Changeset 486 for trunk/phpbms/install

Timestamp:

04/07/09 18:12:09 (3 years ago)

Author:

nate

Message:

• Made select fields related to sql statements in the tabledefs, tablefindoptions, and tablesearchablefields tables text areas.

Location:

trunk/phpbms/install

Files:

• createtables.sql (modified) (3 diffs)
• updatev0.98.sql (modified) (2 diffs)

trunk/phpbms/install/createtables.sql

@@ -159 +159 @@
   `viewsqlroleid` int(11) NOT NULL default '-100',
   `deletebutton` varchar(32) default '',
-  `defaultwhereclause` varchar(255) default NULL,
-  `defaultsortorder` varchar(255) default '',
+  `defaultwhereclause` text,
+  `defaultsortorder` text,
   `defaultsearchtype` varchar(64) default '',
   `defaultcriteriafindoptions` varchar(128) default '',
@@ -175 +175 @@
   tabledefid int(11) NOT NULL default '0',
   name varchar(64) NOT NULL default '',
-  search varchar(255) NOT NULL default '',
+  search text NOT NULL,
   displayorder int(11) NOT NULL default '0',
   roleid int(11) NOT NULL default '0',
@@ -198 +198 @@
   id int(11) NOT NULL auto_increment,
   tabledefid int(11) NOT NULL default '0',
-  field varchar(255) NOT NULL default '',
+  field text NOT NULL,
   name varchar(64) NOT NULL default '',
   displayorder int(11) NOT NULL default '0',

trunk/phpbms/install/updatev0.98.sql

@@ -23 +23 @@
 ALTER TABLE `tabledefs` ENGINE=INNODB;
 ALTER TABLE `tabledefs` ADD COLUMN `importfile` VARCHAR(128) DEFAULT NULL AFTER `addroleid`, ADD COLUMN `importroleid` int(11) NOT NULL DEFAULT '-100' AFTER `importfile`;
+ALTER TABLE `tabledefs` MODIFY COLUMN `defaultwhereclause` TEXT DEFAULT NULL, MODIFY COLUMN `defaultsortorder` TEXT;
 ALTER TABLE `tablefindoptions` ENGINE=INNODB;
+ALTER TABLE `tablefindoptions` MODIFY COLUMN `search` TEXT NOT NULL;
 ALTER TABLE `tablegroupings` ENGINE=INNODB;
 ALTER TABLE `tableoptions` ENGINE=INNODB;
@@ -46 +48 @@
 INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('204', 'import', '0', '0', '0', '-100', '0');
 ALTER TABLE `tablesearchablefields` ENGINE=INNODB;
+ALTER TABLE `tablesearchablefields` MODIFY COLUMN `field` TEXT NOT NULL;
 ALTER TABLE `tabs` ENGINE=INNODB;
 ALTER TABLE `users` ENGINE=INNODB;