Default-User added

1 files changed, 12 insertions, 1 deletions

diff --git a/pbs.sql b/pbs.sql
index 0d64807..cfd4592 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -578,6 +578,17 @@ INSERT INTO `pbs`.`pbs_right` (`rightID`, `rightcategoryID`, `shortcut`, `title`
 -- Adding Super-User
 INSERT INTO `pbs`.`pbs_group` (`groupID` ,`title` ,`description`)VALUES 
 (1, 'OpenSLX', 'This is the OpenSLX-Group');
-INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES (1, '1', 'SuperAdmin', 'The SuperAdmin', 0);
+INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES 
+	(1, '1', 'SuperAdmin', 'The SuperAdmin', 0);
 INSERT INTO `pbs`.`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);
+
+-- Adding Admin
+INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES 
+(2, 1, 'Community-Admin', NULL, 1);
+
+-- Adding User
+INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES 
+(3, 1, 'User', 'Default-User', 1);
+INSERT INTO `pbs`.`pbs_rightroles` (`roleID`, `rightID`) VALUES
+(3, 2),(3, 3),(3, 4),(3, 16),(3, 19),(3, 33),(3, 37),(3, 46),(3, 50),(3, 51),(3, 52),(3, 57),(3, 63),(3, 70),(3, 71),(3, 72);