-----------------------hj 20130528---------------------------
alter table db_order add fpxexpresstypeid VARCHAR2(20);
alter table db_order add fpxexpresstype VARCHAR2(100);
alter table db_order modify sellnum number(10);
alter table db_order modify delaydays number(10);
alter table db_order modify ordernum number(10);
alter table db_order modify negativenum number(10);
alter table db_order modify neutralnum number(10);
alter table db_order modify positivenum number(10);
alter table DB_MANUFACTURE add CATEGORYID VARCHAR2(50);
alter table db_manufacture add CATEGORYNAME VARCHAR2(100);

-----------------------库存名称---------------------------
alter table db_purchase add  productname varchar2(500);
alter table db_product add productname varchar2(500);
-----------------------hj 20130528---------------------------
CREATE TABLE "DB_RETURN_INSTORAGE" (
"SEQUENCEID" NUMBER(18),
"RETURNSID" NUMBER(18),
"ORDERID" VARCHAR2(50),
"PRODUCTID" VARCHAR2(100),
"ORDERNUM" NUMBER(10),
"RETURNNUM" NUMBER(10),
"INNUM" NUMBER(10),
"OPER" VARCHAR2(50),
"OPERTIME" DATE,
CONSTRAINT "PK_DB_RETURN_INSTORAGE" PRIMARY KEY ("SEQUENCEID") VALIDATE
) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING

alter table db_order modify sellnum number(10);
alter table db_order modify delaydays number(10);
alter table db_order modify ordernum number(10);
alter table db_order modify negativenum number(10);
alter table db_order modify neutralnum number(10);
alter table db_order modify positivenum number(10);

-----------------------hp 20130528---------------------------
alter table db_PURCHASELOG modify RESERVE3 varchar2(1000);
alter table DB_PRODUCTDEVELOPFORSON modify RESERVE1 varchar2(1000);
alter table DB_PURCHASEFLOW add ordernum number(9);

-----------------------hj 20130527---------------------------
alter table db_returnmanagerment rename column ACTUALSAVENUM to returnflag;
alter table db_returnmanagerment modify returnflag number(6);
alter table db_returnmanagerment add returndescr varchar2(1000);
drop table DB_RETURN_CONTENT;

-----------------------hj 20130524---------------------------
alter table db_returnmanagerment add REPLAYORDERID VARCHAR2(300);
alter table DB_RETURNMANAGERMENT add actualSavenum NUMBER(10);

---------------------------3条数据--------------------------------

insert into DB_BACKNOTE (SEQUENCEID, NAME, OPER, OPERTIME)
values ('3', 'please contact us when you receive refund, thanks', 'admin', to_date('24-05-2013 10:16:23', 'dd-mm-yyyy hh24:mi:ss'));
insert into DB_BACKNOTE (SEQUENCEID, NAME, OPER, OPERTIME)
values ('1', 'I’m sorry', 'admin', to_date('24-05-2013 10:15:57', 'dd-mm-yyyy hh24:mi:ss'));
insert into DB_BACKNOTE (SEQUENCEID, NAME, OPER, OPERTIME)
values ('2', 'thank you', 'admin', to_date('24-05-2013 10:16:10', 'dd-mm-yyyy hh24:mi:ss'));
commit;

