summaryrefslogtreecommitdiffstats
path: root/setup
diff options
context:
space:
mode:
authorBjörn Geiger2011-08-04 16:44:01 +0200
committerBjörn Geiger2011-08-04 16:44:01 +0200
commit51a7855e5872caae801035cccafb062d1a3b9ae0 (patch)
tree79d57ab40dcaeb572f21398dc536af1afc4dcc22 /setup
parentMerge branch 'master' of git.openslx.org:lsfks/projekte/poolctrl (diff)
downloadpoolctrl-51a7855e5872caae801035cccafb062d1a3b9ae0.tar.gz
poolctrl-51a7855e5872caae801035cccafb062d1a3b9ae0.tar.xz
poolctrl-51a7855e5872caae801035cccafb062d1a3b9ae0.zip
Datenbank Fehler korrigiert
Diffstat (limited to 'setup')
-rw-r--r--setup/poolctrl.sql5
1 files changed, 2 insertions, 3 deletions
diff --git a/setup/poolctrl.sql b/setup/poolctrl.sql
index 2f987f3..61b532f 100644
--- a/setup/poolctrl.sql
+++ b/setup/poolctrl.sql
@@ -68,6 +68,7 @@ CREATE TABLE IF NOT EXISTS `pbs_bootmenu` (
`title` varchar(50) NOT NULL,
`created` varchar(14) NOT NULL,
`defaultbootmenu` tinyint(1) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`bootmenuID`),
KEY `membershipID` (`membershipID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
@@ -111,7 +112,7 @@ CREATE TABLE IF NOT EXISTS `pbs_membership` (
`roleID` int(11) NOT NULL,
`suspend` tinyint(1) NOT NULL,
`apikey` varchar(30),
- PRIMARY KEY (`membershipID`),
+ PRIMARY KEY (`membershipID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `pbs_pool` (
@@ -160,8 +161,6 @@ ALTER TABLE `pbs_config`
ALTER TABLE `pbs_bootos`
ADD CONSTRAINT `pbs_bootos_ibfk_3` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL;
-ALTER TABLE `pbs_client`
-
ALTER TABLE `pbs_poolentries`
ADD CONSTRAINT `pbs_poolentries_ibfk_1` FOREIGN KEY (`poolID`) REFERENCES `pbs_pool` (`poolID`) ON DELETE CASCADE;