<?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);
NewConfigValue('ShopPayPalUser', '', $db);
NewConfigValue('ShopPrivacyStatement', '', $db);
NewConfigValue('ShopShowInfoLinks', 1, $db);
NewConfigValue('ShopShowLeftCategoryMenu', 1, $db);
NewConfigValue('ShopShowLogoAndShopName', 1, $db);
NewConfigValue('ShopShowOnlyAvailableItems', 0, $db);
NewConfigValue('ShopShowQOHColumn', 1, $db);
NewConfigValue('ShopShowTopCategoryMenu', 1, $db);
NewConfigValue('ShopStockLocations', 1, $db);
NewConfigValue('ShopSurchargeStockID', '', $db);
NewConfigValue('ShopSwipeHQAPIKey', '', $db);
NewConfigValue('ShopSwipeHQMerchantID', '', $db);
NewConfigValue('ShopTermsConditions', '', $db);
NewConfigValue('ShopTitle', 'Shop Home', $db);
NewConfigValue('ShowStockidOnImages', 0, $db);
NewConfigValue('ShowValueOnGRN', 1, $db);
NewConfigValue('Show_Settled_LastMonth', 1, $db);
NewConfigValue('SmtpSetting', 0, $db);
NewConfigValue('SO_AllowSameItemMultipleTimes', 1, $db);
NewConfigValue('StandardCostDecimalPlaces', 2, $db);
NewConfigValue('TaxAuthorityReferenceName', '', $db);
NewConfigValue('UpdateCurrencyRatesDaily', 0, $db);
NewConfigValue('VersionNumber', '13.10.0', $db);
NewConfigValue('vtiger_integration', 0, $db);
NewConfigValue('WeightedAverageCosting', 1, $db);
NewConfigValue('WikiApp', 'Disabled', $db);
NewConfigValue('WikiPath', 'wiki', $db);
NewConfigValue('WorkingDaysWeek', 5, $db);
NewConfigValue('YearEnd', 3, $db);
NewConfigValue('DBUpdateNumber', HighestFileName($PathPrefix), $db);
<?php
/* New config values for whether to show frequently ordered items
* on order entry, and if so then how many months to show
*/
NewConfigValue('FrequentlyOrderedItems', '0', $db);
NewConfigValue('NumberOfMonthMustBeShown', '6', $db);
UpdateDBNo(8, $db);
<?php
NewConfigValue('ShopAdditionalStockLocations', '', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
/* Move the version number to the database from the config.php file
*/
NewConfigValue('VersionNumber', '4.00-RC1', $db);
UpdateDBNo(34, $db);
<?php
/* New config value to determine whether values are shown on the grn
* screen and the printed grn
*/
NewConfigValue('ShowValueOnGRN', 1, $db);
UpdateDBNo(27, $db);
<?php
NewConfigValue('ShopManagerEmail', '', $db);
UpdateDBNo(basename(__FILE__, '.php'), $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);
InsertRecord('systypes', array('typeid', 'typename'), array('20', _('Purchase Invoice')), array('typeid', 'typename'), array('20', _('Purchase Invoice')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('21', _('Debit Note')), array('typeid', 'typename'), array('21', _('Debit Note')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('22', _('Creditors Payment')), array('typeid', 'typename'), array('22', _('Creditors Payment')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('23', _('Creditors Journal')), array('typeid', 'typename'), array('23', _('Creditors Journal')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('25', _('Purchase Order Delivery')), array('typeid', 'typename'), array('25', _('Purchase Order Delivery')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('26', _('Work Order Receipt')), array('typeid', 'typename'), array('26', _('Work Order Receipt')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('28', _('Work Order Issue')), array('typeid', 'typename'), array('28', _('Work Order Issue')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('29', _('Work Order Variance')), array('typeid', 'typename'), array('29', _('Work Order Variance')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('30', _('Sales Order')), array('typeid', 'typename'), array('30', _('Sales Order')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('31', _('Shipment Close')), array('typeid', 'typename'), array('31', _('Shipment Close')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('32', _('Contract Close')), array('typeid', 'typename'), array('32', _('Contract Close')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('35', _('Cost Update')), array('typeid', 'typename'), array('35', _('Cost Update')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('37', _('Tenders')), array('typeid', 'typename'), array('37', _('Tenders')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('38', _('Stock Requests')), array('typeid', 'typename'), array('38', _('Stock Requests')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('36', _('Exchange Difference')), array('typeid', 'typename'), array('36', _('Exchange Difference')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('40', _('Work Order')), array('typeid', 'typename'), array('40', _('Work Order')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('41', _('Asset Addition')), array('typeid', 'typename'), array('41', _('Asset Addition')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('42', _('Asset Category Change')), array('typeid', 'typename'), array('42', _('Asset Category Change')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('43', _('Delete w/down asset')), array('typeid', 'typename'), array('43', _('Delete w/down asset')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('44', _('Depreciation')), array('typeid', 'typename'), array('44', _('Depreciation')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('49', _('Import Fixed Assets')), array('typeid', 'typename'), array('49', _('Import Fixed Assets')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('50', _('Opening Balance')), array('typeid', 'typename'), array('50', _('Opening Balance')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('500', _('Auto Debtor Number')), array('typeid', 'typename'), array('500', _('Auto Debtor Number')), $db);
NewConfigValue('UpdateCurrencyRatesDaily', '0', $db);
CreateTable('assetmanager', "CREATE TABLE `assetmanager` (\n `id` int(11) NOT NULL auto_increment,\n `serialno` varchar(30) NOT NULL default '',\n `assetglcode` int(11) NOT NULL default '0',\n `depnglcode` int(11) NOT NULL default '0',\n `description` varchar(30) NOT NULL default '',\n `lifetime` int(11) NOT NULL default 0,\n `location` varchar(15) NOT NULL default '',\n `cost` double NOT NULL default 0.0,\n `depn` double NOT NULL default 0.0,\n PRIMARY KEY (`id`)\n)", $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
DropColumn('lastcurcostdate', 'stockmaster', $db);
AddColumn('lastcostupdate', 'stockmaster', 'DATE', 'NOT NULL', "0000-00-00", 'netweight', $db);
NewConfigValue('InventoryManagerEmail', '*****@*****.**', $db);
AddIndex(array('ref'), 'banktrans', 'ref', $db);
AddColumn('tag', 'pcexpenses', 'TINYINT( 4 )', 'NOT NULL', "0", 'glaccount', $db);
DropConstraint('debtotrans', 'debtortrans_ibfk_1', $db);
ChangeConfigValue('VersionNumber', '4.06.6', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
Createtable('salesman', "CREATE TABLE `salesman` (\n `salesmancode` char(3) NOT NULL default '',\n `salesmanname` char(30) NOT NULL default '',\n `smantel` char(20) NOT NULL default '',\n `smanfax` char(20) NOT NULL default '',\n `commissionrate1` double(16,4) NOT NULL default '0.0000',\n `breakpoint` decimal(20,4) NOT NULL default '0.0000',\n `commissionrate2` double(16,4) NOT NULL default '0.0000',\n PRIMARY KEY (`salesmancode`)\n)", $db);
CreateTable('salesorderdetails', "CREATE TABLE `salesorderdetails` (\n `orderno` int(11) NOT NULL default '0',\n `stkcode` varchar(20) NOT NULL default '',\n `qtyinvoiced` double(16,4) NOT NULL default '0.0000',\n `unitprice` double(16,4) NOT NULL default '0.0000',\n `quantity` double(16,4) NOT NULL default '0.0000',\n `estimate` tinyint(4) NOT NULL default '0',\n `discountpercent` double(16,4) NOT NULL default '0.0000',\n `actualdispatchdate` datetime NOT NULL default '0000-00-00 00:00:00',\n `completed` tinyint(1) NOT NULL default '0',\n `narrative` text NOT NULL,\n PRIMARY KEY (`orderno`,`stkcode`),\n KEY `OrderNo` (`orderno`),\n KEY `StkCode` (`stkcode`),\n KEY `Completed` (`completed`),\n CONSTRAINT `salesorderdetails_ibfk_1` FOREIGN KEY (`orderno`) REFERENCES `salesorders` (`OrderNo`),\n CONSTRAINT `salesorderdetails_ibfk_2` FOREIGN KEY (`stkcode`) REFERENCES `stockmaster` (`StockID`)\n)", $db);
CreateTable('salesorders', "CREATE TABLE `salesorders` (\n `orderno` int(11) NOT NULL auto_increment,\n `debtorno` varchar(10) NOT NULL default '',\n `branchcode` varchar(10) NOT NULL default '',\n `customerref` varchar(50) NOT NULL default '',\n `buyername` varchar(50) default NULL,\n `comments` longblob,\n `orddate` date NOT NULL default '0000-00-00',\n `ordertype` char(2) NOT NULL default '',\n `shipvia` int(11) NOT NULL default '0',\n `deladd1` varchar(40) NOT NULL default '',\n `deladd2` varchar(20) NOT NULL default '',\n `deladd3` varchar(15) NOT NULL default '',\n `deladd4` varchar(15) default NULL,\n `contactphone` varchar(25) default NULL,\n `contactemail` varchar(25) default NULL,\n `deliverto` varchar(40) NOT NULL default '',\n `deliverblind` tinyint(1) default '1',\n `freightcost` double NOT NULL default '0',\n `fromstkloc` varchar(5) NOT NULL default '',\n `deliverydate` date NOT NULL default '0000-00-00',\n `printedpackingslip` tinyint(4) NOT NULL default '0',\n `datepackingslipprinted` date NOT NULL default '0000-00-00',\n `quotation` tinyint(4) NOT NULL default '0',\n PRIMARY KEY (`orderno`),\n KEY `DebtorNo` (`debtorno`),\n KEY `OrdDate` (`orddate`),\n KEY `OrderType` (`ordertype`),\n KEY `LocationIndex` (`fromstkloc`),\n KEY `BranchCode` (`branchcode`,`debtorno`),\n KEY `ShipVia` (`shipvia`),\n KEY `quotation` (`quotation`),\n CONSTRAINT `salesorders_ibfk_1` FOREIGN KEY (`branchcode`, `debtorno`) REFERENCES `custbranch` (`branchcode`, `debtorno`),\n CONSTRAINT `salesorders_ibfk_2` FOREIGN KEY (`shipvia`) REFERENCES `shippers` (`Shipper_ID`),\n CONSTRAINT `salesorders_ibfk_3` FOREIGN KEY (`fromstkloc`) REFERENCES `locations` (`loccode`)\n)", $db);
CreateTable('salestypes', "CREATE TABLE `salestypes` (\n `typeabbrev` char(2) NOT NULL default '',\n `sales_type` char(20) NOT NULL default '',\n PRIMARY KEY (`typeabbrev`),\n KEY `Sales_Type` (`sales_type`)\n)", $db);
CreateTable('scripts', "CREATE TABLE `scripts` (\n `pageid` smallint(4) NOT NULL auto_increment,\n `filename` varchar(50) NOT NULL default '',\n `pagedescription` text NOT NULL,\n PRIMARY KEY (`pageid`),\n KEY `FileName` (`filename`)\n)", $db);
CreateTable('securitygroups', "CREATE TABLE `securitygroups` (\n `secroleid` int(11) NOT NULL default '0',\n `tokenid` int(11) NOT NULL default '0',\n PRIMARY KEY (`secroleid`,`tokenid`),\n KEY `secroleid` (`secroleid`),\n KEY `tokenid` (`tokenid`),\n CONSTRAINT `securitygroups_secroleid_fk` FOREIGN KEY (`secroleid`) REFERENCES `securityroles` (`secroleid`),\n CONSTRAINT `securitygroups_tokenid_fk` FOREIGN KEY (`tokenid`) REFERENCES `securitytokens` (`tokenid`)\n)", $db);
CreateTable('securityroles', "CREATE TABLE `securityroles` (\n `secroleid` int(11) NOT NULL auto_increment,\n `secrolename` text NOT NULL,\n PRIMARY KEY (`secroleid`)\n)", $db);
CreateTable('securitytokens', "CREATE TABLE `securitytokens` (\n `tokenid` int(11) NOT NULL default '0',\n `tokenname` text NOT NULL,\n PRIMARY KEY (`tokenid`)\n)", $db);
CreateTable('shipmentcharges', "CREATE TABLE `shipmentcharges` (\n `shiptchgid` int(11) NOT NULL auto_increment,\n `shiptref` int(11) NOT NULL default '0',\n `transtype` smallint(6) NOT NULL default '0',\n `transno` int(11) NOT NULL default '0',\n `stockid` varchar(20) NOT NULL default '',\n `value` double NOT NULL default '0',\n PRIMARY KEY (`shiptchgid`),\n KEY `TransType` (`transtype`,`transno`),\n KEY `ShiptRef` (`shiptref`),\n KEY `StockID` (`stockid`),\n KEY `TransType_2` (`transtype`),\n CONSTRAINT `shipmentcharges_ibfk_1` FOREIGN KEY (`shiptref`) REFERENCES `shipments` (`ShiptRef`),\n CONSTRAINT `shipmentcharges_ibfk_2` FOREIGN KEY (`transtype`) REFERENCES `systypes` (`TypeID`)\n)", $db);
CreateTable('shipments', "CREATE TABLE `shipments` (\n `shiptref` int(11) NOT NULL default '0',\n `voyageref` varchar(20) NOT NULL default '0',\n `vessel` varchar(50) NOT NULL default '',\n `eta` datetime NOT NULL default '0000-00-00 00:00:00',\n `accumvalue` double(16,4) NOT NULL default '0.0000',\n `supplierid` varchar(10) NOT NULL default '',\n `closed` tinyint(4) NOT NULL default '0',\n PRIMARY KEY (`shiptref`),\n KEY `ETA` (`eta`),\n KEY `SupplierID` (`supplierid`),\n KEY `ShipperRef` (`voyageref`),\n KEY `Vessel` (`vessel`),\n CONSTRAINT `shipments_ibfk_1` FOREIGN KEY (`supplierid`) REFERENCES `suppliers` (`SupplierID`)\n)", $db);
CreateTable('shippers', "CREATE TABLE `shippers` (\n `shipper_id` int(11) NOT NULL auto_increment,\n `shippername` char(40) NOT NULL default '',\n `mincharge` double(16,4) NOT NULL default '0.0000',\n PRIMARY KEY (`shipper_id`)\n)", $db);
CreateTable('stockcategory', "CREATE TABLE `stockcategory` (\n `categoryid` char(6) NOT NULL default '',\n `categorydescription` char(20) NOT NULL default '',\n `stocktype` char(1) NOT NULL default 'F',\n `stockact` int(11) NOT NULL default '0',\n `adjglact` int(11) NOT NULL default '0',\n `purchpricevaract` int(11) NOT NULL default '80000',\n `materialuseagevarac` int(11) NOT NULL default '80000',\n `wipact` int(11) NOT NULL default '0',\n PRIMARY KEY (`categoryid`),\n KEY `CategoryDescription` (`categorydescription`),\n KEY `StockType` (`stocktype`)\n)", $db);
CreateTable('stockcheckfreeze', "CREATE TABLE `stockcheckfreeze` (\n `stockid` varchar(20) NOT NULL default '',\n `loccode` varchar(5) NOT NULL default '',\n `qoh` double NOT NULL default '0',\n PRIMARY KEY (`stockid`),\n KEY `LocCode` (`loccode`),\n CONSTRAINT `stockcheckfreeze_ibfk_1` FOREIGN KEY (`stockid`) REFERENCES `stockmaster` (`StockID`),\n CONSTRAINT `stockcheckfreeze_ibfk_2` FOREIGN KEY (`loccode`) REFERENCES `locations` (`loccode`)\n)", $db);
CreateTable('stockcounts', "CREATE TABLE `stockcounts` (\n `id` int(11) NOT NULL auto_increment,\n `stockid` varchar(20) NOT NULL default '',\n `loccode` varchar(5) NOT NULL default '',\n `qtycounted` double NOT NULL default '0',\n `reference` varchar(20) NOT NULL default '',\n PRIMARY KEY (`id`),\n KEY `StockID` (`stockid`),\n KEY `LocCode` (`loccode`),\n CONSTRAINT `stockcounts_ibfk_1` FOREIGN KEY (`stockid`) REFERENCES `stockmaster` (`StockID`),\n CONSTRAINT `stockcounts_ibfk_2` FOREIGN KEY (`loccode`) REFERENCES `locations` (`loccode`)\n)", $db);
CreateTable('stockmaster', "CREATE TABLE `stockmaster` (\n `stockid` varchar(20) NOT NULL default '',\n `categoryid` varchar(6) NOT NULL default '',\n `description` varchar(50) NOT NULL default '',\n `longdescription` text NOT NULL,\n `units` varchar(20) NOT NULL default 'each',\n `mbflag` char(1) NOT NULL default 'B',\n `lastcurcostdate` date NOT NULL default '1800-01-01',\n `actualcost` decimal(20,4) NOT NULL default '0.0000',\n `lastcost` decimal(20,4) NOT NULL default '0.0000',\n `materialcost` decimal(20,4) NOT NULL default '0.0000',\n `labourcost` decimal(20,4) NOT NULL default '0.0000',\n `overheadcost` decimal(20,4) NOT NULL default '0.0000',\n `lowestlevel` smallint(6) NOT NULL default '0',\n `discontinued` tinyint(4) NOT NULL default '0',\n `controlled` tinyint(4) NOT NULL default '0',\n `eoq` double(10,2) NOT NULL default '0.00',\n `volume` decimal(20,4) NOT NULL default '0.0000',\n `kgs` decimal(20,4) NOT NULL default '0.0000',\n `barcode` varchar(50) NOT NULL default '',\n `discountcategory` char(2) NOT NULL default '',\n `taxlevel` tinyint(4) NOT NULL default '1',\n `serialised` tinyint(4) NOT NULL default '0',\n `decimalplaces` tinyint(4) NOT NULL default '0',\n PRIMARY KEY (`stockid`),\n KEY `CategoryID` (`categoryid`),\n KEY `Description` (`description`),\n KEY `LastCurCostDate` (`lastcurcostdate`),\n KEY `MBflag` (`mbflag`),\n KEY `StockID` (`stockid`,`categoryid`),\n KEY `Controlled` (`controlled`),\n KEY `DiscountCategory` (`discountcategory`),\n CONSTRAINT `stockmaster_ibfk_1` FOREIGN KEY (`categoryid`) REFERENCES `stockcategory` (`categoryid`)\n)", $db);
CreateTable('stockmoves', "CREATE TABLE `stockmoves` (\n `stkmoveno` int(11) NOT NULL auto_increment,\n `stockid` varchar(20) NOT NULL default '',\n `type` smallint(6) NOT NULL default '0',\n `transno` int(11) NOT NULL default '0',\n `loccode` varchar(5) NOT NULL default '',\n `trandate` date NOT NULL default '0000-00-00',\n `debtorno` varchar(10) NOT NULL default '',\n `branchcode` varchar(10) NOT NULL default '',\n `price` decimal(20,4) NOT NULL default '0.0000',\n `prd` smallint(6) NOT NULL default '0',\n `reference` varchar(40) NOT NULL default '',\n `qty` double(16,4) NOT NULL default '1.0000',\n `discountpercent` double(16,4) NOT NULL default '0.0000',\n `standardcost` double(16,4) NOT NULL default '0.0000',\n `show_on_inv_crds` tinyint(4) NOT NULL default '1',\n `newqoh` double NOT NULL default '0',\n `hidemovt` tinyint(4) NOT NULL default '0',\n `taxrate` double NOT NULL default '0',\n `narrative` text NOT NULL,\n PRIMARY KEY (`stkmoveno`),\n KEY `DebtorNo` (`debtorno`),\n KEY `LocCode` (`loccode`),\n KEY `Prd` (`prd`),\n KEY `StockID` (`stockid`,`loccode`),\n KEY `StockID_2` (`stockid`),\n KEY `TranDate` (`trandate`),\n KEY `TransNo` (`transno`),\n KEY `Type` (`type`),\n KEY `Show_On_Inv_Crds` (`show_on_inv_crds`),\n KEY `Hide` (`hidemovt`),\n CONSTRAINT `stockmoves_ibfk_1` FOREIGN KEY (`stockid`) REFERENCES `stockmaster` (`stockid`),\n CONSTRAINT `stockmoves_ibfk_2` FOREIGN KEY (`type`) REFERENCES `systypes` (`TypeID`),\n CONSTRAINT `stockmoves_ibfk_3` FOREIGN KEY (`loccode`) REFERENCES `locations` (`loccode`),\n CONSTRAINT `stockmoves_ibfk_4` FOREIGN KEY (`prd`) REFERENCES `periods` (`periodno`)\n)", $db);
CreateTable('stockserialitems', "CREATE TABLE `stockserialitems` (\n `stockid` varchar(20) NOT NULL default '',\n `loccode` varchar(5) NOT NULL default '',\n `serialno` varchar(30) NOT NULL default '',\n `quantity` double NOT NULL default '0',\n PRIMARY KEY (`stockid`,`serialno`,`loccode`),\n KEY `StockID` (`stockid`),\n KEY `LocCode` (`loccode`),\n CONSTRAINT `stockserialitems_ibfk_1` FOREIGN KEY (`stockid`) REFERENCES `stockmaster` (`stockid`),\n CONSTRAINT `stockserialitems_ibfk_2` FOREIGN KEY (`loccode`) REFERENCES `locations` (`loccode`)\n)", $db);
CreateTable('stockserialmoves', "CREATE TABLE `stockserialmoves` (\n `stkitmmoveno` int(11) NOT NULL auto_increment,\n `stockmoveno` int(11) NOT NULL default '0',\n `stockid` varchar(20) NOT NULL default '',\n `serialno` varchar(30) NOT NULL default '',\n `moveqty` double NOT NULL default '0',\n PRIMARY KEY (`stkitmmoveno`),\n KEY `StockMoveNo` (`stockmoveno`),\n KEY `StockID_SN` (`stockid`,`serialno`),\n CONSTRAINT `stockserialmoves_ibfk_1` FOREIGN KEY (`stockmoveno`) REFERENCES `stockmoves` (`stkmoveno`),\n CONSTRAINT `stockserialmoves_ibfk_2` FOREIGN KEY (`stockid`, `serialno`) REFERENCES `stockserialitems` (`stockid`, `serialno`)\n)", $db);
CreateTable('suppallocs', "CREATE TABLE `suppallocs` (\n `id` int(11) NOT NULL auto_increment,\n `amt` double NOT NULL default '0',\n `datealloc` date NOT NULL default '0000-00-00',\n `transid_allocfrom` int(11) NOT NULL default '0',\n `transid_allocto` int(11) NOT NULL default '0',\n PRIMARY KEY (`id`),\n KEY `TransID_AllocFrom` (`transid_allocfrom`),\n KEY `TransID_AllocTo` (`transid_allocto`),\n KEY `DateAlloc` (`datealloc`),\n CONSTRAINT `suppallocs_ibfk_1` FOREIGN KEY (`transid_allocfrom`) REFERENCES `supptrans` (`ID`),\n CONSTRAINT `suppallocs_ibfk_2` FOREIGN KEY (`transid_allocto`) REFERENCES `supptrans` (`ID`)\n)", $db);
CreateTable('suppliercontacts', "CREATE TABLE `suppliercontacts` (\n `supplierid` varchar(10) NOT NULL default '',\n `contact` varchar(30) NOT NULL default '',\n `position` varchar(30) NOT NULL default '',\n `tel` varchar(30) NOT NULL default '',\n `fax` varchar(30) NOT NULL default '',\n `mobile` varchar(30) NOT NULL default '',\n `email` varchar(55) NOT NULL default '',\n `ordercontact` tinyint(1) NOT NULL default '0',\n PRIMARY KEY (`supplierid`,`contact`),\n KEY `Contact` (`contact`),\n KEY `SupplierID` (`supplierid`),\n CONSTRAINT `suppliercontacts_ibfk_1` FOREIGN KEY (`supplierid`) REFERENCES `suppliers` (`SupplierID`)\n)", $db);
CreateTable('suppliers', "CREATE TABLE `suppliers` (\n `supplierid` char(10) NOT NULL default '',\n `suppname` char(40) NOT NULL default '',\n `address1` char(40) NOT NULL default '',\n `address2` char(40) NOT NULL default '',\n `address3` char(40) NOT NULL default '',\n `address4` char(50) NOT NULL default '',\n `currcode` char(3) NOT NULL default '',\n `suppliersince` date NOT NULL default '0000-00-00',\n `paymentterms` char(2) NOT NULL default '',\n `lastpaid` double(16,4) NOT NULL default '0.0000',\n `lastpaiddate` datetime default NULL,\n `bankact` char(16) NOT NULL default '',\n `bankref` char(12) NOT NULL default '',\n `bankpartics` char(12) NOT NULL default '',\n `remittance` tinyint(4) NOT NULL default '1',\n `taxauthority` tinyint(4) NOT NULL default '1',\n PRIMARY KEY (`supplierid`),\n KEY `CurrCode` (`currcode`),\n KEY `PaymentTerms` (`paymentterms`),\n KEY `SupplierID` (`supplierid`),\n KEY `SuppName` (`suppname`),\n KEY `TaxAuthority` (`taxauthority`),\n CONSTRAINT `suppliers_ibfk_1` FOREIGN KEY (`currcode`) REFERENCES `currencies` (`currabrev`),\n CONSTRAINT `suppliers_ibfk_2` FOREIGN KEY (`paymentterms`) REFERENCES `paymentterms` (`termsindicator`),\n CONSTRAINT `suppliers_ibfk_3` FOREIGN KEY (`taxauthority`) REFERENCES `taxauthorities` (`TaxID`)\n)", $db);
CreateTable('supptrans', "CREATE TABLE `supptrans` (\n `transno` int(11) NOT NULL default '0',\n `type` smallint(6) NOT NULL default '0',\n `supplierno` varchar(10) NOT NULL default '',\n `suppreference` varchar(20) NOT NULL default '',\n `trandate` date NOT NULL default '0000-00-00',\n `duedate` date NOT NULL default '0000-00-00',\n `settled` tinyint(4) NOT NULL default '0',\n `rate` double(16,6) NOT NULL default '1.000000',\n `ovamount` double(16,4) NOT NULL default '0.0000',\n `ovgst` double(16,4) NOT NULL default '0.0000',\n `diffonexch` double(16,4) NOT NULL default '0.0000',\n `alloc` double(16,4) NOT NULL default '0.0000',\n `transtext` longblob,\n `hold` tinyint(4) NOT NULL default '0',\n `id` int(11) NOT NULL auto_increment,\n PRIMARY KEY (`id`),\n UNIQUE KEY `TypeTransNo` (`transno`,`type`),\n KEY `DueDate` (`duedate`),\n KEY `Hold` (`hold`),\n KEY `SupplierNo` (`supplierno`),\n KEY `Settled` (`settled`),\n KEY `SupplierNo_2` (`supplierno`,`suppreference`),\n KEY `SuppReference` (`suppreference`),\n KEY `TranDate` (`trandate`),\n KEY `TransNo` (`transno`),\n KEY `Type` (`type`),\n CONSTRAINT `supptrans_ibfk_1` FOREIGN KEY (`type`) REFERENCES `systypes` (`TypeID`),\n CONSTRAINT `supptrans_ibfk_2` FOREIGN KEY (`supplierno`) REFERENCES `suppliers` (`supplierid`)\n)", $db);
CreateTable('systypes', "CREATE TABLE `systypes` (\n `typeid` smallint(6) NOT NULL default '0',\n `typename` char(50) NOT NULL default '',\n `typeno` int(11) NOT NULL default '1',\n PRIMARY KEY (`typeid`),\n KEY `TypeNo` (`typeno`)\n)", $db);
CreateTable('taxauthlevels', "CREATE TABLE `taxauthlevels` (\n `taxauthority` tinyint(4) NOT NULL default '1',\n `dispatchtaxauthority` tinyint(4) NOT NULL default '1',\n `level` tinyint(4) NOT NULL default '0',\n `taxrate` double NOT NULL default '0',\n PRIMARY KEY (`taxauthority`,`dispatchtaxauthority`,`level`),\n KEY `TaxAuthority` (`taxauthority`),\n KEY `DispatchTaxAuthority` (`dispatchtaxauthority`),\n CONSTRAINT `taxauthlevels_ibfk_1` FOREIGN KEY (`taxauthority`) REFERENCES `taxauthorities` (`TaxID`),\n CONSTRAINT `taxauthlevels_ibfk_2` FOREIGN KEY (`dispatchtaxauthority`) REFERENCES `taxauthorities` (`TaxID`)\n)", $db);
CreateTable('taxauthorities', "CREATE TABLE `taxauthorities` (\n `taxid` tinyint(4) NOT NULL auto_increment,\n `description` varchar(20) NOT NULL default '',\n `taxglcode` int(11) NOT NULL default '0',\n `purchtaxglaccount` int(11) NOT NULL default '0',\n `bank` varchar(50) NOT NULL default '',\n `bankacctype` varchar(20) NOT NULL default '',\n `bankacc` varchar(50) NOT NULL default '',\n `bankswift` varchar(30) NOT NULL default '',\n PRIMARY KEY (`taxid`),\n KEY `TaxGLCode` (`taxglcode`),\n KEY `PurchTaxGLAccount` (`purchtaxglaccount`),\n CONSTRAINT `taxauthorities_ibfk_1` FOREIGN KEY (`taxglcode`) REFERENCES `chartmaster` (`accountcode`)\n)", $db);
CreateTable('unitsofmeasure', "CREATE TABLE `unitsofmeasure` (\n `unitid` tinyint(4) NOT NULL auto_increment,\n `unitname` varchar(15) NOT NULL default '',\n PRIMARY KEY (`unitid`)\n)", $db);
CreateTable('workcentres', "CREATE TABLE `workcentres` (\n `code` char(5) NOT NULL default '',\n `location` char(5) NOT NULL default '',\n `description` char(20) NOT NULL default '',\n `capacity` double(16,4) NOT NULL default '1.0000',\n `overheadperhour` decimal(20,4) NOT NULL default '0.0000',\n `overheadrecoveryact` int(11) NOT NULL default '0',\n `setuphrs` decimal(20,4) NOT NULL default '0.0000',\n PRIMARY KEY (`code`),\n KEY `Description` (`description`),\n KEY `Location` (`location`),\n CONSTRAINT `workcentres_ibfk_1` FOREIGN KEY (`location`) REFERENCES `locations` (`loccode`)\n)", $db);
CreateTable('worksorders', "CREATE TABLE `worksorders` (\n `woref` char(20) NOT NULL default '',\n `loccode` char(5) NOT NULL default '',\n `unitsreqd` smallint(6) NOT NULL default '1',\n `unitsrecd` double NOT NULL default '0',\n `stockid` char(20) NOT NULL default '',\n `stdcost` decimal(20,4) NOT NULL default '0.0000',\n `requiredby` date NOT NULL default '0000-00-00',\n `releaseddate` date NOT NULL default '1800-01-01',\n `accumvalueissued` decimal(20,4) NOT NULL default '0.0000',\n `accumvaluetrfd` decimal(20,4) NOT NULL default '0.0000',\n `closed` tinyint(4) NOT NULL default '0',\n `released` tinyint(4) NOT NULL default '0',\n PRIMARY KEY (`woref`),\n KEY `StockID` (`stockid`),\n KEY `LocCode` (`loccode`),\n KEY `ReleasedDate` (`releaseddate`),\n KEY `RequiredBy` (`requiredby`),\n KEY `WORef` (`woref`,`loccode`),\n CONSTRAINT `workorders_ibfk_1` FOREIGN KEY (`loccode`) REFERENCES `locations` (`loccode`),\n CONSTRAINT `workorders_ibfk_2` FOREIGN KEY (`stockid`) REFERENCES `stockmaster` (`stockid`)\n)", $db);
CreateTable('www_users', "CREATE TABLE `www_users` (\n `userid` varchar(20) NOT NULL default '',\n `password` text NOT NULL,\n `realname` varchar(35) NOT NULL default '',\n `customerid` varchar(10) NOT NULL default '',\n `phone` varchar(30) NOT NULL default '',\n `email` varchar(55) default NULL,\n `defaultlocation` varchar(5) NOT NULL default '',\n `fullaccess` int(11) NOT NULL default '1',\n `lastvisitdate` datetime default NULL,\n `branchcode` varchar(10) NOT NULL default '',\n `pagesize` varchar(20) NOT NULL default 'A4',\n `modulesallowed` varchar(20) NOT NULL default '',\n `blocked` tinyint(4) NOT NULL default '0',\n `displayrecordsmax` int(11) NOT NULL default '0',\n `theme` varchar(30) NOT NULL default 'fresh',\n `language` char(2) NOT NULL default 'en',\n `pinno` varchar(30) NOT NULL default '',\n `swipecard` varchar(50) NOT NULL default '',\n PRIMARY KEY (`userid`),\n KEY `CustomerID` (`customerid`),\n KEY `DefaultLocation` (`defaultlocation`),\n CONSTRAINT `www_users_ibfk_1` FOREIGN KEY (`defaultlocation`) REFERENCES `locations` (`loccode`)\n)", $db);
NewConfigValue('DBUpdateNumber', 0, $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
executeSQL("INSERT INTO securitytokens VALUES(0, 'Main Index Page')", $db);
executeSQL("INSERT INTO securitygroups (SELECT secroleid,0 FROM securityroles)", $db);
NewScript('reportwriter/admin/ReportCreator.php', '15', $db);
NewScript('RecurringSalesOrdersProcess.php', '1', $db);
RemoveScript('Z_CopyBOM.php', $db);
NewScript('CopyBOM.php', 15, $db);
CreateTable('departments', "CREATE TABLE departments (\n`departmentid` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,\n`description` VARCHAR (100) NOT NULL DEFAULT '',\n`authoriser` varchar (20) NOT NULL DEFAULT ''\n)", $db);
CreateTable('stockrequest', "CREATE TABLE stockrequest (\n`dispatchid` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,\n`loccode` VARCHAR (5) NOT NULL DEFAULT '',\n`departmentid` INT NOT NULL DEFAULT 0,\n`despatchdate` DATE NOT NULL DEFAULT '0000-00-00',\n`authorised` TINYINT NOT NULL DEFAULT 0,\n`closed` TINYINT NOT NULL DEFAULT 0,\n`narrative` TEXT NOT NULL\n)", $db);
CreateTable('stockrequestitems', "CREATE TABLE stockrequestitems (\n`dispatchitemsid` INT NOT NULL DEFAULT 0,\n`dispatchid` INT NOT NULL DEFAULT 0,\n`stockid` VARCHAR (20) NOT NULL DEFAULT '',\n`quantity` DOUBLE NOT NULL DEFAULT 0,\n`qtydelivered` DOUBLE NOT NULL DEFAULT 0,\n`decimalplaces` INT(11) NOT NULL DEFAULT 0,\n`uom` VARCHAR(20) NOT NULL DEFAULT '',\n`completed` TINYINT NOT NULL DEFAULT 0\n)", $db);
NewScript('Departments.php', '1', $db);
NewScript('InternalStockRequest.php', '1', $db);
NewScript('InternalStockRequestFulfill.php', '1', $db);
NewScript('InternalStockRequestAuthorisation.php', '1', $db);
AddColumn('issueglact', 'stockcategory', 'INT', 'NOT NULL', '0', 'adjglact', $db);
executeSQL("UPDATE `stockcategory` SET `issueglact`=`adjglact`", $db);
NewConfigValue('ShowStockidOnImages', '0', $db);
NewScript('SupplierPriceList.php', '4', $db);
CreateTable('labels', "CREATE TABLE IF NOT EXISTS `labels` (\n `labelid` tinyint(11) NOT NULL AUTO_INCREMENT,\n `description` varchar(50) NOT NULL,\n `papersize` varchar(20) NOT NULL,\n `height` tinyint(11) NOT NULL,\n `width` tinyint(11) NOT NULL,\n `topmargin` tinyint(11) NOT NULL,\n `leftmargin` tinyint(11) NOT NULL,\n `rowheight` tinyint(11) NOT NULL,\n `columnwidth` tinyint(11) NOT NULL,\n PRIMARY KEY (`labelid`)\n)", $db);
CreateTable('labelfields', "CREATE TABLE IF NOT EXISTS `labelfields` (\n `labelfieldid` int(11) NOT NULL AUTO_INCREMENT,\n `labelid` tinyint(4) NOT NULL,\n `fieldvalue` varchar(20) CHARACTER SET utf8 NOT NULL,\n `vpos` tinyint(4) NOT NULL,\n `hpos` tinyint(4) NOT NULL,\n `fontsize` tinyint(4) NOT NULL,\n `barcode` tinyint(4) NOT NULL DEFAULT '0',\n PRIMARY KEY (`labelfieldid`),\n KEY `labelid` (`labelid`),\n KEY `vpos` (`vpos`)\n)", $db);
AddIndex(array('locationname'), 'locations', 'locationname', $db);
DropPrimaryKey('chartmaster', 'accountcode', $db);
DropConstraint('bankaccounts', 'bankaccounts_ibfk_1', $db);
DropConstraint('chartdetails', 'chartdetails_ibfk_1', $db);
DropConstraint('gltrans', 'gltrans_ibfk_1', $db);
DropConstraint('pcexpenses', 'pcexpenses_ibfk_1', $db);
DropConstraint('pctabs', 'pctabs_ibfk_5', $db);
DropConstraint('taxauthorities', 'taxauthorities_ibfk_1', $db);
ChangeColumnType('accountcode', 'chartmaster', 'varchar(20)', 'NOT NULL', '0', $db);
AddPrimaryKey('chartmaster', 'accountcode', $db);
AddConstraint('bankaccounts', 'bankaccounts_ibfk_1', 'accountcode', 'chartmaster', 'accountcode', $db);
AddConstraint('chartdetails', 'chartdetails_ibfk_1', 'accountcode', 'chartmaster', 'accountcode', $db);
<?php
NewConfigValue('ShopFreightModule', 'Default', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
AddPrimaryKey('geocode_param', array('geocodeid'), $db);
ChangeColumnName('geocodeid', 'geocode_param', 'TINYINT', 'NOT NULL', '0', 'geocodeid', $db, 'autoincrement');
AddIndex(array('coyname'), 'factorcompanies', 'factor_name', $db);
AddColumn('currcode', 'bankaccounts', 'CHAR(3)', 'NOT NULL', '', 'accountcode', $db);
ChangeColumnType('role', 'custcontacts', 'VARCHAR(40)', 'NOT NULL', '', $db);
ChangeColumnType('phoneno', 'custcontacts', 'VARCHAR(20)', 'NOT NULL', '', $db);
ChangeColumnType('notes', 'custcontacts', 'VARCHAR(255)', 'NOT NULL', '', $db);
DropPrimaryKey('purchdata', array('supplierno', 'stockid'), $db);
AddPrimaryKey('purchdata', array('supplierno', 'stockid', 'effectivefrom'), $db);
AddColumn('quotedate', 'salesorders', 'DATE', 'NOT NULL', "0000-00-00", 'quotation', $db);
AddColumn('confirmeddate', 'salesorders', 'DATE', 'NOT NULL', "0000-00-00", 'deliverydate', $db);
CreateTable('woserialnos', "CREATE TABLE `woserialnos` (\n\t`wo` INT NOT NULL ,\n\t`stockid` VARCHAR( 20 ) NOT NULL ,\n\t`serialno` VARCHAR( 30 ) NOT NULL ,\n\t`quantity` DOUBLE NOT NULL DEFAULT '1',\n\t`qualitytext` TEXT NOT NULL,\n\t PRIMARY KEY (`wo`,`stockid`,`serialno`)\n)", $db);
NewConfigValue('AutoCreateWOs', 1, $db);
NewConfigValue('DefaultFactoryLocation', 'MEL', $db);
NewConfigValue('FactoryManagerEmail', '*****@*****.**', $db);
NewConfigValue('DefineControlledOnWOEntry', '1', $db);
AddColumn('nextserialno', 'stockmaster', 'BIGINT', 'NOT NULL', "0", 'shrinkfactor', $db);
AddColumn('qualitytext', 'stockserialitems', 'TEXT', 'NOT NULL', '', 'quantity', $db);
ChangeColumnType('orderno', 'salesorders', 'INT( 11 )', 'NOT NULL', '', $db);
CreateTable('purchorderauth', "CREATE TABLE `purchorderauth` (\n\t`userid` varchar(20) NOT NULL DEFAULT '',\n\t`currabrev` char(3) NOT NULL DEFAULT '',\n\t`cancreate` smallint(2) NOT NULL DEFAULT 0,\n\t`authlevel` int(11) NOT NULL DEFAULT 0,\n\tPRIMARY KEY (`userid`,`currabrev`)\n)", $db);
AddColumn('version', 'purchorders', 'DECIMAL(3,2)', 'NOT NULL', "1.0", 'contact', $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);
CreateTable('stockmovestaxes', "CREATE TABLE stockmovestaxes (\n\tstkmoveno int NOT NULL,\n\ttaxauthid tinyint NOT NULL,\n\ttaxontax TINYINT DEFAULT 0 NOT NULL,\n\ttaxcalculationorder TINYINT NOT NULL,\n\ttaxrate double DEFAULT 0 NOT NULL,\n\tPRIMARY KEY (stkmoveno,taxauthid),\n\tKEY (taxauthid),\n\tKEY (taxcalculationorder)\n)", $db);
AddConstraint('stockmovestaxes', 'stockmovestaxes_ibfk_1', 'taxauthid', 'taxauthorities', 'taxid', $db);
DropColumn('taxrate', 'stockmoves', $db);
CreateTable('debtortranstaxes', "CREATE TABLE debtortranstaxes (\n\t`debtortransid` INT NOT NULL ,\n\t`taxauthid` TINYINT NOT NULL ,\n\t`taxamount` DOUBLE NOT NULL,\n\tPRIMARY KEY(debtortransid, taxauthid),\n\tKEY (taxauthid)\n)", $db);
AddConstraint('debtortranstaxes', 'debtortranstaxes_ibfk_1', 'taxauthid', 'taxauthorities', 'taxid', $db);
AddConstraint('debtortranstaxes', 'debtortranstaxes_ibfk_2', 'debtortransid', 'debtortrans', 'id', $db);
DropConstraint('custbranch', 'custbranch_ibfk_5', $db);
ChangeColumnName('taxauthority', 'custbranch', 'TINYINT(4)', 'NOT NULL', '1', 'taxgroupid', $db);
DropIndex('custbranch', 'area_2', $db);
DropIndex('custbranch', 'taxauthority', $db);
AddIndex(array('taxgroupid'), 'custbranch', 'taxgroupid', $db);
//InsertRecord('taxgroups', array('taxgroupid', 'taxgroupdescription'), array(NULL,'Default tax group'), array('taxgroupid', 'taxgroupdescription'), array(NULL,'Default tax group'), $db);
AddConstraint('custbranch', 'custbranch_ibfk_7', 'taxgroupid', 'taxgroups', 'taxgroupid', $db);
RenameTable('taxauthlevels', 'taxauthrates', $db);
AddConstraint('taxauthrates', 'taxauthrates_ibfk_1', 'dispatchtaxprovince', 'taxprovinces', 'taxprovinceid', $db);
ChangeColumnName('taxlevel', 'stockmaster', 'TINYINT(4)', 'NOT NULL', '1', 'taxcatid', $db);
AddIndex(array('taxcatid'), 'stockmaster', 'stockmaster_ibix_1', $db);
AddConstraint('stockmaster', 'stockmaster_ibfk_2', 'taxcatid', 'taxcategories', 'taxcatid', $db);
DropPrimaryKey('salesorderdetails', array('orderno', 'stkcode'), $db);
AddColumn('orderlineno', 'salesorderdetails', 'INT(11)', 'NOT NULL', '0', 'orderno', $db);
AddPrimaryKey('salesorderdetails', array('orderno', 'orderlineno'), $db);
NewConfigValue('FreightTaxCategory', '1', $db);
NewConfigValue('SO_AllowSameItemMultipleTimes', '1', $db);
CreateTable('supptranstaxes', "CREATE TABLE `supptranstaxes` (\n `supptransid` int(11) NOT NULL default '0',\n `taxauthid` tinyint(4) NOT NULL default '0',\n `taxamount` double NOT NULL default '0',\n PRIMARY KEY (`supptransid`,`taxauthid`),\n KEY `taxauthid` (`taxauthid`),\n CONSTRAINT `supptranstaxes_ibfk_1` FOREIGN KEY (`taxauthid`) REFERENCES `taxauthorities` (`taxid`),\n CONSTRAINT `supptranstaxes_ibfk_2` FOREIGN KEY (`supptransid`) REFERENCES `supptrans` (`id`)\n)", $db);
DropConstraint('suppliers', 'suppliers_ibfk_3', $db);
ChangeColumnName('taxauthority', 'suppliers', 'TINYINT', 'NOT NULL', '1', 'taxgroupid', $db);
DropIndex('suppliers', 'taxauthority', $db);
AddIndex(array('taxgroupid'), 'suppliers', 'taxgroupid', $db);
AddConstraint('suppliers', 'suppliers_ibfk_3', 'taxgroupid', 'taxgroups', 'taxgroupid', $db);
AddColumn('managed', 'locations', 'TINYINT', 'NOT NULL', '0', 'taxprovinceid', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
NewConfigValue('ShopShowLeftCategoryMenu', '1', $db);
NewConfigValue('ShopStockLocations', '1', $db);
DeleteConfigValue('ShopAdditionalStockLocations', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
NewConfigValue('ShopShowOnlyAvailableItems', '0', $db);
NewConfigValue('ShopShowQOHColumn', '1', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
/* New config values for logging any prnMsg messages
* Defines the patth and the messages to be logged
*/
NewConfigValue('LogPath', '', $db);
NewConfigValue('LogSeverity', '0', $db);
UpdateDBNo(7, $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);
CreateTable('reports', "CREATE TABLE `reports` (\n `id` int(5) NOT NULL auto_increment,\n `reportname` varchar(30) NOT NULL default '',\n `reporttype` char(3) NOT NULL default 'rpt',\n `groupname` varchar(9) NOT NULL default 'misc',\n `defaultreport` enum('1','0') NOT NULL default '0',\n `papersize` varchar(15) NOT NULL default 'A4,210,297',\n `paperorientation` enum('P','L') NOT NULL default 'P',\n `margintop` int(3) NOT NULL default '10',\n `marginbottom` int(3) NOT NULL default '10',\n `marginleft` int(3) NOT NULL default '10',\n `marginright` int(3) NOT NULL default '10',\n `coynamefont` varchar(20) NOT NULL default 'Helvetica',\n `coynamefontsize` int(3) NOT NULL default '12',\n `coynamefontcolor` varchar(11) NOT NULL default '0,0,0',\n `coynamealign` enum('L','C','R') NOT NULL default 'C',\n `coynameshow` enum('1','0') NOT NULL default '1',\n `title1desc` varchar(50) NOT NULL default '%reportname%',\n `title1font` varchar(20) NOT NULL default 'Helvetica',\n `title1fontsize` int(3) NOT NULL default '10',\n `title1fontcolor` varchar(11) NOT NULL default '0,0,0',\n `title1fontalign` enum('L','C','R') NOT NULL default 'C',\n `title1show` enum('1','0') NOT NULL default '1',\n `title2desc` varchar(50) NOT NULL default 'Report Generated %date%',\n `title2font` varchar(20) NOT NULL default 'Helvetica',\n `title2fontsize` int(3) NOT NULL default '10',\n `title2fontcolor` varchar(11) NOT NULL default '0,0,0',\n `title2fontalign` enum('L','C','R') NOT NULL default 'C',\n `title2show` enum('1','0') NOT NULL default '1',\n `filterfont` varchar(10) NOT NULL default 'Helvetica',\n `filterfontsize` int(3) NOT NULL default '8',\n `filterfontcolor` varchar(11) NOT NULL default '0,0,0',\n `filterfontalign` enum('L','C','R') NOT NULL default 'L',\n `datafont` varchar(10) NOT NULL default 'Helvetica',\n `datafontsize` int(3) NOT NULL default '10',\n `datafontcolor` varchar(10) NOT NULL default 'black',\n `datafontalign` enum('L','C','R') NOT NULL default 'L',\n `totalsfont` varchar(10) NOT NULL default 'Helvetica',\n `totalsfontsize` int(3) NOT NULL default '10',\n `totalsfontcolor` varchar(11) NOT NULL default '0,0,0',\n `totalsfontalign` enum('L','C','R') NOT NULL default 'L',\n `col1width` int(3) NOT NULL default '25',\n `col2width` int(3) NOT NULL default '25',\n `col3width` int(3) NOT NULL default '25',\n `col4width` int(3) NOT NULL default '25',\n `col5width` int(3) NOT NULL default '25',\n `col6width` int(3) NOT NULL default '25',\n `col7width` int(3) NOT NULL default '25',\n `col8width` int(3) NOT NULL default '25',\n `table1` varchar(25) NOT NULL default '',\n `table2` varchar(25) default NULL,\n `table2criteria` varchar(75) default NULL,\n `table3` varchar(25) default NULL,\n `table3criteria` varchar(75) default NULL,\n `table4` varchar(25) default NULL,\n `table4criteria` varchar(75) default NULL,\n `table5` VARCHAR(25) ,\n `table5criteria` VARCHAR(75) ,\n `table6` VARCHAR(25),\n `table6criteria` VARCHAR(75),\n PRIMARY KEY (`id`),\n KEY `name` (`reportname`,`groupname`)\n)", $db);
CreateTable('reportfields', "CREATE TABLE `reportfields` (\n `id` int(8) NOT NULL auto_increment,\n `reportid` int(5) NOT NULL default '0',\n `entrytype` varchar(15) NOT NULL default '',\n `seqnum` int(3) NOT NULL default '0',\n `fieldname` varchar(35) NOT NULL default '',\n `displaydesc` varchar(25) NOT NULL default '',\n `visible` enum('1','0') NOT NULL default '1',\n `columnbreak` enum('1','0') NOT NULL default '1',\n `params` text,\n PRIMARY KEY (`id`),\n KEY `reportid` (`reportid`)\n)", $db);
CreateTable('reportlinks', "CREATE TABLE IF NOT EXISTS `reportlinks` (\n `table1` varchar(25) NOT NULL default '',\n `table2` varchar(25) NOT NULL default '',\n `equation` varchar(75) NOT NULL default ''\n)", $db);
/* Need to find a way of making this rdbms agnostic
* but for the time being do it as mysql only
*/
if ($DBType == 'mysql' or $DBType == 'mysqli') {
$sql = "INSERT INTO reportlinks SELECT table_name, referenced_table_name, concat(table_name, '.', column_name, '=' , referenced_table_name, '.', referenced_column_name) FROM information_schema.key_column_usage WHERE referenced_table_name is not null and table_schema = '" . $_SESSION['DatabaseName'] . "'";
executeSQL($sql, $db);
}
NewConfigValue('WikiApp', 'Disabled', $db);
NewConfigValue('WikiPath', 'wiki', $db);
NewConfigValue('ProhibitJournalsToControlAccounts', '0', $db);
NewConfigValue('InvoicePortraitFormat', '0', $db);
NewConfigValue('ProhibitPostingsBefore', '2006-01-01', $db);
NewConfigValue('WeightedAverageCosting', '1', $db);
NewConfigValue('AllowOrderLineItemNarrative', '1', $db);
NewConfigValue('vtiger_integration', '0', $db);
NewConfigValue('DB_Maintenance', '-1', $db);
NewConfigValue('HTTPS_Only', '0', $db);
AddIndex(array('serialno'), 'stockserialitems', 'serialno', $db);
AddIndex(array('serialno'), 'stockserialmoves', 'serialno', $db);
InsertRecord('taxcategories', array('taxcatname'), array('Freight'), array('taxcatname'), array('Freight'), $db);
DropIndex('custbranch', 'BranchCode', $db);
AddColumn('stdcostunit', 'grns', 'double', 'NOT NULL', '0', 'supplierid', $db);
DropConstraint('stockcheckfreeze', 'stockcheckfreeze_ibfk_1', $db);
DropPrimaryKey('stockcheckfreeze', array('stockid'), $db);
AddPrimaryKey('stockcheckfreeze', array('stockid', 'loccode'), $db);
AddConstraint('stockcheckfreeze', 'stockcheckfreeze_ibfk_1', 'stockid', 'stockmaster', 'stockid', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
/* New config value for the Purchasing managers email address
*/
NewConfigValue('PurchasingManagerEmail', '', $db);
UpdateDBNo(29, $db);
<?php
/* 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) ENGINE=InnoDB DEFAULT CHARSET=utf8", $db);
CreateTable("pickinglistdetails", "CREATE TABLE `pickinglistdetails` (\n `pickinglistno` int(11) NOT NULL DEFAULT 0,\n `pickinglistlineno` int(11) NOT NULL DEFAULT 0,\n `orderlineno` int(11) NOT NULL DEFAULT 0,\n `qtyexpected` double NOT NULL default 0.00,\n `qtypicked` double NOT NULL default 0.00,\n CONSTRAINT `pickinglistdetails_ibfk_1` FOREIGN KEY (`pickinglistno`) REFERENCES `pickinglists` (`pickinglistno`),\n PRIMARY KEY (`pickinglistno`, `pickinglistlineno`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8", $db);
InsertRecord('systypes', array('typeid', 'typename'), array(19, 'Picking List'), array('typeid', 'typename'), array(19, 'Picking List'), $db);
UpdateDBNo(18, $db);
<?php
NewConfigValue('ShopShowTopCategoryMenu', '1', $db);
NewConfigValue('ShopShowLogoAndShopName', '1', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?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
NewConfigValue('ShopPaypalCommissionAccount', '7220', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
NewConfigValue('ShopPayPalProPassword', '', $db);
NewConfigValue('ShopPayPalProSignature', '', $db);
NewConfigValue('ShopCreditCardGateway', 'PayFlowPro', $db);
NewConfigValue('ShopPayFlowUser', '', $db);
NewConfigValue('ShopPayFlowPassword', '', $db);
NewConfigValue('ShopPayFlowVendor', '', $db);
NewConfigValue('ShopPayFlowMerchant', '', $db);
NewConfigValue('ShopAllowPayPal', '1', $db);
NewConfigValue('ShopAllowCreditCards', '1', $db);
NewConfigValue('ShopAllowBankTransfer', '1', $db);
NewConfigValue('ShopAllowSurcharges', '1', $db);
NewConfigValue('ShopPayPalSurcharge', '0.034', $db);
NewConfigValue('ShopBankTransferSurcharge', '0.0', $db);
NewConfigValue('ShopCreditCardSurcharge', '0.029', $db);
NewConfigValue('ShopPayPalBankAccount', '1030', $db);
NewConfigValue('ShopCreditCardBankAccount', '1030', $db);
NewConfigValue('ShopSwipeHQMerchantID', '', $db);
NewConfigValue('ShopSwipeHQAPIKey', '', $db);
NewConfigValue('ShopSurchargeStockID', '', $db);
NewConfigValue('ItemDescriptionLanguages', '', $db);
NewConfigValue('SmtpSetting', '', $db);
CreateTable('stockdescriptiontranslations', "CREATE TABLE IF NOT EXISTS `stockdescriptiontranslations` (\n `stockid` varchar(20) NOT NULL DEFAULT '',\n `language_id` varchar(10) NOT NULL DEFAULT 'en_GB.utf8',\n `descriptiontranslation` varchar(50) NOT NULL,\n PRIMARY KEY (`stockid`,`language_id`)\n)", $db);
AddColumn('language_id', 'debtorsmaster', 'VARCHAR( 10 )', 'NOT NULL', 'en_GB.utf8', 'typeid', $db);
AddColumn('salesperson', 'debtortrans', 'VARCHAR( 4 )', 'NOT NULL', 'DE', 'packages', $db);
AddIndex(array('salesperson'), 'debtortrans', 'salesperson', $db);
CreateTable('manufacturers', "CREATE TABLE IF NOT EXISTS `manufacturers` (\n `manufacturers_id` int(11) NOT NULL AUTO_INCREMENT,\n `manufacturers_name` varchar(32) NOT NULL,\n `manufacturers_url` varchar(50) NOT NULL DEFAULT '',\n `manufacturers_image` varchar(64) DEFAULT NULL,\n PRIMARY KEY (`manufacturers_id`),\n KEY (`manufacturers_name`)\n)", $db);
CreateTable('salescattranslations', "CREATE TABLE IF NOT EXISTS `salescattranslations` (\n `salescatid` tinyint(4) NOT NULL DEFAULT '0',\n `language_id` varchar(10) NOT NULL DEFAULT 'en_GB.utf8',\n `salescattranslation` varchar(40) NOT NULL,\n PRIMARY KEY (`salescatid`,`language_id`)\n)", $db);
AddColumn('manufacturers_id', 'salescatprod', 'INT( 11 )', 'NOT NULL', '0', 'stockid', $db);
AddColumn('featured', 'salescatprod', 'INT( 11 )', 'NOT NULL', '0', 'manufacturers_id', $db);
AddIndex(array('manufacturers_id'), 'salescatprod', 'manufacturers_id', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
/* New supplier type field and table
*/
CreateTable('suppliertype', "CREATE TABLE `suppliertype` (\n `typeid` tinyint(4) NOT NULL AUTO_INCREMENT,\n `typename` varchar(100) NOT NULL,\n PRIMARY KEY (`typeid`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8", $db);
NewConfigValue('DefaultSupplierType', 1, $db);
InsertRecord('suppliertype', array('typeid', 'typename'), array(1, 'Default'), array('typeid', 'typename'), array(1, 'Default'), $db);
AddColumn('supptype', 'suppliers', 'tinyint(4)', 'NOT NULL', 1, 'address6', $db);
UpdateDBNo(32, $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);
NewScript('PageSecurity.php', 15, $db);
NewScript('UpgradeDatabase.php', 15, $db);
NewScript('ManualContents.php', 10, $db);
NewScript('FormMaker.php', 1, $db);
NewScript('ReportMaker.php', 1, $db);
NewScript('ReportCreator.php', 13, $db);
NewConfigValue('VersionNumber', '3.12.0', $db);
ChangeConfigValue('VersionNumber', '3.12.1', $db);
ChangeConfigValue('VersionNumber', '3.12.2', $db);
ChangeColumnName('nw', 'purchorderdetails', 'VARCHAR(50)', 'NOT NULL', '', 'netweight', $db);
ChangeColumnName('gw', 'purchorderdetails', 'VARCHAR(50)', 'NOT NULL', '', 'kgs', $db);
AddColumn('conversionfactor', 'purchorderdetails', 'DOUBLE', 'NOT NULL', '1', 'assetid', $db);
ChangeConfigValue('VersionNumber', '3.12.3', $db);
ChangeColumnName('uom', 'purchorderdetails', 'VARCHAR(50)', 'NOT NULL', '', 'suppliersunit', $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);
<?php
NewConfigValue('ShopShowInfoLinks', '1', $db);
NewConfigValue('ShopTitle', 'Shop Home', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
CreateTable('tenders', "CREATE TABLE `tenders` (\n `tenderid` int(11) NOT NULL DEFAULT '0',\n `location` varchar(5) 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 `telephone` varchar(25) NOT NULL DEFAULT '',\n `closed` int(2) NOT NULL DEFAULT '0',\n `requiredbydate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\n PRIMARY KEY (`tenderid`)\n)", $db);
CreateTable('tenderitems', "CREATE TABLE `tenderitems` (\n `tenderid` int(11) NOT NULL DEFAULT '0',\n `stockid` varchar(20) NOT NULL DEFAULT '',\n `quantity` varchar(40) NOT NULL DEFAULT '',\n `units` varchar(20) NOT NULL DEFAULT 'each',\n PRIMARY KEY (`tenderid`,`stockid`)\n)", $db);
CreateTable('tendersuppliers', "CREATE TABLE `tendersuppliers` (\n `tenderid` int(11) NOT NULL DEFAULT '0',\n `supplierid` varchar(10) NOT NULL DEFAULT '',\n `email` varchar(40) NOT NULL DEFAULT '',\n `responded` int(2) NOT NULL DEFAULT '0',\n PRIMARY KEY (`tenderid`,`supplierid`)\n)", $db);
NewScript('SupplierTenderCreate.php', '4', $db);
AddColumn('cancreatetender', 'www_users', 'TINYINT(1)', 'NOT NULL', '0', 'fullaccess', $db);
NewConfigValue('StandardCostDecimalPlaces', '2', $db);
ChangeConfigValue('VersionNumber', '4.07', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
