67,513
社区成员
发帖
与我相关
我的任务
分享
drop database if exists bbs;
create database bbs default character set utf8;
use bbs;
drop table if exists member;
drop table if exists message;
drop table if exists category;
drop table if exists role;
drop table if exists memberrole;
drop table if exists page;
drop table if exists rolepage;
create table member
(
id int auto_increment,
name varchar(20),
password varchar(20),
sex int,
birth datetime,
phone varchar(20),
addr varchar(200),
headimage varchar(200),
state int,
primary key(id)
)type=innodb;
create table role
(
id int auto_increment,
name varchar(20),
url varchar(200),
primary key(id)
)type=innodb;
create table page
(
id int auto_increment,
name varchar(20),
url varchar(200),
parentid int,
primary key(id)
)type=innodb;
create table rolepage
(
id int auto_increment,
roleid int,
pageid int,
primary key(id)
)type=innodb;
create table memberrole
(
id int auto_increment,
memid int,
roleid int,
isdefault int,
primary key(id)
)type=innodb;
create table message
(
id int auto_increment,
title varchar(200),
content varchar(2000),
createdate datetime,
replycount int,
clickcount int,
lastreplydate datetime,
lastreplymemid int,
parentid int,
state int,
memid int,
primary key(id)
)type=innodb;
insert into page values(null,'系统后台','main.action',-1);
insert into page values(null,'权限管理','',1);
insert into page values(null,'页面管理','',1);
insert into page values(null,'用户管理','',1);
insert into page values(null,'角色管理','memberRole.action',2);
insert into page values(null,'页面角色管理','pageRole.action',2);
insert into page values(null,'用户角色管理','memberRole.action',2);
insert into page values(null,'页面管理','pageManage.action',3);
insert into page values(null,'用户管理','memberManage.action',4);
insert into role values(null,'超级管理员','/bbs/manager/main.action');
insert into role values(null,'注册会员','/bbs/public/messageList.action');
insert into rolepage values(null,1,1);
insert into rolepage values(null,1,2);
insert into rolepage values(null,1,3);
insert into rolepage values(null,1,4);
insert into rolepage values(null,1,5);
insert into rolepage values(null,1,6);
insert into rolepage values(null,1,7);
insert into rolepage values(null,1,8);
insert into rolepage values(null,1,9);
insert into member values(null,'admin','1',1,'2000-2-2 2:2:2','15977445042','深圳',null,1);
insert into member values(null,'guest','1',1,'2000-2-2 2:2:2','15977445042','深圳',null,1);
insert into memberrole values(null,1,1,1);
insert into memberrole values(null,2,2,1);