
alter  table DB_PUBLISHPICTURE modify shoptypeid varchar2(100);
alter  table DB_PUBLISHPICTURE modify platformid varchar2(100);
alter table DB_ORDER_HISTORY modify LOCATIONID varchar2(4000);
---------------产品级别修改字段---------------------------
alter table DB_productclass modify AVGSELLNUM1 NUMBER(8,3) ;
alter table DB_productclass modify AVGSELLNUM2 NUMBER(8,3) ;
------------------------20130105 hj  -----------------------
alter table DB_EBAYORDERINFO modify ERRORINFO varchar2(4000);

---------------------------更新语句-------------------------
update db_product set reserve11 = 0 where savenum <= 0 and reserve11 is null;

update DB_PROTOCOL set OPENFLAG = '1';

alter table db_shop modify reserve13 varchar2(2000);
alter table db_order modify STORAGEID varchar2(2000);
alter table db_order modify LOCATION varchar2(2000);
alter table db_order modify LOCATIONID varchar2(2000);
update db_order set storageid = ','||storageid||',' where storageid is not null and storageid not like ',%';

------------------------20121203hj---------------------------------------
alter table db_storage modify FILED3 varchar2(4000);
alter table db_storagelog modify FILED3 varchar2(4000);

------------------------20121129 hp---------------------------------------
alter table db_order modify LOCATIONID varchar2(500);
-------------------------2012-11-26 lxd --------------------------

update DB_MANUFACTURE a set SKYPE=(select FILED8 from DB_MANUFACTURE b where a.SEQUENCEID=b.SEQUENCEID) where FILED8 is not null;
update DB_MANUFACTURE  set FILED8=null where FILED8 is not null;
------------------------------20130414 xiao5----------------------------------------------
alter table DB_CATEGORY add hkinsurancetype varchar2(50);
alter table DB_CATEGORY add HKCATEGORY varchar2(50);

alter table DB_PROTOCOL add OPENFLAG varchar2(50);

update DB_ASKTRADERNUMBER set errflag='1' where errflag in('97','98','99') and expressid is not null and ORDERTIME>sysdate-5;
update DB_ASKTRADERNUMBER set errflag='0' where errflag in('97','98','99') and expressid is null and ORDERTIME>sysdate-5;


update db_sell set feedback='6' where feedback in('1','2','3','4') and opertime <sysdate-2;
update db_sell set feedback='3' where reserve4 like '%usage limit%' and opertime>sysdate-5;
update db_sell set updateflag='3' where reserve5 like '%usage limit%' and opertime>sysdate-5;
update db_ebaymessage set updateflag='1',errorcount='4' where errorcount>=3;
update db_ebaymessage set updateflag='0',errorcount='3' where errordescr like '%usage limit%' and opertime>sysdate-5;

------------------------------20130417 xiao5----------------------------------------------
update db_order set Ebaycustomeraddress='Name:'||customername||chr(13)
||'Address:'||customeraddress||chr(13)
||'City:'||customercity||chr(13)
||'State:'||customerprovince||chr(13)
||'Country:'||customercountry||chr(13)
||'Postal code:'||customerzipcode||chr(13)
||'Tel:'||customertel1
 where ordertime>sysdate-50 and Ebaycustomeraddress is null;
alter table db_shop add amazonurlname varchar2(200);

update db_sell a  set a.costprice=nvl((select costprice from db_product b where a.productid=b.sid),0) where a.costprice  is null or  a.costprice=0;


update db_selltostat a  set a.costprice=nvl((select costprice from db_product b where a.productid=b.sid),0) where  a.costprice is null or  a.costprice=0;


alter table db_product add purchaseflag number(10);
alter table DB_TWODEVELOPMENTPRODUCT add developmenttime date;
alter table db_product modify SAVENUM number(10);
alter table db_product modify ORDERNUM number(10);
alter table db_product modify ALERTNUM number(10);
alter table db_product modify HJRESERVE8 number(10);
alter table db_product modify HJRESERVE9 number(10);
alter table db_product modify HJRESERVE10 number(10);
alter table db_product modify DEVELOPMENTFLAG number(10);
alter table db_product modify BUYNUM number(10);
alter table db_product modify MINALERNUM number(10);
alter table db_product modify SAVEDATE number(10);
alter table DB_TWODEVELOPMENTPRODUCT add purchaseflag number(10);
alter table db_shop add amazonurl varchar2(200);
alter table DB_PRODUCT add indexfordevelop varchar2(50);

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_EUBPROVINCE add provinceen varchar2(100);
alter table DB_EUBCITY add  cityen varchar2(100);
alter table DB_EUBDISTRICT add diten varchar2(100); 