summaryrefslogtreecommitdiffstats
path: root/setup/poolctrl_data.sql
diff options
context:
space:
mode:
authorBjörn Geiger2011-08-24 15:46:50 +0200
committerBjörn Geiger2011-08-24 15:46:50 +0200
commit9172d638e5b271981ead452c5db89154fe5df22f (patch)
tree0b9a05f69b9b71d4f608b8ca9ac45fd33466a2a9 /setup/poolctrl_data.sql
parentweitere Fehler (diff)
downloadpoolctrl-9172d638e5b271981ead452c5db89154fe5df22f.tar.gz
poolctrl-9172d638e5b271981ead452c5db89154fe5df22f.tar.xz
poolctrl-9172d638e5b271981ead452c5db89154fe5df22f.zip
Datenbankänderung
Diffstat (limited to 'setup/poolctrl_data.sql')
-rw-r--r--setup/poolctrl_data.sql27
1 files changed, 0 insertions, 27 deletions
diff --git a/setup/poolctrl_data.sql b/setup/poolctrl_data.sql
index 57df655..6adbc6f 100644
--- a/setup/poolctrl_data.sql
+++ b/setup/poolctrl_data.sql
@@ -1,33 +1,6 @@
USE ##poolctrl##;
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--- Adding person
-INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `housenumber`, `city`, `postalcode`, `logindate`, `registerdate`, `email`, `login`, `password`, `password_salt`, `loginpassword`) VALUES
-(1, 'Herr', 'Super', 'Admin', 'Street', '1337', 'Teshouse', '1337', NULL, '1299612370', 'test', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a', '$6$Do9tGnw0$9ndoxsmcpNV.9mFTBRB7u2RbWekbSfjnUfPKXrCUEpXrZXoqnOesXITGl.RDy0cuaYB1Ouob6WtNWQqU/M/4U.'),
-(2, 'Herr', 'Test 2', 'Test 2', 'Teststr,', '5', 'Testburg', '1337', NULL, '1299612370', 'test2', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a', '$6$Do9tGnw0$9ndoxsmcpNV.9mFTBRB7u2RbWekbSfjnUfPKXrCUEpXrZXoqnOesXITGl.RDy0cuaYB1Ouob6WtNWQqU/M/4U.'),
-(3, 'Herr', 'Test 3', 'Test 3', 'Teststr,', '5', 'Testburg', '1337', NULL, '1299612370', 'test3', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a', '$6$Do9tGnw0$9ndoxsmcpNV.9mFTBRB7u2RbWekbSfjnUfPKXrCUEpXrZXoqnOesXITGl.RDy0cuaYB1Ouob6WtNWQqU/M/4U.');
-
--- Adding group
-INSERT INTO `pbs_group` (`groupID` ,`title` ,`description`)VALUES
-(1, 'OpenSLX', 'This is the OpenSLX-Group'),
-(2, 'Germany', 'Deutschland'),
-(3, 'France', 'France'),
-(4, 'DFN', 'Deutsches Forschungsnetz'),
-(5, 'Institutionen', 'Fifth Group'),
-(6, 'Baden-Würtemberg', 'Sixth Group'),
-(7, 'Bayern', 'Seventh Group'),
-(8, 'Uni-Freiburg', 'Eight Group');
-
--- Adding memberships
-INSERT INTO `pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (NULL, '1', '1', '1', 'apikey1');
-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', 'apikey5');
-INSERT INTO `pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (NULL, '6', '1', '1', 'apikey6');
-INSERT INTO `pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (NULL, '7', '1', '1', 'apikey7');
-INSERT INTO `pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (NULL, '8', '1', '1', 'apikey8');
-
-- Adding clients
INSERT INTO `pbs_client` (`clientID`, `groupID`,`macadress`, `hardwarehash`, `ip`, `ip6`) VALUES
(1, 1, 'a5:9a:0f:94:2a:b0', 'ea9b82d9de911bc2d3cd23f53a6cab48', '132.230.5.6', ''),