Changeset 15630 for branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql
- Timestamp:
- 01/18/18 15:08:25 (3 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql
r15552 r15630 33 33 ON DELETE CASCADE 34 34 GO 35 35 -- OBSOLETE (start) 36 36 ALTER TABLE [dbo].[AssignedTaskResource] DROP CONSTRAINT [Task_AssignedTaskResource] 37 37 ALTER TABLE [dbo].[AssignedTaskResource] WITH CHECK ADD CONSTRAINT [Task_AssignedTaskResource] FOREIGN KEY([TaskId]) … … 46 46 ON DELETE CASCADE 47 47 GO 48 48 -- OBSOLETE (end) 49 49 ALTER TABLE [dbo].[AssignedJobResource] DROP CONSTRAINT [Job_AssignedJobResource] 50 50 ALTER TABLE [dbo].[AssignedJobResource] WITH CHECK ADD CONSTRAINT [Job_AssignedJobResource] FOREIGN KEY([JobId]) … … 118 118 REFERENCES [dbo].[Project] ([ProjectId]) 119 119 ON 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 121 121 GO 122 122 … … 158 158 159 159 160 161 -- OBSOLETE (start) 160 162 /****** Object: Trigger [dbo].[tr_JobDeleteCascade] Script Date: 04/19/2011 16:31:53 ******/ 161 163 SET ANSI_NULLS ON … … 210 212 END 211 213 GO 212 213 214 -- OBSOLETE (end) 215
Note: See TracChangeset
for help on using the changeset viewer.