Changeset 206 for trunk/phpbms/install/updatev0.7.sql

Timestamp:

03/27/07 11:44:14 (5 years ago)

Author:

brieb

Message:

Fixed install problems with scheduler.
Fixed convert to invoice function.
Expanded logging details for errors.

Files:

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

trunk/phpbms/install/updatev0.7.sql

@@ -66 +66 @@
 INSERT INTO `settings` (`name`, `value`) VALUES ('thousands_separator',',');
 INSERT INTO `settings` (`name`, `value`) VALUES ('demo_enabled','false');
-CREATE TABLE `scheduler` (`id` int(10) unsigned NOT NULL, `name` varchar(45) default NULL, `job` varchar(128) default NULL, `crontab` varchar(64) default NULL, `lastrun` datetime default NULL, `startdatetime` datetime NOT NULL, `enddatetime` datetime default NULL, `description` text, `inactive` tinyint(3) unsigned NOT NULL default '0', `createdby` int(10) unsigned default NULL, `creationdate` datetime default NULL, `modifiedby` int(10) unsigned default NULL, `modifieddate` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY  (`id`), KEY `inactivated` (`inactive`), KEY `startdate` (`startdatetime`), KEY `enddate` (`enddatetime`));
+CREATE TABLE `scheduler` (`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(45) default NULL, `job` varchar(128) default NULL, `crontab` varchar(64) default NULL, `lastrun` datetime default NULL, `startdatetime` datetime NOT NULL, `enddatetime` datetime default NULL, `description` text, `inactive` tinyint(3) unsigned NOT NULL default '0', `createdby` int(10) unsigned default NULL, `creationdate` datetime default NULL, `modifiedby` int(10) unsigned default NULL, `modifieddate` timestamp NOT NULL, PRIMARY KEY  (`id`), KEY `inactivated` (`inactive`), KEY `startdate` (`startdatetime`), KEY `enddate` (`enddatetime`));
 INSERT INTO `tabledefs` (`id`, `displayname`, `type`, `moduleid`, `maintable`, `querytable`, `editfile`, `editroleid`, `addfile`, `addroleid`, `searchroleid`, `advsearchroleid`, `viewsqlroleid`, `deletebutton`, `defaultwhereclause`, `defaultsortorder`, `defaultsearchtype`, `defaultcriteriafindoptions`, `defaultcriteriaselection`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES (201,'Scheduler','system',1,'scheduler','scheduler','modules/base/scheduler_addedit.php',-100,'modules/base/scheduler_addedit.php',-100,-100,-100,-100,'delete','scheduler.id!=0','scheduler.name','','','',1,NOW(),1,NOW());
 INSERT INTO `tablefindoptions` (`tabledefid`, `name`, `search`, `displayorder`, `roleid`) VALUES (201,'all records','scheduler.id!=0',0,0);