Changeset 771 for trunk/phpbms/install

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

Location:

trunk/phpbms/install

Files:

• createtables.sql (modified) (1 diff)
• update-nextver.sql (modified) (1 diff)

trunk/phpbms/install/createtables.sql

@@ -128 +128 @@
   `reportuuid` varchar(64) NOT NULL,
   `name` varchar(64) NOT NULL default '',
-  `value` text default '',
+  `value` text,
   `type` varchar(32) NOT NULL default 'string',
   `required` tinyint(4) NOT NULL default '0',

trunk/phpbms/install/update-nextver.sql

@@ -1 @@
-UPDATE settings SET `name` = 'currency_sym' WHERE `name` = 'currency_symbol';
+