summaryrefslogtreecommitdiffstats
path: root/setup/poolctrl_data.sql
diff options
context:
space:
mode:
authorBjörn Geiger2011-08-19 00:45:34 +0200
committerBjörn Geiger2011-08-19 00:45:34 +0200
commit74d2e51da636f8ec981a0b004efb7e1f04b08e08 (patch)
treec62968896bfc4fb4cb6715b17894c58bdfba9418 /setup/poolctrl_data.sql
parentmore ps-logic (diff)
downloadpoolctrl-74d2e51da636f8ec981a0b004efb7e1f04b08e08.tar.gz
poolctrl-74d2e51da636f8ec981a0b004efb7e1f04b08e08.tar.xz
poolctrl-74d2e51da636f8ec981a0b004efb7e1f04b08e08.zip
verschiedene Datenbankänderungen
Diffstat (limited to 'setup/poolctrl_data.sql')
-rw-r--r--setup/poolctrl_data.sql13
1 files changed, 9 insertions, 4 deletions
diff --git a/setup/poolctrl_data.sql b/setup/poolctrl_data.sql
index b699a14..87ed4ab 100644
--- a/setup/poolctrl_data.sql
+++ b/setup/poolctrl_data.sql
@@ -97,7 +97,12 @@ INSERT INTO `poolctrl_event` (`eventID`, `title`, `start`, `end`, `category`, `p
(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 eventreports
-INSERT INTO `poolctrl_eventreport` (`reportID`, `report`, `eventID`) VALUES
-(1, DEFAULT, 1),
-(2, DEFAULT, 2),
-(3, 'wake-on-lan failed', 3);
+INSERT INTO `poolctrl_eventreport` (`reportID`, `report`, `type`, `eventID`) VALUES
+(1, DEFAULT, 1, 1),
+(2, DEFAULT, 1, 2),
+(3, 'wake-on-lan failed', 1, 3);
+
+-- Adding reporttypes
+INSERT INTO `poolctrl_reporttype` (`reporttypeID`, `title`) VALUES
+(1, 'Boot'),
+(2, 'Shutdown');