Changeset 771 for trunk/phpbms/modules/bms/install/createtables.sql

Timestamp:

01/27/10 10:18:24 (2 years ago)

Author:

brieb

Message:

• fixed installtion issue with creating table with field type text and default value
• changed paymentmethods type to varchar instead of enum

Files:

• trunk/phpbms/modules/bms/install/createtables.sql (modified) (1 diff)

trunk/phpbms/modules/bms/install/createtables.sql

@@ -325 +325 @@
   `uuid` varchar(64) NOT NULL,
   `name` varchar(128) NOT NULL default '',
-  `type` enum('draft','charge','receivable') default NULL,
+  `type` varchar(32) default NULL,
   `priority` int(8) NOT NULL default '0',
   `inactive` tinyint(1) NOT NULL default '0',