upgrade2.9b-3.0.sql

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

ALTER TABLE `custbranch` CHANGE BrAddress3 braddress3 varchar(40)  NOT NULL default '';
ALTER TABLE `custbranch` CHANGE BrAddress4 braddress4 varchar(50)  NOT NULL default '';
ALTER TABLE `custbranch` CHANGE EstDeliveryDays estdeliverydays smallint(6)  NOT NULL default '1';
ALTER TABLE `custbranch` CHANGE Area area char(2)  NOT NULL default '';
ALTER TABLE `custbranch` CHANGE Salesman salesman varchar(4)  NOT NULL default '';
ALTER TABLE `custbranch` CHANGE FwdDate fwddate smallint(6)  NOT NULL default '0';
ALTER TABLE `custbranch` CHANGE PhoneNo phoneno varchar(20)  NOT NULL default '';
ALTER TABLE `custbranch` CHANGE FaxNo faxno varchar(20)  NOT NULL default '';
ALTER TABLE `custbranch` CHANGE ContactName contactname varchar(30)  NOT NULL default '';
ALTER TABLE `custbranch` CHANGE Email email varchar(55)  NOT NULL default '';
ALTER TABLE `custbranch` CHANGE DefaultLocation defaultlocation varchar(5)  NOT NULL default '';
ALTER TABLE `custbranch` CHANGE TaxAuthority taxauthority tinyint(4)  NOT NULL default '1';
ALTER TABLE `custbranch` CHANGE DefaultShipVia defaultshipvia int(11)  NOT NULL default '1';
ALTER TABLE `custbranch` CHANGE DisableTrans disabletrans tinyint(4)  NOT NULL default '0';
ALTER TABLE `custbranch` CHANGE BrPostAddr1 brpostaddr1 varchar(40)  NOT NULL default '';
ALTER TABLE `custbranch` CHANGE BrPostAddr2 brpostaddr2 varchar(40)  NOT NULL default '';
ALTER TABLE `custbranch` CHANGE BrPostAddr3 brpostaddr3 varchar(30)  NOT NULL default '';
ALTER TABLE `custbranch` CHANGE BrPostAddr4 brpostaddr4 varchar(20)  NOT NULL default '';
ALTER TABLE `custbranch` CHANGE CustBranchCode custbranchcode varchar(30)  NOT NULL default '';
ALTER TABLE `debtortrans` CHANGE ID id int(11)  NOT NULL auto_increment;
ALTER TABLE `debtortrans` CHANGE TransNo transno int(11)  NOT NULL default '0';
ALTER TABLE `debtortrans` CHANGE Type type smallint(6)  NOT NULL default '0';
ALTER TABLE `debtortrans` CHANGE DebtorNo debtorno varchar(10)  NOT NULL default '';
ALTER TABLE `debtortrans` CHANGE BranchCode branchcode varchar(10)  NOT NULL default '';
ALTER TABLE `debtortrans` CHANGE TranDate trandate datetime  NOT NULL default '0000-00-00 00:00:00';
ALTER TABLE `debtortrans` CHANGE Prd prd smallint(6)  NOT NULL default '0';
ALTER TABLE `debtortrans` CHANGE Settled settled tinyint(4)  NOT NULL default '0';
ALTER TABLE `debtortrans` CHANGE Reference reference varchar(20)  NOT NULL default '';
ALTER TABLE `debtortrans` CHANGE Tpe tpe char(2)  NOT NULL default '';
ALTER TABLE `debtortrans` CHANGE Order_ order_ int(11)  NOT NULL default '0';
ALTER TABLE `debtortrans` CHANGE Rate rate double(16,6)  NOT NULL default '0.000000';
ALTER TABLE `debtortrans` CHANGE OvAmount ovamount float  NOT NULL default '0';
ALTER TABLE `debtortrans` CHANGE OvGST ovgst float  NOT NULL default '0';
ALTER TABLE `debtortrans` CHANGE OvFreight ovfreight float  NOT NULL default '0';
ALTER TABLE `debtortrans` CHANGE OvDiscount ovdiscount float  NOT NULL default '0';
ALTER TABLE `debtortrans` CHANGE DiffOnExch diffonexch float  NOT NULL default '0';
ALTER TABLE `debtortrans` CHANGE Alloc alloc float  NOT NULL default '0';
ALTER TABLE `debtortrans` CHANGE InvText invtext text;
ALTER TABLE `debtortrans` CHANGE ShipVia shipvia varchar(10)  NOT NULL default '';
ALTER TABLE `debtortrans` CHANGE EDISent edisent tinyint(4)  NOT NULL default '0';
ALTER TABLE `debtortrans` CHANGE Consignment consignment varchar(15)  NOT NULL default '';
ALTER TABLE `debtorsmaster` CHANGE DebtorNo debtorno varchar(10)  NOT NULL default '';
ALTER TABLE `debtorsmaster` CHANGE Name name varchar(40)  NOT NULL default '';
ALTER TABLE `debtorsmaster` CHANGE Address1 address1 varchar(40)  NOT NULL default '';
ALTER TABLE `debtorsmaster` CHANGE Address2 address2 varchar(40)  NOT NULL default '';
ALTER TABLE `debtorsmaster` CHANGE Address3 address3 varchar(40)  NOT NULL default '';
ALTER TABLE `debtorsmaster` CHANGE Address4 address4 varchar(50)  NOT NULL default '';
ALTER TABLE `debtorsmaster` CHANGE CurrCode currcode char(3)  NOT NULL default '';
ALTER TABLE `debtorsmaster` CHANGE SalesType salestype char(2)  NOT NULL default '';
ALTER TABLE `debtorsmaster` CHANGE ClientSince clientsince datetime  NOT NULL default '0000-00-00 00:00:00';
ALTER TABLE `debtorsmaster` CHANGE HoldReason holdreason smallint(6)  NOT NULL default '0';
ALTER TABLE `debtorsmaster` CHANGE PaymentTerms paymentterms char(2)  NOT NULL default 'f';
ALTER TABLE `debtorsmaster` CHANGE Discount discount double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `debtorsmaster` CHANGE PymtDiscount pymtdiscount double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `debtorsmaster` CHANGE LastPaid lastpaid double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `debtorsmaster` CHANGE LastPaidDate lastpaiddate datetime  default NULL;
ALTER TABLE `debtorsmaster` CHANGE CreditLimit creditlimit float  NOT NULL default '1000';
ALTER TABLE `debtorsmaster` CHANGE InvAddrBranch invaddrbranch tinyint(4)  NOT NULL default '0';
ALTER TABLE `debtorsmaster` CHANGE DiscountCode discountcode char(2)  NOT NULL default '';
ALTER TABLE `debtorsmaster` CHANGE EDIInvoices ediinvoices tinyint(4)  NOT NULL default '0';
ALTER TABLE `debtorsmaster` CHANGE EDIOrders ediorders tinyint(4)  NOT NULL default '0';
ALTER TABLE `debtorsmaster` CHANGE EDIReference edireference varchar(20)  NOT NULL default '';
ALTER TABLE `debtorsmaster` CHANGE EDITransport editransport varchar(5)  NOT NULL default 'email';
ALTER TABLE `debtorsmaster` CHANGE EDIAddress ediaddress varchar(50)  NOT NULL default '';
ALTER TABLE `debtorsmaster` CHANGE EDIServerUser ediserveruser varchar(20)  NOT NULL default '';
ALTER TABLE `debtorsmaster` CHANGE EDIServerPwd ediserverpwd varchar(20)  NOT NULL default '';
ALTER TABLE `discountmatrix` CHANGE SalesType salestype char(2)  NOT NULL default '';
ALTER TABLE `discountmatrix` CHANGE DiscountCategory discountcategory char(2)  NOT NULL default '';
ALTER TABLE `discountmatrix` CHANGE QuantityBreak quantitybreak int(11)  NOT NULL default '1';
ALTER TABLE `discountmatrix` CHANGE DiscountRate discountrate double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `ediitemmapping` CHANGE SuppOrCust supporcust varchar(4)  NOT NULL default '';
ALTER TABLE `ediitemmapping` CHANGE PartnerCode partnercode varchar(10)  NOT NULL default '';
ALTER TABLE `ediitemmapping` CHANGE StockID stockid varchar(20)  NOT NULL default '';
ALTER TABLE `ediitemmapping` CHANGE PartnerStockID partnerstockid varchar(50)  NOT NULL default '';
ALTER TABLE `edimessageformat` CHANGE ID id int(11)  NOT NULL auto_increment;
ALTER TABLE `edimessageformat` CHANGE PartnerCode partnercode varchar(10)  NOT NULL default '';
ALTER TABLE `edimessageformat` CHANGE MessageType messagetype varchar(6)  NOT NULL default '';
ALTER TABLE `edimessageformat` CHANGE Section section varchar(7)  NOT NULL default '';
ALTER TABLE `edimessageformat` CHANGE SequenceNo sequenceno int(11)  NOT NULL default '0';
ALTER TABLE `edimessageformat` CHANGE LineText linetext varchar(70)  NOT NULL default '';
ALTER TABLE `edi_orders_seg_groups` CHANGE SegGroupNo seggroupno tinyint(4)  NOT NULL default '0';
ALTER TABLE `edi_orders_seg_groups` CHANGE MaxOccur maxoccur int(4)  NOT NULL default '0';
ALTER TABLE `edi_orders_seg_groups` CHANGE ParentSegGroup parentseggroup tinyint(4)  NOT NULL default '0';
ALTER TABLE `edi_orders_segs` CHANGE ID id int(11)  NOT NULL auto_increment;
ALTER TABLE `edi_orders_segs` CHANGE SegTag segtag char(3)  NOT NULL default '';
ALTER TABLE `edi_orders_segs` CHANGE SegGroup seggroup tinyint(4)  NOT NULL default '0';
ALTER TABLE `edi_orders_segs` CHANGE MaxOccur maxoccur tinyint(4)  NOT NULL default '0';
ALTER TABLE `freightcosts` CHANGE ShipCostFromID shipcostfromid int(11)  NOT NULL auto_increment;
ALTER TABLE `freightcosts` CHANGE LocationFrom locationfrom varchar(5)  NOT NULL default '';
ALTER TABLE `freightcosts` CHANGE Destination destination varchar(40)  NOT NULL default '';
ALTER TABLE `freightcosts` CHANGE ShipperID shipperid int(11)  NOT NULL default '0';
ALTER TABLE `freightcosts` CHANGE CubRate cubrate double(16,2)  NOT NULL default '0.00';
ALTER TABLE `freightcosts` CHANGE KGRate kgrate double(16,2)  NOT NULL default '0.00';
ALTER TABLE `freightcosts` CHANGE MAXKGs maxkgs double(16,2)  NOT NULL default '999999.00';
ALTER TABLE `freightcosts` CHANGE MAXCub maxcub double(16,2)  NOT NULL default '999999.00';
ALTER TABLE `freightcosts` CHANGE FixedPrice fixedprice double(16,2)  NOT NULL default '0.00';
ALTER TABLE `freightcosts` CHANGE MinimumChg minimumchg double(16,2)  NOT NULL default '0.00';
ALTER TABLE `gltrans` CHANGE CounterIndex counterindex int(11)  NOT NULL auto_increment;
ALTER TABLE `gltrans` CHANGE Type type smallint(6)  NOT NULL default '0';
ALTER TABLE `gltrans` CHANGE TypeNo typeno bigint(16)  NOT NULL default '1';
ALTER TABLE `gltrans` CHANGE ChequeNo chequeno int(11)  NOT NULL default '0';
ALTER TABLE `gltrans` CHANGE TranDate trandate date  NOT NULL default '0000-00-00';
ALTER TABLE `gltrans` CHANGE PeriodNo periodno smallint(6)  NOT NULL default '0';
ALTER TABLE `gltrans` CHANGE Account account int(11)  NOT NULL default '0';
ALTER TABLE `gltrans` CHANGE Narrative narrative varchar(200)  NOT NULL default '';
ALTER TABLE `gltrans` CHANGE Amount amount float  NOT NULL default '0';
ALTER TABLE `gltrans` CHANGE Posted posted tinyint(4)  NOT NULL default '0';
ALTER TABLE `gltrans` CHANGE JobRef jobref varchar(20)  NOT NULL default '';
ALTER TABLE `grns` CHANGE GRNBatch grnbatch smallint(6)  NOT NULL default '0';
ALTER TABLE `grns` CHANGE GRNNo grnno int(11)  NOT NULL auto_increment;
ALTER TABLE `grns` CHANGE PODetailItem podetailitem int(11)  NOT NULL default '0';
ALTER TABLE `grns` CHANGE ItemCode itemcode varchar(20)  NOT NULL default '';
ALTER TABLE `grns` CHANGE DeliveryDate deliverydate date  NOT NULL default '0000-00-00';
ALTER TABLE `grns` CHANGE ItemDescription itemdescription varchar(100)  NOT NULL default '';
ALTER TABLE `grns` CHANGE QtyRecd qtyrecd double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `grns` CHANGE QuantityInv quantityinv double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `grns` CHANGE SupplierID supplierid varchar(10)  NOT NULL default '';
ALTER TABLE `holdreasons` CHANGE ReasonCode reasoncode smallint(6)  NOT NULL default '1';
ALTER TABLE `holdreasons` CHANGE ReasonDescription reasondescription char(30)  NOT NULL default '';
ALTER TABLE `holdreasons` CHANGE DissallowInvoices dissallowinvoices tinyint(4)  NOT NULL default '-1';
ALTER TABLE `lastcostrollup` CHANGE StockID stockid char(20)  NOT NULL default '';
ALTER TABLE `lastcostrollup` CHANGE TotalOnHand totalonhand double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `lastcostrollup` CHANGE MatCost matcost decimal(20,4)  NOT NULL default '0.0000';
ALTER TABLE `lastcostrollup` CHANGE LabCost labcost decimal(20,4)  NOT NULL default '0.0000';
ALTER TABLE `lastcostrollup` CHANGE OheadCost oheadcost decimal(20,4)  NOT NULL default '0.0000';
ALTER TABLE `lastcostrollup` CHANGE CategoryID categoryid char(6)  NOT NULL default '';
ALTER TABLE `lastcostrollup` CHANGE StockAct stockact int(11)  NOT NULL default '0';
ALTER TABLE `lastcostrollup` CHANGE AdjGLAct adjglact int(11)  NOT NULL default '0';
ALTER TABLE `lastcostrollup` CHANGE NewMatCost newmatcost decimal(20,4)  NOT NULL default '0.0000';
ALTER TABLE `lastcostrollup` CHANGE NewLabCost newlabcost decimal(20,4)  NOT NULL default '0.0000';
ALTER TABLE `lastcostrollup` CHANGE NewOheadCost newoheadcost decimal(20,4)  NOT NULL default '0.0000';
ALTER TABLE `locstock` CHANGE LocCode loccode varchar(5)  NOT NULL default '';
ALTER TABLE `locstock` CHANGE StockID stockid varchar(20)  NOT NULL default '';
ALTER TABLE `locstock` CHANGE Quantity quantity double(16,1)  NOT NULL default '0.0';
ALTER TABLE `locstock` CHANGE ReorderLevel reorderlevel bigint(20)  NOT NULL default '0';
ALTER TABLE `loctransfers` CHANGE Reference reference int(11)  NOT NULL default '0';
ALTER TABLE `loctransfers` CHANGE StockID stockid varchar(20)  NOT NULL default '';
ALTER TABLE `loctransfers` CHANGE ShipQty shipqty int(11)  NOT NULL default '0';
ALTER TABLE `loctransfers` CHANGE RecQty recqty int(11)  NOT NULL default '0';
ALTER TABLE `loctransfers` CHANGE ShipDate shipdate date  NOT NULL default '0000-00-00';
ALTER TABLE `loctransfers` CHANGE RecDate recdate date  NOT NULL default '0000-00-00';
ALTER TABLE `loctransfers` CHANGE ShipLoc shiploc varchar(7)  NOT NULL default '';
ALTER TABLE `loctransfers` CHANGE RecLoc recloc varchar(7)  NOT NULL default '';
ALTER TABLE `locations` CHANGE LocCode loccode varchar(5)  NOT NULL default '';
ALTER TABLE `locations` CHANGE LocationName locationname varchar(50)  NOT NULL default '';
ALTER TABLE `locations` CHANGE DelAdd1 deladd1 varchar(40)  NOT NULL default '';
ALTER TABLE `locations` CHANGE DelAdd2 deladd2 varchar(40)  NOT NULL default '';
ALTER TABLE `locations` CHANGE DelAdd3 deladd3 varchar(40)  NOT NULL default '';
ALTER TABLE `locations` CHANGE Tel tel varchar(30)  NOT NULL default '';
ALTER TABLE `locations` CHANGE Fax fax varchar(30)  NOT NULL default '';
ALTER TABLE `locations` CHANGE Email email varchar(55)  NOT NULL default '';
ALTER TABLE `locations` CHANGE Contact contact varchar(30)  NOT NULL default '';
ALTER TABLE `locations` CHANGE TaxAuthority taxauthority tinyint(4)  NOT NULL default '1';
ALTER TABLE `orderdeliverydifferenceslog` CHANGE OrderNo orderno int(11)  NOT NULL default '0';
ALTER TABLE `orderdeliverydifferenceslog` CHANGE InvoiceNo invoiceno int(11)  NOT NULL default '0';
ALTER TABLE `orderdeliverydifferenceslog` CHANGE StockID stockid varchar(20)  NOT NULL default '';
ALTER TABLE `orderdeliverydifferenceslog` CHANGE QuantityDiff quantitydiff double(16,4)  NOT NULL default '0.0000';
ALTER TABLE `orderdeliverydifferenceslog` CHANGE DebtorNo debtorno varchar(10)  NOT NULL default '';
ALTER TABLE `orderdeliverydifferenceslog` CHANGE Branch branch varchar(10)  NOT NULL default '';
ALTER TABLE `orderdeliverydifferenceslog` CHANGE Can_or_BO can_or_bo char(3)  NOT NULL default 'CAN';
ALTER TABLE `paymentterms` CHANGE TermsIndicator termsindicator char(2)  NOT NULL default '';
ALTER TABLE `paymentterms` CHANGE Terms terms char(40)  NOT NULL default '';
ALTER TABLE `paymentterms` CHANGE DaysBeforeDue daysbeforedue smallint(6)  NOT NULL default '0';
ALTER TABLE `paymentterms` CHANGE DayInFollowingMonth dayinfollowingmonth smallint(6)  NOT NULL default '0';
ALTER TABLE `periods` CHANGE PeriodNo periodno smallint(6)  NOT NULL default '0';
ALTER TABLE `periods` CHANGE LastDate_in_Period lastdate_in_period date  NOT NULL default '0000-00-00';
ALTER TABLE `prices` CHANGE StockID stockid varchar(20)  NOT NULL default '';
ALTER TABLE `prices` CHANGE TypeAbbrev typeabbrev char(2)  NOT NULL default '';
ALTER TABLE `prices` CHANGE CurrAbrev currabrev char(3)  NOT NULL default '';
ALTER TABLE `prices` CHANGE DebtorNo debtorno varchar(10)  NOT NULL default '';
ALTER TABLE `prices` CHANGE Price price decimal(20,4)  NOT NULL default '0.0000';
ALTER TABLE `prices` CHANGE BranchCode branchcode varchar(10)  NOT NULL default '';
ALTER TABLE `purchdata` CHANGE SupplierNo supplierno char(10)  NOT NULL default '';
ALTER TABLE `purchdata` CHANGE StockID stockid char(20)  NOT NULL default '';
ALTER TABLE `purchdata` CHANGE Price price decimal(20,4)  NOT NULL default '0.0000';
ALTER TABLE `purchdata` CHANGE SuppliersUOM suppliersuom char(50)  NOT NULL default '';
ALTER TABLE `purchdata` CHANGE ConversionFactor conversionfactor double(16,4)  NOT NULL default '1.0000';
ALTER TABLE `purchdata` CHANGE SupplierDescription supplierdescription char(50)  NOT NULL default '';
ALTER TABLE `purchdata` CHANGE LeadTime leadtime smallint(6)  NOT NULL default '1';
ALTER TABLE `purchdata` CHANGE Preferred preferred tinyint(4)  NOT NULL default '0';
ALTER TABLE `purchorderdetails` CHANGE PODetailItem podetailitem int(11)  NOT NULL auto_increment;