Changeset 701 for trunk/phpbms/modules/bms/install/updatev0.9.sql

Timestamp:

01/01/10 14:34:39 (2 years ago)

Author:

nate

Message:

• Removed references to 'deposits' and replaced them with references to 'credits' (in relation to ar items and receipts).
• Made sure that the type field for aritems should be able to take 'credit' but not 'deposit', and the update will change the references from deposit to credit (this time on the database side).
• Fixed bugs with generateuuids.php and with the load open items button on the receipts add-edit.

Files:

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

trunk/phpbms/modules/bms/install/updatev0.9.sql

@@ -124 +124 @@
 UPDATE `invoicestatuses` SET `name`="Shipped", `setreadytopost`=1 WHERE id = 4;
 UPDATE `invoices` SET `readytopost`=1 WHERE `type`="Invoice";
-CREATE TABLE `aritems` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `clientid` int(10) unsigned NOT NULL, `type` ENUM('invoice','deposit','service charge') NOT NULL, `status` ENUM('open','closed') NOT NULL, `itemdate` DATE NOT NULL, `relatedid` int(10) unsigned default NULL, `amount` double NOT NULL default '0', `paid` double NOT NULL default '0', `aged1` tinyint(3) unsigned NOT NULL default '0', `aged2` tinyint(3) unsigned NOT NULL default '0', `aged3` tinyint(3) unsigned NOT NULL default '0', `title` varchar(255) default NULL, `posted` tinyint(3) unsigned NOT NULL default '0', `createdby` int(10) unsigned NOT NULL, `creationdate` datetime NOT NULL, `modifiedby` int(10) unsigned default NULL, `modifieddate` timestamp NOT NULL, PRIMARY KEY  (`id`));
+CREATE TABLE `aritems` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `clientid` int(10) unsigned NOT NULL, `type` ENUM('invoice','credit','service charge') NOT NULL, `status` ENUM('open','closed') NOT NULL, `itemdate` DATE NOT NULL, `relatedid` int(10) unsigned default NULL, `amount` double NOT NULL default '0', `paid` double NOT NULL default '0', `aged1` tinyint(3) unsigned NOT NULL default '0', `aged2` tinyint(3) unsigned NOT NULL default '0', `aged3` tinyint(3) unsigned NOT NULL default '0', `title` varchar(255) default NULL, `posted` tinyint(3) unsigned NOT NULL default '0', `createdby` int(10) unsigned NOT NULL, `creationdate` datetime NOT NULL, `modifiedby` int(10) unsigned default NULL, `modifieddate` timestamp NOT NULL, PRIMARY KEY  (`id`));
 CREATE TABLE `receipts` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `clientid` int(10) unsigned NOT NULL, `amount` double NOT NULL default '0', `receiptdate` date NOT NULL, `status` enum('open','collected') NOT NULL default 'open', `readytopost` tinyint(3) unsigned NOT NULL default '0', `posted` tinyint(3) unsigned NOT NULL default '0', `paymentmethodid` int(10) unsigned NOT NULL default '0', `ccnumber` varchar(64) default NULL, `ccexpiration` varchar(10) default NULL, `ccverification` varchar(4) default NULL, `bankname` varchar(64) default NULL, `checkno` varchar(32) default NULL, `routingnumber` int(10) unsigned default NULL,`accountnumber` int(10) unsigned default NULL, `transactionid` varchar(64) default NULL, `paymentother` varchar(128) default NULL, `memo` text, `createdby` int(11) NOT NULL default '0', `creationdate` datetime NOT NULL default '0000-00-00 00:00:00', `modifiedby` int(10) unsigned default NULL, `modifieddate` timestamp NOT NULL, PRIMARY KEY  (`id`));
 INSERT INTO `settings` (`name`,`value`) VALUES ('term1_days','30');