From afc41a26404d9dfffeae3f9ac16f0c7be7e945ba Mon Sep 17 00:00:00 2001 From: Björn Geiger Date: Wed, 7 Sep 2011 14:02:46 +0200 Subject: kleine korrektur in DB --- setup/poolctrl.sql | 6 +----- 1 file changed, 1 insertion(+), 5 deletions(-) (limited to 'setup') 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, -- cgit v1.2.3-55-g7522