Ignore:
Timestamp:
01/18/18 15:08:25 (3 years ago)
Author:
jzenisek
Message:

#2839

  • updated Heartbeat processing (regarding: checking against AssignedJobResources and handling of the updated Job deletion routine)
  • updated Job deletion routine(still in progress at GenerateStatistics)
File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql

    r15552 r15630  
    3333ON DELETE CASCADE
    3434GO
    35 
     35-- OBSOLETE (start)
    3636ALTER TABLE [dbo].[AssignedTaskResource]  DROP  CONSTRAINT [Task_AssignedTaskResource]
    3737ALTER TABLE [dbo].[AssignedTaskResource]  WITH CHECK ADD  CONSTRAINT [Task_AssignedTaskResource] FOREIGN KEY([TaskId])
     
    4646ON DELETE CASCADE
    4747GO
    48 
     48-- OBSOLETE (end)
    4949ALTER TABLE [dbo].[AssignedJobResource]  DROP  CONSTRAINT [Job_AssignedJobResource]
    5050ALTER TABLE [dbo].[AssignedJobResource]  WITH CHECK ADD  CONSTRAINT [Job_AssignedJobResource] FOREIGN KEY([JobId])
     
    118118REFERENCES [dbo].[Project] ([ProjectId])
    119119ON UPDATE CASCADE
    120 -- ON DELETE CASCADE
     120-- ON DELETE CASCADE (no "ON DELETE CASCADE" >>> if project is deleted, jobs (actually job-belonging tasks) should be aborted, but not deleted
    121121GO
    122122
     
    158158
    159159
     160
     161-- OBSOLETE (start)
    160162/****** Object:  Trigger [dbo].[tr_JobDeleteCascade]    Script Date: 04/19/2011 16:31:53 ******/
    161163SET ANSI_NULLS ON
     
    210212END
    211213GO
    212 
    213 
     214-- OBSOLETE (end)
     215
Note: See TracChangeset for help on using the changeset viewer.