<?php
ChangeColumnName('forpreprint', 'paymentmethods', 'tinyint(1)', 'NOT NULL', '0', 'usepreprintedstationery', $db);
UpdateDBNo(87, $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
/* Mods to select fixed asset for disposal
*/
AddColumn('disposaldate', 'fixedassets', 'date', 'NOT NULL', '0000-00-00', 'barcode', $db);
ChangeColumnName('disposalvalue', 'fixedassets', 'double', 'NOT NULL', 0.0, 'disposalproceeds', $db);
UpdateDBNo(48, $db);
<?php
ChangeColumnName('nw', 'purchorderdetails', 'varchar(50)', 'NOT NULL', '0', 'netweight', $db);
UpdateDBNo(79, $db);
} else {
OutputResult(_('The fixed assets have already been removed from stockmoves, stockmaster, and stockcategory tables'), 'info');
}
$sql = "SELECT stockmaster.* FROM stockmaster INNER JOIN stockcategory ON stockmaster.categoryid=stockcategory.categoryid WHERE stockcategory.stocktype='A'";
$result = DB_query($sql, $db);
if (DB_num_rows($result) != 0) {
$response = executeSQL("DELETE stockmaster.* FROM stockmaster INNER JOIN stockcategory ON stockmaster.categoryid=stockcategory.categoryid WHERE stockcategory.stocktype='A'", $db, False);
if ($response == 0) {
OutputResult(_('The fixed assets have been removed from stockmaster table'), 'success');
} else {
OutputResult(_('The fixed assets could not be removed from stockmaster table'), 'error');
}
} else {
OutputResult(_('The fixed assets have already been removed from stockmaster table'), 'info');
}
ChangeColumnName('id', 'fixedassets', 'int(11)', 'NOT NULL', 0, 'assetid', $db, 'AUTO_INCREMENT');
$sql = "SELECT categoryid FROM stockcategory WHERE stocktype='A'";
$result = DB_query($sql, $db);
if (DB_num_rows($result) != 0) {
$response = executeSQL("DELETE FROM stockcategory WHERE stocktype='A'", $db, False);
if ($response == 0) {
OutputResult(_('The fixed assets have been removed from stockmaster table'), 'success');
} else {
OutputResult(_('The fixed assets could not be removed from stockmaster table'), 'error');
}
} else {
OutputResult(_('The fixed assets have already been removed from stockmaster table'), 'info');
}
DropColumn('stockid', 'fixedassets', $db);
InsertRecord('systypes', array('typeid', 'typename'), array('41', 'Asset Addition'), array('typeid', 'typename', 'typeno'), array('41', 'Asset Addition', '1'), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('42', 'Asset Category Change'), array('typeid', 'typename', 'typeno'), array('42', 'Asset Category Change', '1'), $db);
NewScript('Z_UploadResult.php', 15, $db);
NewScript('ReportletContainer.php', 1, $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);
<?php
ChangeColumnName('kgs', 'stockmaster', 'DECIMAL( 20, 4 )', 'NOT NULL', '0.0000', 'grossweight', $db);
UpdateDBNo(basename(__FILE__, '.php'), $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);
AddConstraint('gltrans', 'gltrans_ibfk_1', 'account', 'chartmaster', 'accountcode', $db);
AddConstraint('pcexpenses', 'pcexpenses_ibfk_1', 'glaccount', 'chartmaster', 'accountcode', $db);
AddConstraint('pctabs', 'pctabs_ibfk_5', 'glaccountassignment', 'chartmaster', 'accountcode', $db);
AddConstraint('taxauthorities', 'taxauthorities_ibfk_1', 'taxglcode', 'chartmaster', 'accountcode', $db);
ChangeColumnName('papersize', 'labels', 'DOUBLE', 'NOT NULL', '0', 'pagewidth', $db);
AddColumn('pageheight', 'labels', 'DOUBLE', 'NOT NULL', '0', 'pagewidth', $db);
ChangeColumnType('height', 'labels', 'DOUBLE', 'NOT NULL', '0', $db);
ChangeColumnType('width', 'labels', 'DOUBLE', 'NOT NULL', '0', $db);
ChangeColumnType('topmargin', 'labels', 'DOUBLE', 'NOT NULL', '0', $db);
ChangeColumnType('leftmargin', 'labels', 'DOUBLE', 'NOT NULL', '0', $db);
ChangeColumnType('rowheight', 'labels', 'DOUBLE', 'NOT NULL', '0', $db);
ChangeColumnType('columnwidth', 'labels', 'DOUBLE', 'NOT NULL', '0', $db);
ChangeColumnType('vpos', 'labelfields', 'DOUBLE', 'NOT NULL', '0', $db);
ChangeColumnType('hpos', 'labelfields', 'DOUBLE', 'NOT NULL', '0', $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);
<?php
CreateTable('mrpdemandtypes', "CREATE TABLE `mrpdemandtypes` (\n `mrpdemandtype` varchar(6) NOT NULL default '',\n `description` char(30) NOT NULL default '',\n PRIMARY KEY (`mrpdemandtype`),\n KEY `mrpdemandtype` (`mrpdemandtype`)\n)", $db);
CreateTable('mrpdemands', "CREATE TABLE `mrpdemands` (\n `demandid` int(11) NOT NULL AUTO_INCREMENT,\n `stockid` varchar(20) NOT NULL default '',\n `mrpdemandtype` varchar(6) NOT NULL default '',\n `quantity` double NOT NULL default '0',\n `duedate` date NOT NULL default '0000-00-00',\n PRIMARY KEY (`demandid`),\n KEY `StockID` (`stockid`)\n)", $db);
AddConstraint('mrpdemands', 'mrpdemands_ibfk_1', 'mrpdemandtype', 'mrpdemandtypes', 'mrpdemandtype', $db);
AddConstraint('mrpdemands', 'mrpdemands_ibfk_2', 'stockid', 'stockmaster', 'stockid', $db);
AddColumn('pansize', 'stockmaster', 'DOUBLE', 'NOT NULL', '0.0', 'decimalplaces', $db);
AddColumn('shrinkfactor', 'stockmaster', 'DOUBLE', 'NOT NULL', '0.0', 'pansize', $db);
CreateTable('mrpcalendar', "CREATE TABLE `mrpcalendar` (\n\tcalendardate date NOT NULL,\n\tdaynumber int(6) NOT NULL,\n\tmanufacturingflag smallint(6) NOT NULL default '1',\n\tINDEX (daynumber),\n\tPRIMARY KEY (calendardate)\n)", $db);
InsertRecord('mrpdemandtypes', array('mrpdemandtype', 'description'), array('FOR', 'Forecast'), array('mrpdemandtype', 'description'), array('FOR', 'Forecast'), $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);
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);
