diff options
Diffstat (limited to 'pbs-newdata.sql')
| -rw-r--r-- | pbs-newdata.sql | 13 |
1 files changed, 9 insertions, 4 deletions
diff --git a/pbs-newdata.sql b/pbs-newdata.sql index 9a447ef..b80f457 100644 --- a/pbs-newdata.sql +++ b/pbs-newdata.sql @@ -42,10 +42,15 @@ INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`) VALUE 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_rightcategory` (`rightcategoryID`, `title`) VALUES +(1, 'rightcategory 1'), +(2, 'rightcategory 2'), +(3, 'rightcategory 3'); + +INSERT INTO `pbs_right` (`rightID`, `rightcategoryID`, `title`, `description`) VALUES (1, 1, 'Recht 1', NULL); +INSERT INTO `pbs_right` (`rightID`, `rightcategoryID`, `title`, `description`) VALUES (2, 1, 'Recht 2', NULL); +INSERT INTO `pbs_right` (`rightID`, `rightcategoryID`, `title`, `description`) VALUES (3, 2, 'Recht 3', NULL); +INSERT INTO `pbs_right` (`rightID`, `rightcategoryID`, `title`, `description`) VALUES (4, 3, 'Recht 4', NULL); INSERT INTO `pbs_rightroles` (`roleID`, `rightID`) VALUES (1, 1), |