24 lines
1.5 KiB
SQL
Executable File
24 lines
1.5 KiB
SQL
Executable File
-- # $Id$
|
|
-- # $HeadURL$
|
|
-- # $Author$
|
|
|
|
-- Organizer user
|
|
|
|
INSERT INTO opm.opm_group (id, name, description, type_id, is_hidden) VALUES (1001, 'Organizer' , 'Organizer rights', 3, true);
|
|
INSERT INTO opm.opm_group (id, name, description, type_id, is_hidden) VALUES (1002, 'Organizer group', 'Organizer rights', 2, false);
|
|
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) SELECT 1001, id FROM opm.opm_group WHERE type_id = 4;
|
|
INSERT INTO opm.opm_group_group (group_id, is_member_of_group_id) SELECT 1002, id FROM opm.opm_group WHERE type_id = 4;
|
|
|
|
INSERT INTO opm.opm_operator (id, name, password, description, primary_group_id, projection_priority, audio_channel_priority, visible_parties) VALUES (99, 'Organizer', md5('Organizer'), 'User Organizer', 1002, 1, 1, '{0,1,2,3,4,5,6,7,8,9,10,11,12,13}');
|
|
|
|
ALTER SEQUENCE opm.opm_operator_id_seq RESTART WITH 100;
|
|
--ALTER SEQUENCE opm.opm_group_group_id_seq RESTART WITH 100; -- No need, ids were always given automatically.
|
|
ALTER SEQUENCE opm.opm_group_id_seq RESTART WITH 2000;
|
|
ALTER SEQUENCE opm.opm_acl_allow_id_seq RESTART WITH 2000;
|
|
ALTER SEQUENCE opm.opm_acl_deny_id_seq RESTART WITH 2000;
|
|
|
|
-- UPDATE opm.opm_group SET name = 'Organizer', description = 'Organizer rights' WHERE id = 1001;
|
|
-- UPDATE opm.opm_group SET name = 'Organizer group', description = 'Organizer rights' WHERE id = 1002;
|
|
-- UPDATE opm.opm_operator SET name = 'Organizer', password = md5('Organizer'), description = 'User Organizer' WHERE id = 99;
|