Esempi di codice in PHP per AddIndex

Esempio n. 1

0

Mostra file

File: 47.php Progetto: rrsc/KwaMoja

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);

Esempio n. 2

0

Mostra file

File: 21.php Progetto: rrsc/KwaMoja

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);
AddConstraint('internalstockcatrole', 'secroleid', 'secroleid', 'securityroles', 'secroleid', $db);
NewScript('PDFQuotationPortrait.php', '2', $db);
ChangeConfigValue('VersionNumber', '4.09', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);

Esempio n. 3

0

Mostra file

File: 6.php Progetto: rrsc/KwaMoja

<?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);

Esempio n. 4

0

Mostra file

File: update_db.php Progetto: uirapuru/virgoapi

try {
    $db = DataBase::GetDbInstance();
    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();

Esempio n. 5

0

Mostra file

File: 5.php Progetto: rrsc/KwaMoja

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);

Esempio n. 6

0

Mostra file

File: 127.php Progetto: sunilburli/webERP-Medical

<?php

/* Include the new script for printing quotations in Portrait
 */
AddIndex(array('debtorno', 'typeid'), 'debtorsmaster', 'debtorsmaster_idx1', $db);
AddIndex(array('name'), 'debtorsmaster', 'debtorsmaster_idx2', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);

Esempio n. 7

0

Mostra file

File: update_db.php Progetto: uirapuru/virgoapi

<?php

echo "<h3>Updating virgo_api database</h3>";
echo "<br />";
try {
    $db = DataBase::GetDbInstance();
    AddColumn($db, "offers_photos", "foto_id", "INT");
    AddColumn($db, "offers", "description_synonim", "TEXT NULL");
    AddIndex($db, "offers", "offers_province", '`province`', '`id_lng`');
    AddIndex($db, "offers", "offers_location", '`location`', '`id_lng`');
    AddIndex($db, "offers", "offers_quarter", '`quarter`', '`id_lng`');
    AddIndex($db, "offers", "offers_object_province", '`object`', '`province`', '`id_lng`');
    AddIndex($db, "offers", "offers_object_location", '`object`', '`location`', '`id_lng`');
    AddIndex($db, "offers", "offers_province_location", '`province`', '`location`', '`id_lng`');
    AddIndex($db, "properties", "name", '`name`');
    AddIndex($db, "offers_properties", "value", "`value` ( 100 )");
    DropColumn($db, "offers_rooms_sets", "id");
    AddColumn($db, "offers", "display_number", "INT NOT", "DEFAULT 0");
    DropColumn($db, "offers", "field_destiny");
    DropColumn($db, "offers", "local_destiny");
    DropColumn($db, "offers", "hall_destiny");
    DropColumn($db, "offers", "category");
    AddColumn($db, "offers", "expiration_date", "DATE NULL");
    AddColumn($db, "offers_photos", "LinkFilmYouTube", "VARCHAR( 500 )");
    AddColumn($db, "offers_photos", "LinkMiniaturkaYouTube", "VARCHAR( 500 )");
    AddColumn($db, "offers", "loc_as_commune", "BOOL NOT", "DEFAULT 0");
    //optymalizacja dodanie kolumn flagowych do oferty
    $s2_result = $db->ExecuteQuery("SHOW columns FROM offers WHERE field='has_swfs'");
    $s2_row = $db->FetchArray($s2_result);
    $s2_add = $s2_row == null;
    //$s2_add=true;

Esempio n. 8

0

Mostra file

File: 12.php Progetto: rrsc/KwaMoja

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);
ChangeConfigValue('VersionNumber', '4.03.7', $db);
DropColumn('itemno', 'purchorderdetails', $db);
DropColumn('subtotal_amount', 'purchorderdetails', $db);

Esempio n. 9

0

Mostra file

File: 18.php Progetto: rrsc/KwaMoja

<?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);

Esempio n. 10

0

