From 5ccfc04815ee1ece626fec93a67c51eccd0a1f03 Mon Sep 17 00:00:00 2001
From: Björn Geiger
Date: Tue, 9 Aug 2011 17:37:03 +0200
Subject: verschiedene Änderungen

---
 setup/poolctrl.sql | 31 -------------------------------
 1 file changed, 31 deletions(-)

(limited to 'setup/poolctrl.sql')

diff --git a/setup/poolctrl.sql b/setup/poolctrl.sql
index 8dc176f..975d4c7 100644
--- a/setup/poolctrl.sql
+++ b/setup/poolctrl.sql
@@ -46,35 +46,6 @@ CREATE TABLE IF NOT EXISTS `poolctrl_eventcategory` (
 
 -- PBS2 Tabellen
 -- TO DO: Tabellen an dieser Stelle nicht per Hand erzeugen sondern von der PBS2-Datenbank kopieren, sodass diese auf dem neusten Stand sind
-
-CREATE TABLE IF NOT EXISTS `pbs_filter` (
-  `filterID` int(11) NOT NULL AUTO_INCREMENT,
-  `membershipID` int(11),
-  `groupID` int(11),
-  `bootmenuID` int(11) NOT NULL,
-  `title` varchar(30) NOT NULL,
-  `description` varchar(140),  
-  `created` varchar(14) NOT NULL,
-  `priority` int(11) NOT NULL,
-  PRIMARY KEY (`filterID`),
-  KEY `bootmenuID` (`bootmenuID`),
-  KEY `groupID` (`groupID`),
-  KEY `membershipID` (`membershipID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-
-CREATE TABLE IF NOT EXISTS `pbs_bootmenu` (
-  `bootmenuID` int(11) NOT NULL AUTO_INCREMENT,
-  `membershipID` int(11),
-  `groupID` int(11),
-  `title` varchar(50) NOT NULL,
-  `created` varchar(14) NOT NULL,
-  `defaultbootmenu` tinyint(1) NOT NULL DEFAULT '0',
-  `startcounter` INT( 11 ) NOT NULL DEFAULT '300',
-  PRIMARY KEY (`bootmenuID`),
-  KEY `groupID` (`groupID`),
-  KEY `membershipID` (`membershipID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-
 CREATE TABLE IF NOT EXISTS `pbs_bootos` (
   `bootosID` int(11) NOT NULL AUTO_INCREMENT,
   `groupID` int(11) NOT NULL,
@@ -219,8 +190,6 @@ ALTER TABLE `poolctrl_event`
   ADD CONSTRAINT `poolctrl_event_poolidC` FOREIGN KEY (`pbs_poolID`) REFERENCES `pbs_pool` (`poolID`) ON DELETE CASCADE,
   ADD CONSTRAINT `poolctrl_event_bootosidC` FOREIGN KEY (`pbs_bootosID`) REFERENCES `pbs_bootos` (`bootosID`) ON DELETE CASCADE,
   ADD CONSTRAINT `poolctrl_event_membershipidC` FOREIGN KEY (`pbs_membershipID`) REFERENCES `pbs_membership` (`membershipID`)  ON DELETE CASCADE,
---  ADD CONSTRAINT `poolctrl_event_bootmenuidC` FOREIGN KEY (`pbs_bootmenuID`) REFERENCES `pbs_bootmenu` (`bootmenuID`) ON DELETE CASCADE,
---  ADD CONSTRAINT `poolctrl_event_filteridC` FOREIGN KEY (`pbs_filterID`) REFERENCES `pbs_filter` (`filterID`) ON DELETE CASCADE,
   ADD CONSTRAINT `poolctrl_event_categoryC` FOREIGN KEY (`category`) REFERENCES `poolctrl_eventcategory` (`eventcategoryID`) ON DELETE CASCADE,
   ADD CONSTRAINT `poolctrl_event_startC` CHECK (start > CURRENT_TIMESTAMP()),
   ADD CONSTRAINT `poolctrl_event_endC` CHECK (end > start);
-- 
cgit v1.2.3-55-g7522

