23 lines
1.3 KiB
SQL
Executable File
23 lines
1.3 KiB
SQL
Executable File
-- # $Id$
|
|
-- # $HeadURL$
|
|
-- # $Author$
|
|
|
|
-- Organisator user
|
|
|
|
INSERT INTO opm.opm_group (id, name, description, type_id, is_hidden) VALUES (1001, 'Organisator' , 'Organisator rights', 3, true);
|
|
INSERT INTO opm.opm_group (id, name, description, type_id, is_hidden) VALUES (1002, 'Organisator group', 'Organisator 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, 'Organisator', md5('Organisator'), 'User Organisator', 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;
|
|
|
|
-- For ABT Database, please uncomment
|
|
-- UPDATE opm.opm_operator SET password = md5('guez') WHERE id = 99;
|