1 -- --------------------------------------------------
3 -- --------------------------------------------------
5 ALTER TABLE client_group ADD COLUMN comment text;
6 ALTER TABLE client_group_member RENAME COLUMN clientid TO ClientId;
10 userid serial not null,
11 username text not null,
12 use_acl boolean default false,
13 enabled boolean default true,
14 comment text default '',
15 passwd text default '',
18 CREATE UNIQUE INDEX bweb_user_idx on bweb_user (username(255));
20 CREATE TABLE bweb_role
22 roleid serial not null,
23 rolename text not null,
24 comment text default '',
27 CREATE UNIQUE INDEX bweb_role_idx on bweb_role (rolename(255));
28 INSERT INTO bweb_role (rolename) VALUES ('r_user_mgnt');
29 INSERT INTO bweb_role (rolename) VALUES ('r_group_mgnt');
30 INSERT INTO bweb_role (rolename) VALUES ('r_configure');
32 INSERT INTO bweb_role (rolename) VALUES ('r_autochanger_mgnt');
33 INSERT INTO bweb_role (rolename) VALUES ('r_location_mgnt');
34 INSERT INTO bweb_role (rolename) VALUES ('r_delete_job');
35 INSERT INTO bweb_role (rolename) VALUES ('r_prune');
36 INSERT INTO bweb_role (rolename) VALUES ('r_purge');
38 INSERT INTO bweb_role (rolename) VALUES ('r_view_job');
39 INSERT INTO bweb_role (rolename) VALUES ('r_view_stat');
40 INSERT INTO bweb_role (rolename) VALUES ('r_view_media');
42 INSERT INTO bweb_role (rolename) VALUES ('r_run_job');
43 INSERT INTO bweb_role (rolename) VALUES ('r_cancel_job');
44 INSERT INTO bweb_role (rolename) VALUES ('r_client_status');
46 CREATE TABLE bweb_role_member
48 roleid integer not null,
49 userid integer not null,
50 primary key (roleid, userid)
53 CREATE TABLE bweb_client_group_acl
55 client_group_id integer not null,
56 userid integer not null,
57 primary key (client_group_id, userid)