mysql数据库web访问权限_web权限数据库设计

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

本文原创发布php中文网，转载请注明出处，感谢您的尊重！