diff options
Diffstat (limited to 'pbs-newdata.sql')
| -rw-r--r-- | pbs-newdata.sql | 6 |
1 files changed, 1 insertions, 5 deletions
diff --git a/pbs-newdata.sql b/pbs-newdata.sql index 01b1fcc..13061c9 100644 --- a/pbs-newdata.sql +++ b/pbs-newdata.sql @@ -13,7 +13,6 @@ INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `h -- Adding group INSERT INTO `pbs`.`pbs_group` (`groupID` ,`title` ,`description`)VALUES -(1, 'Group 1', 'First Group'), (2, 'Group 2', 'Second Group'), (3, 'Group 3', 'Third Group'), (4, 'Group 4', 'Fourth Group'), @@ -36,16 +35,13 @@ INSERT INTO `pbs`.`pbs_groupgroups` (`parentID`, `groupID`) VALUES (3, 10); -- Adding role -INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES (1, '1', 'Role 1-Group1', NULL, 0); + 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_rightroles` (`roleID`, `rightID`) VALUES -(1, 1), -(1, 2), -(1, 3), (2, 4), (2, 3), (3, 1), |