gbookofcool.sql

来自「这也是一个java版的留言版」· SQL 代码 · 共 62 行

###Instant DB
create table WEB_GBOOK
(
    gbk_id               int       AUTO INCREMENT,
    GBK_NAME      VARCHAR2(10)           null    ,
    GBK_SUBJECT   VARCHAR2(36)           null    ,
    GBK_CONTENT   VARCHAR2(625)          null    ,
    GBK_MAIL      VARCHAR2(32)           null    ,
    GBK_WEBSITE   VARCHAR2(50)           null    ,
    GBK_DATE      VARCHAR2(20)           null    ,
    GBK_IP        VARCHAR2(15)           null    ,
    GBK_QQ        CHAR(10)               null    ,
    GBK_ISREPLY   CHAR(1)                null    ,
    GBK_REPLY     VARCHAR2(255)          null    ,
    GBK_REPLYDATE VARCHAR2(20)           null    ,
    
    constraint PK_WEB_GBOOK primary key (GBK_ID)
)          
create table WEB_USERS
(
    USR_ID     INT   auto increment   not null,
    USR_NICK   VARCHAR(16)            null    ,
    USR_NAME   VARCHAR(16)            null    ,
    USR_PSWD   VARCHAR(16)            null    ,
    USR_CLASS  CHAR(1)                null    ,
    USR_EMAIL  VARCHAR(32)            null    ,
    constraint PK_WEB_USERS primary key (USR_ID, USR_NICK)
)     

                                                                                                       

###MySQL
create table WEB_GBOOK
(
    gbk_id        int auto_increment    not null,
    GBK_NAME      VARCHAR(10)           null    ,
    GBK_SUBJECT   VARCHAR(36)           null    ,
    GBK_CONTENT   VARCHAR(255)          null    ,
    GBK_MAIL      VARCHAR(32)           null    ,
    GBK_WEBSITE   VARCHAR(50)           null    ,
    GBK_DATE      VARCHAR(20)           null    ,
    GBK_IP        VARCHAR(15)           null    ,
    GBK_QQ        CHAR(10)              null    ,
    GBK_ISREPLY   CHAR(1)               null    ,
    GBK_REPLY     VARCHAR(255)          null    ,
    GBK_REPLYDATE VARCHAR(20)           null    ,
    
    constraint PK_WEB_GBOOK primary key (GBK_ID)
)                                                 
create table WEB_USERS
(
    USR_ID     INT   auto_increment   not null,
    USR_NICK   VARCHAR(16)            not null,
    USR_NAME   VARCHAR(16)            null    ,
    USR_PSWD   VARCHAR(16)            null    ,
    USR_CLASS  CHAR(1)                null    ,
    USR_EMAIL  VARCHAR(32)            null    ,
    constraint PK_WEB_USERS primary key (USR_ID, USR_NICK)
)     

### Common
insert into web_users  (usr_nick,usr_name,usr_pswd,usr_class,usr_email) values  ('sindo','sindo lee','1234','0','[e-mail]')