Free cookie consent management tool by TermsFeed Policy Generator

source: branches/2989_MovingPeaksBenchmark/HeuristicLab.Services.OKB.DataAccess/3.3/SQL Scripts/Initialize OKB.sql @ 17530

Last change on this file since 17530 was 13682, checked in by abeham, 9 years ago

#2588:

  • Added table, FK constraints, and FK indexes to database
  • Updated Linq2Sql mapping
  • Added service methods and dtos for downloading
  • Property svn:mime-type set to application/octet-stream
File size: 41.4 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
283CREATE TABLE [dbo].[SingleObjectiveSolution](
284  [Id] [bigint] IDENTITY(1,1) NOT NULL,
285  [ProblemId] [bigint] NULL,
286  [DataTypeId] [bigint] NULL,
287  [BinaryDataId] [bigint] NULL,
288  [RunId] [bigint] NULL,
289  [Quality] [float] NOT NULL,
290 CONSTRAINT [PK_SingleObjectiveSolution] PRIMARY KEY CLUSTERED
291(
292  [Id] ASC
293)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
294) ON [PRIMARY]
295GO
296/****** Object:  ForeignKey [FK_AlgorithmClass_Algorithm]    Script Date: 01/31/2011 02:17:22 ******/
297ALTER TABLE [dbo].[Algorithm]  WITH CHECK ADD  CONSTRAINT [FK_AlgorithmClass_Algorithm] FOREIGN KEY([AlgorithmClassId])
298REFERENCES [dbo].[AlgorithmClass] ([Id])
299GO
300ALTER TABLE [dbo].[Algorithm] CHECK CONSTRAINT [FK_AlgorithmClass_Algorithm]
301GO
302/****** Object:  ForeignKey [FK_BinaryData_Algorithm]    Script Date: 01/31/2011 02:17:22 ******/
303ALTER TABLE [dbo].[Algorithm]  WITH CHECK ADD  CONSTRAINT [FK_BinaryData_Algorithm] FOREIGN KEY([BinaryDataId])
304REFERENCES [dbo].[BinaryData] ([Id])
305GO
306ALTER TABLE [dbo].[Algorithm] CHECK CONSTRAINT [FK_BinaryData_Algorithm]
307GO
308/****** Object:  ForeignKey [FK_DataType_Algorithm]    Script Date: 01/31/2011 02:17:22 ******/
309ALTER TABLE [dbo].[Algorithm]  WITH CHECK ADD  CONSTRAINT [FK_DataType_Algorithm] FOREIGN KEY([DataTypeId])
310REFERENCES [dbo].[DataType] ([Id])
311GO
312ALTER TABLE [dbo].[Algorithm] CHECK CONSTRAINT [FK_DataType_Algorithm]
313GO
314/****** Object:  ForeignKey [FK_Platform_Algorithm]    Script Date: 01/31/2011 02:17:22 ******/
315ALTER TABLE [dbo].[Algorithm]  WITH CHECK ADD  CONSTRAINT [FK_Platform_Algorithm] FOREIGN KEY([PlatformId])
316REFERENCES [dbo].[Platform] ([Id])
317GO
318ALTER TABLE [dbo].[Algorithm] CHECK CONSTRAINT [FK_Platform_Algorithm]
319GO
320/****** Object:  ForeignKey [FK_Algorithm_AlgorithmUser]    Script Date: 01/31/2011 02:17:22 ******/
321ALTER TABLE [dbo].[AlgorithmUser]  WITH CHECK ADD  CONSTRAINT [FK_Algorithm_AlgorithmUser] FOREIGN KEY([AlgorithmId])
322REFERENCES [dbo].[Algorithm] ([Id])
323ON UPDATE CASCADE
324ON DELETE CASCADE
325GO
326ALTER TABLE [dbo].[AlgorithmUser] CHECK CONSTRAINT [FK_Algorithm_AlgorithmUser]
327GO
328/****** Object:  ForeignKey [FK_Characteristic_CharacteristicValue]    Script Date: 01/31/2011 02:17:22 ******/
329ALTER TABLE [dbo].[CharacteristicValue]  WITH CHECK ADD  CONSTRAINT [FK_Characteristic_CharacteristicValue] FOREIGN KEY([CharacteristicId])
330REFERENCES [dbo].[Characteristic] ([Id])
331GO
332ALTER TABLE [dbo].[CharacteristicValue] CHECK CONSTRAINT [FK_Characteristic_CharacteristicValue]
333GO
334/****** Object:  ForeignKey [FK_DataType_CharacteristicValue]    Script Date: 01/31/2011 02:17:22 ******/
335ALTER TABLE [dbo].[CharacteristicValue]  WITH CHECK ADD  CONSTRAINT [FK_DataType_CharacteristicValue] FOREIGN KEY([DataTypeId])
336REFERENCES [dbo].[DataType] ([Id])
337GO
338ALTER TABLE [dbo].[CharacteristicValue] CHECK CONSTRAINT [FK_DataType_CharacteristicValue]
339GO
340/****** Object:  ForeignKey [FK_Problem_CharacteristicValue]    Script Date: 01/31/2011 02:17:22 ******/
341ALTER TABLE [dbo].[CharacteristicValue]  WITH CHECK ADD  CONSTRAINT [FK_Problem_CharacteristicValue] FOREIGN KEY([ProblemId])
342REFERENCES [dbo].[Problem] ([Id])
343GO
344ALTER TABLE [dbo].[CharacteristicValue] CHECK CONSTRAINT [FK_Problem_CharacteristicValue]
345GO
346/****** Object:  ForeignKey [FK_BinaryData_Problem]    Script Date: 01/31/2011 02:17:22 ******/
347ALTER TABLE [dbo].[Problem]  WITH CHECK ADD  CONSTRAINT [FK_BinaryData_Problem] FOREIGN KEY([BinaryDataId])
348REFERENCES [dbo].[BinaryData] ([Id])
349GO
350ALTER TABLE [dbo].[Problem] CHECK CONSTRAINT [FK_BinaryData_Problem]
351GO
352/****** Object:  ForeignKey [FK_DataType_Problem]    Script Date: 01/31/2011 02:17:22 ******/
353ALTER TABLE [dbo].[Problem]  WITH CHECK ADD  CONSTRAINT [FK_DataType_Problem] FOREIGN KEY([DataTypeId])
354REFERENCES [dbo].[DataType] ([Id])
355GO
356ALTER TABLE [dbo].[Problem] CHECK CONSTRAINT [FK_DataType_Problem]
357GO
358/****** Object:  ForeignKey [FK_Platform_Problem]    Script Date: 01/31/2011 02:17:22 ******/
359ALTER TABLE [dbo].[Problem]  WITH CHECK ADD  CONSTRAINT [FK_Platform_Problem] FOREIGN KEY([PlatformId])
360REFERENCES [dbo].[Platform] ([Id])
361GO
362ALTER TABLE [dbo].[Problem] CHECK CONSTRAINT [FK_Platform_Problem]
363GO
364/****** Object:  ForeignKey [FK_ProblemClass_Problem]    Script Date: 01/31/2011 02:17:22 ******/
365ALTER TABLE [dbo].[Problem]  WITH CHECK ADD  CONSTRAINT [FK_ProblemClass_Problem] FOREIGN KEY([ProblemClassId])
366REFERENCES [dbo].[ProblemClass] ([Id])
367GO
368ALTER TABLE [dbo].[Problem] CHECK CONSTRAINT [FK_ProblemClass_Problem]
369GO
370/****** Object:  ForeignKey [FK_Problem_ProblemUser]    Script Date: 01/31/2011 02:17:22 ******/
371ALTER TABLE [dbo].[ProblemUser]  WITH CHECK ADD  CONSTRAINT [FK_Problem_ProblemUser] FOREIGN KEY([ProblemId])
372REFERENCES [dbo].[Problem] ([Id])
373ON UPDATE CASCADE
374ON DELETE CASCADE
375GO
376ALTER TABLE [dbo].[ProblemUser] CHECK CONSTRAINT [FK_Problem_ProblemUser]
377GO
378/****** Object:  ForeignKey [FK_Algorithm_Run]    Script Date: 01/31/2011 02:17:22 ******/
379ALTER TABLE [dbo].[Run]  WITH CHECK ADD  CONSTRAINT [FK_Algorithm_Run] FOREIGN KEY([AlgorithmId])
380REFERENCES [dbo].[Algorithm] ([Id])
381GO
382ALTER TABLE [dbo].[Run] CHECK CONSTRAINT [FK_Algorithm_Run]
383GO
384/****** Object:  ForeignKey [FK_Problem_Run]    Script Date: 01/31/2011 02:17:22 ******/
385ALTER TABLE [dbo].[Run]  WITH CHECK ADD  CONSTRAINT [FK_Problem_Run] FOREIGN KEY([ProblemId])
386REFERENCES [dbo].[Problem] ([Id])
387GO
388ALTER TABLE [dbo].[Run] CHECK CONSTRAINT [FK_Problem_Run]
389GO
390/****** Object:  ForeignKey [FK_BinaryData_Value]    Script Date: 01/31/2011 02:17:22 ******/
391ALTER TABLE [dbo].[Value]  WITH CHECK ADD  CONSTRAINT [FK_BinaryData_Value] FOREIGN KEY([BinaryDataId])
392REFERENCES [dbo].[BinaryData] ([Id])
393GO
394ALTER TABLE [dbo].[Value] CHECK CONSTRAINT [FK_BinaryData_Value]
395GO
396/****** Object:  ForeignKey [FK_DataType_Value]    Script Date: 01/31/2011 02:17:22 ******/
397ALTER TABLE [dbo].[Value]  WITH CHECK ADD  CONSTRAINT [FK_DataType_Value] FOREIGN KEY([DataTypeId])
398REFERENCES [dbo].[DataType] ([Id])
399GO
400ALTER TABLE [dbo].[Value] CHECK CONSTRAINT [FK_DataType_Value]
401GO
402/****** Object:  ForeignKey [FK_Run_Value]    Script Date: 01/31/2011 02:17:22 ******/
403ALTER TABLE [dbo].[Value]  WITH CHECK ADD  CONSTRAINT [FK_Run_Value] FOREIGN KEY([RunId])
404REFERENCES [dbo].[Run] ([Id])
405GO
406ALTER TABLE [dbo].[Value] CHECK CONSTRAINT [FK_Run_Value]
407GO
408/****** Object:  ForeignKey [FK_ValueName_Value]    Script Date: 01/31/2011 02:17:22 ******/
409ALTER TABLE [dbo].[Value]  WITH CHECK ADD  CONSTRAINT [FK_ValueName_Value] FOREIGN KEY([ValueNameId])
410REFERENCES [dbo].[ValueName] ([Id])
411GO
412ALTER TABLE [dbo].[Value] CHECK CONSTRAINT [FK_ValueName_Value]
413GO
414ALTER TABLE [dbo].[SingleObjectiveSolution]  WITH CHECK ADD  CONSTRAINT [FK_SingleObjectiveSolution_BinaryData] FOREIGN KEY([BinaryDataId])
415REFERENCES [dbo].[BinaryData] ([Id])
416GO
417ALTER TABLE [dbo].[SingleObjectiveSolution] CHECK CONSTRAINT [FK_SingleObjectiveSolution_BinaryData]
418GO
419ALTER TABLE [dbo].[SingleObjectiveSolution]  WITH CHECK ADD  CONSTRAINT [FK_SingleObjectiveSolution_DataType] FOREIGN KEY([DataTypeId])
420REFERENCES [dbo].[DataType] ([Id])
421GO
422ALTER TABLE [dbo].[SingleObjectiveSolution] CHECK CONSTRAINT [FK_SingleObjectiveSolution_DataType]
423GO
424ALTER TABLE [dbo].[SingleObjectiveSolution]  WITH CHECK ADD  CONSTRAINT [FK_SingleObjectiveSolution_Problem] FOREIGN KEY([ProblemId])
425REFERENCES [dbo].[Problem] ([Id])
426GO
427ALTER TABLE [dbo].[SingleObjectiveSolution] CHECK CONSTRAINT [FK_SingleObjectiveSolution_Problem]
428GO
429ALTER TABLE [dbo].[SingleObjectiveSolution]  WITH CHECK ADD  CONSTRAINT [FK_SingleObjectiveSolution_Run] FOREIGN KEY([RunId])
430REFERENCES [dbo].[Run] ([Id])
431GO
432ALTER TABLE [dbo].[SingleObjectiveSolution] CHECK CONSTRAINT [FK_SingleObjectiveSolution_Run]
433GO
434/****** Object:  Index [RunValue]    Script Date: 03/09/2016 17:04:01 ******/
435CREATE NONCLUSTERED INDEX [RunValue] ON [dbo].[Value]
436(
437  [RunId] ASC
438)
439INCLUDE ( [Id],
440[ValueNameId],
441[DataTypeId],
442[BoolValue],
443[IntValue],
444[LongValue],
445[FloatValue],
446[DoubleValue],
447[StringValue],
448[BinaryDataId]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
449GO
450/****** Object:  Index [ValueNameValue]    Script Date: 03/09/2016 17:05:09 ******/
451CREATE NONCLUSTERED INDEX [ValueNameValue] ON [dbo].[Value]
452(
453  [ValueNameId] ASC
454)
455INCLUDE ( [DataTypeId]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
456GO
457/****** Object:  Index [ProblemCharacteristicValue]    Script Date: 03/09/2016 17:07:54 ******/
458CREATE NONCLUSTERED INDEX [ProblemCharacteristicValue] ON [dbo].[CharacteristicValue]
459(
460  [ProblemId] ASC
461)
462INCLUDE ( [Id],
463[CharacteristicId],
464[DataTypeId],
465[BoolValue],
466[IntValue],
467[LongValue],
468[FloatValue],
469[DoubleValue],
470[StringValue]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
471GO
472/****** Object:  Index [CharacteristicCharacteristicValue]    Script Date: 03/09/2016 17:08:15 ******/
473CREATE NONCLUSTERED INDEX [CharacteristicCharacteristicValue] ON [dbo].[CharacteristicValue]
474(
475  [CharacteristicId] ASC
476)
477INCLUDE ( [DataTypeId]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
478GO
479/****** Object:  Index [SolutionRunId]    Script Date: 03/10/2016 15:01:59 ******/
480CREATE NONCLUSTERED INDEX [SolutionRunId] ON [dbo].[SingleObjectiveSolution]
481(
482  [RunId] ASC
483)
484INCLUDE ( [Id],
485[ProblemId],
486[BinaryDataId],
487[Quality],
488[DataTypeId]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
489GO
490/****** Object:  Index [SolutionProblemId]    Script Date: 03/10/2016 15:01:57 ******/
491CREATE NONCLUSTERED INDEX [SolutionProblemId] ON [dbo].[SingleObjectiveSolution]
492(
493  [ProblemId] ASC
494)
495INCLUDE ( [Id],
496[BinaryDataId],
497[RunId],
498[Quality],
499[DataTypeId]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
500GO
Note: See TracBrowser for help on using the repository browser.