Changeset 485 for trunk/phpbms/install/updatev0.98.sql
- Timestamp:
- 04/07/09 11:44:18 (3 years ago)
- Files:
-
- 1 modified
-
trunk/phpbms/install/updatev0.98.sql (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/phpbms/install/updatev0.98.sql
r427 r485 4 4 ALTER TABLE `log` ENGINE=INNODB; 5 5 ALTER TABLE `menu` ENGINE=INNODB; 6 UPDATE `menu` SET `name` = 'Tools' WHERE `id` = '1' AND `name` = 'Organizer'; 6 7 ALTER TABLE `modules` ENGINE=INNODB; 7 8 ALTER TABLE `notes` ENGINE=INNODB; 9 ALTER TABLE `notes` MODIFY COLUMN `type` CHAR(2) NOT NULL DEFAULT 'NT'; 8 10 ALTER TABLE `relationships` ENGINE=INNODB; 9 11 ALTER TABLE `reports` ENGINE=INNODB; 12 ALTER TABLE `reports` MODIFY COLUMN `reportfile` VARCHAR(128) NOT NULL; 13 UPDATE `reports` SET `description` = 'This report will generate a comma-delimited text file. Values are encapsulated in quotes, and the first line lists the field names.' WHERE `name` = 'Raw Table Export'; 10 14 ALTER TABLE `roles` ENGINE=INNODB; 15 ALTER TABLE `roles` MODIFY COLUMN `inactive` TINYINT(4) NOT NULL DEFAULT 0; 11 16 ALTER TABLE `rolestousers` ENGINE=INNODB; 12 17 ALTER TABLE `scheduler` ENGINE=INNODB; 18 INSERT INTO `scheduler` (`name`, `job`, `crontab`, `lastrun`, `startdatetime`, `enddatetime`, `description`, `inactive`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('Clean Import Files', './scheduler_delete_tempimport.php', '30::*::*::*::*', NULL, NOW(), 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()); 19 INSERT INTO `scheduler` (`id`, `name`, `job`, `crontab`, `lastrun`, `startdatetime`, `enddatetime`, `description`, `inactive`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('4', 'Remove Excess System Log Records', './scheduler_delete_logs.php', '*::24::*::*::*', NULL, '2009-03-31 12:00:00', NULL, 'This script will trim the system log when there are more than 2000 records present at the time of its calling (default will be every 24 hours).', '0', 1, NOW(), 1, NOW()); 13 20 ALTER TABLE `settings` ENGINE=INNODB; 14 21 ALTER TABLE `smartsearches` ENGINE=INNODB; 15 22 ALTER TABLE `tablecolumns` ENGINE=INNODB; 16 23 ALTER TABLE `tabledefs` ENGINE=INNODB; 24 ALTER TABLE `tabledefs` ADD COLUMN `importfile` VARCHAR(128) DEFAULT NULL AFTER `addroleid`, ADD COLUMN `importroleid` int(11) NOT NULL DEFAULT '-100' AFTER `importfile`; 17 25 ALTER TABLE `tablefindoptions` ENGINE=INNODB; 18 26 ALTER TABLE `tablegroupings` ENGINE=INNODB; 19 27 ALTER TABLE `tableoptions` ENGINE=INNODB; 20 ALTER TABLE `tablesearchablefields` ENGINE=INNODB;21 ALTER TABLE `tabs` ENGINE=INNODB;22 ALTER TABLE `users` ENGINE=INNODB;23 ALTER TABLE `usersearches` ENGINE=INNODB;24 INSERT INTO `scheduler` (`name`, `job`, `crontab`, `lastrun`, `startdatetime`, `enddatetime`, `description`, `inactive`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('clean import files', '/scheduler_delete_tempimport.php', '30::*::*::*::*', NULL, NOW(), 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());25 ALTER TABLE `tabledefs` ADD COLUMN `importfile` VARCHAR(128) DEFAULT NULL AFTER `addroleid`, ADD COLUMN `importroleid` int(11) NOT NULL DEFAULT '-100' AFTER `importfile`;26 UPDATE `tabledefs` SET `importfile`='modules/base/users_import.php' WHERE `id` = 9;27 28 ALTER TABLE `tableoptions` ADD COLUMN `needselect` BOOLEAN NOT NULL DEFAULT 1 AFTER `option`; 28 29 UPDATE `tableoptions` SET `needselect` = 0 WHERE `name` IN('massEmail','new','printex','select') AND `tabledefid` IN (9,10,11,12,16,17,19,21,23,24,26,27,200,201,202,203,204); … … 30 31 INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('10', 'import', '0', '0', '0', '-100', '0'); 31 32 INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('11', 'import', '0', '0', '0', '-100', '0'); 32 INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('12', 'import', ' 0', '0', '0', '-100', '0');33 INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('12', 'import', '1', '0', '0', '-100', '0'); 33 34 INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('16', 'import', '0', '0', '0', '-100', '0'); 34 35 INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('17', 'import', '1', '0', '0', '-100', '0'); … … 44 45 INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('203', 'import', '0', '0', '0', '-100', '0'); 45 46 INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('204', 'import', '0', '0', '0', '-100', '0'); 46 UPDATE `reports` SET `description` = 'This report will generate a comma-delimited text file. Values are encapsulated in quotes, and the first line lists the field names.' WHERE `name` = 'Raw Table Export'; 47 ALTER TABLE `tablesearchablefields` ENGINE=INNODB; 48 ALTER TABLE `tabs` ENGINE=INNODB; 49 ALTER TABLE `users` ENGINE=INNODB; 50 ALTER TABLE `users` ADD COLUMN `lastip` VARCHAR(45) NOT NULL DEFAULT '' AFTER `lastname`; 51 ALTER TABLE `usersearches` ENGINE=INNODB;
