--------------------香港EUB商品目录增加字段------------------------------------------------------
alter table DB_CATEGORY add SHORTSKU VARCHAR2(5);
alter table DB_CATEGORY add hkinsurancetype varchar2(50);
alter table DB_CATEGORY add HKCATEGORY varchar2(50);
--------------------------------------------------------------------------
alter table DB_SHOP add SPAYPALNAME varchar2(100);
alter table db_sysadmin modify password varchar2(50);

----------------HJ  20130315  速卖通上传  备注信息------------------------
alter table db_order_temp add content varchar2(4000);

-----------------sl 关键词------------------------------
alter table DB_ANTISTOP add antistop1 varchar2(500);
alter table DB_ANTISTOP add antistop2 varchar2(500);
alter table DB_ANTISTOP add antistop3 varchar2(500);
alter table DB_ANTISTOP add antistop4 varchar2(500);
alter table DB_ANTISTOP add antistop5 varchar2(500);
-----------------hp 20130129------------------------------
alter table db_product add reserve11 number(8,4);
alter table db_product add reserve12 number(8,4);
alter table db_product add reserve13 number(8,4);
alter table db_product add reserve14 number(8,4);
alter table db_product add reserve15 varchar2(1000);
alter table db_product add reserve16 varchar2(1000);
alter table db_product add reserve17 varchar2(1000);
alter table db_product add reserve18 varchar2(1000);
alter table db_product add reserve19 number(8,0);
alter table db_product add reserve20 number(8,0);
-----------------hp 20130129------------------------------
alter table db_purchase add reserve7 number(8,4);
alter table db_purchase add reserve8 number(8,4);
alter table db_purchase add reserve9 number(8,4);
alter table db_purchase add reserve10 varchar2(2);
alter table db_purchase add reserve11 varchar2(500);
alter table db_purchase add reserve12 varchar2(500);
alter table db_purchase add reserve13 varchar2(500);
alter table db_purchase add reserve14 number(8,0);
---------------ly 20120116---------------
alter table db_shop add accesskeyid varchar2(400);
alter table db_shop add secretaccesskey varchar2(400);
alter table db_shop add applicationname varchar2(400);
alter table db_shop add sellerid varchar2(400);
alter table db_shop add marketplaceid varchar2(400);
alter table db_shop add starttime varchar2(200);
alter table db_shop add endtime varchar2(200);
alter table db_shop add amazon varchar2(200);
alter table db_shop add amazonflag varchar2(200);
alter table db_shop add amazonurl varchar2(200);
---------------------sl 20130105---------------------------------
alter table DB_MANUFACTURE add takeoper1 varchar2(400);
alter table DB_MANUFACTURE add takeoper2 varchar2(400);
------------------------20130104 hp  -----------------------
alter table db_product_online add SELLNUM7 number(10);
alter table db_product_online add SELLNUM8 number(10);
alter table db_product_online add SELLNUM9 number(10);
alter table db_product_online add SELLNUM10 number(10);
alter table db_product_online add PRODUCTSAVENUM number(10);
alter table db_product_online add reserve12 number(8,2);
alter table db_product_online add reserve13 number(8,2);
alter table db_product_online add reserve14 number(8,4);
alter table db_product_online add reserve15 number(8,4);
alter table db_product_online add reserve16 varchar2(100);
alter table db_product_online add reserve17 varchar2(100);
alter table db_product_online add reserve18 varchar2(100);
alter table db_product_online add reserve19 varchar2(100);
------------------------20130101 hp  -----------------------
alter table db_product_online add calculateoper varchar2(50);
alter table db_product_online add calculatetime date;
alter table db_product_online add calculateexpresstype varchar2(50);
alter table db_product_online add calculatecountry varchar2(50);
alter table db_product_online add calculatediscount number(8,4);
alter table db_product_online add profit number(8,2);
alter table db_product_online add profitmargin number(8,4);
------------------------20121225 hp  林彦涛的需求产品信息-----
alter table db_productlog add outerlength number(8,2);
alter table db_productlog add outerwidth number(8,2);
alter table db_productlog add outerhigh number(8,2);
alter table db_productlog add outervolume number(8,2);
alter table db_productlog add outergrossweight number(8,2);
alter table db_productlog add outernetweight number(8,2);
alter table db_productlog add outernorms varchar2(1000);
alter table db_productlog add outerlevel varchar2(500);
alter table db_productlog add grossweight number(8,2);
alter table db_productlog add length number(8,2);
alter table db_productlog add width number(8,2);
alter table db_productlog add high number(8,2);
alter table db_productlog add volume number(8,2);
alter table db_product add outerlength number(8,2);
alter table db_product add outerwidth number(8,2);
alter table db_product add outerhigh number(8,2);
alter table db_product add outervolume number(8,2); 
alter table db_product add outergrossweight number(8,2); 
alter table db_product add outernetweight number(8,2);
alter table db_product add outernorms varchar2(1000);
alter table db_product add outerlevel varchar2(500);
alter table db_product add grossweight number(8,2);
alter table db_product add length number(8,2);
alter table db_product add width number(8,2);
alter table db_product add high number(8,2);
alter table db_product add volume number(8,2);
------------------------20121220 ly 訂單創建時間-----------
alter table DB_ORDER add creatordertime Date;
------------------------20121214 ly paypal争议ebay争议-----
alter table DB_ORDER add paypaldispute VARCHAR2(100);
alter table DB_ORDER add ebaydispute VARCHAR2(100);
------------------------20121214 sl -----------------------
alter table DB_MANUFACTURE add takeoper VARCHAR2(100);
alter table DB_MANUFACTURE add manageproduct VARCHAR2(4000);
alter table DB_MANUFACTURE add productcategory VARCHAR2(4000);
alter table DB_MANUFACTURE add manufacturer VARCHAR2(4000);
alter table DB_MANUFACTURE add phone VARCHAR2(4000);
alter table DB_MANUFACTURE add Onlinecontactway VARCHAR2(4000);
alter table DB_MANUFACTURE add productclass VARCHAR2(4000);
alter table DB_MANUFACTURE add Factoryeclass VARCHAR2(4000);
alter table DB_MANUFACTURE add Serviceclass VARCHAR2(4000);
alter table DB_MANUFACTURE add Priceclass VARCHAR2(4000);
alter table DB_MANUFACTURE add Deliverytime VARCHAR2(4000);
alter table DB_MANUFACTURE add ChristmasDeliverytime VARCHAR2(4000);

