diff options
author | Simon | 2011-04-21 17:44:19 +0200 |
---|---|---|
committer | Simon | 2011-04-21 17:44:19 +0200 |
commit | 9f5bdc99cfa6607afc00d5d9beadcf794af22abf (patch) | |
tree | aa9cd3d8e31ae5d1583d1ef8a56f2058f4805af8 /setup/pbs-newdata.sql | |
parent | update installer .. (diff) | |
download | pbs2-9f5bdc99cfa6607afc00d5d9beadcf794af22abf.tar.gz pbs2-9f5bdc99cfa6607afc00d5d9beadcf794af22abf.tar.xz pbs2-9f5bdc99cfa6607afc00d5d9beadcf794af22abf.zip |
sql fix für datenbank-insert
Diffstat (limited to 'setup/pbs-newdata.sql')
-rw-r--r-- | setup/pbs-newdata.sql | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/setup/pbs-newdata.sql b/setup/pbs-newdata.sql index 43d2c41..ebe5d15 100644 --- a/setup/pbs-newdata.sql +++ b/setup/pbs-newdata.sql @@ -9,7 +9,7 @@ INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `h (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 +INSERT INTO `pbs_group` (`groupID` ,`title` ,`description`)VALUES (2, 'Germany', 'Deutschland'), (3, 'France', 'France'), (4, 'DFN', 'Deutsches Forschungsnetz'), @@ -18,7 +18,7 @@ INSERT INTO `pbs`.`pbs_group` (`groupID` ,`title` ,`description`)VALUES (7, 'Bayern', 'Seventh Group'), (8, 'Uni-Freiburg', 'Eight Group'); -INSERT INTO `pbs`.`pbs_groupgroups` (`parentID`, `groupID`) VALUES +INSERT INTO `pbs_groupgroups` (`parentID`, `groupID`) VALUES (1, 2), (1, 3), (2, 4), @@ -28,13 +28,13 @@ INSERT INTO `pbs`.`pbs_groupgroups` (`parentID`, `groupID`) VALUES (6, 8); -- Adding memberships -INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (NULL, '2', '1', '1', 'apikey2'); -INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (NULL, '3', '1', '1', 'apikey3'); -INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (NULL, '4', '1', '1', 'apikey4'); -INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (NULL, '5', '1', '1', 'apikey4'); -INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (NULL, '6', '1', '1', 'apikey4'); -INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (NULL, '7', '1', '1', 'apikey4'); -INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (NULL, '8', '1', '1', 'apikey4'); +INSERT INTO `pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (NULL, '2', '1', '1', 'apikey2'); +INSERT INTO `pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (NULL, '3', '1', '1', 'apikey3'); +INSERT INTO `pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (NULL, '4', '1', '1', 'apikey4'); +INSERT INTO `pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (NULL, '5', '1', '1', 'apikey4'); +INSERT INTO `pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (NULL, '6', '1', '1', 'apikey4'); +INSERT INTO `pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (NULL, '7', '1', '1', 'apikey4'); +INSERT INTO `pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (NULL, '8', '1', '1', 'apikey4'); -- Adding clients INSERT INTO `pbs_client` (`clientID`, `groupID`,`macadress`, `hardwarehash`) VALUES |