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

