diff options
| author | Björn Geiger | 2011-03-24 11:30:25 +0100 |
|---|---|---|
| committer | Björn Geiger | 2011-03-24 11:30:25 +0100 |
| commit | 512a4a5927ef02909b4160476aadf6e43c7a2df7 (patch) | |
| tree | 8ec3b22d5490988f9829d83077d3794e4c95ce38 | |
| parent | Merge branch 'master' of ssh://git.openslx.org/lsfks/master-teamprojekt/pbs2 (diff) | |
| download | pbs2-512a4a5927ef02909b4160476aadf6e43c7a2df7.tar.gz pbs2-512a4a5927ef02909b4160476aadf6e43c7a2df7.tar.xz pbs2-512a4a5927ef02909b4160476aadf6e43c7a2df7.zip | |
Testdaten Rechtetabelle
| -rw-r--r-- | pbs-newdata.sql | 16 |
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'); |