From 9b0fdbb013ecd114cfc6861a7c748770d13d0048 Mon Sep 17 00:00:00 2001 From: Sebastian Wagner Date: Fri, 7 Oct 2011 15:43:33 +0200 Subject: poolctrl db data changed --- setup/poolctrl.sql | 26 -------------------------- 1 file changed, 26 deletions(-) (limited to 'setup/poolctrl.sql') diff --git a/setup/poolctrl.sql b/setup/poolctrl.sql index 070c79d..7a3057c 100755 --- a/setup/poolctrl.sql +++ b/setup/poolctrl.sql @@ -89,29 +89,3 @@ ALTER TABLE `poolctrl_event` ADD CONSTRAINT `poolctrl_event_repeatendC` FOREIGN KEY (`repeatend`) REFERENCES `poolctrl_repeatend` (`repeatendID`) ON DELETE SET NULL, ADD CONSTRAINT `poolctrl_event_startC` CHECK (start > CURRENT_TIMESTAMP()), ADD CONSTRAINT `poolctrl_event_endC` CHECK (end > start); - --- Insert Data - --- Adding eventcategories -INSERT INTO `poolctrl_eventcategory` (`eventcategoryID`, `title`, `color`) VALUES -(1, 'Lecture', 'green'), -(2, 'Maintenance', 'yellow'), -(3, 'Boot', 'blue'), -(4, 'Shutdown', 'red'); - --- Adding runningtypes -INSERT INTO `poolctrl_runningtype` (`runningtypeID`, `title`) VALUES -(1, 'Boot'), -(2, 'Shutdown'); - --- Adding repeattypes -INSERT INTO `poolctrl_repeattype` (`repeattypeID`, `title`) VALUES -(1, 'Daily'), -(2, 'Once a week'), -(3, 'Every couple of weeks'), -(4, 'Every month'); - --- Adding repeatend -INSERT INTO `poolctrl_repeatend` (`repeatendID`, `title`) VALUES -(1, 'After'), -(2, 'Date'); -- cgit v1.2.3-55-g7522