---------建表1—DB_FPXCONFIG--------
CREATE TABLE "DB_FPXCONFIG" ( "SID" VARCHAR2(20), "TOKEN" VARCHAR2(200), "SHIPPERNAME" VARCHAR2(100), 
	"SHIPPERCOMPANYNAME" VARCHAR2(200), "SHIPPERADDRESS" VARCHAR2(200), "SHIPPERPOSTCODE" VARCHAR2(50), 
	"SHIPPERTELEPHONE" VARCHAR2(50), "SHIPPERFAX" VARCHAR2(50), "INSURTYPE" VARCHAR2(50), "CARGOCODE" VARCHAR2(50), 
	"PAYMENTCODE" VARCHAR2(50), "INITIALCOUNTRYCODE" VARCHAR2(50), "PRODUCTCODE" VARCHAR2(50), "RESERVE1" VARCHAR2(100), 
	"RESERVE2" VARCHAR2(100), "RESERVE3" VARCHAR2(100), "OPENFLAG" VARCHAR2(10), CONSTRAINT "PK_FPXCONFIG_SID" PRIMARY KEY ("SID") VALIDATE ) 
	TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 
	STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;

----------建表2—DB_FPXCOUNTRY-------
CREATE TABLE "DB_FPXCOUNTRY" ( "SID" VARCHAR2(20), "COUNTRYCN" VARCHAR2(100), "COUNTRYEN" VARCHAR2(100), 
	"OPENFLAG" VARCHAR2(50), CONSTRAINT "PK_FPXCOUNTRY_SID" PRIMARY KEY ("SID") VALIDATE ) 
	TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 
	STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;


----------建表3—DB_FPXEXPRESSTYPE----
CREATE TABLE "DB_FPXEXPRESSTYPE" ( "SID" VARCHAR2(20), "NAME" VARCHAR2(100), "NAMEEN" VARCHAR2(100), 
	"OPENFLAG" VARCHAR2(50), CONSTRAINT "PK_FPXEXPRESSTYPE_SID" PRIMARY KEY ("SID") VALIDATE ) 
	TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 
	STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;

----------建表4—DB_FPXORIGINAREA------
CREATE TABLE "DB_FPXORIGINAREA" ( "SID" VARCHAR2(20), "NAME" VARCHAR2(100), "OPENFLAG" VARCHAR2(50), 
	CONSTRAINT "PK_FPXORIGINAREA_SID" PRIMARY KEY ("SID") VALIDATE ) 
	TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 
	STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;


----------配置好4px功能项到系统菜单中----
insert into DB_MENUFUNC (funid, funname, fundesc, url, ifwinopen, ifparent, parentid, sort, type, reserve1, reserve2, reserve3, reserve4, reserve5)values
('1317', '4PX配置', '4PX配置', '/eshop/order.do?method=findFPXConfigureList', 0, 3, '1300', 28, 3, null, null, null, null, null);
insert into DB_OPERMENU(oper,menuid) values('admin','1317');

---------------------解决打印预览是空白的脚本--------------------------
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);