From b88646bb38eb2d13eb7930068351211666be97e5 Mon Sep 17 00:00:00 2001
From: Simon Brandhof <simon.brandhof@gmail.com>
Date: Tue, 14 Feb 2012 12:33:28 +0100
Subject: [PATCH] Fix PurgeDao for SQLServer -  first attempt

---
 .../sonar/core/purge/PurgeVendorMapper-mssql.xml  | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mssql.xml

diff --git a/sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mssql.xml b/sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mssql.xml
new file mode 100644
index 00000000000..7f086c79613
--- /dev/null
+++ b/sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mssql.xml
@@ -0,0 +1,15 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+
+<mapper namespace="org.sonar.core.purge.PurgeVendorMapper">
+
+  <delete id="deleteResourceReviewComments" parameterType="long">
+    delete from review_comments rc inner join reviews r on rc.review_id=r.id where r.resource_id=#{id}
+  </delete>
+
+  <delete id="deleteResourceActionPlansReviews" parameterType="long">
+    delete from action_plans_reviews apr inner join action_plans ap on ap.id=apr.action_plan_id where ap.project_id=#{id}
+  </delete>
+
+</mapper>
+
-- 
2.39.5