summaryrefslogtreecommitdiffstats
path: root/pbs-newdata.sql
diff options
context:
space:
mode:
authorBjörn Geiger2011-03-24 11:30:25 +0100
committerBjörn Geiger2011-03-24 11:30:25 +0100
commit512a4a5927ef02909b4160476aadf6e43c7a2df7 (patch)
tree8ec3b22d5490988f9829d83077d3794e4c95ce38 /pbs-newdata.sql
parentMerge branch 'master' of ssh://git.openslx.org/lsfks/master-teamprojekt/pbs2 (diff)
downloadpbs2-512a4a5927ef02909b4160476aadf6e43c7a2df7.tar.gz
pbs2-512a4a5927ef02909b4160476aadf6e43c7a2df7.tar.xz
pbs2-512a4a5927ef02909b4160476aadf6e43c7a2df7.zip
Testdaten Rechtetabelle
Diffstat (limited to 'pbs-newdata.sql')
-rw-r--r--pbs-newdata.sql16
1 files changed, 15 insertions, 1 deletions
diff --git a/pbs-newdata.sql b/pbs-newdata.sql
index 33c3ff3..9a447ef 100644
--- a/pbs-newdata.sql
+++ b/pbs-newdata.sql
@@ -35,13 +35,27 @@ INSERT INTO `pbs`.`pbs_groupgroups` (`parentID`, `groupID`) VALUES
(3, 9),
(3, 10);
-
-- Adding role
INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`) VALUES (1, '1', 'Role 1-Group1', NULL);
INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`) VALUES (2, '1', 'Role 2-Group1', NULL);
INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`) VALUES (3, '2', 'Role 1-Group2', NULL);
INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`) VALUES (4, '2', 'Role 2-Group2', NULL);
+-- Adding right
+INSERT INTO `pbs_right` (`rightID`, `title`, `description`) VALUES (1, 'Recht 1', NULL);
+INSERT INTO `pbs_right` (`rightID`, `title`, `description`) VALUES (2, 'Recht 2', NULL);
+INSERT INTO `pbs_right` (`rightID`, `title`, `description`) VALUES (3, 'Recht 3', NULL);
+INSERT INTO `pbs_right` (`rightID`, `title`, `description`) VALUES (4, 'Recht 4', NULL);
+
+INSERT INTO `pbs_rightroles` (`roleID`, `rightID`) VALUES
+(1, 1),
+(1, 2),
+(1, 3),
+(2, 4),
+(2, 3),
+(3, 1),
+(4, 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');