summaryrefslogtreecommitdiffstats
path: root/setup/pbs.sql
diff options
context:
space:
mode:
authorBjörn Geiger2011-09-07 14:41:11 +0200
committerBjörn Geiger2011-09-07 14:41:11 +0200
commitd2131cfff8b5a13fd8c315489070f467ec56961a (patch)
treef16db02afc4767b407f97c77f853fd01a3cbc1d1 /setup/pbs.sql
parentMerge branch 'master' of git.openslx.org:lsfks/projekte/pbs2 (diff)
downloadpbs2-d2131cfff8b5a13fd8c315489070f467ec56961a.tar.gz
pbs2-d2131cfff8b5a13fd8c315489070f467ec56961a.tar.xz
pbs2-d2131cfff8b5a13fd8c315489070f467ec56961a.zip
kleine Datenbankänderung
Diffstat (limited to 'setup/pbs.sql')
-rw-r--r--setup/pbs.sql56
1 files changed, 32 insertions, 24 deletions
diff --git a/setup/pbs.sql b/setup/pbs.sql
index 8d55278..377f22e 100644
--- a/setup/pbs.sql
+++ b/setup/pbs.sql
@@ -400,7 +400,8 @@ INSERT INTO `pbs_rightcategory` (`rightcategoryID`, `title`) VALUES
(9, 'Client'),
(10, 'Pool'),
(11, 'Filter'),
-(12, 'Session');
+(12, 'Session'),
+(13, 'PoolCtrl');
-- Insert rights
INSERT INTO `pbs_right` (`rightID`, `rightcategoryID`, `shortcut`, `title`, `description`) VALUES
@@ -615,32 +616,39 @@ INSERT INTO `pbs_right` (`rightID`, `rightcategoryID`, `shortcut`, `title`, `des
-- Session
-- Session Übersicht ansehen
-(NULL, '12', 'so', 'Show overview of Session', NULL)
+(NULL, '12', 'so', 'Show overview of Session', NULL),
+
+ -- Nochmals Gruppe
+ -- Eigene Gruppe bearbeitern
+(NULL, '2', 'geo', 'Edit own group', NULL),
+ -- Andere Gruppe bearbeitne
+(NULL, '2', 'ge', 'Edit other group', NULL),
+ -- Gruppen verbinden
+(NULL, '2', 'glk', 'Link groups', NULL),
+ -- Übersicht der Gruppenanfragen der eigenen Gruppe
+(NULL, '2', 'grog', 'Overview of own group requests', NULL),
+ -- Übersicht der Gruppenanfragen anderer Gruppen
+(NULL, '2', 'grotg', 'Overview of other group requests', NULL),
+ -- Mitglieder der eigenen Groupe anzeigen
+(NULL, '2', 'gsmgo', 'Show members of own group', NULL),
-- PoolCtrl
-- Event Übersicht ansehen
-(NULL, '11', 'eo', 'Show overview of Events', NULL),
+(NULL, '13', 'eo', 'Show overview of Events', NULL),
-- Events von anderen in der Übersicht anzeigen
-(NULL, '11', 'eoo', 'Show Events of others in the overview', NULL),
+(NULL, '13', 'eoo', 'Show Events of others in the overview', NULL),
-- Events erstellen
-(NULL, '11', 'ec', 'Create new Event', NULL),
+(NULL, '13', 'ec', 'Create new Event', NULL),
-- Eigene Events löschen
-(NULL, '11', 'ed', 'Delete own Events', NULL),
+(NULL, '13', 'ed', 'Delete own Events', NULL),
-- Events von Anderen löschen
-(NULL, '11', 'edo', 'Delete Events of others', NULL),
+(NULL, '13', 'edo', 'Delete Events of others', NULL),
-- Eigene Events bearbeiten
-(NULL, '11', 'ee', 'Edit own Events', NULL),
+(NULL, '13', 'ee', 'Edit own Events', NULL),
-- Events von Anderen bearbeiten
-(NULL, '11', 'eeo', 'Create new Event', NULL),
+(NULL, '13', 'eeo', 'Create new Event', NULL),
-- Events ausführen
-(NULL, '11', 'er', 'Run Events', NULL);
-
-INSERT INTO `pbs_right` (`rightID`, `rightcategoryID`, `shortcut`, `title`, `description`) VALUES (NULL, '2', 'geo', 'Edit own group', NULL);
-INSERT INTO `pbs_right` (`rightID`, `rightcategoryID`, `shortcut`, `title`, `description`) VALUES (NULL, '2', 'ge', 'Edit other group', NULL);
-INSERT INTO `pbs_right` (`rightID`, `rightcategoryID`, `shortcut`, `title`, `description`) VALUES (NULL, '2', 'glk', 'Link groups', NULL);
-INSERT INTO `pbs_right` (`rightID`, `rightcategoryID`, `shortcut`, `title`, `description`) VALUES (NULL, '2', 'grog', 'Overview of own group requests', NULL);
-INSERT INTO `pbs_right` (`rightID`, `rightcategoryID`, `shortcut`, `title`, `description`) VALUES (NULL, '2', 'grotg', 'Overview of other group requests', NULL);
-INSERT INTO `pbs_right` (`rightID`, `rightcategoryID`, `shortcut`, `title`, `description`) VALUES (NULL, '2', 'gsmgo', 'Show members of own group', NULL);
+(NULL, '13', 'er', 'Run Events', NULL);
-- Adding Super-User
INSERT INTO `pbs_group` (`groupID` ,`title` ,`description`)VALUES
@@ -648,37 +656,37 @@ INSERT INTO `pbs_group` (`groupID` ,`title` ,`description`)VALUES
INSERT INTO `pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES
(1, '1', 'SuperAdmin', 'The SuperAdmin', 0);
INSERT INTO `pbs_rightroles` (`roleID`, `rightID`) VALUES
-(1, 1),(1, 2),(1, 3),(1, 4),(1, 5),(1, 6),(1, 7),(1, 8),(1, 9),(1, 10),(1, 11),(1, 12),(1, 13),(1, 14),(1, 15),(1, 16),(1, 17),(1, 18),(1, 19),(1, 20),(1, 21),(1, 22),(1, 23),(1, 24),(1, 25),(1, 26),(1, 27),(1, 28),(1, 29),(1, 30),(1, 31),(1, 32),(1, 33),(1, 34),(1, 35),(1, 36),(1, 37),(1, 38),(1, 39),(1, 40),(1, 41),(1, 42),(1, 43),(1, 44),(1, 45),(1, 46),(1, 47),(1, 48),(1, 49),(1, 50),(1, 51),(1, 52),(1, 53),(1, 54),(1, 55),(1, 56),(1, 57),(1, 58),(1, 59),(1, 60),(1, 61),(1, 62),(1, 63),(1, 64),(1, 65),(1, 66),(1, 67),(1, 68),(1, 69),(1, 70),(1, 71),(1, 72),(1, 73),(1, 74),(1, 75),(1, 76),(1, 77),(1, 78),(1, 79),(1, 80),(1, 81),(1, 82),(1, 83),(1, 84),(1, 85),(1, 86),(1, 87),(1, 88),(1, 89),(1, 90),(1, 91),(1, 92),(1, 93),(1, 94),(1, 95),(1, 96),(1, 97),(1, 98),(1, 99),(1, 100);
+(1, 1),(1, 2),(1, 3),(1, 4),(1, 5),(1, 6),(1, 7),(1, 8),(1, 9),(1, 10),(1, 11),(1, 12),(1, 13),(1, 14),(1, 15),(1, 16),(1, 17),(1, 18),(1, 19),(1, 20),(1, 21),(1, 22),(1, 23),(1, 24),(1, 25),(1, 26),(1, 27),(1, 28),(1, 29),(1, 30),(1, 31),(1, 32),(1, 33),(1, 34),(1, 35),(1, 36),(1, 37),(1, 38),(1, 39),(1, 40),(1, 41),(1, 42),(1, 43),(1, 44),(1, 45),(1, 46),(1, 47),(1, 48),(1, 49),(1, 50),(1, 51),(1, 52),(1, 53),(1, 54),(1, 55),(1, 56),(1, 57),(1, 58),(1, 59),(1, 60),(1, 61),(1, 62),(1, 63),(1, 64),(1, 65),(1, 66),(1, 67),(1, 68),(1, 69),(1, 70),(1, 71),(1, 72),(1, 73),(1, 74),(1, 75),(1, 76),(1, 77),(1, 78),(1, 79),(1, 80),(1, 81),(1, 82),(1, 83),(1, 84),(1, 85),(1, 86),(1, 87),(1, 88),(1, 89),(1, 90),(1, 91),(1, 92),(1, 93),(1, 94),(1, 95),(1, 96),(1, 97),(1, 98),(1, 99),(1, 100),(1, 101),(1, 102),(1, 103),(1, 104),(1, 105),(1, 106),(1, 107),(1, 108);
-- Adding Community-Admin
INSERT INTO `pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES
(2, 1, 'Community-Admin', 'This role can observe and edit all group, person and role specific details', 1);
INSERT INTO `pbs_rightroles` (`roleID`, `rightID`) VALUES
-(2, 1),(2, 2),(2, 3),(2, 4),(2, 5),(2, 6),(2, 7),(2, 8),(2, 9),(2, 10),(2, 11),(2, 12),(2, 13),(2, 14),(2, 15),(2, 16),(2, 17),(2, 18),(2, 19),(2, 20),(2, 21),(2, 22),(2, 23),(2, 24),(2, 25),(2, 26),(2, 27),(2, 28),(2, 29),(2, 30),(2, 31),(2, 33),(2, 37),(2, 46),(2, 50),(2, 51),(2, 52),(2, 57),(2, 63),(2, 70),(2, 71),(2, 72),(2, 73),(2, 95),(2, 96),(2, 97),(2, 98),(2, 99),(2, 100);
+(2, 1),(2, 2),(2, 3),(2, 4),(2, 5),(2, 6),(2, 7),(2, 8),(2, 9),(2, 10),(2, 11),(2, 12),(2, 13),(2, 14),(2, 15),(2, 16),(2, 17),(2, 18),(2, 19),(2, 20),(2, 21),(2, 22),(2, 23),(2, 24),(2, 25),(2, 26),(2, 27),(2, 28),(2, 29),(2, 30),(2, 31),(2, 33),(2, 37),(2, 46),(2, 50),(2, 51),(2, 52),(2, 57),(2, 63),(2, 70),(2, 71),(2, 72),(2, 73),(2, 95),(2, 96),(2, 97),(2, 98),(2, 99),(2, 100),(2, 101),(2, 102),(2, 103),(2, 104),(2, 105),(2, 106),(2, 107);
-- Adding Monitor-Admin
INSERT INTO `pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES
(3, 1, 'Monitor-Admin', 'This role can monitor all details of the pbs-server', 1);
INSERT INTO `pbs_rightroles` (`roleID`, `rightID`) VALUES
-(3, 1),(3, 9),(3, 10),(3, 11),(3, 12),(3, 16),(3, 23),(3, 25),(3, 32),(3, 39),(3, 45),(3, 50),(3, 51),(3, 52),(3, 56),(3, 62),(3, 71),(3, 72),(3, 73),(3, 75),(3, 79),(3, 86),(3, 94);
+(3, 1),(3, 9),(3, 10),(3, 11),(3, 12),(3, 16),(3, 23),(3, 25),(3, 32),(3, 39),(3, 45),(3, 50),(3, 51),(3, 52),(3, 56),(3, 62),(3, 71),(3, 72),(3, 73),(3, 75),(3, 79),(3, 86),(3, 94),(3, 101);
-- Adding Default-Admin
INSERT INTO `pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES
-(4, 1, 'Admin', 'This role is the defautl Admin', 1);
+(4, 1, 'Admin', 'This role is the default Admin', 1);
INSERT INTO `pbs_rightroles` (`roleID`, `rightID`) VALUES
-(4, 2),(4, 3),(4, 4),(4, 10),(4, 12),(4, 13),(4, 16),(4, 17),(4, 18),(4, 19),(4, 20),(4, 22),(4, 23),(4, 24),(4, 25),(4, 26),(4, 28),(4, 29),(4, 30),(4, 31),(4, 32),(4, 34),(4, 35),(4, 36),(4, 37),(4, 39),(4, 40),(4, 41),(4, 42),(4, 43),(4, 45),(4, 47),(4, 48),(4, 49),(4, 50),(4, 51),(4, 52),(4, 53),(4, 55),(4, 56),(4, 58),(4, 59),(4, 60),(4, 62),(4, 64),(4, 65),(4, 66),(4, 67),(4, 68),(4, 69),(4, 70),(4, 71),(4, 72),(4, 73),(4, 75),(4, 76),(4, 77),(4, 78),(4, 79),(4, 80),(4, 81),(4, 82),(4, 83),(4, 84),(4, 85),(4, 86),(4, 87),(4, 88),(4, 89),(4, 90),(4, 91),(4, 92),(4, 93),(4, 94);
+(4, 2),(4, 3),(4, 4),(4, 10),(4, 12),(4, 13),(4, 16),(4, 17),(4, 18),(4, 19),(4, 20),(4, 22),(4, 23),(4, 24),(4, 25),(4, 26),(4, 28),(4, 29),(4, 30),(4, 31),(4, 32),(4, 34),(4, 35),(4, 36),(4, 37),(4, 39),(4, 40),(4, 41),(4, 42),(4, 43),(4, 45),(4, 47),(4, 48),(4, 49),(4, 50),(4, 51),(4, 52),(4, 53),(4, 55),(4, 56),(4, 58),(4, 59),(4, 60),(4, 62),(4, 64),(4, 65),(4, 66),(4, 67),(4, 68),(4, 69),(4, 70),(4, 71),(4, 72),(4, 73),(4, 75),(4, 76),(4, 77),(4, 78),(4, 79),(4, 80),(4, 81),(4, 82),(4, 83),(4, 84),(4, 85),(4, 86),(4, 87),(4, 88),(4, 89),(4, 90),(4, 91),(4, 92),(4, 93),(4, 94),(4, 101),(4, 103),(4, 104),(4, 106);
-- Adding Meta-Admin
INSERT INTO `pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES
(5, 1, 'Meta-Admin', 'This role can edit all metadata from entrys', 1);
INSERT INTO `pbs_rightroles` (`roleID`, `rightID`) VALUES
-(5, 1),(5, 2),(5, 3),(5, 4),(5, 32),(5, 38),(5, 39),(5, 44),(5, 45),(5, 50),(5, 51),(5, 52),(5, 54),(5, 55),(5, 61),(5, 62),(5, 71),(5, 72),(5, 73),(5, 74),(5, 75),(5, 86),(5, 89);
+(5, 1),(5, 2),(5, 3),(5, 4),(5, 32),(5, 38),(5, 39),(5, 44),(5, 45),(5, 50),(5, 51),(5, 52),(5, 54),(5, 55),(5, 61),(5, 62),(5, 71),(5, 72),(5, 73),(5, 74),(5, 75),(5, 86),(5, 89),(5, 101),(5, 103),(5, 104),(5, 106);
-- Adding User
INSERT INTO `pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES
(6, 1, 'User', 'The default user', 1);
INSERT INTO `pbs_rightroles` (`roleID`, `rightID`) VALUES
-(6, 2),(6, 3),(6, 4),(6, 16),(6, 19),(6, 33),(6, 37),(6, 46),(6, 50),(6, 51),(6, 52),(6, 57),(6, 63),(6, 70),(6, 71),(6, 72);
+(6, 2),(6, 3),(6, 4),(6, 16),(6, 19),(6, 33),(6, 37),(6, 46),(6, 50),(6, 51),(6, 52),(6, 57),(6, 63),(6, 70),(6, 71),(6, 72),(6, 101),(6, 103),(6, 104),(6, 106);
-- Adding a Person for SuperAdmin
INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `housenumber`, `city`, `postalcode`, `logindate`, `registerdate`, `email`, `login`, `password`, `password_salt`, `loginpassword`) VALUES