summaryrefslogtreecommitdiffstats
path: root/setup
diff options
context:
space:
mode:
authorBjörn Geiger2011-09-22 18:05:10 +0200
committerBjörn Geiger2011-09-22 18:05:10 +0200
commit88b8407c57148af770a08cc813c8b3f8e6a454c8 (patch)
treed46b4e67063ce12cb66a1d8d0d159d648b9df825 /setup
parentRepeat Optionen werden nun in der DB gespeichert, achtung DB Update (diff)
downloadpoolctrl-88b8407c57148af770a08cc813c8b3f8e6a454c8.tar.gz
poolctrl-88b8407c57148af770a08cc813c8b3f8e6a454c8.tar.xz
poolctrl-88b8407c57148af770a08cc813c8b3f8e6a454c8.zip
DB Korrektur
Diffstat (limited to 'setup')
-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');