summaryrefslogtreecommitdiffstats
path: root/setup/poolctrl.sql
diff options
context:
space:
mode:
Diffstat (limited to 'setup/poolctrl.sql')
-rw-r--r--setup/poolctrl.sql6
1 files changed, 1 insertions, 5 deletions
diff --git a/setup/poolctrl.sql b/setup/poolctrl.sql
index 4cd4c2a..5762a29 100644
--- a/setup/poolctrl.sql
+++ b/setup/poolctrl.sql
@@ -124,12 +124,8 @@ CREATE TABLE IF NOT EXISTS `pbs_poolentries` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
-- Constraints
-ALTER TABLE `pbs_bootos`
- ADD CONSTRAINT `pbs_bootos_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL;
-
ALTER TABLE `pbs_config`
- ADD CONSTRAINT `pbs_config_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL,
- ADD CONSTRAINT `pbs_config_ibfk_2` FOREIGN KEY (`bootosID`) REFERENCES `pbs_bootos` (`bootosID`) ON DELETE CASCADE;
+ ADD CONSTRAINT `pbs_config_ibfk` FOREIGN KEY (`bootosID`) REFERENCES `pbs_bootos` (`bootosID`) ON DELETE CASCADE;
ALTER TABLE `pbs_poolentries`
ADD CONSTRAINT `pbs_poolentries_ibfk_1` FOREIGN KEY (`poolID`) REFERENCES `pbs_pool` (`poolID`) ON DELETE CASCADE,