diff options
author | michael pereira | 2011-04-26 13:24:13 +0200 |
---|---|---|
committer | michael pereira | 2011-04-26 13:24:13 +0200 |
commit | fee7b6edf0d7aaa9d156d823dc66abdd3848397c (patch) | |
tree | e7da905cb93887d648fbd9e2850a153b145bc4ae /setup/pbs-newdata.sql | |
parent | crypt back (diff) | |
download | pbs2-fee7b6edf0d7aaa9d156d823dc66abdd3848397c.tar.gz pbs2-fee7b6edf0d7aaa9d156d823dc66abdd3848397c.tar.xz pbs2-fee7b6edf0d7aaa9d156d823dc66abdd3848397c.zip |
db
Diffstat (limited to 'setup/pbs-newdata.sql')
-rw-r--r-- | setup/pbs-newdata.sql | 8 |
1 files changed, 3 insertions, 5 deletions
diff --git a/setup/pbs-newdata.sql b/setup/pbs-newdata.sql index 59b9e9e..e209875 100644 --- a/setup/pbs-newdata.sql +++ b/setup/pbs-newdata.sql @@ -3,10 +3,10 @@ SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- Adding person test2//test INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `housenumber`, `city`, `postalcode`, `logindate`, `registerdate`, `email`, `login`, `password`, `password_salt`, `loginpassword`) VALUES -(2, 'Herr', 'Test 2', 'Test 2', 'Teststr,', '5', 'Testburg', '1337', NULL, '1299612370', 'test2', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a', '$6$v66WvVJA$4wmqSpCv0bMSf8aWtS'); +(2, 'Herr', 'Test 2', 'Test 2', 'Teststr,', '5', 'Testburg', '1337', NULL, '1299612370', 'test2', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a', '$6$Do9tGnw0$9ndoxsmcpNV.9mFTBRB7u2RbWekbSfjnUfPKXrCUEpXrZXoqnOesXITGl.RDy0cuaYB1Ouob6WtNWQqU/M/4U.'); -- Adding person test3//test INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `housenumber`, `city`, `postalcode`, `logindate`, `registerdate`, `email`, `login`, `password`, `password_salt`, `loginpassword`) VALUES -(3, 'Herr', 'Test 3', 'Test 3', 'Teststr,', '5', 'Testburg', '1337', NULL, '1299612370', 'test3', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a', '$6$v66WvVJA$4wmqSpCv0bMSf8aWtS'); +(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 @@ -58,9 +58,7 @@ INSERT INTO `pbs_client` (`clientID`, `groupID`,`macadress`, `hardwarehash`) VAL INSERT INTO `pbs_hometype` (`hometypeID`, `name`) VALUES (0, 'standard'), (1, 'usbstick'), -(2, 'custom path'), -(3, 'extern'), -(4, 'dropbox'); +(2, 'custom path'); |