create table entity
(
id int unsigned not null,
type enum ('t', 'c'),
name varchar(64) not null,
credentials varchar(32),
primary key (id),
key (name)
);
create table relation
(
parent int unsigned not null,
child int unsigned not null,
type enum ('t', 'c'),
key (parent),
key (child)
);
create table attribute
(
id int unsigned not null,
pos int unsigned not null,
name varchar(255) not null,
isstring bool,
value mediumtext not null,
key (id),
key (name)
);
create table permission
(
id int unsigned not null,
type varchar(255) not null,
name varchar(255) not null,
actions varchar(255) not null,
key (id)
);
insert into entity values(1, 't', 'root', null);
insert into entity values(2, 'c', 'root', 'boot');
insert into relation values(1, 2, 'c');
insert into relation values(0, 1, 't');
|
Anvil
