upgrade2.9b-3.0.sql

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

ALTER TABLE `purchorderdetails` CHANGE OrderNo orderno int(11)  NOT NULL default '0';
ALTER TABLE `purchorderdetails` CHANGE ItemCode itemcode varchar(20)  NOT NULL default '';
ALTER TABLE `purchorderdetails` CHANGE DeliveryDate deliverydate date  NOT NULL default '0000-00-00';
ALTER TABLE `purchorderdetails` CHANGE ItemDescription itemdescription varchar(100)  NOT NULL default '';
ALTER TABLE `purchorderdetails` CHANGE GLCode glcode int(11)  NOT NULL default '0';
ALTER TABLE `purchorderdetails` CHANGE QtyInvoiced qtyinvoiced double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `purchorderdetails` CHANGE UnitPrice unitprice double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `purchorderdetails` CHANGE ActPrice actprice double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `purchorderdetails` CHANGE StdCostUnit stdcostunit double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `purchorderdetails` CHANGE QuantityOrd quantityord double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `purchorderdetails` CHANGE QuantityRecd quantityrecd double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `purchorderdetails` CHANGE ShiptRef shiptref int(1)  NOT NULL default '0';
ALTER TABLE `purchorderdetails` CHANGE JobRef jobref varchar(20)  NOT NULL default '';
ALTER TABLE `purchorderdetails` CHANGE Completed completed tinyint(4)  NOT NULL default '0';
ALTER TABLE `purchorders` CHANGE OrderNo orderno int(11)  NOT NULL auto_increment;
ALTER TABLE `purchorders` CHANGE SupplierNo supplierno varchar(10)  NOT NULL default '';
ALTER TABLE `purchorders` CHANGE Comments comments longblob;
ALTER TABLE `purchorders` CHANGE OrdDate orddate datetime  NOT NULL default '0000-00-00 00:00:00';
ALTER TABLE `purchorders` CHANGE Rate rate double(16,4)  NOT NULL default '1.0000';
ALTER TABLE `purchorders` CHANGE DatePrinted dateprinted datetime  default NULL;
ALTER TABLE `purchorders` CHANGE AllowPrint allowprint tinyint(4)  NOT NULL default '1';
ALTER TABLE `purchorders` CHANGE Initiator initiator varchar(10)  default NULL;
ALTER TABLE `purchorders` CHANGE RequisitionNo requisitionno varchar(15)  default NULL;
ALTER TABLE `purchorders` CHANGE IntoStockLocation intostocklocation varchar(5)  NOT NULL default '';
ALTER TABLE `purchorders` CHANGE DelAdd1 deladd1 varchar(40)  NOT NULL default '';
ALTER TABLE `purchorders` CHANGE DelAdd2 deladd2 varchar(40)  NOT NULL default '';
ALTER TABLE `purchorders` CHANGE DelAdd3 deladd3 varchar(40)  NOT NULL default '';
ALTER TABLE `purchorders` CHANGE DelAdd4 deladd4 varchar(40)  NOT NULL default '';
ALTER TABLE `reportcolumns` CHANGE ReportID reportid smallint(6)  NOT NULL default '0';
ALTER TABLE `reportcolumns` CHANGE ColNo colno smallint(6)  NOT NULL default '0';
ALTER TABLE `reportcolumns` CHANGE Heading1 heading1 varchar(15)  NOT NULL default '';
ALTER TABLE `reportcolumns` CHANGE Heading2 heading2 varchar(15)  default NULL;
ALTER TABLE `reportcolumns` CHANGE Calculation calculation tinyint(1)  NOT NULL default '0';
ALTER TABLE `reportcolumns` CHANGE PeriodFrom periodfrom smallint(6)  default NULL;
ALTER TABLE `reportcolumns` CHANGE PeriodTo periodto smallint(6)  default NULL;
ALTER TABLE `reportcolumns` CHANGE DataType datatype varchar(15)  default NULL;
ALTER TABLE `reportcolumns` CHANGE ColNumerator colnumerator tinyint(4)  default NULL;
ALTER TABLE `reportcolumns` CHANGE ColDenominator coldenominator tinyint(4)  default NULL;
ALTER TABLE `reportcolumns` CHANGE CalcOperator calcoperator char(1)  default NULL;
ALTER TABLE `reportcolumns` CHANGE BudgetOrActual budgetoractual tinyint(1)  NOT NULL default '0';
ALTER TABLE `reportcolumns` CHANGE ValFormat valformat char(1)  NOT NULL default 'N';
ALTER TABLE `reportcolumns` CHANGE Constant constant float  NOT NULL default '0';
ALTER TABLE `reportheaders` CHANGE ReportID reportid smallint(6)  NOT NULL auto_increment;
ALTER TABLE `reportheaders` CHANGE ReportHeading reportheading varchar(80)  NOT NULL default '';
ALTER TABLE `reportheaders` CHANGE GroupByData1 groupbydata1 varchar(15)  NOT NULL default '';
ALTER TABLE `reportheaders` CHANGE NewPageAfter1 newpageafter1 tinyint(1)  NOT NULL default '0';
ALTER TABLE `reportheaders` CHANGE Lower1 lower1 varchar(10)  NOT NULL default '';
ALTER TABLE `reportheaders` CHANGE Upper1 upper1 varchar(10)  NOT NULL default '';
ALTER TABLE `reportheaders` CHANGE GroupByData2 groupbydata2 varchar(15)  default NULL;
ALTER TABLE `reportheaders` CHANGE NewPageAfter2 newpageafter2 tinyint(1)  NOT NULL default '0';
ALTER TABLE `reportheaders` CHANGE Lower2 lower2 varchar(10)  default NULL;
ALTER TABLE `reportheaders` CHANGE Upper2 upper2 varchar(10)  default NULL;
ALTER TABLE `reportheaders` CHANGE GroupByData3 groupbydata3 varchar(15)  default NULL;
ALTER TABLE `reportheaders` CHANGE NewPageAfter3 newpageafter3 tinyint(1)  NOT NULL default '0';
ALTER TABLE `reportheaders` CHANGE Lower3 lower3 varchar(10)  default NULL;
ALTER TABLE `reportheaders` CHANGE Upper3 upper3 varchar(10)  default NULL;
ALTER TABLE `reportheaders` CHANGE GroupByData4 groupbydata4 varchar(15)  NOT NULL default '';
ALTER TABLE `reportheaders` CHANGE NewPageAfter4 newpageafter4 tinyint(1)  NOT NULL default '0';
ALTER TABLE `reportheaders` CHANGE Upper4 upper4 varchar(10)  NOT NULL default '';
ALTER TABLE `reportheaders` CHANGE Lower4 lower4 varchar(10)  NOT NULL default '';
ALTER TABLE `salesanalysis` CHANGE TypeAbbrev typeabbrev char(2)  NOT NULL default '';
ALTER TABLE `salesanalysis` CHANGE PeriodNo periodno smallint(6)  NOT NULL default '0';
ALTER TABLE `salesanalysis` CHANGE Amt amt double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `salesanalysis` CHANGE Cost cost double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `salesanalysis` CHANGE Cust cust varchar(10)  NOT NULL default '';
ALTER TABLE `salesanalysis` CHANGE CustBranch custbranch varchar(10)  NOT NULL default '';
ALTER TABLE `salesanalysis` CHANGE Qty qty double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `salesanalysis` CHANGE Disc disc double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `salesanalysis` CHANGE StockID stockid varchar(20)  NOT NULL default '';
ALTER TABLE `salesanalysis` CHANGE Area area char(2)  NOT NULL default '';
ALTER TABLE `salesanalysis` CHANGE BudgetOrActual budgetoractual tinyint(1)  NOT NULL default '0';
ALTER TABLE `salesanalysis` CHANGE Salesperson salesperson char(3)  NOT NULL default '';
ALTER TABLE `salesanalysis` CHANGE StkCategory stkcategory varchar(6)  NOT NULL default '';
ALTER TABLE `salesanalysis` CHANGE ID id int(11)  NOT NULL auto_increment;
ALTER TABLE `salesglpostings` CHANGE ID id int(11)  NOT NULL auto_increment;
ALTER TABLE `salesglpostings` CHANGE Area area char(2)  NOT NULL default '';
ALTER TABLE `salesglpostings` CHANGE StkCat stkcat varchar(6)  NOT NULL default '';
ALTER TABLE `salesglpostings` CHANGE DiscountGLCode discountglcode int(11)  NOT NULL default '0';
ALTER TABLE `salesglpostings` CHANGE SalesGLCode salesglcode int(11)  NOT NULL default '0';
ALTER TABLE `salesglpostings` CHANGE SalesType salestype char(2)  NOT NULL default 'AN';
ALTER TABLE `salesorderdetails` CHANGE OrderNo orderno int(11)  NOT NULL default '0';
ALTER TABLE `salesorderdetails` CHANGE StkCode stkcode varchar(20)  NOT NULL default '';
ALTER TABLE `salesorderdetails` CHANGE QtyInvoiced qtyinvoiced double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `salesorderdetails` CHANGE UnitPrice unitprice double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `salesorderdetails` CHANGE Quantity quantity double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `salesorderdetails` CHANGE Estimate estimate tinyint(4)  NOT NULL default '0';
ALTER TABLE `salesorderdetails` CHANGE DiscountPercent discountpercent double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `salesorderdetails` CHANGE ActualDispatchDate actualdispatchdate datetime  NOT NULL default '0000-00-00 00:00:00';
ALTER TABLE `salesorderdetails` CHANGE Completed completed tinyint(1)  NOT NULL default '0';
ALTER TABLE `salesorderdetails` CHANGE Narrative narrative text  NOT NULL;
ALTER TABLE `salesorders` CHANGE OrderNo orderno int(11)  NOT NULL auto_increment;
ALTER TABLE `salesorders` CHANGE DebtorNo debtorno varchar(10)  NOT NULL default '';
ALTER TABLE `salesorders` CHANGE BranchCode branchcode varchar(10)  NOT NULL default '';
ALTER TABLE `salesorders` CHANGE CustomerRef customerref varchar(50)  NOT NULL default '';
ALTER TABLE `salesorders` CHANGE BuyerName buyername varchar(50)  default NULL;
ALTER TABLE `salesorders` CHANGE Comments comments longblob;
ALTER TABLE `salesorders` CHANGE OrdDate orddate date  NOT NULL default '0000-00-00';
ALTER TABLE `salesorders` CHANGE OrderType ordertype char(2)  NOT NULL default '';
ALTER TABLE `salesorders` CHANGE ShipVia shipvia int(11)  NOT NULL default '0';
ALTER TABLE `salesorders` CHANGE DelAdd1 deladd1 varchar(40)  NOT NULL default '';
ALTER TABLE `salesorders` CHANGE DelAdd2 deladd2 varchar(20)  NOT NULL default '';
ALTER TABLE `salesorders` CHANGE DelAdd3 deladd3 varchar(15)  NOT NULL default '';
ALTER TABLE `salesorders` CHANGE DelAdd4 deladd4 varchar(15)  default NULL;
ALTER TABLE `salesorders` CHANGE ContactPhone contactphone varchar(25)  default NULL;
ALTER TABLE `salesorders` CHANGE ContactEmail contactemail varchar(25)  default NULL;
ALTER TABLE `salesorders` CHANGE DeliverTo deliverto varchar(40)  NOT NULL default '';
ALTER TABLE `salesorders` CHANGE FreightCost freightcost float(10,2)  NOT NULL default '0.00';
ALTER TABLE `salesorders` CHANGE FromStkLoc fromstkloc varchar(5)  NOT NULL default '';
ALTER TABLE `salesorders` CHANGE DeliveryDate deliverydate date  NOT NULL default '0000-00-00';
ALTER TABLE `salesorders` CHANGE PrintedPackingSlip printedpackingslip tinyint(4)  NOT NULL default '0';
ALTER TABLE `salesorders` CHANGE DatePackingSlipPrinted datepackingslipprinted date  NOT NULL default '0000-00-00';
ALTER TABLE `salestypes` CHANGE TypeAbbrev typeabbrev char(2)  NOT NULL default '';
ALTER TABLE `salestypes` CHANGE Sales_Type sales_type char(20)  NOT NULL default '';
ALTER TABLE `salesman` CHANGE SalesmanCode salesmancode char(3)  NOT NULL default '';
ALTER TABLE `salesman` CHANGE SalesmanName salesmanname char(30)  NOT NULL default '';
ALTER TABLE `salesman` CHANGE SManTel smantel char(20)  NOT NULL default '';
ALTER TABLE `salesman` CHANGE SManFax smanfax char(20)  NOT NULL default '';
ALTER TABLE `salesman` CHANGE CommissionRate1 commissionrate1 double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `salesman` CHANGE Breakpoint breakpoint decimal(20,4)  NOT NULL default '0.0000';
ALTER TABLE `salesman` CHANGE CommissionRate2 commissionrate2 double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `scripts` CHANGE PageID pageid smallint(4)  NOT NULL default '0';
ALTER TABLE `scripts` CHANGE FileName filename varchar(50)  NOT NULL default '';
ALTER TABLE `scripts` CHANGE PageDescription pagedescription text  NOT NULL;
ALTER TABLE `shipmentcharges` CHANGE ShiptChgID shiptchgid int(11)  NOT NULL auto_increment;
ALTER TABLE `shipmentcharges` CHANGE ShiptRef shiptref int(11)  NOT NULL default '0';
ALTER TABLE `shipmentcharges` CHANGE TransType transtype smallint(6)  NOT NULL default '0';
ALTER TABLE `shipmentcharges` CHANGE TransNo transno int(11)  NOT NULL default '0';
ALTER TABLE `shipmentcharges` CHANGE StockID stockid varchar(20)  NOT NULL default '';
ALTER TABLE `shipmentcharges` CHANGE Value value float  NOT NULL default '0';
ALTER TABLE `shipments` CHANGE ShiptRef shiptref int(11)  NOT NULL default '0';
ALTER TABLE `shipments` CHANGE VoyageRef voyageref varchar(20)  NOT NULL default '0';
ALTER TABLE `shipments` CHANGE Vessel vessel varchar(50)  NOT NULL default '';
ALTER TABLE `shipments` CHANGE ETA eta datetime  NOT NULL default '0000-00-00 00:00:00';
ALTER TABLE `shipments` CHANGE AccumValue accumvalue double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `shipments` CHANGE SupplierID supplierid varchar(10)  NOT NULL default '';
ALTER TABLE `shipments` CHANGE Closed closed tinyint(4)  NOT NULL default '0';
ALTER TABLE `shippers` CHANGE Shipper_ID shipper_id int(11)  NOT NULL auto_increment;
ALTER TABLE `shippers` CHANGE ShipperName shippername char(40)  NOT NULL default '';
ALTER TABLE `shippers` CHANGE MinCharge mincharge double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `stockcategory` CHANGE CategoryID categoryid char(6)  NOT NULL default '';
ALTER TABLE `stockcategory` CHANGE CategoryDescription categorydescription char(20)  NOT NULL default '';
ALTER TABLE `stockcategory` CHANGE StockType stocktype char(1)  NOT NULL default 'F';
ALTER TABLE `stockcategory` CHANGE StockAct stockact int(11)  NOT NULL default '0';
ALTER TABLE `stockcategory` CHANGE AdjGLAct adjglact int(11)  NOT NULL default '0';
ALTER TABLE `stockcategory` CHANGE PurchPriceVarAct purchpricevaract int(11)  NOT NULL default '80000';
ALTER TABLE `stockcategory` CHANGE MaterialUseageVarAc materialuseagevarac int(11)  NOT NULL default '80000';
ALTER TABLE `stockcategory` CHANGE WIPAct wipact int(11)  NOT NULL default '0';
ALTER TABLE `stockcheckfreeze` CHANGE StockID stockid varchar(20)  NOT NULL default '';
ALTER TABLE `stockcheckfreeze` CHANGE LocCode loccode varchar(5)  NOT NULL default '';
ALTER TABLE `stockcheckfreeze` CHANGE QOH qoh float  NOT NULL default '0';
ALTER TABLE `stockcounts` CHANGE ID id int(11)  NOT NULL auto_increment;
ALTER TABLE `stockcounts` CHANGE StockID stockid varchar(20)  NOT NULL default '';
ALTER TABLE `stockcounts` CHANGE LocCode loccode varchar(5)  NOT NULL default '';
ALTER TABLE `stockcounts` CHANGE QtyCounted qtycounted float  NOT NULL default '0';
ALTER TABLE `stockcounts` CHANGE Reference reference varchar(20)  NOT NULL default '';
ALTER TABLE `stockmaster` CHANGE StockID stockid varchar(20)  NOT NULL default '';
ALTER TABLE `stockmaster` CHANGE CategoryID categoryid varchar(6)  NOT NULL default '';
ALTER TABLE `stockmaster` CHANGE Description description varchar(50)  NOT NULL default '';
ALTER TABLE `stockmaster` CHANGE LongDescription longdescription text  NOT NULL;
ALTER TABLE `stockmaster` CHANGE Units units varchar(20)  NOT NULL default 'each';
ALTER TABLE `stockmaster` CHANGE MBflag mbflag char(1)  NOT NULL default 'B';
ALTER TABLE `stockmaster` CHANGE LastCurCostDate lastcurcostdate date  NOT NULL default '1800-01-01';
ALTER TABLE `stockmaster` CHANGE ActualCost actualcost decimal(20,4)  NOT NULL default '0.0000';
ALTER TABLE `stockmaster` CHANGE LastCost lastcost decimal(20,4)  NOT NULL default '0.0000';
ALTER TABLE `stockmaster` CHANGE Materialcost materialcost decimal(20,4)  NOT NULL default '0.0000';
ALTER TABLE `stockmaster` CHANGE Labourcost labourcost decimal(20,4)  NOT NULL default '0.0000';
ALTER TABLE `stockmaster` CHANGE Overheadcost overheadcost decimal(20,4)  NOT NULL default '0.0000';
ALTER TABLE `stockmaster` CHANGE lowestlevel lowestlevel smallint(6)  NOT NULL default '0';
ALTER TABLE `stockmaster` CHANGE Discontinued discontinued tinyint(4)  NOT NULL default '0';
ALTER TABLE `stockmaster` CHANGE Controlled controlled tinyint(4)  NOT NULL default '0';
ALTER TABLE `stockmaster` CHANGE EOQ eoq double(10,2)  NOT NULL default '0.00';
ALTER TABLE `stockmaster` CHANGE Volume volume decimal(20,4)  NOT NULL default '0.0000';
ALTER TABLE `stockmaster` CHANGE KGS kgs decimal(20,4)  NOT NULL default '0.0000';
ALTER TABLE `stockmaster` CHANGE BarCode barcode varchar(50)  NOT NULL default '';
ALTER TABLE `stockmaster` CHANGE DiscountCategory discountcategory char(2)  NOT NULL default '';
ALTER TABLE `stockmaster` CHANGE TaxLevel taxlevel tinyint(4)  NOT NULL default '1';
ALTER TABLE `stockmaster` CHANGE Serialised serialised tinyint(4)  NOT NULL default '0';
ALTER TABLE `stockmaster` CHANGE DecimalPlaces decimalplaces tinyint(4)  NOT NULL default '0';
ALTER TABLE `stockmoves` CHANGE StkMoveNo stkmoveno int(11)  NOT NULL auto_increment;
ALTER TABLE `stockmoves` CHANGE StockID stockid varchar(20)  NOT NULL default '';
ALTER TABLE `stockmoves` CHANGE Type type smallint(6)  NOT NULL default '0';