From 3c8f2a7c26ca065ef33e85661d3e9e299b9aeb3f Mon Sep 17 00:00:00 2001
From: Björn Geiger
Date: Wed, 29 Jun 2011 17:04:33 +0200
Subject: Eventcategory nun in eigener Tabelle

---
 setup/poolctrl_data.sql | 13 ++++++++++---
 1 file changed, 10 insertions(+), 3 deletions(-)

(limited to 'setup/poolctrl_data.sql')

diff --git a/setup/poolctrl_data.sql b/setup/poolctrl_data.sql
index 9967aee..dd08c97 100644
--- a/setup/poolctrl_data.sql
+++ b/setup/poolctrl_data.sql
@@ -99,11 +99,18 @@ INSERT INTO `pbs_poolentries` (`poolentriesID`, `poolID`, `clientID`) VALUES
 (9, 4, 9),
 (10, 4, 10);
 
+-- Adding eventcategories
+INSERT INTO `poolctrl_eventcategory` (`eventcategoryID`, `title`) VALUES
+(1, 'Lecture'),
+(2, 'Private'),
+(3, 'Public'),
+(4, 'Maintenance');
+
 -- Adding events
 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');
+(1, 'Systeme I', '2011-06-24 12:10:00', '2011-06-24 14:00:00', '1', 1, 1, 1, 'Systeme I Vorlesung'),
+(2, 'Systeme II', '2011-06-24 14:10:00', '2011-06-24 16:00:00', '1', 1, 1, 1, 'Systeme II Vorlesung'),
+(3, 'Systeme III', '2011-06-24 16:10:00', '2011-06-24 18:00:00', '1', 1, 1, 1, 'Systeme III Vorlesung');
 
 -- Adding eventreport
 INSERT INTO `poolctrl_eventreport` (`reportID`, `report`, `eventID`) VALUES
-- 
cgit v1.2.3-55-g7522

