Changeset 12962 for stable/HeuristicLab.Services.Hive.DataAccess/3.3/Daos
- Timestamp:
- 09/21/15 16:28:38 (9 years ago)
- Location:
- stable
- Files:
-
- 3 edited
- 1 copied
Legend:
- Unmodified
- Added
- Removed
-
stable
- Property svn:mergeinfo changed
-
stable/HeuristicLab.Services.Hive.DataAccess
- Property svn:mergeinfo changed
-
stable/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/PluginDao.cs
r12761 r12962 57 57 #region String queries 58 58 private const string DeleteUnusedPluginsStringQuery = @" 59 DELETE FROM [Plugin] 60 WHERE [Plugin].[PluginId] NOT IN ( 61 SELECT DISTINCT rp.[PluginId] 62 FROM [RequiredPlugins] rp 63 WHERE EXISTS (SELECT [TaskId] 64 FROM [Task] t 65 WHERE t.[TaskId] = rp.[TaskId]) 66 ); 67 "; 59 DELETE FROM [Plugin] WHERE PluginId IN ( 60 SELECT p.[PluginId] FROM [Plugin] p 61 LEFT JOIN [RequiredPlugins] rp 62 ON rp.PluginId = p.PluginId 63 WHERE rp.PluginId IS NULL)"; 68 64 #endregion 69 65 }
Note: See TracChangeset
for help on using the changeset viewer.