PHP AddColumn函数代码示例

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