Changeset 546 for trunk/phpbms/install

Timestamp:

05/29/09 12:03:28 (3 years ago)

Author:

nate

Message:

• Made tabs use uuids instead of ids, when they are called on pages (e.g. add_edit pages).
• Gave module records uuids in the install and updates for each module.
• Removed ids from install / updates for tabs.

Location:

trunk/phpbms/install

Files:

• modules.sql (modified) (1 diff)
• tabs.sql (modified) (1 diff)
• updatev0.98.sql (modified) (2 diffs)

trunk/phpbms/install/modules.sql

@@ -1 @@
-INSERT INTO modules VALUES (1,'Base','base','The basic phpBMS framkework.  This is the minimum module required in order for the web applicatoin to work.','0.98');
+INSERT INTO modules (`id`, `uuid`, `displayname`, `name`, `description`, `version`) VALUES (1, 'mod:29873ee8-c12a-e3f6-9010-4cd24174ffd7', 'Base','base','The basic phpBMS framkework.  This is the minimum module required in order for the web applicatoin to work.','0.98');

trunk/phpbms/install/tabs.sql

@@ -1 @@
-INSERT INTO `tabs` (`id`, `uuid`, `name`, `tabgroup`, `location`, `displayorder`, `enableonnew`, `roleid`, `tooltip`, `notificationsql`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('1',   'tab:fdf064e0-f2d9-6c67-b64f-449e72e859b9', 'general', 'tabledefs entry', 'modules/base/tabledefs_addedit.php', '10', '1', '-100', '', '', 1, NOW(), 1, NOW());
-INSERT INTO `tabs` (`id`, `uuid`, `name`, `tabgroup`, `location`, `displayorder`, `enableonnew`, `roleid`, `tooltip`, `notificationsql`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('2',   'tab:b1011143-1d47-520e-5879-3953a4f5055b', 'columns', 'tabledefs entry', 'modules/base/tabledefs_columns.php', '20', '0', '-100', '', NULL, 1, NOW(), 1, NOW());
-INSERT INTO `tabs` (`id`, `uuid`, `name`, `tabgroup`, `location`, `displayorder`, `enableonnew`, `roleid`, `tooltip`, `notificationsql`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('3',   'tab:c5bdaf10-062c-fb3a-f40f-ddce821fd579', 'options', 'tabledefs entry', 'modules/base/tabledefs_options.php', '30', '0', '-100', '', NULL, 1, NOW(), 1, NOW());
-INSERT INTO `tabs` (`id`, `uuid`, `name`, `tabgroup`, `location`, `displayorder`, `enableonnew`, `roleid`, `tooltip`, `notificationsql`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('4',   'tab:276dacd4-4a37-d979-aeda-a7982f632559', 'quick search', 'tabledefs entry', 'modules/base/tabledefs_quicksearch.php', '40', '0', '-100', '', NULL, 1, NOW(), 1, NOW());
-INSERT INTO `tabs` (`id`, `uuid`, `name`, `tabgroup`, `location`, `displayorder`, `enableonnew`, `roleid`, `tooltip`, `notificationsql`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('5',   'tab:22d08e82-5047-4150-6de7-49e89149f56b', 'search fields', 'tabledefs entry', 'modules/base/tabledefs_searchfields.php', '50', '0', '-100', '', NULL, 1, NOW(), 1, NOW());
-INSERT INTO `tabs` (`id`, `uuid`, `name`, `tabgroup`, `location`, `displayorder`, `enableonnew`, `roleid`, `tooltip`, `notificationsql`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('100', 'tab:c111eaf5-692b-9c7d-1d46-1bacb6703361', 'groupings', 'tabledefs entry', 'modules/base/tabledefs_groupings.php', '25', '0', '-100', '', NULL, 1, NOW(), 1, NOW());
-INSERT INTO `tabs` (`id`, `uuid`, `name`, `tabgroup`, `location`, `displayorder`, `enableonnew`, `roleid`, `tooltip`, `notificationsql`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('101', 'tab:2ebf956d-5e39-c7d5-16b7-501b64685a5a', 'custom fields', 'tabledefs entry', 'modules/base/tabledefs_custom.php', '60', '0', '-100', NULL, NULL, 1, NOW(), 1, NOW());
+INSERT INTO `tabs` (`uuid`, `name`, `tabgroup`, `location`, `displayorder`, `enableonnew`, `roleid`, `tooltip`, `notificationsql`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('tab:fdf064e0-f2d9-6c67-b64f-449e72e859b9', 'general', 'tabledefs entry', 'modules/base/tabledefs_addedit.php', '10', '1', '-100', '', '', 1, NOW(), 1, NOW());
+INSERT INTO `tabs` (`uuid`, `name`, `tabgroup`, `location`, `displayorder`, `enableonnew`, `roleid`, `tooltip`, `notificationsql`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('tab:b1011143-1d47-520e-5879-3953a4f5055b', 'columns', 'tabledefs entry', 'modules/base/tabledefs_columns.php', '20', '0', '-100', '', NULL, 1, NOW(), 1, NOW());
+INSERT INTO `tabs` (`uuid`, `name`, `tabgroup`, `location`, `displayorder`, `enableonnew`, `roleid`, `tooltip`, `notificationsql`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('tab:c5bdaf10-062c-fb3a-f40f-ddce821fd579', 'options', 'tabledefs entry', 'modules/base/tabledefs_options.php', '30', '0', '-100', '', NULL, 1, NOW(), 1, NOW());
+INSERT INTO `tabs` (`uuid`, `name`, `tabgroup`, `location`, `displayorder`, `enableonnew`, `roleid`, `tooltip`, `notificationsql`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('tab:276dacd4-4a37-d979-aeda-a7982f632559', 'quick search', 'tabledefs entry', 'modules/base/tabledefs_quicksearch.php', '40', '0', '-100', '', NULL, 1, NOW(), 1, NOW());
+INSERT INTO `tabs` (`uuid`, `name`, `tabgroup`, `location`, `displayorder`, `enableonnew`, `roleid`, `tooltip`, `notificationsql`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('tab:22d08e82-5047-4150-6de7-49e89149f56b', 'search fields', 'tabledefs entry', 'modules/base/tabledefs_searchfields.php', '50', '0', '-100', '', NULL, 1, NOW(), 1, NOW());
+INSERT INTO `tabs` (`uuid`, `name`, `tabgroup`, `location`, `displayorder`, `enableonnew`, `roleid`, `tooltip`, `notificationsql`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('tab:c111eaf5-692b-9c7d-1d46-1bacb6703361', 'groupings', 'tabledefs entry', 'modules/base/tabledefs_groupings.php', '25', '0', '-100', '', NULL, 1, NOW(), 1, NOW());
+INSERT INTO `tabs` (`uuid`, `name`, `tabgroup`, `location`, `displayorder`, `enableonnew`, `roleid`, `tooltip`, `notificationsql`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('tab:2ebf956d-5e39-c7d5-16b7-501b64685a5a', 'custom fields', 'tabledefs entry', 'modules/base/tabledefs_custom.php', '60', '0', '-100', NULL, NULL, 1, NOW(), 1, NOW());

trunk/phpbms/install/updatev0.98.sql

@@ -26 +26 @@
 ALTER TABLE `scheduler` ENGINE=INNODB;
 ALTER TABLE `scheduler` ADD COLUMN `uuid` varchar(64) NOT NULL AFTER `id`;
+--module update--
+UPDATE `modules` SET `uuid`='mod:29873ee8-c12a-e3f6-9010-4cd24174ffd7' WHERE `id`='1';
+--end module update--
 --scheduler--
 INSERT INTO `scheduler` (`uuid`, `name`, `job`, `crontab`, `lastrun`, `startdatetime`, `enddatetime`, `description`, `inactive`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('schd:fb52e7fb-bb49-7f5f-89e1-002b2785f085', 'Clean Import Files', './scheduler_delete_tempimport.php', '30::*::*::*::*', '2009-05-28 12:30:02', '2009-05-07 17:27:13', NULL, 'This will delete any temporary import files that are present (for whatever reason) after 30 minutes of their creation.', '0', 1, NOW(), 1, NOW());
@@ -187 +190 @@
 
 --tabs insert/update--
-INSERT INTO `tabs` (`id`, `uuid`, `name`, `tabgroup`, `location`, `displayorder`, `enableonnew`, `roleid`, `tooltip`, `notificationsql`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('101', 'tab:2ebf956d-5e39-c7d5-16b7-501b64685a5a', 'custom fields', 'tabledefs entry', 'modules/base/tabledefs_custom.php', '60', '0', '-100', NULL, NULL, 1, NOW(), 1, NOW());
+INSERT INTO `tabs` (`uuid`, `name`, `tabgroup`, `location`, `displayorder`, `enableonnew`, `roleid`, `tooltip`, `notificationsql`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('tab:2ebf956d-5e39-c7d5-16b7-501b64685a5a', 'custom fields', 'tabledefs entry', 'modules/base/tabledefs_custom.php', '60', '0', '-100', NULL, NULL, 1, NOW(), 1, NOW());
 UPDATE `tabs` SET `uuid`='tab:fdf064e0-f2d9-6c67-b64f-449e72e859b9' WHERE `id`='1';
 UPDATE `tabs` SET `uuid`='tab:b1011143-1d47-520e-5879-3953a4f5055b' WHERE `id`='2';