1,新建三張表think_auth_group,think_auth_group_access,think_auth_rules

CREATE TABLE think_auth_group(

id int(11) not null 主鍵auto_increment,

title char(100) NOT NULL,

狀態(tài)tinyint( 1) DEFAULT NULL,

rules char(80) DEFAULT NULL,

create_time int(11) DEFAULT NULL)

ENGINE=InnoDB DEFAULT CHARSET=utf8;

創(chuàng)建表 `think_auth_group_access` (

? `uid `smallint(5) unsigned NOT NULL,

? `group_id`smallint(5) unsigned NOT NULL,

? 唯一密鑰 `uid_group_id` (`uid`,`group_id`),

? KEY `uid` (`uid`) ,

? KEY `group_id` (`group_id`)

) ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE think_auth_rules(

id int(11) not null 主鍵 auto_increment,

name varchar （ 100) NOT NULL,?

title varchar(100) NOT NULL,?

type tinyint(1) DEFAULT NULL,?

status tinyint(1) DEFAULT NULL,?

condition char(100) DEFAULT NULL,

pidsmallint( 5)?DEFAULT NULL,

sort tinyint(4) DEFAULT NULL,

create_time int(11) DEFAULT NULL)

ENGINE=InnoDB DEFAULT CHARSET=utf8;