CreateTable("pcashdetails", "CREATE TABLE `pcashdetails` (\n `counterindex` int(20) NOT NULL AUTO_INCREMENT,\n `tabcode` varchar(20) NOT NULL,\n `date` date NOT NULL,\n `codeexpense` varchar(20) NOT NULL,\n `amount` double NOT NULL,\n `authorized` date NOT NULL COMMENT 'date cash assigment was revised and authorized by authorizer from tabs table',\n `posted` tinyint(4) NOT NULL COMMENT 'has (or has not) been posted into gltrans',\n `notes` text NOT NULL,\n `receipt` text COMMENT 'filename or path to scanned receipt or code of receipt to find physical receipt if tax guys or auditors show up',\n PRIMARY KEY (`counterindex`)\n)", $db);
CreateTable("pcexpenses", "CREATE TABLE `pcexpenses` (\n `codeexpense` varchar(20) NOT NULL COMMENT 'code for the group',\n `description` varchar(50) NOT NULL COMMENT 'text description, e.g. meals, train tickets, fuel, etc',\n `glaccount` int(11) NOT NULL COMMENT 'GL related account',\n PRIMARY KEY (`codeexpense`),\n KEY (`glaccount`)\n)", $db);
CreateTable("pctabexpenses", "CREATE TABLE `pctabexpenses` (\n `typetabcode` varchar(20) NOT NULL,\n `codeexpense` varchar(20) NOT NULL,\n KEY (`typetabcode`),\n KEY (`codeexpense`)\n)", $db);
CreateTable("pctabs", "CREATE TABLE `pctabs` (\n `tabcode` varchar(20) NOT NULL,\n `usercode` varchar(20) NOT NULL COMMENT 'code of user employee from www_users',\n `typetabcode` varchar(20) NOT NULL,\n `currency` char(3) NOT NULL,\n `tablimit` double NOT NULL,\n `authorizer` varchar(20) NOT NULL COMMENT 'code of user from www_users',\n `glaccountassignment` int(11) NOT NULL COMMENT 'gl account where the money comes from',\n `glaccountpcash` int(11) NOT NULL,\n PRIMARY KEY (`tabcode`),\n KEY (`usercode`),\n KEY (`typetabcode`),\n KEY (`currency`),\n KEY (`authorizer`),\n KEY (`glaccountassignment`)\n)", $db);
CreateTable("pctypetabs", "CREATE TABLE `pctypetabs` (\n `typetabcode` varchar(20) NOT NULL COMMENT 'code for the type of petty cash tab',\n `typetabdescription` varchar(50) NOT NULL COMMENT 'text description, e.g. tab for CEO',\n PRIMARY KEY (`typetabcode`)\n)", $db);
AddConstraint('pcexpenses', 'pcexpenses_ibfk_1', 'glaccount', 'chartmaster', 'accountcode', $db);
AddConstraint('pctabexpenses', 'pctabexpenses_ibfk_1', 'typetabcode', 'pctypetabs', 'typetabcode', $db);
AddConstraint('pctabexpenses', 'pctabexpenses_ibfk_2', 'codeexpense', 'pcexpenses', 'codeexpense', $db);
AddConstraint('pctabs', 'pctabs_ibfk_1', 'usercode', 'www_users', 'userid', $db);
AddConstraint('pctabs', 'pctabs_ibfk_2', 'typetabcode', 'pctypetabs', 'typetabcode', $db);
AddConstraint('pctabs', 'pctabs_ibfk_3', 'currency', 'currencies', 'currabrev', $db);
AddConstraint('pctabs', 'pctabs_ibfk_4', 'authorizer', 'www_users', 'userid', $db);
AddConstraint('pctabs', 'pctabs_ibfk_5', 'glaccountassignment', 'chartmaster', 'accountcode', $db);
DropConstraint('suppliers', 'suppliers_ibfk_4', $db);
UpdateField('suppliers', 'factorcompanyid', 0, '`factorcompanyid`=1', $db);
DeleteRecords('factorcompanies', "coyname='None'", $db);
/* New security token for petty cash usage */
UpdateField('securitytokens', 'tokenname', 'Petty Cash', 'tokenid=6', $db);
/* Add input date to transaction tables so that transactions can be
* reported on by their input date
*/
AddColumn('inputdate', 'supptrans', 'datetime', 'NOT NULL', '0000-00-00', 'duedate', $db);
AddColumn('inputdate', 'debtortrans', 'datetime', 'NOT NULL', '0000-00-00', 'trandate', $db);
/* Change the size of the fieldname field in the report writer as
* the previous size was not big enough to hold all field names
*/
ChangeColumnSize('fieldname', 'reportfields', 'varchar(60)', 'NOT NULL', '', 60, $db);
/* Database changes needed for the picking list functionality
*/
NewConfigValue('RequirePickingNote', 0, $db);
CreateTable("pickinglists", "CREATE TABLE `pickinglists` (\n `pickinglistno` int(11) NOT NULL DEFAULT 0,\n `orderno` int(11) NOT NULL DEFAULT 0,\n `pickinglistdate` date NOT NULL default '0000-00-00',\n `dateprinted` date NOT NULL default '0000-00-00',\n `deliverynotedate` date NOT NULL default '0000-00-00',\n CONSTRAINT `pickinglists_ibfk_1` FOREIGN KEY (`orderno`) REFERENCES `salesorders` (`orderno`),\n PRIMARY KEY (`pickinglistno`)\n)", $db);
<?php
NewConfigValue('ExchangeRateFeed', 'ECB', $db);
AddColumn('salesperson', 'salesorders', 'VARCHAR(4)', 'NOT NULL', '', 'poplaced', $db);
ChangeColumnType('salesmancode', 'salesman', 'VARCHAR(4)', 'NOT NULL', '', $db);
DropColumn('commissionrate', 'salesorderdetails', $db);
DropColumn('commissionearned', 'salesorderdetails', $db);
NewScript('CounterReturns.php', '5', $db);
ChangeColumnType('initiator', 'purchorders', 'VARCHAR(20)', 'NOT NULL', '', $db);
CreateTable('jobcards', "CREATE TABLE `jobcards` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `debtorno` varchar(255) DEFAULT NULL,\n `description` varchar(500) DEFAULT NULL,\n `task1` varchar(500) DEFAULT NULL,\n `task2` varchar(500) DEFAULT NULL,\n `task3` varchar(500) DEFAULT NULL,\n `task4` varchar(500) DEFAULT NULL,\n `task5` varchar(500) DEFAULT NULL,\n `task6` varchar(500) DEFAULT NULL,\n `createdate` date DEFAULT NULL,\n `completedate` date DEFAULT NULL,\n `invoice` varchar(255) DEFAULT NULL,\n PRIMARY KEY (`id`)\n)", $db);
InsertRecord('securitytokens', array('tokenid', 'tokenname'), array('1000', 'User can view and alter sales prices'), array('tokenid', 'tokenname'), array('1000', 'User can view and alter sales prices'), $db);
InsertRecord('securitytokens', array('tokenid', 'tokenname'), array('1001', 'User can bypass purchasing security and go straight from order to invoice'), array('tokenid', 'tokenname'), array('1001', 'User can bypass purchasing security and go straight from order to invoice'), $db);
UpdateField('securitytokens', 'tokenname', 'Unknown', 'tokenid=12', $db);
AddColumn('fontsize', 'www_users', 'TINYINT(2)', 'NOT NULL', '0', 'department', $db);
NewScript('CustomerPurchases.php', '5', $db);
NewScript('GoodsReceivedButNotInvoiced.php', '15', $db);
NewScript('ItemsWithoutPicture.php', '15', $db);
UpdateField('scripts', 'pagesecurity', '2', "script='GoodsReceivedButNotInvoiced.php'", $db);
DeleteRecords('scripts', "script='Z_ItemsWithoutPicture.php'", $db);
UpdateField('scripts', 'script', 'Z_ItemsWithoutPicture.php', "script='ItemsWithoutPicture.php'", $db);
ChangeColumnType('description', 'taxauthorities', 'VARCHAR(40)', 'NOT NULL', '', $db);
NewScript('MaterialsNotUsed.php', '4', $db);
ChangeConfigValue('VersionNumber', '4.10', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
