耽误1天的一张表

 

-- Create table
create table TJSDY
(
  JSDM CHAR(3) not null,
  JSMC CHAR(30) not null,
  JSLX CHAR(1) not null,
  BY1  CHAR(10) default '**********' not null,
  BY2  CHAR(20) default '********************' not null,
  CDWZ CHAR(1) default '2' not null,
  SJJS CHAR(3) default '*' not null
)
tablespace YZ_BASIC
  pctfree 1
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 1M
    next 1M
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
-- Create/Recreate indexes
create unique index TJSDY_UN1 on TJSDY (JSDM)
  tablespace YZ_BASIC_INX
  pctfree 1
  initrans 2
  maxtrans 255
  storage
  (
    initial 512K
    next 512K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );