<?php
NewConfigValue('ShopShowLeftCategoryMenu', '1', $db);
NewConfigValue('ShopStockLocations', '1', $db);
DeleteConfigValue('ShopAdditionalStockLocations', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
DeleteConfigValue('ShopShowLeftCategoryMenu', $db);
DeleteConfigValue('ShopShowInfoLinks', $db);
DeleteConfigValue('ShopShowTopCategoryMenu', $db);
DeleteConfigValue('ShopShowLogoAndShopName', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
CreateTable('custcontacts', "CREATE TABLE `custcontacts` (\n `contid` int(11) NOT NULL auto_increment,\n `debtorno` varchar(10) NOT NULL,\n `contactname` varchar(40) NOT NULL,\n `role` varchar(40) NOT NULL,\n `phoneno` varchar(20) NOT NULL,\n `notes` varchar(255) NOT NULL,\n PRIMARY KEY (`contid`)\n)", $db);
AddColumn('taxref', 'suppliers', 'VARCHAR(20)', 'NOT NULL', '', 'factorcompanyid', $db);
CreateTable('tags', "CREATE TABLE `tags` (\n`tagref` tinyint(4) NOT NULL auto_increment,\n`tagdescription` varchar(50) NOT NULL,\nPRIMARY KEY (`tagref`)\n)", $db);
AddColumn('tag', 'gltrans', 'TINYINT(4)', 'NOT NULL', "0", 'jobref', $db);
DropColumn('vtiger_accountid', 'custbranch', $db);
DropColumn('vtiger_accountid', 'salesorders', $db);
DropColumn('vtiger_productid', 'stockmaster', $db);
DeleteConfigValue('vtiger_integration', $db);
AddColumn('lat', 'custbranch', 'FLOAT( 10, 6 )', 'NOT NULL', "0.0", 'braddress6', $db);
AddColumn('lng', 'custbranch', 'FLOAT( 10, 6 )', 'NOT NULL', "0.0", 'lat', $db);
AddColumn('lat', 'suppliers', 'FLOAT( 10, 6 )', 'NOT NULL', "0.0", 'address6', $db);
AddColumn('lng', 'suppliers', 'FLOAT( 10, 6 )', 'NOT NULL', "0.0", 'lat', $db);
CreateTable('geocode_param', "CREATE TABLE `geocode_param` (\n `geocodeid` varchar(4) NOT NULL default '',\n `geocode_key` varchar(200) NOT NULL default '',\n `center_long` varchar(20) NOT NULL default '',\n `center_lat` varchar(20) NOT NULL default '',\n `map_height` varchar(10) NOT NULL default '',\n `map_width` varchar(10) NOT NULL default '',\n `map_host` varchar(50) NOT NULL default ''\n)", $db);
NewConfigValue('geocode_integration', '0', $db);
NewConfigValue('DefaultCustomerType', '1', $db);
CreateTable('debtortype', "CREATE TABLE `debtortype` (\n`typeid` tinyint(4) NOT NULL auto_increment,\n`typename` varchar(100) NOT NULL,\nPRIMARY KEY (`typeid`)\n)", $db);
InsertRecord('debtortype', array('typeid', 'typename'), array(NULL, 'Default'), array('typeid', 'typename'), array(NULL, 'Default'), $db);
AddColumn('typeid', 'debtorsmaster', 'TINYINT(4)', 'NOT NULL', "1", 'customerpoline', $db);
AddConstraint('debtorsmaster', 'debtorsmaster_ibfk_5', 'typeid', 'debtortype', 'typeid', $db);
AddColumn('effectivefrom', 'purchdata', 'DATE', 'NOT NULL', "0000-00-00", 'preferred', $db);
CreateTable('debtortypenotes', "CREATE TABLE `debtortypenotes` (\n`noteid` tinyint(4) NOT NULL auto_increment,\n`typeid` tinyint(4) NOT NULL default '0',\n`href` varchar(100) NOT NULL,\n`note` varchar(200) NOT NULL,\n`date` date NOT NULL default '0000-00-00',\n`priority` varchar(20) NOT NULL,\nPRIMARY KEY (`noteid`)\n)", $db);
CreateTable('custnotes', "CREATE TABLE `custnotes` (\n`noteid` tinyint(4) NOT NULL auto_increment,\n`debtorno` varchar(10) NOT NULL default '0',\n`href` varchar(100) NOT NULL,\n`note` varchar(200) NOT NULL,\n`date` date NOT NULL default '0000-00-00',\n`priority` varchar(20) NOT NULL,\nPRIMARY KEY (`noteid`)\n)", $db);
NewConfigValue('Extended_CustomerInfo', '0', $db);
NewConfigValue('Extended_SupplierInfo', '0', $db);
ChangeColumnType('area', 'salesglpostings', 'VARCHAR(3)', 'NOT NULL', '', $db);
ChangeColumnType('area', 'salesanalysis', 'VARCHAR(3)', 'NOT NULL', '', $db);
ChangeColumnType('trandate', 'debtortrans', 'DATE', 'NOT NULL', '0000-00-00', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
