<?php /* Include the new script for printing quotations in Portrait */ AddColumn('pagewidth', 'labels', 'float', 'NOT NULL', '0', 'description', $db); AddColumn('pageheight', 'labels', 'float', 'NOT NULL', '0', 'pagewidth', $db); DropColumn('papersize', 'labels', $db); UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php /* Add input date to transaction tables so that transactions can be * reported on by their input date */ AddColumn('inputdate', 'supptrans', 'datetime', 'NOT NULL', '0000-00-00', 'duedate', $db); AddColumn('inputdate', 'debtortrans', 'datetime', 'NOT NULL', '0000-00-00', 'trandate', $db); UpdateDBNo(16, $db);
<?php AddColumn('userid', 'banktrans', 'varchar(20)', 'NOT NULL', '', 'currcode', $db); UpdateDBNo(106, $db);
<?php AddColumn('parentarea', 'areas', 'CHAR( 3 )', 'NOT NULL', '', 'areacode', $db); AddColumn('salesarea', 'salesman', 'CHAR( 3 )', 'NOT NULL', '', 'salesmanname', $db); AddColumn('manager', 'salesman', 'INT( 1 )', 'NOT NULL', '0', 'salesarea', $db); AddConstraint('salesman', 'fk_salesman_1', 'salesarea', 'areas', 'areacode', $db); UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php AddColumn('itemdue', 'salesorderdetails', 'DATE', 'NOT NULL', "0000-00-00", 'narrative', $db); AddColumn('poline', 'salesorderdetails', 'VARCHAR(10)', 'NOT NULL', '', 'itemdue', $db); AddColumn('customerpoline', 'debtorsmaster', 'TinyInt(1)', 'NOT NULL', "0", 'taxref', $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 AddColumn('chequeno', 'banktrans', 'int( 11 )', 'NOT NULL', '0', 'ref', $db); UpdateDBNo(88, $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);
AddColumn($db, "menu", "NoFollow", "TINYINT( 1 )"); AddColumn($db, "departments", "header", "TEXT"); AddColumn($db, "departments", "footer", "TEXT"); AddColumn($db, "departments", "logo_file", "VARCHAR( 50 )"); AddColumn($db, "departments", "photo_file", "VARCHAR( 50 )"); AddColumn($db, "departments", "subdomena", "VARCHAR( 30 )"); AddColumn($db, "departments", "organization_id", "INT NULL"); AddColumn($db, "departments", "name2", "VARCHAR( 255 )"); AddColumn($db, "agents", "comunicators", "VARCHAR( 500 )"); AddColumn($db, "agents", "photo_file", "VARCHAR( 50 )"); AddColumn($db, "agents", "agents_code", "INT"); AddColumn($db, "agents", "section", "VARCHAR( 50 )"); AddColumn($db, "artykuly", "galerie_GID", "INT NULL"); AddIndex($db, "artykuly", "galerie_GID", '`galerie_GID`'); AddColumn($db, "galerie", "Rozmiar1", "VARCHAR( 9 )"); AddColumn($db, "galerie", "Rozmiar2", "VARCHAR( 9 )"); AddColumn($db, "galerie", "Rozmiar3", "VARCHAR( 9 )"); AddColumn($db, "artykuly", "Tagi", "VARCHAR( 500 )"); AddColumn($db, "artykuly", "DataRozpoczeciaPublikacji", "VARCHAR( 500 )"); AddColumn($db, "galeriepozycje", "Tagi", "VARCHAR( 500 )"); $sql = "CREATE TABLE IF NOT EXISTS `osoby` (\r\n `id` INT NOT NULL ,\r\n `name` VARCHAR(50) NULL ,\r\n `last_name` VARCHAR(50) NULL ,\r\n `email` VARCHAR(50) NULL ,\r\n `phone` VARCHAR(20) NULL ,\r\n `login` VARCHAR(100) NULL ,\r\n `pwd` VARCHAR(100) NULL ,\r\n `registration_date` DATE NULL ,\r\n `user_id` INT NULL ,\r\n PRIMARY KEY ( `id`)\r\n ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci"; $result = $db->ExecuteQuery($sql); echo "Creating table osoby: OK<br />"; if ($db->LastError() != '') { throw new Exception("table osoby:" . $db->LastError()); } echo "<h4>Updating web_api database complete.</h4>"; } catch (Exception $ex) { echo "Execution error:<br />" . $ex->getMessage(); echo "<h4>Installing database failed. Check configuration (config.php file) and try again. If the problem persists, please contact with us.</h4>"; }
<?php AddColumn('chequeno', 'banktrans', 'INT(11)', 'NOT NULL', 0, 'ref', $db); ChangeColumnType('chequeno', 'banktrans', 'VARCHAR(20)', 'NOT NULL', '', $db); UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php AddColumn('closed', 'tenders', 'int(2)', 'NOT NULL', '0', 'telephone', $db); AddColumn('requiredbydate', 'tenders', 'datetime', 'NOT NULL', '0000-00-00', 'closed', $db); UpdateDBNo(71, $db);
<?php /* Add extra columns for supplier head office details */ AddColumn('email', 'suppliers', 'varchar(55)', 'NOT NULL', '', 'port', $db); AddColumn('fax', 'suppliers', 'varchar(25)', 'NOT NULL', '', 'email', $db); AddColumn('telephone', 'suppliers', 'varchar(25)', 'NOT NULL', '', 'fax', $db); UpdateDBNo(22, $db);
<?php /* Include the new script for printing quotations in Portrait */ AddColumn('issueglact', 'stockcategory', 'INT( 11 )', 'not null', 0, 'adjglact', $db); $sql = "UPDATE stockcategory\n\t\t\tSET issueglact=adjglact"; $result = DB_query($sql, $db); UpdateDBNo(111, $db);
<?php /* Add extra columns to reports */ for ($i = 9; $i <= 20; $i++) { AddColumn('col' . $i . 'width', 'reports', 'int(3)', 'NOT NULL', '25', 'col' . ($i - 1) . 'width', $db); } UpdateDBNo(39, $db);
<?php AddColumn('userid', 'stockrequest', 'VARCHAR( 20 )', 'NOT NULL', '', 'dispatchid', $db); NewMenuItem('stock', 'Transactions', _('Amend an internal stock request'), '/InternalStockRequest.php?Edit=Yes', 11, $db); UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php AddColumn('current', 'salesman', 'tinyint(4)', 'NOT NULL', '1', 'commissionrate2', $db); UpdateDBNo(103, $db);
<?php AddColumn('uomdecimalplaces', 'purchdata', 'tinyint( 4 )', 'NOT NULL', '0', 'conversionfactor', $db); UpdateDBNo(105, $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 /* Include the new script for printing quotations in Portrait */ AddColumn('email', 'custcontacts', 'varchar(55)', 'not null', '', 'notes', $db); UpdateDBNo(115, $db);
<?php AddColumn('restrictlocations', 'www_users', 'TINYINT(1)', 'NOT NULL', 1, 'defaultlocation', $db); UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php /* Add the field in the currencies that shows the number of decimal places to be shown for each currency */ AddColumn('decimalplaces', 'currencies', 'tinyint(3)', 'NOT NULL', '2', 'hundredsname', $db); UpdateDBNo(9, $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 AddColumn('authorizerexpenses', 'pctabs', 'VARCHAR(20)', 'NOT NULL', '""', 'authorizer'); $SQL = "UPDATE pctabs SET authorizerexpenses=authorizer"; executeSQL($SQL, $db); UpdateDBNo(basename(__FILE__, '.php'));
<?php AddColumn('units', 'stockmoves', 'varchar(40)', 'NOT NULL', '', 'narrative', $db); AddColumn('conversionfactor', 'stockmoves', 'double', 'NOT NULL', '1', 'units', $db); UpdateDBNo(88, $db);
<?php /* Include the new script for printing quotations in Portrait */ InsertRecord('pagesecurity', array('script', 'security'), array('doc/Manual/ManualContents.php', 1), array('script', 'security'), array('doc/Manual/ManualContents.php', 1), $db); RenameTable('dispatch', 'stockrequest', $db); RenameTable('dispatchitems', 'stockrequestitems', $db); AddColumn('decimalplaces', 'stockrequestitems', 'int', 'not null', 0, 'quantity', $db); AddColumn('uom', 'stockrequestitems', 'varchar(20)', 'not null', '', 'decimalplaces', $db); ChangeColumnType('dispatchid', 'stockrequest', 'INT (11)', 'NOT NULL', 0, $db); InsertRecord('systypes', array('typeid'), array('38'), array('typeid', 'typename', 'typeno'), array('38', 'Stock Requests', '0'), $db); UpdateDBNo(97, $db);
<?php AddColumn('defaulttag', 'www_users', 'VARCHAR( 20 )', 'NOT NULL', '', 'defaultlocation', $db); AddColumn('defaulttag', 'gltrans', 'VARCHAR( 20 )', 'NOT NULL', '', 'jobref', $db); UpdateDBNo(83, $db);
<?php /* Include the new script for printing quotations in Portrait */ AddColumn('tag', 'pcexpenses', 'TINYINT( 4 )', 'not null', 0, 'glaccount', $db); UpdateDBNo(100, $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);
<?php AddColumn('active', 'salescat', 'INT (1)', 'NOT NULL', 1, 'salescatname', $db); UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php /* Add extra field into prices table for unit of measure */ AddColumn('units', 'prices', 'varchar(20)', 'NOT NULL', 'each', 'price', $db); $sql = "UPDATE prices SET units=(SELECT units FROM stockmaster WHERE prices.stockid=stockmaster.stockid)"; $result = DB_query($sql, $db); UpdateDBNo(64, $db);