source: trunk/sources/HeuristicLab.Services.OKB.DataAccess/3.3/SQL Scripts/Initialize OKB.sql @ 8049

Last change on this file since 8049 was 8049, checked in by ascheibe, 10 years ago

#1174 integrated OKB services parts into trunk

  • Property svn:mime-type set to application/octet-stream
File size: 32.8 KB
Line 
1USE [HeuristicLab.OKB]
2GO
3/****** Object:  Table [dbo].[ValueName]    Script Date: 01/31/2011 02:17:22 ******/
4SET ANSI_NULLS ON
5GO
6SET QUOTED_IDENTIFIER ON
7GO
8CREATE TABLE [dbo].[ValueName](
9  [Id] [bigint] IDENTITY(1,1) NOT NULL,
10  [Name] [nvarchar](200) NOT NULL,
11  [Category] [tinyint] NOT NULL,
12  [Type] [tinyint] NOT NULL,
13 CONSTRAINT [PK_ValueName_Id] PRIMARY KEY CLUSTERED
14(
15  [Id] ASC
16)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
17) ON [PRIMARY]
18GO
19/****** Object:  Table [dbo].[ProblemClass]    Script Date: 01/31/2011 02:17:22 ******/
20SET ANSI_NULLS ON
21GO
22SET QUOTED_IDENTIFIER ON
23GO
24CREATE TABLE [dbo].[ProblemClass](
25  [Id] [bigint] IDENTITY(1,1) NOT NULL,
26  [Name] [nvarchar](200) NOT NULL,
27  [Description] [nvarchar](max) NULL,
28 CONSTRAINT [PK_ProblemClass_Id] PRIMARY KEY CLUSTERED
29(
30  [Id] ASC
31)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
32 CONSTRAINT [UQ_ProblemClass_Name] UNIQUE NONCLUSTERED
33(
34  [Name] ASC
35)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
36) ON [PRIMARY]
37GO
38SET IDENTITY_INSERT [dbo].[ProblemClass] ON
39INSERT [dbo].[ProblemClass] ([Id], [Name], [Description]) VALUES (1, N'Unknown', N'Unknown or undefined problem class.')
40SET IDENTITY_INSERT [dbo].[ProblemClass] OFF
41/****** Object:  Table [dbo].[Characteristic]    Script Date: 01/31/2011 02:17:22 ******/
42SET ANSI_NULLS ON
43GO
44SET QUOTED_IDENTIFIER ON
45GO
46CREATE TABLE [dbo].[Characteristic](
47  [Id] [bigint] IDENTITY(1,1) NOT NULL,
48  [Name] [nvarchar](200) NOT NULL,
49  [Type] [tinyint] NOT NULL,
50 CONSTRAINT [PK_Characteristic_Id] PRIMARY KEY CLUSTERED
51(
52  [Id] ASC
53)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
54) ON [PRIMARY]
55GO
56/****** Object:  Table [dbo].[BinaryData]    Script Date: 01/31/2011 02:17:22 ******/
57SET ANSI_NULLS ON
58GO
59SET QUOTED_IDENTIFIER ON
60GO
61SET ANSI_PADDING ON
62GO
63CREATE TABLE [dbo].[BinaryData](
64  [Id] [bigint] IDENTITY(1,1) NOT NULL,
65  [Data] [varbinary](max) NOT NULL,
66  [Hash] [varbinary](20) NOT NULL,
67 CONSTRAINT [PK_BinaryData_Id] PRIMARY KEY CLUSTERED
68(
69  [Id] ASC
70)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
71 CONSTRAINT [UQ_BinaryData_Hash] UNIQUE NONCLUSTERED
72(
73  [Hash] ASC
74)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
75) ON [PRIMARY]
76GO
77SET ANSI_PADDING OFF
78GO
79/****** Object:  Table [dbo].[AlgorithmClass]    Script Date: 01/31/2011 02:17:22 ******/
80SET ANSI_NULLS ON
81GO
82SET QUOTED_IDENTIFIER ON
83GO
84CREATE TABLE [dbo].[AlgorithmClass](
85  [Id] [bigint] IDENTITY(1,1) NOT NULL,
86  [Name] [nvarchar](200) NOT NULL,
87  [Description] [nvarchar](max) NULL,
88 CONSTRAINT [PK_AlgorithmClass_Id] PRIMARY KEY CLUSTERED
89(
90  [Id] ASC
91)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
92 CONSTRAINT [UQ_AlgorithmClass_Name] UNIQUE NONCLUSTERED
93(
94  [Name] ASC
95)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
96) ON [PRIMARY]
97GO
98SET IDENTITY_INSERT [dbo].[AlgorithmClass] ON
99INSERT [dbo].[AlgorithmClass] ([Id], [Name], [Description]) VALUES (1, N'Unknown', N'Unknown or undefined algorithm class.')
100SET IDENTITY_INSERT [dbo].[AlgorithmClass] OFF
101/****** Object:  Table [dbo].[Platform]    Script Date: 01/31/2011 02:17:22 ******/
102SET ANSI_NULLS ON
103GO
104SET QUOTED_IDENTIFIER ON
105GO
106CREATE TABLE [dbo].[Platform](
107  [Id] [bigint] IDENTITY(1,1) NOT NULL,
108  [Name] [nvarchar](200) NOT NULL,
109  [Description] [nvarchar](max) NULL,
110 CONSTRAINT [PK_Platform_Id] PRIMARY KEY CLUSTERED
111(
112  [Id] ASC
113)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
114 CONSTRAINT [UQ_Platform_Name] UNIQUE NONCLUSTERED
115(
116  [Name] ASC
117)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
118) ON [PRIMARY]
119GO
120SET IDENTITY_INSERT [dbo].[Platform] ON
121INSERT [dbo].[Platform] ([Id], [Name], [Description]) VALUES (1, N'Unknown', N'Unknown or undefined platform.')
122INSERT [dbo].[Platform] ([Id], [Name], [Description]) VALUES (2, N'HeuristicLab 3.3', NULL)
123SET IDENTITY_INSERT [dbo].[Platform] OFF
124/****** Object:  Table [dbo].[DataType]    Script Date: 01/31/2011 02:17:22 ******/
125SET ANSI_NULLS ON
126GO
127SET QUOTED_IDENTIFIER ON
128GO
129CREATE TABLE [dbo].[DataType](
130  [Id] [bigint] IDENTITY(1,1) NOT NULL,
131  [Name] [nvarchar](200) NOT NULL,
132  [TypeName] [nvarchar](max) NOT NULL,
133 CONSTRAINT [PK_DataType_Id] PRIMARY KEY CLUSTERED
134(
135  [Id] ASC
136)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
137) ON [PRIMARY]
138GO
139SET IDENTITY_INSERT [dbo].[DataType] ON
140INSERT [dbo].[DataType] ([Id], [Name], [TypeName]) VALUES (1, N'Unknown', N'Unknown')
141SET IDENTITY_INSERT [dbo].[DataType] OFF
142/****** Object:  Table [dbo].[Problem]    Script Date: 01/31/2011 02:17:22 ******/
143SET ANSI_NULLS ON
144GO
145SET QUOTED_IDENTIFIER ON
146GO
147CREATE TABLE [dbo].[Problem](
148  [Id] [bigint] IDENTITY(1,1) NOT NULL,
149  [ProblemClassId] [bigint] NOT NULL,
150  [PlatformId] [bigint] NOT NULL,
151  [DataTypeId] [bigint] NOT NULL,
152  [BinaryDataId] [bigint] NULL,
153  [Name] [nvarchar](200) NOT NULL,
154  [Description] [nvarchar](max) NULL,
155 CONSTRAINT [PK_Problem_Id] PRIMARY KEY CLUSTERED
156(
157  [Id] ASC
158)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
159 CONSTRAINT [UQ_Problem_Name_PlatformId] UNIQUE NONCLUSTERED
160(
161  [Name] ASC,
162  [PlatformId] ASC
163)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
164) ON [PRIMARY]
165GO
166/****** Object:  Table [dbo].[Algorithm]    Script Date: 01/31/2011 02:17:22 ******/
167SET ANSI_NULLS ON
168GO
169SET QUOTED_IDENTIFIER ON
170GO
171CREATE TABLE [dbo].[Algorithm](
172  [Id] [bigint] IDENTITY(1,1) NOT NULL,
173  [AlgorithmClassId] [bigint] NOT NULL,
174  [PlatformId] [bigint] NOT NULL,
175  [DataTypeId] [bigint] NOT NULL,
176  [BinaryDataId] [bigint] NULL,
177  [Name] [nvarchar](200) NOT NULL,
178  [Description] [nvarchar](max) NULL,
179 CONSTRAINT [PK_Algorithm_Id] PRIMARY KEY CLUSTERED
180(
181  [Id] ASC
182)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
183 CONSTRAINT [UQ_Algorithm_Name_PlatformId] UNIQUE NONCLUSTERED
184(
185  [Name] ASC,
186  [PlatformId] ASC
187)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
188) ON [PRIMARY]
189GO
190/****** Object:  Table [dbo].[CharacteristicValue]    Script Date: 01/31/2011 02:17:22 ******/
191SET ANSI_NULLS ON
192GO
193SET QUOTED_IDENTIFIER ON
194GO
195CREATE TABLE [dbo].[CharacteristicValue](
196  [Id] [bigint] IDENTITY(1,1) NOT NULL,
197  [ProblemId] [bigint] NOT NULL,
198  [CharacteristicId] [bigint] NOT NULL,
199  [DataTypeId] [bigint] NOT NULL,
200  [BoolValue] [bit] SPARSE  NULL,
201  [IntValue] [int] SPARSE  NULL,
202  [LongValue] [bigint] SPARSE  NULL,
203  [FloatValue] [real] SPARSE  NULL,
204  [DoubleValue] [float] SPARSE  NULL,
205  [StringValue] [nvarchar](max) SPARSE  NULL,
206 CONSTRAINT [PK_CharacteristicValue_Id] PRIMARY KEY CLUSTERED
207(
208  [Id] ASC
209)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
210) ON [PRIMARY]
211GO
212/****** Object:  Table [dbo].[AlgorithmUser]    Script Date: 01/31/2011 02:17:22 ******/
213SET ANSI_NULLS ON
214GO
215SET QUOTED_IDENTIFIER ON
216GO
217CREATE TABLE [dbo].[AlgorithmUser](
218  [AlgorithmId] [bigint] NOT NULL,
219  [UserGroupId] [uniqueidentifier] NOT NULL,
220 CONSTRAINT [PK_AlgorithmUser_AlgorithmId_UserId] PRIMARY KEY CLUSTERED
221(
222  [AlgorithmId] ASC,
223  [UserGroupId] ASC
224)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
225) ON [PRIMARY]
226GO
227/****** Object:  Table [dbo].[Run]    Script Date: 01/31/2011 02:17:22 ******/
228SET ANSI_NULLS ON
229GO
230SET QUOTED_IDENTIFIER ON
231GO
232CREATE TABLE [dbo].[Run](
233  [Id] [bigint] IDENTITY(1,1) NOT NULL,
234  [AlgorithmId] [bigint] NOT NULL,
235  [ProblemId] [bigint] NOT NULL, 
236  [CreatedDate] [datetime2](7) NOT NULL,
237  [UserId] [uniqueidentifier] NOT NULL,
238  [ClientId] [uniqueidentifier] NOT NULL,
239 CONSTRAINT [PK_Run_Id] PRIMARY KEY CLUSTERED
240(
241  [Id] ASC
242)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
243) ON [PRIMARY]
244GO
245/****** Object:  Table [dbo].[ProblemUser]    Script Date: 01/31/2011 02:17:22 ******/
246SET ANSI_NULLS ON
247GO
248SET QUOTED_IDENTIFIER ON
249GO
250CREATE TABLE [dbo].[ProblemUser](
251  [ProblemId] [bigint] NOT NULL,
252  [UserGroupId] [uniqueidentifier] NOT NULL,
253 CONSTRAINT [PK_ProblemUser_ProblemId_UserId] PRIMARY KEY CLUSTERED
254(
255  [ProblemId] ASC,
256  [UserGroupId] ASC
257)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
258) ON [PRIMARY]
259GO
260/****** Object:  Table [dbo].[Value]    Script Date: 01/31/2011 02:17:22 ******/
261SET ANSI_NULLS ON
262GO
263SET QUOTED_IDENTIFIER ON
264GO
265CREATE TABLE [dbo].[Value](
266  [Id] [bigint] IDENTITY(1,1) NOT NULL,
267  [RunId] [bigint] NOT NULL,
268  [ValueNameId] [bigint] NOT NULL,
269  [DataTypeId] [bigint] NOT NULL,
270  [BoolValue] [bit] SPARSE  NULL,
271  [IntValue] [int] SPARSE  NULL,
272  [LongValue] [bigint] SPARSE  NULL,
273  [FloatValue] [real] SPARSE  NULL,
274  [DoubleValue] [float] SPARSE  NULL,
275  [StringValue] [nvarchar](max) SPARSE  NULL,
276  [BinaryDataId] [bigint] SPARSE  NULL,
277 CONSTRAINT [PK_Value_Id] PRIMARY KEY CLUSTERED
278(
279  [Id] ASC
280)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
281) ON [PRIMARY]
282GO
283/****** Object:  ForeignKey [FK_AlgorithmClass_Algorithm]    Script Date: 01/31/2011 02:17:22 ******/
284ALTER TABLE [dbo].[Algorithm]  WITH CHECK ADD  CONSTRAINT [FK_AlgorithmClass_Algorithm] FOREIGN KEY([AlgorithmClassId])
285REFERENCES [dbo].[AlgorithmClass] ([Id])
286GO
287ALTER TABLE [dbo].[Algorithm] CHECK CONSTRAINT [FK_AlgorithmClass_Algorithm]
288GO
289/****** Object:  ForeignKey [FK_BinaryData_Algorithm]    Script Date: 01/31/2011 02:17:22 ******/
290ALTER TABLE [dbo].[Algorithm]  WITH CHECK ADD  CONSTRAINT [FK_BinaryData_Algorithm] FOREIGN KEY([BinaryDataId])
291REFERENCES [dbo].[BinaryData] ([Id])
292GO
293ALTER TABLE [dbo].[Algorithm] CHECK CONSTRAINT [FK_BinaryData_Algorithm]
294GO
295/****** Object:  ForeignKey [FK_DataType_Algorithm]    Script Date: 01/31/2011 02:17:22 ******/
296ALTER TABLE [dbo].[Algorithm]  WITH CHECK ADD  CONSTRAINT [FK_DataType_Algorithm] FOREIGN KEY([DataTypeId])
297REFERENCES [dbo].[DataType] ([Id])
298GO
299ALTER TABLE [dbo].[Algorithm] CHECK CONSTRAINT [FK_DataType_Algorithm]
300GO
301/****** Object:  ForeignKey [FK_Platform_Algorithm]    Script Date: 01/31/2011 02:17:22 ******/
302ALTER TABLE [dbo].[Algorithm]  WITH CHECK ADD  CONSTRAINT [FK_Platform_Algorithm] FOREIGN KEY([PlatformId])
303REFERENCES [dbo].[Platform] ([Id])
304GO
305ALTER TABLE [dbo].[Algorithm] CHECK CONSTRAINT [FK_Platform_Algorithm]
306GO
307/****** Object:  ForeignKey [FK_Algorithm_AlgorithmUser]    Script Date: 01/31/2011 02:17:22 ******/
308ALTER TABLE [dbo].[AlgorithmUser]  WITH CHECK ADD  CONSTRAINT [FK_Algorithm_AlgorithmUser] FOREIGN KEY([AlgorithmId])
309REFERENCES [dbo].[Algorithm] ([Id])
310ON UPDATE CASCADE
311ON DELETE CASCADE
312GO
313ALTER TABLE [dbo].[AlgorithmUser] CHECK CONSTRAINT [FK_Algorithm_AlgorithmUser]
314GO
315/****** Object:  ForeignKey [FK_Characteristic_CharacteristicValue]    Script Date: 01/31/2011 02:17:22 ******/
316ALTER TABLE [dbo].[CharacteristicValue]  WITH CHECK ADD  CONSTRAINT [FK_Characteristic_CharacteristicValue] FOREIGN KEY([CharacteristicId])
317REFERENCES [dbo].[Characteristic] ([Id])
318GO
319ALTER TABLE [dbo].[CharacteristicValue] CHECK CONSTRAINT [FK_Characteristic_CharacteristicValue]
320GO
321/****** Object:  ForeignKey [FK_DataType_CharacteristicValue]    Script Date: 01/31/2011 02:17:22 ******/
322ALTER TABLE [dbo].[CharacteristicValue]  WITH CHECK ADD  CONSTRAINT [FK_DataType_CharacteristicValue] FOREIGN KEY([DataTypeId])
323REFERENCES [dbo].[DataType] ([Id])
324GO
325ALTER TABLE [dbo].[CharacteristicValue] CHECK CONSTRAINT [FK_DataType_CharacteristicValue]
326GO
327/****** Object:  ForeignKey [FK_Problem_CharacteristicValue]    Script Date: 01/31/2011 02:17:22 ******/
328ALTER TABLE [dbo].[CharacteristicValue]  WITH CHECK ADD  CONSTRAINT [FK_Problem_CharacteristicValue] FOREIGN KEY([ProblemId])
329REFERENCES [dbo].[Problem] ([Id])
330GO
331ALTER TABLE [dbo].[CharacteristicValue] CHECK CONSTRAINT [FK_Problem_CharacteristicValue]
332GO
333/****** Object:  ForeignKey [FK_BinaryData_Problem]    Script Date: 01/31/2011 02:17:22 ******/
334ALTER TABLE [dbo].[Problem]  WITH CHECK ADD  CONSTRAINT [FK_BinaryData_Problem] FOREIGN KEY([BinaryDataId])
335REFERENCES [dbo].[BinaryData] ([Id])
336GO
337ALTER TABLE [dbo].[Problem] CHECK CONSTRAINT [FK_BinaryData_Problem]
338GO
339/****** Object:  ForeignKey [FK_DataType_Problem]    Script Date: 01/31/2011 02:17:22 ******/
340ALTER TABLE [dbo].[Problem]  WITH CHECK ADD  CONSTRAINT [FK_DataType_Problem] FOREIGN KEY([DataTypeId])
341REFERENCES [dbo].[DataType] ([Id])
342GO
343ALTER TABLE [dbo].[Problem] CHECK CONSTRAINT [FK_DataType_Problem]
344GO
345/****** Object:  ForeignKey [FK_Platform_Problem]    Script Date: 01/31/2011 02:17:22 ******/
346ALTER TABLE [dbo].[Problem]  WITH CHECK ADD  CONSTRAINT [FK_Platform_Problem] FOREIGN KEY([PlatformId])
347REFERENCES [dbo].[Platform] ([Id])
348GO
349ALTER TABLE [dbo].[Problem] CHECK CONSTRAINT [FK_Platform_Problem]
350GO
351/****** Object:  ForeignKey [FK_ProblemClass_Problem]    Script Date: 01/31/2011 02:17:22 ******/
352ALTER TABLE [dbo].[Problem]  WITH CHECK ADD  CONSTRAINT [FK_ProblemClass_Problem] FOREIGN KEY([ProblemClassId])
353REFERENCES [dbo].[ProblemClass] ([Id])
354GO
355ALTER TABLE [dbo].[Problem] CHECK CONSTRAINT [FK_ProblemClass_Problem]
356GO
357/****** Object:  ForeignKey [FK_Problem_ProblemUser]    Script Date: 01/31/2011 02:17:22 ******/
358ALTER TABLE [dbo].[ProblemUser]  WITH CHECK ADD  CONSTRAINT [FK_Problem_ProblemUser] FOREIGN KEY([ProblemId])
359REFERENCES [dbo].[Problem] ([Id])
360ON UPDATE CASCADE
361ON DELETE CASCADE
362GO
363ALTER TABLE [dbo].[ProblemUser] CHECK CONSTRAINT [FK_Problem_ProblemUser]
364GO
365/****** Object:  ForeignKey [FK_Algorithm_Run]    Script Date: 01/31/2011 02:17:22 ******/
366ALTER TABLE [dbo].[Run]  WITH CHECK ADD  CONSTRAINT [FK_Algorithm_Run] FOREIGN KEY([AlgorithmId])
367REFERENCES [dbo].[Algorithm] ([Id])
368GO
369ALTER TABLE [dbo].[Run] CHECK CONSTRAINT [FK_Algorithm_Run]
370GO
371/****** Object:  ForeignKey [FK_Problem_Run]    Script Date: 01/31/2011 02:17:22 ******/
372ALTER TABLE [dbo].[Run]  WITH CHECK ADD  CONSTRAINT [FK_Problem_Run] FOREIGN KEY([ProblemId])
373REFERENCES [dbo].[Problem] ([Id])
374GO
375ALTER TABLE [dbo].[Run] CHECK CONSTRAINT [FK_Problem_Run]
376GO
377/****** Object:  ForeignKey [FK_BinaryData_Value]    Script Date: 01/31/2011 02:17:22 ******/
378ALTER TABLE [dbo].[Value]  WITH CHECK ADD  CONSTRAINT [FK_BinaryData_Value] FOREIGN KEY([BinaryDataId])
379REFERENCES [dbo].[BinaryData] ([Id])
380GO
381ALTER TABLE [dbo].[Value] CHECK CONSTRAINT [FK_BinaryData_Value]
382GO
383/****** Object:  ForeignKey [FK_DataType_Value]    Script Date: 01/31/2011 02:17:22 ******/
384ALTER TABLE [dbo].[Value]  WITH CHECK ADD  CONSTRAINT [FK_DataType_Value] FOREIGN KEY([DataTypeId])
385REFERENCES [dbo].[DataType] ([Id])
386GO
387ALTER TABLE [dbo].[Value] CHECK CONSTRAINT [FK_DataType_Value]
388GO
389/****** Object:  ForeignKey [FK_Run_Value]    Script Date: 01/31/2011 02:17:22 ******/
390ALTER TABLE [dbo].[Value]  WITH CHECK ADD  CONSTRAINT [FK_Run_Value] FOREIGN KEY([RunId])
391REFERENCES [dbo].[Run] ([Id])
392GO
393ALTER TABLE [dbo].[Value] CHECK CONSTRAINT [FK_Run_Value]
394GO
395/****** Object:  ForeignKey [FK_ValueName_Value]    Script Date: 01/31/2011 02:17:22 ******/
396ALTER TABLE [dbo].[Value]  WITH CHECK ADD  CONSTRAINT [FK_ValueName_Value] FOREIGN KEY([ValueNameId])
397REFERENCES [dbo].[ValueName] ([Id])
398GO
399ALTER TABLE [dbo].[Value] CHECK CONSTRAINT [FK_ValueName_Value]
400GO
Note: See TracBrowser for help on using the repository browser.