alter table db_spbase add address varchar2(500);
alter table db_spbase add linkman varchar2(50);
alter table db_spbase add tel varchar2(20);
alter table db_spbase add email varchar2(50);
alter table db_spbase add logo varchar2(50);
-----采购表少字段的----
alter table DB_PURCHASE add PURCHASEFLAG NUMBER(22,2);
alter table DB_PURCHASE add SENDTIME DATE;
alter table DB_PURCHASE add SHIPNUM VARCHAR2(50);
alter table DB_PURCHASE add GIFTNUM NUMBER(22,6);
alter table DB_PURCHASE add PAYMENTID NUMBER(22,12);
alter table DB_PURCHASE add RECEIVETIME DATE;
alter table DB_PURCHASE add RECEIVEOPER VARCHAR2(50);
----------------------------------------------------------------------
alter table db_expresstype modify districtcode varchar2(200); 
------------店铺权限字段扩展长度----
alter table db_sysadmin modify IDENTIFYNUM varchar2(200);
----------------物流接口升级-----------
----第一步---
drop table db_expressapi;
----第二步---
CREATE TABLE "DB_EXPRESSAPI" ( "ID" NUMBER(6), "APINAME" VARCHAR2(500) NOT NULL , "SORT" NUMBER(3) NOT NULL , 
"CONTENT" VARCHAR2(500), "OPENFLAG" NUMBER(2) NOT NULL , "OPER" VARCHAR2(50), "OPERTIME" DATE, 
CONSTRAINT "PK_DB_EXPRESSAPI" PRIMARY KEY ("ID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 
STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;
---第三步导入物流表db_expressapi.txt---

 
