diff options
Diffstat (limited to 'sonar-core/src')
| -rw-r--r-- | sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mssql.xml | 15 |
1 files changed, 15 insertions, 0 deletions
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> + |