1 -- --------------------------------------------------
3 -- --------------------------------------------------
7 userid serial not null,
8 username text not null,
9 use_acl boolean default false,
10 enabled boolean default true,
11 comment text default '',
12 passwd text default '',
15 CREATE UNIQUE INDEX bweb_user_idx on bweb_user (username(255));
17 CREATE TABLE bweb_role
19 roleid serial not null,
20 rolename text not null,
21 -- comment text default '',
24 CREATE UNIQUE INDEX bweb_role_idx on bweb_role (rolename(255));
25 INSERT INTO bweb_role (rolename) VALUES ('r_user_mgnt');
26 INSERT INTO bweb_role (rolename) VALUES ('r_group_mgnt');
27 INSERT INTO bweb_role (rolename) VALUES ('r_configure');
29 INSERT INTO bweb_role (rolename) VALUES ('r_autochanger_mgnt');
30 INSERT INTO bweb_role (rolename) VALUES ('r_location_mgnt');
31 INSERT INTO bweb_role (rolename) VALUES ('r_delete_job');
32 INSERT INTO bweb_role (rolename) VALUES ('r_prune');
33 INSERT INTO bweb_role (rolename) VALUES ('r_purge');
35 INSERT INTO bweb_role (rolename) VALUES ('r_view_job');
36 INSERT INTO bweb_role (rolename) VALUES ('r_view_stat');
37 INSERT INTO bweb_role (rolename) VALUES ('r_view_media');
39 INSERT INTO bweb_role (rolename) VALUES ('r_run_job');
40 INSERT INTO bweb_role (rolename) VALUES ('r_cancel_job');
41 INSERT INTO bweb_role (rolename) VALUES ('r_client_status');
43 CREATE TABLE bweb_role_member
45 roleid integer not null,
46 userid integer not null,
47 primary key (roleid, userid)
50 CREATE TABLE bweb_client_group_acl
52 client_group_id integer not null,
53 userid integer not null,
54 primary key (client_group_id, userid)