diff options
author | Björn Geiger | 2011-03-24 11:19:29 +0100 |
---|---|---|
committer | Björn Geiger | 2011-03-24 11:19:29 +0100 |
commit | d0d15777332c373d92a949e43b6f9c44900dd8d2 (patch) | |
tree | a7c3281bd3a6971214d43b76537864928a505f1a /pbs.sql | |
parent | Rollenverwaltung in Dev Modul (diff) | |
download | pbs2-d0d15777332c373d92a949e43b6f9c44900dd8d2.tar.gz pbs2-d0d15777332c373d92a949e43b6f9c44900dd8d2.tar.xz pbs2-d0d15777332c373d92a949e43b6f9c44900dd8d2.zip |
Passwort Recovery, Mailversand funktioniert wahrscheinlich nicht
Diffstat (limited to 'pbs.sql')
-rw-r--r-- | pbs.sql | 10 |
1 files changed, 10 insertions, 0 deletions
@@ -337,6 +337,14 @@ ALTER TABLE `pbs_filterentries` ADD CONSTRAINT `pbs_filterentries_ibfk_1` FOREIGN KEY (`filterID`) REFERENCES `pbs_filter` (`filterID`) ON DELETE CASCADE, ADD CONSTRAINT `pbs_filterentries_ibfk_2` FOREIGN KEY (`filtertypeID`) REFERENCES `pbs_filtertype` (`filtertypeID`) ON DELETE CASCADE; +CREATE TABLE IF NOT EXISTS `pbs_passwordrecovery` ( + `personID` int(11) NOT NULL, + `recoveryID` varchar(100) COLLATE utf8_unicode_ci NOT NULL, + PRIMARY KEY (`personID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; +ALTER TABLE `pbs_passwordrecovery` + ADD CONSTRAINT `pbs_passwordrecovery_ibfk_1` FOREIGN KEY (`personID`) REFERENCES `pbs_person` (`personID`) ON DELETE CASCADE; + -- Insert Filtertypes INSERT INTO `pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (1, 'IP'), @@ -351,3 +359,5 @@ INSERT INTO `pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (10, 'Weekday'), (11, 'Date'); + + |