summaryrefslogblamecommitdiffstats
path: root/setup/poolctrl_data.sql
blob: 495a6ba4aabc5ed481a146a52a912796e4d7ed9f (plain) (tree)
1
2
3
4
5
6
7
8
9
                 

                                     





                                                                                 
 



                                                                    
 





                                                                  
 



                                                                

                



                                                                                                                                                                                                           
 
                      
                                                                                                        





                                                      
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);