<?php /* Include the new script for printing quotations in Portrait */ 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) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1", $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) ENGINE=InnoDB DEFAULT CHARSET=utf8", $db); UpdateDBNo(basename(__FILE__, '.php'), $db);
$sql = "desc fixedassets stockid"; $result = DB_query($sql, $db); if (DB_num_rows($result) > 0) { $response = executeSQL("UPDATE fixedassets INNER JOIN stockmaster ON fixedassets.stockid=stockmaster.stockid SET assetcategoryid=stockmaster.categoryid,\nfixedassets.description=stockmaster.description, fixedassets.longdescription=stockmaster.longdescription", $db, False); if ($response == 0) { OutputResult(_('The fixedassets table has been updated from stockmaster'), 'success'); } else { OutputResult(_('The fixedassets table could not be updated from stockmaster'), 'error'); } } else { OutputResult(_('The fixedassets table is already correct'), 'info'); } } else { $response = executeSQL("UPDATE fixedassets INNER JOIN stockmaster ON fixedassets.stockid=stockmaster.stockid SET assetcategoryid=stockmaster.categoryid,\nfixedassets.description=stockmaster.description, fixedassets.longdescription=stockmaster.longdescription", $db, False); } Createtable('fixedassetcategories', "CREATE TABLE IF NOT EXISTS `fixedassetcategories` (\n `categoryid` char(6) NOT NULL DEFAULT '',\n `categorydescription` char(20) NOT NULL DEFAULT '',\n `costact` int(11) NOT NULL DEFAULT '0',\n `depnact` int(11) NOT NULL DEFAULT '0',\n `disposalact` int(11) NOT NULL DEFAULT '80000',\n `accumdepnact` int(11) NOT NULL DEFAULT '0',\n defaultdepnrate double NOT NULL DEFAULT '.2',\n defaultdepntype int NOT NULL DEFAULT '1',\n PRIMARY KEY (`categoryid`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8", $db); if (DB_table_exists('fixedassets', $db)) { $sql = "SELECT categoryid FROM fixedassetcategories"; $result = DB_query($sql, $db); if (DB_num_rows($result) == 0) { $response = executeSQL("INSERT INTO fixedassetcategories (categoryid, categorydescription, costact, depnact, disposalact, accumdepnact)\nSELECT categoryid, categorydescription, stockact, adjglact, materialuseagevarac, wipact FROM stockcategory WHERE stocktype='A'", $db, False); if ($response == 0) { OutputResult(_('The fixedassetcategories table has been updated from stockcategory'), 'success'); } else { OutputResult(_('The fixedassetcategories table could not be updated from stockcategory'), 'error'); } } else { OutputResult(_('The fixedassetcategories table is already correct'), 'info'); } } else { $response = executeSQL("INSERT INTO fixedassetcategories (categoryid, categorydescription, costact, depnact, disposalact, accumdepnact)\nSELECT categoryid, categorydescription, stockact, adjglact, materialuseagevarac, wipact FROM stockcategory WHERE stocktype='A'", $db, False);
createTable('paymentmethods', "CREATE TABLE `paymentmethods` (\n `paymentid` tinyint(4) NOT NULL auto_increment,\n `paymentname` varchar(15) NOT NULL default '',\n `paymenttype` int(11) NOT NULL default '1',\n `receipttype` int(11) NOT NULL default '1',\n PRIMARY KEY (`paymentid`)\n)", $db); CreateTable('paymentterms', "CREATE TABLE `paymentterms` (\n `termsindicator` char(2) NOT NULL default '',\n `terms` char(40) NOT NULL default '',\n `daysbeforedue` smallint(6) NOT NULL default '0',\n `dayinfollowingmonth` smallint(6) NOT NULL default '0',\n PRIMARY KEY (`termsindicator`),\n KEY `DaysBeforeDue` (`daysbeforedue`),\n KEY `DayInFollowingMonth` (`dayinfollowingmonth`)\n)", $db); CreateTable('periods', "CREATE TABLE `periods` (\n `periodno` smallint(6) NOT NULL default '0',\n `lastdate_in_period` date NOT NULL default '0000-00-00',\n PRIMARY KEY (`periodno`),\n KEY `LastDate_in_Period` (`lastdate_in_period`)\n)", $db); CreateTable('prices', "CREATE TABLE `prices` (\n `stockid` varchar(20) NOT NULL default '',\n `typeabbrev` char(2) NOT NULL default '',\n `currabrev` char(3) NOT NULL default '',\n `debtorno` varchar(10) NOT NULL default '',\n `price` decimal(20,4) NOT NULL default '0.0000',\n `branchcode` varchar(10) NOT NULL default '',\n PRIMARY KEY (`stockid`,`typeabbrev`,`currabrev`,`debtorno`),\n KEY `CurrAbrev` (`currabrev`),\n KEY `DebtorNo` (`debtorno`),\n KEY `StockID` (`stockid`),\n KEY `TypeAbbrev` (`typeabbrev`),\n CONSTRAINT `prices_ibfk_1` FOREIGN KEY (`stockid`) REFERENCES `stockmaster` (`StockID`),\n CONSTRAINT `prices_ibfk_2` FOREIGN KEY (`currabrev`) REFERENCES `currencies` (`currabrev`),\n CONSTRAINT `prices_ibfk_3` FOREIGN KEY (`typeabbrev`) REFERENCES `salestypes` (`TypeAbbrev`)\n)", $db); CreateTable('purchdata', "CREATE TABLE `purchdata` (\n `supplierno` char(10) NOT NULL default '',\n `stockid` char(20) NOT NULL default '',\n `price` decimal(20,4) NOT NULL default '0.0000',\n `suppliersuom` char(50) NOT NULL default '',\n `conversionfactor` double(16,4) NOT NULL default '1.0000',\n `supplierdescription` char(50) NOT NULL default '',\n `leadtime` smallint(6) NOT NULL default '1',\n `preferred` tinyint(4) NOT NULL default '0',\n PRIMARY KEY (`supplierno`,`stockid`),\n KEY `StockID` (`stockid`),\n KEY `SupplierNo` (`supplierno`),\n KEY `Preferred` (`preferred`),\n CONSTRAINT `purchdata_ibfk_1` FOREIGN KEY (`stockid`) REFERENCES `stockmaster` (`StockID`),\n CONSTRAINT `purchdata_ibfk_2` FOREIGN KEY (`supplierno`) REFERENCES `suppliers` (`SupplierID`)\n)", $db); CreateTable('purchorderdetails', "CREATE TABLE `purchorderdetails` (\n `podetailitem` int(11) NOT NULL auto_increment,\n `orderno` int(11) NOT NULL default '0',\n `itemcode` varchar(20) NOT NULL default '',\n `deliverydate` date NOT NULL default '0000-00-00',\n `itemdescription` varchar(100) NOT NULL default '',\n `glcode` int(11) NOT NULL default '0',\n `qtyinvoiced` double(16,4) NOT NULL default '0.0000',\n `unitprice` double(16,4) NOT NULL default '0.0000',\n `actprice` double(16,4) NOT NULL default '0.0000',\n `stdcostunit` double(16,4) NOT NULL default '0.0000',\n `quantityord` double(16,4) NOT NULL default '0.0000',\n `quantityrecd` double(16,4) NOT NULL default '0.0000',\n `shiptref` int(1) NOT NULL default '0',\n `jobref` varchar(20) NOT NULL default '',\n `completed` tinyint(4) NOT NULL default '0',\n PRIMARY KEY (`podetailitem`),\n KEY `DeliveryDate` (`deliverydate`),\n KEY `GLCode` (`glcode`),\n KEY `ItemCode` (`itemcode`),\n KEY `JobRef` (`jobref`),\n KEY `OrderNo` (`orderno`),\n KEY `ShiptRef` (`shiptref`),\n KEY `Completed` (`completed`),\n CONSTRAINT `purchorderdetails_ibfk_1` FOREIGN KEY (`orderno`) REFERENCES `purchorders` (`OrderNo`)\n)", $db); CreateTable('purchorders', "CREATE TABLE `purchorders` (\n `orderno` int(11) NOT NULL auto_increment,\n `supplierno` varchar(10) NOT NULL default '',\n `comments` longblob,\n `orddate` datetime NOT NULL default '0000-00-00 00:00:00',\n `rate` double(16,4) NOT NULL default '1.0000',\n `dateprinted` datetime default NULL,\n `allowprint` tinyint(4) NOT NULL default '1',\n `initiator` varchar(10) default NULL,\n `requisitionno` varchar(15) default NULL,\n `intostocklocation` varchar(5) NOT NULL default '',\n `deladd1` varchar(40) NOT NULL default '',\n `deladd2` varchar(40) NOT NULL default '',\n `deladd3` varchar(40) NOT NULL default '',\n `deladd4` varchar(40) NOT NULL default '',\n PRIMARY KEY (`orderno`),\n KEY `OrdDate` (`orddate`),\n KEY `SupplierNo` (`supplierno`),\n KEY `IntoStockLocation` (`intostocklocation`),\n KEY `AllowPrintPO` (`allowprint`),\n CONSTRAINT `purchorders_ibfk_1` FOREIGN KEY (`supplierno`) REFERENCES `suppliers` (`SupplierID`),\n CONSTRAINT `purchorders_ibfk_2` FOREIGN KEY (`intostocklocation`) REFERENCES `locations` (`loccode`)\n)", $db); CreateTable('recurringsalesorders', "CREATE TABLE `recurringsalesorders` (\n `recurrorderno` 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 `freightcost` double NOT NULL default '0',\n `fromstkloc` varchar(5) NOT NULL default '',\n `lastrecurrence` date NOT NULL default '0000-00-00',\n `stopdate` date NOT NULL default '0000-00-00',\n `frequency` tinyint(4) NOT NULL default '1',\n `autoinvoice` tinyint(4) NOT NULL default '0',\n PRIMARY KEY (`recurrorderno`),\n KEY `debtorno` (`debtorno`),\n KEY `orddate` (`orddate`),\n KEY `ordertype` (`ordertype`),\n KEY `locationindex` (`fromstkloc`),\n KEY `branchcode` (`branchcode`,`debtorno`),\n CONSTRAINT `recurringsalesorders_ibfk_1` FOREIGN KEY (`branchcode`, `debtorno`) REFERENCES `custbranch` (`branchcode`, `debtorno`)\n)", $db); CreateTable('recurrsalesorderdetails', "CREATE TABLE `recurrsalesorderdetails` (\n `recurrorderno` int(11) NOT NULL default '0',\n `stkcode` varchar(20) NOT NULL default '',\n `unitprice` double(16,4) NOT NULL default '0.0000',\n `quantity` double(16,4) NOT NULL default '0.0000',\n `discountpercent` double(16,4) NOT NULL default '0.0000',\n `narrative` text NOT NULL,\n PRIMARY KEY (`recurrorderno`,`stkcode`),\n KEY `orderno` (`recurrorderno`),\n KEY `stkcode` (`stkcode`),\n CONSTRAINT `recurrsalesorderdetails_ibfk_1` FOREIGN KEY (`recurrorderno`) REFERENCES `recurringsalesorders` (`recurrorderno`),\n CONSTRAINT `recurrsalesorderdetails_ibfk_2` FOREIGN KEY (`stkcode`) REFERENCES `stockmaster` (`stockid`)\n)", $db); CreateTable('reportcolumns', "CREATE TABLE `reportcolumns` (\n `reportid` smallint(6) NOT NULL default '0',\n `colno` smallint(6) NOT NULL default '0',\n `heading1` varchar(15) NOT NULL default '',\n `heading2` varchar(15) default NULL,\n `calculation` tinyint(1) NOT NULL default '0',\n `periodfrom` smallint(6) default NULL,\n `periodto` smallint(6) default NULL,\n `datatype` varchar(15) default NULL,\n `colnumerator` tinyint(4) default NULL,\n `coldenominator` tinyint(4) default NULL,\n `calcoperator` char(1) default NULL,\n `budgetoractual` tinyint(1) NOT NULL default '0',\n `valformat` char(1) NOT NULL default 'N',\n `constant` double NOT NULL default '0',\n PRIMARY KEY (`reportid`,`colno`),\n CONSTRAINT `reportcolumns_ibfk_1` FOREIGN KEY (`reportid`) REFERENCES `reportheaders` (`ReportID`)\n)", $db); CreateTable('reportheaders', "CREATE TABLE `reportheaders` (\n `reportid` smallint(6) NOT NULL auto_increment,\n `reportheading` varchar(80) NOT NULL default '',\n `groupbydata1` varchar(15) NOT NULL default '',\n `newpageafter1` tinyint(1) NOT NULL default '0',\n `lower1` varchar(10) NOT NULL default '',\n `upper1` varchar(10) NOT NULL default '',\n `groupbydata2` varchar(15) default NULL,\n `newpageafter2` tinyint(1) NOT NULL default '0',\n `lower2` varchar(10) default NULL,\n `upper2` varchar(10) default NULL,\n `groupbydata3` varchar(15) default NULL,\n `newpageafter3` tinyint(1) NOT NULL default '0',\n `lower3` varchar(10) default NULL,\n `upper3` varchar(10) default NULL,\n `groupbydata4` varchar(15) NOT NULL default '',\n `newpageafter4` tinyint(1) NOT NULL default '0',\n `upper4` varchar(10) NOT NULL default '',\n `lower4` varchar(10) NOT NULL default '',\n PRIMARY KEY (`reportid`),\n KEY `ReportHeading` (`reportheading`)\n)", $db); CreateTable('salesanalysis', "CREATE TABLE `salesanalysis` (\n `typeabbrev` char(2) NOT NULL default '',\n `periodno` smallint(6) NOT NULL default '0',\n `amt` double(16,4) NOT NULL default '0.0000',\n `cost` double(16,4) NOT NULL default '0.0000',\n `cust` varchar(10) NOT NULL default '',\n `custbranch` varchar(10) NOT NULL default '',\n `qty` double(16,4) NOT NULL default '0.0000',\n `disc` double(16,4) NOT NULL default '0.0000',\n `stockid` varchar(20) NOT NULL default '',\n `area` char(2) NOT NULL default '',\n `budgetoractual` tinyint(1) NOT NULL default '0',\n `salesperson` char(3) NOT NULL default '',\n `stkcategory` varchar(6) NOT NULL default '',\n `id` int(11) NOT NULL auto_increment,\n PRIMARY KEY (`id`),\n KEY `CustBranch` (`custbranch`),\n KEY `Cust` (`cust`),\n KEY `PeriodNo` (`periodno`),\n KEY `StkCategory` (`stkcategory`),\n KEY `StockID` (`stockid`),\n KEY `TypeAbbrev` (`typeabbrev`),\n KEY `Area` (`area`),\n KEY `BudgetOrActual` (`budgetoractual`),\n KEY `Salesperson` (`salesperson`),\n CONSTRAINT `salesanalysis_ibfk_1` FOREIGN KEY (`periodno`) REFERENCES `periods` (`periodno`)\n)", $db); CreateTable('salescat', "CREATE TABLE `salescat` (\n `salescatid` tinyint(4) NOT NULL auto_increment,\n `parentcatid` tinyint(4) default NULL,\n `salescatname` varchar(30) default NULL,\n PRIMARY KEY (`salescatid`)\n)", $db); CreateTable('salescatprod', "CREATE TABLE `salescatprod` (\n `salescatid` tinyint(4) NOT NULL default '0',\n `stockid` varchar(20) NOT NULL default '',\n PRIMARY KEY (`salescatid`,`stockid`),\n KEY `salescatid` (`salescatid`),\n KEY `stockid` (`stockid`),\n CONSTRAINT `salescatprod_ibfk_1` FOREIGN KEY (`stockid`) REFERENCES `stockmaster` (`stockid`),\n CONSTRAINT `salescatprod_ibfk_2` FOREIGN KEY (`salescatid`) REFERENCES `salescat` (`salescatid`)\n)", $db); CreateTable('salesglpostings', "CREATE TABLE `salesglpostings` (\n `id` int(11) NOT NULL auto_increment,\n `area` char(2) NOT NULL default '',\n `stkcat` varchar(6) NOT NULL default '',\n `discountglcode` int(11) NOT NULL default '0',\n `salesglcode` int(11) NOT NULL default '0',\n `salestype` char(2) NOT NULL default 'AN',\n PRIMARY KEY (`id`),\n UNIQUE KEY `Area_StkCat` (`area`,`stkcat`,`salestype`),\n KEY `Area` (`area`),\n KEY `StkCat` (`stkcat`),\n KEY `SalesType` (`salestype`)\n)", $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);