Changeset 650 for trunk/phpbms/modules

Timestamp:

10/08/09 13:35:27 (3 years ago)

Author:

nate

Message:

• Fix sql in system update concerning products and productcategories ( gave productcategories' tabledef a specific uuid and a prefix ).

Files:

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

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

@@ -493 +493 @@
     `id`='6';
 UPDATE `tabledefs` SET
+    `uuid` = 'tbld:3342a3d4-c6a2-3a38-6576-419299859561',
+    `prefix` = 'pcat'
+WHERE
+    `id`='7';
+UPDATE `tabledefs` SET
     `uuid`='tbld:8179e105-5487-5173-d835-d9d510cc7f1b',
     `querytable` = '(prerequisites LEFT JOIN `products` ON prerequisites.parentid=products.uuid) LEFT JOiN products AS childproducts on prerequisites.childid=childproducts.uuid'