diff options
author | Simon | 2011-03-19 10:32:19 +0100 |
---|---|---|
committer | Simon | 2011-03-19 10:32:19 +0100 |
commit | 4dedc8c5b49466b82cf453536b3f224d57a0c710 (patch) | |
tree | 846db54e9c1661fbbc42df3f73eab79d6e690f2e /pbs-newdata.sql | |
parent | FilterEvaluate an Session angepasst (diff) | |
download | pbs2-4dedc8c5b49466b82cf453536b3f224d57a0c710.tar.gz pbs2-4dedc8c5b49466b82cf453536b3f224d57a0c710.tar.xz pbs2-4dedc8c5b49466b82cf453536b3f224d57a0c710.zip |
Bei Auth Controller zum testen MembershipID wählbar
Pool zeigt nurnoch freie Clients der eigenen Gruppe an
Diffstat (limited to 'pbs-newdata.sql')
-rw-r--r-- | pbs-newdata.sql | 21 |
1 files changed, 17 insertions, 4 deletions
diff --git a/pbs-newdata.sql b/pbs-newdata.sql index c94e759..9e1674b 100644 --- a/pbs-newdata.sql +++ b/pbs-newdata.sql @@ -7,17 +7,27 @@ INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `h -- Adding person test2//test INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `housenumber`, `city`, `postalcode`, `logindate`, `registerdate`, `email`, `login`, `password`, `password_salt`) VALUES (2, 'Herr', 'Test 2', 'Test 2', 'Teststr,', '5', 'Testburg', '1337', NULL, '1299612370', 'test2', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a'); +-- Adding person test3//test +INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `housenumber`, `city`, `postalcode`, `logindate`, `registerdate`, `email`, `login`, `password`, `password_salt`) VALUES +(3, 'Herr', 'Test 3', 'Test 3', 'Teststr,', '5', 'Testburg', '1337', NULL, '1299612370', 'test3', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a'); -- Adding group -INSERT INTO `pbs`.`pbs_group` (`groupID` ,`title` ,`description`)VALUES (1 , 'Group 1', NULL); +INSERT INTO `pbs`.`pbs_group` (`groupID` ,`title` ,`description`)VALUES +(1, 'Group 1', 'Our Testgroup'), +(2, 'Group 2', 'The Second Testgroup'), +(3, 'Group 3', 'Wohoo'); -- Adding role -INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`) VALUES (1, '1', 'Role 1', NULL); -INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`) VALUES (2, '1', 'Role 2', NULL); +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 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'); -- Adding clients INSERT INTO `pbs_client` (`clientID`, `groupID`,`macadress`, `hardwarehash`) VALUES @@ -30,7 +40,10 @@ INSERT INTO `pbs_client` (`clientID`, `groupID`,`macadress`, `hardwarehash`) VAL (7, 1, '00:55:00:55:00:55', 'e8d7e80d79f224771b7a3a0af4e02748'), (8, 1, '66:00:66:00:66:00', 'ded66ce272f384e9e386c1b57ded3e4d'), (9, 1, '00:ff:ff:ff:ff:ff', '695610ee509c060b1fca9c8011529af4'), -(10, 1, '00:22:00:22:00:22', 'a3562c8cad2a4fa4fc11656025dc911b'); +(10, 1, '00:22:00:22:00:22', 'a3562c8cad2a4fa4fc11656025dc911b'), +(11, 2, 'af:54:07:87:63:44', '98413218152196816519841365419816'), +(12, 2, '87:21:74:52:96:20', '98741298132516132169813516981616'), +(13, 2, '14:47:58:47:36:48', '32168132068132068513216053516513'); -- Adding config INSERT INTO `pbs_config` (`configID`, `title`, `groupID`, `membershipID`, `shellscript`, `created`) VALUES |