Changeset 729 for trunk/phpbms/install/updatev0.98.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/updatev0.98.sql (modified) (1 diff)

trunk/phpbms/install/updatev0.98.sql

@@ -324 +324 @@
 --tablecolumns UPDATE--
 UPDATE `tablecolumns` SET `column` = 'IF(`tabs`.`roleid`=\'\' OR `tabs`.`roleid` IS NULL,\'EVERYONE\',IF(`tabs`.`roleid`=\'Admin\',\'Administrators\',`roles`.`name`))' WHERE `column` = 'if(tabs.roleid=0,\'EVERYONE\',if(tabs.roleid=-100,\'Administrators\',roles.name))' AND `tabledefid` = '203';
+UPDATE `tablecolumns` SET `column` = 'concat(\'[b]\', tabledefs.displayname, \'[/b][br][space][space]\', tabledefs.uuid)', `format` = 'bbcode' WHERE `name` = 'display' AND `tabledefid` = 11;
 --end tablecolumns UPDATE--
 --tabledefs INSERT--