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

initrans 2

add constraint uk_haikou_goodurl20170803 unique (good_url)

add constraint uk_haikou_shopurl20170803 unique (shop_url)