From 03b4da383449c290ea01723095d1a87fa257fea5 Mon Sep 17 00:00:00 2001
From: michael pereira
Date: Tue, 29 Mar 2011 10:59:15 +0200
Subject: Preboot User Controller fertig, ACL fehlt noch

---
 pbs.sql | 8 ++------
 1 file changed, 2 insertions(+), 6 deletions(-)

(limited to 'pbs.sql')

diff --git a/pbs.sql b/pbs.sql
index 9d5d57d..c88ad27 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -129,7 +129,7 @@ CREATE TABLE IF NOT EXISTS `pbs_bootos` (
   `description` varchar(140),
   `path_init` varchar(140) NOT NULL,
   `path_kernel` varchar(140) NOT NULL,
-  `defaultkcl` varchar(255) NOT NULL,
+  `defaultkcl` varchar(255),
   `created` VARCHAR(14) NOT NULL,
   `expires` VARCHAR(14),
   `public` int(11) NOT NULL,
@@ -137,7 +137,6 @@ CREATE TABLE IF NOT EXISTS `pbs_bootos` (
   KEY `configID` (`configID`),
   KEY `groupID` (`groupID`),
   KEY `membershipID` (`membershipID`),
-  KEY `defaultkcl` (`defaultkcl`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
 
 ALTER TABLE `pbs_bootos`
@@ -157,7 +156,7 @@ CREATE TABLE IF NOT EXISTS `pbs_bootmenu` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
 
 ALTER TABLE `pbs_bootmenu`
-  ADD CONSTRAINT `pbs_bootmenu_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE CASCADE,
+  ADD CONSTRAINT `pbs_bootmenu_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL,
   ADD CONSTRAINT `pbs_bootmenu_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;
 
 CREATE TABLE IF NOT EXISTS `pbs_bootmenuentries` (
@@ -172,7 +171,6 @@ CREATE TABLE IF NOT EXISTS `pbs_bootmenuentries` (
   PRIMARY KEY (`bootmenuentriesID`),
   KEY `bootosID` (`bootosID`),
   KEY `bootmenuID` (`bootmenuID`),
-  KEY `kcl` (`kcl`),
   KEY `configID` (`configID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
 
@@ -180,8 +178,6 @@ ALTER TABLE `pbs_bootmenuentries`
   ADD CONSTRAINT `pbs_bootmenuentries_ibfk_1` FOREIGN KEY (`bootmenuID`) REFERENCES `pbs_bootmenu` (`bootmenuID`) ON DELETE CASCADE,
   ADD CONSTRAINT `pbs_bootmenuentries_ibfk_2` FOREIGN KEY (`bootosID`) REFERENCES `pbs_bootos` (`bootosID`) ON DELETE CASCADE,
   ADD CONSTRAINT `pbs_bootmenuentries_ibfk_3` FOREIGN KEY (`configID`) REFERENCES `pbs_config` (`configID`) ON DELETE SET NULL,
-  ADD CONSTRAINT `pbs_bootmenuentries_ibfk_4` FOREIGN KEY (`kcl`) REFERENCES `pbs_bootos` (`defaultkcl`) ON DELETE CASCADE,
-  ADD CONSTRAINT `pbs_bootmenuentries_ibfk_5` FOREIGN KEY (`kcl`) REFERENCES `pbs_bootos` (`defaultkcl`) ON UPDATE CASCADE;
 
 CREATE TABLE IF NOT EXISTS `pbs_preboot` (
   `prebootID` int(11) NOT NULL AUTO_INCREMENT,
-- 
cgit v1.2.3-55-g7522

