/** * Database schema required by \yii\rbac\DbManager. * * @author Qiang Xue <qiang.xue@gmail.com> * @author Alexander Kochetov <creocoder@gmail.com> * @link http://www.yiiframework.com/ * @copyright 2008 Yii Software LLC * @license http://www.yiiframework.com/license/ * @since 2.0 */ drop table if exists [tbl_auth_assignment]; drop table if exists [tbl_auth_item_child]; drop table if exists [tbl_auth_item]; create table [tbl_auth_item] ( [name] varchar(64) not null, [type] integer not null, [description] text, [biz_rule] text, [data] text, primary key ([name]), key [type] ([type]) ); create table [tbl_auth_item_child] ( [parent] varchar(64) not null, [child] varchar(64) not null, primary key ([parent],[child]), foreign key ([parent]) references [tbl_auth_item] ([name]) on delete cascade on update cascade, foreign key ([child]) references [tbl_auth_item] ([name]) on delete cascade on update cascade ); create table [tbl_auth_assignment] ( [item_name] varchar(64) not null, [user_id] varchar(64) not null, [biz_rule] text, [data] text, primary key ([item_name],[user_id]), foreign key ([item_name]) references [tbl_auth_item] ([name]) on delete cascade on update cascade );