summaryrefslogtreecommitdiffstats
path: root/setup/poolctrl_data.sql
diff options
context:
space:
mode:
authorBjörn Geiger2011-08-22 12:31:48 +0200
committerBjörn Geiger2011-08-22 12:31:48 +0200
commitbdbf7625d172fa64e7694f3bf37eed642517bbe1 (patch)
tree9e7b2593693dde4d0c224169b6c189bafc7feb72 /setup/poolctrl_data.sql
parentminor (diff)
downloadpoolctrl-bdbf7625d172fa64e7694f3bf37eed642517bbe1.tar.gz
poolctrl-bdbf7625d172fa64e7694f3bf37eed642517bbe1.tar.xz
poolctrl-bdbf7625d172fa64e7694f3bf37eed642517bbe1.zip
Datenbankänderung
Diffstat (limited to 'setup/poolctrl_data.sql')
-rw-r--r--setup/poolctrl_data.sql17
1 files changed, 6 insertions, 11 deletions
diff --git a/setup/poolctrl_data.sql b/setup/poolctrl_data.sql
index f22da32..57df655 100644
--- a/setup/poolctrl_data.sql
+++ b/setup/poolctrl_data.sql
@@ -90,8 +90,8 @@ INSERT INTO `poolctrl_eventcategory` (`eventcategoryID`, `title`) VALUES
(3, 'Boot'),
(4, 'Shutdown');
--- Adding runningtypes
-INSERT INTO `poolctrl_runningtype` (`runningtypeID`, `title`) VALUES
+-- Adding eventtypes
+INSERT INTO `poolctrl_eventtype` (`eventtypeID`, `title`) VALUES
(1, 'Boot'),
(2, 'Shutdown');
@@ -101,13 +101,8 @@ INSERT INTO `poolctrl_event` (`eventID`, `title`, `start`, `end`, `category`, `p
(2, 'Systeme II', '2011-06-24 14:10:00', '2011-06-24 16:00:00', '1', 1, 1, 1, 'Systeme II Vorlesung', 1, 1),
(3, 'Systeme III', '2011-06-24 16:10:00', '2011-06-24 18:00:00', '1', 1, 1, 1, 'Systeme III Vorlesung', 1, 1);
--- Adding reporttypes
-INSERT INTO `poolctrl_reporttype` (`reporttypeID`, `title`) VALUES
-(1, 'Boot'),
-(2, 'Shutdown');
-
-- Adding eventreports
-INSERT INTO `poolctrl_eventreport` (`reportID`, `report`, `type`, `eventID`) VALUES
-(1, DEFAULT, 1, 1),
-(2, DEFAULT, 1, 2),
-(3, 'wake-on-lan failed', 1, 3);
+INSERT INTO `poolctrl_eventreport` (`reportID`, `result`, `errors`, `type`, `eventID`) VALUES
+(1, DEFAULT, null, 1, 1),
+(2, DEFAULT, null, 1, 2),
+(3, 'failed', 'wake-on-lan failed', 1, 3);