﻿-------------------------权限问题
alter table db_sysadmin modify identifynum varchar2(200);
-----------------订单归档报错 xiao5---------------------
alter table DB_SELL_HISTORY modify RESERVE4 varchar2(500);
--------------防止smt漏单 xiao5-------
alter table db_sell modify productpic1 varchar2(500);
alter table db_order modify reserve4 varchar2(2000);
---------------------------关掉原来的4px配置菜单--------------------
----------有些paypal地址进不到系统中需要扩展以下两字段长度 xiao5------
alter table db_order modify PAYPALOPER VARCHAR2(100);
alter table db_paypal modify OPER VARCHAR2(100);
--------------DB_MANUFACTURE--------------
alter table DB_MANUFACTURE add DISTRICT VARCHAR2(200);
alter table DB_MANUFACTURE add arrivalcycle number(8);
--------------db_product_history--------------
alter table db_product_history add   HISTPAVGROFIT NUMBER(8,6);
alter table db_product_history modify PROFITT NUMBER(10,4);
alter table db_product_history modify HISTPROFIT NUMBER(10,4);
alter table db_product_history modify PROFITS NUMBER(10,4);
alter table db_product_history add GSTprice number(10,4);
alter table db_product_history add oceanshipprice number(10,4);
alter table db_product_history add fobprice number(10,4);
alter table db_product_history add cifprice number(10,4);
alter table db_product_history add expressprice number(10,4);
alter table db_product_history add profit number(10,4);
alter table db_product_history add BIDprofit number(10,4);
alter table db_product_history add fixedprofit number(10,4);
alter table db_product_history add BIDebayprice number(10,4);
alter table db_product_history add Fixedebayprice number(10,4);
alter table db_product_history add BIDnum number(10);
alter table db_product_history add storerent number(10,4);
alter table db_product_history add allpurchasenum number(15);
alter table db_product_history add MANUFACTUREQUOTE NUMBER(8,6);
alter table db_product_history add tariffprice number(8,4);
alter table db_product_history add PAYPALPRICE number(10,4);
alter table db_product_history add aliasku VARCHAR2(200);
alter table db_product_history add EBAYPRICE number(10,4);
alter table db_product_history add MANUFACTUREQUOTE NUMBER(8,6);
alter table  DB_PURCHASEFLOW  add weight number(8,2);
alter table db_product_history add tariffprice number(8,4);
alter table db_product_history add PAYPALPRICE number(10,4);
--BIN平均价
alter table db_product_history add bidavgprice number(8,2);
--BIN成交率
alter table db_product_history add bidturnoverrate number(8,2);
--BIN总金额
alter table db_product_history add bidtotalprice number(8,2);
--BIN7
alter table db_product_history add bid7day number(8);
--BIN30
alter table db_product_history add bid30day number(8);
--BIN60
alter table db_product_history add bid60day number(8);
--体积
alter table db_product_history add volume NUMBER(8, 2);
--单位重量
alter table db_product_history add SIZES VARCHAR2(100 byte);
--零售价
alter table db_product_history add SELLPRICE NUMBER(8, 2);
--长
alter table db_product_history add length number(8,2);
--宽
alter table db_product_history add width number(8,2);
--高
alter table db_product_history add high number(8,2);
--7天销量
alter table db_product_history add sales7 number(8,2);
--30天销量
alter table db_product_history add sales30 number(8,2);
--90天销量
alter table db_product_history add sales90 number(8,2);
--商品分级
alter table db_product_history add outerlevel varchar2(50);
--断货库存
alter table db_product_history add DHNUMBER NUMBER(4) default 0;
--子SKU
alter table db_product_history add mainsku VARCHAR2(200);
--------------db_purchaseflow --------------
alter table db_purchaseflow add ordernum NUMBER(10);
alter table db_purchaseflow add MANUFACTURE VARCHAR2(100);
alter table db_purchaseflow add MANUFACTUREID VARCHAR2(50);
alter table db_purchaseflowdevelop add paymenttype VARCHAR2(200);
alter table db_purchaseflow add paymenttype VARCHAR2(200);
alter table db_purchaseflow add INPORTPRICE NUMBER(12,4);
alter table db_purchaseflow add amount NUMBER(12,4);
alter table db_purchaseflow modify reserve6 number(12,4);
alter table db_purchaseflow modify SAMPLENUM NUMBER(10);
alter table db_purchaseflow modify RESERVE9 NUMBER(10);
alter table db_purchaseflow modify RESERVE10 NUMBER(10);
alter table db_purchaseflow modify RESERVE11 NUMBER(10);
alter table db_purchaseflow modify SEQUENCEID number(18);
alter table db_purchaseflow modify reserve5 VARCHAR2(100);
alter table db_purchaseflow modify reserve12 number(12,4);
alter table db_purchaseflow rename column reserve7 to inporttime;
alter table db_purchaseflow rename column reserve8 to stocktime;
---------------------------db_purchaseflowdevelop -------------------------------
alter table db_purchaseflowdevelop add amount NUMBER(12,4);
alter table db_purchaseflowdevelop add discount1 number(12,4);
alter table db_purchaseflowdevelop add ordernum number(10);
alter table db_purchaseflowdevelop add classnum number(10);
alter table db_purchaseflowdevelop add developtotalvolume number(12,4);
alter table db_purchaseflowdevelop add DISTRICT VARCHAR2(500);
--------------DB_CATEGORY--------------
alter table DB_CATEGORY add TEMPLET varchar2(20);
alter table db_category add customscode varchar2(50);
alter table db_category add SHORTSKU varchar2(5);
alter table DB_CATEGORY add CUSTOMSCODE VARCHAR2(50);
--------------DB_PRODUCE_NEW--------------
ALTER TABLE DB_PRODUCE_NEW  add rate NUMBER(8,4);
ALTER TABLE DB_PRODUCE_NEW  add country varchar2(100);
alter table DB_PRODUCE_NEW modify productid VARCHAR2(100);
--------------db_returnmanagerment --------------
alter table db_returnmanagerment add keywords varchar2(50);
--------------db_productfordescr--------------
alter table db_productfordescr add descr2 varchar2(4000);
alter table db_productfordescr add descr3 varchar2(4000);
alter table db_productfordescr add descr4 varchar2(4000);
alter table db_productfordescr add descr5 varchar2(4000);
---------------------db_productforsel--------------------
alter table db_productforsell add   ONEWEEKNUM NUMBER(10);
alter table db_productforsell add   TWOWEEKNUM NUMBER(10);
alter table db_productforsell add   THREEWEEKNUM NUMBER(10);
alter table db_productforsell add   FOURWEEKNUM NUMBER(10);
alter table db_productforsell add   US VARCHAR(50);
alter table db_productforsell add   AU VARCHAR(50);
alter table db_productforsell add   UK VARCHAR(50);
alter table db_productforsell add   CA VARCHAR(50);
alter table db_productforsell add   DE VARCHAR(50);
alter table db_productforsell add descrflag varchar2(1);
alter table db_productforsell add photoflag varchar2(1);
alter table db_productforsell add status1 varchar2(1);
alter table db_productforsell add seasonflag varchar2(1);
alter table db_productforsell add attribute varchar2(1);
alter table db_productforsell add onestage varchar2(1);
alter table db_productforsell add twostage varchar2(1);
alter table db_productforsell add avgnum number(10,2);
alter table db_productforsell add onemonth varchar2(1);
alter table db_productforsell add newsall number(10);
alter table db_productforsell add news number(10);
alter table db_productforsell add tasknum number(10);
alter table db_productforsell add reserve9 number(10,4);
alter table db_productforsell add reserve10 number(10,4);
alter table db_productforsell add reserve11 number(10,4);
alter table db_productforsell add reserve12 number(10,2);
alter table db_productforsell add maoli number(10,2);
alter table db_productforsell add expresstype1 varchar2(100);
alter table db_productforsell add expresstype2 varchar2(100);
alter table db_productforsell add expresstype3 varchar2(100);
alter table db_productforsell add expresstype4 varchar2(100);
alter table db_productforsell add expresstype5 varchar2(100);
alter table db_productforsell add reserve13 number(10,2);
alter table db_productforsell add reserve14 number(10,2);
---------------db_shop--------------
alter table db_shop add ebayshopid varchar2(100);
alter table db_shop add ebayshopname varchar2(100);
alter table db_shop add orderoper number(5);
alter table db_shop add PAYPALEMAIL VARCHAR2(100);
alter table db_shop add AMAZONURL VARCHAR2(200);
alter table db_shop add AMAZONURLNAME VARCHAR2(200);
--------------------db_sellforshop-----------------------
alter table db_sellforshop add ebayshopid varchar2(100);
alter table db_sellforshop add ebayshopname varchar2(100);
alter table db_sellforshop add sort number(3);
-----------------db_sellskuforshop---------------------
alter table db_sellskuforshop add  flagus NUMBER(10);
alter table db_sellskuforshop add  flagau NUMBER(10);
alter table db_sellskuforshop add  flaguk NUMBER(10);
alter table db_sellskuforshop add  flagca NUMBER(10);
alter table db_sellskuforshop add  flagde NUMBER(10);
-------------------db_spbase-------------------------
alter table db_spbase add assignflag number(8);
---------------------db_order---------------------
alter table db_order add orderoper number(5) ;
alter table db_order add TRADETYPEFLAG NUMBER(2);   
alter table db_order add CONTENTFLAG NUMBER(2);
alter table db_order add NOTESTOYOURSELFFLAG NUMBER(2);
alter table db_order add ORIGINSKU VARCHAR2(3000);
---------------------db_orderlog---------------------
alter table db_orderlog add orderoper number(5) ;
-------------------Db_Projectsku-----------------------------
alter table Db_Projectsku add sid varchar2(200);
--跟进标志
alter table DB_PROJECTSKU add IMGURL varchar2(500) ;
--销售项目sku完成时间
alter table db_projectsku add checktime DATE;
--销售项目sku状态1为完成
alter table db_projectsku add checkflag number(10);
-------------------Db_projectbbs ------------------------
alter table Db_projectbbs add clipartflag number(5) ;
alter table Db_projectbbs add salesflag number(5) ;
alter table Db_projectbbs add checkflag number(5) ;
alter table Db_projectbbs add estimatedstarttime date ;
--项目管理预计结束时间点
alter table Db_projectbbs add estimatedendtime date ;
--开始时间点
alter table Db_projectbbs add starttime date ;
--结束时间点
alter table Db_projectbbs add endtime date ;
--状态
alter table Db_projectbbs add STATUS number(8,2);
-------------------- DB_MULTI_WAREHOUSE --------------------
alter table DB_MULTI_WAREHOUSE modify sequenceid VARCHAR2(50);
----------------------db_expresstyperule------------------------------
alter table  db_expresstyperule modify expresstypeid varchar2(50);
ALTER TABLE DB_EXPRESSTYPERULE add formula varchar2(500);
-------------------DB_PRODUCTDEVELOPFORSON -----------------------
alter table DB_PRODUCTDEVELOPFORSON modify RESERVE2 varchar(500);
--------------------DB_PRODUCTDEVELOP -----------------------
alter table DB_PRODUCTDEVELOP add lengthnum NUMBER(8,2);
alter table DB_PRODUCTDEVELOP add widthnum NUMBER(8,2);
alter table DB_PRODUCTDEVELOP add heightnum NUMBER(8,2);
alter table db_productdevelop add deliverytime date;
alter table db_productdevelop add totalassess number(10);
alter table db_productdevelop add yieldly varchar2(50);
alter table db_productdevelop add finidhtime date;
alter table db_productdevelop add CHECKSIMPLETIME date;
----------------------DB_FPXPRINTLEBAL -----------------------------
alter table  DB_FPXPRINTLEBAL add DIUNITPRICE varchar2(50);
----------------------Db_Caiwu ----------------
alter table   Db_Caiwu add country varchar2(50);   ---国家
alter table   Db_Caiwu add ponumber varchar2(50);      -- PO订单
alter table   Db_Caiwu add menufuncter varchar2(50);      --- 厂家（供应商）
alter table   Db_Caiwu add menufuncterid varchar2(10);     --    厂家id（供应商）
alter table   Db_Caiwu add paymenttype varchar2(50);--           付款方式
alter table   Db_Caiwu add sendtime DATE;            --   出货时间
alter table   Db_Caiwu add toporttime DATE;        --     到港口时间
alter table   Db_Caiwu add depositstime DATE;     --  -  订金付款时间
alter table   Db_Caiwu add sendpaytime DATE;   --      出货付款日期
alter table   Db_Caiwu add toportpaytime DATE;  --      到港付款日期
alter table   Db_Caiwu add finalpaytime DATE;   --付最终款日期
alter table   Db_Caiwu add amountrmb number(10,4);     --总金额(人民币)
alter table   Db_Caiwu add amountusd number(10,4);      --    总金额(美元)
alter table   Db_Caiwu add deposits number(10,4); --订金
alter table   Db_Caiwu add paymentmoney number(10,4);   --       已付款
alter table   Db_Caiwu add nopaymenymoney number(10,4);    --     未付款
alter table   Db_Caiwu add sendmoney number(10,4);        --出货金额
alter table   Db_Caiwu add toportmoney number(10,4);         --  到港金额
alter table   Db_Caiwu add finalmoney number(10,4);       --最终金额
alter table db_caiwu add productid varchar2(50);  --商品编号
alter table db_caiwu add amountrmbflag number(10);
alter table db_caiwu add depositsflag number(10);
alter table db_caiwu add sendmoneyflag number(10);
alter table db_caiwu add toportmoneyflag number(10);
alter table db_caiwu add finalmoneyflag number(10);
alter table db_caiwu add accountmoney number(10,4);  --已付款
alter table db_caiwu add nonpaymentmoney number(10,4); --未付款
alter table db_caiwu modify AMOUNTRMB  number(15,4);
alter table db_caiwu modify AMOUNTUSD  number(15,4);
alter table db_caiwu modify DEPOSITS  number(15,4);
alter table db_caiwu modify PAYMENTMONEY  number(15,4);
alter table db_caiwu modify NOPAYMENYMONEY  number(15,4);
alter table db_caiwu modify SENDMONEY  number(15,4);
alter table db_caiwu modify TOPORTMONEY  number(15,4);
alter table db_caiwu modify FINALMONEY  number(15,4);
alter table db_caiwu modify ACCOUNTMONEY  number(15,4);
alter table db_caiwu modify NONPAYMENTMONEY number(15,4);
----------------------DB_CALCULATEITEM ----------------
alter table DB_CALCULATEITEM add QUANTITYSOLD60 NUMBER(10);  --60天销量
-------------------DB_FPXPRINTLABEL -----------------------------------
--fpx标签 新加坡挂号分区
alter table DB_FPXPRINTLABEL add districtcode VARCHAR2(200);
--------------------------db_ordersearch ------------------
alter table db_ordersearch add paypaldispute varchar2(1);
alter table db_ordersearch add ebaydispute varchar2(1);
alter table db_ordersearch add bansend varchar2(1);
alter table db_ordersearch add paypaldisputeflag varchar2(1);
alter table db_ordersearch add ebaydisputeflag varchar2(1);
alter table db_ordersearch add bansendflag varchar2(1);
alter table db_ordersearch add filed30 varchar2(500);
alter table db_ordersearch add flag30 varchar2(500);
--------------------db_outcategorysell ---------------------
--万邑通
alter table db_outcategorysell add recordid varchar2(20);
----------------------db_purchasedevelop-----------------------
alter table db_purchasedevelop add GROUPID VARCHAR2(100);             
alter table db_purchasedevelop add CREATOPER VARCHAR2(100);          
alter table db_purchasedevelop add CORPID VARCHAR2(100);            
alter table db_purchasedevelop add OPENFLAG VARCHAR2(10);           
alter table db_purchasedevelop add SLEVEL VARCHAR2(50);             
alter table db_purchasedevelop add STATUS NUMBER(1);                
alter table db_purchasedevelop add TRACKINGNUMBER VARCHAR2(100);    
alter table db_purchasedevelop add WEIGHTAMOUNT NUMBER(12,4);       
alter table db_purchasedevelop add MONEYAMOUNT NUMBER(12,4);         
alter table db_purchasedevelop add ARRIVETIME DATE;                 
alter table db_purchasedevelop add INPORTTIME DATE;  
alter table db_purchasedevelop add MANUFACTUREID VARCHAR2(100); 
---------------------------- DB_PRODUCT --------------------------------
alter table DB_PRODUCT add PRODUCTNAME varchar2(500);
alter table DB_PRODUCT add PURCHASEFLAG varchar2(10);
alter table DB_PRODUCT add INDEXFORDEVELOP varchar2(50);
alter table DB_PRODUCT add PRODUCTNAME VARCHAR2(500);  
alter table DB_PRODUCT add GROSSPROFIT number(10,4);
alter table DB_PRODUCT add RATEOFMARGIN number(10,4);
--------------------DB_TWODEVELOPMENTPRODUCT -------------------
alter table DB_TWODEVELOPMENTPRODUCT add purchaseflag number(10);
alter table DB_TWODEVELOPMENTPRODUCT add developmenttime date;
------------------------DB_EBAYMESSAGEBIND -------------------------
alter table db_ebaymessagebind add sort number(2) ;
alter table DB_EBAYMESSAGEBIND add SORT NUMBER(2);
----------------------------db_purchase -------------------------------
alter table db_purchase add payflag varchar2(10);
alter table db_purchase add discount1 number(10,2);
alter table db_purchase add discount2 number(10,2);
alter table db_purchase add discount3 number(10,2);
alter table db_purchase add discount4 number(10,2);
alter table db_purchase add havepayed number(8);
alter table db_purchase add notpayed number(8);
alter table db_purchase add PURCHASEINDEXID NUMBER(10);
alter table db_purchase add PRODUCTNAME VARCHAR2(500);
alter table db_purchase add PRODUCTNAME varchar2(500);
alter table db_purchase add PURCHASEINDEXID number(10);
----------------------------db_purchaselog -------------------------------
alter table db_purchaselog add RESERVE6 number(2);
alter table db_purchaselog add RESERVE6 number(2);
-------------------------DB_PURCHASEQUESTION ------------------------------
alter table DB_PURCHASEQUESTION add reserve6 varchar2(2);
alter table DB_PURCHASEQUESTION modify ORDERNUM number(10);
alter table DB_PURCHASEQUESTION modify ACTUALNUM number(10);
alter table DB_PURCHASEQUESTION modify SAVENUM number(10);
alter table DB_PURCHASEQUESTION modify RECEIVENUM number(10);
alter table DB_PURCHASEQUESTION modify RETURNNUM number(10);
alter table DB_PURCHASEQUESTION add RESERVE6 VARCHAR2(2);
--------------------------DB_IMGCONFIG ------------------------------
alter table DB_IMGCONFIG add FILED11 VARCHAR2(500);
alter table DB_IMGCONFIG add FILED12 VARCHAR2(500);
alter table DB_IMGCONFIG add FILED13 VARCHAR2(500);
alter table DB_IMGCONFIG add FILED14 VARCHAR2(500);
alter table DB_IMGCONFIG add FILED15 VARCHAR2(500);
-----------------------DB_SALESCOEFFICIENT --------------------------
alter table DB_SALESCOEFFICIENT add ALERTNUM NUMBER(4);
alter table DB_SALESCOEFFICIENT add PURCHASENUM NUMBER(4);
alter table DB_SALESCOEFFICIENT add SORT NUMBER(2);
----------------------DB_ANTISTOP ------------------------
alter table DB_ANTISTOP add NAME VARCHAR2(200);
alter table DB_ANTISTOP add REMARK VARCHAR2(4000);
alter table DB_ANTISTOP add TOTALSALES VARCHAR2(50);
alter table DB_ANTISTOP add TOTALLISTINGS VARCHAR2(50);
alter table DB_ANTISTOP add SUCESSFULLISTING VARCHAR2(50);
alter table DB_ANTISTOP add BIDS VARCHAR2(50);
alter table DB_ANTISTOP add ITEMSSOLD VARCHAR2(200);
alter table DB_ANTISTOP add AVERAGEPRICE VARCHAR2(50);
alter table DB_ANTISTOP add SELLTHROUGH VARCHAR2(200);
alter table DB_ANTISTOP add RANK VARCHAR2(50);
alter table DB_ANTISTOP add SORT NUMBER(5);
alter table DB_ANTISTOP add NAME VARCHAR2(200); 
alter table DB_ANTISTOP add REMARK VARCHAR2(4000);
alter table DB_ANTISTOP add TOTALSALES VARCHAR2(50);
alter table DB_ANTISTOP add TOTALLISTINGS VARCHAR2(50);
alter table DB_ANTISTOP add SUCESSFULLISTING VARCHAR2(50);
alter table DB_ANTISTOP add BIDS VARCHAR2(50);
alter table DB_ANTISTOP add ITEMSSOLD VARCHAR2(200);
alter table DB_ANTISTOP add AVERAGEPRICE VARCHAR2(50); 
alter table DB_ANTISTOP add SELLTHROUGH VARCHAR2(200);
alter table DB_ANTISTOP add RANK VARCHAR2(50);
alter table DB_ANTISTOP add SORT number(5);
----------------------DB_PUBLISHPICTURE -----------------------
alter table DB_PUBLISHPICTURE add ATTRIBUTEID VARCHAR2(50);
alter table DB_PUBLISHPICTURE add USEING VARCHAR2(50);
alter table DB_PUBLISHPICTURE add OPENFLAG VARCHAR2(10);
alter table DB_PUBLISHPICTURE add ATTRIBUTEID VARCHAR2(50);
alter table DB_PUBLISHPICTURE add USEING VARCHAR2(50);
alter table DB_PUBLISHPICTURE add OPENFLAG VARCHAR2(10);
--------------------DB_EUBPROVINCE  -------------------------
alter table DB_EUBPROVINCE  add  PROVINCEEN VARCHAR2(100);
---------------------DB_EUBCITY -------------------------
alter table DB_EUBCITY add CITYEN VARCHAR2(100);
--------------------DB_EUBDISTRICT ------------------
alter table DB_EUBDISTRICT add DITEN VARCHAR2(100);
---------------------DB_PROTOCOL ----------------------
alter table DB_PROTOCOL add TYPEFLAG VARCHAR2(5);
alter table DB_PROTOCOL add RESERVE14 VARCHAR2(100);
-----------------------db_sysadmin---------------------------------
alter table db_sysadmin add operid number(4);
-----------------------------update----------------------------
update db_menufunc set funname='销售项目管理' where funname='项目管理1';
update DB_MENUFUNC set reserve2='menu2'||substr(reserve2, 5) where reserve2 is not null and funid not in(select funid from DB_MENUFUNC where reserve2 like '%menu2%' );
--index页面标题菜单缩减样式
---------------------------------------------cy 2013-08-28-----------------------------------
alter table Db_purchase add RESERVE15 VARCHAR2(2000);
---------------------------------------------fst 2013-08-30-----------------------------------
alter table db_productdevelop modify deliverytime varchar2(100);
alter table db_Sysadmin add menuid VARCHAR2(3000);\
alter table db_salescoefficientlog add ALERTNUM NUMBER(10,4);
alter table db_salescoefficientlog add PURCHASENUM NUMBER(10,4);
alter table db_sendmessage add RETURNID NUMBER(18);
alter table db_sendlist add selluser varchar2(100);--卖家账号
alter table db_sendlist add selluser varchar2(100);--买家编号
alter table db_sendlist add expressid varchar2(50); --货运单号
alter table db_sendlist add skus varchar2(500);  --SKU
alter table db_sendlist add ebayitemids varchar2(500); --ebayitemid
-----------hj----------
alter table DB_PRODUCT_HISTORY add CREATETIME date;   --创建时间
---------------hp----------------------
alter table db_sendmessage add RETURNID NUMBER(18);
alter table db_sendlist add selluser varchar2(100);--卖家账号
alter table db_sendlist add selluser varchar2(100);--买家编号
alter table db_sendlist add expressid varchar2(50); --货运单号
alter table db_sendlist add skus varchar2(500);  --SKU
alter table db_sendlist add ebayitemids varchar2(500); --ebayitemid
----------------------fst  purchasedevelop  少的字段-----
alter table db_purchasedevelop add CONTENT VARCHAR2(2000);
alter table db_product_history add bidprice number(9,4);
alter table db_product_history add bargainrate number(8,2);  --成交率
alter table db_product_history add advertisement varchar2(500);   --  广告形式
alter table db_product_history add opertime date;
alter table db_product_history add oper varchar2(50);
alter table db_product_history add updatetime date;
alter table db_product_history add tocolsort number(10,0);
alter table db_product_history add tocollong number(10,0);
alter table db_product_history add fixprofit number(10,4); 
alter table db_product_history add profit number(10,4); 
alter table db_product_history add cifprice number(10,4);   
alter table db_product_history add post number(10,4);    
alter table db_product_history add paypalbidfee number(10,4);    
alter table db_product_history add paypalfixfee number(10,4);
alter table db_product_history add ebaybidfee number(10,4); 
alter table db_product_history add ebayfixfee number(10,4);    
alter table db_product_history add onlinetime date;
alter table db_product_history add sellnumdescrby7d varchar2(500);  
alter table db_product_history add sellnumdescrby7c varchar2(500);
alter table db_product_history add sellnumdescrby7b varchar2(500);
alter table db_product_history add sellnumdescrby7a varchar2(500);  
alter table db_product_history add sellnumby7d number(10,4);
alter table db_product_history add sellnumby7c number(10,4);
alter table db_product_history add sellnumby7b number(10,4);
alter table db_product_history add sellnumby7a number(10,4);
alter table db_product_history add sellthrough number(10,4);
alter table db_product_history add clickthrough number(10,4);
alter table db_product_history add impressions number(10,4);
alter table db_product_history add todayoedernum number(10,0);
alter table db_product_history add monthbidnum number(10,0);
alter table db_product_history add oldordernum number(10,0);    
alter table db_product_history add sixdaysales number(10,4);
alter table db_product_history add ndaysales number(10,4);
alter table db_product_history add outerlevel varchar2(50);
alter table db_product_history add manufacture varchar2(200);
alter table db_product_history add manufactureid varchar2(50);    
alter table db_product_history add category varchar2(200);
alter table db_product_history add categoryid varchar2(50);  
alter table db_product_history add sellprice number(9,4); 
alter table db_product_history add purprice number(9,4);
alter table db_product_history add profitpercent number(9,4);
alter table db_product_history add fixprice number(9,4);
alter table db_product_history add savenumcbm number(10,4);  
alter table db_product_history add savenumcif number(10,4);   
alter table db_product_history add needorder number(9,0);  
alter table db_product_history add monthsavenum number(9,0);
alter table db_product_history add productionnumday number(9,4);
alter table db_product_history add productionnum number(9,0); 
alter table db_product_history add allotnumday number(9,4);
alter table db_product_history add allotnum number(9,0);    
alter table db_product_history add purchasenumday number(9,4);
alter table db_product_history add purchasenum number(9,0);    
alter table db_product_history add savenumday number(9,4);
alter table db_product_history add savenum number(9,0); 
alter table db_product_history add allsavenumday number(9,4);
alter table db_product_history add allsavenum number(9,0);
alter table db_product_history add dailymeansales number(9,4);
alter table db_product_history add selloper varchar2(50);
alter table db_product_history add puroper varchar2(50);
alter table db_product_history add productid varchar2(50);
-----------------2013-09-24----cy--------
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(10);              
alter table db_expresstype add WIDTH		NUMBER(10);                
alter table db_expresstype add HEIGHT		NUMBER(10);              
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 CKYFLAG		NUMBER(10);              
alter table db_expresstype add INSURED		NUMBER(12,4);            
alter table db_expresstype add CODE		VARCHAR2(100);             
alter table db_expresstype add STORAGENAME		VARCHAR2(200);       
alter table db_expresstype add STORAGECODE		VARCHAR2(100); 
------------------------------------hj 2013-09-18-----------------------------------
alter table db_produce_new add NEWPRODUCTID varchar2(50);
alter table db_produce_new add EXPRESSFEE NUMBER(12,4);
alter table db_produce_new add SELLSTATUS NUMBER(10);
alter table db_produce_new add HISTORYSAVENUM NUMBER(10);
alter table db_produce_new add HISTORYCIFPRICE NUMBER(20,4);
alter table db_produce_new add HISTORYPROFITAMOUNT NUMBER(20,4);
alter table db_produce_new add INTRANSITDAY NUMBER(12,4);
alter table db_produce_new add INTRANSITNUM NUMBER(10);
alter table db_produce_new add PRODUCENUM NUMBER(10);
alter table db_produce_new add SAVENUMMONEY NUMBER(12,4);
alter table db_produce_new add CLASSPROFIT NUMBER(12,4);
alter table db_produce_new add PRODUCTCONTRIBUTIONS NUMBER(12,4);
alter table db_produce_new add MONTHLYPROFITABC varchar2(5);
alter table db_produce_new add FPROFITABC varchar2(5);
alter table db_produce_new add TURNOVERDAY NUMBER(12,4);
alter table db_produce_new add MONTHPROFITS NUMBER(12,4);
alter table db_produce_new drop column INTRANSITDAY;
alter table db_produce_new drop column INTRANSITNUM;
alter table db_produce_new drop column PRODUCENUM;
alter table db_produce_new drop column SAVENUMMONEY;
alter table db_produce_new drop column HISTORYSAVENUM;
alter table db_produce_new drop column HISTORYCIFPRICE;
alter table db_produce_new drop column HISTORYPROFITAMOUNT;
alter table db_produce_new drop column CLASSPROFIT;
alter table db_produce_new drop column PRODUCTCONTRIBUTIONS;
alter table db_produce_new drop column MONTHLYPROFITABC;
alter table db_produce_new drop column FPROFITABC;
alter table db_produce_new drop column TURNOVERDAY;
alter table db_produce_new drop column MONTHPROFITS;
alter table db_product_history add HISTORYSAVENUM NUMBER(10);
alter table db_product_history add HISTORYCIFPRICE NUMBER(20,4);
alter table db_product_history add HISTORYPROFITAMOUNT NUMBER(20,4);
alter table db_product_history add CLASSPROFIT NUMBER(12,4);
alter table db_product_history add PRODUCTCONTRIBUTIONS NUMBER(12,4);
alter table db_product_history add MONTHLYPROFITABC varchar2(5);
alter table db_product_history add FPROFITABC varchar2(5);
alter table db_product_history add TURNOVERDAY NUMBER(12,4);
alter table db_product_history add MONTHPROFITS NUMBER(12,4);
alter table db_product_history2 add HISTORYSAVENUM NUMBER(10);
alter table db_product_history2 add HISTORYCIFPRICE NUMBER(20,4);
alter table db_product_history2 add HISTORYPROFITAMOUNT NUMBER(20,4);
alter table db_product_history2 add CLASSPROFIT NUMBER(12,4);
alter table db_product_history2 add PRODUCTCONTRIBUTIONS NUMBER(12,4);
alter table db_product_history2 add MONTHLYPROFITABC varchar2(5);
alter table db_product_history2 add FPROFITABC varchar2(5);
alter table db_product_history2 add TURNOVERDAY NUMBER(12,4);
alter table db_product_history2 add MONTHPROFITS NUMBER(12,4);
alter table db_product_history add REFUNDRATE NUMBER(12,4);
alter table db_product_history add MONTHCLASSPROFIT NUMBER(12,4);
alter table db_product_history add CHANGEAMOUNT NUMBER(12,4);
alter table db_product_history add LITERRATIO NUMBER(12,4);
alter table db_product_history add CLASSCONTRIBUTIONRATIO NUMBER(12,4);
alter table db_product_history add MONTHREFUNDRATE NUMBER(12,4);
alter table db_product_history add HISTORYAVGPROFITRATIO NUMBER(12,4);
alter table db_product_history add HISTORYAVGPROFIT NUMBER(12,4);
alter table db_product_history add HISTORYNETPROFITAMOUNT NUMBER(12,4);
alter table db_product_history add volumeweight number(12,4);
alter table db_product_history add GST number(12,4);
alter table db_product_history2 add REFUNDRATE NUMBER(12,4);
alter table db_product_history2 add MONTHCLASSPROFIT NUMBER(12,4);
alter table db_product_history2 add CHANGEAMOUNT NUMBER(12,4);
alter table db_product_history2 add LITERRATIO NUMBER(12,4);
alter table db_product_history2 add CLASSCONTRIBUTIONRATIO NUMBER(12,4);
alter table db_product_history2 add MONTHREFUNDRATE NUMBER(12,4);
alter table db_product_history2 add HISTORYAVGPROFITRATIO NUMBER(12,4);
alter table db_product_history2 add HISTORYAVGPROFIT NUMBER(12,4);
alter table db_product_history2 add HISTORYNETPROFITAMOUNT NUMBER(12,4);
alter table db_product_history2 add volumeweight number(12,4);
alter table db_product_history2 add GST number(12,4);
alter table db_product_history add TARIFF number(12,4);
alter table db_product_history2 add TARIFF number(12,4);
alter table DB_PRODUCTFORSELL add NUMFORDESCR number(8);
alter table DB_PRODUCTFORSELL add NUMFORSHOP number(8);
alter table DB_PRODUCTFORSELL add NUMFORONLINESHOP number(8);
alter table DB_PRODUCTFORSELL add SODEFORONLINEITEM number(8);
alter table DB_PRODUCTFORSELL add NUMFORONLINEITEM number(8);
alter table DB_PRODUCTFORSELL add NUMFORSKU number(8);
alter table DB_PRODUCTFORSELL add PURCHASEOPER varchar2(50);
alter table DB_PRODUCTFORSELL add SELLOPER varchar2(50);
alter table DB_PRODUCTFORSELL add CATEGORYNAME varchar2(500);
alter table DB_PRODUCTFORSELL add CATEGORYID varchar2(50);
alter table DB_PRODUCTFORSELL add STATUS varchar2(10);
--------fst------2013-09-24---------
alter table DB_PRODUCT_HISTORY add BIDPRICE NUMBER(9,4);
alter table DB_PROTOCOL add OPENFLAG VARCHAR2(50);
----------hp--------2013-09-26---------------------
alter table DB_PROTOCOL add timetype number(2);
------------------fst  文件上传 保存 文件名的 以前21 太小修改200
alter table db_uploadfile modify reserve2 varchar2(200);

