summaryrefslogtreecommitdiffstats
path: root/setup
diff options
context:
space:
mode:
authorBjörn Geiger2011-08-04 11:47:31 +0200
committerBjörn Geiger2011-08-04 11:47:31 +0200
commit5d6227beed3957f6a265094c4aac5cc7d9558009 (patch)
tree79c61d74a683b64b57160d214a20464b7c418fea /setup
parentLogin nun über LoginAPI des PBS (diff)
downloadpoolctrl-5d6227beed3957f6a265094c4aac5cc7d9558009.tar.gz
poolctrl-5d6227beed3957f6a265094c4aac5cc7d9558009.tar.xz
poolctrl-5d6227beed3957f6a265094c4aac5cc7d9558009.zip
kleine Datenbankänderung
Diffstat (limited to 'setup')
-rw-r--r--setup/poolctrl.sql9
1 files changed, 9 insertions, 0 deletions
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;