From 1d9d98fcda8fb525a816a057be4ee8ea6db0b81f Mon Sep 17 00:00:00 2001 From: Björn Geiger Date: Wed, 14 Sep 2011 14:07:48 +0200 Subject: verschiedenes --- setup/poolctrl.sql | 2 +- setup/poolctrl_data.sql | 9 ++++++--- 2 files changed, 7 insertions(+), 4 deletions(-) (limited to 'setup') diff --git a/setup/poolctrl.sql b/setup/poolctrl.sql index 9e6d2ff..c50d266 100755 --- a/setup/poolctrl.sql +++ b/setup/poolctrl.sql @@ -47,7 +47,7 @@ CREATE TABLE IF NOT EXISTS `poolctrl_eventcategory` ( CREATE TABLE IF NOT EXISTS `poolctrl_eventreport` ( `reportID` int(11) NOT NULL AUTO_INCREMENT, - `result` varchar(140) COLLATE utf8_unicode_ci DEFAULT 'succeeded', + `result` varchar(140) COLLATE utf8_unicode_ci DEFAULT 'successful', `errors` varchar(140) COLLATE utf8_unicode_ci, `type` int(11) NOT NULL, `eventID` int(11) NOT NULL, diff --git a/setup/poolctrl_data.sql b/setup/poolctrl_data.sql index d866bd6..5715ec9 100755 --- a/setup/poolctrl_data.sql +++ b/setup/poolctrl_data.sql @@ -76,6 +76,9 @@ INSERT INTO `poolctrl_event` (`eventID`, `title`, `start`, `end`, `category`, `p -- Adding eventreports INSERT INTO `poolctrl_eventreport` (`reportID`, `result`, `errors`, `type`, `eventID`, `created`) VALUES -(1, DEFAULT, null, 1, 1, 1308917400), -(2, DEFAULT, null, 1, 2, 1308917400), -(3, 'failed', 'wake-on-lan failed', 1, 3, 1308931800); +(1, DEFAULT, null, 1, 1, 1308910200), +(2, DEFAULT, null, 2, 1, 1308916800), +(3, DEFAULT, null, 1, 2, 1308917400), +(4, DEFAULT, null, 2, 2, 1308924000), +(5, 'failed', 'wake-on-lan failed', 1, 3, 1308931800), +(6, DEFAULT, null, 2, 3, 1308931200); -- cgit v1.2.3-55-g7522