Mostra file

File: 9.php Progetto: rrsc/KwaMoja

<?php

CreateTable('audittrail', "CREATE TABLE `audittrail` (\n\t`transactiondate` datetime NOT NULL default '0000-00-00',\n\t`userid` varchar(20) NOT NULL default '',\n\t`querystring` text,\n\tKEY `UserID` (`userid`),\n  CONSTRAINT `audittrail_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `www_users` (`userid`)\n)", $db);
ChangeColumnType('contactemail', 'salesorders', 'VARCHAR(40)', 'NOT NULL', '', $db);
NewConfigValue('MonthsAuditTrail', '1', $db);
CreateTable('factorcompanies', "CREATE TABLE `factorcompanies` (\n  `id` int(11) NOT NULL auto_increment,\n  `coyname` varchar(50) 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  `contact` varchar(25) NOT NULL default '',\n  `telephone` varchar(25) NOT NULL default '',\n  `fax` varchar(25) NOT NULL default '',\n  `email` varchar(55) NOT NULL default '',\n  PRIMARY KEY  (`id`)\n)", $db);
InsertRecord('factorcompanies', array('id', 'coyname'), array(NULL, 'None'), array('id', 'coyname'), array(NULL, 'None'), $db);
AddColumn('factorcompanyid', 'suppliers', 'INT(11)', 'NOT NULL', '1', 'taxgroupid', $db);
AddConstraint('suppliers', 'suppliers_ibfk_4', 'factorcompanyid', 'factorcompanies', 'id', $db);
AddColumn('perishable', 'stockmaster', 'TINYINT(1)', 'NOT NULL', '0', 'serialised', $db);
AddColumn('appendfile', 'stockmaster', 'VARCHAR(40)', 'NOT NULL', "none", 'serialised', $db);
AddColumn('expirationdate', 'stockserialitems', 'DATETIME', 'NOT NULL', "0000-00-00", 'serialno', $db);
AddColumn('currcode', 'bankaccounts', 'CHAR( 3 )', 'NOT NULL', '', 'accountcode', $db);
AddIndex(array('currcode'), 'bankaccounts', 'currcode', $db);
ChangeColumnType('exrate', 'banktrans', 'DOUBLE', 'NOT NULL', '1.0', $db);
AddColumn('functionalexrate', 'banktrans', 'DOUBLE', 'NOT NULL', " 1", 'exrate', $db);
DropConstraint('worequirements', 'worequirements_ibfk_3', $db);
AddConstraint('worequirements', 'worequirements_ibfk_3', array('wo', 'parentstockid'), 'woitems', array('wo', 'stockid'), $db);
NewConfigValue('ProhibitNegativeStock', '1', $db);
InsertRecord('systypes', array('typeid', 'typename'), array('0', _('Journal - GL')), array('typeid', 'typename'), array('0', _('Journal - GL')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('1', _('Payment - GL')), array('typeid', 'typename'), array('1', _('Payment - GL')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('2', _('Receipt - GL')), array('typeid', 'typename'), array('2', _('Receipt - GL')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('3', _('Standing Journal')), array('typeid', 'typename'), array('3', _('Standing Journal')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('10', _('Sales Invoice')), array('typeid', 'typename'), array('10', _('Sales Invoice')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('11', _('Credit Note')), array('typeid', 'typename'), array('11', _('Credit Note')), $db);
InsertRecord('systypes', array('typeid', 'typename'), array('12', _('Receipt')), array('typeid', 'typename'), array('12', _('Receipt')), $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);

Esempio n. 11

0

Mostra file

File: 20.php Progetto: rrsc/KwaMoja

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);
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);

Esempio n. 12

0

Mostra file

File: 11.php Progetto: rrsc/KwaMoja

<?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);

Esempio n. 13

0

Mostra file

File: 2.php Progetto: rrsc/KwaMoja

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);

Esempi in PHP per AddIndex