Changeset 6712 for branches/HeuristicLab.Hive-3.4/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Initialize Hive Database.sql
- Timestamp:
- 09/06/11 16:26:00 (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/HeuristicLab.Hive-3.4/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Initialize Hive Database.sql
r6698 r6712 1 USE [HeuristicLab.Hive-3. 4]1 USE [HeuristicLab.Hive-3.3] 2 2 /* create and initialize hive database tables */ 3 3 … … 6 6 [ResourceId] UniqueIdentifier NOT NULL, 7 7 [JobId] UniqueIdentifier NOT NULL, 8 CONSTRAINT [PK_dbo.ResourceId] PRIMARY KEY ([ResourceId]), 9 CONSTRAINT [PK_dbo.JobId] PRIMARY KEY ([JobId]) 8 CONSTRAINT [PK_dbo.ResourceIdJobId] PRIMARY KEY ([ResourceId], [JobId]) 10 9 ) 11 10 CREATE TABLE [dbo].[Plugin]( … … 59 58 CONSTRAINT [PK_dbo.Job] PRIMARY KEY ([JobId]) 60 59 ) 61 CREATE TABLE [dbo].[ UptimeCalendar](62 [ UptimeCalendarId] UniqueIdentifier,60 CREATE TABLE [dbo].[Downtime]( 61 [DowntimeId] UniqueIdentifier, 63 62 [ResourceId] UniqueIdentifier, 64 63 [StartDate] DateTime, … … 67 66 [Recurring] Bit, 68 67 [RecurringId] UniqueIdentifier, 69 CONSTRAINT [PK_dbo. UptimeCalendar] PRIMARY KEY ([UptimeCalendarId])68 CONSTRAINT [PK_dbo.Downtime] PRIMARY KEY ([DowntimeId]) 70 69 ) 71 70 CREATE TABLE [dbo].[HiveExperiment]( … … 161 160 ALTER TABLE [dbo].[Job] 162 161 ADD CONSTRAINT [HiveExperiment_Job] FOREIGN KEY ([HiveExperimentId]) REFERENCES [dbo].[HiveExperiment]([HiveExperimentId]) 163 ALTER TABLE [dbo].[ UptimeCalendar]164 ADD CONSTRAINT [Resource_ UptimeCalendar] FOREIGN KEY ([ResourceId]) REFERENCES [dbo].[Resource]([ResourceId])162 ALTER TABLE [dbo].[Downtime] 163 ADD CONSTRAINT [Resource_Downtime] FOREIGN KEY ([ResourceId]) REFERENCES [dbo].[Resource]([ResourceId]) 165 164 ALTER TABLE [dbo].[JobData] 166 165 ADD CONSTRAINT [Job_JobData] FOREIGN KEY ([JobId]) REFERENCES [dbo].[Job]([JobId])
Note: See TracChangeset
for help on using the changeset viewer.