DropIndex PHP Code Examples

Example #1

0

Show file

File: 5.php Project: 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);

Example #2

0

Show file

File: 6.php Project: 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);

Example #3

0

Show file

File: 2.php Project: 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);

PHP DropIndex Examples