summaryrefslogtreecommitdiffstats
path: root/setup
diff options
context:
space:
mode:
authorBjörn Geiger2011-09-14 14:07:48 +0200
committerBjörn Geiger2011-09-14 14:07:48 +0200
commit1d9d98fcda8fb525a816a057be4ee8ea6db0b81f (patch)
tree3c6fdc1456f4caec80c96b1f568140a4b7678f8a /setup
parentkleine Korrektur (diff)
downloadpoolctrl-1d9d98fcda8fb525a816a057be4ee8ea6db0b81f.tar.gz
poolctrl-1d9d98fcda8fb525a816a057be4ee8ea6db0b81f.tar.xz
poolctrl-1d9d98fcda8fb525a816a057be4ee8ea6db0b81f.zip
verschiedenes
Diffstat (limited to 'setup')
-rwxr-xr-xsetup/poolctrl.sql2
-rwxr-xr-xsetup/poolctrl_data.sql9
2 files changed, 7 insertions, 4 deletions
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);