1 -- --------------------------------------------------
3 -- --------------------------------------------------
5 CREATE FUNCTION concat (text, text) RETURNS text AS '
17 CREATE AGGREGATE group_concat(
25 CREATE TABLE bweb_user
27 userid serial not null,
28 username text not null,
29 use_acl boolean default false,
30 enabled boolean default true,
31 comment text default '',
32 passwd text default '',
35 CREATE UNIQUE INDEX bweb_user_idx on bweb_user (username);
37 CREATE TABLE bweb_role
39 roleid serial not null,
40 rolename text not null,
41 -- comment text default '',
44 CREATE UNIQUE INDEX bweb_role_idx on bweb_role (rolename);
46 INSERT INTO bweb_role (rolename) VALUES ('r_user_mgnt');
47 INSERT INTO bweb_role (rolename) VALUES ('r_group_mgnt');
48 INSERT INTO bweb_role (rolename) VALUES ('r_configure');
50 INSERT INTO bweb_role (rolename) VALUES ('r_autochanger_mgnt');
51 INSERT INTO bweb_role (rolename) VALUES ('r_location_mgnt');
52 INSERT INTO bweb_role (rolename) VALUES ('r_delete_job');
53 INSERT INTO bweb_role (rolename) VALUES ('r_prune');
54 INSERT INTO bweb_role (rolename) VALUES ('r_purge');
56 INSERT INTO bweb_role (rolename) VALUES ('r_view_job');
57 INSERT INTO bweb_role (rolename) VALUES ('r_view_stat');
58 INSERT INTO bweb_role (rolename) VALUES ('r_view_media');
60 INSERT INTO bweb_role (rolename) VALUES ('r_run_job');
61 INSERT INTO bweb_role (rolename) VALUES ('r_cancel_job');
62 INSERT INTO bweb_role (rolename) VALUES ('r_client_status');
64 CREATE TABLE bweb_role_member
66 roleid integer not null,
67 userid integer not null,
68 primary key (roleid, userid)
71 CREATE TABLE bweb_client_group_acl
73 client_group_id integer not null,
74 userid integer not null,
75 primary key (client_group_id, userid)