From d9e6366da0b8a9f00502b05baa813e63e4c7836f Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Sat, 10 Nov 2007 13:18:12 +0000 Subject: [PATCH] ebl remove user managment git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/branches/Branch-2.2@5888 91ce42f0-d328-0410-95d8-f526ca767f89 --- gui/bweb/script/bweb-postgresql.sql | 70 ----------------------------- 1 file changed, 70 deletions(-) diff --git a/gui/bweb/script/bweb-postgresql.sql b/gui/bweb/script/bweb-postgresql.sql index 3170cae449..ddd540b86f 100644 --- a/gui/bweb/script/bweb-postgresql.sql +++ b/gui/bweb/script/bweb-postgresql.sql @@ -1,74 +1,4 @@ --- -------------------------------------------------- --- Upgrade from 2.2 --- -------------------------------------------------- - -CREATE FUNCTION concat (text, text) RETURNS text AS ' -DECLARE -result text; -BEGIN -IF $1 is not null THEN -result := $1 || $2; -END IF; - -RETURN result; -END; -' LANGUAGE plpgsql; - -CREATE AGGREGATE group_concat( -sfunc = concat, -basetype = text, -stype = text, -initcond = '' -); - -BEGIN; -CREATE TABLE bweb_user -( - userid serial not null, - username text not null, - use_acl boolean default false, - comment text default '', - passwd text default '', - primary key (userid) -); -CREATE UNIQUE INDEX bweb_user_idx on bweb_user (username); - -CREATE TABLE bweb_role -( - roleid serial not null, - rolename text not null, --- comment text default '', - primary key (roleid) -); -CREATE UNIQUE INDEX bweb_role_idx on bweb_role (rolename); - -INSERT INTO bweb_role (rolename) VALUES ('r_user_mgnt'); -INSERT INTO bweb_role (rolename) VALUES ('r_delete_job'); -INSERT INTO bweb_role (rolename) VALUES ('r_prune'); -INSERT INTO bweb_role (rolename) VALUES ('r_purge'); -INSERT INTO bweb_role (rolename) VALUES ('r_group_mgnt'); -INSERT INTO bweb_role (rolename) VALUES ('r_location_mgnt'); -INSERT INTO bweb_role (rolename) VALUES ('r_cancel_job'); -INSERT INTO bweb_role (rolename) VALUES ('r_run_job'); -INSERT INTO bweb_role (rolename) VALUES ('r_configure'); -INSERT INTO bweb_role (rolename) VALUES ('r_client_status'); -INSERT INTO bweb_role (rolename) VALUES ('r_view_job'); - -CREATE TABLE bweb_role_member -( - roleid integer not null, - userid integer not null, - primary key (roleid, userid) -); - -CREATE TABLE bweb_client_group_acl -( - client_group_id integer not null, - userid integer not null, - primary key (client_group_id, userid) -); -COMMIT; -- -------------------------------------------------- -- Upgrade from 2.0 -- -------------------------------------------------- -- 2.39.5