create table account ( accid int default 0 not null, acccode char(20), accname varchar(30), primary key (accid) ) engine=innodb default charset=utf8;create table role ( roleid int default 0 not null, rolecode char(20), rolename varchar(30)
create table account ( accid int default '0' not null, acccode char(20), accname varchar(30), primary key (accid) ) engine=innodb default charset=utf8;create table role ( roleid int default '0' not null, rolecode char(20), rolename varchar(30), primary key (roleid) ) engine=innodb default charset=utf8;create table accrole ( accroleid int default '0' not null, faccid int, froleid int, primary key (accroleid), constraint accrole_fk1 foreign key (faccid) references account (accid) , constraint accrole_fk2 foreign key (froleid) references role (roleid), index accrole_fk1 (faccid), index accrole_fk2 (froleid) ) engine=innodb default charset=utf8; create table module ( modid int default '0' not null, modcode char(20), modname varchar(30), parentcode char(20), url varchar(50), primary key (modid) ) engine=innodb default charset=utf8;create table privilege ( priid int default '0' not null, pricode char(20), priname varchar(30), primary key (priid) ) engine=innodb default charset=utf8; create table modpri ( modpriid int default '0' not null, modid int, priid int, primary key (modpriid), constraint modpri_fk1 foreign key (modid) references module (modid) , constraint modpri_fk2 foreign key (priid) references privilege (priid), index modpri_fk1 (modid), index modpri_fk2 (priid) ) engine=innodb default charset=utf8;create table rolemodpri ( rolemodpri int default '0' not null, roleid int, modpriid int, primary key (rolemodpri), constraint rolemodpri_fk1 foreign key (roleid) references role (roleid) , constraint rolemodpri_fk2 foreign key (modpriid) references modpri (modpriid), index rolemodpri_fk1 (roleid), index rolemodpri_fk2 (modpriid) ) engine=innodb default charset=utf8;
设计图：
附件：
http://download.csdn.net/detail/linzhichao12345/7741975