Added multiply selection support in array_selector.

[fa-stable.git] / sql / alter2.2.sql

diff --git a/sql/alter2.2.sql b/sql/alter2.2.sql
index 6fd520b874a6ffc584ae2d22f6242173a102f301..441c9ba65855d108c004c2ff33c950b8c4e4ce74 100644 (file)
--- a/sql/alter2.2.sql
+++ b/sql/alter2.2.sql
@@ -114,7 +114,9 @@ DROP TABLE IF EXISTS `0_tags`;
 CREATE TABLE `0_tags` (
   `id` int(11) NOT NULL auto_increment,
   `type` smallint(6) NOT NULL,
-  `name` varchar(60) NOT NULL,
+  `name` varchar(30) NOT NULL,
+  `description` varchar(60) default NULL,
+  `inactive` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`id`),
   UNIQUE KEY(`type`,`name`)
 ) TYPE=MyISAM AUTO_INCREMENT=1;
@@ -128,3 +130,9 @@ CREATE TABLE `0_tag_associations` (
   PRIMARY KEY  (`id`)
 ) TYPE=MyISAM AUTO_INCREMENT=1;
 
+ALTER TABLE `0_suppliers` ADD COLUMN `phone2` varchar(30) NOT NULL default '' AFTER `phone`;
+ALTER TABLE `0_cust_branch` ADD COLUMN `phone2` varchar(30) NOT NULL default '' AFTER `phone`;
+ALTER TABLE `0_shippers` ADD COLUMN `phone2` varchar(30) NOT NULL default '' AFTER `phone`;
+ALTER TABLE `0_locations` ADD COLUMN `phone2` varchar(30) NOT NULL default '' AFTER `phone`;
+ALTER TABLE `0_debtors_master` ADD COLUMN `notes` tinytext NULL default '' AFTER `credit_limit`;
+ALTER TABLE `0_cust_branch` ADD COLUMN `notes` tinytext NULL default '' AFTER `group_no`;