USE ##poolctrl##; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- Adding eventcategories INSERT INTO `poolctrl_eventcategory` (`eventcategoryID`, `title`, `color`) VALUES (1, 'Lecture', 'green'), (2, 'Maintenance', 'yellow'), (3, 'Boot', 'blue'), (4, 'Shutdown', 'red'); -- Adding runningtypes INSERT INTO `poolctrl_runningtype` (`runningtypeID`, `title`) VALUES (1, 'Boot'), (2, 'Shutdown'); -- Adding repeattypes INSERT INTO `poolctrl_repeattype` (`repeattypeID`, `title`) VALUES (1, 'Daily'), (2, 'Once a week'), (3, 'Every couple of weeks'), (4, 'Every month'); -- Adding repeatend INSERT INTO `poolctrl_repeatend` (`repeatendID`, `title`) VALUES (1, 'After'), (2, 'Date'); -- Adding events INSERT INTO `poolctrl_event` (`eventID`, `title`, `start`, `end`, `category`, `pbs_poolID`, `pbs_membershipID`, `pbs_bootosID`, `pbs_configID`, `note`, `pbs_bootmenuID`, `pbs_filterID`, `created`) VALUES (1, 'Systeme I', '2011-06-24 12:10:00', '2011-06-24 14:00:00', '1', 1, 1, 1, 1, 'Systeme I Vorlesung', 1, 1, 1308583320), (2, 'Systeme II', '2011-06-24 14:10:00', '2011-06-24 16:00:00', '1', 1, 1, 1, 1, 'Systeme II Vorlesung', 1, 1, 1308583320), (3, 'Systeme III', '2011-06-24 16:10:00', '2011-06-24 18:00:00', '1', 1, 1, 1, 1, 'Systeme III Vorlesung', 1, 1, 1308583320); -- Adding eventreports INSERT INTO `poolctrl_eventreport` (`reportID`, `result`, `errors`, `type`, `eventID`, `created`) VALUES (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);