drop table hive_acl;
drop table hive_account_role;
drop table hive_account;
drop table hive_role;
create table hive_account (
id int identity,
account varchar(50) unique not null,
password varchar(16) not null,
primary key (id),
);
create table hive_role (
id int identity,
role varchar(50) unique not null,
primary key (id),
);
create table hive_account_role (
account_id int,
role_id int,
primary key (account_id, role_id),
foreign key (account_id) references hive_account(id),
foreign key (role_id) references hive_role(id),
);
create table hive_acl (
role_id int,
component varchar(50),
instance varchar(50),
op varchar(50),
primary key (role_id, component, instance, op),
foreign key (role_id) references hive_role(id),
);
insert into hive_account (account, password) values ('admin', 'abc');
insert into hive_account (account, password) values ('amen', 'abc');
insert into hive_account (account, password) values ('anonymous', '');
insert into hive_role (role) values ('admins');
insert into hive_role (role) values ('users');
insert into hive_role (role) values ('guests');
insert into hive_account_role (account_id, role_id) values (1,1);
insert into hive_account_role (account_id, role_id) values (1,2);
insert into hive_account_role (account_id, role_id) values (2,2);
insert into hive_account_role (account_id, role_id) values (3,3);
insert into hive_acl (role_id, component, instance, op) values (1, '*', '*', '*');
insert into hive_acl (role_id, component, instance, op) values (2, 'category', 'manager', 'none');
insert into hive_acl (role_id, component, instance, op) values (2, 'category', '*', 'read');
insert into hive_acl (role_id, component, instance, op) values (2, 'category', 'public', 'write');
insert into hive_acl (role_id, component, instance, op) values (3, 'category', 'public', 'read');
<p class="indent">
|