一个菜鸟正在用SSH写一个论坛（1） .

    嗯。。搞定了注册和登录，说明我的SSH整合已经没有问题了，那么我就继续折腾了。

    我的目的是用SSH框架写一个论坛（当然是功能最简单的那种），搞定了整合之后我打算先做出一些基本的功能，于是我就先简单的设计了一下数据库。

/*==============================================================*/
/* DBMS name:      MySQL 5.0                                    */
/* Created on:     2015/9/17 17:21:07                           */
/*==============================================================*/


drop table if exists BM;

drop table if exists borad;

drop table if exists post;

drop table if exists reply;

drop table if exists userinfo;

/*==============================================================*/
/* Table: BM                                                    */
/*==============================================================*/
create table BM
(
   BM_id                int not null,
   user_id              int,
   borad_id             int,
   primary key (BM_id)
);

/*==============================================================*/
/* Table: borad                                                 */
/*==============================================================*/
create table borad
(
   borad_id             int not null,
   borad_name           char(20) not null,
   primary key (borad_id)
);

/*==============================================================*/
/* Table: post                                                  */
/*==============================================================*/
create table post
(
   post_id              int not null,
   user_id              int,
   borad_id             int,
   post_title           char(20) not null,
   post_createtime      timestamp not null,
   post_updatetime      timestamp not null,
   post_replytime       timestamp not null,
   post_readtimes       int not null,
   post_content         char(200),
   primary key (post_id)
);

/*==============================================================*/
/* Table: reply                                                 */
/*==============================================================*/
create table reply
(
   reply_id             int not null,
   post_id              int,
   user_id              int,
   reply_content        char(200) not null,
   reply_createtime     timestamp not null,
   primary key (reply_id)
);

/*==============================================================*/
/* Table: userinfo                                              */
/*==============================================================*/
create table userinfo
(
   user_id              int not null,
   user_name            char(20) not null,
   user_passwrod        char(20) not null,
   user_nickname        char(20) not null,
   user_image           char(50) not null,
   primary key (user_id)
);

alter table BM add constraint FK_Relationship_1 foreign key (user_id)
      references userinfo (user_id) on delete restrict on update restrict;

alter table BM add constraint FK_Relationship_2 foreign key (borad_id)
      references borad (borad_id) on delete restrict on update restrict;

alter table post add constraint FK_Relationship_4 foreign key (user_id)
      references userinfo (user_id) on delete restrict on update restrict;

alter table post add constraint FK_Relationship_5 foreign key (borad_id)
      references borad (borad_id) on delete restrict on update restrict;

alter table reply add constraint FK_Relationship_6 foreign key (post_id)
      references post (post_id) on delete restrict on update restrict;

alter table reply add constraint FK_Relationship_7 foreign key (user_id)
      references userinfo (user_id) on delete restrict on update restrict;

这是用PowerDesigner创建了LogicalModel然后生成的MySql代码。*.hbm.xml就不放上来了。