diff options
| author | michael pereira | 2011-04-12 15:13:01 +0200 |
|---|---|---|
| committer | michael pereira | 2011-04-12 15:13:01 +0200 |
| commit | 1d6cfed3b0ebd97aff7fa5153200f6f7eea5bf7a (patch) | |
| tree | 1a32e5a0dfafa86d7abfa7a550e373f74a391d13 /pbs-newdata.sql | |
| parent | default tgz in kcl (diff) | |
| parent | fehler in sql korrigiert (diff) | |
| download | pbs2-1d6cfed3b0ebd97aff7fa5153200f6f7eea5bf7a.tar.gz pbs2-1d6cfed3b0ebd97aff7fa5153200f6f7eea5bf7a.tar.xz pbs2-1d6cfed3b0ebd97aff7fa5153200f6f7eea5bf7a.zip | |
Merge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2
Diffstat (limited to 'pbs-newdata.sql')
| -rw-r--r-- | pbs-newdata.sql | 17 |
1 files changed, 7 insertions, 10 deletions
diff --git a/pbs-newdata.sql b/pbs-newdata.sql index 5715328..7adefab 100644 --- a/pbs-newdata.sql +++ b/pbs-newdata.sql @@ -35,24 +35,21 @@ INSERT INTO `pbs`.`pbs_groupgroups` (`parentID`, `groupID`) VALUES (3, 10); -- 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 |