Changeset 771

Timestamp:

01/27/10 10:18:24 (6 months 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

Files:

• install/createtables.sql (modified) (1 diff)
• install/update-nextver.sql (modified) (1 diff)
• modules/bms/install/createtables.sql (modified) (1 diff)
• modules/bms/install/update-nextver.sql (added)
• modules/recurringinvoices/scheduler_recurr.php (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';
+

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',

trunk/phpbms/modules/recurringinvoices/scheduler_recurr.php

@@ -405 +405 @@
                         $headers = "From: ".$to;
 
-                        @ mail ($to,$subject,$message,$headers);
+                        @ mail($to,$subject,$message,$headers);
                 }// endwhile