Changeset 701 for trunk/phpbms/modules/bms/install/updatev0.98.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.98.sql (modified) (1 diff)

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

@@ -39 +39 @@
     ADD COLUMN `uuid` VARCHAR(64) NOT NULL,
     MODIFY `clientid` VARCHAR(64) NOT NULL,
-    MODIFY `relatedid` VARCHAR(64);
+    MODIFY `relatedid` VARCHAR(64),
+    MODIFY `type` ENUM('invoice','credit','service charge', 'deposit') NOT NULL;
+UPDATE `aritems` SET `type`='credit' WHERE `type`='deposit';
+ALTER TABLE `aritems`
+    MODIFY `type` ENUM('invoice','credit','service charge') NOT NULL;
 --end aritems ALTER--
 --attachements ALTER--