alter table DB_MANUFACTURE add Productdeliverytime VARCHAR2(4000);
alter table DB_MANUFACTURE add Productquality VARCHAR2(4000);
alter table DB_MANUFACTURE add packaging VARCHAR2(4000);
alter table DB_MANUFACTURE add DeliverType VARCHAR2(4000);
alter table DB_MANUFACTURE add emaile VARCHAR2(4000);
alter table DB_MANUFACTURE add faxmaile VARCHAR2(4000);
alter table DB_MANUFACTURE add drawback VARCHAR2(4000);
alter table DB_MANUFACTURE add collectionoper VARCHAR2(4000);
alter table DB_MANUFACTURE add bank VARCHAR2(4000);
alter table DB_MANUFACTURE add account VARCHAR2(4000);

alter table DB_MANUFACTURE add Remittancecompanyname VARCHAR2(4000);
alter table DB_MANUFACTURE add Remittanceaccount VARCHAR2(4000);
alter table DB_MANUFACTURE add companyaddress VARCHAR2(4000);
alter table DB_MANUFACTURE add bankname VARCHAR2(4000);
alter table DB_MANUFACTURE add SwiftCode VARCHAR2(4000);
alter table DB_MANUFACTURE add bankaddress VARCHAR2(4000);
alter table DB_MANUFACTURE add Transferbankname VARCHAR2(4000);
alter table DB_MANUFACTURE add TransferSwiftCode  VARCHAR2(4000);
alter table DB_MANUFACTURE add Transferbankaddress VARCHAR2(4000);

---------------xb 20130122--------------
alter table db_order add positivenum number(6);
alter table db_order add neutralnum number(6);
alter table db_order add negativenum number(6);
alter table db_order add feedbacktime date;
--feedbacktime 这个是最新的评价时间
--negativenum 这个是差评数量
--neutralnum 这个是中评的数量
--positivenum 这个是好评的数量
--------------------hp 20130111---------------------------------------
alter table DB_PROTOCOL add OPENFLAG varchar2(50);

alter table DB_CATEGORY add hkinsurancetype varchar2(50);
alter table DB_CATEGORY add HKCATEGORY varchar2(50);

