⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 table-oracle-gbk.sql

📁 交易撮合系统是一套买卖信息沟通的平台
💻 SQL
📖 第 1 页 / 共 4 页
字号:
🔍
1234 
  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_FA0_BID on BBSCS_FORUMARCHIVES_0 (BOARDID)
######
create index I_FA0_LASTTIME on BBSCS_FORUMARCHIVES_0 (LASTTIME)
######
create index I_FA0_MID on BBSCS_FORUMARCHIVES_0 (MAINID)
######
create index I_FA0_POSTTIME on BBSCS_FORUMARCHIVES_0 (POSTTIME)
######
create table BBSCS_FORUMARCHIVES_1
(
  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_FA1_BID on BBSCS_FORUMARCHIVES_1 (BOARDID)
######
create index I_FA1_LASTTIME on BBSCS_FORUMARCHIVES_1 (LASTTIME)
######
create index I_FA1_MID on BBSCS_FORUMARCHIVES_1 (MAINID)
######
create index I_FA1_POSTTIME on BBSCS_FORUMARCHIVES_1 (POSTTIME)
######
create table BBSCS_FORUMARCHIVES_2
(
  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_FA2_BID on BBSCS_FORUMARCHIVES_2 (BOARDID)
######
create index I_FA2_LASTTIME on BBSCS_FORUMARCHIVES_2 (LASTTIME)
######
create index I_FA2_MID on BBSCS_FORUMARCHIVES_2 (MAINID)
######
create index I_FA2_POSTTIME on BBSCS_FORUMARCHIVES_2 (POSTTIME)
######
create table BBSCS_FORUMARCHIVES_3
(
  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_FA3_BID on BBSCS_FORUMARCHIVES_3 (BOARDID)
######
create index I_FA3_LASTTIME on BBSCS_FORUMARCHIVES_3 (LASTTIME)
######
create index I_FA3_MID on BBSCS_FORUMARCHIVES_3 (MAINID)
######
create index I_FA3_POSTTIME on BBSCS_FORUMARCHIVES_3 (POSTTIME)
######
create table BBSCS_FORUMARCHIVES_4
(
  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,
1234

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -