Changeset 17059 for stable/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql
- Timestamp:
- 07/04/19 14:28:13 (5 years ago)
- Location:
- stable
- Files:
-
- 3 edited
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/SQL Scripts/Prepare Hive Database.sql
r14186 r17059 19 19 20 20 /* this script is supposed to be executed after the plain DB is generated by the linq-to-sql schema */ 21 USE [HeuristicLab.Hive-3.3] 22 23 ALTER TABLE [dbo].[AssignedResources] DROP CONSTRAINT [Task_AssignedResource] 24 ALTER TABLE [dbo].[AssignedResources] WITH CHECK ADD CONSTRAINT [Task_AssignedResource] FOREIGN KEY([TaskId]) 25 REFERENCES [dbo].[Task] ([TaskId]) 26 ON UPDATE CASCADE 27 ON DELETE CASCADE 28 GO 29 ALTER TABLE [dbo].[AssignedResources] DROP CONSTRAINT [Resource_AssignedResource] 30 ALTER TABLE [dbo].[AssignedResources] WITH CHECK ADD CONSTRAINT [Resource_AssignedResource] FOREIGN KEY([ResourceId]) 21 USE [HeuristicLab.Hive-3.4] 22 23 ALTER TABLE [dbo].[AssignedProjectResource] DROP CONSTRAINT [Project_AssignedProjectResource] 24 ALTER TABLE [dbo].[AssignedProjectResource] WITH CHECK ADD CONSTRAINT [Project_AssignedProjectResource] FOREIGN KEY([ProjectId]) 25 REFERENCES [dbo].[Project] ([ProjectId]) 26 ON UPDATE CASCADE 27 ON DELETE CASCADE 28 GO 29 ALTER TABLE [dbo].[AssignedProjectResource] DROP CONSTRAINT [Resource_AssignedProjectResource] 30 ALTER TABLE [dbo].[AssignedProjectResource] WITH CHECK ADD CONSTRAINT [Resource_AssignedProjectResource] FOREIGN KEY([ResourceId]) 31 REFERENCES [dbo].[Resource] ([ResourceId]) 32 ON UPDATE CASCADE 33 ON DELETE CASCADE 34 GO 35 ALTER TABLE [dbo].[AssignedJobResource] DROP CONSTRAINT [Job_AssignedJobResource] 36 ALTER TABLE [dbo].[AssignedJobResource] WITH CHECK ADD CONSTRAINT [Job_AssignedJobResource] FOREIGN KEY([JobId]) 37 REFERENCES [dbo].[Job] ([JobId]) 38 ON UPDATE CASCADE 39 ON DELETE CASCADE 40 GO 41 ALTER TABLE [dbo].[AssignedJobResource] DROP CONSTRAINT [Resource_AssignedJobResource] 42 ALTER TABLE [dbo].[AssignedJobResource] WITH CHECK ADD CONSTRAINT [Resource_AssignedJobResource] FOREIGN KEY([ResourceId]) 31 43 REFERENCES [dbo].[Resource] ([ResourceId]) 32 44 ON UPDATE CASCADE … … 88 100 ALTER TABLE dbo.Job ALTER COLUMN JobId ADD ROWGUIDCOL; 89 101 ALTER TABLE dbo.Job WITH NOCHECK ADD CONSTRAINT [DF_Job_JobId] DEFAULT (NEWSEQUENTIALID()) FOR JobId; 102 ALTER TABLE [dbo].[Job] DROP CONSTRAINT [Project_Job] 103 ALTER TABLE [dbo].[Job] WITH CHECK ADD CONSTRAINT [Project_Job] FOREIGN KEY([ProjectId]) 104 REFERENCES [dbo].[Project] ([ProjectId]) 105 ON UPDATE CASCADE 106 GO 90 107 91 108 ALTER TABLE dbo.StateLog ALTER COLUMN StateLogId ADD ROWGUIDCOL; … … 99 116 GO 100 117 101 ALTER TABLE [dbo].[ResourcePermission] DROP CONSTRAINT [Resource_ResourcePermission] 102 ALTER TABLE [dbo].[ResourcePermission] WITH CHECK ADD CONSTRAINT [Resource_ResourcePermission] FOREIGN KEY([ResourceId]) 103 REFERENCES [dbo].[Resource] ([ResourceId]) 118 ALTER TABLE dbo.Project ALTER COLUMN ProjectId ADD ROWGUIDCOL; 119 ALTER TABLE dbo.Project WITH NOCHECK ADD CONSTRAINT [DF_Project_ProjectId] DEFAULT (NEWSEQUENTIALID()) FOR ProjectId; 120 121 ALTER TABLE [dbo].[ProjectPermission] DROP CONSTRAINT [Project_ProjectPermission] 122 ALTER TABLE [dbo].[ProjectPermission] WITH CHECK ADD CONSTRAINT [Project_ProjectPermission] FOREIGN KEY([ProjectId]) 123 REFERENCES [dbo].[Project] ([ProjectId]) 104 124 ON UPDATE CASCADE 105 125 ON DELETE CASCADE … … 123 143 124 144 145 146 -- OBSOLETE - DO NOT PERFORM (start) 125 147 /****** Object: Trigger [dbo].[tr_JobDeleteCascade] Script Date: 04/19/2011 16:31:53 ******/ 126 148 SET ANSI_NULLS ON … … 175 197 END 176 198 GO 177 178 199 -- OBSOLETE (end) 200
Note: See TracChangeset
for help on using the changeset viewer.