---LYT专用
alter table  db_back_money add createtime date;--创建时间
alter table  db_back_money add operflag varchar2(10);
alter table  db_back_money add corpid varchar2(50);
alter table  db_back_money add createoper varchar2(20);

alter table DB_PRODUCE_NEW add GENERALDELIVERY VARCHAR2(200);
alter table DB_PRODUCE_NEW add GENERALDELIVERYFEE NUMBER(12,4);
alter table DB_PRODUCE_NEW add EXPEDITEDCOURIER VARCHAR2(200);
alter table DB_PRODUCE_NEW add EXPEDITEDCOURIERFEE NUMBER(12,4);
alter table DB_PRODUCE_NEW add WAREHOUSERENTAL NUMBER(12,4);
alter table DB_PRODUCE_NEW add HANDLINGCHARGES NUMBER(12,4);
alter table DB_PRODUCE_NEW add QUALITYRATING VARCHAR2(200);
alter table DB_FAQQUESTION add openflag number(10);
alter table DB_FAQQUESTION add sku varchar2(100);
alter table DB_PURCHASE add reserve15 varchar2(15);
alter table db_caiwu add depositstime  date;
alter table db_caiwu add sendmoneytime  date;
alter table db_caiwu add toportmoneytime  date;
alter table db_caiwu add finalmoneytime  date;
alter table db_caiwu add depositsstime  date;
alter table db_caiwu add descr varchar2(2000);
----------------------------------fst 20131013 产品开发流程保存图片 更改大小---------------------
alter table db_productdevelop modify PICTURE VARCHAR2(500);
alter table db_project   modify PRODUCTID varchar2(4000);--修改大小
alter table db_projectlog   modify PRODUCTID varchar2(4000); --自定义报表
alter table db_ordersearch add filed31 varchar2(500); --美国省份
alter table db_ordersearch add flag31 varchar2(50);
---------------------------------20131020 hj
alter table db_produce_new rename column sellstatus to status;
alter table db_manufacture add categoryid varchar2(50);
alter table db_manufacture add categoryname varchar2(100);
alter table DB_PRODUCTANDMANUFACTURE add EVALUATION varchar2(50);      
alter table DB_PRODUCTANDMANUFACTURE add INFORMATION varchar2(500);
alter table DB_PRODUCTANDMANUFACTURE add STYLE varchar2(500);
alter table DB_PRODUCTANDMANUFACTURE add REPAIRRATE varchar2(20);
alter table DB_PRODUCTANDMANUFACTURE add ATTESTATION varchar2(500);
alter table DB_PRODUCTANDMANUFACTURE add PACKAGING varchar2(200);   
alter table DB_PRODUCTANDMANUFACTURE add IMPORTRIGHT varchar2(100);
alter table DB_PRODUCTANDMANUFACTURE add SERVE varchar2(50);
alter table DB_PRODUCTANDMANUFACTURE add EVALUATION varchar2(50); 
alter table DB_PRODUCTANDMANUFACTURE add MANAGEPRODUCT varchar2(500);
alter table DB_PRODUCTANDMANUFACTURE add LINKMAN varchar2(50);   
alter table DB_PRODUCTANDMANUFACTURE add SURVEYTABLE varchar2(500);   
alter table DB_PRODUCTANDMANUFACTURE add PERSONNUM number(10); 
alter table DB_PRODUCTANDMANUFACTURE add MAINMARKET varchar2(500); 
alter table DB_PRODUCTANDMANUFACTURE add PROFESSIONAL varchar2(10); 
alter table DB_PRODUCTANDMANUFACTURE add PRICEFIXING varchar2(10);      
alter table DB_PRODUCTANDMANUFACTURE add RESTS varchar2(500);
alter table DB_PRODUCTANDMANUFACTURE add MANUFACTUREURL varchar2(500);
alter table DB_PRODUCTANDMANUFACTURE add RESERVE5 varchar2(200);  
alter table DB_PRODUCTANDMANUFACTURE add RESERVE6 varchar2(200);
alter table DB_PRODUCTANDMANUFACTURE add RESERVE7 varchar2(200);
alter table DB_PRODUCTANDMANUFACTURE add RESERVE8 varchar2(200);
ALTER TABLE DB_ORDER ADD FPXEXPRESSTYPE VARCHAR2(100);
ALTER TABLE DB_ORDER ADD FPXEXPRESSTYPEID VARCHAR2(20);
ALTER TABLE DB_ORDER ADD WAREHOUSE VARCHAR2(200);
ALTER TABLE DB_ORDER ADD TRADETYPEFLAG NUMBER(2);
ALTER TABLE DB_ORDER ADD NOTESTOYOURSELFFLAG NUMBER(2);
ALTER TABLE DB_ORDER ADD CONTENTFLAG NUMBER(2);
ALTER TABLE DB_ORDER ADD ORDEROPER NUMBER(5);
ALTER TABLE DB_ORDER ADD ORIGINSKU VARCHAR2(3000);  
ALTER TABLE DB_ORDER ADD ITEMSIGN varchar2(50);
ALTER TABLE DB_ORDER ADD ORDERSIGN varchar2(50);
ALTER TABLE DB_ORDER ADD ERRORDESCR varchar2(4000);
ALTER TABLE DB_ORDER ADD CKYFLAG NUMBER(2);
ALTER TABLE DB_ORDER ADD LENGTH NUMBER(5);
ALTER TABLE DB_ORDER ADD WEIDTH NUMBER(5);
ALTER TABLE DB_ORDER ADD HEIGHT NUMBER(5);
alter table  DB_CALCULATEALL add costfiled8 NUMBER(8,5);
alter table  DB_CALCULATEALL add costfiled9 NUMBER(8,5);
alter table  db_cal_among add costfiled8 NUMBER(8,5);
alter table  db_cal_among add costfiled9 NUMBER(8,5);
alter table db_status add checkflag varchar(10);--审核
alter table db_order_temp add content varchar2(4000);
ALTER TABLE "DB_CAIWULOG" RENAME COLUMN "MOEY" TO "MONEY";
alter table db_status add checkflag varchar(10);--审核
alter table db_productforsell add picturestr  varchar2(4000);--图片配置
alter table DB_SELLFORSHOP add descr  varchar2(500);
alter table Db_Protocol add action VARCHAR2(100);
alter table DB_PURCHASE add PURCHASEFLAG number(2);
alter table db_sell modify productpic1 varchar2(500);
alter table db_order modify reserve4 varchar2(2000);
alter table db_order modify PAYPALOPER varchar2(100); --paypal用户名过长 fst修改
alter table DB_PROJECT add PRODUCTSKU clob;
alter table db_shop add shopmanager VARCHAR2(50);--shop添加店长字段