table-oracle-gbk.sql

一个jsp写的bbs

  TAGNAME            VARCHAR2(255),
  ISGUEST            NUMBER(1) default 0,
  PREVIEWATTACH      NUMBER(1) default 0,
  PRIMARY KEY  (ID)
)
######
create index I_FH_BID on BBSCS_FORUM_HISTORY (BOARDID)
######
create index I_FH_DELSIGN on BBSCS_FORUM_HISTORY (DELSIGN)
######
create index I_FH_ISNEW on BBSCS_FORUM_HISTORY (ISNEW)
######
create index I_FH_LASTTIME on BBSCS_FORUM_HISTORY (LASTTIME)
######
create index I_FH_MID on BBSCS_FORUM_HISTORY (MAINID)
######
create table BBSCS_FORUMBUY
(
  ID              VARCHAR2(40) not null,
  POSTID          VARCHAR2(40) not null,
  BUYFROMID       VARCHAR2(40) not null,
  BUYFROMNAME     VARCHAR2(20) not null,
  BUYTOID         VARCHAR2(40) not null,
  BUYTONAME       VARCHAR2(20) not null,
  BUYPRICE        NUMBER(11) default 0 not null,
  BUYTOUSERINCOME NUMBER(11) default 0 not null,
  BUYTIME         NUMBER(20) default 0 not null,
  PRIMARY KEY  (ID)
)
######
create table BBSCS_FRIEND
(
  ID            VARCHAR2(40) default '' not null,
  USERID        VARCHAR2(40) default '' not null,
  USERNAME      VARCHAR2(20) default '' not null,
  FRIENDID      VARCHAR2(40) default '' not null,
  FRIENDNAME    VARCHAR2(20) default '' not null,
  FRIENDCOMMENT CLOB,
  ISBLACK       NUMBER(1) default '0',
  PRIMARY KEY  (ID)
)
######
create index I_FRI_UID on BBSCS_FRIEND (USERID)
######
create table BBSCS_GROUPROLE
(
  GROUPID NUMBER(11) default 0 not null,
  ROLEID  NUMBER(11) default 0 not null,
  PRIMARY KEY  (GROUPID,ROLEID)
)
######
create table BBSCS_LOGINERROR
(
  ID         VARCHAR2(40) default '' not null,
  USERID     VARCHAR2(40) default '' not null,
  ERRORTIMES NUMBER(11) default 0 not null,
  LOGINTIME  NUMBER(20) default 0,
  PRIMARY KEY  (ID)
)
######
create unique index U_LE_UID on BBSCS_LOGINERROR (USERID)
######
create table BBSCS_NOTE
(
  ID           VARCHAR2(40) default '' not null,
  FROMID       VARCHAR2(40) default '' not null,
  FROMUSERNAME VARCHAR2(20) default '' not null,
  FROMNICKNAME VARCHAR2(60) default '' not null,
  TOID         VARCHAR2(40) default '' not null,
  TOUSERNAME   VARCHAR2(20) default '' not null,
  TONICKNAME   VARCHAR2(60) default '' not null,
  NOTETYPE     NUMBER(1) default 0 not null,
  NOTETITLE    VARCHAR2(150) default '' not null,
  NOTECONTEXT  CLOB not null,
  CREATETIME   TIMESTAMP(6) not null,
  ISNEW        NUMBER(1) default 1,
  NEEDRE       NUMBER(1) default 0,
  ISRE         NUMBER(1) default 0,
  SYSMSG       NUMBER(1) default 0,
  PRIMARY KEY  (ID)
)
######
create index I_N_FID on BBSCS_NOTE (FROMID)
######
create index I_N_TID on BBSCS_NOTE (TOID)
######
create table BBSCS_PERMISSION
(
  ID                 NUMBER(20) default 0 not null,
  PERMISSIONNAME     VARCHAR2(255) default '' not null,
  PERMISSIONRESOURCE VARCHAR2(255),
  ACTION             VARCHAR2(255),
  TYPEID             NUMBER(2) default 0 not null,
  PRIMARY KEY  (ID)
)
######
create table BBSCS_ROLE
(
  ID          NUMBER(11) not null,
  ROLENAME    VARCHAR2(255) default '' not null,
  TYPEID      NUMBER(2) default '0' not null,
  PERMISSIONS CLOB,
  PRIMARY KEY  (ID)
)
######
create table BBSCS_SUBSCIBE
(
  ID          VARCHAR2(40) default '' not null,
  USERID      VARCHAR2(40) default '' not null,
  USERNAME    VARCHAR2(20) default '' not null,
  NICKNAME    VARCHAR2(60) default '' not null,
  POSTID      VARCHAR2(40) default '' not null,
  POSTTITLE   VARCHAR2(150) default '' not null,
  BOARDID     NUMBER(20) default '0' not null,
  EMAILINFORM NUMBER(1) default '1',
  MSGINFORM   NUMBER(1) default '1',
  USEREMAIL   VARCHAR2(255),
  CREATETIME  TIMESTAMP(6),
  USERLOCALE  VARCHAR2(20) default 'zh_CN',
  PRIMARY KEY  (ID)
)
######
create table BBSCS_SYSNUMSTAT
(
  ID         VARCHAR2(20) not null,
  RECDATE    VARCHAR2(20) not null,
  NUM0       NUMBER(11) default 0,
  NUMINC0    NUMBER(11) default 0 not null,
  NUM1       NUMBER(11) default 0 not null,
  NUMINC1    NUMBER(11) default 0 not null,
  NUM2       NUMBER(11) default 0 not null,
  NUMINC2    NUMBER(11) default 0 not null,
  NUM3       NUMBER(11) default 0 not null,
  NUMINC3    NUMBER(11) default 0 not null,
  NUM4       NUMBER(11) default 0 not null,
  NUMINC4    NUMBER(11) default 0 not null,
  NUM5       NUMBER(11) default 0 not null,
  NUMINC5    NUMBER(11) default 0 not null,
  CREATETIME NUMBER(20) default 0,
  PRIMARY KEY  (ID)
)
######
create table BBSCS_USERINFO
(
  ID              VARCHAR2(40) default '' not null,
  USERNAME        VARCHAR2(20) default '' not null,
  NICKNAME        VARCHAR2(60) default '' not null,
  PASSWD          VARCHAR2(40) default '' not null,
  REPASSWD        VARCHAR2(40) default '' not null,
  EMAIL           VARCHAR2(255) default '' not null,
  QUESTION        VARCHAR2(255) default '' not null,
  ANSWER          VARCHAR2(255) default '' not null,
  REGTIME         TIMESTAMP(6) not null,
  LOGINTIME       TIMESTAMP(6) not null,
  LOGINIP         VARCHAR2(20) default '',
  LOGINTIMES      NUMBER(11) default 0 not null,
  LASTLOGINTIME   TIMESTAMP(6),
  LASTLOGINIP     VARCHAR2(20),
  ARTICLENUM      NUMBER(11) default 0,
  STAYTIME        NUMBER(20) default 0,
  ARTICLEELITENUM NUMBER(11) default 0,
  LIFEFORCE       NUMBER(11) default 0,
  USERTITLE       NUMBER(3) default 0,
  COIN            NUMBER(11) default 0,
  LITERARY        NUMBER(11) default 0,
  EXPERIENCE      NUMBER(11) default 0,
  USERKNOW        NUMBER(11) default 0,
  SIGNNAME0       VARCHAR2(30),
  SIGNDETAIL0     CLOB,
  SIGNNAME1       VARCHAR2(30),
  SIGNDETAIL1     CLOB,
  SIGNNAME2       VARCHAR2(30),
  SIGNDETAIL2     CLOB,
  HAVEPIC         NUMBER(3) default 0,
  PICFILENAME     VARCHAR2(255),
  FORUMPERNUM     NUMBER(3) default 20,
  POSTPERNUM      NUMBER(3) default 10,
  USERFROM        VARCHAR2(255),
  TIMEZONE        VARCHAR2(20) default 'GMT+08:00',
  BIRTHYEAR       NUMBER(4) default 1980,
  BIRTHMONTH      NUMBER(2) default 1,
  BIRTHDAY        NUMBER(2) default 1,
  RECEIVENOTE     NUMBER(1) default 1,
  ACCEPTFRIEND    NUMBER(1) default 1,
  FORUMVIEWMODE   NUMBER(1) default 0,
  VALIDATED       NUMBER(1) default 1,
  GROUPID         NUMBER(11) default 0,
  HIDDENLOGIN     NUMBER(1) default 0,
  EDITTYPE        NUMBER(1) default -1,
  USERLOCALE      VARCHAR2(20) default 'zh_CN',
  VALIDATECODE    VARCHAR2(20),
  PRIMARY KEY  (ID)
)
######
create table BBSCS_USERDETAIL
(
  ID           VARCHAR2(40) default '' not null,
  HEIGHT       VARCHAR2(255),
  WEIGHT       VARCHAR2(255),
  INTEREST     VARCHAR2(255) default '',
  GRADUATE     VARCHAR2(255) default '',
  FAVOURPEOPLE VARCHAR2(255) default '',
  DREAMJOB     VARCHAR2(255) default '',
  FAVOURART    VARCHAR2(255) default '',
  FAVOURMUSIC  VARCHAR2(255) default '',
  FAVOURPLACE  VARCHAR2(255) default '',
  FAVOURMOVIE  VARCHAR2(255) default '',
  FAVOURCHAT   VARCHAR2(255) default '',
  FAVOURBOOK   VARCHAR2(255) default '',
  DREAMLOVER   VARCHAR2(255) default '',
  FAVOURTEAM   VARCHAR2(255) default '',
  HOMEPAGE     VARCHAR2(255) default '',
  OICQNO       VARCHAR2(255) default '',
  ICQNO        VARCHAR2(255) default '',
  MSN          VARCHAR2(255) default '',
  YAHOO        VARCHAR2(255) default '',
  SEX          NUMBER(1) default 0,
  BRIEF        CLOB,
  PRIMARY KEY  (ID),
  CONSTRAINT FK_USERDETAIL_ID FOREIGN KEY (ID) REFERENCES BBSCS_USERINFO (ID) ON DELETE CASCADE
)
######
create table BBSCS_USERGROUP
(
  ID        NUMBER(11) not null,
  GROUPNAME VARCHAR2(255) default '' not null,
  GROUPDESC VARCHAR2(255),
  TYPEID    NUMBER(2) default 0 not null,
  PRIMARY KEY  (ID)
)
######
create table BBSCS_USERLEVEL
(
  ID         VARCHAR2(40) not null,
  LEVELNAME  VARCHAR2(60) not null,
  LEVELVALUE NUMBER(11) default 0 not null,
  LEVELTYPE  NUMBER(1) default 0,
  PRIMARY KEY  (ID)
)
######
create table BBSCS_USERONLINE
(
  ID           VARCHAR2(40) default '' not null,
  USERID       VARCHAR2(40) default '' not null,
  USERNAME     VARCHAR2(20) default '' not null,
  NICKNAME     VARCHAR2(60) default '' not null,
  ONLINETIME   NUMBER(20),
  BOARDID      NUMBER(20) default '0',
  ATPLACE      VARCHAR2(255),
  USERGROUPID  NUMBER(11),
  VALIDATECODE VARCHAR2(100),
  HIDDENUSER   NUMBER(1) default 0,
  PRIMARY KEY  (ID)
)
######
create table BBSCS_USERTOP
(
  ID        VARCHAR2(40) not null,
  USERID    VARCHAR2(40) not null,
  USERNAME  VARCHAR2(20) not null,
  NICKNAME  VARCHAR2(60) not null,
  VALUETYPE NUMBER(2) default 0 not null,
  USERVALUE NUMBER(11) default 0,
  VALUEINC  NUMBER(11),
  PRIMARY KEY  (ID)
)
######
create index I_UT_VT on BBSCS_USERTOP (VALUETYPE)
######
create table BBSCS_VOTE
(
  ID       VARCHAR2(40) default '' not null,
  TITLE    VARCHAR2(255) default '' not null,
  ISM      NUMBER(1) default 0,
  DEADLINE NUMBER(20) default 0,
  PRIMARY KEY  (ID)
)
######
create table BBSCS_VOTEITEM
(
  ID        VARCHAR2(40) default '' not null,
  VOTEID    VARCHAR2(40) default '' not null,
  ITEM      VARCHAR2(255) default '' not null,
  ITEMVALUE NUMBER(11) default 0,
  PRIMARY KEY  (ID)
)
######
create table BBSCS_VOTEUSER
(
  ID         VARCHAR2(40) default '' not null,
  VOTEID     VARCHAR2(40) default '' not null,
  VOTEUSERID VARCHAR2(40) default '' not null,
  VOTETIME   NUMBER(20) default 0 not null,
  PRIMARY KEY  (ID)
)
######
create sequence SEQ_BOARD_ID
######
create sequence SEQ_BOARDMASTER_ID
######
create sequence SEQ_ELITE_ID
######
create sequence SEQ_ROLE_ID
######
create sequence SEQ_USERGROUP_ID