From 5d6227beed3957f6a265094c4aac5cc7d9558009 Mon Sep 17 00:00:00 2001 From: Björn Geiger Date: Thu, 4 Aug 2011 11:47:31 +0200 Subject: kleine Datenbankänderung --- setup/poolctrl.sql | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'setup') diff --git a/setup/poolctrl.sql b/setup/poolctrl.sql index e395ac6..a2dfeef 100644 --- a/setup/poolctrl.sql +++ b/setup/poolctrl.sql @@ -182,6 +182,12 @@ CREATE TABLE IF NOT EXISTS `pbs_poolentries` ( PRIMARY KEY (`poolentriesID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1; +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; + -- Constraints ALTER TABLE `pbs_filter` ADD CONSTRAINT `pbs_filter_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`), @@ -217,6 +223,9 @@ ALTER TABLE `pbs_pool` ALTER TABLE `pbs_poolentries` ADD CONSTRAINT `pbs_poolentries_ibfk_1` FOREIGN KEY (`poolID`) REFERENCES `pbs_pool` (`poolID`) ON DELETE CASCADE; +ALTER TABLE `pbs_passwordrecovery` + ADD CONSTRAINT `pbs_passwordrecovery_ibfk_1` FOREIGN KEY (`personID`) REFERENCES `pbs_person` (`personID`) ON DELETE CASCADE; + ALTER TABLE `poolctrl_eventreport` ADD CONSTRAINT `pbs_eventreport_eventidC` FOREIGN KEY (`eventID`) REFERENCES `poolctrl_event` (`eventID`) ON DELETE CASCADE; -- cgit v1.2.3-55-g7522