sql

-- Create table
create table Z_ENT_HAIKOU_SHOP
(
SHOP_ID CHAR(32) not null,
SITE_ENT_ID CHAR(32),
PLATFORM_CODE CHAR(3),
SHOP_NAME VARCHAR2(300),
SHOP_ADDRESS VARCHAR2(300),
SHOP_URL VARCHAR2(1000),
SHOP_CONTENT CLOB,
HPL NUMBER,
EV_NUM NUMBER,
ADD_TIME DATE,
LASTDATE DATE,
BAD_EV_NUM NUMBER,
IS_EV NUMBER,
SFZC VARCHAR2(300),
GOOD_URL VARCHAR2(1000),
SHOP_TYPE VARCHAR2(300),
SHOP_SUB_TYPE VARCHAR2(300),
STATE VARCHAR2(10),
GOOD_ID CHAR(32),
ZCXX VARCHAR2(1000),
TAOBAO_URL VARCHAR2(1000),
DATA_HOTELID VARCHAR2(100)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table Z_ENT_HAIKOU_SHOP
add constraint PK_HAIKOU_SHOPID_20170803 primary key (SHOP_ID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table Z_ENT_HAIKOU_SHOP
add constraint UK_HAIKOU_GOODURL20170803 unique (GOOD_URL)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table Z_ENT_HAIKOU_SHOP
add constraint UK_HAIKOU_SHOPURL20170803 unique (SHOP_URL)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);