summaryrefslogtreecommitdiffstats
path: root/setup/poolctrl.sql
diff options
context:
space:
mode:
Diffstat (limited to 'setup/poolctrl.sql')
-rwxr-xr-xsetup/poolctrl.sql9
1 files changed, 4 insertions, 5 deletions
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');