From 5da4cf29171b2b3e5dafa8f969b57d02c0ed6743 Mon Sep 17 00:00:00 2001
From: Michael Wilson
Date: Fri, 28 Nov 2014 15:46:50 +0100
Subject: lecture permissions deleted after deleting lecture

---
 dozentenmodulserver/src/main/java/sql/SQL.java | 11 +++++++++--
 1 file changed, 9 insertions(+), 2 deletions(-)

diff --git a/dozentenmodulserver/src/main/java/sql/SQL.java b/dozentenmodulserver/src/main/java/sql/SQL.java
index d496489d..5ba19c70 100644
--- a/dozentenmodulserver/src/main/java/sql/SQL.java
+++ b/dozentenmodulserver/src/main/java/sql/SQL.java
@@ -1390,11 +1390,18 @@ public class SQL {
 			//delete the lecture record
 			String sql = "DELETE FROM bwLehrpool.m_VLData_lecture WHERE lectureID = ?;";
 			PreparedStatement prest = con.prepareStatement(sql);
-			prest.setString(1, id);
+			prest.setString(1, id); 
 			
 			prest.executeUpdate();
 
-			//delete all permission records for this lecture		
+			
+			//delete all permission records for this lecture
+			sql = "DELETE FROM bwLehrpool.pm_VLData_lecture WHERE lectureID = ?;";
+			prest = con.prepareStatement(sql);
+			prest.setString(1, id); 
+			
+			prest.executeUpdate();
+			
 			con.commit();
 			con.close();
 			return true;
-- 
cgit v1.2.3-55-g7522