<?php
ChangeColumnType('area', 'custbranch', 'CHAR(3)', 'NOT NULL', '', $db);
AddColumn('specialinstructions', 'custbranch', 'TEXT', 'NOT NULL', '', 'brpostaddr6', $db);
AddColumn('parentgroupname', 'accountgroups', 'VARCHAR(30)', 'NOT NULL', '', 'sequenceintb', $db);
DropTable('worksorders', 'accumvalueissued', $db);
CreateTable('workorders', "CREATE TABLE `workorders` (\n wo int(11) NOT NULL,\n loccode char(5) NOT NULL default '',\n requiredby date NOT NULL default '0000-00-00',\n startdate date NOT NULL default '0000-00-00',\n costissued double NOT NULL default '0',\n closed tinyint(4) NOT NULL default '0',\n PRIMARY KEY (`wo`),\n KEY LocCode (`loccode`),\n KEY StartDate (`startdate`),\n KEY RequiredBy (`requiredby`)\n)", $db);
AddConstraint('workorders', 'workorders_ibfk_1', 'loccode', 'locations', 'loccode', $db);
CreateTable('woitems', "CREATE TABLE `woitems` (\n wo int(11) NOT NULL,\n stockid char(20) NOT NULL default '',\n qtyreqd double NOT NULL DEFAULT 1,\n qtyrecd double NOT NULL DEFAULT 0,\n stdcost double NOT NULL,\n nextlotsnref varchar(20) DEFAULT '',\n PRIMARY KEY (`wo`, `stockid`),\n KEY `stockid` (`stockid`)\n)", $db);
AddConstraint('woitems', 'woitems_ibfk_1', 'stockid', 'stockmaster', 'stockid', $db);
AddConstraint('woitems', 'woitems_ibfk_2', 'wo', 'workorders', 'wo', $db);
CreateTable('worequirements', "CREATE TABLE `worequirements` (\n wo int(11) NOT NULL,\n parentstockid varchar(20) NOT NULL,\n stockid varchar(20) NOT NULL,\n qtypu double NOT NULL DEFAULT 1,\n stdcost double NOT NULL DEFAULT 0,\n autoissue tinyint NOT NULL DEFAULT 0,\n PRIMARY KEY (`wo`, `parentstockid`,`stockid`)\n)", $db);
AddConstraint('worequirements', 'worequirements_ibfk_1', 'wo', 'workorders', 'wo', $db);
AddConstraint('worequirements', 'worequirements_ibfk_2', 'stockid', 'stockmaster', 'stockid', $db);
AddConstraint('worequirements', 'worequirements_ibfk_3', 'parentstockid', 'woitems', 'stockid', $db);
AddColumn('autoissue', 'bom', 'TINYINT', 'NOT NULL', '0', 'quantity', $db);
NewConfigValue('AutoIssue', '1', $db);
DropIndex('stockmoves', 'StockID', $db);
AddIndex(array('reference'), 'stockmoves', 'stockmoves', $db);
DropPrimaryKey('recurrsalesorderdetails', array('recurrorderno', 'stkcode'), $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
ChangeColumnType('language', 'www_users', 'VARCHAR(10)', 'NOT NULL', 'en_GB.utf8', $db);
DropTable('buckets', 'availdate', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
AddColumn('chequeno', 'banktrans', 'INT(11)', 'NOT NULL', 0, 'ref', $db);
ChangeColumnType('chequeno', 'banktrans', 'VARCHAR(20)', 'NOT NULL', '', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
ChangeColumnType('salescatname', 'salescat', 'VARCHAR(50)', 'NOT NULL', '', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
AddColumn('revised', 'purchorders', 'DATE', 'NOT NULL', "0000-00-00", 'version', $db);
AddColumn('realorderno', 'purchorders', 'VARCHAR(16)', 'NOT NULL', '', 'revised', $db);
AddColumn('deliveryby', 'purchorders', 'VARCHAR(100)', 'NOT NULL', '', 'realorderno', $db);
AddColumn('deliverydate', 'purchorders', 'DATE', 'NOT NULL', "0000-00-00", 'deliveryby', $db);
AddColumn('status', 'purchorders', 'VARCHAR(12)', 'NOT NULL', '', 'deliverydate', $db);
AddColumn('stat_comment', 'purchorders', 'TEXT', 'NOT NULL', '', 'status', $db);
AddColumn('itemno', 'purchorderdetails', 'VARCHAR(50)', 'NOT NULL', '', 'itemcode', $db);
AddColumn('uom', 'purchorderdetails', 'VARCHAR(50)', 'NOT NULL', '', 'itemno', $db);
AddColumn('subtotal_amount', 'purchorderdetails', 'VARCHAR(50)', 'NOT NULL', '', 'uom', $db);
AddColumn('package', 'purchorderdetails', 'VARCHAR(50)', 'NOT NULL', '', 'subtotal_amount', $db);
AddColumn('pcunit', 'purchorderdetails', 'VARCHAR(50)', 'NOT NULL', '', 'package', $db);
AddColumn('nw', 'purchorderdetails', 'VARCHAR(50)', 'NOT NULL', '', 'pcunit', $db);
AddColumn('suppliers_partno', 'purchorderdetails', 'VARCHAR(50)', 'NOT NULL', '', 'nw', $db);
AddColumn('gw', 'purchorderdetails', 'VARCHAR(50)', 'NOT NULL', '', 'suppliers_partno', $db);
AddColumn('cuft', 'purchorderdetails', 'VARCHAR(50)', 'NOT NULL', '', 'gw', $db);
AddColumn('total_quantity', 'purchorderdetails', 'VARCHAR(50)', 'NOT NULL', '', 'cuft', $db);
AddColumn('total_amount', 'purchorderdetails', 'VARCHAR(50)', 'NOT NULL', '', 'total_quantity', $db);
AddColumn('phn', 'suppliers', 'VARCHAR(50)', 'NOT NULL', '', 'taxref', $db);
AddColumn('port', 'suppliers', 'VARCHAR(50)', 'NOT NULL', '', 'phn', $db);
AddColumn('netweight', 'stockmaster', 'DECIMAL(20,4)', 'NOT NULL', "0.0", 'nextserialno', $db);
AddColumn('suppliers_partno', 'purchdata', 'VARCHAR(50)', 'NOT NULL', '', 'effectivefrom', $db);
ChangeColumnType('note', 'custnotes', 'TEXT', 'NOT NULL', '', $db);
AddColumn('bankaccountcode', 'bankaccounts', 'VARCHAR(50)', 'NOT NULL', '', 'currcode', $db);
AddColumn('invoice', 'bankaccounts', 'SMALLINT(2)', 'NOT NULL', "0", 'bankaccountcode', $db);
AddColumn('salesman', 'www_users', 'CHAR( 3 )', 'NOT NULL', '', 'customerid', $db);
ChangeColumnType('shipvia', 'debtortrans', 'INT(11)', 'NOT NULL', '0', $db);
CreateTable('audittrail', "CREATE TABLE IF NOT EXISTS `audittrail` (\n `transactiondate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\n `userid` varchar(20) NOT NULL DEFAULT '',\n `querystring` text,\n KEY `UserID` (`userid`)\n)", $db);
AddConstraint('audittrail', 'audittrail_ibfk_1', 'userid', 'www_users', 'userid', $db);
CreateTable('deliverynotes', "CREATE TABLE IF NOT EXISTS `deliverynotes` (\n `deliverynotenumber` int(11) NOT NULL,\n `deliverynotelineno` tinyint(4) NOT NULL,\n `salesorderno` int(11) NOT NULL,\n `salesorderlineno` int(11) NOT NULL,\n `qtydelivered` double NOT NULL DEFAULT '0',\n `printed` tinyint(4) NOT NULL DEFAULT '0',\n `invoiced` tinyint(4) NOT NULL DEFAULT '0',\n `deliverydate` date NOT NULL DEFAULT '0000-00-00',\n PRIMARY KEY (`deliverynotenumber`,`deliverynotelineno`)\n)", $db);
AddConstraint('deliverynotes', 'deliverynotes_ibfk_1', array('salesorderno', 'salesorderlineno'), 'salesorderdetails', array('orderno', 'orderlineno'), $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
/* Change the shipment quantity to a double from integer,
* as stock quantities can be of type double
*/
ChangeColumnType('shipqty', 'loctransfers', 'double', 'NOT NULL', 0.0, $db);
UpdateDBNo(33, $db);
<?php
ChangeColumnType('debtorsact', 'companies', 'VARCHAR(20)', 'NOT NULL', '70000', $db);
ChangeColumnType('pytdiscountact', 'companies', 'VARCHAR(20)', 'NOT NULL', '55000', $db);
ChangeColumnType('creditorsact', 'companies', 'VARCHAR(20)', 'NOT NULL', '80000', $db);
ChangeColumnType('payrollact', 'companies', 'VARCHAR(20)', 'NOT NULL', '84000', $db);
ChangeColumnType('grnact', 'companies', 'VARCHAR(20)', 'NOT NULL', '72000', $db);
ChangeColumnType('exchangediffact', 'companies', 'VARCHAR(20)', 'NOT NULL', '65000', $db);
ChangeColumnType('purchasesexchangediffact', 'companies', 'VARCHAR(20)', 'NOT NULL', '0', $db);
ChangeColumnType('retainedearnings', 'companies', 'VARCHAR(20)', 'NOT NULL', '90000', $db);
ChangeColumnType('freightact', 'companies', 'VARCHAR(20)', 'NOT NULL', '0', $db);
ChangeColumnType('stockact', 'lastcostrollup', 'VARCHAR(20)', 'NOT NULL', '0', $db);
ChangeColumnType('adjglact', 'lastcostrollup', 'VARCHAR(20)', 'NOT NULL', '0', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
ChangeColumnType('discountglcode', 'salesglpostings', 'VARCHAR(20)', 'NOT NULL', '0', $db);
ChangeColumnType('salesglcode', 'salesglpostings', 'VARCHAR(20)', 'NOT NULL', '0', $db);
ChangeColumnType('glcode', 'cogsglpostings', 'VARCHAR(20)', 'NOT NULL', '0', $db);
ChangeColumnType('costact', 'fixedassetcategories', 'VARCHAR(20)', 'NOT NULL', '0', $db);
ChangeColumnType('depnact', 'fixedassetcategories', 'VARCHAR(20)', 'NOT NULL', '0', $db);
ChangeColumnType('disposalact', 'fixedassetcategories', 'VARCHAR(20)', 'NOT NULL', '80000', $db);
ChangeColumnType('accumdepnact', 'fixedassetcategories', 'VARCHAR(20)', 'NOT NULL', '0', $db);
ChangeColumnType('glcode', 'purchorderdetails', 'VARCHAR(20)', 'NOT NULL', '0', $db);
ChangeColumnType('stockact', 'stockcategory', 'VARCHAR(20)', 'NOT NULL', '0', $db);
ChangeColumnType('adjglact', 'stockcategory', 'VARCHAR(20)', 'NOT NULL', '0', $db);
ChangeColumnType('issueglact', 'stockcategory', 'VARCHAR(20)', 'NOT NULL', '0', $db);
ChangeColumnType('purchpricevaract', 'stockcategory', 'VARCHAR(20)', 'NOT NULL', '80000', $db);
ChangeColumnType('materialuseagevarac', 'stockcategory', 'VARCHAR(20)', 'NOT NULL', '80000', $db);
ChangeColumnType('wipact', 'stockcategory', 'VARCHAR(20)', 'NOT NULL', '0', $db);
ChangeColumnType('overheadrecoveryact', 'workcentres', 'VARCHAR(20)', 'NOT NULL', '0', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
ChangeColumnType('brpostaddr3', 'custbranch', 'VARCHAR(40)', 'NOT NULL', '', $db);
ChangeColumnType('brpostaddr4', 'custbranch', 'VARCHAR(50)', 'NOT NULL', '', $db);
ChangeColumnType('brpostaddr6', 'custbranch', 'VARCHAR(40)', 'NOT NULL', '', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
ChangeColumnType('pagesecurity', 'scripts', 'INT(11)', 'NOT NULL', '1', $db);
AddColumn('assigner', 'pctabs', 'VARCHAR(20)', 'NOT NULL', '', 'tablimit', $db);
ChangeConfigValue('VersionNumber', '4.04.1', $db);
UpdateDBNo(basename(__FILE__, '.php'), $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);
<?php
CreateTable('audittrail', "CREATE TABLE `audittrail` (\n\t`transactiondate` datetime NOT NULL default '0000-00-00',\n\t`userid` varchar(20) NOT NULL default '',\n\t`querystring` text,\n\tKEY `UserID` (`userid`),\n CONSTRAINT `audittrail_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `www_users` (`userid`)\n)", $db);
ChangeColumnType('contactemail', 'salesorders', 'VARCHAR(40)', 'NOT NULL', '', $db);
NewConfigValue('MonthsAuditTrail', '1', $db);
CreateTable('factorcompanies', "CREATE TABLE `factorcompanies` (\n `id` int(11) NOT NULL auto_increment,\n `coyname` varchar(50) NOT NULL default '',\n `address1` varchar(40) NOT NULL default '',\n `address2` varchar(40) NOT NULL default '',\n `address3` varchar(40) NOT NULL default '',\n `address4` varchar(40) NOT NULL default '',\n `address5` varchar(20) NOT NULL default '',\n `address6` varchar(15) NOT NULL default '',\n `contact` varchar(25) NOT NULL default '',\n `telephone` varchar(25) NOT NULL default '',\n `fax` varchar(25) NOT NULL default '',\n `email` varchar(55) NOT NULL default '',\n PRIMARY KEY (`id`)\n)", $db);
InsertRecord('factorcompanies', array('id', 'coyname'), array(NULL, 'None'), array('id', 'coyname'), array(NULL, 'None'), $db);
AddColumn('factorcompanyid', 'suppliers', 'INT(11)', 'NOT NULL', '1', 'taxgroupid', $db);
AddConstraint('suppliers', 'suppliers_ibfk_4', 'factorcompanyid', 'factorcompanies', 'id', $db);
AddColumn('perishable', 'stockmaster', 'TINYINT(1)', 'NOT NULL', '0', 'serialised', $db);
AddColumn('appendfile', 'stockmaster', 'VARCHAR(40)', 'NOT NULL', "none", 'serialised', $db);
AddColumn('expirationdate', 'stockserialitems', 'DATETIME', 'NOT NULL', "0000-00-00", 'serialno', $db);
AddColumn('currcode', 'bankaccounts', 'CHAR( 3 )', 'NOT NULL', '', 'accountcode', $db);
AddIndex(array('currcode'), 'bankaccounts', 'currcode', $db);
ChangeColumnType('exrate', 'banktrans', 'DOUBLE', 'NOT NULL', '1.0', $db);
AddColumn('functionalexrate', 'banktrans', 'DOUBLE', 'NOT NULL', " 1", 'exrate', $db);
DropConstraint('worequirements', 'worequirements_ibfk_3', $db);
AddConstraint('worequirements', 'worequirements_ibfk_3', array('wo', 'parentstockid'), 'woitems', array('wo', 'stockid'), $db);
NewConfigValue('ProhibitNegativeStock', '1', $db);
InsertRecord('systypes', array('typeid', 'typename'), array('0', _('Journal - GL')), array('typeid', 'typename'), array('0', _('Journal - GL')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('1', _('Payment - GL')), array('typeid', 'typename'), array('1', _('Payment - GL')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('2', _('Receipt - GL')), array('typeid', 'typename'), array('2', _('Receipt - GL')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('3', _('Standing Journal')), array('typeid', 'typename'), array('3', _('Standing Journal')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('10', _('Sales Invoice')), array('typeid', 'typename'), array('10', _('Sales Invoice')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('11', _('Credit Note')), array('typeid', 'typename'), array('11', _('Credit Note')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('12', _('Receipt')), array('typeid', 'typename'), array('12', _('Receipt')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('15', _('Journal - Debtors')), array('typeid', 'typename'), array('15', _('Journal - Debtors')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('16', _('Location Transfer')), array('typeid', 'typename'), array('16', _('Location Transfer')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('17', _('Stock Adjustment')), array('typeid', 'typename'), array('17', _('Stock Adjustment')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('18', _('Purchase Order')), array('typeid', 'typename'), array('18', _('Purchase Order')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('19', _('Picking List')), array('typeid', 'typename'), array('19', _('Picking List')), $db);
AddColumn('opencashdrawer', 'paymentmethods', 'TINYINT', 'NOT NULL', '0', 'usepreprintedstationery', $db);
DropConstraint('bankaccounts', 'bankaccounts_ibfk_1', $db);
DropConstraint('banktrans', 'banktrans_ibfk_2', $db);
ChangeColumnType('accountcode', 'bankaccounts', 'varchar(20)', 'NOT NULL', '0', $db);
ChangeColumnType('bankact', 'banktrans', 'varchar(20)', 'NOT NULL', '0', $db);
AddConstraint('banktrans', 'banktrans_ibfk_2', 'bankact', 'bankaccounts', 'accountcode', $db);
DropConstraint('chartdetails', 'chartdetails_ibfk_1', $db);
DropPrimaryKey('chartdetails', array('accountcode', 'period'), $db);
ChangeColumnType('accountcode', 'chartdetails', 'varchar(20)', 'NOT NULL', '0', $db);
AddPrimaryKey('chartdetails', array('accountcode', 'period'), $db);
DropConstraint('gltrans', 'gltrans_ibfk_1', $db);
ChangeColumnType('account', 'gltrans', 'varchar(20)', 'NOT NULL', '0', $db);
AddConstraint('gltrans', 'gltrans_ibfk_1', 'account', 'chartmaster', 'accountcode', $db);
DropConstraint('pcexpenses', 'pcexpenses_ibfk_1', $db);
ChangeColumnType('glaccount', 'pcexpenses', 'varchar(20)', 'NOT NULL', '0', $db);
AddConstraint('pcexpenses', 'pcexpenses_ibfk_1', 'glaccount', 'chartmaster', 'accountcode', $db);
DropConstraint('pctabs', 'pctabs_ibfk_5', $db);
ChangeColumnType('glaccountassignment', 'pctabs', 'varchar(20)', 'NOT NULL', '0', $db);
ChangeColumnType('glaccountpcash', 'pctabs', 'varchar(20)', 'NOT NULL', '0', $db);
AddConstraint('pctabs', 'pctabs_ibfk_5', 'glaccountassignment', 'chartmaster', 'accountcode', $db);
DropConstraint('taxauthorities', 'taxauthorities_ibfk_1', $db);
ChangeColumnType('taxglcode', 'taxauthorities', 'varchar(20)', 'NOT NULL', '0', $db);
AddConstraint('taxauthorities', 'taxauthorities_ibfk_1', 'taxglcode', 'chartmaster', 'accountcode', $db);
DropConstraint('taxauthorities', 'taxauthorities_ibfk_2', $db);
ChangeColumnType('purchtaxglaccount', 'taxauthorities', 'varchar(20)', 'NOT NULL', '0', $db);
AddConstraint('taxauthorities', 'taxauthorities_ibfk_2', 'purchtaxglaccount', 'chartmaster', 'accountcode', $db);
AddConstraint('bankaccounts', 'bankaccounts_ibfk_1', 'accountcode', 'chartmaster', 'accountcode', $db);
AddConstraint('chartdetails', 'chartdetails_ibfk_1', 'accountcode', 'chartmaster', 'accountcode', $db);
NewScript('NoSalesItems.php', '2', $db);
ChangeConfigValue('VersionNumber', '4.08', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
AddColumn('address5', 'debtorsmaster', 'VARCHAR(20)', 'NOT NULL', '', 'address4', $db);
AddColumn('address6', 'debtorsmaster', 'VARCHAR(15)', 'NOT NULL', '', 'address5', $db);
AddColumn('braddress5', 'custbranch', 'VARCHAR(20)', 'NOT NULL', '', 'braddress4', $db);
AddColumn('braddress6', 'custbranch', 'VARCHAR(15)', 'NOT NULL', '', 'braddress5', $db);
AddColumn('brpostaddr5', 'custbranch', 'VARCHAR(20)', 'NOT NULL', '', 'brpostaddr4', $db);
AddColumn('brpostaddr6', 'custbranch', 'VARCHAR(15)', 'NOT NULL', '', 'brpostaddr5', $db);
AddColumn('deladd4', 'locations', 'VARCHAR(40)', 'NOT NULL', '', 'deladd3', $db);
AddColumn('deladd5', 'locations', 'VARCHAR(20)', 'NOT NULL', '', 'deladd4', $db);
AddColumn('deladd6', 'locations', 'VARCHAR(15)', 'NOT NULL', '', 'deladd5', $db);
AddColumn('deladd5', 'purchorders', 'VARCHAR(20)', 'NOT NULL', '', 'deladd4', $db);
AddColumn('deladd6', 'purchorders', 'VARCHAR(15)', 'NOT NULL', '', 'deladd5', $db);
AddColumn('contact', 'purchorders', 'VARCHAR(30)', 'NOT NULL', '', 'deladd6', $db);
AddColumn('deladd5', 'recurringsalesorders', 'VARCHAR(20)', 'NOT NULL', '', 'deladd4', $db);
AddColumn('deladd6', 'recurringsalesorders', 'VARCHAR(15)', 'NOT NULL', '', 'deladd5', $db);
ChangeColumnType('deladd2', 'recurringsalesorders', 'VARCHAR(40)', 'NOT NULL', '', $db);
ChangeColumnType('deladd3', 'recurringsalesorders', 'VARCHAR(40)', 'NOT NULL', '', $db);
ChangeColumnType('deladd4', 'recurringsalesorders', 'VARCHAR(40)', 'NOT NULL', '', $db);
AddColumn('deladd5', 'salesorders', 'VARCHAR(20)', 'NOT NULL', '', 'deladd4', $db);
AddColumn('deladd6', 'salesorders', 'VARCHAR(15)', 'NOT NULL', '', 'deladd5', $db);
ChangeColumnType('deladd2', 'salesorders', 'VARCHAR(40)', 'NOT NULL', '', $db);
ChangeColumnType('deladd3', 'salesorders', 'VARCHAR(40)', 'NOT NULL', '', $db);
ChangeColumnType('deladd4', 'salesorders', 'VARCHAR(40)', 'NOT NULL', '', $db);
AddColumn('address5', 'suppliers', 'VARCHAR(20)', 'NOT NULL', '', 'address4', $db);
AddColumn('address6', 'suppliers', 'VARCHAR(15)', 'NOT NULL', '', 'address5', $db);
ChangeColumnName('regoffice3', 'companies', 'VARCHAR(40)', 'NOT NULL', '', 'regoffice4', $db);
ChangeColumnName('regoffice2', 'companies', 'VARCHAR(40)', 'NOT NULL', '', 'regoffice3', $db);
ChangeColumnName('regoffice1', 'companies', 'VARCHAR(40)', 'NOT NULL', '', 'regoffice2', $db);
ChangeColumnName('postaladdress', 'companies', 'VARCHAR(40)', 'NOT NULL', '', 'regoffice1', $db);
AddColumn('regoffice5', 'companies', 'VARCHAR(20)', 'NOT NULL', '', 'regoffice4', $db);
AddColumn('regoffice6', 'companies', 'VARCHAR(15)', 'NOT NULL', '', 'regoffice5', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
ChangeConfigName('DefaultTaxLevel', 'DefaultTaxCategory', $db);
ChangeConfigValue('part_pics_dir', 'companies/kwamoja/part_pics', $db);
ChangeConfigValue('EDI_Incoming_Orders', 'companies/kwamoja/EDI_Incoming_Orders', $db);
ChangeConfigValue('EDI_MsgPending', 'companies/kwamoja/EDI_MsgPending', $db);
ChangeConfigValue('EDI_Sent', 'companies/kwamoja/EDI_Sent', $db);
ChangeConfigValue('companies/kwamoja/reports', 'reports_dir', $db);
DropColumn('pinno', 'www_users', $db);
DropColumn('swipecard', 'www_users', $db);
ChangeColumnType('bankact', 'suppliers', 'VARCHAR( 30 )', 'NOT NULL', '', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
NewScript('Z_DeleteOldPrices.php', '15', $db);
NewScript('Z_ChangeLocationCode.php', '15', $db);
CreateTable('internalstockcatrole', "CREATE TABLE IF NOT EXISTS `internalstockcatrole` (\n `categoryid` varchar(6) NOT NULL,\n `secroleid` int(11) NOT NULL,\n KEY `internalstockcatrole_ibfk_1` (`categoryid`),\n KEY `internalstockcatrole_ibfk_2` (`secroleid`)\n)", $db);
NewScript('InternalStockCategoriesByRole.php', '15', $db);
AddColumn('internalrequest', 'locations', 'TINYINT(1)', 'NOT NULL', '1', 'cashsalebranch', $db);
ChangeColumnType('shipdate', 'loctransfers', 'DATETIME', 'NOT NULL', "0000-00-00 00:00:00", $db);
ChangeColumnType('recdate', 'loctransfers', 'DATETIME', 'NOT NULL', "0000-00-00 00:00:00", $db);
NewScript('GLJournalInquiry.php', '15', $db);
NewScript('PDFGLJournal.php', '15', $db);
AddColumn('department', 'www_users', 'INT(11)', 'NOT NULL', '0', 'pdflanguage', $db);
NewConfigValue('WorkingDaysWeek', '5', $db);
ChangeColumnType('address6', 'suppliers', 'VARCHAR(40)', 'NOT NULL', '', $db);
ChangeColumnType('braddress6', 'custbranch', 'VARCHAR(40)', 'NOT NULL', '', $db);
ChangeColumnType('address6', 'debtorsmaster', 'VARCHAR(40)', 'NOT NULL', '', $db);
AddConstraint('stockcatproperties', 'categoryid', 'categoryid', 'stockcategory', 'categoryid', $db);
AddConstraint('stockitemproperties', 'stockid', 'stockid', 'stockmaster', 'stockid', $db);
AddConstraint('stockitemproperties', 'stkcatpropid', 'stkcatpropid', 'stockcatproperties', 'stkcatpropid', $db);
AddConstraint('stockmovestaxes', 'stkmoveno', 'stkmoveno', 'stockmoves', 'stkmoveno', $db);
AddIndex(array('loccode'), 'stockrequest', 'loccode', $db);
AddConstraint('stockrequest', 'loccode', 'loccode', 'locations', 'loccode', $db);
AddIndex(array('departmentid'), 'stockrequest', 'departmentid', $db);
AddConstraint('stockrequest', 'departmentid', 'departmentid', 'departments', 'departmentid', $db);
AddPrimaryKey('stockrequestitems', array('dispatchitemsid', 'dispatchid'), $db);
AddIndex(array('dispatchid'), 'stockrequestitems', 'dispatchid', $db);
AddIndex(array('stockid'), 'stockrequestitems', 'stockid', $db);
AddConstraint('stockrequestitems', 'dispatchid', 'dispatchid', 'stockrequest', 'dispatchid', $db);
AddConstraint('stockrequestitems', 'stockrequestitems_ibfk_2', 'stockid', 'stockmaster', 'stockid', $db);
AddPrimaryKey('internalstockcatrole', array('categoryid', 'secroleid'), $db);
AddConstraint('internalstockcatrole', 'internalstockcatrole_ibfk_1', 'categoryid', 'stockcategory', 'categoryid', $db);
ChangeConfigValue('VersionNumber', '3.12.31', $db);
NewConfigValue('AutoAuthorisePO', '1', $db);
ChangeConfigValue('VersionNumber', '4.03', $db);
AddColumn('poplaced', 'salesorders', 'TINYINT', 'NOT NULL', '0', 'quotedate', $db);
AddIndex(array('poplaced'), 'salesorders', 'poplaced', $db);
ChangeConfigValue('VersionNumber', '4.03.1', $db);
ChangeConfigValue('VersionNumber', '4.03.2', $db);
AddColumn('cashsalebranch', 'locations', 'VARCHAR(10)', 'NOT NULL', "Default ''", 'managed', $db);
ChangeColumnType('cashsalecustomer', 'locations', 'VARCHAR(10)', 'NOT NULL', '', $db);
ChangeConfigValue('VersionNumber', '4.03.3', $db);
NewScript('Z_ChangeSupplierCode.php', '15', $db);
ChangeConfigValue('VersionNumber', '4.03.5', $db);
NewScript('ReprintGRN.php', '11', $db);
ChangeConfigValue('VersionNumber', '4.03.6', $db);
AddColumn('usepreprintedstationery', 'paymentmethods', 'TINYINT', 'NOT NULL', '0', 'receipttype', $db);
RemoveScript('PDFStockTransListing.php', $db);
NewScript('PDFPeriodStockTransListing.php', '3', $db);
ChangeConfigValue('VersionNumber', '4.03.7', $db);
DropColumn('itemno', 'purchorderdetails', $db);
DropColumn('subtotal_amount', 'purchorderdetails', $db);
DropColumn('package', 'purchorderdetails', $db);
DropColumn('pcunit', 'purchorderdetails', $db);
DropColumn('kgs', 'purchorderdetails', $db);
DropColumn('cuft', 'purchorderdetails', $db);
DropColumn('total_quantity', 'purchorderdetails', $db);
DropColumn('netweight', 'purchorderdetails', $db);
DropColumn('total_amount', 'purchorderdetails', $db);
DropColumn('uom', 'purchorderdetails', $db);
ChangeConfigValue('VersionNumber', '4.03.8', $db);
ChangeColumnType('stockcheckdate', 'stockcheckfreeze', 'DATE', 'NOT NULL', '0000-00-00', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
/* Include the new script for printing quotations in Portrait
*/
InsertRecord('pagesecurity', array('script', 'security'), array('doc/Manual/ManualContents.php', 1), array('script', 'security'), array('doc/Manual/ManualContents.php', 1), $db);
RenameTable('dispatch', 'stockrequest', $db);
RenameTable('dispatchitems', 'stockrequestitems', $db);
AddColumn('decimalplaces', 'stockrequestitems', 'int', 'not null', 0, 'quantity', $db);
AddColumn('uom', 'stockrequestitems', 'varchar(20)', 'not null', '', 'decimalplaces', $db);
ChangeColumnType('dispatchid', 'stockrequest', 'INT (11)', 'NOT NULL', 0, $db);
InsertRecord('systypes', array('typeid'), array('38'), array('typeid', 'typename', 'typeno'), array('38', 'Stock Requests', '0'), $db);
UpdateDBNo(97, $db);
<?php
CreateTable('custcontacts', "CREATE TABLE `custcontacts` (\n `contid` int(11) NOT NULL auto_increment,\n `debtorno` varchar(10) NOT NULL,\n `contactname` varchar(40) NOT NULL,\n `role` varchar(40) NOT NULL,\n `phoneno` varchar(20) NOT NULL,\n `notes` varchar(255) NOT NULL,\n PRIMARY KEY (`contid`)\n)", $db);
AddColumn('taxref', 'suppliers', 'VARCHAR(20)', 'NOT NULL', '', 'factorcompanyid', $db);
CreateTable('tags', "CREATE TABLE `tags` (\n`tagref` tinyint(4) NOT NULL auto_increment,\n`tagdescription` varchar(50) NOT NULL,\nPRIMARY KEY (`tagref`)\n)", $db);
AddColumn('tag', 'gltrans', 'TINYINT(4)', 'NOT NULL', "0", 'jobref', $db);
DropColumn('vtiger_accountid', 'custbranch', $db);
DropColumn('vtiger_accountid', 'salesorders', $db);
DropColumn('vtiger_productid', 'stockmaster', $db);
DeleteConfigValue('vtiger_integration', $db);
AddColumn('lat', 'custbranch', 'FLOAT( 10, 6 )', 'NOT NULL', "0.0", 'braddress6', $db);
AddColumn('lng', 'custbranch', 'FLOAT( 10, 6 )', 'NOT NULL', "0.0", 'lat', $db);
AddColumn('lat', 'suppliers', 'FLOAT( 10, 6 )', 'NOT NULL', "0.0", 'address6', $db);
AddColumn('lng', 'suppliers', 'FLOAT( 10, 6 )', 'NOT NULL', "0.0", 'lat', $db);
CreateTable('geocode_param', "CREATE TABLE `geocode_param` (\n `geocodeid` varchar(4) NOT NULL default '',\n `geocode_key` varchar(200) NOT NULL default '',\n `center_long` varchar(20) NOT NULL default '',\n `center_lat` varchar(20) NOT NULL default '',\n `map_height` varchar(10) NOT NULL default '',\n `map_width` varchar(10) NOT NULL default '',\n `map_host` varchar(50) NOT NULL default ''\n)", $db);
NewConfigValue('geocode_integration', '0', $db);
NewConfigValue('DefaultCustomerType', '1', $db);
CreateTable('debtortype', "CREATE TABLE `debtortype` (\n`typeid` tinyint(4) NOT NULL auto_increment,\n`typename` varchar(100) NOT NULL,\nPRIMARY KEY (`typeid`)\n)", $db);
InsertRecord('debtortype', array('typeid', 'typename'), array(NULL, 'Default'), array('typeid', 'typename'), array(NULL, 'Default'), $db);
AddColumn('typeid', 'debtorsmaster', 'TINYINT(4)', 'NOT NULL', "1", 'customerpoline', $db);
AddConstraint('debtorsmaster', 'debtorsmaster_ibfk_5', 'typeid', 'debtortype', 'typeid', $db);
AddColumn('effectivefrom', 'purchdata', 'DATE', 'NOT NULL', "0000-00-00", 'preferred', $db);
CreateTable('debtortypenotes', "CREATE TABLE `debtortypenotes` (\n`noteid` tinyint(4) NOT NULL auto_increment,\n`typeid` tinyint(4) NOT NULL default '0',\n`href` varchar(100) NOT NULL,\n`note` varchar(200) NOT NULL,\n`date` date NOT NULL default '0000-00-00',\n`priority` varchar(20) NOT NULL,\nPRIMARY KEY (`noteid`)\n)", $db);
CreateTable('custnotes', "CREATE TABLE `custnotes` (\n`noteid` tinyint(4) NOT NULL auto_increment,\n`debtorno` varchar(10) NOT NULL default '0',\n`href` varchar(100) NOT NULL,\n`note` varchar(200) NOT NULL,\n`date` date NOT NULL default '0000-00-00',\n`priority` varchar(20) NOT NULL,\nPRIMARY KEY (`noteid`)\n)", $db);
NewConfigValue('Extended_CustomerInfo', '0', $db);
NewConfigValue('Extended_SupplierInfo', '0', $db);
ChangeColumnType('area', 'salesglpostings', 'VARCHAR(3)', 'NOT NULL', '', $db);
ChangeColumnType('area', 'salesanalysis', 'VARCHAR(3)', 'NOT NULL', '', $db);
ChangeColumnType('trandate', 'debtortrans', 'DATE', 'NOT NULL', '0000-00-00', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
