Changeset 540 for trunk/phpbms/install

Timestamp:

05/28/09 11:55:38 (3 years ago)

Author:

brieb

Message:

• Added UUID prefix to table definitions in preparation for system-wide UUID conversion.

Location:

trunk/phpbms/install

Files:

• createtables.sql (modified) (1 diff)
• updatev0.98.sql (modified) (1 diff)

trunk/phpbms/install/createtables.sql

@@ -155 +155 @@
   `id` int(11) NOT NULL auto_increment,
   `displayname` varchar(64) default NULL,
+  `prefix` varchar(4) default NULL,
   `type` varchar(16) NOT NULL default 'table',
   `moduleid` int(11) NOT NULL default '0',

trunk/phpbms/install/updatev0.98.sql

@@ -129 +129 @@
 UPDATE `reports` SET `uuid`='reports:2944b204-5967-348a-8679-6835f45f0d79' WHERE `name`='SQL Export';
 UPDATE `reports` SET `uuid`='reports:37a299d1-d795-ad83-4b47-0778c16a381c' WHERE `name`='Support Tables SQL Export';
+-- Adding UUID prefix
+ALTER TABLE `tabledefs` ADD COLUMN `prefix` VARCHAR(4) AFTER `displayname`;
+-- Setting BASE UUID prefix for needed records
+UPDATE `tabledefs` SET `prefix` = 'usr' WHERE id = 9;
+UPDATE `tabledefs` SET `prefix` = 'tab' WHERE id = 203;
+UPDATE `tabledefs` SET `prefix` = 'tbld' WHERE id = 11;
+UPDATE `tabledefs` SET `prefix` = 'smsr' WHERE id = 204;
+UPDATE `tabledefs` SET `prefix` = 'schd' WHERE id = 201;
+UPDATE `tabledefs` SET `prefix` = 'role' WHERE id = 200;
+UPDATE `tabledefs` SET `prefix` = 'rpt' WHERE id = 16;
+UPDATE `tabledefs` SET `prefix` = 'rln' WHERE id = 10;
+UPDATE `tabledefs` SET `prefix` = 'note' WHERE id = 12;
+UPDATE `tabledefs` SET `prefix` = 'wdgt' WHERE id = 205;
+UPDATE `tabledefs` SET `prefix` = 'mod' WHERE id = 21;
+UPDATE `tabledefs` SET `prefix` = 'file' WHERE id = 26;
+UPDATE `tabledefs` SET `prefix` = 'menu' WHERE id = 19;