diff options
Diffstat (limited to 'setup/pbs.sql')
| -rw-r--r-- | setup/pbs.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/setup/pbs.sql b/setup/pbs.sql index 7fea674..d2bdeda 100644 --- a/setup/pbs.sql +++ b/setup/pbs.sql @@ -81,7 +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, + `loginpassword` varchar(512) COLLATE utf8_unicode_ci NOT NULL, `suspend` tinyint(1) NOT NULL, PRIMARY KEY (`personID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; @@ -172,7 +172,7 @@ ALTER TABLE `pbs_config` `bootosuserID` int(11) NOT NULL AUTO_INCREMENT, `configID` int(11) NOT NULL, `login` varchar(30) NOT NULL, - `password` varchar(30) NOT NULL, + `password` varchar(512) NOT NULL, `homepath` varchar(140), `hometypeID` int(11), PRIMARY KEY (`bootosuserID`), @@ -656,7 +656,7 @@ INSERT INTO `pbs_rightroles` (`roleID`, `rightID`) VALUES -- Adding a Person for SuperAdmin 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$FU8dTKfc$iIkvk3Qj9RxFnQkNDO0GypS//h0vjdi9n.iz/9GmbwMo35/YEA2Y81FIKEcZYQPS8x3MESADNpTn0BxV6csZV.'); +(1, 'Herr', 'Super', 'Admin', 'Street', '1337', 'Teshouse', '1337', NULL, '1299612370', 'test', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a', '$6$Do9tGnw0$9ndoxsmcpNV.9mFTBRB7u2RbWekbSfjnUfPKXrCUEpXrZXoqnOesXITGl.RDy0cuaYB1Ouob6WtNWQqU/M/4U.'); -- Get him a Membership in MainGroup for activate Requests INSERT INTO `pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (NULL, '1', '1', '1', 'apikey1'); |