______________________退款备注________________________________
CREATE TABLE "DB_BACKNOTE" ( "SEQUENCEID" VARCHAR2(10), "NAME" VARCHAR2(200),
 "OPER" VARCHAR2(50), "OPERTIME" DATE, CONSTRAINT "PK_DB_BACKNOTE" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255
 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING

-----------------------sl --------------------------
CREATE TABLE "DB_ANALYSETYPE" ( "SEQUENCEID" VARCHAR2(10), "NAME" VARCHAR2(100), "FLAG" NUMBER(5), 
"CORPID" VARCHAR2(10), "OPENFLAG" VARCHAR2(10), "OPER" VARCHAR2(50), "OPERTIME" DATE, 
"DESCRIPTION" VARCHAR2(500), CONSTRAINT "PK_DB_ANALYSETYPE" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255
 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING

-----------------------hp 速賣通認可的物流方式  20130521---------------------------
CREATE TABLE "DB_ALIEXPRESSTYPE" ( "SID" NUMBER(4), "NAME" VARCHAR2(200), 
"SHOWNAME" VARCHAR2(200), "SERVICENAME" VARCHAR2(200), "OPER" VARCHAR2(50), 
"OPERTIME" DATE, "OPENFLAG" VARCHAR2(100), "ALIID" VARCHAR2(100), "DESCR" VARCHAR2(200), 
"RESERVE1" VARCHAR2(200), "RESERVE2" VARCHAR2(200), "RESERVE3" VARCHAR2(200), 
CONSTRAINT "PK_DB_ALIEXPRESSTYPE" PRIMARY KEY ("SID") VALIDATE ) TABLESPACE "ZHRGPT" 
PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING 


-----------------------hj 20130517---------------------------
alter table DB_RETURNMANAGERMENT rename column status to replaystatus;
alter table DB_RETURNMANAGERMENT add returnprostatus number(6);
alter table DB_RETURNMANAGERMENT add returnmoneystatus number(6);
alter table DB_RETURNMANAGERMENT_LOG rename column status to replaystatus;
alter table DB_RETURNMANAGERMENT_LOG add returnprostatus number(6);
alter table DB_RETURNMANAGERMENT_LOG add returnmoneystatus number(6);

-----------------------hp 20130517---------------------------
CREATE TABLE "DB_PRODUCTFORSELL" ( "SEQUENCEID" VARCHAR2(20), "SELLSKU" VARCHAR2(50), 
"NAME" VARCHAR2(1000), "ENNAME" VARCHAR2(1000), "TITLE" VARCHAR2(500), 
"OPER" VARCHAR2(50), "OPERTIME" DATE, "OPENFLAG" VARCHAR2(10), 
"CORPID" VARCHAR2(10), "RESERVE1" VARCHAR2(4000), "RESERVE2" VARCHAR2(100), 
"RESERVE3" VARCHAR2(100), "RESERVE4" NUMBER(8), "RESERVE5" NUMBER(8), 
"RESERVE6" NUMBER(10, 4), "RESERVE7" NUMBER(10, 4), "RESERVE8" DATE, 
"CREATETIME" DATE, "STATUS" VARCHAR2(10), 
CONSTRAINT "PK_DB_PRODUCTFORSELL" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE 
( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING


CREATE TABLE "DB_SELLFORSHOP" ( "SEQUENCEID" NUMBER(10), "SELLSKU" VARCHAR2(50), 
"SHOPID" VARCHAR2(50), "SHOPNAME" VARCHAR2(100), "OPENFLAG" VARCHAR2(2), 
"OPER" VARCHAR2(50),"OPERTIME" DATE, "CORPID" VARCHAR2(50), "SELLUSERID" VARCHAR2(50), 
CONSTRAINT "PK_DB_SELLFORSHOP" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE 
( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING

CREATE TABLE "DB_PRODUCTANDSELL" ( "SEQUENCEID" VARCHAR2(50), "SKU" VARCHAR2(50), 
"FLAG" VARCHAR2(10), CONSTRAINT "PK_DB_PRODUCTANDSELL" PRIMARY KEY ("SEQUENCEID", "SKU") VALIDATE )TABLESPACE 
"ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING 
----------------------lxd 20130524--------------------------
insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values
('1411', '订单运费对比报表', '订单运费对比报表', '/eshop/report.do?method=orderexpress', 0, 3, '1400', 11, 3, '#99AB32', null, 'lxd', null, null);
-----------------------hj 20130514---------------------------
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);

---------------------------- ly 20130514------------------------
insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values
('2111', '手动出库', '手动出库', '/eshop/product.do?method=expstorelist', 0, 3, '2100', 11, 3, '#99AB32', null, '李源', null, null);

CREATE TABLE db_expstoreitem (SEQUENCEID NUMBER(12) NOT NULL, expstoreid NUMBER(12), sku VARCHAR2(100 byte), ordernum NUMBER(12),price NUMBER(10,4),savelog VARCHAR2(4000 byte),  CONSTRAINT PK_DB_expstoreitem PRIMARY KEY(SEQUENCEID) );

CREATE TABLE DB_expstore (SEQUENCEID NUMBER(12) NOT NULL, groupid VARCHAR2(100 byte), customerid VARCHAR2(100 byte), CONTENT VARCHAR2(4000 byte), OPER VARCHAR2(50 byte), OPERTIME DATE, CORPID VARCHAR2(50 byte), OPENFLAG VARCHAR2(10 byte),  CONSTRAINT PK_DB_expstore PRIMARY KEY(SEQUENCEID) );

alter table  DB_expstore add updateflag number(5);
---------------------------- sl 20130509------------------------
alter table  DB_ANTISTOPSHOP add shopflag number(5);
alter  table DB_CALPRICE modify   SEQUENCEID NUMBER(15);
alter table DB_ANTISTOPSHOP add resultflag number(5);
---------------------------- ly 20130509------------------------
--店铺管理网页源码
CREATE TABLE DB_EBAYIDMANAGEHTMLSOURCE( SEQUENCEID NUMBER(8), EBAYIDMANAGEID NUMBER(8),DESCR VARCHAR2(4000),SORT NUMBER(8), CONSTRAINT PK_DB_EBAYIDMANAGEHTMLSOURCE PRIMARY KEY (SEQUENCEID) VALIDATE );

alter table DB_EBAYIDMANAGE add actualshopname varchar2(200);
alter table DB_EBAYIDMANAGE add actualshopid varchar2(200);

alter table  DB_ANTISTOPSHOP add shopflag number(5);
alter  table DB_CALPRICE modify   SEQUENCEID NUMBER(15);

---------------------------- hj 20130509------------------------
alter table db_product modify DESCR VARCHAR2(4000);

---------------------------- ly 20130508------------------------
alter table db_shop add amazonurlname varchar2(200);
alter table DB_EBAYIDMANAGE add BBEreality varchar2(100);   
alter table DB_EBAYIDMANAGE add BBEreality1 varchar2(100);   
alter table DB_EBAYIDMANAGE add BBEreality2 varchar2(100);    
alter table DB_EBAYIDMANAGE add BBEnum varchar2(100);   
alter table DB_EBAYIDMANAGE add BBEnum1 varchar2(100);   
alter table DB_EBAYIDMANAGE add BBEnum2 varchar2(100);   
alter table DB_EBAYIDMANAGE add bbebb varchar2(100);   
alter table DB_EBAYIDMANAGE add bbebb1 varchar2(100);   
alter table DB_EBAYIDMANAGE add bbebb2 varchar2(100);     
alter table DB_EBAYIDMANAGE add BBEnumb number(10,4);   
alter table DB_EBAYIDMANAGE add BBEnumb1 number(10,4);
alter table DB_EBAYIDMANAGE add BBEnumb2 number(10,4);
alter table DB_EBAYIDMANAGE add chae number(10,4);   
alter table DB_EBAYIDMANAGE add chae1 number(10,4);
alter table DB_EBAYIDMANAGE add chae2 number(10,4);
alter table DB_EBAYIDMANAGE add bbesnum number(10,4);   
alter table DB_EBAYIDMANAGE add bbesnum1 number(10,4);
alter table DB_EBAYIDMANAGE add bbesnum2 number(10,4);

---------------------------- hj 20130506------------------------
alter table db_sendmessage add RETURNID NUMBER(18);

---------------------------- hp 20130504------------------------
alter table db_productdevelopforson modify reserve1 varchar2(1000);
alter table  db_productdevelopforson add moneytype varchar2(50);
alter table  db_productdevelopforson add reserve5 varchar2(100);
alter table  db_productdevelopforson add reserve6 varchar2(100);
alter table  db_productdevelopforson add reserve7 varchar2(100);
alter table  db_productdevelopforson add reserve8 varchar2(100);


---------------------------- 退货管理 20130504------------------------
CREATE TABLE "DB_RETURNMANAGERMENT" ( 
"SEQUENCEID" NUMBER(18), 
"NAME" VARCHAR2(200), 
"STATUS" NUMBER(6), 
"OPENFLAG" NUMBER(6), 
"CREATOPER" VARCHAR2(50), 
"CREATTIME" DATE, 
"OPER" VARCHAR2(50), 
"OPERTIME" DATE, 
"CONTENTID" NUMBER(18), 
"ORDERID" VARCHAR2(50), 
"MESSAGEID" VARCHAR2(50), 
"SHOPTYPEID" NUMBER(10), 
"CUSTOMERNAME" VARCHAR2(600), 
"CUSTOMERCOUNTRY" VARCHAR2(1000), 
"SHOPTYPE" VARCHAR2(100), 
"ORDERSTATUS" VARCHAR2(100), 
"ORDERSOURCE" VARCHAR2(50), 
"ORDERTIME" NUMBER(10), 
"CUSTOMERCOUNTRYID" VARCHAR2(50), 
"CUSTOMERCOUNTRYEN" VARCHAR2(50), 
"CONTENT" VARCHAR2(1000), 
"DISPOSEFLAG" NUMBER(6), 
CONSTRAINT "PK_DB_RETURNMANAGERMENT" 
PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) 
LOGGING;

CREATE TABLE "DB_RETURNMANAGERMENT_LOG" ( 
"SEQUENCEID" NUMBER(18), 
"RETURNID" NUMBER(18), 
"NAME" VARCHAR2(200), 
"STATUS" NUMBER(6), 
"OPENFLAG" NUMBER(6), 
"CREATOPER" VARCHAR2(50), 
"CREATTIME" DATE, 
"OPER" VARCHAR2(50), 
"OPERTIME" DATE, 
"CONTENTID" NUMBER(18), 
"ORDERID" VARCHAR2(50), 
"MESSAGEID" VARCHAR2(50), 
"SHOPTYPEID" NUMBER(10), 
"CUSTOMERNAME" VARCHAR2(600), 
"CUSTOMERCOUNTRY" VARCHAR2(1000), 
"SHOPTYPE" VARCHAR2(100), 
"ORDERSTATUS" VARCHAR2(100), 
"ORDERSOURCE" VARCHAR2(50), 
"ORDERTIME" NUMBER(10), 
"OPERTYPE" NUMBER(6), 
"CUSTOMERCOUNTRYID" VARCHAR2(50), 
"CUSTOMERCOUNTRYEN" VARCHAR2(50), 
"DESCR" VARCHAR2(4000), 
"DISPOSEFLAG" NUMBER(6), 
CONSTRAINT "PK_DB_RETURNMANAGERMENT_LOG" 
PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) 
LOGGING;

CREATE TABLE "DB_RETURN_CONTENT" ( 
"SEQUENCEID" NUMBER(18), 
"CREATOPER" VARCHAR2(50), 
"CREATTIME" DATE, 
"CONTENT1" VARCHAR2(4000), 
"CONTENT2" VARCHAR2(4000), 
"CONTENT3" VARCHAR2(4000), 
CONSTRAINT "PK_DB_RETURN_CONTENT" 
PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) 
LOGGING;


---------------------------- ly 20130502------------------------
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页面标题菜单缩减样式

--------------------------sl 绩效考核表 20130502-------------------
CREATE TABLE "DB_PERFORMANCE" ( "SEQUENCEID" NUMBER(10), "OPER" VARCHAR2(50), "POINT" NUMBER(5), 
"CREATETIME" DATE, "DESCR" VARCHAR2(4000), "CORPID" VARCHAR2(10), "OPENFLAG" VARCHAR2(10), 
"STATUS" NUMBER(4), "OPERID" NUMBER(6), "POINTDESCR" VARCHAR2(500), "GROUPID" VARCHAR2(10), 
CONSTRAINT "PK_DB_PERFORMANCE" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 
STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;
alter  table DB_PERFORMANCE add createoper varchar2(50);
alter  table DB_PERFORMANCE add opertime date;
alter  table DB_PERFORMANCE add alertflag number(2);


---------------------------- 产品开发表字表 hp 20130502------------------------
CREATE TABLE "DB_PRODUCTDEVELOPFORSON" ( "SEQUENCEID" NUMBER(9), 
"FATHINDEXID" VARCHAR2(50), "PRODUCTID" VARCHAR2(50), "NAME" VARCHAR2(500),
"ENNAME" VARCHAR2(500), "SAVENUM" NUMBER(8), "SELLPRICE" NUMBER(8, 2), "COSTPRICE" NUMBER(8, 2),
"WEIGHT" NUMBER(8), "CATEGORYID" VARCHAR2(50), "CATEGORYNAME" VARCHAR2(50),
"MANUFACTUREID" VARCHAR2(50), "MANUFACTURENAME" VARCHAR2(50), "QUOTE" NUMBER(8, 2),
"MINNUM" NUMBER(8), "PHOTOURL" VARCHAR2(500), "CHASEOPER" VARCHAR2(20),
"RESERVE1" VARCHAR2(100), "RESERVE2" VARCHAR2(100), "RESERVE3" NUMBER(8),
"RESERVE4" NUMBER(8, 2), "TITLE" VARCHAR2(500), "OPENFLAG" VARCHAR2(2), "FLAG" VARCHAR2(2), 
"OPER" VARCHAR2(50), "OPERTIME" DATE, "CORPID" VARCHAR2(50), 
CONSTRAINT "PK_DB_PRODUCTDEVELOPFORSON" PRIMARY KEY 
("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING 

-----------竞争对手历史表------lxd----20130428-----------
alter table db_ebaymessagebind add sort number(2) ;
alter table  DB_COMPETITORSEARCH add JSONSTR varchar2(4000);
CREATE TABLE "DB_COMPETITORLIST" ( "SEQUENCEID" VARCHAR2(100), "USERNAME" VARCHAR2(50), 
"SHOPNAME" VARCHAR2(100), "DAYONLINENUM" NUMBER(8), "YESTERDAYONLINENUM" NUMBER(8), "WEEKONLINENUM" NUMBER(12), 
"MONTHONLINENUM" NUMBER(12), "CREATRTIME" DATE, "UPDATETIME" DATE, CONSTRAINT "PK_DB_competitorlist" PRIMARY KEY 
("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;
alter table db_workreport add fileurl varchar2(200);
---------------------------- 产品开发表 hp 20130428------------------------
alter table db_productdevelop add productnote varchar2(2000);
alter table db_productdevelop add reserve11 varchar2(100);
alter table db_productdevelop add reserve12 varchar2(100);
alter table db_productdevelop add reserve13 varchar2(100);
alter table db_productdevelop add reserve14 varchar2(100);
alter table db_productdevelop add reserve15 varchar2(100);
alter table db_productdevelop add reserve16 varchar2(100);
alter table db_productdevelop add reserve17 varchar2(100);
alter table db_productdevelop add reserve18 varchar2(100);

-----------标题重复查询表------lxd----20130428-----------
ALTER TABLE db_enmity RENAME COLUMN USERNEME TO USERNAME;
alter table db_Productanditemid add enmityid varchar2(50);
alter table db_taskitemid add enmityid varchar2(50);
alter table db_itemresult add enmityid varchar2(50);
alter table db_newitemresult add enmityid varchar2(50);
CREATE TABLE "DB_REPEATPRODUCT" (
 "SEQUENCEID" NUMBER(10), "TITLE" VARCHAR2(2000), "SALSEMONEY" VARCHAR2(50), "PUBLISNUM" VARCHAR2(50),
 "CHANGERATE" VARCHAR2(50), "PRICEAVG" VARCHAR2(50), "OFFER" VARCHAR2(50), "TOPSALSENUM" NUMBER(10), 
 "TOPSALSEMONEY" NUMBER(10), "OPENFLAG" NUMBER(10), "OPER" VARCHAR2(50), "OPERTIME" DATE, "CORPID" NUMBER(10), 
 CONSTRAINT "PK_DB_REPEATPRODUCT" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS
-------------项目管理 ly---20130427------------------------
--备注
CREATE TABLE db_projectdesrc( SEQUENCEID NUMBER(8), PROJECTID NUMBER(8),DESCR VARCHAR2(4000),CONSTRAINT PK_db_projectdesrc PRIMARY KEY (SEQUENCEID) VALIDATE );

--SKU创建形式
CREATE TABLE db_projectcollaborative( SEQUENCEID NUMBER(8), PROJECTID NUMBER(8),COPER VARCHAR2(50),CONSTRAINT PK_db_projectcollaborative PRIMARY KEY (SEQUENCEID) VALIDATE );

--协同人
CREATE TABLE db_projectsku( SEQUENCEID NUMBER(8), PROJECTID NUMBER(8),SKU VARCHAR2(50),SKUTYPE NUMBER(8),CONSTRAINT PK_db_projectsku PRIMARY KEY (SEQUENCEID) VALIDATE );

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values
('5114', '项目管理1', '项目管理1', '/eshop/project.do?method=listbbs', 0, 3, '5100', 22, 3, '#99AB32', null, '史亮', null, null);

alter table db_projectdesrc add SORT number(4);
alter table db_projectdesrc add CREATETIME DATE; --操作时间
----------------高BBe商品 sl 20130427-------------------------
CREATE TABLE "DB_EBAYHIGHBBE" ( "SEQUENCEID" NUMBER(6), "EBAYIDMANAGEID" NUMBER(17), 
"TITLE" VARCHAR2(100), "ITEMID" NUMBER(20), "TRADEMONEY" VARCHAR2(20), "TRADEALL" VARCHAR2(20), 
"TRADEBBE" VARCHAR2(20), "BBEBILI" VARCHAR2(20), "OPER" VARCHAR2(50), "OPERTIME" DATE, 
CONSTRAINT "PK_DB_EBAYHIGHBBE" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 
STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING
-----------------产品开发表（DB_PRODUCTDEVELOP 的主键） hp 20130426----------------
alter table DB_PRODUCT add indexfordevelop varchar2(50);
-------------爬虫搜索脚本 lxd---20130423------------------------
CREATE TABLE "DB_COMPETITORSEARCH" ( 
"SEQUENCEID" NUMBER(6), "NAME" VARCHAR2(100), "DESCR" VARCHAR2(2000), "OPER" VARCHAR2(100), 
"OPERTIME" DATE, "SQLFILTER" VARCHAR2(3000), "DAYSELLNUM" NUMBER(6), "TRANSLATRATE" NUMBER(4, 2), "PUBLISHTIME" DATE, 
"SELLPRICESTART" NUMBER(8, 2), "SELLPRICEEND" NUMBER(8, 2), "ROVERLAPENUM" NUMBER(8), "OPENFLAG" VARCHAR2(50), 
"CORPID" NUMBER(2), "DAYSELLNUM2" NUMBER(6), "TRANSLATRATE2" NUMBER(4, 2), "PUBLISHTIME2" DATE, "ROVERLAPENUM2" NUMBER(8),
 CONSTRAINT "PK_DB_DB_COMPETITORSEARCH" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS

alter table db_enmity add  EBAYITEMID VARCHAR2(100);  
alter table db_enmity add  USERNEME VARCHAR2(100);
-------------项目管理 sl---------20130423------------------------
CREATE TABLE "DB_PROJECTBBS" ( "SEQUENCEID" NUMBER(8), "PROJECTNAME" VARCHAR2(500), "LIMITTIME" NUMBER(5), "PRINCIPALOPER" VARCHAR2(50), 
"OPER" VARCHAR2(50), "OPERTIME" DATE, "CREATEOPER" VARCHAR2(50), "CREATETIME" DATE, "CORPID" VARCHAR2(10), "OPERNFLAG" VARCHAR2(10), 
CONSTRAINT "PK_DB_PROJECTBBS" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 
STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;

ALTER TABLE  db_projectbbs ADD percentage number(5,4);

-------------ebay帐号管理DSR数据 ly---------20130418------------------------
CREATE TABLE DB_EBAYTotalsales (SEQUENCEID NUMBER(17,0) NOT NULL,

EBAYMANAGEID NUMBER(17,0) NOT NULL,

NAME VARCHAR2(150 byte),

Standardvalue1 VARCHAR2(50 byte),

value1 VARCHAR2(50 byte),

Standardvalue2 VARCHAR2(50 byte),

value2 VARCHAR2(50 byte),

Standardvalue3 VARCHAR2(50 byte),

value3 VARCHAR2(50 byte),

Standardvalue4 VARCHAR2(50 byte),

value4 VARCHAR2(50 byte),

OPERTIME DATE,

OPENFLAG NUMBER(2),

OPER VARCHAR2(100),

CORPID NUMBER(2),

CONSTRAINT PK__DB_EBAYTotalsales PRIMARY KEY(SEQUENCEID));

CREATE TABLE DB_EBAYDSR (SEQUENCEID

NUMBER(17,0) NOT NULL, EBAYMANAGEID

NUMBER(17,0) NOT NULL, NAME VARCHAR2(150 byte),

CONTENT VARCHAR2(150 byte), month3num

VARCHAR2(50 byte),month3proportion

VARCHAR2(50 byte),month12num

VARCHAR2(50 byte),month12proportion

VARCHAR2(50 byte),OPERTIME DATE,OPENFLAG NUMBER(2),OPER VARCHAR2(100),CORPID NUMBER(2),
CONSTRAINT PK__DB_EBAYDSR PRIMARY KEY(SEQUENCEID));

------------------bbe数据解析  sl 20130419----------------
CREATE TABLE "DB_EBAYBBE" ( "SEQUENCEID" NUMBER(5), "EBAYIDMANAGEID" NUMBER(17), 
"BBENUM" VARCHAR2(200), "BBEPERCENT" VARCHAR2(50), "BBE2" VARCHAR2(50), "BBE3" VARCHAR2(50), 
"CORPID" VARCHAR2(10), "OPENFLAG" VARCHAR2(10), "OPER" VARCHAR2(50), "OPERTIME" DATE, 
CONSTRAINT "PK_DB_EBAYBBE" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" 
PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;
-----------------20130418 hp 任务流程------------------------
alter table DB_PROTOCOL add reserve14 varchar2(100);
------------------ebay额度管理  sl 20130418----------------
CREATE TABLE "DB_EBAYLIMIT" ( "SEQUENCEID" NUMBER(5), "EBAYIDMANAGEID" NUMBER(17), 
"ACTIVITY" VARCHAR2(200), "ITEMS" VARCHAR2(50), "AMOUNT" VARCHAR2(50), 
"OPER" VARCHAR2(50), "OPERTIME" DATE, "CORPID" VARCHAR2(10), 
"OPENFLAG" VARCHAR2(10), 
CONSTRAINT "PK_DB_EBAYLIMIT" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 
STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;

------------------图片属性配置 重新设计 20130418 sl 20130222----------------
CREATE TABLE "DB_PICTUREATTRIBUTE" ( "SEQUENCEID" VARCHAR2(50), "NAME" VARCHAR2(200),
"UPLOADFLAG" VARCHAR2(10), "THISURL" VARCHAR2(300), "FTPIP" VARCHAR2(50), "FTPUSERNAME" VARCHAR2(100), 
"FTPPASSWORD" VARCHAR2(100), "FTPURL" VARCHAR2(300), "RESERVE1" VARCHAR2(100), "RESERVE2" VARCHAR2(100), 
"RESERVE3" VARCHAR2(100), "RESERVE4" NUMBER(10, 4), "RESERVE5" NUMBER(10, 4), "CORPID" VARCHAR2(10), 
"OPENFLAG" VARCHAR2(10), "OPER" VARCHAR2(50), "OPERTIME" DATE, "ATTRIBUTEID" VARCHAR2(50), 
CONSTRAINT "PK_DB_ICTUREATTRIBUTE" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING
-------------ebay帐号管理 ly---------20130417------------------------
insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values
('7122', 'EBAY帐号管理', 'EBAY帐号管理', '/eshop/shop.do?method=ebayIdManageList', 0, 3, '7100', 22, 3, '#99AB32', null, '李源', null, null);

CREATE TABLE DB_EBAYIDMANAGE (SEQUENCEID
NUMBER(17,0) NOT NULL, NAME VARCHAR2(150 byte), SHOPTYPEID
VARCHAR2(50 byte),OPERTIME DATE,OPENFLAG NUMBER(2),OPER VARCHAR2(100),CORPID NUMBER(2),
CONSTRAINT PK_DB_EBAYIDMANAGE PRIMARY KEY(SEQUENCEID));
----------------------20130416------------------------

ALTER TABLE DB_SENDLIST RENAME COLUMN SELLUSERID TO SELLUSER;
alter table  DB_ANTISTOP add SORT NUMBER(5);
-------------徐波爬虫表新增加字段---------20130416------------------------
alter table db_resultdetail add firstdowntime date;
alter table db_resultdetail add itemflag number(2);
alter table db_itemresult add showflag number(2);
alter table db_newitemresult add showflag number(2);
alter table db_itemresult add sellnumberavgoneday number(10,3);
alter table db_newitemresult add sellnumberavgoneday number(10,3);

alter table db_itemresult add sellnumberday number(8);
alter table db_itemresult add sellnumberweek number(8);
alter table db_itemresult add sellnumbermonth number(8);
alter table db_itemresult add sellnumbertotal number(8);
alter table db_itemresult add sellnumberavg number(8);
alter table db_itemresult add sellnumbersite number(8);
alter table db_itemresult add downcount number(8);

alter table db_newitemresult add sellnumberday number(8);
alter table db_newitemresult add sellnumberweek number(8);
alter table db_newitemresult add sellnumbermonth number(8);
alter table db_newitemresult add sellnumbertotal number(8);
alter table db_newitemresult add sellnumberavg number(8);
alter table db_newitemresult add sellnumbersite number(8);
alter table db_newitemresult add downcount number(8);

create table DB_ITEMIDSPC  (
   SID                  VARCHAR2(50)                    not null,
   ITEMID               VARCHAR2(20),
   SKU                  VARCHAR2(200),
   constraint PK_DB_ITEMIDSPC primary key (SID)
)
pctfree 10
initrans 1
maxtrans 255
storage
(
    initial 64K
    minextents 1
    maxextents unlimited
)
tablespace ZHRGPT
logging
noparallel;

comment on table DB_ITEMIDSPC is
'多物品的子商品';

 CREATE TABLE "DB_PRODUCTANDITEMID" ("SEQUENCEID"
    VARCHAR2(50 byte) NOT NULL,  "PRODUCTINDEXID" VARCHAR2(100 byte), "ITEMID"
    VARCHAR2(100 byte),
    CONSTRAINT "PK_DB_PRODUCTANDITEMID" PRIMARY KEY("SEQUENCEID"))
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING ;

-----------------20130415 hp 产品供应商配置表------------------------
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);

-----------------20130412 sl 计算价格------------------------
alter table db_calprice add  platfromid number(5);
alter table db_calprice add  expresstypeid number(5);
alter table db_calprice add  platfromname varchar2(50);
alter table db_calprice add  expresstype varchar2(50);

-----------------20130412 ly SKU销售报告------------------------
insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values('5111', 'SKU销售报告', 'SKU销售报告', '/eshop/product.do?method=productSellList', 0, 3, '5100', 23, 3, '#99AB32', null, '李源', null, null);
alter table db_shop add amazonurl varchar2(200);

-----------------20130409 sl 计算价格结果表------------------------
CREATE TABLE "DB_CALPRICE" ( "SEQUENCEID" NUMBER(5), "PRODUCTID" VARCHAR2(50), 
"PRICE" NUMBER(10, 4), "TOCOUNTRY" VARCHAR2(50), "CREATETIME" DATE, "CORPID" NUMBER(5), 
"OPENFLAG" NUMBER(5), "PRICERMB" NUMBER(10, 4), "MONERYRATE" VARCHAR2(10), "CALCULATEALLID" VARCHAR2(6), 
"CALCULATEALL" VARCHAR2(50), CONSTRAINT "PK_DB_CALPRICE" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING

--------假想敌--------------
CREATE TABLE "DB_ENMITY" (
"SEQUENCEID" NUMBER(6), --主键
"USERNAME" VARCHAR2(100),   --用户名
"SHOPNAME" VARCHAR2(100),   --店铺名称
"DESCR" VARCHAR2(2000), --描述
"OPER" VARCHAR2(100), --操作人
"OPERTIME" DATE, --操作时间
"OPENFLAG" NUMBER(2),
"STATUS" NUMBER(2),
"CORPID" NUMBER(2),
CONSTRAINT "PK_DB_DB_ENMITY" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT)
LOGGING NOCOMPRESS;
-----------------20130409 lxd竞争对手------------------------
CREATE TABLE DB_competitor( 
SEQUENCEID NUMBER(6),  --主键 1
username VARCHAR2(100),--用户名 2
shopname VARCHAR2(100),--店铺名 3
evaluate VARCHAR2(100),--评价   4
location VARCHAR2(100),--商品所在地 5
dayonline VARCHAR2(100),  --今天在线数量 6
yestonline VARCHAR2(100),  --昨天在线数量 7
weekonline VARCHAR2(100), --周在线数量 8
monthonline VARCHAR2(100),--月在线数量 9
credit  NUMBER(2),   --信用度 10
keyflag NUMBER(2),     --重点商品标志 11
salsenum NUMBER(4),    --重点销量 12
salsemoney NUMBER(8,2),  --重点销额 13 
OPER VARCHAR2(50),     --操作人 14
OPERTIME DATE,         --操作时间 15
CORPID VARCHAR2(10),   --企业编号 16
CONSTRAINT "PK_DB_competitor" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS

alter table DB_competitor modify dayonline NUMBER(5);
alter table DB_competitor modify yestonline NUMBER(5);
alter table DB_competitor modify weekonline NUMBER(8);
alter table DB_competitor modify monthonline NUMBER(8);
alter table DB_competitor add openflag  NUMBER(2);
alter table DB_competitor add status NUMBER(2);--状态
alter table DB_competitor add sellprice NUMBER(8,2); --销售价
alter table DB_competitor add  translatrate NUMBER(4,2);--转化率
alter table DB_competitor add  feedbackscore NUMBER(4,2);--好评率
-----------------20130408 sl 计算价格-----------------------------
CREATE TABLE "DB_CALCULATEALL" ( "SEQUENCEID" NUMBER(6),
"PLATFORMID" NUMBER(4), "PLATFORMNAME" VARCHAR2(100),
"COSTTYPE" NUMBER(6), "EXPRESSTYPEID" NUMBER(4),
"TOCOUNTRY" VARCHAR2(50), "MAOLI" NUMBER(8, 4), "OPER" VARCHAR2(50),
"OPERTIME" DATE, "CORPID" NUMBER(2), "OPENFLAG" NUMBER(2), CONSTRAINT
"PK_DB_CALATEALL" PRIMARY KEY ("SEQUENCEID") VALIDATE )
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;

alter table  DB_CALCULATEALL add name varchar2(100);
alter  table DB_CALCULATEALL add PACKAGINGid number(6);
alter table DB_CALCULATEALL add expresstype varchar2(50);

-----------------20130408 lxd SKU关联竞争商品------------------------
CREATE TABLE DB_COMPETITIONSKU( 
"SEQUENCEID" NUMBER(6),
"SKU" VARCHAR2(100),
"XSKU" VARCHAR2(100), 
"OPER" VARCHAR2(50), 
"OPERTIME" DATE, 
"CORPID" VARCHAR2(10), 
CONSTRAINT "PK_DB_COMPETITIONSKU" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 
255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;
-----------------20130407(徐波,出口易交运用)--------------------------
alter table db_order add warehouse  varchar2(200);
alter table db_order add errordescr varchar2(4000);
alter table db_order add ordersign varchar2(50);
alter table db_order add itemsign varchar2(50);
alter table db_expresstype add tokenconfigid varchar2(50);

create table DB_TOKENCONFIG  (
   SID                  VARCHAR2(50)                    not null,
   EXPRESSID            VARCHAR2(30),
   TOKENID              VARCHAR2(100),
   USERKEY              VARCHAR2(50),
   CUSTOMUSERKEY        VARCHAR2(50),
   OPER                 VARCHAR2(50),
   OPERTIME             DATE,
   FLAG                 NUMBER(2),
   OPENFLAG             NUMBER(2),
   CORPID               VARCHAR2(30),
   RESERVE1             VARCHAR2(2000),
   RESERVE2             VARCHAR2(2000),
   RESERVE3             VARCHAR2(2000),
   RESERVE4             NUMBER(6),
   RESERVE5             NUMBER(6),
   RESERVE6             NUMBER(8,3),
   constraint PK_DB_TOKENCONFIG primary key (SID)
)
pctfree 10
initrans 1
maxtrans 255
storage
(
    initial 64K
    minextents 1
    maxextents unlimited
)
tablespace ZHRGPT
logging
noparallel;

comment on table DB_TOKENCONFIG is
'货运方式配置';

alter table db_order add height number(5);
alter table db_order add weidth number(5);
alter table db_order add length number(5);
alter table db_order add ckyflag number(2);

create table DB_CKYORDER  (
   SID                  VARCHAR2(20)                    not null,
   ORDERID              VARCHAR2(20),
   OPERTIME             DATE,
   constraint PK_DB_CKYORDER primary key (SID)
)
pctfree 10
initrans 1
maxtrans 255
storage
(
    initial 64K
    minextents 1
    maxextents unlimited
)
tablespace ZHRGPT
logging
noparallel;

comment on table DB_CKYORDER is
'出口易订单';

---------------------------hp 20130406itemid爬虫中间表-------------------------------------
 CREATE TABLE "DB_PRODUCTANDITEMID" ("SEQUENCEID"
    VARCHAR2(50 byte) NOT NULL,  "PRODUCTINDEXID" VARCHAR2(100 byte), "ITEMID"
    VARCHAR2(100 byte),
    CONSTRAINT "PK_DB_PRODUCTANDITEMID" PRIMARY KEY("SEQUENCEID"))
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING ;

---------------------------hp 20130405销售模块-------------------------------------
update db_menufunc set url = '/eshop/product.do?method=productForSellList' where funname = '产品销售管理';

---------------------------hj 20130405批次总表-------------------------------------
alter table db_purchasedevelop add weightamount number(12,4);
alter table db_purchasedevelop add moneyamount number(12,4);
alter table db_purchasedevelop modify status number(10);

----------------出口易接口配置------------------------------------------------
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_WORKREPORT add alertflag number(4); 
---------------------------lxd 20130327 ----菜单临时表-------------------------------------

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

CREATE TABLE DB_OPERMENU_TMP (
 OPER VARCHAR2(21) NOT NULL , MENUID VARCHAR2(100) NOT NULL ) 
 TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS

--------------------------------hj 20130401----------------
CREATE TABLE "DB_ALLOCATE_TEMP" ( "SEQUENCEID" VARCHAR2(100),
"PRODUCTID" VARCHAR2(100), "INPORTTIME" DATE, "TITLE" VARCHAR2(1000),
"ORPER" VARCHAR2(100), "OPERTIME" DATE, "RESERVE1" VARCHAR2(200), "RESERVE2" VARCHAR2(100),
"RESERVE3" VARCHAR2(100), "RESERVE4" VARCHAR2(100), "RESERVE5" VARCHAR2(100), "ALLOCATENUM" NUMBER(10),
"SONALLOCATENUM" NUMBER(10), "WEIGHT" NUMBER(10), "QUESTIONSID" VARCHAR2(200), CONSTRAINT
"PK_DB_ALLOCATE_TEMP" PRIMARY KEY ("SEQUENCEID") VALIDATE )
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE
( INITIAL 64K BUFFER_POOL DEFAULT)
LOGGING

--------------------------------hj 20130401----------------
alter table DB_ALLOCATE_TEMP add questionsid varchar2(200);

--------------------------------sl 20130330----------------
alter table db_caiwu add oper1 varchar2(100);
 alter table db_caiwu add flag number(8);

---------------------------lxd 20130327 ----增加英文字段-------------------------------------
alter table DB_EUBPROVINCE add provinceen varchar2(100);
alter table DB_EUBCITY add  cityen varchar2(100);
alter table DB_EUBDISTRICT add diten varchar2(100);

------------------------------------------- hj 20130310 ------------------------------------------
alter table db_order_temp modify CUSTOMERADDRESS1 varchar2(2000);
alter table db_order_temp modify CUSTOMERPROVINCE varchar2(1000);
alter table db_order_temp modify CUSTOMERCITY varchar2(1000);
alter table db_order_temp modify CUSTOMERCOUNTRY varchar2(1000);

alter table db_order modify CUSTOMERCOUNTRY varchar2(1000);
alter table db_order modify CUSTOMERPROVINCE varchar2(1000);
alter table db_order modify CUSTOMERCITY varchar2(1000);     
alter table db_order modify CUSTOMERADDRESS varchar2(2000);

alter table db_order modify CUSTOMERNAME varchar2(600);
alter table db_order modify CUSTOMERRESERVE1 varchar2(1000);       
alter table db_order_temp modify CUSTOMERNAME varchar2(600);

------------------------------------------- hj 20130328 ------------------------------------------
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);

------------------------------------------- hp 20130327 ------------------------------------------、
alter table DB_PRODUCTDEVELOP add reserve7 varchar2(50);
alter table DB_PRODUCTDEVELOP add reserve8 varchar2(50);
alter table DB_PRODUCTDEVELOP add reserve9 varchar2(50);
alter table DB_PRODUCTDEVELOP add reserve10  varchar2(50);

----------------ly 开启paypal金额报表--------
delete DB_OPERMENU where menuid in(select funid from DB_MENUFUNC where URL='/eshop/order.do?method=paypalMoney' );
update DB_MENUFUNC set funid='1409',parentid='1400',ifparent='3' where  URL='/eshop/order.do?method=paypalMoney';
insert into db_opermenu (menuid,oper)values('1409','admin');
----------------ly 工作报告管理任务时间--------
insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values('6111', '工作报告', '工作报告', '/eshop/other.do?method=workreportList', 0, 3, '6100', 23, 3, '#99AB32', null, '梁曦冬', null, null);

alter table DB_WORKREPORT modify content varchar2(4000);
alter table DB_WORKREPORTLOG modify content varchar2(4000);
alter table DB_WORKREPORT add UPDATEFLAG varchar2(2000);   
alter table DB_WORKREPORTLOG add UPDATEFLAG varchar2(2000);
alter table DB_WORKREPORTLOG add sid number(10);
alter table DB_WORKREPORTLOG modify sequenceid varchar2(50);
alter table DB_WORKREPORT add PROTOCOLTIME1 DATE;
alter table DB_WORKREPORT add PROTOCOLTIME2 DATE;
alter table DB_WORKREPORTLOG add PROTOCOLTIME1 DATE;
alter table DB_WORKREPORTLOG add PROTOCOLTIME2 DATE;
alter table DB_WORKREPORT modify PROTOCOLTIME1 varchar2(50);
alter table DB_WORKREPORT modify PROTOCOLTIME2 varchar2(50);
alter table DB_WORKREPORTLOG modify PROTOCOLTIME1 varchar2(50);
alter table DB_WORKREPORTLOG modify PROTOCOLTIME2 varchar2(50);
alter table  DB_WORKREPORT  modify UPDATEFLAG varchar2(2000);
alter table  DB_WORKREPORTLOG  modify UPDATEFLAG varchar2(2000);

-------------SL 关键词关联表----------
CREATE TABLE "DB_ANTISTOPSHOP" ( "SEQUENCEID" NUMBER(10),
"SITE" VARCHAR2(20), "SORT" NUMBER(10), "SELLSHOP" VARCHAR2(50),
"SELLMONEY" NUMBER(10, 4), "PUBLISHNUM" NUMBER(10), "DEALNUM" NUMBER(10),
"SELLPRICE" NUMBER(10, 4), "PRODUCT" NUMBER(10), "AVGPRICE" NUMBER(10, 4),
"SUBRATE" VARCHAR2(50), "CORPID" NUMBER(10), "OPENFLAG" NUMBER(10),
"OPER" VARCHAR2(50), "OPERTIME" DATE, PRIMARY KEY ("SEQUENCEID") VALIDATE )
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING

alter table DB_ANTISTOPSHOP add ANTISTOPID number(10);

----------------HP  20130325  采购序列号------------------------
create sequence purchase_seq_id
increment by 1
start with 1
maxvalue 99999999
minvalue 1

----------------sl 工作报告--------
CREATE TABLE DB_WORKREPORT ( SEQUENCEID NUMBER(10),
TITLE VARCHAR2(500), WORKATTRIBUTEID NUMBER(10),
WORKMOULDID NUMBER(10), WORKMOULD VARCHAR2(4000),
CREATEOPER VARCHAR2(100), CREATETIME DATE, WORK1 VARCHAR2(4000),
WORK2 VARCHAR2(4000), WORK3 VARCHAR2(4000), WORK4 VARCHAR2(4000),
WORK5 VARCHAR2(4000), WORK6 VARCHAR2(4000), OPERTIME DATE, WARMOPER VARCHAR2(4000),
FLAG NUMBER(8), CORPID VARCHAR2(10), OPENFLAG NUMBER(8), OPER VARCHAR2(100), CONTENT VARCHAR2(100),
STATUS NUMBER(10), CONSTRAINT PK_DB_WORKREPORT PRIMARY KEY (SEQUENCEID) VALIDATE )
TABLESPACE ZHRGPT PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING

---日志表
CREATE TABLE DB_WORKREPORTLOG ( SEQUENCEID NUMBER(10),
TITLE VARCHAR2(500), WORKATTRIBUTEID NUMBER(10), WORKMOULDID NUMBER(10),
WORKMOULD VARCHAR2(4000), CREATEOPER VARCHAR2(100), CREATETIME DATE, WORK1 VARCHAR2(4000),
WORK2 VARCHAR2(4000), WORK3 VARCHAR2(4000), WORK4 VARCHAR2(4000), WORK5 VARCHAR2(4000),
WORK6 VARCHAR2(4000), OPERTIME DATE, WARMOPER VARCHAR2(4000), FLAG NUMBER(8), CORPID VARCHAR2(10),
 OPENFLAG NUMBER(8), OPER VARCHAR2(100), CONTENT VARCHAR2(100), STATUS NUMBER(10),
 CONSTRAINT PK_DB_WORKREPORTLOG PRIMARY KEY (SEQUENCEID) VALIDATE ) TABLESPACE ZHRGPT
 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING    ;


---模板
CREATE TABLE DB_WORKMODLE ( SEQUENCEID NUMBER(8), TITLE VARCHAR2(500),
 CONTENT VARCHAR2(4000), OPER VARCHAR2(100), OPERTIME DATE, CORPID VARCHAR2(10),
 OPENFLAG NUMBER(8), CONSTRAINT PK_DB_WORKMODLE PRIMARY KEY (SEQUENCEID) VALIDATE )
 TABLESPACE ZHRGPT PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE
 ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING   ;

----------------HP  20130325  采购indexid------------------------
alter table DB_PURCHASE add purchaseindexid number(10);

----------------HJ  20130321  调拨批次表------------------------
alter table db_purchasedevelop add content varchar2(2000);

alter table DB_CATEGORY add SHORTSKU VARCHAR2(5);
-----------ly 2013-03-15-----------
update db_menufunc set funname='任务管理',fundesc='任务管理' where funname='销售流程';

----------------HJ  20130315  调拨批次表------------------------
alter table DB_PURCHASEDEVELOP add TrackingNumber varchar2(100);
alter table DB_PURCHASEDEVELOP add arrivetime date;
alter table DB_PURCHASEDEVELOP add INPORTTIME date;
alter table DB_PURCHASEDEVELOP modify status number(1);

----------------HJ  20130315  速卖通上传  备注信息------------------------
alter table db_order_temp add content varchar2(4000);
ALTER TABLE "DB_CAIWULOG" RENAME COLUMN "MOEY" TO "MONEY";

------------------------------------------- hp 20130318 ------------------------------------------、
alter table DB_PRODUCTDEVELOP add categoryid varchar2(50);
alter table DB_PRODUCTDEVELOP add categoryname varchar2(50);
alter table DB_PRODUCTDEVELOP add FINISHTIME date;

-----------ly 修改表 添加字段-----------
alter table DB_PROTOCOL add typeflag VARCHAR2(5); 

-----------sl 删除多余表-----------
drop table DB_FINANCIAL;

-----------sl 财务表--------------
CREATE TABLE "DB_CAIWU" ("SEQUENCEID" VARCHAR2(50 byte) 
    NOT NULL, "SOURCE" VARCHAR2(100 byte), "SOURCEID" VARCHAR2(50
    byte), "MONEYRATE" VARCHAR2(10 byte), "MONEY" NUMBER(10, 4), 
    "GROUPID" VARCHAR2(50 byte), "REMARK" VARCHAR2(4000 byte), 
    "RESERVE1" VARCHAR2(500 byte), "RESERVE2" VARCHAR2(500 byte),
    "RESERVE3" VARCHAR2(500 byte), "RESERVE4" NUMBER(10, 4), 
    "RESERVE5" NUMBER(10, 4), "CORPID" VARCHAR2(10 byte), 
    "OPENFLAG" VARCHAR2(10 byte), "STATUS" VARCHAR2(50 byte), 
    "OPER" VARCHAR2(50 byte), "OPERTIME" DATE, "CREATEOPER" 
    VARCHAR2(50 byte), "CREATETIME" DATE, 
    CONSTRAINT "PK_DB_CAIWU" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING;
CREATE TABLE "DB_CAIWUDEPLOY" ("SEQUENCEID" VARCHAR2(10 
    byte) NOT NULL, "NAME" VARCHAR2(50 byte) NOT NULL, "CORPID" 
    VARCHAR2(10 byte) NOT NULL, "OPENFLAG" VARCHAR2(10 byte) NOT 
    NULL, 
    CONSTRAINT "PK_DB_CAIWUDEPLOY" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING;
CREATE TABLE "DB_CAIWULOG" ("SEQUENCEID" VARCHAR2(50 
    byte) NOT NULL, "SOURCE" VARCHAR2(100 byte), "SOURCEID" 
    VARCHAR2(50 byte), "MONEYRATE" VARCHAR2(10 byte), "MOEY" 
    NUMBER(10, 4), "GROUPID" VARCHAR2(50 byte), "REMARK" 
    VARCHAR2(4000 byte), "RESERVE1" VARCHAR2(500 byte), 
    "RESERVE2" VARCHAR2(500 byte), "RESERVE3" VARCHAR2(500 byte),
    "RESERVE4" NUMBER(10, 5), "RESERVE5" NUMBER(10, 4), "CORPID" 
    VARCHAR2(10 byte), "OPENFLAG" VARCHAR2(10 byte), "STATUS" 
    VARCHAR2(50 byte), "DESCR" VARCHAR2(4000 byte), "OPER" 
    VARCHAR2(50 byte), "OPERTIME" DATE, 
    CONSTRAINT "PK_DB_CAIWULOG" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING;  
    
CREATE TABLE "DB_PRODUCTANDMANUFACTURE" ("SEQUENCEID" 
    VARCHAR2(50 byte) NOT NULL, "INDEXID" VARCHAR2(15 byte), 
    "MANUFACTUREID" VARCHAR2(50 byte), "MANUFACTURENAME" 
    VARCHAR2(100 byte), "QUOTE" NUMBER(12, 4), "OPER" 
    VARCHAR2(100 byte), "CORPID" VARCHAR2(100 byte), "OPERTIME" 
    DATE, "OPENFLAG" VARCHAR2(100 byte), "ADDRESS" VARCHAR2(100 
    byte), "TEL" VARCHAR2(100 byte), "RESERVE1" VARCHAR2(100 
    byte), "RESERVE2" VARCHAR2(100 byte), "RESERVE3" NUMBER(8, 4),
    "RESERVE4" NUMBER(8, 4), "WANGWANG" VARCHAR2(1000 byte), "QQ"
    VARCHAR2(20 byte), "CREATETIME" DATE, "TYPE" VARCHAR2(2 byte),
    "PRODUCTID" VARCHAR2(50 byte), "MINNUM" NUMBER(10), "NOTE" 
    VARCHAR2(1000 byte), 
    CONSTRAINT "PK_DB_BRANDPRODUCT" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING ;


------------------------------------ hp 20130312-----------------------------------------
create sequence product_seq_id
increment by 1
start with 1
maxvalue 99999999
minvalue 1 

--------------------------hp 20130312------------------------------------
alter table DB_PRODUCTDEVELOP add finishtime date;
alter table DB_PRODUCTDEVELOP add RESERVE1 VARCHAR2(100);
alter table DB_PRODUCTDEVELOP add RESERVE2 VARCHAR2(100);
alter table DB_PRODUCTDEVELOP add RESERVE3 NUMBER(8,4);
alter table DB_PRODUCTDEVELOP add RESERVE4 NUMBER(8,4);
alter table DB_PRODUCTDEVELOP add RESERVE5 NUMBER(8);
alter table DB_PRODUCTDEVELOP add RESERVE6 date;

-----------------------HJ 20130313	采购批次表---------------------------
alter table DB_PURCHASEDEVELOP add status varchar2(50);
alter table db_purchaselog add reserve6 number(2);

-----------------------LY 20130312---------------------------

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values('6302', '系统报表', '系统报表', '/eshop/report.do?method=bossreport', 0, 3, '6300', 2, 3, '#99AB32', null, 'ly', null, null);
-----------------LXD 2013-3-12---------------------------------------------------
insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5) values('5219', '质量反馈报表', '质量反馈报表', '/eshop/report.do?method=reportFeeBack', 0, 3, 5200, 33,'3', '', null, '梁曦冬', null, null);

alter table db_platform add id number(3);
alter table DB_SALESCOEFFICIENT add ALERTNUM NUMBER(4);
alter table DB_SALESCOEFFICIENT add PURCHASENUM NUMBER(4);

-----------------------HJ 20130208	商品自定义搜索脚本---------------------------
insert into db_menufunc values('2212','商品搜索脚本','商品搜索脚本','/eshop/product.do?method=productSearchList','0','3','2200','17','3','60','','','','');
insert into db_opermenu values('admin','2212');

---------------------------sl 20130311------------
alter table DB_GIFT add createoper varchar2(50);
alter table DB_GIFT add createtime date;

-----------------------LY 20130311---------------------------
insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values('1408', '英国邮政统计', '英国邮政统计', '/eshop/report.do?method=UKexpresstypereport', 0, 3, '1400', 442, 3, '#99AB32', null, 'ly', null, null);
-----------------------HJ 20130208	商品自定义搜索脚本---------------------------
CREATE TABLE "DB_PRODUCTSEARCH" ("SEQUENCEID" 
    VARCHAR2(50 byte) NOT NULL, "NAME" VARCHAR2(100 byte), 
    "DESCR" VARCHAR2(2000 byte), "OPER" VARCHAR2(100 byte), 
    "OPERTIME" DATE, "OPENFLAG" VARCHAR2(50 byte), "SQLFILTER1" 
    VARCHAR2(4000 byte), "SQLFILTER2" VARCHAR2(4000 byte), 
    "FILED1" NUMBER(6), "FILED2" NUMBER(6), "FILED3" VARCHAR2(500
    byte), "FILED4" VARCHAR2(500 byte), "FILED5" VARCHAR2(500 
    byte), "FILED6" VARCHAR2(500 byte), "FILED7" VARCHAR2(500 
    byte), "FILED8" VARCHAR2(500 byte), "FILED9" VARCHAR2(500 
    byte), "FILED10" VARCHAR2(500 byte), "FILED11" VARCHAR2(500 
    byte), "FILED12" VARCHAR2(500 byte), "FILED13" VARCHAR2(500 
    byte), "FILED14" VARCHAR2(500 byte), "FILED15" VARCHAR2(500 
    byte), "FILED16" VARCHAR2(500 byte), "FILED17" VARCHAR2(500 
    byte), "FILED18" VARCHAR2(500 byte), "FILED19" VARCHAR2(500 
    byte), "FILED20" VARCHAR2(500 byte), "FLAG1" VARCHAR2(50 
    byte), "FLAG2" VARCHAR2(50 byte), "FLAG3" VARCHAR2(50 byte), 
    "FLAG4" VARCHAR2(50 byte), "FLAG5" VARCHAR2(50 byte), "FLAG6"
    VARCHAR2(50 byte), "FLAG7" VARCHAR2(50 byte), "FLAG8" 
    VARCHAR2(50 byte), "FLAG9" VARCHAR2(50 byte), "FLAG10" 
    VARCHAR2(50 byte), "FLAG11" VARCHAR2(50 byte), "FLAG12" 
    VARCHAR2(50 byte), "FLAG13" VARCHAR2(50 byte), "FLAG14" 
    VARCHAR2(50 byte), "FLAG15" VARCHAR2(50 byte), "FLAG16" 
    VARCHAR2(50 byte), "FLAG17" VARCHAR2(50 byte), "FLAG18" 
    VARCHAR2(50 byte), "FLAG19" VARCHAR2(50 byte), "FLAG20" 
    VARCHAR2(50 byte), 
    CONSTRAINT "PK_DB_PRODUCTSEARCH" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING ;
COMMENT ON TABLE "DB_PRODUCTSEARCH" IS '自定义商品搜索'

-------------------sl 20130305关键词表-----------------
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);

-------------------sl 20130305关键词关联表-----------------
CREATE TABLE "DB_ANTISTOPRELE" ("SEQUENCEID" VARCHAR2(50 
    byte) NOT NULL, "ANTISTOP1" VARCHAR2(500 byte), "ANTISTOP2" 
    VARCHAR2(500 byte), "OPER" VARCHAR2(50 byte), "OPERTIME" DATE,
    "CORPID" VARCHAR2(10 byte), "OPENFLAG" VARCHAR2(10 byte), 
    CONSTRAINT "PK_DB_ANTISTOPRELE" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING; 
--------------------sl 20130305礼物系统表------------------
CREATE TABLE "DB_GIFT" ("SEQUENCEID" VARCHAR2(50 byte) 
    NOT NULL, "PRODUCTID" VARCHAR2(100 byte), "PRODUCTNAME" 
    VARCHAR2(500 byte), "PRODUCTNAMEEN" VARCHAR2(500 byte), 
    "WEIGHT" NUMBER(8, 4), "COSTPRICE" NUMBER(8, 4), "SELLPRICE" 
    NUMBER(8, 4), "SAVENUM" NUMBER(10), "OPER1" VARCHAR2(50 byte),
    "OPER2" VARCHAR2(50 byte), "SHOPTYPE" VARCHAR2(100 byte), 
    "SHOPTYPEID" VARCHAR2(50 byte), "PICTUREURL" VARCHAR2(500 
    byte), "EBAYITEMID" VARCHAR2(100 byte), "EBAYSITE" 
    VARCHAR2(50 byte), "RESERVE1" VARCHAR2(500 byte), "RESERVE2" 
    VARCHAR2(500 byte), "RESERVE3" VARCHAR2(500 byte), "RESERVE4"
    NUMBER(10, 4), "RESERVE5" NUMBER(10, 4), "OPER" VARCHAR2(50 
    byte), "OPERTIME" DATE, "CORPID" VARCHAR2(10 byte), 
    "OPENFLAG" VARCHAR2(10 byte), "CATEGORYID" VARCHAR2(50 byte),
    "CATEGORY" VARCHAR2(200 byte), 
    CONSTRAINT "PK_DB_GIFT" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING;
--------------------sl 20130304--------------
alter table DB_ANTISTOP add name varchar2(200);
alter table DB_ANTISTOP add remark varchar2(4000);
--------------------sl 20130301------------
alter table DB_PUBLISHPICTURE add ATTRIBUTEID varchar2(50);

-------------------2013-03-1---------------------------------------
alter table DB_SYSADMIN add OPERID NUMBER(4);
alter table DB_SHOP add SPAYPALNAME varchar2(100);
insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values('1004', '供应商关联配置', '供应商关联配置', '/eshop/product.do?method=productandmanufacturelist', 0, 3, '3', 442, 3, '#99AB32', null, '梁曦冬', null, null);
----------------------------------20130228 产品销售流程 hp----------------------------------------
CREATE TABLE "DB_PRODUCTDEVELOP" ("SEQUENCEID" 
    VARCHAR2(50 byte) NOT NULL, "PRODUCTSOURCE" VARCHAR2(50 byte),
    "PRODUCTID" VARCHAR2(50 byte), "GOALACCOUNT" VARCHAR2(50 
    byte), "PHOTOURL" VARCHAR2(100 byte), "PRODUCTTITLE" 
    VARCHAR2(100 byte), "NAMECHN" VARCHAR2(100 byte), "URL" 
    VARCHAR2(100 byte), "GOALSELL" NUMBER(8, 4), "EXPRESSTYPE" 
    NUMBER(8, 4), "ESTIMATEWEIGHT" NUMBER(8, 4), "GOALADRESS" 
    VARCHAR2(500 byte), "ANTISTOP" VARCHAR2(100 byte), "NOTE" 
    VARCHAR2(4000 byte), "CREATEOPER" VARCHAR2(50 byte), 
    "CREATETIME" DATE, "CREATECHECKOPER" VARCHAR2(50 byte), 
    "CREATECHECKTIME" DATE, "MARKETOPER" VARCHAR2(50 byte), 
    "FORECASTGROSS" VARCHAR2(10 byte), "FORECASTSELLNUM" 
    NUMBER(8), "QUALITY" VARCHAR2(10 byte), "SECULAR" VARCHAR2(10
    byte), "COUNTRY" VARCHAR2(50 byte), "IFOLDSKU" VARCHAR2(10 
    byte), "URGENT" VARCHAR2(10 byte), "OPER" VARCHAR2(50 byte), 
    "OPERTIME" DATE, "OPENFLAG" VARCHAR2(10 byte), "CORPID" 
    VARCHAR2(10 byte), "PRODUCTNUM" NUMBER(8), "STATUS" 
    VARCHAR2(10 byte), "PICTURE" VARCHAR2(50 byte), 
    "PURCHASEFLOWOPER" VARCHAR2(50 byte), "CONTENT" VARCHAR2(4000
    byte), 
    CONSTRAINT "PK_DB_PRODUCTDEVELOP" PRIMARY KEY("SEQUENCEID")) 
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 

-------------------2013-02-27---------------------------------------
1004	供应商关联配置	供应商关联配置	/eshop/product.do?method=productandmanufacturelist	0	3	442	39	3	#99AB32		梁曦冬		
-------------------动态采购管理 2013-02-26 归类在商品配置里---------
insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values('1002', '动态采购管理', '动态采购管理', '/eshop/other.do?method=autoaddsalenumlist', 0, 3, '3', 442, 3, '#99AB32', null, '梁曦冬', null, null);
	
CREATE TABLE "DB_AUTOADDSALENUMLOG" ("SEQUENCEID" 
    VARCHAR2(50 byte) NOT NULL, "SID" VARCHAR2(100 byte), 
    "STARTSALENUM" NUMBER(8, 3), "ENDSALENUM" NUMBER(8, 3), 
    "ALERTNUM" NUMBER(4), "PURCHASENUM" NUMBER(4), "OPER" 
    VARCHAR2(100 byte), "OPERTIME" DATE, "RESERVE1" VARCHAR2(100 
    byte), "RESERVE2" VARCHAR2(100 byte), "RESERVE3" VARCHAR2(100
    byte), "RESERVE4" NUMBER, "RESERVE5" NUMBER, "RESERVE6" 
    NUMBER(8, 3), "CORPID" VARCHAR2(50 byte), "OPENFLAG" 
    VARCHAR2(10 byte), "OPERTYPE" VARCHAR2(50 byte), "CONTENT" 
    VARCHAR2(2000 byte), 
    CONSTRAINT "PK_DB_AUTOADDSALENUMLOG" PRIMARY 
    KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING ;

CREATE TABLE "DB_AUTOADDSALENUM" ("SEQUENCEID" 
    VARCHAR2(50 byte) NOT NULL, "STARTSALENUM" NUMBER(8, 3), 
    "ENDSALENUM" NUMBER(8, 3), "ALERTNUM" NUMBER(4), 
    "PURCHASENUM" NUMBER(4), "OPER" VARCHAR2(100 byte), 
    "OPERTIME" DATE, "RESERVE1" VARCHAR2(100 byte), "RESERVE2" 
    VARCHAR2(100 byte), "RESERVE3" VARCHAR2(100 byte), "RESERVE4"
    NUMBER, "RESERVE5" NUMBER, "RESERVE6" NUMBER(8, 3), 
    CONSTRAINT "PK_DB_AUTOADDSALENUM" PRIMARY KEY("SEQUENCEID")) 
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING ;
---------------------db_menufunc修改-----------------------
update DB_MENUFUNC set funname='员工管理' where funame='员工代表管理'

---------------------香港EUB物品类型 hp 2013-02-25----------
alter table DB_CATEGORY add hkinsurancetype varchar2(50);
alter table DB_CATEGORY add HKCATEGORY varchar2(50);

-----------------sl ftp上传配置--------------------------------------
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);

aaaaaaaaaaaaaaaaaaaaaaa

---------------hp 20130219销售系数表及日志表----------------------
CREATE TABLE "DB_SALESCOEFFICIENT" ("SEQUENCEID"
    VARCHAR2(50 byte) NOT NULL, "RANK" VARCHAR2(10 byte),
    "RANGE1" NUMBER(8, 4), "RANGE2" NUMBER(8, 4), "OPER"
    VARCHAR2(20 byte), "OPERTIME" DATE, "OPENFLAG" VARCHAR2(10
    byte), "CORPID" VARCHAR2(10 byte), "FILED1" VARCHAR2(100
    byte), "FILED2" VARCHAR2(100 byte), "FILED3" NUMBER(8),
    "FILED4" NUMBER(8, 4), "FILED5" NUMBER(8, 4),
    CONSTRAINT "PK_DB_SALESCOEFFICIENT" PRIMARY KEY("SEQUENCEID")
    USING INDEX
    TABLESPACE "ZHRGPT"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)

    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING;



CREATE TABLE "DB_SALESCOEFFICIENTLOG" ("SEQUENCEID"
    VARCHAR2(50 byte) NOT NULL, "RANK" VARCHAR2(10 byte),
    "RANGE1" NUMBER(8, 4), "RANGE2" NUMBER(8, 4), "OPER"
    VARCHAR2(20 byte), "OPERTIME" DATE, "OPENFLAG" VARCHAR2(10
    byte), "CORPID" VARCHAR2(10 byte), "OPERTYPE" VARCHAR2(10
    byte), "CONTENT" VARCHAR2(1000 byte), "FILED1" VARCHAR2(100
    byte), "FILED2" VARCHAR2(100 byte), "FILED3" NUMBER(8),
    "FILED4" NUMBER(8, 4), "FILED5" NUMBER(8, 4),
    CONSTRAINT "DB_SALESCOEFFICIENTLOG" PRIMARY KEY("SEQUENCEID")
    USING INDEX
    TABLESPACE "ZHRGPT"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)

    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING;


--------清除原来的店铺平台----------lxd------------
truncate table db_platform;
--------增加index------------------------------------
alter table db_platform add id number(3);
--------增加店铺平台---------------------------------
insert into db_platform (sequenceid,name,descr,oper,opertime,filed8,corpid,openflag,id) values('1','ebay','ebay','admin',sysdate,1,'1','1',1);
insert into db_platform (sequenceid,name,descr,oper,opertime,filed8,corpid,openflag,id) values('2','Amazon US','Amazon US','admin',sysdate,2,'1','1',2);
insert into db_platform (sequenceid,name,descr,oper,opertime,filed8,corpid,openflag,id) values('3','Amazon CN','Amazon CN','admin',sysdate,3,'1','1',3);
insert into db_platform (sequenceid,name,descr,oper,opertime,filed8,corpid,openflag,id) values('4','1号店','1号店','admin',sysdate,4,'1','1',4);
insert into db_platform (sequenceid,name,descr,oper,opertime,filed8,corpid,openflag,id) values('5','淘宝','淘宝','admin',sysdate,5,'1','1',5);
insert into db_platform (sequenceid,name,descr,oper,opertime,filed8,corpid,openflag,id) values('6','Tmall','Tmall','admin',sysdate,6,'1','1',6);
insert into db_platform (sequenceid,name,descr,oper,opertime,filed8,corpid,openflag,id) values('7','京东','京东','admin',sysdate,7,'1','1',7);
insert into db_platform (sequenceid,name,descr,oper,opertime,filed8,corpid,openflag,id) values('8','ioffer','ioffer','admin',sysdate,8,'1','1',8);
insert into db_platform (sequenceid,name,descr,oper,opertime,filed8,corpid,openflag,id) values('9','Joomla ZM','Joomla ZM','admin',sysdate,9,'1','1',9);
insert into db_platform (sequenceid,name,descr,oper,opertime,filed8,corpid,openflag,id) values('10','aliexpress','aliexpress','admin',sysdate,10,'1','1',10);
insert into db_platform (sequenceid,name,descr,oper,opertime,filed8,corpid,openflag,id) values('11','Zen Cart','Zen Cart','admin',sysdate,11,'1','1',11);
insert into db_platform (sequenceid,name,descr,oper,opertime,filed8,corpid,openflag,id) values('12','Dhgate','Dhgate','admin',sysdate,12,'1','1',12);
insert into db_platform (sequenceid,name,descr,oper,opertime,filed8,corpid,openflag,id) values('13','other','other','admin',sysdate,13,'1','1',13);

---------------ly 20130218跟踪号仓库表----------------------
insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('231', '内部单号管理', '内部单号管理', '/eshop/expresstype.do?method=expressidlist', 0, 3, '203', 23, 3, '#FFFFFF', null, '李源', 'http://www.mabangapp.com/forum/李源.html', null);


CREATE TABLE DB_EXPRESSIDDATA 
(SID VARCHAR2(100
    byte) NOT NULL, 
Prefix VARCHAR2(500 byte), 
Suffix VARCHAR2(500 byte), 
EXPRESSIDBEGIN    NUMBER(12), 
EXPRESSIDEND NUMBER(12), 
USEEXPRESSID NUMBER(12), 
EXPRESSTYPEID
    VARCHAR2(500 byte),
EXPRESSTYPE VARCHAR2(50 byte),
operflag VARCHAR2(10 byte), 
OPER VARCHAR2(50 byte),
   
 OPERTIME DATE, 
CREATEOPER VARCHAR2(50 byte), 
CREATTIME
    DATE, CORPID VARCHAR2(10 byte),
   
 CONSTRAINT PK_DB_EXPRESSIDDATA PRIMARY KEY(SID));		
 
 

CREATE TABLE DB_EXPRESSIDDATALOG

(SEQUENCEID VARCHAR2(100
    byte) NOT NULL,

SID VARCHAR2(100
    byte),

Prefix VARCHAR2(500 byte),
Suffix VARCHAR2(500 byte),
EXPRESSIDBEGIN    NUMBER(12),
EXPRESSIDEND NUMBER(12),
USEEXPRESSID NUMBER(12),
EXPRESSTYPEID
    VARCHAR2(500 byte),

EXPRESSTYPE VARCHAR2(50 byte),

operflag VARCHAR2(10 byte),
OPER VARCHAR2(50 byte),

OPERTIME DATE,

CREATEOPER VARCHAR2(50 byte),

CREATTIME
    DATE,

OPENTYPE VARCHAR2(50 byte),

CONTENT VARCHAR2(4000 byte),

CORPID VARCHAR2(10 byte),
CONSTRAINT PK_DB_EXPRESSIDDATALOG PRIMARY KEY(SEQUENCEID));
---------------sl 20130204----------------------
CREATE TABLE "DB_PUBLISHPICTURE" ("SEQUENCEID" 
    VARCHAR2(100 byte) NOT NULL, "PRODUCTID" VARCHAR2(50 byte), 
    "PICTUREURL" VARCHAR2(300 byte), "ATTRIBUTE" VARCHAR2(50 
    byte), "PLATFORMID" VARCHAR2(20 byte), "PLATFORMNAME" 
    VARCHAR2(50 byte), "FLAG" VARCHAR2(10 byte), "SHOPTYPEID" 
    VARCHAR2(10 byte), "SHOPTYPENAME" VARCHAR2(50 byte), "CORPID"
    VARCHAR2(10 byte), "OPENFLAG" VARCHAR2(10 byte), "OPER" 
    VARCHAR2(50 byte), "OPERTIME" DATE, "CREATEOPER" VARCHAR2(50 
    byte), "CREATETIME" DATE, 
    CONSTRAINT "PK_DB_PUBLISHPICTURE" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING;  
    alter table DB_PUBLISHPICTURE add attributeid varchar2(50);
    alter table DB_PUBLISHPICTURE add useing varchar2(50);
    alter  table DB_PUBLISHPICTURE modify shoptypeid varchar2(100);
     alter  table DB_PUBLISHPICTURE modify platformid varchar2(100);
---------------产品级别修改字段---------------------------
alter table DB_productclass modify AVGSELLNUM1 NUMBER(8,3) ;
alter table DB_productclass modify AVGSELLNUM2 NUMBER(8,3) ;
insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values('1003', '产品级别管理', '产品级别管理', '/eshop/product.do?method=productclasslist', 0, 3, '442', 79, 3, '#FFFFFF', null, null, null, null);
-------------------------------------------------------------- hp 20130203 --------------------------------------------------------------------
------------------- 库存低于0或为0时，入库日销量也设为0 -------------------
update db_product set reserve11 = 0 where savenum <= 0 and reserve11 is null
------------------- 库存高于0，入库日销量也设为当日日销量 -----------------
update db_product set reserve11 = reserve9 where status not in ('清仓','停产') and savenum > 0 and reserve11 is null
-----------------sl 关键词------------------------------
CREATE TABLE "DB_ANTISTOP" ("SEQUENCEID" VARCHAR2(100 
    byte) NOT NULL, "ANTISTOP" VARCHAR2(500 byte), "DESCR" 
    VARCHAR2(4000 byte), "PARENTID" VARCHAR2(50 byte), 
    "PARENTFLAG" VARCHAR2(10 byte), "OPER" VARCHAR2(50 byte), 
    "OPERTIME" DATE, "CREATEOPER" VARCHAR2(50 byte), "CREATTIME" 
    DATE, "CORPID" VARCHAR2(10 byte), "OPENFLAG" VARCHAR2(10 
    byte), 
    CONSTRAINT "PK_DB_OPENFLAG" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 
    
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);

alter table DB_ORDER_HISTORY modify LOCATIONID varchar2(4000);



----------------hp 采购流程  20130122----
CREATE TABLE "DB_PURCHASEFLOW" ("SEQUENCEID" VARCHAR2(50 
    byte) NOT NULL, "OPER" VARCHAR2(50 byte), "OPENFLAG" 
    VARCHAR2(10 byte), "OPERTIME" DATE, "CORPID" VARCHAR2(50 
    byte), "ARRIVEDATE" DATE, "POSITION" VARCHAR2(1000 byte), 
    "FOLLOWUPOPER" VARCHAR2(50 byte), "POORDERFLAG" VARCHAR2(10 
    byte), "COMPANY" VARCHAR2(1000 byte), "PRODUCTID" VARCHAR2(50
    byte), "PRODUCTNAME" VARCHAR2(1000 byte), "PAYMENT" 
    VARCHAR2(200 byte), "ALLMONEY" NUMBER(10, 2), "DEPOSIT" 
    NUMBER(10, 2), "STATUS" VARCHAR2(10 byte), "DOLLAR" NUMBER(10,
    2), "POSURE" VARCHAR2(100 byte), "CONTENT" VARCHAR2(4000 
    byte), "PHOTOQCDATE" DATE, "NOTE" VARCHAR2(4000 byte), 
    "SAMPLENUM" NUMBER(8), "SAMPLEARRIVEDATE" DATE, "FTCBM" 
    NUMBER(10, 4), "DELIVERYDATE" DATE, "FINISHORDERDATE" DATE, 
    "DRAWBACKDATE" DATE, "CITY" VARCHAR2(500 byte), "EXPRESSDATE"
    DATE, "CKY" VARCHAR2(100 byte), "FPX" VARCHAR2(100 byte), 
    "EXPRESSID" VARCHAR2(50 byte), "PONUM" VARCHAR2(50 byte), 
    "LOADDATE" DATE, "ETAHARBOURDATE" DATE, "ETAARRIVEDATE" DATE,
    "ARRIVESTOREDATE" DATE, "CONTAINERNOTE" VARCHAR2(2000 byte), 
    "AUGARNEREDDATE" DATE, "PACKINGLIST" VARCHAR2(2000 byte), 
    "BILLOFLADING" VARCHAR2(100 byte), "SHIPMENTUPDATEINVENTORY" 
    VARCHAR2(1000 byte), "GARNEREDUPDATEINVENTORY" VARCHAR2(1000 
    byte), "CLOSEDATE" DATE, "GROUPID" VARCHAR2(50 byte), 
    "DEPOSITDATE" DATE, "EXPRESSTYPE" VARCHAR2(50 byte), 
    "CREATEOPER" VARCHAR2(50 byte), "CREATEDATE" DATE, 
    "DRAWBACKFLAG" VARCHAR2(50 byte), "SHIPMENTDATE" DATE, 
    "ARRIVALDATE" DATE, "FINALDATE" DATE, "SHIPMENTMONEY" 
    NUMBER(10, 2), "ARRIVALMONEY" NUMBER(10, 2), "FINALMONEY" 
    NUMBER(10, 2), "URGENT" VARCHAR2(50 byte), "MONEYNOTE" 
    VARCHAR2(4000 byte), "PICTURE1" VARCHAR2(500 byte), 
    "RESERVE1" VARCHAR2(500 byte), "RESERVE2" VARCHAR2(500 byte),
    "RESERVE3" VARCHAR2(500 byte), "RESERVE4" VARCHAR2(500 byte),
    "RESERVE5" VARCHAR2(500 byte), "RESERVE6" DATE, "RESERVE7" 
    DATE, "RESERVE8" DATE, "RESERVE9" NUMBER(8), "RESERVE10" 
    NUMBER(8), "RESERVE11" NUMBER(8), "RESERVE12" NUMBER(8, 4), 
    "RESERVE13" NUMBER(8, 2), "RESERVE14" NUMBER(8, 2), 
    "OUTERLENGTH" NUMBER(8, 2), "OUTERWIDTH" NUMBER(8, 2), 
    "OUTERHIGH" NUMBER(8, 2), "OUTERVOLUME" NUMBER(8, 2), 
    "OUTERGROSSWEIGHT" NUMBER(8, 2), "OUTERNETWEIGHT" NUMBER(8, 
    2), "OUTERNORMS" VARCHAR2(1000 byte), "OUTERLEVEL" 
    VARCHAR2(500 byte), "GROSSWEIGHT" NUMBER(8, 2), "LENGTH" 
    NUMBER(8, 2), "WIDTH" NUMBER(8, 2), "HIGH" NUMBER(8, 2), 
    "VOLUME" NUMBER(8, 2), 
    CONSTRAINT "PK_DBPURCHASEFLOW" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 
----------------sl 出口易表----
CREATE TABLE "DB_DEPARTMENTAPI" ("SEQUENCEID" 
    VARCHAR2(100 byte) NOT NULL, "DEPARTMENT" VARCHAR2(100 byte),
    "USERNAME" VARCHAR2(100 byte), "USERKEY" VARCHAR2(100 byte), 
    "TOKEN" VARCHAR2(200 byte), "PASSWORD" VARCHAR2(50 byte), 
    "RESERVE1" VARCHAR2(500 byte), "RESERVE2" VARCHAR2(500 byte),
    "RESERVE3" VARCHAR2(100 byte), "RESERVE4" NUMBER(10, 3), 
    "RESERVE5" NUMBER(10, 3), "OPER" VARCHAR2(400 byte), 
    "OPERTIME" DATE, 
    CONSTRAINT "PK_DEPARTMENT_SEQUENCEID" PRIMARY 
    KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 
    
    
    
---------------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 这个是好评的数量

---------------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);
 
 update DB_MENUFUNC set funname='入库量报表' where funname='采购管理1 ';

---------------功能模块分配---------------
update DB_MENUFUNC set reserve3='李源',reserve4='http://www.mabangapp.com/forum/李源.html' where funname in ('所有订单','今日订单','新订单','已支付','配货中','已发货','已完成','作废订单','可合并的订单');

update DB_MENUFUNC set reserve3='李源',reserve4='http://www.mabangapp.com/forum/李源.html' where funname in ('单日物流报表','订单情况表','订单购买量','订单价格区间','订单延迟报表','订单处理日志表','物流统计');

update DB_MENUFUNC set reserve3='李源',reserve4='http://www.mabangapp.com/forum/李源.html' where funname in ('供应商管理PRO','库存报表','滞销商品报表','采购频率查询','供应商采购报表');

update DB_MENUFUNC set reserve3='李源',reserve4='http://www.mabangapp.com/forum/李源.html' where funname in ('日收入报表','日销售报表','月销售额报表','热销商品排名','热销店铺排名','按地区销售额报表','按国家销售额报表','商品反馈报表','项目商品销售监控');

update DB_MENUFUNC set reserve3='李源',reserve4='http://www.mabangapp.com/forum/李源.html' where funname in ('货币金额报表','供应商营业额报表','客户排名','单商品销售查询','人员营业报表','PayPal销售额报表','退款报表','财务支出报表');

update DB_MENUFUNC set reserve3='李源',reserve4='http://www.mabangapp.com/forum/李源.html'  where funname in ('员工代表管理','店铺账号管理');

update DB_MENUFUNC set reserve3='韩健',reserve4='http://www.mabangapp.com/forum/韩健.html' where funname in('包装验货','包装验货pro','订单搜索脚本','订单搜索脚本pro','上传EBAY订单','上传亚马逊订单','上传速卖通订单','上传通用订单','订单过渡');

update DB_MENUFUNC set reserve3='韩健',reserve4='http://www.mabangapp.com/forum/韩健.html' where funname in('产品列表','批量增加产品');

update DB_MENUFUNC set reserve3='黄鹏',reserve4='http://www.mabangapp.com/forum/黄鹏.html' where funname in('E邮宝订单','退款管理','货运方式设置','新增单个产品','计算价格','商品修改日志查询');

update DB_MENUFUNC set reserve3='黄鹏',reserve4='http://www.mabangapp.com/forum/黄鹏.html' where funname in('智能生成采购单','采购管理','入库管理','异常采购单','在线商品管理','商品质量反馈pro','论坛','工作任务');

update DB_MENUFUNC set reserve3='史亮',reserve4='http://www.mabangapp.com/forum/史亮.html' where funname in('Paypal对账','过期订单归档','查询历史订单','下载zencart订单','警戒时间配置','订单自定义类型','绑定商品','盘点库存','产品导出','商品质量反馈');

update DB_MENUFUNC set reserve3='史亮',reserve4='http://www.mabangapp.com/forum/史亮.html' where funname in('批量修改仓位','产品批量修改','商品空值查询','商品网名管理','仓库设置','仓位设置','商品目录管理','包材设置','增加商品网名','采购管理1 ','入库量报表1 ','公告管理');

update DB_MENUFUNC set reserve3='史亮',reserve4='http://www.mabangapp.com/forum/史亮.html' where funname in('手动入库','项目管理','部门管理','Ebay订单提取规则','Paypal','国家配置','汇率设置','供应商管理','zencart配置','邮件内容配置','销售平台管理','系统说明');

update DB_MENUFUNC set reserve3='梁溪东',reserve4='http://www.mabangapp.com/forum/梁曦冬.html' where funname in('订单修改日志查询','品牌管理','盘点查询','未分配消息','待处理消息','所有消息','配置参与工号','设置自定义状态','设置快捷短语','删除消息','内部短消息','设置店铺分配','设置商品目录分配','按买家ID首字母分配','订单通知消息','消息分类配置','消息监控报表','查看公告','产品图片配置','系统日志');

--------------------hp 20130111---------------------------------------
update DB_PROTOCOL set OPENFLAG = '1'
alter table DB_PROTOCOL add OPENFLAG varchar2(50);


--------------------sl 采购主表---------------------------------------
CREATE TABLE "DB_PURCHASEDEVELOP" ("SEQUENCEID" 
    VARCHAR2(100 byte) NOT NULL, "GROUPID" VARCHAR2(100 byte), 
    "MANUFACTUREID" VARCHAR2(100 byte), "MANUFACTURENAME" 
    VARCHAR2(500 byte), "PAYTYPE" VARCHAR2(100 byte), "FREIGHT" 
    NUMBER(8, 2), "OPER" VARCHAR2(100 byte), "OPERTIME" DATE, 
    "CREATOPER" VARCHAR2(100 byte), "CREATOPERTIME" DATE, 
    "CORPID" VARCHAR2(100 byte), "OPENFLAG" VARCHAR2(10 byte), 
    "RESERVE1" VARCHAR2(500 byte), "RESERVE2" VARCHAR2(500 byte),
    "RESERVE3" VARCHAR2(500 byte), "RESERVE4" NUMBER(10), 
    "RESERVE5" NUMBER(8, 2), 
    CONSTRAINT "PK_DBPURCHASEDEVELOP" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 


---------------------ly 20130106菜单配置---------------------------------

update DB_MENUFUNC set reserve5=null;

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('201', '订单流程管理', '订单流程管理', '#', 0, 0, '2', 1, 3, '#FFFFFF', null, null, null, 2);	

update DB_MENUFUNC set parentid='201',ifparent=3 where funname in('所有订单','今日订单','新订单','已支付','配货中','已发货','已完成','作废订单','可合并的订单','E邮宝订单','包装验货','包装验货pro');

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('202', 'paypal管理', 'paypal管理', '#', 0, 0, '2', 2, 3, '#FFFFFF', null, null, null, 2);	

update DB_MENUFUNC set parentid='202',ifparent=3 where funname in('Paypal对账','退款管理');

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('203', '订单配置', '订单配置', '#', 0, 0, '2', 3, 3, '#FFFFFF', null, null, null, 2);

update DB_MENUFUNC set parentid='203',ifparent=3 where funname in('买家记录','订单过渡','单商品订单','智能物流选择','过期订单归档','查询历史订单','订单搜索脚本','订单搜索脚本pro','上传EBAY订单','上传亚马逊订单','上传速卖通订单','上传通用订单','下载zencart订单','订单修改日志查询','货运方式设置','订单自定义类型');

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('204', '订单报表', '订单报表', '#', 0, 0, '2', 4, 3, '#FFFFFF', null, null, null, 2);

update DB_MENUFUNC set parentid='204',ifparent=3 where funname in('单日物流报表','订单情况表','订单购买量','订单价格区间','订单延迟报表','订单处理日志表','物流统计');

update DB_MENUFUNC set funname='商品库存',fundesc='商品库存' where funname='产品管理';

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('441', '库存管理', '库存管理', '#', 0, 0, '4', 1, 3, '#FFFFFF', null, null, null, 2);

update DB_MENUFUNC set parentid='441',ifparent=3 where funname in('产品列表','绑定商品','新增单个产品','盘点库存','产品导出','计算价格','供应商管理PRO','商品质量反馈');

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('442', '商品配置', '商品配置', '#', 0, 0, '4', 2, 3, '#FFFFFF', null, null, null, 2);

update DB_MENUFUNC set parentid='442',ifparent=3 where funname in('批量修改仓位','产品批量修改','批量增加产品','商品修改日志查询','商品空值查询','商品网名管理','品牌管理','仓库设置','仓位设置','商品目录管理','包材类型设置','增加商品网名','在线产品维护','各店铺在线商品','在线商品对比','商品下线','供应商管理');

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('443', '商品报表', '商品报表', '#', 0, 0, '4', 3, 3, '#FFFFFF', null, null, null, 2);

update DB_MENUFUNC set parentid='443',ifparent=3 where funname in('库存报表','盘点查询','滞销商品报表','采购管理1 ','入库量报表1 ');

update DB_MENUFUNC set funname='采购调拨',fundesc='采购调拨' where funname='采购库存';

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('661', '采购管理', '采购管理', '#', 0, 0, '6', 1, 3, '#FFFFFF', null, null, null, 2);

update DB_MENUFUNC set parentid='661',type='3',ifparent=3 where funid in('52','36','304','66','54');

update DB_MENUFUNC set parentid='442',type='3',ifparent=3 where funname in('警戒时间配置');

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('662', '调拨管理', '调拨管理', '#', 0, 0, '6', 2, 3, '#FFFFFF', null, null, null, 2);

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('663', '采购报表', '采购报表', '#', 0, 0, '6', 3, 3, '#FFFFFF', null, null, null, 2);

update DB_MENUFUNC set parentid='663',ifparent=3 where funname in('采购频率查询','供应商营业额报表');

update DB_MENUFUNC set reserve2=null where funid='9';

update DB_MENUFUNC set funname='销售管理',fundesc='销售管理',reserve2='menu_icon04 png_bg' where funname='运营管理';

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('801', '销售管理', '销售管理', '#', 0, 0, '8', 1, 3, '#FFFFFF', null, null, null, 2);

update DB_MENUFUNC set parentid='801',ifparent=3 where funname in('直线商品管理','各店铺在线商品','销售流程','商品质量反馈pro','项目管理','在线商品管理');

update DB_MENUFUNC set funname='在线商品管理',fundesc='在线商品管理' where funname='各店铺在线商品';

update DB_MENUFUNC set ifwinopen=0,ifparent=3 where funname='项目管理';

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('802', '销售报表', '销售报表', '#', 0, 0, '8', 2, 3, '#FFFFFF', null, null, null, 2);

update DB_MENUFUNC set parentid='802',ifparent=3 where funname in('日收入报表','日销售报表','月销售额报表','热销商品排名','热销店铺排名','按地区销售额报表','按国家销售额报表','商品反馈报表','项目商品销售监控','利润区间查询','货币金额报表','供应商营业额报表','客户排名','单商品销售查询','人员营业报表','PayPal金额报表','退款报表');

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('900', '企业内部管理', '企业内部管理', '#', 0, 1, '900', 6, 3, '#FFFFFF', 'menu_icon12 png_bg', null, null, null);

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('901', '企业内部管理', '企业内部管理', '#', 0, 0, '900', 1, 3, '#FFFFFF', null, null, null, 2);

update DB_MENUFUNC set parentid='901',ifparent=3 where funname in('论坛','工作任务','查看公告','内部短消息','收入支出管理','公告管理','修改密码');

update DB_MENUFUNC set ifwinopen=0,ifparent=3 where funname in('论坛','工作任务','收入支出管理');

update DB_MENUFUNC set funname='工作任务',fundesc='工作任务',reserve2=null where funname='流程管理';

update DB_MENUFUNC set funname='收入支出管理',fundesc='收入支出管理',reserve2=null where funname='企业流水帐';

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('902', '配置', '配置', '#', 0, 0, '900', 2, 3, '#FFFFFF', null, null, null, 2);

update DB_MENUFUNC set parentid='902',ifparent=3 where funname in('员工代表管理','组别管理','收支类型设置','业务工作流设置','部门管理');

update DB_MENUFUNC set funname='部门管理',fundesc='部门管理',reserve2=null where funname='组别管理';

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('903', '报表', '报表', '#', 0, 0, '900', 3, 3, '#FFFFFF', null, null, null, 2);

update DB_MENUFUNC set parentid='903',ifparent=0 where funname in('财务支出报表');

update DB_MENUFUNC set reserve5=2,reserve2='menu_icon07 png_bg' where funname in('系统管理');

update DB_MENUFUNC set parentid='3',ifparent=3 where funname in('店铺账号管理','Ebay订单提取规则','Paypal','国家配置','汇率设置','供应商管理PRO','产品图片配置','承运商','系统日志','业务模板','技能组管理','zencart配置','中国邮政配置','邮件内容配置','打印标签模板','销售平台管理','支付费设置','商品类别设置','登录费用设置','交易费用设置','系统说明');

update DB_MENUFUNC set type=5 where funname in('供应商管理','买家记录','单商品订单','智能物流选择','在线产品维护','商品下线','报表管理','统计报表','利润区间查询','单商品报表','SKU销量报表','商品分类销售','打印标签模板','技能组管理','业务模板','承运商','供应商管理','项目进度报表','库存周转率报表','支付费设置','商品类别设置','登录费用设置','交易费用设置','中国邮政配置','基本功能','买家管理');

update DB_MENUFUNC set url='#',ifwinopen=0 where funid='700';

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('701', '待回复', '待回复', '#', 0, 0, '700', 1, 3, '#FFFFFF', null, null, null, 2);

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('711', '未分配消息', '未分配消息', '/eshop/message.do?method=publiclist', 0, 3, '701', 1, 3, '#FFFFFF', null, null, null, null);

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('712', '待处理消息', '待处理消息', '/eshop/message.do?method=loginmessage', 0, 3, '701', 2, 3, '#FFFFFF', null, null, null, null);

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('713', '所有消息', '所有消息', '/eshop/message.do?method=list', 0, 3, '701', 3, 3, '#FFFFFF', null, null, null, null);

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('702', '消息配置', '消息配置', '#', 0, 0, '700', 2, 3, '#FFFFFF', null, null, null, 2);

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values('720', '配置参与工号', '配置参与工号', '/eshop/sysadmin.do?method=setMessageoper', 0, 3, '702', 0, 3, '#FFFFFF', null, null, null, null);

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values('721', '设置自定义状态', '设置自定义状态', '/eshop/message.do?method=typelist', 0, 3, '702', 1, 3, '#FFFFFF', null, null, null, null);

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values('722', '设置快捷短语', '设置快捷短语', '/eshop/smsprompt.do?method=list', 0, 3, '702', 2, 3, '#FFFFFF', null, null, null, null);

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values('723', '删除消息', '删除消息', '/eshop/manager/crm/message/delete.jsp', 0, 3, '702', 3, 3, '#FFFFFF', null, null, null, null);

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values('724', '内部短消息', '内部短消息', '/eshop/bullet.do?method=getPostMessage', 0, 3, '702', 4, 3, '#FFFFFF', null, null, null, null);

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values('725', '设置店铺分配', '设置店铺分配', '/eshop/message.do?method=assignByShop', 0, 3, '702', 5, 3, '#FFFFFF', null, null, null, null);

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values('726', '设置商品目录分配', '设置商品目录分配', '/eshop/message.do?method=assignByCategory', 0, 3, '702', 6, 3, '#FFFFFF', null, null, null, null);

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values('727', '按买家ID首字母分配', '按买家ID首字母分配', '/eshop/ebaymessageconfig.do?method=list', 0, 3, '702', 7, 3, '#FFFFFF', null, null, null, null);

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values('728', '订单通知消息', '订单通知消息', '/eshop/orderconfig.do?method=list', 0, 3, '702', 8, 3, '#FFFFFF', null, null, null, null);

update DB_MENUFUNC set parentid='702',sort=9 where funname in('Message分类配置');

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values ('703', 'CRM报表', 'CRM报表', '#', 0, 0, '700', 3, 3, '#FFFFFF', null, null, null, 2);

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values('730', '消息监控报表', '消息监控报表', '/eshop/message.do?method=statMessage', 0, 3, '703', 0, 3, '#FFFFFF', null, null, null, null);

update db_menufunc set type='5' where funid in('112','19');

update DB_MENUFUNC set reserve2='menu_icon02 png_bg' where funname in('采购调拨');

insert into db_opermenu select 'admin',funid from db_menufunc  where funid not in (select menuid from db_opermenu where oper='admin');

update db_menufunc set parentid='901',ifparent=3 where parentid='1' and funid!='1';

update db_menufunc set reserve5=2 where funid in('201','202','203','204','441','442','443','661','662','663','801','802','901','902','903','701','702','703');

insert into db_opermenu (OPER,menuid) ( select oper,'201' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'202' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'203' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'204' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'441' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'442' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'443' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'661' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'662' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'663' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'801' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'802' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'900' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'901' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'902' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'903' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'701' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'711' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'712' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'713' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'702' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'720' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'721' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'722' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'723' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'724' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'725' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'726' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'727' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'728' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'703' from db_sysadmin  );
insert into db_opermenu (OPER,menuid) ( select oper,'730' from db_sysadmin  );

insert into db_opermenu (OPER,menuid) ( select admin,funid from db_menufunc  where funid not in (select menuid from db_opermenu where oper='admin'));




---------------------sl 20130105---------------------------------
alter table DB_MANUFACTURE add takeoper1 varchar2(400);
alter table DB_MANUFACTURE add takeoper2 varchar2(400);




------------------------20130105 hj  -----------------------
alter table DB_EBAYORDERINFO modify ERRORINFO varchar2(4000);





﻿------------------------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);



------------------------20121211 hj---------------------------------------
alter table db_product add MAINSKU VARCHAR2(50);
alter table db_productlog add MAINSKU VARCHAR2(50);
update db_order set storageid = ','||storageid||',' where storageid is not null and storageid not like ',%'


------------------------20121211 hp 销售流程---------------------------------------

CREATE TABLE "DB_PROTOCOL" ("SEQUENCEID" VARCHAR2(50 
    byte) NOT NULL, "SKU" VARCHAR2(50 byte), "NAME" VARCHAR2(1000
    byte), "URGENT" VARCHAR2(100 byte), "CREATEOPER" VARCHAR2(50 
    byte), "EXECUTOR" VARCHAR2(50 byte), "STATUS" VARCHAR2(100 
    byte), "CREATETIME" DATE, "STARTTIME" DATE, "BACKTIME" DATE, 
    "ENDTIME" DATE, "TITLE" VARCHAR2(1000 byte), "DESCR" 
    VARCHAR2(2000 byte), "PICTURE1" VARCHAR2(100 byte), 
    "PICTURE2" VARCHAR2(100 byte), "PICTURE3" VARCHAR2(100 byte),
    "BACKREASON" VARCHAR2(1000 byte), "NOTE" VARCHAR2(2000 byte),
    "RESERVE1" VARCHAR2(500 byte), "RESERVE2" VARCHAR2(500 byte),
    "RESERVE3" VARCHAR2(500 byte), "RESERVE4" VARCHAR2(500 byte),
    "RESERVE5" VARCHAR2(500 byte), "RESERVE6" NUMBER(10), 
    "RESERVE7" NUMBER(10), "RESERVE8" NUMBER(10, 4), "RESERVE9" 
    NUMBER(10, 4), "RESERVE10" DATE, "OPERTIME" DATE, "RESERVE11"
    DATE, "RESERVE12" DATE, "RESERVE13" DATE, "FLAG" VARCHAR2(50 
    byte), "CHECKOPER" VARCHAR2(50 byte), "CHECKNOTREASON" 
    VARCHAR2(2000 byte), "CHECKTIME" DATE, "REPEATTIME" DATE, 
    "OPER" VARCHAR2(50 byte), 
    CONSTRAINT "PK_SID_DB_PROTOCOL" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 


------------------------20121211ly 解决报表selloper问题,必须先建立字段---------------------------------------
declare
   v_selloper varchar2(50);
   cursor c_rec is select distinct oper3 from db_product where oper3 is not null;
begin
     open c_rec;
     loop
      <<c_rec_mark>>
          v_selloper :='';
          fetch c_rec into v_selloper;
          exit when c_rec%notfound;
          if v_selloper is not null then
             update db_sell set selloper=v_selloper where productid in(select sequenceid from db_product where oper3=v_selloper);
             update db_selltostat set selloper=v_selloper where productid in(select sequenceid from db_product where oper3=v_selloper);
             commit;
          end if;
     end loop;
     commit;
     close c_rec;
end;
------------------------20121211ly 栏位图片调整---------------------------------------
update DB_MENUFUNC set reserve2='menu_icon01 png_bg' where funname='订单管理';
update DB_MENUFUNC set reserve2='menu_icon13 png_bg' where funname='产品管理';
update DB_MENUFUNC set reserve2='menu_icon06 png_bg' where funname='采购库存';
update DB_MENUFUNC set reserve2='menu_icon05 png_bg' where funname='消息管理';
update DB_MENUFUNC set reserve2='menu_icon09 png_bg' where funname='项目管理';
update DB_MENUFUNC set reserve2='menu_icon04 png_bg' where funname='收入支出管理';
update DB_MENUFUNC set reserve2='menu_icon03 png_bg' where funname='统计报表';
update DB_MENUFUNC set reserve2='menu_icon02 png_bg' where funname='买家管理';
update DB_MENUFUNC set reserve2='menu_icon07 png_bg' where funname='系统管理'; 
update DB_MENUFUNC set reserve2='menu_icon10 png_bg' where funname='基本功能';
------------------------20121206ly 关闭旧数据源报表---------------------------------------
update DB_MENUFUNC set type='5' where funname='热销店铺排名'--STAT_HOTSHOP_DAILY
update DB_MENUFUNC set type='5' where funname='按国家销售额报表'--STAT_COUNTRY_DAILY
update DB_MENUFUNC set type='5' where funname='单商品报表'--stat_product_daily
update DB_MENUFUNC set type='5' where funname='商品分类销售'--STAT_PRODUCT_DAILY          
update DB_MENUFUNC set type='5' where funname='利润区间查询'--STAT_PRODUCT_DAILY
update DB_MENUFUNC set type='5' where funname='货币金额报表'--STAT_MONEY_DAILY
update DB_MENUFUNC set type='5' where funname='人员营业报表'--STAT_PRODUCT_DAILY
update DB_MENUFUNC set type='5' where funname='库存周转率报表'--DB_PRODUCT_DAILY

------------------------20121206ly db_menufunc 外框替换---------------------------------------
turncate table db_menufunc

ORACLEDUMP	|FUNID	FUNNAME	FUNDESC	URL	IFWINOPEN	IFPARENT	PARENTID	SORT	TYPE	RESERVE1	RESERVE2	RESERVE3	RESERVE4	RESERVE5
"304","手动入库","手动入库","/eshop/purchase.do?method=handstorage","0","3","6","5","3","#FFFFFF","","","",""
"71","Paypal","Paypal","/eshop/spaypal.do?method=list","0","3","3","3","3","#FF6633","","","",""
"151","系统说明","系统说明","/eshop/other.do?method=systemHelp","0","3","3","34","3","#AA5544","","","",""
"152","订单过渡","订单过渡","/eshop/order.do?method=orderTransition","0","3","2","12","3","#99AB32","","","",""
"72","Paypal对账","Paypal对账","/eshop/paypal.do?method=list","0","3","2","2","3","#FFFFFF","","","",""
"206","订单延迟报表","订单延迟报表","/eshop/report.do?method=reportOrderDefer","0","3","7","9","3","#FF6633","","","",""
"154","SKU销量报表","SKU销量报表","/eshop/report.do?method=reportskusales","0","3","7","12","3","#99AB32","","","",""
"401","供应商管理PRO","供应商管理PRO","/eshop/manufacture.do?method=listmain","0","3","4","10","3","#FF6633","","","",""
"120","滞销商品报表","滞销商品报表","/eshop/report.do?method=reportTosavesearch","0","3","7","13","3","#99AB32","","","",""
"121","项目进度报表","项目进度报表","/eshop/report.do?method=createRealGanttChart","0","3","7","27","3","#3399CC","","","",""
"61","中国邮政配置","中国邮政配置","/eshop/chinaexpress.do?method=list","0","3","3","23","3","#99AB32","","","",""
"62","打印标签模板","打印标签模板","/eshop/lable.do?method=list","0","3","3","26","3","#99AB32","","","",""
"63","采购金额管理","采购金额管理","/eshop/purchase.do?method=listMoney","0","3","6","5","5","#99AB32","","","",""
"123","盘点查询","盘点查询","/eshop/report.do?method=searchstock","0","3","7","26","3","#3399CC","","","",""
"124","商品质量反馈","商品质量反馈","/eshop/other.do?method=AddBackInfo","0","3","4","10","3","#FF6633","","","",""
"127","商品分类销售","商品分类销售","/eshop/report.do?method=searchcate","0","3","7","15","3","#99AB32","","","",""
"64","销售平台管理","销售平台管理","/eshop/platform.do?method=list","0","3","3","27","3","#99AB32","","","",""
"65","买家记录","买家记录","/eshop/order.do?method=findCustomerDetail","0","3","2","10","5","#99AB32","","","",""
"66","智能生成采购单","智能生成采购单","/eshop/purchase.do?method=automaticProducePurchase","0","3","6","1","3","#FFFFFF","","","",""
"67","包装验货","智能生成采购单","/eshop/manager/order/checkorder.jsp","0","3","2","19","3","#AA5544","","","",""
"133","产品批量修改","产品批量修改","/eshop/manager/other/inputstock.jsp","0","3","4","2","3","#FFFFFF","","","",""
"40","所有订单","所有订单","/eshop/order.do?method=ordermanager","0","3","2","1","3","#FFFFFF","","","",""
"41","今日订单","今日订单","/eshop/order.do?method=ordermanager&beforeday=0","0","3","2","3","3","#FF6633","","","",""
"42","新订单","新订单","/eshop/order.do?method=ordermanager&status=0","0","3","2","4","3","#FF6633","","","",""
"43","已支付","已支付","/eshop/order.do?method=ordermanager&status=1","0","3","2","5","3","#FF6633","","","",""
"136","配货中","配货中","/eshop/order.do?method=ordermanager&status=2","0","3","2","6","3","#FF6633","","","",""
"137","已发货","已发货","/eshop/order.do?method=ordermanager&status=3","0","3","2","7","3","#FF6633","","","",""
"138","已完成","已完成","/eshop/order.do?method=ordermanager&status=4","0","3","2","8","3","#FF6633","","","",""
"139","作废订单","作废订单","/eshop/order.do?method=ordermanager&status=5","0","3","2","9","3","#FF6633","","","",""
"47","可合并的订单","智能推算出可以合并的订单合并","/eshop/manager/order/UniteOrderManager.jsp","0","3","2","14","3","#99AB32","","","",""
"59","智能物流选择","智能物流选择","/eshop/order.do?method=autoExpressOrder&flag=1","0","3","2","15","3","#99AB32","","","",""
"122","单商品订单","单商品订单","/eshop/manager/other/oneorder.jsp","0","3","2","13","5","#99AB32","","","",""
"130","E邮宝订单","E邮宝订单","/eshop/eub.do?method=searcheub&status=0","0","3","2","17","3","#AA5544","","","",""
"45","过期订单归档","过期订单归档","/eshop/order.do?method=historyorder","0","3","2","16","3","#99AB32","","","",""
"46","查询历史订单","查询历史订单","/eshop/manager/order/historyorder.jsp","0","3","2","18","3","#AA5544","","","",""
"44","上传EBAY订单","上传EBAY订单","/eshop/ebay.do?method=uploadfile&flag=1","0","3","2","23","3","#3399CC","","","",""
"131","上传亚马逊订单","上传亚马逊订单","/eshop/other.do?method=uploadfile&flag=2","0","3","2","24","3","#3399CC","","","",""
"134","上传速卖通订单","上传速卖通订单","/eshop/other.do?method=uploadfile&flag=4","0","3","2","25","3","#3399CC","","","",""
"132","上传通用订单","上传通用订单","/eshop/other.do?method=uploadfile&flag=3","0","3","2","26","3","#3399CC","","","",""
"69","国家配置","国家配置","/eshop/chinaexpress.do?method=listCountry","0","3","3","7","3","#FF6633","","","",""
"70","承运商","承运商","/eshop/company.do?method=list","0","3","3","14","3","#99AB32","","","",""
"145","人员营业报表","人员营业报表","/eshop/report.do?method=operreport","0","3","7","28","3","#3399CC","","","",""
"146","订单搜索脚本","订单搜索脚本","/eshop/order.do?method=ordersearchlist&flag=2","0","3","2","21","3","#AA5544","","","",""
"148","退款管理","退款管理","/eshop/refund.do?method=list","0","3","2","11","3","#99AB32","","","",""
"143","警戒时间配置","警戒时间配置","/eshop/other.do?method=productalert","0","3","3","24","3","#99AB32","","","",""
"142","zencart配置","zencart配置","/eshop/other.do?method=mysql","0","3","3","20","3","#99AB32","","","",""
"144","下载zencart订单","下载zencart订单","/eshop/other.do?method=downloadzencar1","0","3","2","27","3","#3399CC","","","",""
"128","商品反馈报表","商品反馈报表","/eshop/report.do?method=Productbackinfo","0","3","7","14","3","#99AB32","","","",""
"129","库存周转率报表 ","库存周转率报表","/eshop/report.do?method=saverate","0","3","7","29","3","#3399CC","","","",""
"126","PayPal金额报表","PayPal金额报表","/eshop/order.do?method=paypalMoney","0","3","7","30","3","#3399CC","","","",""
"125","商品空值查询","商品空值查询","/eshop/other.do?method=productByNull","0","3","4","11","3","#FF6633","","","",""
"54","异常采购单","异常采购单","/eshop/purchase.do?method=questionlist&resulttype=no","0","3","6","4","3","#99AB32","","","",""
"39","Ebay订单提取规则","Ebay订单提取规则","/eshop/ebay.do?method=ebayapilist","0","3","3","2","3","#FFFFFF","","","",""
"38","店铺账号管理","店铺账号管理","/eshop/shop.do?method=list","0","3","3","1","3","#FFFFFF","","","",""
"100","日销售报表","日销售报表","/eshop/report.do?method=reportDay","0","3","7","1","3","#FFFFFF","","","",""
"141","邮件内容配置","邮件内容配置","/eshop/other.do?method=maillist","0","3","3","25","3","#99AB32","","","",""
"68","订单搜索脚本pro","订单搜索脚本pro","/eshop/order.do?method=ordersearchlist&flag=1","0","3","2","22","3","#AA5544","","","",""
"57","各店铺在线商品","各店铺在线商品","/eshop/product.do?method=onlinelist","0","3","4","15","3","#99AB32","","","",""
"58","在线商品对比","在线商品对比","/eshop/product.do?method=compareonline","0","3","4","16","3","#99AB32","","","",""
"9","收入支出管理","收入支出管理","/eshop/expense.do?method=loginexpense","1","1","9","5","3","#FFFFFF","menu_icon01 png_bg","","","2"
"19","买家管理","买家管理","/eshop/customer.do?method=logincustomer","1","1","19","6","3","#FFFFFF","menu_icon02 png_bg","","","2"
"36","采购管理","采购管理","/eshop/purchase.do?method=findpurchaselist","0","3","6","2","3","#FF6633","","","",""
"2","订单管理","订单管理","#","0","1","2","1","3","#FFFFFF","menu_icon03 png_bg","","","2"
"4","产品管理","产品管理","#","0","1","4","2","3","#FFFFFF","menu_icon04 png_bg","","","2"
"6","采购库存","采购库存","#","0","1","6","3","3","#FFFFFF","menu_icon05 png_bg","","","2"
"35","订单自定义类型","订单自定义类型","/eshop/ordertype.do?method=list","0","3","3","29","3","#99AB32","","","",""
"32","产品列表","产品列表","/eshop/product.do?method=list","0","3","4","1","3","#FFFFFF","","","",""
"21","员工代表管理","客服代表管理","/eshop/sysadmin.do?method=sysadminList","0","3","3","19","3","#99AB32","","","",""
"20","组别管理","组别管理","/eshop/sysadmin.do?method=classList","0","3","3","15","3","#99AB32","","","",""
"5","项目管理","业务管理","/eshop/project.do?method=loginproject","1","1","5","4","3","#FFFFFF","menu_icon06 png_bg","","","2"
"7","统计报表","统计报表","#","0","1","7","7","3","#FFFFFF","menu_icon07 png_bg","","","2"
"8","运营管理","运营管理","#","0","1","8","5","5","#FFFFFF","menu_icon08 png_bg","","","2"
"16","查看公告","查看公告","/eshop/bullet.do?method=getbullet","0","3","1","6","3","#FFFFFF","","","",""
"1","基本功能","基本功能","#","0","1","1","12","3","#FFFFFF","menu_icon09 png_bg","","","2"
"3","系统管理","系统管理","#","0","1","3","11","3","#FFFFFF","menu_icon10 png_bg","","","2"
"511","按地区销售额报表","按地区销售额报表","/eshop/report.do?method=reportByProvince","0","3","7","5","3","#FFFFFF","","","",""
"412","库存报表","库存报表","/eshop/report.do?method=reportSavenum","0","3","7","23","3","#3399CC","","","",""
"706","采购频率查询","采购频率查询","/eshop/purchase.do?method=purchaseRate","0","3","6","6","3","#99AB32","","","",""
"422","退款报表","退款报表","/eshop/report.do?method=reportRefundPaypal","0","3","7","31","3","#3399CC","","","",""
"14","系统日志","系统日志","/eshop/sysadmin.do?method=syslogList","0","3","3","16","3","#99AB32","","","",""
"321","商品下线","商品下线","/eshop/product.do?method=findproductonlinelist","0","3","4","22","3","#FFFFFF","","","",""
"436","商品修改日志查询","商品修改日志查询","/eshop/product.do?method=loglist","0","3","4","16","3","#FFFFFF","","","",""
"305","商品网名管理","商品网名管理","/eshop/product.do?method=titlelist","0","3","4","12","3","#99AB32","","","",""
"306","增加商品网名","增加商品网名","/eshop/product.do?method=addtitle","0","3","4","13","3","#99AB32","","","",""
"10","修改密码","修改密码","/eshop/manager/sysadmin/changepwd.jsp","0","3","1","1","3","#FFFFFF","","","",""
"11","修改个人资料","修改个人资料","/eshop/sysadmin.do?method=editinfo","0","3","1","2","3","#FFFFFF","","","",""
"12","更换皮肤","更换皮肤","/eshop/manager/sysadmin/changeskins.jsp","0","3","1","3","3","#FFFFFF","","","",""
"13","内部短消息","内部短消息","/eshop/bullet.do?method=getPostMessage","0","3","1","4","3","#FFFFFF","","","",""
"15","公告管理","公告管理","/eshop/bullet.do?method=list","0","3","1","13","3","#FFFFFF","","","",""
"22","技能组管理","技能组管理","/eshop/sysadmin.do?method=grouptypeList","0","3","3","18","3","#99AB32","","","",""
"23","业务模板","业务模板","/eshop/moban.do?method=list","0","3","3","17","3","#99AB32","","","",""
"24","商品目录管理","商品目录管理","/eshop/category.do?method=list","0","3","3","11","3","#FF6633","","","",""
"25","品牌管理","品牌管理","/eshop/brand.do?method=list","0","3","3","4","3","#FF6633","","","",""
"26","仓位设置","仓位设置","/eshop/location.do?method=list","0","3","3","6","3","#FF6633","","","",""
"27","收支类型设置","收支类型设置","/eshop/expensetype.do?method=list","0","3","3","21","3","#99AB32","","","",""
"28","供应商管理","供应商管理","/eshop/manufacture.do?method=list","0","3","3","9","3","#FF6633","","","",""
"29","货运方式设置","货运方式设置","/eshop/expresstype.do?method=list","0","3","3","22","3","#99AB32","","","",""
"30","仓库设置","仓库设置","/eshop/storage.do?method=list","0","3","3","5","3","#FF6633","","","",""
"31","汇率设置","汇率设置","/eshop/moneyrate.do?method=list","0","3","3","8","3","#FF6633","","","",""
"33","新增单个产品","新增单个产品","/eshop/product.do?method=add","0","3","4","3","3","#FFFFFF","","","",""
"34","批量增加产品","批量增加产品","/eshop/product.do?method=addBatch","0","3","4","4","3","#FFFFFF","","","",""
"52","入库管理","入库管理","/eshop/purchase.do?method=findAll","0","3","6","3","3","#FF6633","","","",""
"50","论坛","论坛","/eshop/forum.do?method=loginforum","1","1","50","10","3","#FFFFFF","menu_icon11 png_bg","","","2"
"51","工作任务","工作任务","/eshop/task.do?method=logintask","1","1","51","9","3","#FFFFFF","menu_icon12 png_bg","","","2"
"37","业务工作流设置","业务工作流设置","/eshop/task.do?method=tasktypelist","0","3","3","28","3","#99AB32","","","",""
"55","产品图片配置","产品图片配置","/eshop/imgconfig.do?method=list","0","3","3","12","3","#FF6633","","","",""
"53","盘点库存","盘点库存","/eshop/manager/purchase/inputstock.jsp","0","3","4","6","3","#FF6633","","","",""
"56","绑定商品","绑定商品","/eshop/product.do?method=bindproductlist","0","3","4","7","3","#FF6633","","","",""
"60","包材类型设置","包材类型设置","/eshop/packaging.do?method=list","0","3","3","13","3","#FF6633","","","",""
"101","月销售额报表","月销售额报表","/eshop/report.do?method=reportMonth","0","3","7","2","3","#FFFFFF","","","",""
"102","财务支出报表","财务支出报表","/eshop/report.do?method=reportExpense","0","3","7","20","3","#AA5544","","","",""
"103","供应商营业额报表","供应商营业额报表","/eshop/report.do?method=reportManufacture","0","3","7","21","3","#AA5544","","","",""
"104","订单情况表","订单情况表","/eshop/report.do?method=reportOrder","0","3","7","6","3","#FF6633","","","",""
"105","订单处理日志表","订单处理日志表","/eshop/report.do?method=reportOrderlog","0","3","7","10","3","#FF6633","","","",""
"106","热销商品排名","热销商品排名","/eshop/report.do?method=reportHotProduct","0","3","7","3","3","#FFFFFF","","","",""
"107","热销店铺排名","热销店铺排名","/eshop/report.do?method=reportHotShop","0","3","7","4","3","#FFFFFF","","","",""
"108","项目商品销售监控","项目商品销售监控","/eshop/report.do?method=reportProjectOrder","0","3","7","17","3","#99AB32","","","",""
"109","货币金额报表","货币金额报表","/eshop/report.do?method=reportByMoney","0","3","7","19","3","#AA5544","","","",""
"110","单商品销售查询","单商品销售查询","/eshop/report.do?method=reportByOnePro","0","3","7","16","3","#99AB32","","","",""
"111","按国家销售额报表","按国家销售额报表","/eshop/report.do?method=reportByCountry","0","3","7","5","3","#FFFFFF","","","",""
"116","订单价格区间","订单价格区间","/eshop/report.do?method=reportByorderRang","0","3","7","8","3","#FF6633","","","",""
"117","客户排名","客户排名","/eshop/report.do?method=reportByCustomer","0","3","7","22","3","#3399CC","","","",""
"112","库存报表","库存报表","/eshop/report.do?method=reportStock","0","3","7","23","3","#3399CC","","","",""
"113","采购报表","采购报表","/eshop/report.do?method=reportPurchase","0","3","7","24","3","#3399CC","","","",""
"114","物流统计","物流统计","/eshop/report.do?method=expresstypeStatistik","0","3","7","25","3","#3399CC","","","",""
"115","单商品报表","单商品报表","/eshop/report.do?method=searchProduct","0","3","7","11","3","#99AB32","","","",""
"118","订单购买量","订单购买量","/eshop/report.do?method=reportByOrder","0","3","7","7","3","#FF6633","","","",""
"119","利润区间查询","利润区间查询","/eshop/report.do?method=reportByProduct","0","3","7","18","3","#AA5544","","","",""
"251","包装验货pro","包装验货pro","/eshop/manager/order/checkorderPro.jsp","0","3","2","20","3","#AA5544","","","",""
"218","供应商管理PRO","供应商管理PRO","/eshop/manufacture.do?method=listmain","0","3","3","10","3","#FF6633","","","",""
"301","登录费用设置","登录费用设置","/eshop/loginfree.do?method=list","0","3","3","32","3","#3399CC","","","",""
"250","产品导出","产品导出","/eshop/other.do?method=productExport","0","3","4","5","3","#FFFFFF","","","",""
"302","交易费用设置","交易费用设置","/eshop/tradefree.do?method=list","0","3","3","33","3","#3399CC","","","",""
"303","计算价格","计算价格","/eshop/calculate.do?method=list","0","3","4","8","3","#FF6633","","","",""
"207","支付费设置","支付费设置","/eshop/paymentset.do?method=list","0","3","3","30","3","#3399CC","","","",""
"208","商品类别设置","商品类别设置","/eshop/proTypeSet.do?method=list","0","3","3","31","3","#3399CC","","","",""
"307","商品网名管理","商品网名管理","/eshop/product.do?method=titlelist","0","3","4","12","5","#99AB32","","","",""
"308","增加商品网名","增加商品网名","/eshop/product.do?method=addtitle","0","3","4","13","5","#99AB32","","","",""
"320","在线产品维护","在线产品维护","/eshop/product.do?method=productonlinelist","0","3","4","14","3","#99AB32","","","",""
"555","商品质量反馈pro","商品质量反馈pro","/eshop/other.do?method=feedbacklist","0","3","4","10","3","#FF6633","","","",""
"420","日收入报表","日收入报表","/eshop/report.do?method=immediatereportDay","0","3","7","1","3","#FFFFFF","","","",""
"700","消息管理","消息管理","/eshop/message.do?method=loginmessage","1","1","700","3","3","#FFFFFF","menu_icon13 png_bg","","","2"
"421","订单修改日志查询","订单修改日志查询","/eshop/order.do?method=loglistfull","0","3","2","400","3","#FFFFFF","","","",""

------------------------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);

------------------------20121203hj---------------------------------------
alter table db_storage modify FILED3 varchar2(4000);
alter table db_storagelog modify FILED3 varchar2(4000);
------------------------20121203lyp---------------------------------------
alter table DB_SHOP add EBAYFEEMONEYRATE varchar2(400);
------------------------20121129 hp---------------------------------------
alter table db_order modify LOCATIONID varchar2(500);

------------------------20121128 xb---------------------------------------
create table DB_BANPRODUCT  (
   SID                  VARCHAR2(50)                    not null,
   PRODUCTID            VARCHAR2(100),
   SHOPID               VARCHAR2(100),
   COPERID              VARCHAR2(50),
   OPER                 VARCHAR2(400),
   OPERTIME             DATE,
   FILED1               VARCHAR2(400),
   FILED2               VARCHAR2(400),
   FILED3               VARCHAR2(400),
   FILED4               VARCHAR2(400),
   FILED5               VARCHAR2(4000),
   FILED6               VARCHAR2(4000),
   FILED7               NUMBER(8,2),
   FILED8               NUMBER(8,2),
   FILED9               NUMBER(8,2),
   OPENFLAG             VARCHAR2(10),
   constraint PK_DB_BANPRODUCT primary key (SID)
)
pctfree 10
initrans 1
maxtrans 255
storage
(
    initial 64K
    minextents 1
    maxextents unlimited
)
tablespace ZHRGPT
logging
noparallel;

comment on column DB_BANPRODUCT.OPENFLAG is
'0表示关闭
1表示开通';

------------------------20121128 xb---------------------------------------
create table DB_BANPRODUCT  (
   SID                  VARCHAR2(50)                    not null,
   NAME                 VARCHAR2(100),
   DESCR                VARCHAR2(4000),
   COPERID              VARCHAR2(50),
   OPER                 VARCHAR2(400),
   OPERTIME             DATE,
   FILED1               VARCHAR2(400),
   FILED2               VARCHAR2(400),
   FILED3               VARCHAR2(400),
   FILED4               VARCHAR2(400),
   FILED5               VARCHAR2(4000),
   FILED6               VARCHAR2(4000),
   FILED7               NUMBER(8,2),
   FILED8               NUMBER(8,2),
   FILED9               NUMBER(8,2),
   OPENFLAG             VARCHAR2(10),
   constraint PK_DB_BANPRODUCT primary key (SID)
)
pctfree 10
initrans 1
maxtrans 255
storage
(
    initial 64K
    minextents 1
    maxextents unlimited
)
tablespace ZHRGPT
logging
noparallel;

comment on column DB_BANPRODUCT.OPENFLAG is
'0表示关闭
1表示开通';

-------------------------2012-11-26 lxd --------------------------
alter table DB_MANUFACTURE add SKYPE VARCHAR2(200);
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;

-------------------------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);
-------------------------20121121 ly--------------------------
412	库存报表	库存报表	/eshop/report.do?method=reportSavenum	0	0	7	23	3	#3399CC				

-------------------------20121120 hj--------------------------
alter table db_product modify STOCKPRICE  number(10,4);    
alter table db_product modify COSTPRICE   number(10,4);    
alter table db_product modify SELLPRICE   number(10,4);    
alter table db_product modify BATCHPRICE1 number(10,4);    
alter table db_product modify BATCHPRICE2 number(10,4);    
alter table db_product modify BATCHPRICE3 number(10,4);    
alter table db_product modify BATCHPRICE4 number(10,4);    
alter table db_product modify PRICE1      number(10,4);    
alter table db_product modify PRICE2      number(10,4);    
alter table db_product modify PRICE3      number(10,4);    
alter table db_product modify PRICE4      number(10,4);    
alter table db_product modify PRICE5      number(10,4);    
alter table db_product modify PRICE6      number(10,4);    
alter table db_product modify PRICE7      number(10,4);    
alter table db_product modify PRICE8      number(10,4);    

alter table db_sell modify COSTPRICE            NUMBER(12,4);
alter table db_sell modify SELLPRICE            NUMBER(12,4);
alter table db_sell modify AMOUNT               NUMBER(12,4);
alter table db_sell modify ORIGINSELLPRICE      NUMBER(12,4);
alter table db_sell modify FINALVALUEFEE        NUMBER(10,4);
alter table db_sell modify ORIGINORDERMONEY     NUMBER(12,4);
alter table db_sell modify ORIGINEXPRESSMONEY   NUMBER(12,4);
alter table db_sell modify ORIGININSURANCE      NUMBER(12,4);
alter table db_sell modify ORIGINFINALVALUEFEE  NUMBER(12,4);
alter table db_sell modify ORDEREXPRESSASK      NUMBER(10,4);
alter table db_sell modify ORDEREXPRESSACTION   NUMBER(10,4);
alter table db_sell modify MONEYEXPRESSASK      NUMBER(10,4);
alter table db_sell modify MONEYEXPRESSACTION   NUMBER(10,4);
alter table db_sell modify TOTALMONEY           NUMBER(10,4);

alter table db_order modify MONEYASK                    number(10,4);
alter table db_order modify MONEYACTION                 number(10,4);
alter table db_order modify MONEYEXPRESSASK             number(10,4);
alter table db_order modify MONEYEXPRESSACTION          number(10,4);
alter table db_order modify MONEYORIGIN1                number(10,4);
alter table db_order modify MONEYORIGIN2                number(10,4);
alter table db_order modify MONEYORIGIN3                number(10,4);
alter table db_order modify MONEYORIGIN4                number(10,4);
alter table db_order modify INSURANCE                   number(10,4);
alter table db_order modify REFUNDRMB                   number(12,4);
alter table db_order modify REFUNDLOSS                  number(12,4);
alter table db_order modify REFUNDORIGINAL              number(12,4);
alter table db_order modify SLRESERVE5                  number(12,4);
alter table db_order modify SLRESERVE6                  number(12,4);
alter table db_order modify SLRESERVE7                  number(12,4);
alter table db_order modify XBRESERVE5                  number(12,4);
alter table db_order modify XBRESERVE6                  number(12,4);
alter table db_order modify QLRESERVE5                  number(12,4);
alter table db_order modify QLRESERVE6                  number(12,4);
alter table db_order modify ORIGINORDERMONEY            number(12,4);
alter table db_order modify ORIGINEXPRESSMONEY          number(12,4);
alter table db_order modify ORIGININSURANCE             number(12,4);
alter table db_order modify ORIGINFINALVALUEFEE         number(12,4);
alter table db_order modify ACTIONORDERWEIGHT           number(12,4);
alter table db_order modify FINALVALUEFEE               number(12,4);
alter table db_order modify ORDERMONEY                  number(12,4);

alter table db_purchase modify INPORTPRICE              NUMBER(12,4);
alter table db_purchase modify AMOUNT                   NUMBER(12,4);
alter table db_purchase modify ACTUALPRICE              NUMBER(12,4);
alter table db_purchase modify ACTUALAMOUNT             NUMBER(12,4);
alter table db_purchase modify DISCOUNT1                NUMBER(12,4);
alter table db_purchase modify DISCOUNT2                NUMBER(12,4);
alter table db_purchase modify DISCOUNT3                NUMBER(12,4);
alter table db_purchase modify DISCOUNT4                NUMBER(12,4);

alter table db_order_history modify MONEYASK             NUMBER(10,4);
alter table db_order_history modify MONEYACTION          NUMBER(10,4);
alter table db_order_history modify MONEYEXPRESSASK      NUMBER(10,4);
alter table db_order_history modify MONEYEXPRESSACTION   NUMBER(10,4);
alter table db_order_history modify MONEYORIGIN1         NUMBER(10,4);
alter table db_order_history modify MONEYORIGIN2         NUMBER(10,4);
alter table db_order_history modify MONEYORIGIN3         NUMBER(10,4);
alter table db_order_history modify MONEYORIGIN4         NUMBER(10,4);
alter table db_order_history modify INSURANCE            NUMBER(10,4);
alter table db_order_history modify REFUNDRMB            NUMBER(12,4);
alter table db_order_history modify REFUNDLOSS           NUMBER(12,4);
alter table db_order_history modify REFUNDORIGINAL       NUMBER(12,4);
alter table db_order_history modify SLRESERVE5           NUMBER(12,4);
alter table db_order_history modify SLRESERVE6           NUMBER(12,4);
alter table db_order_history modify SLRESERVE7           NUMBER(12,4);
alter table db_order_history modify XBRESERVE5           NUMBER(12,4);
alter table db_order_history modify XBRESERVE6           NUMBER(12,4);
alter table db_order_history modify QLRESERVE5           NUMBER(12,4);
alter table db_order_history modify QLRESERVE6           NUMBER(12,4);
alter table db_order_history modify ORIGINORDERMONEY     NUMBER(12,4);
alter table db_order_history modify ORIGINEXPRESSMONEY   NUMBER(12,4);
alter table db_order_history modify ORIGININSURANCE      NUMBER(12,4);
alter table db_order_history modify ORIGINFINALVALUEFEE  NUMBER(12,4);
alter table db_order_history modify ACTIONORDERWEIGHT    NUMBER(12,4);
alter table db_order_history modify FINALVALUEFEE        NUMBER(12,4);
alter table db_order_history modify ORDERMONEY           NUMBER(12,4);

alter table db_sell_history modify COSTPRICE            NUMBER(12,4);
alter table db_sell_history modify SELLPRICE            NUMBER(12,4);
alter table db_sell_history modify AMOUNT               NUMBER(12,4);
alter table db_sell_history modify ORIGINSELLPRICE      NUMBER(12,4);
alter table db_sell_history modify FINALVALUEFEE        NUMBER(10,4);
alter table db_sell_history modify ORIGINORDERMONEY     NUMBER(12,4);
alter table db_sell_history modify ORIGINEXPRESSMONEY   NUMBER(12,4);
alter table db_sell_history modify ORIGININSURANCE      NUMBER(12,4);
alter table db_sell_history modify ORIGINFINALVALUEFEE  NUMBER(12,4);
alter table db_sell_history modify ORDEREXPRESSASK      NUMBER(10,4);
alter table db_sell_history modify ORDEREXPRESSACTION   NUMBER(10,4);
alter table db_sell_history modify MONEYEXPRESSASK      NUMBER(10,4);
alter table db_sell_history modify MONEYEXPRESSACTION   NUMBER(10,4);
alter table db_sell_history modify TOTALMONEY           NUMBER(10,4);

alter table db_paypal modify FILED3   NUMBER(10,4);
alter table db_paypal modify FILED4   NUMBER(10,4);
alter table db_paypal modify FILED11  NUMBER(12,4);
alter table db_paypal modify FILED12  NUMBER(12,4);
alter table db_paypal modify FILED13  NUMBER(12,4);

alter table db_paypalconfig modify FILED8   NUMBER(10,4);
alter table db_paypalconfig modify FILED9   NUMBER(10,4);
alter table db_paypalconfig modify FILED10  NUMBER(10,4);

alter table db_paypal_temp modify FILED3   NUMBER(10,4);
alter table db_paypal_temp modify FILED4   NUMBER(10,4);
alter table db_paypal_temp modify FILED11  NUMBER(12,4);
alter table db_paypal_temp modify FILED12  NUMBER(12,4);
alter table db_paypal_temp modify FILED13  NUMBER(12,4);

alter table DB_PRICELIST modify SELLPRICE    NUMBER(10,4);
alter table DB_PRICELIST modify EXPRESSFEE   NUMBER(10,4);

alter table DB_PRODUCTLOG modify FILED8    NUMBER(10,4);
alter table DB_PRODUCTLOG modify FILED9    NUMBER(10,4);
alter table DB_PRODUCTLOG modify FILED10   NUMBER(10,4);

=========================20121119 hp ====================

alter table DB_REFUNDPAYPAL add reserve15 varchar2(2000);
alter table DB_REFUNDPAYPAL add reserve16 varchar2(2000);
alter table DB_REFUNDPAYPAL add reserve17 varchar2(2000);
alter table DB_REFUNDPAYPAL add reserve18 varchar2(2000);
alter table DB_REFUNDPAYPAL add reserve19 varchar2(2000);
alter table DB_REFUNDPAYPAL add reserve20 varchar2(2000);
alter table DB_REFUNDPAYPAL add reserve21 number(10,4);
alter table DB_REFUNDPAYPAL add reserve22 number(10,4);
alter table DB_REFUNDPAYPAL add reserve23 number(10,4);


alter table DB_REFUNDPAYPALLOG add reserve15 varchar2(2000);
alter table DB_REFUNDPAYPALLOG add reserve16 varchar2(2000);
alter table DB_REFUNDPAYPALLOG add reserve17 varchar2(2000);
alter table DB_REFUNDPAYPALLOG add reserve18 varchar2(2000);
alter table DB_REFUNDPAYPALLOG add reserve19 varchar2(2000);
alter table DB_REFUNDPAYPALLOG add reserve20 varchar2(2000);
alter table DB_REFUNDPAYPALLOG add reserve21 number(10,4);
alter table DB_REFUNDPAYPALLOG add reserve22 number(10,4);
alter table DB_REFUNDPAYPALLOG add reserve23 number(10,4);



-------------------------20121119 xb---------------------
alter table db_feedback add itemprice number(10,4);
alter table db_feedback add itempricetype varchar2(100);


=========================20121117 sl ====================
CREATE TABLE "DB_COUNTRY" ("COUNTRYID" VARCHAR2(20 byte)
    NOT NULL, "COUNTRYNAME" VARCHAR2(100 byte), "COUNTRYNAMEEN"
    VARCHAR2(100 byte), "RESERVE1" VARCHAR2(100 byte), "RESERVE2"
    VARCHAR2(100 byte), "RESERVE3" VARCHAR2(100 byte),
    CONSTRAINT "PK_COUNTRY_SID" PRIMARY KEY("COUNTRYID")
    USING INDEX
    TABLESPACE "ZHRGPT"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)

    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING;
    
    
  ============================数据===================
  ORACLEDUMP	|COUNTRYID	COUNTRYNAME	COUNTRYNAMEEN	RESERVE1	RESERVE2	RESERVE3
"BA","波黑","BOSNIA HERZEGOVINA","","",""
"CZ","捷克","CZECH REPUBLIC","","",""
"CRO","克罗地亚","THE REPUBLIC OF CROATIA","","",""
"HR","克罗地亚","THE REPUBLIC OF CROATIA","","",""
"GU","关岛","GUAM","","",""
"MDV","马尔代夫","MALDIVES","","",""
"MV","马尔代夫","MALDIVES","","",""
"ME","黑山共和国","MONTENEGRO","","",""
"MNE","黑山共和国","MONTENEGRO","","",""
"AA","美国","UNITED STATES","","",""
"AN","安的列斯","ANTILLES","","",""
"MK","马其顿","MACEDONIA","","",""
"NC","新喀里多尼亚","NEW CALEDONIA","","",""
"PF","波利尼西亚","French Polynesia","","",""
"PM","圣皮埃尔和密克隆","Saint Pierre and Miquelon","","",""
"PR","波多黎各","Puerto Rico","","",""
"RE","留尼旺岛","Reunion","","",""
"RS","塞尔维亚","Serbia","","",""
"SV","萨尔瓦多","El Salvador","","",""
"TT","特立尼达和多巴哥","Trinidad and Tobago","","",""
"AE","阿联酋","UNITEDEMIRATES","","",""
"AF","阿富汗","AFGHANISTAN","","",""
"AL","阿尔巴尼亚","ALBANIA","","",""
"AM","亚美尼亚","ARMENIA","","",""
"AO","安哥拉","ANGOLA","","",""
"AR","阿根廷","ARGENTINA","","",""
"AT","奥地利","AUSTRIA","","",""
"AU","澳大利亚","AUSTRALIA","","",""
"AZ","阿塞拜疆","AZERBAIJAN REPUBLIC","","",""
"BD","孟加拉","BANGLADESH","","",""
"BE","比利时","BELGIUM","","",""
"BF","布基纳法索","BURKINAFASO","","",""
"BG","保加利亚","BULGARIA","","",""
"BH","巴林","BAHREIN","","",""
"BI","布隆迪","BURUNDI","","",""
"BJ","贝宁","BENIN","","",""
"BL","巴勒斯坦","","","",""
"BN","文莱","BRUNEIDARUSSALAM","","",""
"BO","玻利维亚","BOLIVIA","","",""
"BR","巴西","BRAZIL","","",""
"BW","博茨瓦纳","BOTSWANA","","",""
"BY","白俄罗斯","BYELORUSSIA","","",""
"CA","加拿大","CANADA","","",""
"CF","中非","CENTRALAFRICA","","",""
"CG","刚果","CONGO","","",""
"CH","瑞士","SWITZERLAND","","",""
"CL","智利","CHILE","","",""
"CM","喀麦隆","CAMEROON","","",""
"CN","中国","CHINA","","",""
"CO","哥伦比亚","COLOMBIA","","",""
"CR","哥斯达黎加","COSTARICA","","",""
"CS","捷克","CZECHREPUBIC","","",""
"CU","古巴","CUBA","","",""
"CY","塞浦路斯","CYPRUS","","",""
"DE","德国","GERMANY","","",""
"DK","丹麦","DENMARK","","",""
"DO","多米尼加共和国","DOMINICANREPUBLIC","","",""
"DZ","阿尔及利亚","ALGERIA","","",""
"EC","厄瓜多尔","ECUADOR","","",""
"EE","爱沙尼亚","ESTONIA","","",""
"EG","埃及","EGYPT","","",""
"ES","西班牙","SPAIN","","",""
"ET","埃塞俄比亚","ETHIOPIA","","",""
"FI","芬兰","FINLAND","","",""
"FJ","斐济","FIJI","","",""
"FR","法国","FRANCE","","",""
"GA","加蓬","GABON","","",""
"GB","英国","UNITEDKINGDOM","","",""
"GD","格林纳达","GRENADA","","",""
"GE","格鲁吉亚","GEORGIA","","",""
"GH","加纳","GHANA","","",""
"GN","几内亚","GUINEA","","",""
"GR","希腊","GREECE","","",""
"GT","危地马拉","GUATEMALA","","",""
"HK","香港特别行政区","HONGKONG","","",""
"HN","洪都拉斯","HONDURAS","","",""
"HU","匈牙利","HUNGARY","","",""
"ID","印度尼西亚","INDONESIA","","",""
"IE","爱尔兰","IRELAND","","",""
"IL","以色列","ISRAEL","","",""
"IN","印度","INDIA","","",""
"IQ","伊拉克","IRAQ","","",""
"IR","伊朗","IRAN","","",""
"IS","冰岛","ICELAND","","",""
"IT","意大利","ITALY","","",""
"JM","牙买加","JAMAICA","","",""
"JO","约旦","JORDAN","","",""
"JP","日本","JAPAN","","",""
"KG","吉尔吉斯坦","KYRGYZSTAN","","",""
"KH","柬埔寨","KAMPUCHEA CAMBODIA","","",""
"KR","韩国","REPUBLICOFKOREA","","",""
"KT","科特迪瓦共和国","COTEO IVOIRE","","",""
"KW","科威特","KUWATI","","",""
"KZ","哈萨克","KAZAKHSTAN","","",""
"LA","老挝","LAOS","","",""
"LB","黎巴嫩","LEBANON","","",""
"LC","圣卢西亚","SAINTLUEIA","","",""
"LI","列支敦士登","LIECHTENSTEIN","","",""
"LK","斯里兰卡","SRILANKA","","",""
"LR","利比里亚","LIBERIA","","",""
"LT","立陶宛","LITHUANIA","","",""
"LU","卢森堡","LUXEMBOURG","","",""
"LV","拉脱维亚","LATVIA","","",""
"LY","利比亚","LIBYAN","","",""
"MA","摩洛哥","MOROCCO","","",""
"MC","摩纳哥","MONACO","","",""
"MD","摩尔多瓦","MOLDOVA REPUBLICOF","","",""
"MG","马达加斯加","MADAGASCAR","","",""
"ML","马里","MALI","","",""
"MM","缅甸","BURMA","","",""
"MN","蒙古","MONGOLIA","","",""
"MO","澳门地区","MACAU","","",""
"MT","马耳他","MALTA","","",""
"MU","毛里求斯","MAURITIUS","","",""
"MW","马拉维","MALAWI","","",""
"MX","墨西哥","MEXICO","","",""
"MY","马来西亚","MALAYSIA","","",""
"MZ","莫桑比克","MOZAMBIQUE","","",""
"NA","纳米比亚","NAMIBIA","","",""
"NE","尼日尔","NIGER","","",""
"NG","尼日利亚","NIGERIA","","",""
"NI","尼加拉瓜","NICARAGUA","","",""
"NL","荷兰","NETHERLANDS","","",""
"NO","挪威","NORWAY","","",""
"NP","尼泊尔","NEPAL","","",""
"NZ","新西兰","NEWZEALAND","","",""
"OM","阿曼","OMAN","","",""
"PA","巴拿马","PANAMA","","",""
"PE","秘鲁","PERU","","",""
"PG","巴布亚新几内亚","PAPUANEWGUINEA","","",""
"PH","菲律宾","PHILIPPINES","","",""
"PK","巴基斯坦","PAKISTAN","","",""
"PL","波兰","POLAND","","",""
"PT","葡萄牙","PORTUGAL","","",""
"PY","巴拉圭","PARAGUAY","","",""
"QA","卡塔尔","QATAR","","",""
"RO","罗马尼亚","ROMANIA","","",""
"RU","俄罗斯","RUSSIANFEDERATION","","",""
"SA","沙特阿拉伯","SAUDIARABIA","","",""
"SC","塞舌尔","SEYCHELLES","","",""
"SD","苏丹","SUDAN","","",""
"SE","瑞典","SWEDEN","","",""
"SG","新加坡","SINGAPORE","","",""
"SI","斯洛文尼亚","SLOVENIA","","",""
"SK","斯洛伐克","SLOVAKIA","","",""
"SM","圣马力诺","SANMARINO","","",""
"SN","塞内加尔","SENEGAL","","",""
"SO","索马里","SOMALIA","","",""
"SY","叙利亚","SYRIA","","",""
"SZ","斯威士兰","SWAZILAND","","",""
"TD","乍得","CHAD","","",""
"TG","多哥","TOGO","","",""
"TH","泰国","THAILAND","","",""
"TJ","塔吉克斯坦","TAJIKISTAN","","",""
"TM","土库曼","TURKMENISTAN","","",""
"TN","突尼斯","TUNISIA","","",""
"TR","土耳其","TURKEY","","",""
"TW","台湾省","TAIWAN","","",""
"TZ","坦桑尼亚","TANZANIA","","",""
"UA","乌克兰","UKRAINE","","",""
"UG","乌干达","UGANDA","","",""
"US","美国","UNITED STATES","","",""
"UY","乌拉圭","URUGUAY","","",""
"UZ","乌兹别克","UZBEKISTAN","","",""
"VC","圣文森特岛","SAINTVINCENT","","",""
"VE","委内瑞拉","VENEZUELA","","",""
"VN","越南","VIETNAM","","",""
"YE","也门","YEMEN","","",""
"YU","南斯拉夫联盟","YUGOSLAVIA","","",""
"ZA","南非","SOUTHAFRICA","","",""
"ZM","赞比亚","ZAMBIA","","",""
"ZR","扎伊尔","ZAIRE","","",""
"ZW","津巴布韦","ZIMBABWE","","",""
-------------------------20121117 xb--------------------------
create table DB_SAVENUM  (
   SKU                  VARCHAR2(50)                    not null,
   MONTH1               NUMBER(10),
   MONEY1               NUMBER(12,4),
   PURCHARSE1           NUMBER(10),
   PURCHARSEMONEY1      NUMBER(12,4),
   MONTH2               NUMBER(10),
   MONEY2               NUMBER(12,4),
   PURCHARSE2           NUMBER(10),
   PURCHARSEMONEY2      NUMBER(12,4),
   MONTH3               NUMBER(10),
   MONEY3               NUMBER(12,4),
   PURCHARSE3           NUMBER(10),
   PURCHARSEMONEY3      NUMBER(12,4),
   MONTH4               NUMBER(10),
   MONEY4               NUMBER(12,4),
   PURCHARSE4           NUMBER(10),
   PURCHARSEMONEY4      NUMBER(12,4),
   MONTH5               NUMBER(10),
   MONEY5               NUMBER(12,4),
   PURCHARSE5           NUMBER(10),
   PURCHARSEMONEY5      NUMBER(12,4),
   MONTH6               NUMBER(10),
   MONEY6               NUMBER(12,4),
   PURCHARSE6           NUMBER(10),
   PURCHARSEMONEY6      NUMBER(12,4),
   MONTH7               NUMBER(10),
   MONEY7               NUMBER(12,4),
   PURCHARSE7           NUMBER(10),
   PURCHARSEMONEY7      NUMBER(12,4),
   MONTH8               NUMBER(10),
   MONEY8               NUMBER(12,4),
   PURCHARSE8           NUMBER(10),
   PURCHARSEMONEY8      NUMBER(12,4),
   MONTH9               NUMBER(10),
   MONEY9               NUMBER(12,4),
   PURCHARSE9           NUMBER(10),
   PURCHARSEMONEY9      NUMBER(12,4),
   MONTH10              NUMBER(10),
   MONEY10              NUMBER(12,4),
   PURCHARSE10          NUMBER(10),
   PURCHARSEMONEY10     NUMBER(12,4),
   MONTH11              NUMBER(10),
   MONEY11              NUMBER(12,4),
   PURCHARSE11          NUMBER(10),
   PURCHARSEMONEY11     NUMBER(12,4),
   MONTH12              NUMBER(10),
   MONEY12              NUMBER(12,4),
   PURCHARSE12          NUMBER(10),
   PURCHARSEMONEY12     NUMBER(12,4),
   PURCHASEOPER         VARCHAR2(50),
   SELLOPER             VARCHAR2(50),
   CATEGORY             VARCHAR2(50),
   MANUFACTUREID        VARCHAR2(50),
   MANUFACTURE          VARCHAR2(50),
   STORAGEID            VARCHAR2(50),
   STORAGE              VARCHAR2(50),
   LOCATIONID           VARCHAR2(50),
   LOCATION             VARCHAR2(50),
   OPENFLAG             VARCHAR2(50),
   CHECKSTOCKOPER       VARCHAR2(50),
   RESERVE1             VARCHAR2(50),
   RESERVE2             VARCHAR2(50),
   RESERVE3             VARCHAR2(50),
   RESERVE4             VARCHAR2(50),
   RESERVE5             VARCHAR2(50),
   RESERVE6             VARCHAR2(50),
   RESERVE7             NUMBER(12,4),
   RESERVE8             NUMBER(12,4),
   RESERVE9             NUMBER(10),
   RESERVE10            NUMBER(10),
   constraint PK_DB_SAVENUM primary key (SKU)
)
pctfree 10
initrans 1
maxtrans 255
storage
(
    initial 64K
    minextents 1
    maxextents unlimited
)
tablespace ZHRGPT
logging
noparallel;

comment on table DB_SAVENUM is
'库存报表数据';


create table DB_SAVENUMMONTH  (
   MONTH                VARCHAR2(50)                    not null,
   FLAG1                VARCHAR2(10),
   FLAG2                VARCHAR2(10),
   FLAG3                VARCHAR2(10),
   FLAG4                VARCHAR2(10),
   FLAG5                VARCHAR2(10),
   FLAG6                VARCHAR2(10),
   FLAG7                VARCHAR2(10),
   FLAG8                VARCHAR2(10),
   FLAG9                VARCHAR2(10),
   FLAG10               VARCHAR2(10),
   FLAG11               VARCHAR2(10),
   FLAG12               VARCHAR2(10),
   FLAG13               VARCHAR2(10),
   FLAG14               VARCHAR2(10),
   FLAG15               VARCHAR2(10),
   constraint PK_DB_SAVENUMMONTH primary key (MONTH)
)
pctfree 10
initrans 1
maxtrans 255
storage
(
    initial 64K
    minextents 1
    maxextents unlimited
)
tablespace ZHRGPT
logging
noparallel;



-------------------------20121115 ly--------------------------
511	按地区销售额报表	按地区销售额报表	/eshop/report.do?method=reportByProvince	0	0	7	5	5	#FFFFFF				
-------------------------2012-11-5 hj------------------------------
alter table DB_EBAYORDERINFO modify CUSTOMERNAME varchar(1000);
alter table DB_EBAYORDERINFO modify CUSTOMERTYPE varchar(1000);
alter table DB_EBAYORDERINFO modify CUSTOMERTEL1 varchar(1000);
alter table DB_EBAYORDERINFO modify CUSTOMERTEL2 varchar(1000);
alter table DB_EBAYORDERINFO modify CUSTOMEREMAIL varchar(1000);
alter table DB_EBAYORDERINFO modify CUSTOMERCOUNTRY varchar(1000);
alter table DB_EBAYORDERINFO modify CUSTOMERPROVINCE varchar(1000);
alter table DB_EBAYORDERINFO modify CUSTOMERCITY varchar(1000);
alter table DB_EBAYORDERINFO modify CUSTOMERADDRESS varchar(3000);
alter table DB_EBAYORDERINFO modify CUSTOMERZIPCODE varchar(200);
alter table DB_EBAYORDERINFO modify CUSTOMERRESERVE1 varchar(3000);
alter table DB_EBAYORDERINFO modify CUSTOMERRESERVE2 varchar(3000);
alter table DB_EBAYORDERINFO modify CUSTOMERRESERVE3 varchar(3000);
alter table DB_EBAYORDERINFO modify CUSTOMERRESERVE4 varchar(3000);
alter table DB_EBAYORDERINFO modify SHOPTYPE varchar(200);
alter table DB_EBAYORDERINFO modify MONEYTYPE varchar(200);
alter table DB_EBAYORDERINFO modify OPER varchar(200);
alter table DB_EBAYORDERINFO modify SKU varchar(200);
alter table DB_EBAYORDERINFO modify PRODUCTNAME varchar(2000);
alter table DB_EBAYORDERINFO modify SHIPPINGSERVICE varchar(2000);
alter table DB_EBAYORDERINFO modify PAYPALEMAIL varchar(200);
alter table DB_EBAYORDERINFO modify ORDERRESERVE1 varchar(1000);
alter table DB_EBAYORDERINFO modify ORDERRESERVE2 varchar(1000);
alter table DB_EBAYORDERINFO modify ORDERRESERVE3 varchar(1000);
alter table DB_EBAYORDERINFO modify RESERVE1 varchar(1000);
alter table DB_EBAYORDERINFO modify RESERVE2 varchar(1000);
alter table DB_EBAYORDERINFO modify RESERVE3 varchar(1000);
alter table DB_EBAYORDERINFO modify RESERVE4 varchar(1000);
alter table DB_EBAYORDERINFO modify RESERVE5 varchar(1000);
alter table DB_EBAYORDERINFO modify ERRORINFO varchar(1000);


-------------------------2012-10-30 hj------------------------------
alter table db_product_online add starttime date;
alter table db_product_online add endtime date;
alter table db_product_online add updatetime1 date;
alter table db_product_online add updatetime2 date;

-------------------------2012-10-26 ly------------------------------
insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)
values ('422', '退款报表', '退款报表', '/eshop/report.do?method=reportRefundPaypal', 0, 0, '7', 31, 5, '#3399CC', null, null, null, null);	
-------------------------20121026 lxd------------------------------
CREATE TABLE "DB_SENDLIST" ("SEQUENCEID" VARCHAR2(100 
    byte) NOT NULL, "ORDERID" VARCHAR2(100 byte), "GROUPID" 
    VARCHAR2(100 byte), "UPDATEFLAG" VARCHAR2(1 byte), "DESCR" 
    VARCHAR2(500 byte), "OPER" VARCHAR2(50 byte), "OPERTIME" DATE,
    "RESERVE1" VARCHAR2(100 byte), "RESERVE2" VARCHAR2(100 byte),
    "RESERVE3" VARCHAR2(500 byte), "RESERVE4" VARCHAR2(500 byte),
    "RESERVE5" NUMBER(10), "RESERVE6" NUMBER(10), "RESERVE7" 
    NUMBER(10, 6), "RESERVE8" NUMBER(10, 6), 
    CONSTRAINT "PK_DB_SENDLIST" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING ;



CREATE TABLE "DB_SENDMESSAGE" ("SEQUENCEID" VARCHAR2(100 
    byte) NOT NULL, "TITLE" VARCHAR2(4000 byte), "GROUPID" 
    VARCHAR2(100 byte), "CREATETIME" DATE, "CREATEOPER" 
    VARCHAR2(50 byte), "STATUS" VARCHAR2(50 byte), "CHECKOPER" 
    VARCHAR2(50 byte), "CHECKTIME" DATE, "RECORDENUM" NUMBER(10),
    "SUCCESSNUM" NUMBER(10), "ERRORNUM" NUMBER(10), "SENDTIME" 
    DATE, "RESERVE1" VARCHAR2(100 byte), "RESERVE2" VARCHAR2(100 
    byte), "RESERVE3" VARCHAR2(500 byte), "RESERVE4" VARCHAR2(500
    byte), "RESERVE5" NUMBER(8), "RESERVE6" NUMBER(8), "RESERVE7"
    NUMBER(10, 6), "RESERVE8" NUMBER(10, 6), 
    CONSTRAINT "PK_DB_SENDMESSAGE" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 
-------------------------20121024 sl------------------------------
update db_order set slreserve7=MONEYEXPRESSASK where ordertime>=sysdate-60
update db_order set MONEYEXPRESSASK=originexpressmoney*moneyrate where ordertime>=sysdate-60


--------------------------20121024 hj-------------------------
alter table DB_TWODEVELOPMENTPRODUCTLOG modify CONTENT varchar2(4000);

--------------------------20121019 hp-------------------------
CREATE TABLE "DB_CHECKPURCHASESMSPROMPT" ("SEQUENCEID" 
    VARCHAR2(50 byte) NOT NULL, "NAME" VARCHAR2(100 byte), 
    "DESCR" VARCHAR2(4000 byte), "OPER" VARCHAR2(50 byte), 
    "OPERTIME" DATE, "FILED1" VARCHAR2(400 byte), "FILED2" 
    VARCHAR2(400 byte), "FILED3" VARCHAR2(400 byte), "FILED4" 
    VARCHAR2(400 byte), "FILED5" VARCHAR2(400 byte), "FILED6" 
    VARCHAR2(4000 byte), "FILED7" VARCHAR2(4000 byte), "FILED8" 
    NUMBER(8, 2), "FILED9" NUMBER(8, 2), "FILED10" NUMBER(8, 2), 
    "CORPID" VARCHAR2(50 byte), "OPENFLAG" VARCHAR2(10 byte), 
    CONSTRAINT "PK_DB_CHECKPURCHASESMSPROMPT" PRIMARY 
    KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING ;
COMMENT ON TABLE "DB_CHECKPURCHASESMSPROMPT" IS '快捷短语';
COMMENT ON COLUMN "DB_CHECKPURCHASESMSPROMPT"."OPENFLAG" IS '0表示关闭
1表示开通'


--------------------------20121017 xb-------------------------
alter table DB_PRODUCT_ONLINE add reserve11 varchar2(4000);
alter table DB_PRODUCT_ONLINE add reserve10 varchar2(4000);

--------------------------20121017 hp-------------------------
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);


--------------------------20121015 hj 应赖亦熟这边的需求，增加两个个二次开发商品的表，这两个表的表结构与bindlist 跟 bindproduct 一样-------------------------
alter table db_order add paypalemail varchar2(50);
alter table db_order add paypaloper varchar2(50);


CREATE TABLE "DB_TWODEVELOPMENTPRODUCT" ("SID" VARCHAR2(100 byte)
    NOT NULL, "NAME" VARCHAR2(200 byte) NOT NULL, "CONTENT"
    VARCHAR2(4000 byte), "DESCR" VARCHAR2(4000 byte),
    "CATEGORYID" VARCHAR2(100 byte), "PROJECTID" VARCHAR2(100
    byte), "STATUS" VARCHAR2(100 byte), "STOCKPRICE" NUMBER(8, 2),
    "COSTPRICE" NUMBER(8, 2), "SELLPRICE" NUMBER(8, 2),
    "OTHERPRICE1" NUMBER(8, 2), "OTHERPRICE2" NUMBER(8, 2),
    "WEIGHT" VARCHAR2(100 byte), "SIZES" VARCHAR2(100 byte),
    "COLOR" VARCHAR2(100 byte), "PICTURE1" VARCHAR2(200 byte),
    "PICTURE2" VARCHAR2(200 byte), "PICTURE3" VARCHAR2(200 byte),
    "PICTURE4" VARCHAR2(200 byte), "ORDERNUM" NUMBER(8), "ALIAS1"
    VARCHAR2(4000 byte), "ALIAS2" VARCHAR2(200 byte), "ALIAS3"
    VARCHAR2(200 byte), "OPER" VARCHAR2(100 byte), "OPERTIME"
    DATE, "RESERVE1" VARCHAR2(200 byte), "RESERVE2" VARCHAR2(200
    byte), "RESERVE3" VARCHAR2(200 byte), "RESERVE4" VARCHAR2(200
    byte), "RESERVE5" VARCHAR2(200 byte), "RESERVE6" VARCHAR2(200
    byte), "RESERVE7" NUMBER(8, 2), "RESERVE8" NUMBER(8, 2),
    "CORPID" VARCHAR2(100 byte),
    CONSTRAINT "PK_DB_TWODEVELOPMENTPRODUCT" PRIMARY KEY("SID")
    USING INDEX
    TABLESPACE "ZHRGPT"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)

    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING ;
COMMENT ON TABLE "DB_TWODEVELOPMENTPRODUCT" IS '二次开发商品表'




CREATE TABLE "DB_TWODEVELOPMENTLIST" ("SID" VARCHAR2(50 byte) NOT
    NULL, "BINDID" VARCHAR2(200 byte), "ALIAS1" VARCHAR2(4000
    byte), "NUM" NUMBER(10), "OPERTIME" DATE, "CORPID"
    VARCHAR2(100 byte), "RESERVE1" VARCHAR2(100 byte), "RESERVE2"
    VARCHAR2(100 byte), "RESERVE3" VARCHAR2(100 byte), "RESERVE4"
    NUMBER(11, 4), "RESERVE5" NUMBER(11, 4),
    CONSTRAINT "DB_TWODEVELOPMENTLIST" PRIMARY KEY("SID")
    USING INDEX
    TABLESPACE "ZHRGPT"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)

    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING




CREATE TABLE "DB_TWODEVELOPMENTPRODUCTLOG" ("SEQUENCEID" VARCHAR2(50
    byte) NOT NULL, "SID" VARCHAR2(100 byte), "NAME" VARCHAR2(100
    byte), "DESCR" VARCHAR2(4000 byte), "OPER" VARCHAR2(50 byte),
    "OPERTIME" DATE, "FILED1" VARCHAR2(400 byte), "FILED2"
    VARCHAR2(400 byte), "FILED3" VARCHAR2(400 byte), "FILED4"
    VARCHAR2(400 byte), "FILED5" VARCHAR2(400 byte), "FILED6"
    VARCHAR2(4000 byte), "FILED7" VARCHAR2(4000 byte), "FILED8"
    NUMBER(8, 2), "FILED9" NUMBER(8, 2), "FILED10" NUMBER(8, 2),
    "CORPID" VARCHAR2(50 byte), "OPENFLAG" VARCHAR2(10 byte),
    "OPERTYPE" VARCHAR2(50 byte), "CONTENT" VARCHAR2(2000 byte),
    CONSTRAINT "PK_DB_TWODEVELOPMENTPRODUCTLOG" PRIMARY KEY("SEQUENCEID")
    USING INDEX
    TABLESPACE "ZHRGPT"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)

    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING

321	商品二次加工	商品二次加工	/eshop/product.do?method=twodevelopmentlist	0	0	4	7	3	#FF6633		

alter table db_order add PAYPALPOSTCODE varchar2(50);
alter table db_order add PAYPALTEL varchar2(50);
alter table db_order add ORIGINPAYPALFEEAMOUNT number(10,4);
alter table db_order add ORIGINPAYPALGROSSAMOUNT number(10,4);
alter table db_order add ORIGINPAYPALNETAMOUNT number(10,4);
-----------------------20121014 xb ------------------------------------------
216	Message分类配置	Message分类配置	/eshop/message.do?method=listmessagebind	0	0	3	35	3	#FFFFFF

-----------------------20121013 hp ------------------------------------------

alter table DB_FEEDBACK modify EXPRESSTYPE VARCHAR2(500);
alter table DB_FEEDBACK modify MANUFACTURE VARCHAR2(500);
alter table DB_FEEDBACK modify STYPE VARCHAR2(500);


alter table DB_FEEDBACK modify SHOPTYPE VARCHAR2(500);
alter table DB_FEEDBACK modify PRODUCTNAME VARCHAR2(4000);

-----------------------20121010 hp ------------------------------------------
alter table db_refundpaypal add PRODUCTID varchar2(50);
alter table db_refundpaypal add ORDERTIME date;
alter table db_refundpaypal add PURCHASEOPER varchar2(100);
alter table db_refundpaypal add EXPRESSTYPE varchar2(50);
alter table db_refundpaypal add RESERVE11 varchar2(500);
alter table db_refundpaypal add RESERVE12 varchar2(500);
alter table db_refundpaypal add RESERVE13 varchar2(500);
alter table db_refundpaypal add RESERVE14 varchar2(500);

alter table db_refundpaypallog add PRODUCTID varchar2(50);
alter table db_refundpaypallog add ORDERTIME date;
alter table db_refundpaypallog add PURCHASEOPER varchar2(100);
alter table db_refundpaypallog add EXPRESSTYPE varchar2(50);
alter table db_refundpaypallog add RESERVE11 varchar2(500);
alter table db_refundpaypallog add RESERVE12 varchar2(500);
alter table db_refundpaypallog add RESERVE13 varchar2(500);
alter table db_refundpaypallog add RESERVE14 varchar2(500);


-----------------------20121010 xb ------------------------------------------
alter table db_product_online add brandid varchar2(100);
alter table db_product_online add brandname varchar2(100);

alter table db_product_online add sellpriceonline number(8,2);
alter table db_product_online add expresspriceonline number(8,2);
alter table db_product_online add moneyrate number(8,4);
alter table db_product_online add costpriceonline number(8,2);
alter table db_product_online add productweight number(8,2);
alter table db_product_online add purchaseoper varchar2(100);
alter table db_product_online add selloper varchar2(100);
alter table db_product_online add itemnumber number(8);
alter table db_product_online add itemnumber1 number(8);
alter table db_product_online add site varchar2(100);
alter table db_product_online add country varchar2(100);
alter table db_product_online add location varchar2(100);
alter table db_product_online add paymentmethod varchar2(100);
alter table db_product_online add categoryid varchar2(100);
alter table db_product_online add categoryname varchar2(100);

-------------------------------20121009-----------------------------------------

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)
values ('420', '日收入报表', '日收入报表', '/eshop/report.do?method=immediatereportDay', 0, 0, '7', 1, 3, '#FFFFFF', null, null, null, null);
-----------------------20121008 sl ------------------------------------------
alter table db_order_history modify oper2 VARCHAR2(4000);

-------------------------------20120929 hp-----------------------------------------

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)
values ('555', '商品质量反馈pro', '商品质量反馈pro', '/eshop/other.do?method=feedbacklist', 0, 0, '4', 10, 3, '#FF6633', null, null, null, null);


------------------------20120925 liangxidong----------------------------------
CREATE TABLE "DB_PRODUCTCLASS" ("SEQUENCEID" VARCHAR2(50 
    byte) NOT NULL, "CLASSNAME" VARCHAR2(100 byte), "AVGSELLNUM1"
    NUMBER, "AVGSELLNUM2" NUMBER, "OPER" VARCHAR2(100 byte), 
    "OPERTIME" DATE, "RESERVE1" VARCHAR2(100 byte), "RESERVE2" 
    VARCHAR2(100 byte), "RESERVE3" VARCHAR2(100 byte), "RESERVE4"
    NUMBER, "RESERVE5" NUMBER, 
    CONSTRAINT "PK_DB_PRODUCTCLASS" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 
------------------------20120925 qinli----------------------------------
CREATE TABLE "DB_FEEDBACK" ("FEEDBACKID" VARCHAR2(50 
    byte) NOT NULL, "CUSTOMERID" VARCHAR2(100 byte), 
    "TRANSACTIONID" VARCHAR2(50 byte), "ITEMID" VARCHAR2(50 byte),
    "PRODUCTID" VARCHAR2(50 byte), "PRODUCTNAME" VARCHAR2(500 
    byte), "FEEDBACKTYPEID" VARCHAR2(50 byte), "FEEDBACKTYPE" 
    VARCHAR2(100 byte), "CONTENT" VARCHAR2(4000 byte), 
    "FEEDBACKTIME" DATE, "CREATETIME" DATE, "SHOPTYPEID" 
    VARCHAR2(50 byte), "SHOPTYPE" VARCHAR2(100 byte), 
    "EXPRESSTYPEID" VARCHAR2(50 byte), "EXPRESSTYPE" VARCHAR2(200
    byte), "STYPE" VARCHAR2(50 byte), "OPER" VARCHAR2(50 byte), 
    "OPERTIME" DATE, "ANSWER" VARCHAR2(4000 byte), 
    "MANUFACTUREID" VARCHAR2(50 byte), "MANUFACTURE" VARCHAR2(200
    byte), "MONEY" NUMBER(8, 2), "RETURNMONEY" NUMBER(8, 2), 
    "PAYPALID" VARCHAR2(50 byte), "ORDERNUM" NUMBER(6), "SELLNUM"
    NUMBER(5), "WEBSITE" VARCHAR2(100 byte), "PURCHASEOPER" 
    VARCHAR2(50 byte), "SELLOPER" VARCHAR2(50 byte), 
    "SERVICEOPER" VARCHAR2(50 byte), "PICKUPOPER" VARCHAR2(50 
    byte), "COUNTRY" VARCHAR2(200 byte), "ORDERID" VARCHAR2(50 
    byte), "ORDERTIME" DATE, "EXPRESSTIME" DATE, "STATUS" 
    VARCHAR2(100 byte), "RESERVE1" VARCHAR2(1000 byte), 
    "RESERVE2" VARCHAR2(1000 byte), "RESERVE3" VARCHAR2(1000 
    byte), "RESERVE4" VARCHAR2(100 byte), "RESERVE5" VARCHAR2(100
    byte), "RESERVE6" NUMBER(10), "RESERVE7" NUMBER(10), 
    "RESERVE8" NUMBER(10, 4), "RESERVE9" NUMBER(10, 4), 
    "RESERVE10" NUMBER(10, 4), "IFRETURN" VARCHAR2(50 byte), 
    CONSTRAINT "PK_FEEDBACKID" PRIMARY KEY("FEEDBACKID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 


---------------------- 20120925 ------------------------------------
alter table DB_ASKTRADERNUMBER modify CUSTOMERADDRESS VARCHAR2(2000);

------ 20120925调整优化二级菜单(sort顺序，reserve1颜色)------
---订单模块--- 
update DB_MENUFUNC set sort = 1, reserve1 = '#FFFFFF' where funname = '所有订单';
update DB_MENUFUNC set sort = 2, reserve1 = '#FFFFFF' where funname = 'Paypal对账';
update DB_MENUFUNC set sort = 3, reserve1 = '#FF6633' where funname = '今日订单';
update DB_MENUFUNC set sort = 4, reserve1 = '#FF6633' where funname = '新订单';
update DB_MENUFUNC set sort = 5, reserve1 = '#FF6633' where funname = '已支付';
update DB_MENUFUNC set sort = 6, reserve1 = '#FF6633' where funname = '配货中';
update DB_MENUFUNC set sort = 7, reserve1 = '#FF6633' where funname = '已发货';
update DB_MENUFUNC set sort = 8, reserve1 = '#FF6633' where funname = '已完成';
update DB_MENUFUNC set sort = 9, reserve1 = '#FF6633' where funname = '作废订单';
update DB_MENUFUNC set sort = 10, reserve1 = '#99AB32' where funname = '买家记录';
update DB_MENUFUNC set sort = 11, reserve1 = '#99AB32' where funname = '退款管理';
update DB_MENUFUNC set sort = 12, reserve1 = '#99AB32' where funname = '订单过渡';
update DB_MENUFUNC set sort = 13, reserve1 = '#99AB32' where funname = '单商品订单';
update DB_MENUFUNC set sort = 14, reserve1 = '#99AB32' where funname = '可合并的订单';
update DB_MENUFUNC set sort = 15, reserve1 = '#99AB32' where funname = '智能物流选择';
update DB_MENUFUNC set sort = 16, reserve1 = '#99AB32' where funname = '过期订单归档';
update DB_MENUFUNC set sort = 17, reserve1 = '#AA5544' where funname = 'E邮宝订单';
update DB_MENUFUNC set sort = 18, reserve1 = '#AA5544' where funname = '查询历史订单';
update DB_MENUFUNC set sort = 19, reserve1 = '#AA5544' where funname = '包装验货';
update DB_MENUFUNC set sort = 20, reserve1 = '#AA5544' where funname = '包装验货pro';
update DB_MENUFUNC set sort = 21, reserve1 = '#AA5544' where funname = '订单搜索脚本';
update DB_MENUFUNC set sort = 22, reserve1 = '#AA5544' where funname = '订单搜索脚本pro';
update DB_MENUFUNC set sort = 23, reserve1 = '#3399CC' where funname = '上传EBAY订单';
update DB_MENUFUNC set sort = 24, reserve1 = '#3399CC' where funname = '上传亚马逊订单';
update DB_MENUFUNC set sort = 25, reserve1 = '#3399CC' where funname = '上传速卖通订单';
update DB_MENUFUNC set sort = 26, reserve1 = '#3399CC' where funname = '上传通用订单';
update DB_MENUFUNC set sort = 27, reserve1 = '#3399CC' where funname = '下载zencart订单';



---产品模块---
update DB_MENUFUNC set sort = 1, reserve1 = '#FFFFFF' where funname = '产品列表';
update DB_MENUFUNC set sort = 2, reserve1 = '#FFFFFF' where funname = '产品批量修改';
update DB_MENUFUNC set sort = 3, reserve1 = '#FFFFFF' where funname = '新增单个产品';
update DB_MENUFUNC set sort = 4, reserve1 = '#FFFFFF' where funname = '批量增加产品';
update DB_MENUFUNC set sort = 5, reserve1 = '#FFFFFF' where funname = '产品导出';
update DB_MENUFUNC set sort = 6, reserve1 = '#FF6633' where funname = '盘点库存';
update DB_MENUFUNC set sort = 7, reserve1 = '#FF6633' where funname = '绑定商品';
update DB_MENUFUNC set sort = 8, reserve1 = '#FF6633' where funname = '计算价格';
update DB_MENUFUNC set sort = 9, reserve1 = '#FF6633' where funname = '供应商管理PRO';
update DB_MENUFUNC set sort = 10, reserve1 = '#FF6633' where funname = '商品质量反馈';
update DB_MENUFUNC set sort = 11, reserve1 = '#FF6633' where funname = '商品空值查询';
update DB_MENUFUNC set sort = 12, reserve1 = '#99AB32' where funname = '商品网名管理';
update DB_MENUFUNC set sort = 13, reserve1 = '#99AB32' where funname = '增加商品网名';
update DB_MENUFUNC set sort = 14, reserve1 = '#99AB32' where funname = '在线产品维护';
update DB_MENUFUNC set sort = 15, reserve1 = '#99AB32' where funname = '各店铺在线商品';
update DB_MENUFUNC set sort = 16, reserve1 = '#99AB32' where funname = '在线商品对比';

---报表模块---
update DB_MENUFUNC set sort = 1, reserve1 = '#FFFFFF' where funname = '日销售报表';
update DB_MENUFUNC set sort = 2, reserve1 = '#FFFFFF' where funname = '月销售额报表';
update DB_MENUFUNC set sort = 3, reserve1 = '#FFFFFF' where funname = '热销商品排名';
update DB_MENUFUNC set sort = 4, reserve1 = '#FFFFFF' where funname = '热销店铺排名';
update DB_MENUFUNC set sort = 5, reserve1 = '#FFFFFF' where funname = '按国家销售额报表';
update DB_MENUFUNC set sort = 6, reserve1 = '#FF6633' where funname = '订单情况表';
update DB_MENUFUNC set sort = 7, reserve1 = '#FF6633' where funname = '订单购买量';
update DB_MENUFUNC set sort = 8, reserve1 = '#FF6633' where funname = '订单价格区间';
update DB_MENUFUNC set sort = 9, reserve1 = '#FF6633' where funname = '订单延迟报表';
update DB_MENUFUNC set sort = 10, reserve1 = '#FF6633' where funname = '订单处理日志表';
update DB_MENUFUNC set sort = 11, reserve1 = '#99AB32' where funname = '单商品报表';
update DB_MENUFUNC set sort = 12, reserve1 = '#99AB32' where funname = 'SKU销量报表';
update DB_MENUFUNC set sort = 13, reserve1 = '#99AB32' where funname = '滞销商品报表';
update DB_MENUFUNC set sort = 14, reserve1 = '#99AB32' where funname = '商品反馈报表';
update DB_MENUFUNC set sort = 15, reserve1 = '#99AB32' where funname = '商品分类销售';
update DB_MENUFUNC set sort = 16, reserve1 = '#99AB32' where funname = '单商品销售查询';
update DB_MENUFUNC set sort = 17, reserve1 = '#99AB32' where funname = '项目商品销售监控';
update DB_MENUFUNC set sort = 18, reserve1 = '#AA5544' where funname = '利润区间查询';
update DB_MENUFUNC set sort = 19, reserve1 = '#AA5544' where funname = '货币金额报表';
update DB_MENUFUNC set sort = 20, reserve1 = '#AA5544' where funname = '财务支出报表';
update DB_MENUFUNC set sort = 21, reserve1 = '#AA5544' where funname = '供应商营业额报表';
update DB_MENUFUNC set sort = 22, reserve1 = '#3399CC' where funname = '客户排名';
update DB_MENUFUNC set sort = 23, reserve1 = '#3399CC' where funname = '库存报表';
update DB_MENUFUNC set sort = 24, reserve1 = '#3399CC' where funname = '采购报表';
update DB_MENUFUNC set sort = 25, reserve1 = '#3399CC' where funname = '物流统计';
update DB_MENUFUNC set sort = 26, reserve1 = '#3399CC' where funname = '盘点查询';
update DB_MENUFUNC set sort = 27, reserve1 = '#3399CC' where funname = '项目进度报表';
update DB_MENUFUNC set sort = 28, reserve1 = '#3399CC' where funname = '人员营业报表';
update DB_MENUFUNC set sort = 29, reserve1 = '#3399CC' where funname = '库存周转率报表 ';
update DB_MENUFUNC set sort = 30, reserve1 = '#3399CC' where funname = 'PayPal金额报表';

---系统配置模块---
update DB_MENUFUNC set sort = 1, reserve1 = '#FFFFFF' where funname = '店铺账号管理';
update DB_MENUFUNC set sort = 2, reserve1 = '#FFFFFF' where funname = 'Ebay订单提取规则';
update DB_MENUFUNC set sort = 3, reserve1 = '#FF6633' where funname = 'Paypal';
update DB_MENUFUNC set sort = 4, reserve1 = '#FF6633' where funname = '品牌管理';
update DB_MENUFUNC set sort = 5, reserve1 = '#FF6633' where funname = '仓库设置';
update DB_MENUFUNC set sort = 6, reserve1 = '#FF6633' where funname = '仓位设置';
update DB_MENUFUNC set sort = 7, reserve1 = '#FF6633' where funname = '国家配置';
update DB_MENUFUNC set sort = 8, reserve1 = '#FF6633' where funname = '汇率设置';
update DB_MENUFUNC set sort = 9, reserve1 = '#FF6633' where funname = '供应商管理';
update DB_MENUFUNC set sort = 10, reserve1 = '#FF6633' where funname = '供应商管理PRO';
update DB_MENUFUNC set sort = 11, reserve1 = '#FF6633' where funname = '商品目录管理';
update DB_MENUFUNC set sort = 12, reserve1 = '#FF6633' where funname = '产品图片配置';
update DB_MENUFUNC set sort = 13, reserve1 = '#FF6633' where funname = '包材类型设置';

update DB_MENUFUNC set sort = 14, reserve1 = '#99AB32' where funname = '承运商';
update DB_MENUFUNC set sort = 15, reserve1 = '#99AB32' where funname = '组别管理';
update DB_MENUFUNC set sort = 16, reserve1 = '#99AB32' where funname = '系统日志';
update DB_MENUFUNC set sort = 17, reserve1 = '#99AB32' where funname = '业务模板';
update DB_MENUFUNC set sort = 18, reserve1 = '#99AB32' where funname = '技能组管理';
update DB_MENUFUNC set sort = 19, reserve1 = '#99AB32' where funname = '员工代表管理';
update DB_MENUFUNC set sort = 20, reserve1 = '#99AB32' where funname = 'zencart配置';
update DB_MENUFUNC set sort = 21, reserve1 = '#99AB32' where funname = '收支类型设置';
update DB_MENUFUNC set sort = 22, reserve1 = '#99AB32' where funname = '货运方式设置';
update DB_MENUFUNC set sort = 23, reserve1 = '#99AB32' where funname = '中国邮政配置';
update DB_MENUFUNC set sort = 24, reserve1 = '#99AB32' where funname = '警戒时间配置';
update DB_MENUFUNC set sort = 25, reserve1 = '#99AB32' where funname = '邮件内容配置';
update DB_MENUFUNC set sort = 26, reserve1 = '#99AB32' where funname = '打印标签模板';
update DB_MENUFUNC set sort = 27, reserve1 = '#99AB32' where funname = '销售平台管理';
update DB_MENUFUNC set sort = 28, reserve1 = '#99AB32' where funname = '业务工作流设置';
update DB_MENUFUNC set sort = 29, reserve1 = '#99AB32' where funname = '订单自定义类型';
update DB_MENUFUNC set sort = 30, reserve1 = '#3399CC' where funname = '支付费设置';
update DB_MENUFUNC set sort = 31, reserve1 = '#3399CC' where funname = '商品类别设置';
update DB_MENUFUNC set sort = 32, reserve1 = '#3399CC' where funname = '登录费用设置';
update DB_MENUFUNC set sort = 33, reserve1 = '#3399CC' where funname = '交易费用设置';
update DB_MENUFUNC set sort = 34, reserve1 = '#AA5544' where funname = '系统说明';


--------------------20120925-----------------------------
alter table DB_PRODUCT_TEMP modify name VARCHAR2(500);
alter table db_purchase add reserve6 number(8,4);

---------------------20120920----------------------------
insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)
values ('700', '消息管理', '消息管理', '@', 0, 1, '0', 3, 3, '#FFFFFF', null, null, null, null);

---------------------20120920----------------------------
insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)
values ('421', '订单修改日志查询', '订单修改日志查询', '/eshop/order.do?method=loglistfull', 0, 0, '2', 400, 3, '#FFFFFF', null, null, null, null);

alter table db_endproduct_online add flag1 varchar2(200);
alter table db_endproduct_online add flag2 varchar2(200);
alter table db_endproduct_online add flag3 varchar2(200);
alter table db_endproduct_online add flag4 varchar2(200);
alter table db_endproduct_online add flag5 varchar2(200);
alter table db_endproduct_onlinelog add flag1 varchar2(200);
alter table db_endproduct_onlinelog add flag2 varchar2(200);
alter table db_endproduct_onlinelog add flag3 varchar2(200);
alter table db_endproduct_onlinelog add flag4 varchar2(200);
alter table db_endproduct_onlinelog add flag5 varchar2(200);


---------------------20120919----------------------------
update db_sysadmin set managerarea='1';--默认开启查看成本价


---------------------20120918  计算价格----------------------------
CREATE TABLE "DB_CALCUPAYPALTYPE" ("SEQUENCEID"
    VARCHAR2(50 byte) NOT NULL, "NAME" VARCHAR2(100 byte),
    "DESCR" VARCHAR2(4000 byte), "OPER" VARCHAR2(50 byte),
    "OPERTIME" DATE, "FILED1" VARCHAR2(400 byte), "FILED2"
    VARCHAR2(400 byte), "FILED3" VARCHAR2(400 byte), "FILED4"
    VARCHAR2(400 byte), "FILED5" VARCHAR2(400 byte), "FILED6"
    VARCHAR2(4000 byte), "FILED7" VARCHAR2(4000 byte), "FILED8"
    NUMBER(8, 5), "FILED9" NUMBER(8, 5), "FILED10" NUMBER(8, 2),
    "CORPID" VARCHAR2(50 byte), "OPENFLAG" VARCHAR2(10 byte),
    CONSTRAINT "PK_CALCUPAYPALTYPE" PRIMARY KEY("SEQUENCEID")
    USING INDEX
    TABLESPACE "ZHRGPT"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)

    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING;




CREATE TABLE "DB_CALCUPAYPALTYPELOG" ("SEQUENCEID"
    VARCHAR2(50 byte) NOT NULL, "SID" VARCHAR2(100 byte), "NAME"
    VARCHAR2(100 byte), "DESCR" VARCHAR2(4000 byte), "OPER"
    VARCHAR2(50 byte), "OPERTIME" DATE, "FILED1" VARCHAR2(400
    byte), "FILED2" VARCHAR2(400 byte), "FILED3" VARCHAR2(400
    byte), "FILED4" VARCHAR2(400 byte), "FILED5" VARCHAR2(400
    byte), "FILED6" VARCHAR2(4000 byte), "FILED7" VARCHAR2(4000
    byte), "FILED8" NUMBER(8, 5), "FILED9" NUMBER(8, 5),
    "FILED10" NUMBER(8, 2), "CORPID" VARCHAR2(50 byte),
    "OPENFLAG" VARCHAR2(10 byte), "OPERTYPE" VARCHAR2(50 byte),
    "CONTENT" VARCHAR2(2000 byte),
    CONSTRAINT "PK_CALCUPAYPALTYPELOG" PRIMARY KEY("SEQUENCEID")
    USING INDEX
    TABLESPACE "ZHRGPT"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)

    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING;




CREATE TABLE "DB_CALCUPLATFORM" ("SEQUENCEID"
    VARCHAR2(50 byte) NOT NULL, "NAME" VARCHAR2(100 byte),
    "DESCR" VARCHAR2(4000 byte), "OPER" VARCHAR2(50 byte),
    "OPERTIME" DATE, "FILED1" VARCHAR2(400 byte), "FILED2"
    VARCHAR2(400 byte), "FILED3" VARCHAR2(400 byte), "FILED4"
    VARCHAR2(400 byte), "FILED5" VARCHAR2(400 byte), "FILED6"
    VARCHAR2(4000 byte), "FILED7" VARCHAR2(4000 byte), "FILED8"
    NUMBER(8, 5), "FILED9" NUMBER(8, 5), "FILED10" NUMBER(8, 5),
    "CORPID" VARCHAR2(50 byte), "OPENFLAG" VARCHAR2(10 byte),
    "FILED11" NUMBER(8, 5), "FILED12" NUMBER(8, 5),
    CONSTRAINT "PK_CALCUPLATFORM" PRIMARY KEY("SEQUENCEID")
    USING INDEX
    TABLESPACE "ZHRGPT"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)

    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING;




CREATE TABLE "DB_CALCUPLATFORMLOG" ("SEQUENCEID"
    VARCHAR2(50 byte) NOT NULL, "SID" VARCHAR2(100 byte), "NAME"
    VARCHAR2(100 byte), "DESCR" VARCHAR2(4000 byte), "OPER"
    VARCHAR2(50 byte), "OPERTIME" DATE, "FILED1" VARCHAR2(400
    byte), "FILED2" VARCHAR2(400 byte), "FILED3" VARCHAR2(400
    byte), "FILED4" VARCHAR2(400 byte), "FILED5" VARCHAR2(400
    byte), "FILED6" VARCHAR2(4000 byte), "FILED7" VARCHAR2(4000
    byte), "FILED8" NUMBER(8, 5), "FILED9" NUMBER(8, 5),
    "FILED10" NUMBER(8, 5), "CORPID" VARCHAR2(50 byte),
    "OPENFLAG" VARCHAR2(10 byte), "OPERTYPE" VARCHAR2(50 byte),
    "CONTENT" VARCHAR2(2000 byte), "FILED11" NUMBER(8, 5),
    "FILED12" NUMBER(8, 5),
    CONSTRAINT "PK_CALCUPLATFORMLOGID" PRIMARY KEY("SEQUENCEID")
    USING INDEX
    TABLESPACE "ZHRGPT"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)

    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING;




CREATE TABLE "DB_CALCUPRODUCTTYPE" ("SEQUENCEID"
    VARCHAR2(50 byte) NOT NULL, "NAME" VARCHAR2(100 byte),
    "DESCR" VARCHAR2(4000 byte), "OPER" VARCHAR2(50 byte),
    "OPERTIME" DATE, "FILED1" VARCHAR2(400 byte), "FILED2"
    VARCHAR2(400 byte), "FILED3" VARCHAR2(400 byte), "FILED4"
    VARCHAR2(400 byte), "FILED5" VARCHAR2(400 byte), "FILED6"
    VARCHAR2(4000 byte), "FILED7" VARCHAR2(4000 byte), "FILED8"
    NUMBER(8, 5), "FILED9" NUMBER(8, 5), "FILED10" NUMBER(8, 2),
    "CORPID" VARCHAR2(50 byte), "OPENFLAG" VARCHAR2(10 byte),
    CONSTRAINT "PK_CALCUPRODUCTTYPE" PRIMARY KEY("SEQUENCEID")
    USING INDEX
    TABLESPACE "ZHRGPT"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)

    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING;



CREATE TABLE "DB_CALCUPRODUCTTYPELOG" ("SEQUENCEID"
    VARCHAR2(50 byte) NOT NULL, "SID" VARCHAR2(100 byte), "NAME"
    VARCHAR2(100 byte), "DESCR" VARCHAR2(4000 byte), "OPER"
    VARCHAR2(50 byte), "OPERTIME" DATE, "FILED1" VARCHAR2(400
    byte), "FILED2" VARCHAR2(400 byte), "FILED3" VARCHAR2(400
    byte), "FILED4" VARCHAR2(400 byte), "FILED5" VARCHAR2(400
    byte), "FILED6" VARCHAR2(4000 byte), "FILED7" VARCHAR2(4000
    byte), "FILED8" NUMBER(8, 5), "FILED9" NUMBER(8, 5),
    "FILED10" NUMBER(8, 2), "CORPID" VARCHAR2(50 byte),
    "OPENFLAG" VARCHAR2(10 byte), "OPERTYPE" VARCHAR2(50 byte),
    "CONTENT" VARCHAR2(2000 byte),
    CONSTRAINT "PK_CALCUPRODUCTTYPELOG" PRIMARY KEY("SEQUENCEID")
    USING INDEX
    TABLESPACE "ZHRGPT"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)

    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING;


insert into DB_CALCUPLATFORM (sequenceid,name,filed8,filed9,filed10,corpid,openflag,filed11,filed12) values('1','eBay美国','6.35','0.11','0.034','1','1','0.3','0.5');
insert into DB_CALCUPLATFORM (sequenceid,name,filed8,filed9,filed10,corpid,openflag,filed11,filed12) values('2','eBay英国','9.58','0.1','0.034','1','1','0.2','0.35');
insert into DB_CALCUPLATFORM (sequenceid,name,filed8,filed9,filed10,corpid,openflag,filed11,filed12) values('3','eBay澳大利亚','6.41','0.079','0.034','1','1','0.3','0.2');


insert into DB_CALCUPRODUCTTYPE (sequenceid,name,filed1,filed2,filed8,corpid,openflag) values('1','美-电子类','1','eBay美国','0.07','1','1');
insert into DB_CALCUPRODUCTTYPE (sequenceid,name,filed1,filed2,filed8,corpid,openflag) values('2','美-服装及汽配类','1','eBay美国','0.1','1','1');
insert into DB_CALCUPRODUCTTYPE (sequenceid,name,filed1,filed2,filed8,corpid,openflag) values('3','美-游戏配件类','1','eBay美国','0.013','1','1');
insert into DB_CALCUPRODUCTTYPE (sequenceid,name,filed1,filed2,filed8,corpid,openflag) values('4','美-其他','1','eBay美国','0.011','1','1');
insert into DB_CALCUPRODUCTTYPE (sequenceid,name,filed1,filed2,filed8,corpid,openflag) values('5','英-技术类','2','eBay英国','0.05','1','1');
insert into DB_CALCUPRODUCTTYPE (sequenceid,name,filed1,filed2,filed8,corpid,openflag) values('6','英-汽配类','2','eBay英国','0.08','1','1');
insert into DB_CALCUPRODUCTTYPE (sequenceid,name,filed1,filed2,filed8,corpid,openflag) values('7','英-游戏配件类','2','eBay英国','0.09','1','1');
insert into DB_CALCUPRODUCTTYPE (sequenceid,name,filed1,filed2,filed8,corpid,openflag) values('8','英-服装及配饰','2','eBay英国','0.12','1','1');
insert into DB_CALCUPRODUCTTYPE (sequenceid,name,filed1,filed2,filed8,corpid,openflag) values('9','英-其他','2','eBay英国','0.1','1','1');
insert into DB_CALCUPRODUCTTYPE (sequenceid,name,filed1,filed2,filed8,corpid,openflag) values('10','澳-统一类别','3','eBay澳大利亚','0.079','1','1');

insert into DB_CALCUPAYPALTYPE (sequenceid,name,filed1,filed2,filed8,filed9,corpid,openflag) values('1','美国standard','1','eBay美国','0.034','0.3','1','1');
insert into DB_CALCUPAYPALTYPE (sequenceid,name,filed1,filed2,filed8,filed9,corpid,openflag) values('2','美国micropay','1','eBay美国','0.06','0.05','1','1');
insert into DB_CALCUPAYPALTYPE (sequenceid,name,filed1,filed2,filed8,filed9,corpid,openflag) values('3','英国standard','2','eBay英国','0.034','0.2','1','1');
insert into DB_CALCUPAYPALTYPE (sequenceid,name,filed1,filed2,filed8,filed9,corpid,openflag) values('4','英国micropay','2','eBay英国','0.06','0.05','1','1');
insert into DB_CALCUPAYPALTYPE (sequenceid,name,filed1,filed2,filed8,filed9,corpid,openflag) values('5','澳standard','3','eBay澳大利亚','0.034','0.3','1','1');
insert into DB_CALCUPAYPALTYPE (sequenceid,name,filed1,filed2,filed8,filed9,corpid,openflag) values('6','澳micropay','3','eBay澳大利亚','0.06','0.05','1','1');



---------------------20120918----------------------------
alter table db_ordersearch add PAYPALID varchar(50);
alter table db_ordersearch add CUSTOMERID varchar(4000);
alter table db_ordersearch add FILED22 varchar(500);
alter table db_ordersearch add FLAG22 varchar(50);
alter table db_ordersearch add FILED23 varchar(500);
alter table db_ordersearch add FLAG23 varchar(50);
alter table db_ordersearch add FILED24 varchar(500);
alter table db_ordersearch add FLAG24 varchar(50);
alter table db_ordersearch add FILED25 varchar(500);
alter table db_ordersearch add FLAG25 varchar(50);
alter table db_ordersearch add FILED26 varchar(500);
alter table db_ordersearch add FLAG26 varchar(50);
alter table db_ordersearch add FILED27 varchar(500);
alter table db_ordersearch add FLAG27 varchar(50);
alter table db_ordersearch add FILED28 varchar(500);
alter table db_ordersearch add FLAG28 varchar(50);
alter table db_ordersearch add FILED29 varchar(500);
alter table db_ordersearch add FLAG29 varchar(50);

---------------------20120915----------------------------

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)
values ('321', '下线产品查询', '下线产品查询', '/eshop/product.do?method=batchEndproduct', 0, 0, '4', 123, 5, '#FFFFFF', null, null, null, null);
---------------------20120913----------------------------

update DB_SYSADMIN set   managerarea='1' where  oper='admin'

CREATE TABLE "DB_ENDPRODUCT_ONLINE" ("SEQUENCEID" 
    VARCHAR2(100 byte) NOT NULL, "PRODUCTONLINEID" VARCHAR2(100 
    byte), "CORPID" VARCHAR2(100 byte), "SHOPID" VARCHAR2(100 
    byte), "SHOPNAME" VARCHAR2(200 byte), "EBAYSKU" VARCHAR2(100 
    byte), "EBAYITEMID" VARCHAR2(100 byte), "PRODUCTID" 
    VARCHAR2(100 byte), "PRODUCTNAME" VARCHAR2(500 byte), 
    "PRODUCTTYPE" VARCHAR2(100 byte), "UPDATETIME" DATE, "PRICE1"
    NUMBER(12, 2), "PRICE2" NUMBER(12, 2), "PRICE3" NUMBER(12, 2),
    "MONEYTYPE" VARCHAR2(100 byte), "NUMBER1" NUMBER(10), 
    "NUMBER2" NUMBER(10), "NUMBER3" NUMBER(10), "RESERVE1" 
    VARCHAR2(500 byte), "RESERVE2" VARCHAR2(500 byte), "RESERVE3"
    VARCHAR2(500 byte), "PRODUCTNAMEENGLISH" VARCHAR2(1000 byte),
    "RESERVE4" VARCHAR2(500 byte), "PIC1" VARCHAR2(500 byte), 
    "PIC2" VARCHAR2(500 byte), "PIC3" VARCHAR2(500 byte), "PIC4" 
    VARCHAR2(500 byte), "PIC5" VARCHAR2(500 byte), "RESERVE5" 
    VARCHAR2(500 byte), "RESERVE6" VARCHAR2(500 byte), "RESERVE7"
    VARCHAR2(500 byte), "RESERVE8" VARCHAR2(500 byte), "RESERVE9"
    VARCHAR2(500 byte), "SELLNUM1" NUMBER(10), "SELLNUM2" 
    NUMBER(10), "SELLNUM3" NUMBER(10), "SELLNUM4" NUMBER(10), 
    "SELLNUM5" NUMBER(10), "SELLNUM6" NUMBER(10), "FLAG" 
    VARCHAR2(100 byte), "DESCR" VARCHAR2(1000 byte), 
    CONSTRAINT "PK_DB_ENDPRODUCT_ONLINE" PRIMARY 
    KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING ;
COMMENT ON TABLE "DB_ENDPRODUCT_ONLINE" IS '下线商品列表'

CREATE TABLE "DB_ENDPRODUCT_ONLINELOG" ("SEQUENCEID" 
    VARCHAR2(100 byte) NOT NULL, "SID" VARCHAR2(100 byte), 
    "CORPID" VARCHAR2(100 byte), "SHOPID" VARCHAR2(100 byte), 
    "SHOPNAME" VARCHAR2(200 byte), "EBAYSKU" VARCHAR2(100 byte), 
    "EBAYITEMID" VARCHAR2(100 byte), "PRODUCTID" VARCHAR2(100 
    byte), "PRODUCTNAME" VARCHAR2(500 byte), "PRODUCTTYPE" 
    VARCHAR2(100 byte), "UPDATETIME" DATE, "PRICE1" NUMBER(12, 2),
    "PRICE2" NUMBER(12, 2), "PRICE3" NUMBER(12, 2), "MONEYTYPE" 
    VARCHAR2(100 byte), "NUMBER1" NUMBER(10), "NUMBER2" 
    NUMBER(10), "NUMBER3" NUMBER(10), "RESERVE1" VARCHAR2(500 
    byte), "RESERVE2" VARCHAR2(500 byte), "RESERVE3" VARCHAR2(500
    byte), "PRODUCTNAMEENGLISH" VARCHAR2(1000 byte), "RESERVE4" 
    VARCHAR2(500 byte), "PIC1" VARCHAR2(500 byte), "PIC2" 
    VARCHAR2(500 byte), "PIC3" VARCHAR2(500 byte), "PIC4" 
    VARCHAR2(500 byte), "PIC5" VARCHAR2(500 byte), "RESERVE5" 
    VARCHAR2(500 byte), "RESERVE6" VARCHAR2(500 byte), "RESERVE7"
    VARCHAR2(500 byte), "RESERVE8" VARCHAR2(500 byte), "RESERVE9"
    VARCHAR2(500 byte), "SELLNUM1" NUMBER(10), "SELLNUM2" 
    NUMBER(10), "SELLNUM3" NUMBER(10), "SELLNUM4" NUMBER(10), 
    "SELLNUM5" NUMBER(10), "SELLNUM6" NUMBER(10), "FLAG" 
    VARCHAR2(100 byte), "DESCR" VARCHAR2(1000 byte), "OPER" 
    VARCHAR2(50 byte), "OPERTYPR" VARCHAR2(50 byte), "OPERTIME" 
    DATE, "CONTENT" VARCHAR2(2000 byte), 
    CONSTRAINT "PK_DB_ENDPRODUCT_ONLINELOG" PRIMARY 
    KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING ;
COMMENT ON TABLE "DB_ENDPRODUCT_ONLINELOG" IS '店铺下线商品日志'

update db_purchase set discount4 = 0 where discount4 is null;
update db_menufunc set url = '/eshop/ebay.do?method=uploadfile&flag=1' where funname = '上传EBAY订单'

CREATE OR REPLACE PROCEDURE "PROC_MOVE_TEMP_TO_ORDER"   (
    v_groupid              in  varchar2,
    v_RESULT               out varchar2,
    v_DESCR                  out varchar2
)
--Version 1.0
--2011-12-10 by qinli xubo yanghua
--本过程实现将db_order_temp临时表中的数据整理导入正式表db_order,db_sell
--本过程在解析完CSV/XLS订单文件后被调用
As
   v_sequenceid    varchar2(50):='';
   v_tradeid        varchar2(200):='';
   v_customerid        varchar2(200):='';
   v_customername        varchar2(200):='';
   v_customertel        varchar2(200):='';
   v_customeremail        varchar2(200):='';
   v_customeraddress1        varchar2(200):='';
   v_customeraddress2        varchar2(200):='';
   v_customercity        varchar2(200):='';
   v_customerprovince        varchar2(200):='';
   v_customerzipcode        varchar2(200):='';
   v_customercountry        varchar2(200):='';
   v_productid        varchar2(200):='';
   v_ordernum        varchar2(200):='';
   v_sellpricestr        varchar2(200):='';
   v_expressstr        varchar2(200):='';
   v_paypalid        varchar2(200):='';
   v_transactionid        varchar2(200):='';
   v_variationdetails        varchar2(200):='';
   v_productname        varchar2(200):='';
   v_itemid        varchar2(200):='';
   v_insurance        varchar2(200):='';
   v_postageservice        varchar2(200):='';
   v_sline    varchar2(2000):='';
   v_recordnum    number(10):=0;
   v_oper    varchar2(50):='';
   v_shopid    varchar2(50):='';
   v_shopname    varchar2(100):='';
   v_shopitemid    varchar2(100):='';
   v_checkflag    varchar2(10):='';
   v_errorinfo    varchar2(500):='';
   v_moneytype    varchar2(100):='';
   v_moneyrate    number(10,4):='';
   v_originsellprice    number(14,4):=0;
   v_rmbsellprice    number(12,4):=0;
   v_rmbamount    number(12,4):=0;
   v_originexpress    number(14,4):=0;
   v_rmbexpressmoney    number(12,4):=0;
   v_insurancemoney    number(14,4):=0;
   v_rmbinsurancemoney    number(12,4):=0;
   v_corpid    varchar2(100):='';
   v_orderid  varchar2(100):='';
   v_pickupoper   varchar2(100):='';--配货
   v_packagingid   varchar2(100):='';--包材id
   v_packagingname   varchar2(200):='';--包材name
   v_packagingweight  number(14,4):=0;--包材重量
   v_packagingclass   varchar2(100):='';--包材级别

   v_status varchar2(100):= '';--订单--
   v_orderExist   number(2):=0;--判断订单是否存在
   v_productExist   number(4):=0;--判断产品是否存在
   v_sellExist     number(4):=0;--判断订单明细是否存在
   v_bindFlag   number(4):=0;--是否捆绑商品
   v_costprice number(12,4):=0; --成本
   v_bindproductid  varchar2(100):= '';--捆绑子商品id
   v_bindproductname varchar2(100):= '';--捆绑子商品名--
   v_bindcostprice  number(12,4):=0; --捆绑子商品成本价
   v_bindCount number(4):=0;--遍历绑定商品的次--
   v_bindnum  number(6):=0;--捆绑个数--
   v_sql_bindlist varchar2(2048) := '';
   v_shoppl varchar2(200) :='';--订单平台（shiliang添加--
   --该游标用于遍历db_order_temp每条checkflag=0的记录(checkflag=1表示验证不通过),按recordnum排序（史亮添加field25--
   cursor c_rec is select sequenceid,tradeid,customerid,customername,customertel,customeremail,customeraddress1,customeraddress2,customercity,customerprovince,customerzipcode,customercountry,productid,ordernum,sellpricestr,expressstr,paypalid,transactionid,variationdetails,productname,itemid,insurance,postageservice,sline,recordnum,oper,shopid,shopname,shopitemid,checkflag,errorinfo,moneytype,moneyrate,originsellprice,rmbsellprice,rmbamount,originexpress,rmbexpressmoney,insurancemoney,rmbinsurancemoney,corpid,field25 from db_order_temp where checkflag='0' and groupid=v_groupid order by recordnum;

   TYPE REF_CURSOR IS REF CURSOR;
   c_bindlist REF_CURSOR;
begin
     open c_rec;
     loop
        <<c_rec_mark>>
        fetch c_rec into v_sequenceid,v_tradeid,v_customerid,v_customername,v_customertel,v_customeremail,v_customeraddress1,v_customeraddress2,v_customercity,v_customerprovince,v_customerzipcode,v_customercountry,v_productid,v_ordernum,v_sellpricestr,v_expressstr,v_paypalid,v_transactionid,v_variationdetails,v_productname,v_itemid,v_insurance,v_postageservice,v_sline,v_recordnum,v_oper,v_shopid,v_shopname,v_shopitemid,v_checkflag,v_errorinfo,v_moneytype,v_moneyrate,v_originsellprice,v_rmbsellprice,v_rmbamount,v_originexpress,v_rmbexpressmoney,v_insurancemoney,v_rmbinsurancemoney,v_corpid,v_shoppl;
        exit when c_rec%notfound;
            v_orderExist := 0;
            -----------开始处理每行数据------------------------
            --第一步验证是否入db_order
            if length(v_customername) > 0 then  ----需要插入db_order
                  --是否存在同tradeid,同shopid的记
                  select count(*) into v_orderExist from db_order where tradeid=v_tradeid and shoptypeid = v_shopid;
                  if v_orderExist > 0 then  --如果订单存在
                     update db_order_temp set checkflag='0',errorinfo='订单已重复导入' where sequenceid = v_sequenceid;
                     commit;
                  else   --如果订单不存在,则插入订
                     if length(v_paypalid) > 0 then
                        v_status := '已支付';
                     else
                        v_status := '新订单';
                     end if;
                     --插入订单
                     insert into db_order (orderid,corpid,tradeid,groupid,customerid,customername,customertype,customertel1,customeremail,customercountry,customerprovince,customercity,customeraddress,customerzipcode,shoptypeid,shoptype,moneytype,moneyask,moneyaction,moneyexpressask,ordertime,uploadtime,paytime,expressweight,payoper,oper,opertime,status,insurance,postageservice,reserve20)
                        values(v_sequenceid,v_corpid,v_tradeid,v_groupid,v_customerid,v_customername,v_shopname,v_customertel,v_customeremail,v_customercountry,v_customerprovince,v_customercity,v_customeraddress1,v_customerzipcode,v_shopid,v_shopname,v_moneytype,0,0,v_rmbexpressmoney,sysdate,sysdate,null,0,null,v_oper,sysdate,v_status,v_rmbinsurancemoney,v_postageservice,v_shoppl);

                     commit;
                  end if;

                  if v_productid is null or length(v_productid) <= 0 then --如果无产品ID,意味着是多订单集合的第一条,仅需要插入db_order
                     update db_order_temp set checkflag='2' where checkflag='0' and sequenceid = v_sequenceid;
                     commit;
                  else --否则,还需要插入db_sell
                     --找到同tradeid,同shopid的订单,并取得对应订单id
                     begin
                        select orderid into v_orderid from db_order where tradeid=v_tradeid and shoptypeid = v_shopid;
                        --验证DbSell是否重复导入(验证条件:是否存在同店铺,同tradeid,同transactionid记录)
                        v_sellExist := 0;
                        select count(*) into v_sellExist from db_sell where tradeid=v_tradeid and shoptype=v_shopname and transactionid=v_transactionid;
                        if v_sellExist > 0 then   --DbSell已存
                            update db_order_temp set checkflag='1',errorinfo='订单已重复导入~' where sequenceid = v_sequenceid;
                            commit;
                        else
                            ------------------------验证产品------------------------------
                            -------------第一步:验证是否捆绑商品--------------------------
                            v_bindFlag := 0;
                            select count(*) into v_bindFlag from db_bindlist where bindid=v_productid;
                            if v_bindFlag > 0 then--如果是捆绑商
                                v_bindCount := 0;
                                v_bindFlag := 1;
                                v_sql_bindlist := 'select a.alias1,a.num,b.name,b.costprice,b.oper2,b.packagingid,b.packagingname,b.packagingweight,b.iclass from db_bindlist a left join db_product b on a.alias1= b.sid where a.bindid='''|| v_productid ||'''';
                                open c_bindlist for v_sql_bindlist;
                                loop
                                   <<c_bindlist_mark>>
                                      v_bindproductid := '';
                                      v_bindnum := 1;
                                      v_bindproductname := '';
                                      v_bindcostprice := 0;
                                   fetch c_bindlist into v_bindproductid,v_bindnum,v_bindproductname,v_bindcostprice,v_pickupoper,v_packagingid,v_packagingname,v_packagingweight,v_packagingclass;
                                   exit when c_bindlist%notfound;
                                      v_bindCount := v_bindCount +1;
                                      --遍历每一个捆绑子商品--
                                      if length(v_bindproductname) > 0 then  --如果有v_bindproductname,则表示商品存--
                                          --DbSell入库--
                                          insert into db_sell (sid,corpid,orderid,productid,productname,ordernum,costprice,sellprice,amount,customerid,ordertime,alertflag,shoptype,updateflag,oper,opertime,flag,descr2,originsellprice,moneytype,tradeid,transactionid,groupid,shoptypeid,ebayitemid,finalvaluefee,feedback,oper1,packagingid,packagingname,packagingweight,packagingclass,reserve10)
                                              values(v_groupid||v_recordnum||v_bindCount,v_corpid,v_orderid,v_bindproductid,v_bindproductname,v_ordernum*v_bindnum,v_bindcostprice,v_rmbsellprice/v_bindnum,v_rmbamount,v_customerid,sysdate,0,v_shopname,'0',v_oper,sysdate,'1',v_variationdetails,v_originsellprice/v_bindnum,v_moneytype,v_tradeid,v_transactionid,v_groupid,v_shopid,v_itemid,'0','0',v_pickupoper,v_packagingid,v_packagingname,v_packagingweight,v_packagingclass,v_shoppl);

                                          --一个绑定商品可能绑定多个子商品,则将售价全部赋予给第1个商品,第2个商品售价为0--
                                          v_rmbsellprice := 0;
                                          v_rmbamount := 0;
                                          v_originsellprice := 0;
                                          --更新DbOrder的配送工
                                          update db_order set oper1=v_pickupoper where orderid=v_orderid and oper1 is null;
                                          commit;
                                      end if;
                                end loop;
                                close c_bindlist;

                                update db_order_temp set checkflag='2' where checkflag='1' and sequenceid = v_sequenceid;
                                commit;
                            else  ---如果不是捆绑商品--------
                                --验证产品是否存在,如果不存在,则创建商品-----------
                                v_productExist := 0;
                                select count(*) into v_productExist from db_product where (sid=v_productid or alias1 like '%,'||v_productid||',%') and corpid=v_corpid;
                                if v_productExist <= 0 then
                                   insert into db_product (sequenceid,sid,corpid,name,descr,status,stockprice,costprice,sellprice,batchprice1,weight,buynum,savenum,ordernum,alertnum,openflag,oper,opertime)
                                   values(v_productid,v_productid,v_corpid,nvl(v_productname,'新创建,无商品名称'),'订单导入时自动创建','正常',0,0,v_rmbsellprice,0,0,0,0,0,0,'1',v_oper,sysdate);
                                   commit;
                                end if;-----创建商品
                                --获取商品信息
                                v_costprice := 0;
                                v_pickupoper :='';
                                select sid,name,costprice,oper2,packagingid,packagingname,packagingweight,iclass into v_productid,v_productname,v_costprice,v_pickupoper,v_packagingid,v_packagingname,v_packagingweight,v_packagingclass from db_product where (sid=v_productid or alias1 like '%,'||v_productid||',%') and corpid=v_corpid;

                                --DbSell入库
                                insert into db_sell (sid,corpid,orderid,productid,productname,ordernum,costprice,sellprice,amount,customerid,ordertime,alertflag,shoptype,updateflag,oper,opertime,flag,descr2,originsellprice,moneytype,tradeid,transactionid,groupid,shoptypeid,ebayitemid,finalvaluefee,feedback,oper1,packagingid,packagingname,packagingweight,packagingclass,reserve10)
                                   values(v_groupid||v_recordnum,v_corpid,v_orderid,v_productid,v_productname,v_ordernum,v_costprice,v_rmbsellprice,v_rmbamount,v_customerid,sysdate,0,v_shopname,'0',v_oper,sysdate,'1',v_variationdetails,v_originsellprice,v_moneytype,v_tradeid,v_transactionid,v_groupid,v_shopid,v_itemid,'0','0',v_pickupoper,v_packagingid,v_packagingname,v_packagingweight,v_packagingclass,v_shoppl);

                                update db_order_temp set checkflag='2' where checkflag='0' and sequenceid = v_sequenceid;
                                commit;

                                --更新DbOrder的配送工--
                                update db_order set oper1=v_pickupoper where orderid=v_orderid and oper1 is null;
                                commit;
                            end if;
                        end if;
                     exception
                     when no_data_found then
                         update db_order_temp set checkflag='1',errorinfo='找不到OrderID~' where sequenceid = v_sequenceid;
                         commit;
                     when others then
                         update db_order_temp set checkflag='1',errorinfo='订单处理异常BBB,' where sequenceid = v_sequenceid;
                         commit;
                     end;
                  end if;

                  update db_order_temp set checkflag='2' where checkflag='0' and sequenceid = v_sequenceid;
                  commit;
            else    ---不需要入db_order,只需要入db_sell
                  if v_productid is null or length(v_productid) <= 0 then --如果无产品ID,则导入不成功
                     update db_order_temp set checkflag='1',errorinfo='产品ID不存在' where checkflag='0' and sequenceid = v_sequenceid;
                     commit;
                  else --否则,还需要插入db_sell
                     --找到对应db_order中的订单id
                     begin
                        select orderid into v_orderid from db_order where tradeid=v_tradeid and shoptypeid = v_shopid;
                        --验证DbSell是否重复导入(验证条件:是否存在同店铺,同tradeid,同transactionid,但不同批次的记录)
                        v_sellExist := 0;
                        select count(*) into v_sellExist from db_sell where tradeid=v_tradeid and shoptype=v_shopname and transactionid=v_transactionid and groupid != v_groupid;
                        if v_sellExist > 0 then   --DbSell已存--
                            update db_order_temp set checkflag='1',errorinfo='订单已重复导入~~' where sequenceid = v_sequenceid;
                            commit;
                        else
                            ------------------------验证产品------------------------------
                            -------------第一步:验证是否捆绑商品--------------------------
                            v_bindFlag := 0;
                            select count(*) into v_bindFlag from db_bindlist where bindid=v_productid;
                            if v_bindFlag > 0 then--如果是捆绑商--
                                v_bindCount := 0;
                                v_bindFlag := 1;
                                v_sql_bindlist := 'select a.alias1,a.num,b.name,b.costprice,b.oper2,b.packagingid,b.packagingname,b.packagingweight,b.iclass from db_bindlist a left join db_product b on a.alias1= b.sid where a.bindid='''|| v_productid ||'''';
                                open c_bindlist for v_sql_bindlist;
                                loop
                                   <<c_bindlist_mark>>
                                      v_bindproductid := '';
                                      v_bindnum := 1;
                                      v_bindproductname := '';
                                      v_bindcostprice := 0;
                                   fetch c_bindlist into v_bindproductid,v_bindnum,v_bindproductname,v_bindcostprice,v_pickupoper,v_packagingid,v_packagingname,v_packagingweight,v_packagingclass;
                                   exit when c_bindlist%notfound;
                                      v_bindCount := v_bindCount +1;
                                      --遍历每一个捆绑子商品
                                      if length(v_bindproductname) > 0 then  --如果有v_bindproductname,则表示商品存?                                          --DbSell入库
                                          insert into db_sell (sid,corpid,orderid,productid,productname,ordernum,costprice,sellprice,amount,customerid,ordertime,alertflag,shoptype,updateflag,oper,opertime,flag,descr2,originsellprice,moneytype,tradeid,transactionid,groupid,shoptypeid,ebayitemid,finalvaluefee,feedback,oper1,packagingid,packagingname,packagingweight,packagingclass,reserve10)
                                              values(v_groupid||v_recordnum||v_bindCount,v_corpid,v_orderid,v_bindproductid,v_bindproductname,v_ordernum*v_bindnum,v_bindcostprice,v_rmbsellprice/v_bindnum,v_rmbamount,v_customerid,sysdate,0,v_shopname,'0',v_oper,sysdate,'1',v_variationdetails,v_originsellprice/v_bindnum,v_moneytype,v_tradeid,v_transactionid,v_groupid,v_shopid,v_itemid,'0','0',v_pickupoper,v_packagingid,v_packagingname,v_packagingweight,v_packagingclass,v_shoppl);

                                          --一个绑定商品可能绑定多个子商品,则将售价全部赋予给第1个商品,第2个商品售价为0
                                          v_rmbsellprice := 0;
                                          v_rmbamount := 0;
                                          v_originsellprice := 0;

                                          --更新DbOrder的配送工--
                                          update db_order set oper1=v_pickupoper where orderid=v_orderid and oper1 is null;
                                          commit;
                                      end if;
                                end loop;
                                close c_bindlist;

                                update db_order_temp set checkflag='2' where checkflag='1' and sequenceid = v_sequenceid;
                                commit;
                            else  ---如果不是捆绑商品--------
                                --验证产品是否存在,如果不存在,则创建商品-----------
                                v_productExist := 0;
                                select count(*) into v_productExist from db_product where (sid=v_productid or alias1 like '%,'||v_productid||',%') and corpid=v_corpid;
                                if v_productExist <= 0 then
                                   insert into db_product (sequenceid,sid,corpid,name,descr,status,stockprice,costprice,sellprice,batchprice1,weight,buynum,savenum,ordernum,alertnum,openflag,oper,opertime)
                                   values(v_productid,v_productid,v_corpid,v_productname,'订单导入时自动创建','正常',0,0,v_rmbsellprice,0,0,0,0,0,0,'1',v_oper,sysdate);
                                   commit;
                                end if;-----创建商品--
                                --获取商品信息--
                                v_costprice := 0;
                                v_pickupoper :='';
                                select sid,name,costprice,oper2,packagingid,packagingname,packagingweight,iclass into v_productid,v_productname,v_costprice,v_pickupoper,v_packagingid,v_packagingname,v_packagingweight,v_packagingclass from db_product where (sid=v_productid or alias1 like '%,'||v_productid||',%') and corpid=v_corpid;

                                --DbSell入库--
                                insert into db_sell (sid,corpid,orderid,productid,productname,ordernum,costprice,sellprice,amount,customerid,ordertime,alertflag,shoptype,updateflag,oper,opertime,flag,descr2,originsellprice,moneytype,tradeid,transactionid,groupid,shoptypeid,ebayitemid,finalvaluefee,feedback,oper1,packagingid,packagingname,packagingweight,packagingclass,reserve10)
                                   values(v_groupid||v_recordnum,v_corpid,v_orderid,v_productid,v_productname,v_ordernum,v_costprice,v_rmbsellprice,v_rmbamount,v_customerid,sysdate,0,v_shopname,'0',v_oper,sysdate,'1',v_variationdetails,v_originsellprice,v_moneytype,v_tradeid,v_transactionid,v_groupid,v_shopid,v_itemid,'0','0',v_pickupoper,v_packagingid,v_packagingname,v_packagingweight,v_packagingclass,v_shoppl);

                                update db_order_temp set checkflag='2' where checkflag='0' and sequenceid = v_sequenceid;
                                commit;

                                --更新DbOrder的配送工--
                                update db_order set oper1=v_pickupoper where orderid=v_orderid and oper1 is null;
                                commit;
                            end if;
                        end if;
                     exception
                     when no_data_found then
                         update db_order_temp set checkflag='1',errorinfo='找不到OrderID!' where sequenceid = v_sequenceid;
                         commit;
                     when others then
                         update db_order_temp set checkflag='1',errorinfo='订单处理异常AAA,' where sequenceid = v_sequenceid;
                         commit;
                     end;
                  end if;

                  update db_order_temp set checkflag='2' where checkflag='0' and sequenceid = v_sequenceid;
                  commit;
            end if;
     end loop;
     close c_rec;

     commit;--提交-----
     v_RESULT :='0';
     v_DESCR := '操作成功';
     return;
exception
when others then
      --dbms_output.put_line(sqlcode||':'||sqlerrm);
      v_RESULT:='1';
      v_DESCR:='未知错误';
     return;
end;


---------------------20120911----------------------------
alter table db_order modify CUSTOMERADDRESS VARCHAR2(1000);
alter table db_order_temp modify CUSTOMERADDRESS1 VARCHAR2(1000);

---------------------20120910----------------------------
alter table db_product_online add sellnum1 number(10);
alter table db_product_online add sellnum2 number(10);
alter table db_product_online add sellnum3 number(10);
alter table db_product_online add sellnum4 number(10);
alter table db_product_online add sellnum5 number(10);
alter table db_product_online add sellnum6 number(10);

alter table db_product_online modify RESERVE9 varchar2(4000);

---------------------20120905----------------------------
alter table db_order modify OPER1 VARCHAR2(1000);
alter table db_order modify OPER2 VARCHAR2(1000);

insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)
values ('320', '在线产品维护', '在线产品维护', '/eshop/product.do?method=productonlinelist', 0, 0, '4', 122, 5, '#FFFFFF', null, null, null, null);

---------------------20120901----------------------------
CREATE TABLE "DB_SCANORDER" ("ORDERID" VARCHAR2(50 byte)
    NOT NULL, "EXPRESSTYPEID" VARCHAR2(100 byte), "EXPRESSTYPE" 
    VARCHAR2(400 byte), "EXPRESSID" VARCHAR2(100 byte), 
    "ORDERWEIGHT" NUMBER(10, 2), "OPER" VARCHAR2(50 byte), 
    "OPERTIME" DATE, "FLAG" VARCHAR2(10 byte), "MAILFLAG" 
    VARCHAR2(10 byte), "RESERVE1" VARCHAR2(1000 byte), "RESERVE2"
    VARCHAR2(200 byte), "RESERVE3" VARCHAR2(200 byte), "GROUPID" 
    VARCHAR2(50 byte), 
    CONSTRAINT "PK_SCANORDERID" PRIMARY KEY("ORDERID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 

---------------------20120822----------------------------
alter table DB_orderlog modify RESERVE3 varchar2(2000);
alter table DB_orderlog modify RESERVE5 varchar2(2000);
alter table DB_MANUFACTURE modify FILED1 VARCHAR2(4000);
alter table DB_MANUFACTURE modify FILED2 VARCHAR2(4000);
alter table DB_MANUFACTURE modify FILED3 VARCHAR2(4000);
alter table DB_MANUFACTURE modify FILED4 VARCHAR2(4000);
alter table DB_MANUFACTURE modify FILED5 VARCHAR2(4000);

alter table db_product add PACKAGINGFEE NUMBER(8,4);
alter table db_sell add PACKAGINGFEE NUMBER(8,4);
alter table db_sell add SPLITPACKAGINGFEE NUMBER(8,4);
alter table db_order add PACKAGINGFEE NUMBER(8,4);
alter table db_selltostat add OUTPACKAGINGFEE NUMBER(8,4);
update db_product set PACKAGINGFEE='0';
update db_sell set PACKAGINGFEE='0';
update db_sell set SPLITPACKAGINGFEE='0';
update db_order set PACKAGINGFEE='0';
update db_selltostat set OUTPACKAGINGFEE='0';

alter table DB_PURCHASEQUESTION add creatoper varchar2(100);
alter table DB_PURCHASEQUESTION modify RESERVE3 varchar2(4000);
alter table DB_PURCHASEHAND modify RESERVE3 varchar2(4000);
alter table db_order add PRINTTIME date;
alter table db_order_history add PRINTTIME date;

---------------------20120818---------------------------
alter table DB_orderlog modify RESERVE3 varchar2(2000);
alter table DB_orderlog modify RESERVE5 varchar2(2000);

---------------------20120816---------------------------
alter table DB_MANUFACTURE modify FILED1 VARCHAR2(4000);
alter table DB_MANUFACTURE modify FILED2 VARCHAR2(4000);
alter table DB_MANUFACTURE modify FILED3 VARCHAR2(4000);
alter table DB_MANUFACTURE modify FILED4 VARCHAR2(4000);
alter table DB_MANUFACTURE modify FILED5 VARCHAR2(4000);
----------------------20120815---------------------
alter table DB_PRODUCT_ONLINE add pic1 VARCHAR2(500);
alter table DB_PRODUCT_ONLINE add pic2 VARCHAR2(500);
alter table DB_PRODUCT_ONLINE add pic3 VARCHAR2(500);
alter table DB_PRODUCT_ONLINE add pic4 VARCHAR2(500);
alter table DB_PRODUCT_ONLINE add pic5 VARCHAR2(500);
alter table DB_PRODUCT_ONLINE modify PRODUCTNAME VARCHAR2(500);
alter table DB_PRODUCT_ONLINE modify RESERVE1 VARCHAR2(500);
alter table DB_PRODUCT_ONLINE modify RESERVE2 VARCHAR2(500);
alter table DB_PRODUCT_ONLINE modify RESERVE3 VARCHAR2(500);
alter table DB_PRODUCT_ONLINE modify RESERVE4 VARCHAR2(500);
alter table DB_PRODUCT_ONLINE add RESERVE5 VARCHAR2(500);
alter table DB_PRODUCT_ONLINE add RESERVE6 VARCHAR2(500);
alter table DB_PRODUCT_ONLINE add RESERVE7 VARCHAR2(500);
alter table DB_PRODUCT_ONLINE add RESERVE8 VARCHAR2(500);
alter table DB_PRODUCT_ONLINE add RESERVE9 VARCHAR2(500);
alter table db_purchase add paymenttype varchar2(200);

CREATE INDEX "PK_DBSELL_ORDERID" 
    ON "DB_SELL"  ("ORDERID") 
    TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 2 MAXTRANS 255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1) 
    LOGGING

---------------------20120809----------------------
alter table db_ordersearch add ORDERMONEY1 varchar2(50);
alter table db_ordersearch add ORDERMONEY2 varchar2(50);
alter table db_ordersearch add ORDERMONEYFLAG varchar2(50);

---------------------20120807----------------------
alter table db_ordersearch add STORAGE varchar2(4000);
alter table db_ordersearch add STORAGEFLAG varchar2(50);
alter table db_ordersearch add ORIGINORDERMONEY1 varchar2(50);
alter table db_ordersearch add ORIGINORDERMONEY2 varchar2(50);
alter table db_ordersearch add ORIGINORDERMONEYFLAG varchar2(50);

-------------20120730---------------------
alter table db_order_temp add ebaycustomeraddress varchar2(4000);
alter table db_purchase modify reserve3 varchar2(500);


---------------20120728--------------------
CREATE TABLE "ESHOP"."DB_PRODUCT_TITLELOG" ("SEQUENCEID" 
    VARCHAR2(100 byte) NOT NULL, "SID" VARCHAR2(500 byte), 
    "TITLE" VARCHAR2(1000 byte), "QTY" VARCHAR2(100 byte), "OPER"
    VARCHAR2(100 byte), "OPERTIME" DATE, "FILED1" VARCHAR2(500 
    byte), "FILED2" VARCHAR2(500 byte), "FILED3" VARCHAR2(500 
    byte), "FILED4" NUMBER(10), "FILED5" NUMBER(10), "DESCR" 
    VARCHAR2(4000 byte), 
    CONSTRAINT "PK_TITLE_LOG" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 

----------------20120727---------------
305	商品网名管理	商品网名管理	/eshop/product.do?method=titlelist	0	0	4	122	3	#FFFFFF				
306	增加商品网名	增加商品网名	/eshop/product.do?method=addtitle	0	0	4	122	3	#FFFFFF				

CREATE TABLE "ESHOP"."DB_PRODUCT_TITLE" ("SEQUENCEID" 
    VARCHAR2(100 byte) NOT NULL, "TITLE" VARCHAR2(500 byte), 
    "SID" VARCHAR2(500 byte), "QTY" VARCHAR2(500 byte), "OPER" VARCHAR2(50
    byte), "OPERTIME" DATE, "FILED1" VARCHAR2(100 byte), "FILED2"
    VARCHAR2(500 byte), "FILED3" VARCHAR2(500 byte), "FILED4" 
    NUMBER(10), "FILED5" NUMBER(10), 
    CONSTRAINT "PK_PRODUCT_TITLE" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 

-----------------20120725-----------
drop table db_paypal;
CREATE TABLE "ESHOP"."DB_PAYPAL" ("SEQUENCEID" VARCHAR2(50 byte) 
    NOT NULL, "TRANSACTIONID" VARCHAR2(100 byte) NOT NULL, 
    "ADDRESS" VARCHAR2(4000 byte), "OPER" VARCHAR2(50 byte), 
    "OPERTIME" DATE, "EMAILADDRESS" VARCHAR2(400 byte), "STATUS" 
    VARCHAR2(400 byte), "FEEAMOUNT" NUMBER(10, 4), "GROSSAMOUNT" 
    NUMBER(10, 4), "NETAMOUNT" NUMBER(10, 4), "PAYTIME" DATE, 
    "FILED1" VARCHAR2(4000 byte), "FILED2" VARCHAR2(4000 byte), 
    "FILED3" NUMBER(8, 2), "FILED4" NUMBER(8, 2), "CORPID" 
    VARCHAR2(50 byte), "OPENFLAG" VARCHAR2(10 byte), 
    "CUSTOMERPROVINCE" VARCHAR2(1000 byte), "CUSTOMERCITY" 
    VARCHAR2(1000 byte), "CUSTOMERCOUNTRY" VARCHAR2(1000 byte), 
    "CUSTOMERSTREET" VARCHAR2(1000 byte), "APIUSER" VARCHAR2(1000
    byte), "APIPASSWORD" VARCHAR2(1000 byte), "APITOKEN" 
    VARCHAR2(1000 byte), "FILED5" VARCHAR2(4000 byte), "FILED6" 
    VARCHAR2(4000 byte), "FILED7" VARCHAR2(4000 byte), "FILED8" 
    VARCHAR2(4000 byte), "FILED9" VARCHAR2(4000 byte), "FILED10" 
    VARCHAR2(4000 byte), "FILED11" NUMBER(10, 2), "FILED12" 
    NUMBER(10, 2), "FILED13" NUMBER(10, 2), 
    "PAYPALCUSTOMERADDRESS" VARCHAR2(4000 byte), 
    CONSTRAINT "PK_DB_PAYPAL" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING ;
COMMENT ON TABLE "ESHOP"."DB_PAYPAL" IS 'paypal鏁版嵁';
COMMENT ON COLUMN "ESHOP"."DB_PAYPAL"."OPENFLAG" IS '0表示关闭
1表示开通'


==================20120724============-======
alter table db_product modify hjreserve8 number(8);        
alter table db_product modify hjreserve9 number(8);
alter table db_product modify hjreserve10 number(8);
==================20120723==============================
alter table db_purchase add sevennum number(8);
alter table db_purchase add threenum number(8);
alter table db_purchase add ninenum number(8);

========================================================
alter table DB_purchase add creatoper varchar2(100);
alter table DB_purchase add creatdate date;
===========================================================
alter table db_ordersearch add FILED21 varchar2(500);
alter table db_ordersearch add FLAG21 varchar2(50);
alter table db_order add paypalflag varchar2(10);
alter table db_order_history add paypalflag varchar2(10);
create table DB_REASON  (
   SEQUENCEID           VARCHAR2(50)                    not null,
   DESCR                VARCHAR2(500),
   constraint PK_DB_REASON primary key (SEQUENCEID)
)
pctfree 10
initrans 1
maxtrans 255
storage
(
    initial 64K
    minextents 1
    maxextents unlimited
)
tablespace ZHRGPT
logging
noparallel;


===================================================================
create table DB_REFUNDPAYPALLOG  (
   SEQUENCEID           VARCHAR2(50)                    not null,
   ORDERID              VARCHAR2(100),
   PAYPALID             VARCHAR2(100),
   USERNAME             VARCHAR2(100),
   PASSWORD             VARCHAR2(100),
   PAYPALTOKEN          VARCHAR2(2000),
   REFUNDTYPE           VARCHAR2(50),
   MONRYTYPE            VARCHAR2(50),
   NOTE                 VARCHAR2(2000),
   REFUNDMONEY          NUMBER(10,2),
   OPER                 VARCHAR2(100),
   CREATETIME           DATE,
   CHECKTIME            DATE,
   CHECKTIME1           DATE,
   REFUNDTIME           DATE,
   OPERTIME             DATE,
   REFUNDRESULT         VARCHAR2(50),
   ERRORREASON          VARCHAR2(2000),
   MONEYTYPE            NUMBER(10,2),
   REMONEY              NUMBER(10,4),
   CREATEOPER           VARCHAR2(100),
   CHECKOPER            VARCHAR2(100),
   CHECKOPER1           VARCHAR2(100),
   CORPID               VARCHAR2(50),
   FLAG                 VARCHAR2(100),
   OPENFLAG             VARCHAR2(100),
   RESERVE1             VARCHAR2(400),
   RESERVE2             VARCHAR2(400),
   RESERVE3             VARCHAR2(400),
   RESERVE4             VARCHAR2(400),
   RESERVE5             VARCHAR2(2000),
   RESERVE6             VARCHAR2(2000),
   RESERVE7             NUMBER(10,4),
   RESERVE8             NUMBER(10,4),
   RESERVE9             NUMBER(10,4),
   RESERVE10            NUMBER(10,4),
   OPERTYPE             VARCHAR2(50),
   CONTENT              VARCHAR2(2000),
   constraint PK_DB_REFIYNDPAYPALLOG primary key (SEQUENCEID)
)
pctfree 10
initrans 1
maxtrans 255
storage
(
    initial 64K
    minextents 1
    maxextents unlimited
)
tablespace ZHRGPT
logging
noparallel;


====================================================================
create table DB_REFUNDPAYPAL  (
   SEQUENCEID           VARCHAR2(50)                    not null,
   ORDERID              VARCHAR2(100),
   PAYPALID             VARCHAR2(100),
   USERNAME             VARCHAR2(100),
   PASSWORD             VARCHAR2(100),
   PAYPALTOKEN          VARCHAR2(2000),
   REFUNDTYPE           VARCHAR2(50),
   MONEYTYPE            VARCHAR2(50),
   NOTE                 VARCHAR2(2000),
   REFUNDMONEY          NUMBER(10,2),
   CREATETIME           DATE,
   CHECKTIME            DATE,
   CHECKTIME1           DATE,
   REFUNDTIME           DATE,
   OPERTIME             DATE,
   REFUNDRESULT         VARCHAR2(50),
   ERRORREASON          VARCHAR2(2000),
   MONEYRATE            NUMBER(10,2),
   REMONEY              NUMBER(10,4),
   OPER                 VARCHAR2(100),
   CREATEOPER           VARCHAR2(100),
   CHECKOPER            VARCHAR2(100),
   CHECKOPER1           VARCHAR2(100),
   CORPID               VARCHAR2(50),
   FLAG                 VARCHAR2(100),
   OPENFLAG             VARCHAR2(100),
   RESERVE1             VARCHAR2(400),
   RESERVE2             VARCHAR2(400),
   RESERVE3             VARCHAR2(400),
   RESERVE4             VARCHAR2(400),
   RESERVE5             VARCHAR2(2000),
   RESERVE6             VARCHAR2(2000),
   RESERVE7             NUMBER(10,4),
   RESERVE8             NUMBER(10,4),
   RESERVE9             NUMBER(10,4),
   RESERVE10            NUMBER(10,4),
   constraint PK_DB_REFIYNDPAYPAL primary key (SEQUENCEID)
)
pctfree 10
initrans 1
maxtrans 255
storage
(
    initial 64K
    minextents 1
    maxextents unlimited
)
tablespace ZHRGPT
logging
noparallel;


===================20120706=============================
CREATE TABLE "ESHOP"."DB_PURCHASEHAND" ("SEQUENCEID"
    VARCHAR2(200 byte) NOT NULL, "SID" VARCHAR2(200 byte),
    "PRODUCTID" VARCHAR2(100 byte), "MANUFACTURE" VARCHAR2(200
    byte), "ORDERNUM" NUMBER(6), "INPORTPRICE" NUMBER(10, 2),
    "AMOUNT" NUMBER(10, 2), "INPORTTIME" DATE, "ACTUALNUM"
    NUMBER(6), "ACTUALPRICE" NUMBER(10, 2), "ACTUALAMOUNT"
    NUMBER(10, 2), "STOCKOPER" VARCHAR2(50 byte), "STOCKTIME"
    DATE, "SLEVEL" VARCHAR2(20 byte), "STATUS" VARCHAR2(50 byte),
    "DESCR" VARCHAR2(1000 byte), "OPER" VARCHAR2(100 byte),
    "OPERTIME" DATE, "RESERVE1" VARCHAR2(100 byte), "RESERVE2"
    VARCHAR2(100 byte), "RESERVE3" VARCHAR2(100 byte), "RESERVE4"
    VARCHAR2(100 byte), "RESERVE5" VARCHAR2(100 byte), "NAME"
    VARCHAR2(500 byte), "SAVENUM" NUMBER(6), "CORPID" VARCHAR2(50
    byte), "OPENFLAG" VARCHAR2(10 byte), "MANUFACTUREID"
    VARCHAR2(100 byte), "GROUPID" VARCHAR2(100 byte), "REMARKS"
    VARCHAR2(1024 byte), "RECEIVENUM" NUMBER(6), "RETURNNUM"
    NUMBER(6), "RESULTTYPE" VARCHAR2(100 byte), "RESULT"
    VARCHAR2(2000 byte),
    CONSTRAINT "DB_PURCHASEHAND" PRIMARY KEY("SEQUENCEID")
    USING INDEX
    TABLESPACE "ZHRGPT"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)

    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING


===================20120703=============================
alter table db_paymentset add CREATEOPER VARCHAR2(50);
alter table db_paymentset add CREATEDATE DATE;
alter table db_producttypeset add CREATEOPER VARCHAR2(50);
alter table db_producttypeset add CREATEDATE DATE;

===================20120702=============================
CREATE TABLE "ESHOP"."DB_TRADEFREE" ("SEQUENCEID" VARCHAR2(100)
    NOT NULL, "PLATFORMID" VARCHAR2(50), "PLATFORM" VARCHAR2(100),
    "SALEMETHOD" VARCHAR2(200), "STARPRICE" NUMBER(11, 4),
    "ENDPRICE" NUMBER(11, 4), "EXPRESSION" VARCHAR2(500),
    "REMARK" VARCHAR2(4000), "OPER" VARCHAR2(100), "OPERTIME"
    DATE, "RESERVE1" VARCHAR2(200), "RESERVE2" VARCHAR2(200),
    "RESERVE3" VARCHAR2(200), "RESERVE4" NUMBER(11, 4),
    "RESERVE5" NUMBER(10, 4),
    CONSTRAINT "PK_DB_TRADEFREE" PRIMARY KEY("SEQUENCEID"));

alter table DB_TRADEFREE add CREATEOPER VARCHAR2(50);
alter table DB_TRADEFREE add CREATEDATE DATE;
alter table DB_TRADEFREE add CORPID  varchar2(50);

===================20120701==============================
CREATE TABLE "ESHOP"."DB_PAYMENTSET" (
     "SEQUENCEID" VARCHAR2(100 byte) NOT NULL,
     "PAYMENTNAME" VARCHAR2(100 byte),
     "PAYMENTFORMULA" VARCHAR2(100 byte),
     "OPERTIME" DATE, "OPER" VARCHAR2(100 byte),
     "RESERVE1" VARCHAR2(200 byte), "RESERVE2" VARCHAR2(200 byte),
     "RESERVE3" VARCHAR2(200 byte), "RESERVE4" VARCHAR2(200 byte),
     "RESERVE5" VARCHAR2(200 byte),
     CONSTRAINT "PK_DB_PAYMENTSET" PRIMARY KEY("SEQUENCEID")
);

CREATE TABLE "ESHOP"."DB_PRODUCTTYPESET" (
     "SEQUENCEID" VARCHAR2(100 byte) NOT NULL,
     "SALESPLATFORM" VARCHAR2(100 byte),
     "SORT" VARCHAR2(100 byte),
     "OPERTIME" DATE,
     "OPER" VARCHAR2(100 byte),
     "RESERVE1" VARCHAR2(200 byte),
     "RESERVE2" VARCHAR2(200 byte),
     "RESERVE3" VARCHAR2(200 byte),
     "RESERVE4" VARCHAR2(200 byte),
     "RESERVE5" VARCHAR2(200 byte),
     CONSTRAINT "PK_DB_PRODUCTTYPESET" PRIMARY KEY("SEQUENCEID")
);

alter table db_paymentset add CORPID varchar2(50);
alter table db_producttypeset add CORPID varchar2(50);


alter table db_product add CREATEOPER VARCHAR2(50);
alter table db_product add CREATEDATE DATE;
alter table DB_LOGINFREE add CORPID  varchar2(50);


===================20120630===============================
CREATE TABLE "ESHOP"."DB_LOGINFREE" ("SEQUENCEID" VARCHAR2(100) 
    NOT NULL, "PLATFORMID" VARCHAR2(50), "PLATFORM" VARCHAR2(100),
    "SALEMETHOD" VARCHAR2(200), "STARPRICE" NUMBER(11, 4), 
    "ENDPRICE" NUMBER(11, 4), "EXPRESSION" VARCHAR2(500), 
    "REMARK" VARCHAR2(4000), "OPER" VARCHAR2(100), "OPERTIME" 
    DATE, "RESERVE1" VARCHAR2(200), "RESERVE2" VARCHAR2(200), 
    "RESERVE3" VARCHAR2(200), "RESERVE4" NUMBER(11, 4), 
    "RESERVE5" NUMBER(10, 4), 
    CONSTRAINT "PK_DB_LOGINFREE" PRIMARY KEY("SEQUENCEID"))  
    
alter table DB_LOGINFREE add CREATEOPER VARCHAR2(50);
alter table DB_LOGINFREE add CREATEDATE DATE;
    
alter table db_ebayorderinfo add ebaycustomeraddress varchar2(4000);    
alter table db_paypal add paypalcustomeraddress varchar2(4000);
alter table db_paypal_temp add paypalcustomeraddress varchar2(4000);

====================20120629===========================
CREATE TABLE "ESHOP"."DB_PRODUCT_ONLINE_TEMP" ("SEQUENCEID"
    VARCHAR2(100) NOT NULL, "SID" VARCHAR2(100), "NAMEEN"
    VARCHAR2(4000),
    CONSTRAINT "DB_PRODUCT_ONLINE_TEMP" PRIMARY
    KEY("SEQUENCEID"))

====================20120628==========================
alter table db_sell add orderexpressask number(8,2);
alter table db_sell add orderexpressaction number(8,2);
alter table db_sell_history add orderexpressask number(8,2);
alter table db_sell_history add orderexpressaction number(8,2);

alter table db_sell add totalpaypalfee number(10,4);
alter table db_sell_history add totalpaypalfee number(10,4);
alter table db_product_online add PRODUCTNAMEENGLISH VARCHAR2(1000);
alter table db_product_online add RESERVE4 VARCHAR2(10);

alter table db_sell add moneyexpressask number(8,2);
alter table db_sell add moneyexpressaction number(8,2);
alter table db_sell_history add moneyexpressask number(8,2);
alter table db_sell_history add moneyexpressaction number(8,2);
alter table db_sell add totalweight number(8,2);
alter table db_sell_history add totalweight number(8,2);
alter table db_sell add weightflag varchar2(10);
alter table db_sell_history add weightflag varchar2(10);
alter table db_sell add paypalflag varchar2(10);
alter table db_sell_history add paypalflag varchar2(10);
alter table db_sell_history add totalmoney NUMBER(8,2);
alter table db_sell_history add moneyrate NUMBER(8,6);
alter table db_sell_history add paypalfee NUMBER(8,4);
alter table db_sell_history add weightrate NUMBER(8,6);

alter table db_sell add totalmoney NUMBER(8,2);
alter table db_sell add moneyrate NUMBER(8,6);
alter table db_sell add paypalfee NUMBER(8,4);
alter table db_sell add weightrate NUMBER(8,6);


====================20120627============================
alter table db_order add ebaycustomeraddress varchar2(4000);
alter table db_order add paypalcustomeraddress varchar2(4000);
alter table db_order_history add ebaycustomeraddress varchar2(4000);
alter table db_order_history add paypalcustomeraddress varchar2(4000);
alter table db_order_history add UNITWEIGHT NUMBER(10,4);


---------------------20120623------------------------------
alter table db_product add manufactureprice number(11,4);
alter table db_product add manufactureprice1 number(11,4);
alter table db_product add manufactureprice2 number(11,4);
alter table db_product add tort varchar2(50);
alter table db_product add HJRESERVE1 varchar2(500);
alter table db_product add HJRESERVE2 varchar2(500);
alter table db_product add HJRESERVE3 varchar2(500);
alter table db_product add HJRESERVE4 varchar2(500);
alter table db_product add HJRESERVE5 varchar2(4000);
alter table db_product add HJRESERVE6 varchar2(4000);
alter table db_product add HJRESERVE7 number(11,4);
alter table db_product add HJRESERVE8 number(11,4);
alter table db_product add HJRESERVE9 number(11,4);
alter table db_product add HJRESERVE10 number(11,4);

------------------------------------------------------------------------
update db_product set status='自动创建' where descr like '%自动创建%';
alter table db_product modify DESCR varchar2(4000);
============================20120615======================================
drop table db_paypal;

============================20120614======================================

alter table DB_ORDERSEARCH add filed19 varchar2(500);
alter table DB_ORDERSEARCH add filed20 varchar2(500);
alter table DB_ORDERSEARCH add flag19 varchar2(50);
alter table DB_ORDERSEARCH add flag20 varchar2(50);

==========================================================
alter table db_product add DECLAREDVALUE number(8,4);
alter table db_product_temp add DECLAREDVALUE NUMBER(10,4);


============================20120612======================================
alter table db_product add nameen varchar2(1500);

==============================20120608=============================
alter table DB_BINDLIST add reserve4 number(11,4);
alter table DB_BINDLIST add reserve5 number(11,4);

alter table db_product add savedate number(8);
alter table db_product add savestar date;
alter table db_product add nextsavetime date;

alter table Db_Expresstype add nameen varchar2(100);
==================================20120521=========================
alter table db_product add minalernum number(8);

----------------------------------20120511-----------------------------------------------

alter table db_ordersearch modify filed10 varchar2(4000);


alter table DB_COMPANYCONFIG modify BASEMONEY NUMBER(10,4);
alter table DB_COMPANYCONFIG modify BASEWEIGHT NUMBER(10,4);
alter table DB_COMPANYCONFIG modify UNITMONEY NUMBER(10,4);
alter table DB_COMPANYCONFIG modify UNITWEIGHT NUMBER(10,4);
alter table DB_COMPANYCONFIG modify RESERVE6 NUMBER(11,4);
alter table DB_COMPANYCONFIG modify RESERVE7 NUMBER(11,4);

----------------------------20120509--------------=========================
145	人员营业报表	人员营业报表	/eshop/report.do?menthod=operreport	0	0	7	30	3	#FFFFFF				

------------------------------20120506----------------------
CREATE TABLE "ESHOP"."DB_MYSQL" ("SEQUENCEID" VARCHAR2(100 byte) NOT
    NULL, "DBHOST" VARCHAR2(100 byte), "DBNAME" VARCHAR2(100
    byte), "DBUSERNAME" VARCHAR2(100 byte), "DBPASSWORD"
    VARCHAR2(100 byte), "RESERVE1" VARCHAR2(200 byte), "RESERVE2"
    VARCHAR2(200 byte), "RESERVE3" VARCHAR2(200 byte), "RESERVE4"
    VARCHAR2(200 byte), "RESERVE5" VARCHAR2(200 byte),
    CONSTRAINT "PK_DB_MYSQL" PRIMARY KEY("SEQUENCEID")
    USING INDEX
    TABLESPACE "ZHRGPT"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)

    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING


-----------------------20120504---------------------------
alter table db_order_history modify   CUSTOMERPROVINCE VARCHAR2(500);
alter table db_order modify   CUSTOMERPROVINCE VARCHAR2(500);

CREATE TABLE "ESHOP"."DB_PRODUCTALERT" ("SQUENCEID" VARCHAR2(100 
    byte) NOT NULL, "ALERTSTAR1" NUMBER(8), "ALERTEND1" NUMBER(8),
    "ALERTSTATIC1" NUMBER(10, 2), "ALERTSTAR2" NUMBER(8), 
    "ALERTEND2" NUMBER(8), "ALERTSTATIC2" NUMBER(10, 2), 
    "ALERTSTAR3" NUMBER(8), "ALERTEND3" NUMBER(8), "ALERTSTATIC3"
    NUMBER(10, 2), 
    CONSTRAINT "PK_DB_ALERT" PRIMARY KEY("SQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 
-----------------------------------------------------------------------

