@Delete({"DELETE FROM deviceGroups " +
        "WHERE deviceId=#{deviceId} " +
        "  AND groupId IN ( " +
        "      SELECT groups.id " +
        "      FROM groups " +
        "      INNER JOIN users ON users.id = #{userId} " +
        "      WHERE groups.customerId = #{customerId} " +
        "      AND (users.allDevicesAvailable AND users.customerId = #{customerId} " +
        "           OR " +
        "           EXISTS (SELECT 1 FROM userDeviceGroupsAccess access WHERE groups.id = access.groupId AND access.userId = users.id)" +
        "      )" +
        "  )"})
void removeDeviceGroupsByDeviceId(
        @Param("userId") int userId,
        @Param("customerId") int customerId,
        @Param("deviceId") Integer deviceId);
 

@Delete({"DELETE FROM configurationApplications " +
        "WHERE applicationVersionId=#{id} " +
        "AND configurationId IN (SELECT configurations.id " +
        "                        FROM configurations " +
        "                        WHERE configurations.customerId=#{customerId})"})
void removeApplicationVersionConfigurationsById(@Param("customerId") int customerId,
                                                @Param("id") Integer applicationVersionId);
 

@Delete("DELETE FROM configurationApplications " +
        "WHERE configurationId = #{configurationId} " +
        "AND applicationId IN ( " +
        "            SELECT id FROM applications " +
        "            WHERE pkg = (" +
        "                SELECT pkg " +
        "                FROM applications " +
        "                WHERE id=#{applicationId} " +
        "            ) AND id != #{applicationId} " +
        ")")
int deleteApplicationConfigurationLinksForSamePkg(@Param("applicationId") int applicationId,
                                                  @Param("configurationId") int configurationId);
 

@Delete("delete from user where id=#{id}")
void deleteById(@Param("id")String id);
 

@Delete("delete from user where id=#{id}")
void deleteById(@Param("id")String id);
 

@Delete("delete from mymusic where my_id=${song_id} and user_id=${user_id}")
public int deleteMyMusic(@Param("song_id") int song_id, @Param("user_id") int user_id);
 

@Delete("delete from rdb_analyze_result where schedule_id IN (select min(schedule_id) from rdb_analyze_result)")
void deleteOld();
 

@Delete("delete from student where sno=#{sno}")
void deleteStudentBySno(String sno);
 

@Delete("delete from sys_menu where id = #{id}")
int delete(Long id);
 

@Delete("delete from sys_menu where parentId = #{id}")
int deleteByParentId(Long id);
 

@Delete("delete from sys_permission where id = #{id}")
int deleteOps(Long id);
 

@Delete("delete from class_table")
void deleteAll();
 

@Delete("DELETE FROM tenants WHERE tenant = #{tenant}")
void delete(String tenant);
 

@Delete("delete from sys_service where parentId = #{id}")
int deleteByParentId(Long id);
 

@Delete("delete from sys_client_permission where clientId = #{clientId}")
int deleteClientPermission(Long clientId);
 

@Delete("delete from oauth_client_details where id = #{id}")
int delete(Long id);
 

@Delete("delete from sys_role_user where roleId = #{clientId}")
int deleteRoleUser(Long clientId);
 

@Delete("delete from student where id = #{id}")
int delete(int id);
 

@Delete("delete from thread_table")
void deleteAll();
 

@Delete("delete from menu where parentId = #{id}")
int deleteByParentId(Long id);
 

@Delete("delete from black_ip where ip = #{ip}")
int delete(String ip);
 

@Delete("delete from file_info where id = #{id}")
int delete(String id);
 

@Delete("delete from sys_permission where id = #{id}")
int delete(Long id);
 

@Delete("delete from sys_role where id = #{id}")
int delete(Long id);
 

@Delete("delete from t_demo where id=#{id}")
void deleteById(Long id);
 

@Delete({"DELETE FROM customers WHERE id=#{id} AND master = FALSE"})
void delete(@Param("id") Integer id);
 

@Delete({"DELETE FROM applications WHERE id=#{id}"})
void removeApplicationById(@Param("id") Integer id);
 

@Delete({"DELETE FROM applicationVersions WHERE id=#{id}"})
void removeApplicationVersionById(@Param("id") Integer id);
 

@Delete("DELETE FROM configurationApplications WHERE id = #{id}")
void deleteApplicationConfigurationLink(@Param("id") Integer linkId);
 

@Delete("delete from gc_table")
void deleteAll();