Changeset 12477 for branches/HiveStatistics/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts

Timestamp:

06/18/15 17:28:03 (10 years ago)

Author:

dglaser

Message:

#2388: Created WebApp.Statistics plugin

File:

• branches/HiveStatistics/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Initialize Hive Database.sql (modified) (1 diff)

branches/HiveStatistics/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Initialize Hive Database.sql

@@ -219 +219 @@
 );
 CREATE TABLE [statistics].[DimJob] (
-    [JobId]    UNIQUEIDENTIFIER NOT NULL,
-    [UserId]   UNIQUEIDENTIFIER NOT NULL,
-    [JobName]  VARCHAR (MAX)    NOT NULL,
-    [UserName] VARCHAR (MAX)    NOT NULL,
+    [JobId]       UNIQUEIDENTIFIER NOT NULL,
+    [UserId]      UNIQUEIDENTIFIER NOT NULL,
+    [JobName]     VARCHAR (MAX)    NOT NULL,
+    [UserName]    VARCHAR (MAX)    NOT NULL,
+  [DateCreated] DATETIME       NOT NULL,
     CONSTRAINT [PK_DimJob] PRIMARY KEY CLUSTERED ([JobId] ASC)
 );