From e5fcbd73596db87bb5cd24e1ba91cf735549b3c3 Mon Sep 17 00:00:00 2001
From: Björn Geiger
Date: Tue, 12 Apr 2011 14:54:50 +0200
Subject: verschiedene Korrekturen

---
 pbs-newdata.sql | 15 +++++++--------
 1 file changed, 7 insertions(+), 8 deletions(-)

(limited to 'pbs-newdata.sql')

diff --git a/pbs-newdata.sql b/pbs-newdata.sql
index 5715328..14c10dd 100644
--- a/pbs-newdata.sql
+++ b/pbs-newdata.sql
@@ -36,23 +36,22 @@ INSERT INTO `pbs`.`pbs_groupgroups` (`parentID`, `groupID`) VALUES
 
 -- 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
-- 
cgit v1.2.3-55-g7522


From 6b54422853a33d14a80bd9f01da899819ab8c813 Mon Sep 17 00:00:00 2001
From: Simon
Date: Tue, 12 Apr 2011 14:58:53 +0200
Subject: default-roles entfernt

---
 pbs-newdata.sql | 2 --
 1 file changed, 2 deletions(-)

(limited to 'pbs-newdata.sql')

diff --git a/pbs-newdata.sql b/pbs-newdata.sql
index 5715328..2a11a1e 100644
--- a/pbs-newdata.sql
+++ b/pbs-newdata.sql
@@ -36,8 +36,6 @@ INSERT INTO `pbs`.`pbs_groupgroups` (`parentID`, `groupID`) VALUES
 
 -- 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);
 
 
-- 
cgit v1.2.3-55-g7522


From 123a0fbb84c72bd30e83b6a2ac66dfaea61b72bd Mon Sep 17 00:00:00 2001
From: Björn Geiger
Date: Tue, 12 Apr 2011 15:06:44 +0200
Subject: fehler in sql korrigiert

---
 pbs-newdata.sql | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'pbs-newdata.sql')

diff --git a/pbs-newdata.sql b/pbs-newdata.sql
index 02babae..7adefab 100644
--- a/pbs-newdata.sql
+++ b/pbs-newdata.sql
@@ -35,8 +35,9 @@ INSERT INTO `pbs`.`pbs_groupgroups` (`parentID`, `groupID`) VALUES
 (3, 10);
 
 -- Adding role
-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
 (4, 4),
-- 
cgit v1.2.3-55-g7522

