summaryrefslogtreecommitdiffstats
path: root/setup
diff options
context:
space:
mode:
authorBjörn Geiger2011-06-28 12:50:20 +0200
committerBjörn Geiger2011-06-28 12:50:20 +0200
commitcdfa8b82df453114a4024e777051cdcc5ce2685c (patch)
tree8864cc1a093b8a72e85374a0fc305031b160af7e /setup
parentminor (diff)
downloadpoolctrl-cdfa8b82df453114a4024e777051cdcc5ce2685c.tar.gz
poolctrl-cdfa8b82df453114a4024e777051cdcc5ce2685c.tar.xz
poolctrl-cdfa8b82df453114a4024e777051cdcc5ce2685c.zip
Datenbankbeispieleinträge angepasst
Diffstat (limited to 'setup')
-rw-r--r--setup/poolctrl_data.sql16
1 files changed, 8 insertions, 8 deletions
diff --git a/setup/poolctrl_data.sql b/setup/poolctrl_data.sql
index ca3ae93..9967aee 100644
--- a/setup/poolctrl_data.sql
+++ b/setup/poolctrl_data.sql
@@ -100,13 +100,13 @@ INSERT INTO `pbs_poolentries` (`poolentriesID`, `poolID`, `clientID`) VALUES
(10, 4, 10);
-- Adding events
-INSERT INTO `poolctrl_event` (`title`, `start`, `end`, `category`, `pbs_poolID`, `pbs_membershipID`, `pbs_bootosID`, `note`) VALUES
-('Systeme I', '2011-06-24 12:10:00', '2011-06-24 14:00:00', 'Vorlesung', 1, 1, 1, 'Systeme I Vorlesung'),
-('Systeme II', '2011-06-24 14:10:00', '2011-06-24 16:00:00', 'Vorlesung', 1, 1, 1, 'Systeme II Vorlesung'),
-('Systeme III', '2011-06-24 16:10:00', '2011-06-24 18:00:00', 'Vorlesung', 1, 1, 1, 'Systeme III Vorlesung');
+INSERT INTO `poolctrl_event` (`eventID`, `title`, `start`, `end`, `category`, `pbs_poolID`, `pbs_membershipID`, `pbs_bootosID`, `note`) VALUES
+(1, 'Systeme I', '2011-06-24 12:10:00', '2011-06-24 14:00:00', 'Vorlesung', 1, 1, 1, 'Systeme I Vorlesung'),
+(2, 'Systeme II', '2011-06-24 14:10:00', '2011-06-24 16:00:00', 'Vorlesung', 1, 1, 1, 'Systeme II Vorlesung'),
+(3, 'Systeme III', '2011-06-24 16:10:00', '2011-06-24 18:00:00', 'Vorlesung', 1, 1, 1, 'Systeme III Vorlesung');
-- Adding eventreport
-INSERT INTO `poolctrl_eventreport` (`report`, `eventID`) VALUES
-(DEFAULT, 1),
-(DEFAULT, 2),
-('wake-on-lan failed', 3);
+INSERT INTO `poolctrl_eventreport` (`reportID`, `report`, `eventID`) VALUES
+(1, DEFAULT, 1),
+(2, DEFAULT, 2),
+(3, 'wake-on-lan failed', 3);