summaryrefslogtreecommitdiffstats
path: root/setup/poolctrl.sql
diff options
context:
space:
mode:
authorSebastian Wagner2011-10-07 15:43:33 +0200
committerSebastian Wagner2011-10-07 15:43:33 +0200
commit9b0fdbb013ecd114cfc6861a7c748770d13d0048 (patch)
tree2fd267c23d67c60070918df38bb2e3a4b0e97e2f /setup/poolctrl.sql
parentrename statistic (diff)
downloadpoolctrl-9b0fdbb013ecd114cfc6861a7c748770d13d0048.tar.gz
poolctrl-9b0fdbb013ecd114cfc6861a7c748770d13d0048.tar.xz
poolctrl-9b0fdbb013ecd114cfc6861a7c748770d13d0048.zip
poolctrl db data changed
Diffstat (limited to 'setup/poolctrl.sql')
-rwxr-xr-xsetup/poolctrl.sql26
1 files changed, 0 insertions, 26 deletions
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');