Changeset 15552 for branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql
- Timestamp:
- 12/20/17 11:27:33 (7 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql
r15528 r15552 42 42 ALTER TABLE [dbo].[AssignedTaskResource] DROP CONSTRAINT [Resource_AssignedTaskResource] 43 43 ALTER TABLE [dbo].[AssignedTaskResource] WITH CHECK ADD CONSTRAINT [Resource_AssignedTaskResource] FOREIGN KEY([ResourceId]) 44 REFERENCES [dbo].[Resource] ([ResourceId]) 45 ON UPDATE CASCADE 46 ON DELETE CASCADE 47 GO 48 49 ALTER TABLE [dbo].[AssignedJobResource] DROP CONSTRAINT [Job_AssignedJobResource] 50 ALTER TABLE [dbo].[AssignedJobResource] WITH CHECK ADD CONSTRAINT [Job_AssignedJobResource] FOREIGN KEY([JobId]) 51 REFERENCES [dbo].[Job] ([JobId]) 52 ON UPDATE CASCADE 53 ON DELETE CASCADE 54 GO 55 ALTER TABLE [dbo].[AssignedJobResource] DROP CONSTRAINT [Resource_AssignedJobResource] 56 ALTER TABLE [dbo].[AssignedJobResource] WITH CHECK ADD CONSTRAINT [Resource_AssignedJobResource] FOREIGN KEY([ResourceId]) 44 57 REFERENCES [dbo].[Resource] ([ResourceId]) 45 58 ON UPDATE CASCADE … … 105 118 REFERENCES [dbo].[Project] ([ProjectId]) 106 119 ON UPDATE CASCADE 107 ON DELETE CASCADE120 -- ON DELETE CASCADE 108 121 GO 109 122
Note: See TracChangeset
for help on using the changeset viewer.