table-oracle-gbk.sql

一个jsp写的bbs

create table BBSCS_AGREEAGAINST
(
  ID         VARCHAR2(40) default '' not null,
  USERID     VARCHAR2(40) default '' not null,
  POSTID     VARCHAR2(40) default '' not null,
  BOARDID    NUMBER(20) default 0 not null,
  VOTETYPE   NUMBER(1) default 0,
  CREATETIME NUMBER(20) default 0 not null,
  PRIMARY KEY  (ID)
)
######
create table BBSCS_BOARD
(
  ID             NUMBER(20) not null,
  PARENTID       NUMBER(20) default 0 not null,
  PARENTIDS      VARCHAR2(255) default '',
  CHILDIDS       VARCHAR2(255) default '',
  BOARDNAME      VARCHAR2(60) default '' not null,
  EXPLAINS       CLOB,
  BULLETIN       CLOB,
  BOARDPIC       VARCHAR2(200) default '',
  USESTAT        NUMBER(1) default 1,
  ORDERS         NUMBER(11) default 0,
  NEEDPASSWD     NUMBER(1) default 0,
  PASSWD         VARCHAR2(100) default '',
  BOARDLEVEL     NUMBER(11) default 0,
  BOARDTYPE      NUMBER(3) default 0,
  ALLOWHTML      NUMBER(1) default 0,
  ALLOWUBB       NUMBER(1) default 0,
  AUDITPOST      NUMBER(1) default 0,
  AUDITATTACH    NUMBER(1) default 0,
  ADDUSERPOSTNUM NUMBER(1) default 1,
  ISHIDDEN       NUMBER(1) default 0,
  ISAUTH         NUMBER(1) default 0,
  MAINPOSTNUM    NUMBER(11) default 0,
  POSTNUM        NUMBER(11) default 0,
  PRIMARY KEY  (ID)
)
######
create table BBSCS_BOARDAUTHUSER
(
  ID         VARCHAR2(40) default '' not null,
  BOARDID    NUMBER(20) default 0 not null,
  USERID     VARCHAR2(40) default '' not null,
  USERNAME   VARCHAR2(20) default '' not null,
  CREATETIME NUMBER(20) default 0,
  PRIMARY KEY  (ID)
)
######
create table BBSCS_BOARDMASTER
(
  ID               NUMBER(20) not null,
  BOARDID          NUMBER(20) default 0 not null,
  USERNAME         VARCHAR2(20) default '' not null,
  PURVIEW          VARCHAR2(200) default '',
  ROLEID           NUMBER(11) default 0,
  OVERCHILDPURVIEW NUMBER(3) default 0,
  ISHIDDEN         NUMBER(3) default 0,
  PRIMARY KEY  (ID)
)
######
create index I_BM on BBSCS_BOARDMASTER (BOARDID)
######
create table BBSCS_BOARDPERMISSION
(
  ID          VARCHAR2(40) default '' not null,
  BOARDID     NUMBER(20) default 0 not null,
  GROUPID     NUMBER(11) default 0 not null,
  PERMISSIONS CLOB,
  PRIMARY KEY  (ID)
)
######
create unique index U_BP_BID_GID on BBSCS_BOARDPERMISSION (BOARDID, GROUPID)
######
create table BBSCS_BOARDSAVE
(
  ID      VARCHAR2(40) default '' not null,
  USERID  VARCHAR2(40) default '' not null,
  BOARDID NUMBER(20) default 0 not null,
  PRIMARY KEY  (ID)
)
######
create unique index U_BS_BID_UID on BBSCS_BOARDSAVE (USERID, BOARDID)
######
create table BBSCS_BOARDTAG
(
  ID      VARCHAR2(40) not null,
  BOARDID NUMBER(20) not null,
  TAGNAME VARCHAR2(255) not null,
  ORDERS  NUMBER(11) default '0',
  PRIMARY KEY  (ID)
)
######
create table BBSCS_BOOKMARK
(
  ID           VARCHAR2(40) default '' not null,
  USERID       VARCHAR2(40) default '' not null,
  BOOKMARKNAME VARCHAR2(255) default '' not null,
  URL          VARCHAR2(255) default '',
  ALT          VARCHAR2(255) default '',
  ISSHARE      NUMBER(1) default 1,
  CREATETIME   TIMESTAMP(6) not null,
  PRIMARY KEY  (ID)
)
######
create index I_BM_UID on BBSCS_BOOKMARK (USERID)
######
create table BBSCS_CHOICE
(
  ID           VARCHAR2(40) default '' not null,
  CATEGORYID   VARCHAR2(40) default '' not null,
  BOARDID      NUMBER(20) default 0 not null,
  BOARDNAME    VARCHAR2(60) default '' not null,
  POSTID       VARCHAR2(40) default '' not null,
  POSTMAINID   VARCHAR2(40) default '' not null,
  USERID       VARCHAR2(40) default '' not null,
  USERNAME     VARCHAR2(20) default '' not null,
  USERNICKNAME VARCHAR2(60),
  TITLE        VARCHAR2(150),
  CREATETIME   NUMBER(20),
  PRIMARY KEY  (ID)
)
######
create table BBSCS_CHOICECATEGORY
(
  ID           VARCHAR2(40) default '' not null,
  CATEGORYNAME VARCHAR2(60) default '' not null,
  BOARDID      NUMBER(20) default 0 not null,
  USESTAT      NUMBER(1) default 1 not null,
  ORDERS       NUMBER(11) default 0,
  PRIMARY KEY  (ID)
)
######
create table BBSCS_COMMEND
(
  ID             VARCHAR2(40) default '' not null,
  BOARDID        NUMBER(20) default '0' not null,
  BOARDNAME      VARCHAR2(60) default '' not null,
  POSTID         VARCHAR2(40) default '' not null,
  POSTMAINID     VARCHAR2(40) default '' not null,
  USERID         VARCHAR2(40) default '' not null,
  USERNAME       VARCHAR2(20) default '' not null,
  COMMENDBOARDID NUMBER(20) default '0' not null,
  COMMENDTOP     NUMBER(1) default '0' not null,
  TITLE          VARCHAR2(150),
  BOARDCATEGORY  VARCHAR2(40),
  TOPCATEGORY    VARCHAR2(40),
  CREATETIME     NUMBER(20) default 0 not null,
  PRIMARY KEY  (ID)
)
######
create table BBSCS_CONFIG
(
  ID          VARCHAR2(50) default '' not null,
  CONFCONTEXT CLOB,
  PRIMARY KEY  (ID)
)
######
create table BBSCS_ELITE
(
  ID         NUMBER(20) not null,
  BOARDID    NUMBER(20) default 0 not null,
  PARENTID   NUMBER(20) default 0 not null,
  PARENTIDS  CLOB,
  ELITENAME  VARCHAR2(90),
  CREATEUSER VARCHAR2(60),
  ELITETIME  NUMBER(20) default 0,
  ORDERS     NUMBER(11) default 0,
  PRIMARY KEY  (ID)
)
######
create table BBSCS_FORUM
(
  ID                 VARCHAR2(40) default '' not null,
  PARENTID           VARCHAR2(40) default '',
  MAINID             VARCHAR2(40) default '',
  BOARDID            NUMBER(20) default 0 not null,
  BOARDNAME          VARCHAR2(60),
  RENUM              NUMBER(11) default 0,
  FACE               NUMBER(2) default 1,
  USERID             VARCHAR2(40),
  USERNAME           VARCHAR2(20),
  NICKNAME           VARCHAR2(60),
  TITLE              VARCHAR2(150),
  DETAIL             CLOB,
  SIGN               CLOB,
  ARTSIZE            NUMBER(11) default 0,
  CLICK              NUMBER(11) default 0,
  POSTTIME           NUMBER(20) default 0,
  LASTTIME           NUMBER(20) default 0,
  IPADDRESS          VARCHAR2(20),
  ISNEW              NUMBER(1) default 0,
  ELITE              NUMBER(20) default 0,
  ELITEID            NUMBER(20) default 0,
  AGREE              NUMBER(11) default 0,
  BEAGAINST          NUMBER(11) default 0,
  CANNOTDEL          NUMBER(1) default 0,
  CANNOTRE           NUMBER(1) default 0,
  COMMEND            NUMBER(20) default 0,
  DELSIGN            NUMBER(1) default 0,
  DELUSERID          VARCHAR2(40),
  DELUSERNAME        VARCHAR2(20),
  DELTIME            NUMBER(20) default 0,
  DELIP              VARCHAR2(20),
  AMEND              VARCHAR2(255),
  DOELITENAME        VARCHAR2(20) default 0,
  DOELITETIME        NUMBER(20) default 0,
  HAVEATTACHFILE     NUMBER(1) default 0,
  ATTACHFILENAME     CLOB,
  LASTPOSTUSERNAME   VARCHAR2(20),
  LASTPOSTTITLE      VARCHAR2(150),
  LASTPOSTNICKNAME   VARCHAR2(60),
  ISTOP              NUMBER(20) default 0,
  ISLOCK             NUMBER(1) default 0,
  AUDITING           NUMBER(1) default 0,
  AUDITINGATTACHFILE NUMBER(1) default 0,
  ISVOTE             NUMBER(1) default 0,
  ISHIDDEN           NUMBER(4) default 0,
  ISHIDDENVALUE      NUMBER(11) default 1,
  EDITTYPE           NUMBER(1) default 0,
  QUOTETEXT          CLOB,
  QUOTEEDITTYPE      NUMBER(1) default 0,
  POSTTYPE           NUMBER(1) default 0,
  TITLECOLOR         NUMBER(2) default 0,
  USERBLOG           NUMBER(1) default 0,
  INDEXSTATUS        NUMBER(1) default 0,
  EMAILINFORM        NUMBER(1) default 0,
  MSGINFORM          NUMBER(1) default 0,
  VOTEID             VARCHAR2(40),
  TAGID              VARCHAR2(40) default 0,
  TAGNAME            VARCHAR2(255),
  ISGUEST            NUMBER(1) default 0,
  PREVIEWATTACH      NUMBER(1) default 0,
  PRIMARY KEY  (ID)
)
######
create index I_F_BID on BBSCS_FORUM (BOARDID)
######
create index I_F_DELSIGN on BBSCS_FORUM (DELSIGN)
######
create index I_F_ISNEW on BBSCS_FORUM (ISNEW)
######
create index I_F_LASTTIME on BBSCS_FORUM (LASTTIME)
######
create index I_F_MID on BBSCS_FORUM (MAINID)
######
create table BBSCS_FORUM_HISTORY
(
  ID                 VARCHAR2(40) default '' not null,
  PARENTID           VARCHAR2(40) default '',
  MAINID             VARCHAR2(40) default '',
  BOARDID            NUMBER(20) default 0 not null,
  BOARDNAME          VARCHAR2(60),
  RENUM              NUMBER(11) default 0,
  FACE               NUMBER(2) default 1,
  USERID             VARCHAR2(40),
  USERNAME           VARCHAR2(20),
  NICKNAME           VARCHAR2(60),
  TITLE              VARCHAR2(150),
  DETAIL             CLOB,
  SIGN               CLOB,
  ARTSIZE            NUMBER(11) default 0,
  CLICK              NUMBER(11) default 0,
  POSTTIME           NUMBER(20) default 0,
  LASTTIME           NUMBER(20) default 0,
  IPADDRESS          VARCHAR2(20),
  ISNEW              NUMBER(1) default 0,
  ELITE              NUMBER(20) default 0,
  ELITEID            NUMBER(20) default 0,
  AGREE              NUMBER(11) default 0,
  BEAGAINST          NUMBER(11) default 0,
  CANNOTDEL          NUMBER(1) default 0,
  CANNOTRE           NUMBER(1) default 0,
  COMMEND            NUMBER(20) default 0,
  DELSIGN            NUMBER(1) default 0,
  DELUSERID          VARCHAR2(40),
  DELUSERNAME        VARCHAR2(20),
  DELTIME            NUMBER(20) default 0,
  DELIP              VARCHAR2(20),
  AMEND              VARCHAR2(255),
  DOELITENAME        VARCHAR2(20) default 0,
  DOELITETIME        NUMBER(20) default 0,
  HAVEATTACHFILE     NUMBER(1) default 0,
  ATTACHFILENAME     CLOB,
  LASTPOSTUSERNAME   VARCHAR2(20),
  LASTPOSTTITLE      VARCHAR2(150),
  LASTPOSTNICKNAME   VARCHAR2(60),
  ISTOP              NUMBER(20) default 0,
  ISLOCK             NUMBER(1) default 0,
  AUDITING           NUMBER(1) default 0,
  AUDITINGATTACHFILE NUMBER(1) default 0,
  ISVOTE             NUMBER(1) default 0,
  ISHIDDEN           NUMBER(4) default 0,
  ISHIDDENVALUE      NUMBER(11) default 1,
  EDITTYPE           NUMBER(1) default 0,
  QUOTETEXT          CLOB,
  QUOTEEDITTYPE      NUMBER(1) default 0,
  POSTTYPE           NUMBER(1) default 0,
  TITLECOLOR         NUMBER(2) default 0,
  USERBLOG           NUMBER(1) default 0,
  INDEXSTATUS        NUMBER(1) default 0,
  EMAILINFORM        NUMBER(1) default 0,
  MSGINFORM          NUMBER(1) default 0,
  VOTEID             VARCHAR2(40),
  TAGID              VARCHAR2(40) default 0,