From 2ff3dcea5161c74d31ee8fc61cce8cdfab6609a0 Mon Sep 17 00:00:00 2001
From: Simon Brandhof <simon.brandhof@gmail.com>
Date: Tue, 14 Feb 2012 12:03:39 +0100
Subject: [PATCH] Fix PurgeDao for MySQL -  new attempt

---
 .../org/sonar/core/purge/PurgeVendorMapper-mysql.xml          | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mysql.xml b/sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mysql.xml
index d3449ac8622..69578003f58 100644
--- a/sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mysql.xml
+++ b/sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mysql.xml
@@ -4,11 +4,11 @@
 <mapper namespace="org.sonar.core.purge.PurgeVendorMapper">
 
   <delete id="deleteResourceReviewComments" parameterType="long">
-    delete rc from review_comments rc, reviews r where rc.review_id=r.id and r.resource_id=#{id}
+    delete rc from review_comments as rc, reviews as r where rc.review_id=r.id and r.resource_id=#{id}
   </delete>
 
   <delete id="deleteResourceActionPlansReviews" parameterType="long">
-    delete apr from action_plans_reviews apr, action_plans ap where ap.id=apr.action_plan_id and ap.project_id=#{id}
+    delete apr from action_plans_reviews as apr, action_plans as ap where ap.id=apr.action_plan_id and ap.project_id=#{id}
   </delete>
 
 </mapper>
-- 
2.39.5