From e2d929c54a0d951c9bae51df7df5178bf9f0066f Mon Sep 17 00:00:00 2001 From: michael pereira Date: Mon, 25 Apr 2011 11:40:40 +0200 Subject: config fertig --- setup/pbs-newdata.sql | 8 ++++---- setup/pbs.sql | 1 + 2 files changed, 5 insertions(+), 4 deletions(-) (limited to 'setup') diff --git a/setup/pbs-newdata.sql b/setup/pbs-newdata.sql index ebe5d15..59b9e9e 100644 --- a/setup/pbs-newdata.sql +++ b/setup/pbs-newdata.sql @@ -2,11 +2,11 @@ USE ##pbs##; 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`) VALUES -(2, 'Herr', 'Test 2', 'Test 2', 'Teststr,', '5', 'Testburg', '1337', NULL, '1299612370', 'test2', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a'); +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'); -- 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'); +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'); -- Adding group INSERT INTO `pbs_group` (`groupID` ,`title` ,`description`)VALUES diff --git a/setup/pbs.sql b/setup/pbs.sql index 39ef83c..1cac013 100644 --- a/setup/pbs.sql +++ b/setup/pbs.sql @@ -81,6 +81,7 @@ CREATE TABLE IF NOT EXISTS `pbs_person` ( `login` varchar(30) COLLATE utf8_unicode_ci, `password` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `password_salt` varchar(64) COLLATE utf8_unicode_ci NOT NULL, + `loginpassword` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `suspended` tinyint(1) NOT NULL, PRIMARY KEY (`personID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- cgit v1.2.3-55-g7522