green.sql

spring+hibernate+struts开发的校务oa系统

  LOGIDIOID  NUMBER(10) not null,
  TITLE      VARCHAR2(100),
  CONTENTTAG NUMBER(10),
  WEATHER    VARCHAR2(100),
  MOOD       VARCHAR2(100),
  ISSUETIME  DATE,
  AUTHOROP   NUMBER(10)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table LOGIDIO
  add constraint PK38 primary key (LOGIDIOID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating LOGWORK...
create table LOGWORK
(
  LOGWORKID  NUMBER(10) not null,
  TITLE      VARCHAR2(100),
  CONTENTTAG NUMBER(10),
  STARTTIME  DATE,
  ENDTIME    DATE,
  RECEVIEOP  NUMBER(10),
  PLACE      VARCHAR2(200),
  DECRIPTION VARCHAR2(500),
  AUTHOROP   NUMBER(10)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table LOGWORK
  add constraint PK39 primary key (LOGWORKID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating MANGLEAPPLY...
create table MANGLEAPPLY
(
  MANGLEAPPLYID NUMBER(10) not null,
  APPLTIME      DATE,
  APPLYCAUSE    VARCHAR2(1000),
  APPLYOP       NUMBER(10),
  REPLYOP       NUMBER(10),
  EQUIPMENT     NUMBER(10),
  ISREAD        NUMBER(10),
  ISFINISH      NUMBER(10),
  SFLAG         NUMBER(10)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table MANGLEAPPLY
  add constraint PK35 primary key (MANGLEAPPLYID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating MESSAGE...
create table MESSAGE
(
  MESSAGEID NUMBER(10) not null,
  TITLE     VARCHAR2(100),
  CONTENT   VARCHAR2(1000),
  SENDOP    NUMBER(10),
  RECEVIEOP NUMBER(10),
  FILEPATH  VARCHAR2(100),
  TYPE      NUMBER(10),
  ISREAD    NUMBER(10),
  SENDTIME  DATE default sysdate,
  SFLAG     NUMBER(10)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table MESSAGE
  add constraint PK17 primary key (MESSAGEID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating TOPIC...
create table TOPIC
(
  TOPICID    NUMBER(10) not null,
  TOP        CHAR(16),
  CONTENTTAG NUMBER(10),
  DISTILLATE CHAR(16),
  SENDTIME   DATE,
  TITLE      VARCHAR2(255),
  FACE       VARCHAR2(255),
  TEMP       CHAR(100) not null,
  FORUMID    NUMBER(10) not null,
  BBSUSERID  NUMBER(10) not null
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table TOPIC
  add constraint PK43 primary key (TOPICID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table TOPIC
  add constraint REFBBSUSER81 foreign key (BBSUSERID)
  references BBSUSER (BBSUSERID);
alter table TOPIC
  add constraint REFFORUM78 foreign key (FORUMID)
  references FORUM (FORUMID);

prompt Creating REPLYTOPIC...
create table REPLYTOPIC
(
  REPLYTOPICID NUMBER(10) not null,
  CONTENT      NUMBER(10),
  REPLYTIME    DATE,
  FACE         VARCHAR2(100),
  TEMP         CHAR(100),
  BBSUSERID    NUMBER(10) not null,
  TOPICID      NUMBER(10) not null
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table REPLYTOPIC
  add constraint PK45 primary key (REPLYTOPICID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table REPLYTOPIC
  add constraint REFBBSUSER83 foreign key (BBSUSERID)
  references BBSUSER (BBSUSERID);
alter table REPLYTOPIC
  add constraint REFTOPIC84 foreign key (TOPICID)
  references TOPIC (TOPICID);

prompt Creating TRANSACTION...
create table TRANSACTION
(
  TRANSACTIONID NUMBER(10) not null,
  TITLE         VARCHAR2(100),
  CONTENT       VARCHAR2(1000),
  SENDTIME      DATE default sysdate,
  FINISHTIME    DATE,
  FINISHTIME2   DATE,
  TRANBEGINTIME DATE,
  TRANENDTIME   DATE,
  SENDOP        NUMBER(10),
  RECEVIEOP     NUMBER(10),
  ISCHECK       NUMBER(10),
  ISFINISH      NUMBER(10),
  ISREAD        NUMBER(10),
  REMARK        VARCHAR2(255),
  ISPASS        NUMBER(10),
  PREID         NUMBER(10) default -1,
  SFLAG         NUMBER(10)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table TRANSACTION
  add constraint PK40_1 primary key (TRANSACTIONID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating USERGROUP...
create table USERGROUP
(
  USERGROUPID NUMBER(10) not null,
  GROUPNAME   VARCHAR2(50),
  DESCRIPTION VARCHAR2(100)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table USERGROUP
  add constraint PK12 primary key (USERGROUPID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating USER_GROUPLINK...
create table USER_GROUPLINK
(
  USER_GROUPLINKID NUMBER(10) not null,
  USERGROUPID      NUMBER(10),
  OPERATORID       NUMBER(10)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table USER_GROUPLINK
  add constraint PK33 primary key (USER_GROUPLINKID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table USER_GROUPLINK
  add constraint REFOPERATOR90 foreign key (OPERATORID)
  references OPERATOR (OPERATORID);
alter table USER_GROUPLINK
  add constraint REFUSERGROUP71 foreign key (USERGROUPID)
  references USERGROUP (USERGROUPID);

prompt Disabling triggers for POPEDOM...
alter table POPEDOM disable all triggers;
prompt Disabling triggers for USERINFO...
alter table USERINFO disable all triggers;
prompt Disabling triggers for OPERATOR...
alter table OPERATOR disable all triggers;
prompt Disabling triggers for FORUM...
alter table FORUM disable all triggers;
prompt Disabling triggers for BBSUSER...
alter table BBSUSER disable all triggers;
prompt Disabling triggers for CONTENT...
alter table CONTENT disable all triggers;
prompt Disabling triggers for EQUIPMENTAPPLY...
alter table EQUIPMENTAPPLY disable all triggers;
prompt Disabling triggers for GREENSYSPARAM...
alter table GREENSYSPARAM disable all triggers;
prompt Disabling triggers for HOLSAPPLY...
alter table HOLSAPPLY disable all triggers;
prompt Disabling triggers for LOGIDIO...
alter table LOGIDIO disable all triggers;
prompt Disabling triggers for LOGWORK...
alter table LOGWORK disable all triggers;
prompt Disabling triggers for MANGLEAPPLY...
alter table MANGLEAPPLY disable all triggers;
prompt Disabling triggers for MESSAGE...
alter table MESSAGE disable all triggers;
prompt Disabling triggers for TOPIC...
alter table TOPIC disable all triggers;
prompt Disabling triggers for REPLYTOPIC...
alter table REPLYTOPIC disable all triggers;
prompt Disabling triggers for TRANSACTION...
alter table TRANSACTION disable all triggers;
prompt Disabling triggers for USERGROUP...
alter table USERGROUP disable all triggers;