From 88b8407c57148af770a08cc813c8b3f8e6a454c8 Mon Sep 17 00:00:00 2001 From: Björn Geiger Date: Thu, 22 Sep 2011 18:05:10 +0200 Subject: DB Korrektur --- setup/poolctrl.sql | 9 ++++----- 1 file changed, 4 insertions(+), 5 deletions(-) (limited to 'setup') diff --git a/setup/poolctrl.sql b/setup/poolctrl.sql index 5d9a75f..5f948f7 100755 --- a/setup/poolctrl.sql +++ b/setup/poolctrl.sql @@ -33,13 +33,13 @@ CREATE TABLE IF NOT EXISTS `poolctrl_event` ( KEY `pbs_bootmenuID` (`pbs_bootmenuID`), KEY `pbs_filterID` (`pbs_filterID`), KEY `category` (`category`), - KEY `runningtype` (`runningtype`) - KEY `repeattype` (`repeattype`) + KEY `runningtype` (`runningtype`), + KEY `repeattype` (`repeattype`), KEY `repeatend` (`repeatend`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1; CREATE TABLE IF NOT EXISTS `poolctrl_runningtype` ( - `eventtypeID` int(11) NOT NULL AUTO_INCREMENT, + `runningtypeID` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(30) COLLATE utf8_unicode_ci NOT NULL UNIQUE, PRIMARY KEY (`runningtypeID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1; @@ -162,7 +162,6 @@ ALTER TABLE `poolctrl_event` ADD CONSTRAINT `poolctrl_event_startC` CHECK (start > CURRENT_TIMESTAMP()), ADD CONSTRAINT `poolctrl_event_endC` CHECK (end > start); ---Adding Data -- Adding eventcategories INSERT INTO `poolctrl_eventcategory` (`eventcategoryID`, `title`) VALUES (1, 'Lecture'), @@ -171,7 +170,7 @@ INSERT INTO `poolctrl_eventcategory` (`eventcategoryID`, `title`) VALUES (4, 'Shutdown'); -- Adding runningtypes -INSERT INTO `poolctrl_runningtype` (`eventtypeID`, `title`) VALUES +INSERT INTO `poolctrl_runningtype` (`runningtypeID`, `title`) VALUES (1, 'Boot'), (2, 'Shutdown'); -- cgit v1.2.3-55-g7522