Changeset 543 for trunk/phpbms/install

Timestamp:

05/28/09 17:05:55 (3 years ago)

Author:

brieb

Message:

• Removed id display from many add/edits as the bottom are now displays both uuid and id.
• Removed comment markers from offending lines in BMS update.

Files:

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

trunk/phpbms/install/updatev0.98.sql

@@ -171 +171 @@
 UPDATE `tabledefs` SET `hascustomfields` = 1 WHERE `id` IN(12, 9, 26, 200);
 
+--create tablecustomfields--
+CREATE TABLE tablecustomfields (
+  `id` int(11) NOT NULL auto_increment,
+  `tabledefid` int(11) NOT NULL default 0,
+  `name` varchar(128) NOT NULL default '',
+  `field` varchar(8) NOT NULL default '',
+  `format` varchar(32),
+  `generator` TEXT,
+  `required` TINYINT(4) NOT NULL default 0,
+  `displayorder` int(11) NOT NULL default 0,
+  `roleid` int(11) NOT NULL default 0,
+  PRIMARY KEY  (`id`),
+  KEY `tabledef` (`tabledefid`)
+) ENGINE=INNODB;
+
 --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());