suncms.sql.svn-base

一个实用的CMS管理

----------------------------------------------
-- Export file for user SUNCMS              --
-- Created by fjn438 on 2008-5-14, 18:19:53 --
----------------------------------------------

spool suncms.log

prompt
prompt Creating table ARTICLE
prompt ======================
prompt
create table ARTICLE
(
  ROW_ID              VARCHAR2(36) not null,
  ARTCLASS_ID         VARCHAR2(36),
  ARTCLASS_NAME       VARCHAR2(20),
  ARTICLE_TITLE       VARCHAR2(100),
  ARTICLE_DESC        VARCHAR2(40),
  ARTICLE_CONTENT     CLOB,
  ARTICLE_STATUS      CHAR(2),
  ARTICLE_OVERDUE     VARCHAR2(30),
  ARTICLE_AUTHOR_ID   VARCHAR2(36),
  ARTICLE_AUTHOR_NAME VARCHAR2(10),
  ARTICLE_EDITOR_ID   VARCHAR2(36),
  ARTICLE_EDITOR_NAME VARCHAR2(10),
  ARTICLE_READ_COUNT  VARCHAR2(36) default 0,
  ARTICLE_ATTACH      VARCHAR2(100),
  CREATE_BY           VARCHAR2(36),
  CREATE_TIME         TIMESTAMP(6),
  MODIFY_BY           VARCHAR2(36),
  MODIFY_TIME         TIMESTAMP(6),
  ARTICLE_FILE        VARCHAR2(100)
)
;

prompt
prompt Creating table ARTICLE_CLASS
prompt ============================
prompt
create table ARTICLE_CLASS
(
  ROW_ID         VARCHAR2(36) not null,
  CLASS_NAME     VARCHAR2(50),
  IF_CHECK       VARCHAR2(2),
  IF_VALID       VARCHAR2(2),
  PAR_CLASS_ID   VARCHAR2(36),
  PAR_CLASS_NAME VARCHAR2(60),
  IF_NAVIGATION  VARCHAR2(2),
  PICTURE        VARCHAR2(100),
  IF_INDEX       VARCHAR2(2),
  IF_BULLETIN    VARCHAR2(2)
)
;

prompt
prompt Creating table AUTHORITY
prompt ========================
prompt
create table AUTHORITY
(
  ROW_ID     VARCHAR2(36) not null,
  ROLE_ID    VARCHAR2(36),
  CLASS_ID   VARCHAR2(36),
  IF_EDIT    VARCHAR2(2),
  IF_CHECK   VARCHAR2(2),
  IF_PUBLISH VARCHAR2(2)
)
;
alter table AUTHORITY
  add constraint PK11 primary key (ROW_ID);

prompt
prompt Creating table ORG_STRUCT
prompt =========================
prompt
create table ORG_STRUCT
(
  ROW_ID      VARCHAR2(36) not null,
  ORG_NAME    VARCHAR2(20) not null,
  ORG_DESC    VARCHAR2(100),
  PARENT_ID   VARCHAR2(36) not null,
  PARENT_NAME VARCHAR2(20),
  ORG_TYPE    VARCHAR2(5),
  CREATE_BY   VARCHAR2(20),
  CREATE_TIME VARCHAR2(10),
  UPDATE_BY   VARCHAR2(20),
  UPDATE_TIME VARCHAR2(10)
)
;
alter table ORG_STRUCT
  add constraint PK2 primary key (ROW_ID);

prompt
prompt Creating table UGROUPS
prompt ======================
prompt
create table UGROUPS
(
  ROW_ID      VARCHAR2(36) not null,
  GROUP_NAME  VARCHAR2(20),
  GROUP_DESC  VARCHAR2(50),
  PARTEN_ID   VARCHAR2(36),
  PARTEN_NAME VARCHAR2(20),
  CREATE_BY   VARCHAR2(20),
  CREATE_TIME VARCHAR2(10),
  UPDATE_BY   VARCHAR2(20),
  UPDATE_TIME VARCHAR2(10)
)
;
alter table UGROUPS
  add constraint PK1 primary key (ROW_ID);

prompt
prompt Creating table UROLES
prompt =====================
prompt
create table UROLES
(
  ROW_ID      VARCHAR2(36) not null,
  ROLE_NAME   VARCHAR2(20) not null,
  ROLE_DESC   VARCHAR2(30),
  CREATE_BY   VARCHAR2(20),
  CREATE_TIME VARCHAR2(10),
  UPDATE_BY   VARCHAR2(20),
  UPDATE_TIME VARCHAR2(10)
)
;
alter table UROLES
  add constraint PK3 primary key (ROW_ID);

prompt
prompt Creating table USERS
prompt ====================
prompt
create table USERS
(
  ROW_ID      VARCHAR2(36) not null,
  USER_LOGIN  VARCHAR2(20) not null,
  USER_PASS   VARCHAR2(20),
  USER_NAME   VARCHAR2(10),
  USER_STATUS VARCHAR2(12),
  USER_ROLE   VARCHAR2(50),
  USER_GROUP  VARCHAR2(50),
  USER_ORG    VARCHAR2(50)
)
;
alter table USERS
  add constraint PK6 primary key (ROW_ID);

prompt
prompt Creating table USER_GROUP
prompt =========================
prompt
create table USER_GROUP
(
  ROW_ID   VARCHAR2(36) not null,
  GROUP_ID VARCHAR2(36) not null,
  USER_ID  VARCHAR2(36) not null
)
;
alter table USER_GROUP
  add constraint PK8 primary key (ROW_ID);

prompt
prompt Creating table USER_ORG
prompt =======================
prompt
create table USER_ORG
(
  ROW_ID  VARCHAR2(36) not null,
  USER_ID VARCHAR2(36) not null,
  ORG_ID  VARCHAR2(36) not null
)
;
alter table USER_ORG
  add constraint PK5 primary key (ROW_ID);

prompt
prompt Creating table USER_ROLE
prompt ========================
prompt
create table USER_ROLE
(
  ROW_ID  VARCHAR2(36) not null,
  USER_ID VARCHAR2(36) not null,
  ROLE_ID VARCHAR2(36) not null
)
;
alter table USER_ROLE
  add constraint PK7 primary key (ROW_ID);

prompt
prompt Creating table VOTE_A
prompt =====================
prompt
create table VOTE_A
(
  ROW_ID    VARCHAR2(36),
  VOTE_ITEM VARCHAR2(100),
  VOTE_ID   VARCHAR2(36),
  POLLED    NUMBER default 0
)
;

prompt
prompt Creating table VOTE_Q
prompt =====================
prompt
create table VOTE_Q
(
  ROW_ID          VARCHAR2(36) not null,
  VOTE_TITLE      VARCHAR2(60),
  VOTE_TYPE       VARCHAR2(2),
  VOTE_STATUS     VARCHAR2(2),
  VOTE_CREATETIME TIMESTAMP(6),
  VOTE_CONTENT    VARCHAR2(200)
)
;


spool off