yii2

1
/**
2
 * Database schema required by \yii\rbac\DbManager.
3
 *
4
 * @author Qiang Xue <qiang.xue@gmail.com>
5
 * @author Alexander Kochetov <creocoder@gmail.com>
6
 * @link https://www.yiiframework.com/
7
 * @copyright 2008 Yii Software LLC
8
 * @license https://www.yiiframework.com/license/
9
 * @since 2.0
10
 */
11

12
drop table if exists "auth_assignment";
13
drop table if exists "auth_item_child";
14
drop table if exists "auth_item";
15
drop table if exists "auth_rule";
16

17
create table "auth_rule"
18
(
19
    "name"  varchar(64) not null,
20
    "data"  bytea,
21
    "created_at"           integer,
22
    "updated_at"           integer,
23
    primary key ("name")
24
);
25

26
create table "auth_item"
27
(
28
   "name"                 varchar(64) not null,
29
   "type"                 smallint not null,
30
   "description"          text,
31
   "rule_name"            varchar(64),
32
   "data"                 bytea,
33
   "created_at"           integer,
34
   "updated_at"           integer,
35
   primary key ("name"),
36
   foreign key ("rule_name") references "auth_rule" ("name") on delete set null on update cascade
37
);
38

39
create index auth_item_type_idx on "auth_item" ("type");
40

41
create table "auth_item_child"
42
(
43
   "parent"               varchar(64) not null,
44
   "child"                varchar(64) not null,
45
   primary key ("parent","child"),
46
   foreign key ("parent") references "auth_item" ("name") on delete cascade on update cascade,
47
   foreign key ("child") references "auth_item" ("name") on delete cascade on update cascade
48
);
49

50
create table "auth_assignment"
51
(
52
   "item_name"            varchar(64) not null,
53
   "user_id"              varchar(64) not null,
54
   "created_at"           integer,
55
   primary key ("item_name","user_id"),
56
   foreign key ("item_name") references "auth_item" ("name") on delete cascade on update cascade
57
);
58

59
create index auth_assignment_user_id_idx on "auth_assignment" ("user_id");
60