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