ins_base_obj.sql

模仿腾讯QQ的

----------------------------------------------
-- Export file for user QQ                  --
-- Created by admin on 2007-11-15, 21:36:02 --
----------------------------------------------

spool sss.log

prompt
prompt Creating table TDEPARTMENT
prompt ==========================
prompt
create table QQ.TDEPARTMENT
(
  DNO       VARCHAR2(5) not null,
  DNAME     VARCHAR2(60) not null,
  DSAFFICHE VARCHAR2(255)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table QQ.TDEPARTMENT
  add primary key (DNO)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table QQ.TDEPARTMENT
  add unique (DNAME)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table TUSER
prompt ====================
prompt
create table QQ.TUSER
(
  UNO            VARCHAR2(5) not null,
  UPASSWORD      VARCHAR2(20) not null,
  UNAME          VARCHAR2(30) not null,
  UTERM          VARCHAR2(30),
  USEX           VARCHAR2(2) not null,
  UICONID        VARCHAR2(255) not null,
  UAGE           VARCHAR2(3),
  DNO            VARCHAR2(5) not null,
  UPHONE         VARCHAR2(13),
  UADDRESS       VARCHAR2(255),
  ULASTLOGINTIME VARCHAR2(20),
  UREGDATE       VARCHAR2(20) not null,
  ULOGINCOUNT    VARCHAR2(5) default 0 not null,
  UISONLINE      VARCHAR2(2) default '0' not null
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table QQ.TUSER
  add primary key (UNO)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table QQ.TUSER
  add constraint FDSAJFEW foreign key (DNO)
  references QQ.TDEPARTMENT (DNO);


spool off