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