From d0d15777332c373d92a949e43b6f9c44900dd8d2 Mon Sep 17 00:00:00 2001 From: Björn Geiger Date: Thu, 24 Mar 2011 11:19:29 +0100 Subject: Passwort Recovery, Mailversand funktioniert wahrscheinlich nicht --- pbs.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'pbs.sql') diff --git a/pbs.sql b/pbs.sql index 1658002..1cbc9c3 100644 --- a/pbs.sql +++ b/pbs.sql @@ -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'); + + -- cgit v1.2.3-55-g7522