Changeset 729 for trunk/phpbms/install/tablecolumns.sql

Timestamp:

01/07/10 16:01:56 (2 years ago)

Author:

brieb

Message:

• code clean up
• changed list display of table definitions

Files:

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

trunk/phpbms/install/tablecolumns.sql

@@ -23 +23 @@
 INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('tbld:5c9d645f-26ab-5003-b98e-89e9049f8ac3', 'id', 'tabledefs.id', 'center', '', '0', '', '0', '', NULL, '');
 INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('tbld:5c9d645f-26ab-5003-b98e-89e9049f8ac3', 'main table', 'tabledefs.maintable', 'left', '', '3', '', '0', '', NULL, '');
-INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('tbld:5c9d645f-26ab-5003-b98e-89e9049f8ac3', 'display', 'tabledefs.displayname', 'left', '', '1', '', '0', '100%', NULL, '');
+INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('tbld:5c9d645f-26ab-5003-b98e-89e9049f8ac3', 'display', 'concat(\'[b]\', tabledefs.displayname, \'[/b][br][space][space]\', tabledefs.uuid)', 'left', '', '1', '', '0', '100%', 'bbcode', '');
 INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('tbld:5c9d645f-26ab-5003-b98e-89e9049f8ac3', 'type', 'tabledefs.type', 'center', '', '2', '', '0', '', NULL, '');
 INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('tbld:7e75af48-6f70-d157-f440-69a8e7f59d38', 'name', 'tabs.name', 'left', '', '1', '', '0', '', NULL, '');