Changeset 6698 for branches/HeuristicLab.Hive-3.4/sources/HeuristicLab.Services.Hive.DataAccess/3.4/SQL Scripts

Timestamp:

09/02/11 11:49:53 (13 years ago)

Author:

ascheibe

Message:

#1233

• implemented review comments
• more cleanups

Location:

branches/HeuristicLab.Hive-3.4/sources/HeuristicLab.Services.Hive.DataAccess/3.4/SQL Scripts

Files:

• Initialize Hive Database.sql (modified) (1 diff)
• Prepare Hive Database.sql (modified) (1 diff)

branches/HeuristicLab.Hive-3.4/sources/HeuristicLab.Services.Hive.DataAccess/3.4/SQL Scripts/Initialize Hive Database.sql

@@ -5 +5 @@
 CREATE TABLE [dbo].[AssignedResources](
   [ResourceId] UniqueIdentifier NOT NULL, 
-  [JobId] UniqueIdentifier NOT NULL, 
-  [AssignedRessourcesId] UniqueIdentifier NOT NULL, 
-  CONSTRAINT [PK_dbo.AssignedResources] PRIMARY KEY ([AssignedRessourcesId])
+  [JobId] UniqueIdentifier NOT NULL,   
+  CONSTRAINT [PK_dbo.ResourceId] PRIMARY KEY ([ResourceId]),
+  CONSTRAINT [PK_dbo.JobId] PRIMARY KEY ([JobId])
   )
 CREATE TABLE [dbo].[Plugin](

branches/HeuristicLab.Hive-3.4/sources/HeuristicLab.Services.Hive.DataAccess/3.4/SQL Scripts/Prepare Hive Database.sql

@@ -8 +8 @@
 
 
-ALTER TABLE dbo.AssignedResources ALTER COLUMN AssignedRessourcesId ADD ROWGUIDCOL;
-ALTER TABLE dbo.AssignedResources WITH NOCHECK ADD CONSTRAINT [DF_AssignedResources_AssignedRessourcesId] DEFAULT (NEWSEQUENTIALID()) FOR AssignedRessourcesId;
 ALTER TABLE [dbo].[AssignedResources]  DROP  CONSTRAINT [Job_AssignedResource]
 ALTER TABLE [dbo].[AssignedResources]  WITH CHECK ADD  CONSTRAINT [Job_AssignedResource] FOREIGN KEY([JobId])