------------------------20121211 hj---------------------------------------
alter table db_product add MAINSKU VARCHAR2(50);
alter table db_productlog add MAINSKU VARCHAR2(50);

------------------------20121206hj---------------------------------------
alter table db_product add STORAGEBINFLAG VARCHAR2(50);
alter table db_productlog add STORAGEBINFLAG VARCHAR2(50);
alter table db_manystoragebin add STORAGEBINFLAG VARCHAR2(50);
alter table db_manystoragebinlog add STORAGEBINFLAG VARCHAR2(50);

------------------------20121203lyp---------------------------------------
alter table DB_SHOP add EBAYFEEMONEYRATE varchar2(400);

-------------------------2012-11-26 lxd --------------------------
alter table DB_MANUFACTURE add SKYPE VARCHAR2(200);
-------------------------20121123 ly--------------------------
alter table DB_SAVENUM add sellcost1 number(10,4);
alter table DB_SAVENUM add sellcost2 number(10,4);
alter table DB_SAVENUM add sellcost3 number(10,4);
alter table DB_SAVENUM add sellcost4 number(10,4);
alter table DB_SAVENUM add sellcost5 number(10,4);
alter table DB_SAVENUM add sellcost6 number(10,4);
alter table DB_SAVENUM add sellcost7 number(10,4);
alter table DB_SAVENUM add sellcost8 number(10,4);
alter table DB_SAVENUM add sellcost9 number(10,4);
alter table DB_SAVENUM add sellcost10 number(10,4);
alter table DB_SAVENUM add sellcost11 number(10,4);
alter table DB_SAVENUM add sellcost12 number(10,4);
-------------------------
alter table db_expresstype add tokenconfigid varchar2(50);
alter table DB_EXPRESSTYPE add Token varchar2(100);
alter table DB_EXPRESSTYPE add UserKey varchar2(100);
alter table DB_EXPRESSTYPE add CustomUserKey varchar2(100);
alter table DB_EXPRESSTYPE add ExpressTypeNew varchar2(100);
alter table DB_EXPRESSTYPE add Contact varchar2(50);
alter table DB_EXPRESSTYPE add Compan varchar2(50);
alter table DB_EXPRESSTYPE add Street1 varchar2(100);
alter table DB_EXPRESSTYPE add Street2 varchar2(100);
alter table DB_EXPRESSTYPE add City varchar2(50);
alter table DB_EXPRESSTYPE add Province varchar2(100);
alter table DB_EXPRESSTYPE add Country varchar2(50);
alter table DB_EXPRESSTYPE add PostCode varchar2(20);
alter table DB_EXPRESSTYPE add Phone varchar2(20);
alter table DB_EXPRESSTYPE add Email varchar2(100);
alter table DB_EXPRESSTYPE add District varchar2(100);
alter table DB_EXPRESSTYPE add DistrictCode varchar2(20);
alter table DB_EXPRESSTYPE add CityCode varchar2(20);
alter table DB_EXPRESSTYPE add ProvinceCode varchar2(20);
alter table DB_EXPRESSTYPE add Length number(6);
alter table DB_EXPRESSTYPE add Width number(6);
alter table DB_EXPRESSTYPE add Height number(6);

alter table DB_EXPRESSTYPE add Cityid varchar2(50);
alter table DB_EXPRESSTYPE add Provinceid varchar2(100);
alter table DB_EXPRESSTYPE add Districtid varchar2(100);
alter table DB_EXPRESSTYPE add EXPRESSTYPEFEEID varchar2(50);
alter table DB_EXPRESSTYPE add filed14 varchar2(500);
alter table DB_EXPRESSTYPE add filed15 varchar2(500);
alter table DB_EXPRESSTYPE add filed16 varchar2(500);
alter table DB_EXPRESSTYPE add filed17 varchar2(500);
alter table DB_EXPRESSTYPE add filed18 varchar2(500);
alter table Db_Expresstype add nameen varchar2(100);
alter table db_shop add accesskeyid varchar2(400);
alter table db_shop add secretaccesskey varchar2(400);
alter table db_shop add applicationname varchar2(400);
alter table db_shop add sellerid varchar2(400);
alter table db_shop add marketplaceid varchar2(400);
alter table db_shop add starttime varchar2(200);
alter table db_shop add endtime varchar2(200);
alter table db_shop add amazon varchar2(200);
alter table db_shop add amazonflag varchar2(200);