upgrade2.9b-3.0.sql

来自「java开源项目源代码」· SQL 代码 · 共 904 行 · 第 1/5 页

RENAME TABLE `AccountGroups` TO `accountgroups`;
RENAME TABLE `Areas` TO `areas`;
RENAME TABLE `BOM` TO `bom`;
RENAME TABLE `BankAccounts` TO `bankaccounts`;
RENAME TABLE `BankTrans` TO `banktrans`;
RENAME TABLE `Buckets` TO `buckets`;
RENAME TABLE `COGSGLPostings` TO `cogsglpostings`;
RENAME TABLE `ChartDetails` TO `chartdetails`;
RENAME TABLE `ChartMaster` TO `chartmaster`;
RENAME TABLE `Companies` TO `companies`;
RENAME TABLE `ContractBOM` TO `contractbom`;
RENAME TABLE `ContractReqts` TO `contractreqts`;
RENAME TABLE `Contracts` TO `contracts`;
RENAME TABLE `Currencies` TO `currencies`;
RENAME TABLE `CustAllocns` TO `custallocns`;
RENAME TABLE `CustBranch` TO `custbranch`;
RENAME TABLE `DebtorTrans` TO `debtortrans`;
RENAME TABLE `DebtorsMaster` TO `debtorsmaster`;
RENAME TABLE `DiscountMatrix` TO `discountmatrix`;
RENAME TABLE `EDIItemMapping` TO `ediitemmapping`;
RENAME TABLE `EDIMessageFormat` TO `edimessageformat`;
RENAME TABLE `EDI_ORDERS_Seg_Groups` TO `edi_orders_seg_groups`;
RENAME TABLE `EDI_ORDERS_Segs` TO `edi_orders_segs`;
RENAME TABLE `FreightCosts` TO `freightcosts`;
RENAME TABLE `GLTrans` TO `gltrans`;
RENAME TABLE `GRNs` TO `grns`;
DROP TABLE `Help`;
RENAME TABLE `HoldReasons` TO `holdreasons`;
RENAME TABLE `LastCostRollUp` TO `lastcostrollup`;
RENAME TABLE `LocStock` TO `locstock`;
RENAME TABLE `LocTransfers` TO `loctransfers`;
RENAME TABLE `Locations` TO `locations`;
RENAME TABLE `OrderDeliveryDifferencesLog` TO `orderdeliverydifferenceslog`;
RENAME TABLE `PaymentTerms` TO `paymentterms`;
RENAME TABLE `Periods` TO `periods`;
RENAME TABLE `Prices` TO `prices`;
RENAME TABLE `PurchData` TO `purchdata`;
RENAME TABLE `PurchOrderDetails` TO `purchorderdetails`;
RENAME TABLE `PurchOrders` TO `purchorders`;
RENAME TABLE `ReportColumns` TO `reportcolumns`;
RENAME TABLE `ReportHeaders` TO `reportheaders`;
RENAME TABLE `SalesAnalysis` TO `salesanalysis`;
RENAME TABLE `SalesGLPostings` TO `salesglpostings`;
RENAME TABLE `SalesOrderDetails` TO `salesorderdetails`;
RENAME TABLE `SalesOrders` TO `salesorders`;
RENAME TABLE `SalesTypes` TO `salestypes`;
RENAME TABLE `Salesman` TO `salesman`;
RENAME TABLE `Scripts` TO `scripts`;
RENAME TABLE `ShipmentCharges` TO `shipmentcharges`;
RENAME TABLE `Shipments` TO `shipments`;
RENAME TABLE `Shippers` TO `shippers`;
RENAME TABLE `StockCategory` TO `stockcategory`;
RENAME TABLE `StockCheckFreeze` TO `stockcheckfreeze`;
RENAME TABLE `StockCounts` TO `stockcounts`;
RENAME TABLE `StockMaster` TO `stockmaster`;
RENAME TABLE `StockMoves` TO `stockmoves`;
RENAME TABLE `StockSerialItems` TO `stockserialitems`;
RENAME TABLE `StockSerialMoves` TO `stockserialmoves`;
RENAME TABLE `SuppAllocs` TO `suppallocs`;
RENAME TABLE `SuppTrans` TO `supptrans`;
RENAME TABLE `SupplierContacts` TO `suppliercontacts`;
RENAME TABLE `Suppliers` TO `suppliers`;
RENAME TABLE `SysTypes` TO `systypes`;
RENAME TABLE `TaxAuthLevels` TO `taxauthlevels`;
RENAME TABLE `TaxAuthorities` TO `taxauthorities`;
RENAME TABLE `WWW_Users` TO `www_users`;
RENAME TABLE `WorkCentres` TO `workcentres`;
RENAME TABLE `WorksOrders` TO `worksorders`;
ALTER TABLE `accountgroups` CHANGE GroupName groupname char(30)  NOT NULL default '';
ALTER TABLE `accountgroups` CHANGE SectionInAccounts sectioninaccounts smallint(6)  NOT NULL default '0';
ALTER TABLE `accountgroups` CHANGE PandL pandl tinyint(4)  NOT NULL default '1';
ALTER TABLE `accountgroups` CHANGE SequenceInTB sequenceintb smallint(6)  NOT NULL default '0';
ALTER TABLE `areas` CHANGE AreaCode areacode char(2)  NOT NULL default '';
ALTER TABLE `areas` CHANGE AreaDescription areadescription varchar(25)  NOT NULL default '';
ALTER TABLE `bom` CHANGE Parent parent char(20)  NOT NULL default '';
ALTER TABLE `bom` CHANGE Component component char(20)  NOT NULL default '';
ALTER TABLE `bom` CHANGE WorkCentreAdded workcentreadded char(5)  NOT NULL default '';
ALTER TABLE `bom` CHANGE LocCode loccode char(5)  NOT NULL default '';
ALTER TABLE `bom` CHANGE EffectiveAfter effectiveafter date  NOT NULL default '0000-00-00';
ALTER TABLE `bom` CHANGE EffectiveTo effectiveto date  NOT NULL default '9999-12-31';
ALTER TABLE `bom` CHANGE Quantity quantity double(16,4)  NOT NULL default '1.0000';
ALTER TABLE `bankaccounts` CHANGE AccountCode accountcode int(11)  NOT NULL default '0';
ALTER TABLE `bankaccounts` CHANGE BankAccountName bankaccountname char(50)  NOT NULL default '';
ALTER TABLE `bankaccounts` CHANGE BankAccountNumber bankaccountnumber char(50)  NOT NULL default '';
ALTER TABLE `bankaccounts` CHANGE BankAddress bankaddress char(50)  default NULL;
ALTER TABLE `banktrans` CHANGE BankTransID banktransid bigint(20)  NOT NULL auto_increment;
ALTER TABLE `banktrans` CHANGE Type type smallint(6)  NOT NULL default '0';
ALTER TABLE `banktrans` CHANGE TransNo transno bigint(20)  NOT NULL default '0';
ALTER TABLE `banktrans` CHANGE BankAct bankact int(11)  NOT NULL default '0';
ALTER TABLE `banktrans` CHANGE Ref ref varchar(50)  NOT NULL default '';
ALTER TABLE `banktrans` CHANGE AmountCleared amountcleared float  NOT NULL default '0';
ALTER TABLE `banktrans` CHANGE ExRate exrate double  NOT NULL default '1';
ALTER TABLE `banktrans` CHANGE TransDate transdate date  NOT NULL default '0000-00-00';
ALTER TABLE `banktrans` CHANGE BankTransType banktranstype varchar(30)  NOT NULL default '';
ALTER TABLE `banktrans` CHANGE Amount amount float  NOT NULL default '0';
ALTER TABLE `banktrans` CHANGE CurrCode currcode char(3)  NOT NULL default '';
ALTER TABLE `buckets` CHANGE WorkCentre workcentre char(5)  NOT NULL default '';
ALTER TABLE `buckets` CHANGE AvailDate availdate datetime  NOT NULL default '0000-00-00 00:00:00';
ALTER TABLE `buckets` CHANGE Capacity capacity float(10,2)  NOT NULL default '0.00';
ALTER TABLE `cogsglpostings` CHANGE ID id int(11)  NOT NULL auto_increment;
ALTER TABLE `cogsglpostings` CHANGE Area area char(2)  NOT NULL default '';
ALTER TABLE `cogsglpostings` CHANGE StkCat stkcat varchar(6)  NOT NULL default '';
ALTER TABLE `cogsglpostings` CHANGE GLCode glcode int(11)  NOT NULL default '0';
ALTER TABLE `cogsglpostings` CHANGE SalesType salestype char(2)  NOT NULL default 'AN';
ALTER TABLE `chartdetails` CHANGE AccountCode accountcode int(11)  NOT NULL default '0';
ALTER TABLE `chartdetails` CHANGE Period period smallint(6)  NOT NULL default '0';
ALTER TABLE `chartdetails` CHANGE Budget budget float  NOT NULL default '0';
ALTER TABLE `chartdetails` CHANGE Actual actual float  NOT NULL default '0';
ALTER TABLE `chartdetails` CHANGE BFwd bfwd float  NOT NULL default '0';
ALTER TABLE `chartdetails` CHANGE BFwdBudget bfwdbudget float  NOT NULL default '0';
ALTER TABLE `chartmaster` CHANGE AccountCode accountcode int(11)  NOT NULL default '0';
ALTER TABLE `chartmaster` CHANGE AccountName accountname char(50)  NOT NULL default '';
ALTER TABLE `chartmaster` CHANGE Group_ group_ char(30)  NOT NULL default '';
ALTER TABLE `companies` CHANGE CoyCode coycode int(11)  NOT NULL default '1';
ALTER TABLE `companies` CHANGE CoyName coyname varchar(50)  NOT NULL default '';
ALTER TABLE `companies` CHANGE GSTNo gstno varchar(20)  NOT NULL default '';
ALTER TABLE `companies` CHANGE CompanyNumber companynumber varchar(20)  NOT NULL default '0';
ALTER TABLE `companies` CHANGE PostalAddress postaladdress varchar(50)  NOT NULL default '';
ALTER TABLE `companies` CHANGE RegOffice1 regoffice1 varchar(50)  NOT NULL default '';
ALTER TABLE `companies` CHANGE RegOffice2 regoffice2 varchar(50)  NOT NULL default '';
ALTER TABLE `companies` CHANGE RegOffice3 regoffice3 varchar(50)  NOT NULL default '';
ALTER TABLE `companies` CHANGE Telephone telephone varchar(25)  NOT NULL default '';
ALTER TABLE `companies` CHANGE Fax fax varchar(25)  NOT NULL default '';
ALTER TABLE `companies` CHANGE Email email varchar(55)  NOT NULL default '';
ALTER TABLE `companies` CHANGE CurrencyDefault currencydefault varchar(4)  NOT NULL default '';
ALTER TABLE `companies` CHANGE DebtorsAct debtorsact int(11)  NOT NULL default '70000';
ALTER TABLE `companies` CHANGE PytDiscountAct pytdiscountact int(11)  NOT NULL default '55000';
ALTER TABLE `companies` CHANGE CreditorsAct creditorsact int(11)  NOT NULL default '80000';
ALTER TABLE `companies` CHANGE PayrollAct payrollact int(11)  NOT NULL default '84000';
ALTER TABLE `companies` CHANGE GRNAct grnact int(11)  NOT NULL default '72000';
ALTER TABLE `companies` CHANGE ExchangeDiffAct exchangediffact int(11)  NOT NULL default '65000';
ALTER TABLE `companies` CHANGE PurchasesExchangeDiffAct purchasesexchangediffact int(11)  NOT NULL default '0';
ALTER TABLE `companies` CHANGE RetainedEarnings retainedearnings int(11)  NOT NULL default '90000';
ALTER TABLE `companies` CHANGE GLLink_Debtors gllink_debtors tinyint(1)  default '1';
ALTER TABLE `companies` CHANGE GLLink_Creditors gllink_creditors tinyint(1)  default '1';
ALTER TABLE `companies` CHANGE GLLink_Stock gllink_stock tinyint(1)  default '1';
ALTER TABLE `companies` CHANGE FreightAct freightact int(11)  NOT NULL default '0';
ALTER TABLE `contractbom` CHANGE ContractRef contractref char(20)  NOT NULL default '';
ALTER TABLE `contractbom` CHANGE Component component char(20)  NOT NULL default '';
ALTER TABLE `contractbom` CHANGE WorkCentreAdded workcentreadded char(5)  NOT NULL default '';
ALTER TABLE `contractbom` CHANGE LocCode loccode char(5)  NOT NULL default '';
ALTER TABLE `contractbom` CHANGE Quantity quantity double(16,4)  NOT NULL default '1.0000';
ALTER TABLE `contractreqts` CHANGE ContractReqID contractreqid int(11)  NOT NULL auto_increment;
ALTER TABLE `contractreqts` CHANGE Contract contract char(20)  NOT NULL default '';
ALTER TABLE `contractreqts` CHANGE Component component char(40)  NOT NULL default '';
ALTER TABLE `contractreqts` CHANGE Quantity quantity double(16,4)  NOT NULL default '1.0000';
ALTER TABLE `contractreqts` CHANGE PricePerUnit priceperunit decimal(20,4)  NOT NULL default '0.0000';
ALTER TABLE `contracts` CHANGE ContractRef contractref varchar(20)  NOT NULL default '';
ALTER TABLE `contracts` CHANGE ContractDescription contractdescription varchar(50)  NOT NULL default '';
ALTER TABLE `contracts` CHANGE DebtorNo debtorno varchar(10)  NOT NULL default '';
ALTER TABLE `contracts` CHANGE BranchCode branchcode varchar(10)  NOT NULL default '';
ALTER TABLE `contracts` CHANGE Status status varchar(10)  NOT NULL default 'Quotation';
ALTER TABLE `contracts` CHANGE CategoryID categoryid varchar(6)  NOT NULL default '';
ALTER TABLE `contracts` CHANGE TypeAbbrev typeabbrev char(2)  NOT NULL default '';
ALTER TABLE `contracts` CHANGE OrderNo orderno int(11)  NOT NULL default '0';
ALTER TABLE `contracts` CHANGE QuotedPriceFX quotedpricefx decimal(20,4)  NOT NULL default '0.0000';
ALTER TABLE `contracts` CHANGE Margin margin double(16,4)  NOT NULL default '1.0000';
ALTER TABLE `contracts` CHANGE WORef woref varchar(20)  NOT NULL default '';
ALTER TABLE `contracts` CHANGE RequiredDate requireddate datetime  NOT NULL default '0000-00-00 00:00:00';
ALTER TABLE `contracts` CHANGE CancelDate canceldate datetime  NOT NULL default '0000-00-00 00:00:00';
ALTER TABLE `contracts` CHANGE QuantityReqd quantityreqd double(16,4)  NOT NULL default '1.0000';
ALTER TABLE `contracts` CHANGE Specifications specifications longblob  NOT NULL;
ALTER TABLE `contracts` CHANGE DateQuoted datequoted datetime  NOT NULL default '0000-00-00 00:00:00';
ALTER TABLE `contracts` CHANGE Units units varchar(15)  NOT NULL default 'Each';
ALTER TABLE `contracts` CHANGE Drawing drawing longblob  NOT NULL;
ALTER TABLE `contracts` CHANGE Rate rate double(16,4)  NOT NULL default '1.0000';
ALTER TABLE `currencies` CHANGE Currency currency char(20)  NOT NULL default '';
ALTER TABLE `currencies` CHANGE CurrAbrev currabrev char(3)  NOT NULL default '';
ALTER TABLE `currencies` CHANGE Country country char(50)  NOT NULL default '';
ALTER TABLE `currencies` CHANGE HundredsName hundredsname char(15)  NOT NULL default 'Cents';
ALTER TABLE `currencies` CHANGE Rate rate double(16,4)  NOT NULL default '1.0000';
ALTER TABLE `custallocns` CHANGE ID id int(11)  NOT NULL auto_increment;
ALTER TABLE `custallocns` CHANGE Amt amt decimal(20,4)  NOT NULL default '0.0000';
ALTER TABLE `custallocns` CHANGE DateAlloc datealloc date  NOT NULL default '0000-00-00';
ALTER TABLE `custallocns` CHANGE TransID_AllocFrom transid_allocfrom int(11)  NOT NULL default '0';
ALTER TABLE `custallocns` CHANGE TransID_AllocTo transid_allocto int(11)  NOT NULL default '0';
ALTER TABLE `custbranch` CHANGE BranchCode branchcode varchar(10)  NOT NULL default '';
ALTER TABLE `custbranch` CHANGE DebtorNo debtorno varchar(10)  NOT NULL default '';
ALTER TABLE `custbranch` CHANGE BrName brname varchar(40)  NOT NULL default '';
ALTER TABLE `custbranch` CHANGE BrAddress1 braddress1 varchar(40)  NOT NULL default '';
ALTER TABLE `custbranch` CHANGE BrAddress2 braddress2 varchar(40)  NOT NULL default '';