summaryrefslogtreecommitdiffstats
path: root/pbs-newdata.sql
diff options
context:
space:
mode:
authorBjörn Geiger2011-04-12 14:54:50 +0200
committerBjörn Geiger2011-04-12 14:54:50 +0200
commite5fcbd73596db87bb5cd24e1ba91cf735549b3c3 (patch)
tree52c44f8a51a0684c9630cdee19c83ce6a7d6458a /pbs-newdata.sql
parentMerge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2 (diff)
downloadpbs2-e5fcbd73596db87bb5cd24e1ba91cf735549b3c3.tar.gz
pbs2-e5fcbd73596db87bb5cd24e1ba91cf735549b3c3.tar.xz
pbs2-e5fcbd73596db87bb5cd24e1ba91cf735549b3c3.zip
verschiedene Korrekturen
Diffstat (limited to 'pbs-newdata.sql')
-rw-r--r--pbs-newdata.sql15
1 files changed, 7 insertions, 8 deletions
diff --git a/pbs-newdata.sql b/pbs-newdata.sql
index 5715328..14c10dd 100644
--- a/pbs-newdata.sql
+++ b/pbs-newdata.sql
@@ -36,23 +36,22 @@ INSERT INTO `pbs`.`pbs_groupgroups` (`parentID`, `groupID`) VALUES
-- Adding role
-INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES (2, '1', 'Role 2-Group1', NULL, 0);
-INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES (3, '2', 'Role 1-Group2', NULL, 0);
-INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES (4, '2', 'Role 2-Group2', NULL, 0);
+INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES (4, '2', 'Role 1-Group2', NULL, 0);
+INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES (5, '2', 'Role 2-Group2', NULL, 0);
+INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES (6, '2', 'Role 3-Group2', NULL, 0);
INSERT INTO `pbs_rightroles` (`roleID`, `rightID`) VALUES
-(2, 4),
-(2, 3),
-(3, 1),
-(4, 2);
+(4, 4),
+(4, 3),
+(5, 1),
+(6, 2);
-- Adding memberships
INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`) VALUES (1, '1', '1', '1');
INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`) VALUES (2, '1', '2', '2');
INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`) VALUES (3, '2', '3', '1');
INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`) VALUES (4, '2', '4', '3');
-INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`) VALUES (NULL , '1', '2', '1');
-- Adding clients
INSERT INTO `pbs_client` (`clientID`, `groupID`,`macadress`, `hardwarehash`) VALUES