PHP UpdateDBNo函数代码示例

<?php

/* Move the version number to the database from the config.php file
 */
NewConfigValue('VersionNumber', '4.00-RC1', $db);
UpdateDBNo(34, $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

/* Include the new script for printing quotations in Portrait
 */
InsertRecord('pagesecurity', array('script', 'security'), array('ConfirmProForma_Invoice.php', 2), array('script', 'security'), array('ConfirmProForma_Invoice.php', 2), $db);
InsertRecord('systypes', array('typeid'), array('13'), array('typeid', 'typename', 'typeno'), array('13', 'Proforma Invoices', '0'), $db);
CreateTable('proformatrans', "CREATE TABLE `proformatrans` (\n  `id` int(11) NOT NULL AUTO_INCREMENT,\n  `transno` int(11) NOT NULL DEFAULT '0',\n  `type` smallint(6) NOT NULL DEFAULT '0',\n  `stockid` varchar(20) NOT NULL DEFAULT '',\n  `debtorno` varchar(10) NOT NULL DEFAULT '',\n  `branchcode` varchar(10) NOT NULL DEFAULT '',\n  `trandate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\n  `inputdate` datetime NOT NULL,\n  `prd` smallint(6) NOT NULL DEFAULT '0',\n  `settled` tinyint(4) NOT NULL DEFAULT '0',\n  `reference` varchar(20) NOT NULL DEFAULT '',\n  `tpe` char(2) NOT NULL DEFAULT '',\n  `order_` int(11) NOT NULL DEFAULT '0',\n  `rate` double NOT NULL DEFAULT '0',\n  `ovamount` double NOT NULL DEFAULT '0',\n  `ovgst` double NOT NULL DEFAULT '0',\n  `ovfreight` double NOT NULL DEFAULT '0',\n  `ovdiscount` double NOT NULL DEFAULT '0',\n  `diffonexch` double NOT NULL DEFAULT '0',\n  `alloc` double NOT NULL DEFAULT '0',\n  `invtext` text,\n  `shipvia` int(11) NOT NULL DEFAULT '0',\n  `edisent` tinyint(4) NOT NULL DEFAULT '0',\n  `consignment` varchar(15) NOT NULL DEFAULT '',\n  PRIMARY KEY (`id`),\n  KEY `DebtorNo` (`debtorno`,`branchcode`),\n  KEY `Order_` (`order_`),\n  KEY `Prd` (`prd`),\n  KEY `Tpe` (`tpe`),\n  KEY `Type` (`type`),\n  KEY `Settled` (`settled`),\n  KEY `TranDate` (`trandate`),\n  KEY `TransNo` (`transno`),\n  KEY `Type_2` (`type`,`transno`),\n  KEY `EDISent` (`edisent`),\n  CONSTRAINT `proformatrans_ibfk_2` FOREIGN KEY (`type`) REFERENCES `systypes` (`typeid`),\n  CONSTRAINT `proformatrans_ibfk_3` FOREIGN KEY (`prd`) REFERENCES `periods` (`periodno`),\n  CONSTRAINT `proformatrans_ibfk_4` FOREIGN KEY (`stockid`) REFERENCES `stockmaster` (`stockid`)\n) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8", $db);
UpdateDBNo(108, $db);

<?php

/* Ensure that all tablse use the utf8_general_cli
 * character set
 */
$sql = 'SHOW TABLES';
$result = DB_Query($sql, $db);
while ($table = DB_fetch_array($result)) {
    if (CharacterSet($table[0], $db) != 'utf8_general_ci') {
        $response = executeSQL('ALTER TABLE ' . $table[0] . ' CONVERT TO CHARACTER SET utf8', $db);
        if ($response == 0) {
            OutputResult(_('The character set of') . ' ' . $table[0] . ' ' . _('has been changed to utf8_general_ci'), 'success');
        } else {
            OutputResult(_('The character set of') . ' ' . $table[0] . ' ' . _('could not be changed to utf8_general_ci'), 'error');
        }
    } else {
        OutputResult(_('The character set of') . ' ' . $table[0] . ' ' . _('is already utf8_general_ci'), 'info');
    }
}
UpdateDBNo(1, $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

/* Remove foreign key from debtortrans table
 */
DropConstraint('debtortrans', 'debtortrans_ibfk_1', $db);
UpdateDBNo(53, $db);

<?php

/* Include the new script for printing quotations in Portrait
 */
InsertRecord('pagesecurity', array('script', 'security'), array('GLJournalInquiry.php', 10), array('script', 'security'), array('GLJournalInquiry.php', 10), $db);
InsertRecord('pagesecurity', array('script', 'security'), array('PDFGLJournal.php', 10), array('script', 'security'), array('PDFGLJournal.php', 10), $db);
UpdateDBNo(90, $db);

<?php

AddColumn('uomdecimalplaces', 'purchdata', 'tinyint( 4 )', 'NOT NULL', '0', 'conversionfactor', $db);
UpdateDBNo(105, $db);

<?php

/* Include the new script for printing quotations in Portrait
 */
InsertRecord('pagesecurity', array('script', 'security'), array('Departments.php', 11), array('script', 'security'), array('Departments.php', 11), $db);
InsertRecord('pagesecurity', array('script', 'security'), array('StockTransfers_departments.php', 11), array('script', 'security'), array('StockTransfers_departments.php', 11), $db);
InsertRecord('pagesecurity', array('script', 'security'), array('PDFStockTransfer_departments.php', 11), array('script', 'security'), array('PDFStockTransfer_departments.php', 11), $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) ENGINE=InnoDB DEFAULT CHARSET=utf8", $db);
CreateTable('dispatch', "CREATE TABLE dispatch (\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`narrative` TEXT NOT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=utf8", $db);
CreateTable('dispatchitems', "CREATE TABLE dispatchitems (\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) ENGINE=InnoDB DEFAULT CHARSET=utf8", $db);
UpdateDBNo(95, $db);

<?php

/* Include the new script for printing quotations in Portrait
 */
AddColumn('email', 'custcontacts', 'varchar(55)', 'not null', '', 'notes', $db);
UpdateDBNo(107, $db);

<?php

/* Include the new script for printing quotations in Portrait
 */
InsertRecord('pagesecurity', array('script', 'security'), array('KCMCUnbilledItems.php', 1), array('script', 'security'), array('KCMCUnbilledItems.php', 1), $db);
UpdateDBNo(120, $db);

<?php

/* Include the new script for printing quotations in Portrait
 */
InsertRecord('pagesecurity', array('script', 'security'), array('SalesByTypePeriodInquiry.php', 1), array('script', 'security'), array('SalesByTypePeriodInquiry.php', 1), $db);
UpdateDBNo(104, $db);

<?php

/* Ensure the correct conversion factor is stored in the purchase
 * order line record
 */
if (!isset($SQLFile)) {
    $sql = "SELECT podetailitem,\n\t\t\titemcode,\n\t\t\tpurchorders.supplierno\n\t\tFROM purchorderdetails\n\t\tLEFT JOIN purchorders\n\t\t\tON purchorders.orderno=purchorderdetails.orderno\n\t\tWHERE conversionfactor=0";
    $result = DB_query($sql, $db);
    while ($myrow = DB_fetch_array($result)) {
        $ConversionFactorSQL = "SELECT conversionfactor\n\t\t\t\t\t\t\tFROM purchdata\n\t\t\t\t\t\t\tWHERE supplierno='" . $myrow['supplierno'] . "'\n\t\t\t\t\t\t\t\tAND stockid='" . $myrow['itemcode'] . "'";
        $ConversionFactorResult = DB_query($ConversionFactorSQL, $db);
        if (DB_num_rows($ConversionFactorResult) > 0) {
            $ConversionFactorRow = DB_fetch_array($ConversionFactorResult);
            $ConversionFactor = $ConversionFactorRow['conversionfactor'];
        } else {
            $ConversionFactor = 1;
        }
        $UpdateSQL = "UPDATE purchorderdetails\n\t\t\t\tSET conversionfactor='" . $ConversionFactor . "'\n\t\t\t\tWHERE podetailitem='" . $myrow['podetailitem'] . "'";
        $UpdateResult = executeSQL($UpdateSQL, $db);
    }
    OutputResult(_('Purchase order details have been correctly updated'), 'success');
}
UpdateDBNo(57, $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
 */
InsertRecord('pagesecurity', array('script', 'security'), array('PDFQuotationPortrait.php', 2), array('script', 'security'), array('PDFQuotationPortrait.php', 2), $db);
UpdateDBNo(63, $db);
?>
~