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

Last change on this file since 4294 was 4294, checked in by swagner, 12 years ago

Updated OKB SQL scripts (#1166)

  • Property svn:mime-type set to application/octet-stream
File size: 64.9 KB
Line 
1USE [HeuristicLab.OKB]
2GO
3/****** Object:  Table [dbo].[User]    Script Date: 03/09/2010 16:21:40 ******/
4SET ANSI_NULLS ON
5GO
6SET QUOTED_IDENTIFIER ON
7GO
8SET ANSI_PADDING ON
9GO
10CREATE TABLE [dbo].[User](
11  [Id] [uniqueidentifier] NOT NULL DEFAULT NEWID(),
12  [Name] [varchar](200) NOT NULL,
13PRIMARY 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],
17UNIQUE NONCLUSTERED
18(
19  [Name] ASC
20)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
21) ON [PRIMARY]
22GO
23SET ANSI_PADDING OFF
24GO
25/****** Object:  Table [dbo].[SolutionRepresentation]    Script Date: 03/09/2010 16:21:40 ******/
26SET ANSI_NULLS ON
27GO
28SET QUOTED_IDENTIFIER ON
29GO
30SET ANSI_PADDING ON
31GO
32CREATE TABLE [dbo].[SolutionRepresentation](
33  [Id] [int] IDENTITY(1,1) NOT NULL,
34  [Name] [varchar](200) NOT NULL,
35  [Description] [varchar](max) NULL,
36PRIMARY KEY CLUSTERED
37(
38  [Id] ASC
39)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
40UNIQUE NONCLUSTERED
41(
42  [Name] ASC
43)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
44) ON [PRIMARY]
45GO
46SET ANSI_PADDING OFF
47GO
48/****** Object:  Table [dbo].[ProblemClass]    Script Date: 03/09/2010 16:21:40 ******/
49SET ANSI_NULLS ON
50GO
51SET QUOTED_IDENTIFIER ON
52GO
53SET ANSI_PADDING ON
54GO
55CREATE TABLE [dbo].[ProblemClass](
56  [Id] [int] IDENTITY(1,1) NOT NULL,
57  [Name] [varchar](200) NOT NULL,
58  [Description] [varchar](100) NULL,
59PRIMARY KEY CLUSTERED
60(
61  [Id] ASC
62)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
63UNIQUE NONCLUSTERED
64(
65  [Name] ASC
66)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
67) ON [PRIMARY]
68GO
69SET ANSI_PADDING OFF
70GO
71/****** Object:  Table [dbo].[Project]    Script Date: 03/09/2010 16:21:40 ******/
72SET ANSI_NULLS ON
73GO
74SET QUOTED_IDENTIFIER ON
75GO
76SET ANSI_PADDING ON
77GO
78CREATE TABLE [dbo].[Project](
79  [Id] [int] IDENTITY(1,1) NOT NULL,
80  [Name] [varchar](200) NOT NULL,
81  [Description] [varchar](max) NULL,
82PRIMARY KEY CLUSTERED
83(
84  [Id] ASC
85)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
86) ON [PRIMARY]
87GO
88SET ANSI_PADDING OFF
89GO
90/****** Object:  Table [dbo].[DataType]    Script Date: 03/09/2010 16:21:40 ******/
91SET ANSI_NULLS ON
92GO
93SET QUOTED_IDENTIFIER ON
94GO
95SET ANSI_PADDING ON
96GO
97CREATE TABLE [dbo].[DataType](
98  [Id] [int] IDENTITY(1,1) NOT NULL,
99  [SqlName] [varchar](200) NOT NULL,
100  [ClrName] [varchar](max) NOT NULL,
101PRIMARY KEY CLUSTERED
102(
103  [Id] ASC
104)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
105) ON [PRIMARY]
106GO
107SET ANSI_PADDING OFF
108GO
109SET IDENTITY_INSERT [dbo].[DataType] ON
110INSERT [dbo].[DataType] ([Id], [SqlName], [ClrName]) VALUES (1, N'Int', N'System.Int32')
111INSERT [dbo].[DataType] ([Id], [SqlName], [ClrName]) VALUES (2, N'Float', N'System.Double')
112INSERT [dbo].[DataType] ([Id], [SqlName], [ClrName]) VALUES (3, N'Char', N'System.String')
113INSERT [dbo].[DataType] ([Id], [SqlName], [ClrName]) VALUES (4, N'Blob', N'System.Object')
114INSERT [dbo].[DataType] ([Id], [SqlName], [ClrName]) VALUES (5, N'BLOB', N'IOperator')
115INSERT [dbo].[DataType] ([Id], [SqlName], [ClrName]) VALUES (6, N'Bit', N'System.Boolean')
116SET IDENTITY_INSERT [dbo].[DataType] OFF
117/****** Object:  Table [dbo].[Client]    Script Date: 03/09/2010 16:21:40 ******/
118SET ANSI_NULLS ON
119GO
120SET QUOTED_IDENTIFIER ON
121GO
122SET ANSI_PADDING ON
123GO
124CREATE TABLE [dbo].[Client](
125  [Id] [uniqueidentifier] NOT NULL DEFAULT NEWID(),
126  [Name] [varchar](200) NOT NULL,
127PRIMARY KEY CLUSTERED
128(
129  [Id] ASC
130)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
131UNIQUE NONCLUSTERED
132(
133  [Name] ASC
134)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
135) ON [PRIMARY]
136GO
137SET ANSI_PADDING OFF
138GO
139/****** Object:  Table [dbo].[AlgorithmClass]    Script Date: 03/09/2010 16:21:40 ******/
140SET ANSI_NULLS ON
141GO
142SET QUOTED_IDENTIFIER ON
143GO
144SET ANSI_PADDING ON
145GO
146CREATE TABLE [dbo].[AlgorithmClass](
147  [Id] [int] IDENTITY(1,1) NOT NULL,
148  [Name] [varchar](200) NOT NULL,
149  [Description] [varchar](max) NULL,
150PRIMARY KEY CLUSTERED
151(
152  [Id] ASC
153)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
154UNIQUE NONCLUSTERED
155(
156  [Name] ASC
157)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
158) ON [PRIMARY]
159GO
160SET ANSI_PADDING OFF
161GO
162/****** Object:  Table [dbo].[Platform]    Script Date: 03/09/2010 16:21:40 ******/
163SET ANSI_NULLS ON
164GO
165SET QUOTED_IDENTIFIER ON
166GO
167SET ANSI_PADDING ON
168GO
169CREATE TABLE [dbo].[Platform](
170  [Id] [int] IDENTITY(1,1) NOT NULL,
171  [Name] [varchar](200) NOT NULL,
172  [Description] [varchar](max) NULL,
173PRIMARY KEY CLUSTERED
174(
175  [Id] ASC
176)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
177UNIQUE NONCLUSTERED
178(
179  [Name] ASC
180)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
181) ON [PRIMARY]
182GO
183SET ANSI_PADDING OFF
184GO
185SET IDENTITY_INSERT [dbo].[Platform] ON
186INSERT [dbo].[Platform] ([Id], [Name], [Description]) VALUES (1, N'HL 2.5', N'HeuristicLab 2.5')
187INSERT [dbo].[Platform] ([Id], [Name], [Description]) VALUES (2, N'HL 3.3', N'HeuristicLab 3.3')
188SET IDENTITY_INSERT [dbo].[Platform] OFF
189/****** Object:  Table [dbo].[Parameter]    Script Date: 03/09/2010 16:21:40 ******/
190SET ANSI_NULLS ON
191GO
192SET QUOTED_IDENTIFIER ON
193GO
194SET ANSI_PADDING ON
195GO
196CREATE TABLE [dbo].[Parameter](
197  [Id] [int] IDENTITY(1,1) NOT NULL,
198  [Name] [varchar](900) NULL,
199  [Description] [varchar](max) NULL,
200  [DataTypeId] [int] NOT NULL,
201PRIMARY KEY CLUSTERED
202(
203  [Id] ASC
204)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
205UNIQUE NONCLUSTERED
206(
207  [Name] ASC
208)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
209) ON [PRIMARY]
210GO
211SET ANSI_PADDING OFF
212GO
213/****** Object:  Table [dbo].[Algorithm]    Script Date: 03/09/2010 16:21:40 ******/
214SET ANSI_NULLS ON
215GO
216SET QUOTED_IDENTIFIER ON
217GO
218SET ANSI_PADDING ON
219GO
220CREATE TABLE [dbo].[Algorithm](
221  [Id] [int] IDENTITY(1,1) NOT NULL,
222  [AlgorithmClassId] [int] NOT NULL,
223  [PlatformId] [int] NOT NULL,
224  [Name] [varchar](200) NOT NULL,
225  [Description] [varchar](max) NULL,
226PRIMARY KEY CLUSTERED
227(
228  [Id] ASC
229)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
230UNIQUE NONCLUSTERED
231(
232  [Name] ASC
233)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
234) ON [PRIMARY]
235GO
236SET ANSI_PADDING OFF
237GO
238/****** Object:  Table [dbo].[Result]    Script Date: 03/09/2010 16:21:40 ******/
239SET ANSI_NULLS ON
240GO
241SET QUOTED_IDENTIFIER ON
242GO
243SET ANSI_PADDING ON
244GO
245CREATE TABLE [dbo].[Result](
246  [Id] [int] IDENTITY(1,1) NOT NULL,
247  [Name] [varchar](200) NOT NULL,
248  [Description] [varchar](max) NULL,
249  [DataTypeId] [int] NOT NULL,
250PRIMARY KEY CLUSTERED
251(
252  [Id] ASC
253)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
254UNIQUE NONCLUSTERED
255(
256  [Name] 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
260SET ANSI_PADDING OFF
261GO
262/****** Object:  Table [dbo].[Problem]    Script Date: 03/09/2010 16:21:40 ******/
263SET ANSI_NULLS ON
264GO
265SET QUOTED_IDENTIFIER ON
266GO
267SET ANSI_PADDING ON
268GO
269CREATE TABLE [dbo].[Problem](
270  [Id] [int] IDENTITY(1,1) NOT NULL,
271  [ProblemClassId] [int] NOT NULL,
272  [PlatformId] [int] NOT NULL,
273  [SolutionRepresentationid] [int] NOT NULL,
274  [Name] [varchar](200) NOT NULL,
275  [Description] [varchar](max) NULL,
276PRIMARY KEY CLUSTERED
277(
278  [Id] ASC
279)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
280UNIQUE NONCLUSTERED
281(
282  [Name] ASC
283)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
284) ON [PRIMARY]
285GO
286SET ANSI_PADDING OFF
287GO
288/****** Object:  Table [dbo].[ProblemCharacteristic]    Script Date: 03/09/2010 16:21:40 ******/
289SET ANSI_NULLS ON
290GO
291SET QUOTED_IDENTIFIER ON
292GO
293SET ANSI_PADDING ON
294GO
295CREATE TABLE [dbo].[ProblemCharacteristic](
296  [Id] [int] IDENTITY(1,1) NOT NULL,
297  [Name] [varchar](200) NOT NULL,
298  [Description] [varchar](max) NULL,
299  [DataTypeId] [int] NOT NULL,
300PRIMARY KEY CLUSTERED
301(
302  [Id] ASC
303)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
304UNIQUE NONCLUSTERED
305(
306  [Name] ASC
307)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
308) ON [PRIMARY]
309GO
310SET ANSI_PADDING OFF
311GO
312/****** Object:  Table [dbo].[Problem_Parameter]    Script Date: 03/09/2010 16:21:40 ******/
313SET ANSI_NULLS ON
314GO
315SET QUOTED_IDENTIFIER ON
316GO
317CREATE TABLE [dbo].[Problem_Parameter](
318  [ProblemId] [int] NOT NULL,
319  [ParameterId] [int] NOT NULL,
320PRIMARY KEY CLUSTERED
321(
322  [ProblemId] ASC,
323  [ParameterId] ASC
324)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
325) ON [PRIMARY]
326GO
327/****** Object:  Table [dbo].[ProblemData]    Script Date: 03/09/2010 16:21:40 ******/
328SET ANSI_NULLS ON
329GO
330SET QUOTED_IDENTIFIER ON
331GO
332SET ANSI_PADDING ON
333GO
334CREATE TABLE [dbo].[ProblemData](
335  [ProblemId] [int] NOT NULL,
336  [Data] [varbinary](max) NOT NULL,
337PRIMARY KEY CLUSTERED
338(
339  [ProblemId] ASC
340)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
341) ON [PRIMARY] TEXTIMAGE_ON [DATA]
342GO
343SET ANSI_PADDING OFF
344GO
345/****** Object:  Table [dbo].[IntProblemCharacteristicValue]    Script Date: 03/09/2010 16:21:40 ******/
346SET ANSI_NULLS ON
347GO
348SET QUOTED_IDENTIFIER ON
349GO
350CREATE TABLE [dbo].[IntProblemCharacteristicValue](
351  [ProblemCharacteristicId] [int] NOT NULL,
352  [ProblemId] [int] NOT NULL,
353  [Value] [int] NOT NULL,
354PRIMARY KEY CLUSTERED
355(
356  [ProblemCharacteristicId] ASC,
357  [ProblemId] ASC
358)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
359) ON [PRIMARY]
360GO
361/****** Object:  Table [dbo].[AlgorithmData]    Script Date: 03/09/2010 16:21:40 ******/
362SET ANSI_NULLS ON
363GO
364SET QUOTED_IDENTIFIER ON
365GO
366SET ANSI_PADDING ON
367GO
368CREATE TABLE [dbo].[AlgorithmData](
369  [AlgorithmId] [int] NOT NULL,
370  [Data] [varbinary](max) NOT NULL,
371PRIMARY KEY CLUSTERED
372(
373  [AlgorithmId] ASC
374)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
375) ON [PRIMARY] TEXTIMAGE_ON [DATA]
376GO
377SET ANSI_PADDING OFF
378GO
379/****** Object:  Table [dbo].[Algorithm_Result]    Script Date: 03/09/2010 16:21:40 ******/
380SET ANSI_NULLS ON
381GO
382SET QUOTED_IDENTIFIER ON
383GO
384CREATE TABLE [dbo].[Algorithm_Result](
385  [AlgorithmId] [int] NOT NULL,
386  [ResultId] [int] NOT NULL,
387PRIMARY KEY CLUSTERED
388(
389  [AlgorithmId] ASC,
390  [ResultId] ASC
391)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
392) ON [PRIMARY]
393GO
394/****** Object:  Table [dbo].[Algorithm_Parameter]    Script Date: 03/09/2010 16:21:40 ******/
395SET ANSI_NULLS ON
396GO
397SET QUOTED_IDENTIFIER ON
398GO
399CREATE TABLE [dbo].[Algorithm_Parameter](
400  [AlgorithmId] [int] NOT NULL,
401  [ParameterId] [int] NOT NULL,
402PRIMARY KEY CLUSTERED
403(
404  [AlgorithmId] ASC,
405  [ParameterId] ASC
406)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
407) ON [PRIMARY]
408GO
409/****** Object:  Table [dbo].[Experiment]    Script Date: 03/09/2010 16:21:40 ******/
410SET ANSI_NULLS ON
411GO
412SET QUOTED_IDENTIFIER ON
413GO
414CREATE TABLE [dbo].[Experiment](
415  [Id] [int] IDENTITY(1,1) NOT NULL,
416  [ProjectId] [int] NOT NULL,
417  [AlgorithmId] [int] NOT NULL,
418  [ProblemId] [int] NOT NULL,
419PRIMARY KEY CLUSTERED
420(
421  [Id] ASC
422)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
423) ON [PRIMARY]
424GO
425CREATE NONCLUSTERED INDEX [FullExperimentIndex] ON [dbo].[Experiment]
426(
427  [ProjectId] ASC,
428  [AlgorithmId] ASC,
429  [ProblemId] ASC
430)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]
431GO
432CREATE NONCLUSTERED INDEX [SimpleExperiementIndex] ON [dbo].[Experiment]
433(
434  [AlgorithmId] ASC,
435  [ProblemId] ASC
436)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]
437GO
438/****** Object:  Table [dbo].[CharProblemCharacteristicValue]    Script Date: 03/09/2010 16:21:40 ******/
439SET ANSI_NULLS ON
440GO
441SET QUOTED_IDENTIFIER ON
442GO
443SET ANSI_PADDING ON
444GO
445CREATE TABLE [dbo].[CharProblemCharacteristicValue](
446  [ProblemCharacteristicId] [int] NOT NULL,
447  [ProblemId] [int] NOT NULL,
448  [Value] [varchar](max) NOT NULL,
449PRIMARY KEY CLUSTERED
450(
451  [ProblemCharacteristicId] ASC,
452  [ProblemId] ASC
453)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
454) ON [PRIMARY]
455GO
456SET ANSI_PADDING OFF
457GO
458/****** Object:  Table [dbo].[FloatProblemCharacteristicValue]    Script Date: 03/09/2010 16:21:40 ******/
459SET ANSI_NULLS ON
460GO
461SET QUOTED_IDENTIFIER ON
462GO
463CREATE TABLE [dbo].[FloatProblemCharacteristicValue](
464  [ProblemCharacteristicId] [int] NOT NULL,
465  [ProblemId] [int] NOT NULL,
466  [Value] [float] NOT NULL,
467PRIMARY KEY CLUSTERED
468(
469  [ProblemCharacteristicId] ASC,
470  [ProblemId] ASC
471)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
472) ON [PRIMARY]
473GO
474/****** Object:  Table [dbo].[FloatParameterValue]    Script Date: 03/09/2010 16:21:40 ******/
475SET ANSI_NULLS ON
476GO
477SET QUOTED_IDENTIFIER ON
478GO
479CREATE TABLE [dbo].[FloatParameterValue](
480  [ParameterId] [int] NOT NULL,
481  [ExperimentId] [int] NOT NULL,
482  [Value] [float] NOT NULL,
483PRIMARY KEY CLUSTERED
484(
485  [ParameterId] ASC,
486  [ExperimentId] ASC
487)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
488) ON [PRIMARY]
489GO
490/****** Object:  Table [dbo].[ExperimentCreator]    Script Date: 03/09/2010 16:21:40 ******/
491SET ANSI_NULLS ON
492GO
493SET QUOTED_IDENTIFIER ON
494GO
495CREATE TABLE [dbo].[ExperimentCreator](
496  [ExperimentId] [int] NOT NULL,
497  [UserId] [uniqueidentifier] NOT NULL,
498PRIMARY KEY CLUSTERED
499(
500  [ExperimentId] ASC,
501  [UserId] ASC
502)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
503) ON [PRIMARY]
504GO
505/****** Object:  Table [dbo].[CharParameterValue]    Script Date: 03/09/2010 16:21:40 ******/
506SET ANSI_NULLS ON
507GO
508SET QUOTED_IDENTIFIER ON
509GO
510SET ANSI_PADDING ON
511GO
512CREATE TABLE [dbo].[CharParameterValue](
513  [ParameterId] [int] NOT NULL,
514  [ExperimentId] [int] NOT NULL,
515  [Value] [varchar](max) NOT NULL,
516PRIMARY KEY CLUSTERED
517(
518  [ParameterId] ASC,
519  [ExperimentId] ASC
520)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
521) ON [PRIMARY]
522GO
523SET ANSI_PADDING OFF
524GO
525/****** Object:  Table [dbo].[OperatorParameterValue]    Script Date: 03/09/2010 16:21:40 ******/
526SET ANSI_NULLS ON
527GO
528SET QUOTED_IDENTIFIER ON
529GO
530SET ANSI_PADDING ON
531GO
532CREATE TABLE [dbo].[OperatorParameterValue](
533  [ParameterId] [int] NOT NULL,
534  [ExperimentId] [int] NOT NULL,
535  [Value] [varbinary](max) NOT NULL,
536  [DataTypeId] [int] NOT NULL,
537PRIMARY KEY CLUSTERED
538(
539  [ParameterId] ASC,
540  [ExperimentId] ASC
541)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
542) ON [PRIMARY] TEXTIMAGE_ON [DATA]
543GO
544SET ANSI_PADDING OFF
545GO
546/****** Object:  Table [dbo].[Run]    Script Date: 03/09/2010 16:21:40 ******/
547SET ANSI_NULLS ON
548GO
549SET QUOTED_IDENTIFIER ON
550GO
551CREATE TABLE [dbo].[Run](
552  [Id] [int] IDENTITY(1,1) NOT NULL,
553  [ExperimentId] [int] NOT NULL,
554  [FinishedDate] [datetime2](7) NULL,
555  [UserId] [uniqueidentifier] NOT NULL,
556  [ClientId] [uniqueidentifier] NOT NULL,
557PRIMARY KEY CLUSTERED
558(
559  [Id] ASC
560)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
561) ON [PRIMARY]
562GO
563CREATE NONCLUSTERED INDEX [Run_FullIndex] ON [dbo].[Run]
564(
565  [ExperimentId] ASC
566)
567INCLUDE ( [Id],
568[FinishedDate],
569[UserId],
570[ClientId]) 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]
571GO
572/****** Object:  Table [dbo].[IntParameterValue]    Script Date: 03/09/2010 16:21:40 ******/
573SET ANSI_NULLS ON
574GO
575SET QUOTED_IDENTIFIER ON
576GO
577CREATE TABLE [dbo].[IntParameterValue](
578  [ParameterId] [int] NOT NULL,
579  [ExperimentId] [int] NOT NULL,
580  [Value] [int] NOT NULL,
581PRIMARY KEY CLUSTERED
582(
583  [ParameterId] ASC,
584  [ExperimentId] ASC
585)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
586) ON [PRIMARY]
587GO
588/****** Object:  Table [dbo].[FloatResultValue]    Script Date: 03/09/2010 16:21:40 ******/
589SET ANSI_NULLS ON
590GO
591SET QUOTED_IDENTIFIER ON
592GO
593CREATE TABLE [dbo].[FloatResultValue](
594  [ResultId] [int] NOT NULL,
595  [RunId] [int] NOT NULL,
596  [Value] [float] NOT NULL,
597PRIMARY KEY CLUSTERED
598(
599  [ResultId] ASC,
600  [RunId] ASC
601)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
602) ON [PRIMARY]
603GO
604/****** Object:  Table [dbo].[IntResultValue]    Script Date: 03/09/2010 16:21:40 ******/
605SET ANSI_NULLS ON
606GO
607SET QUOTED_IDENTIFIER ON
608GO
609CREATE TABLE [dbo].[IntResultValue](
610  [ResultId] [int] NOT NULL,
611  [RunId] [int] NOT NULL,
612  [Value] [int] NOT NULL,
613PRIMARY KEY CLUSTERED
614(
615  [ResultId] ASC,
616  [RunId] ASC
617)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
618) ON [PRIMARY]
619GO
620/****** Object:  Table [dbo].[BlobResultValue]    Script Date: 03/09/2010 16:21:40 ******/
621SET ANSI_NULLS ON
622GO
623SET QUOTED_IDENTIFIER ON
624GO
625SET ANSI_PADDING ON
626GO
627CREATE TABLE [dbo].[BlobResultValue](
628  [ResultId] [int] NOT NULL,
629  [RunId] [int] NOT NULL,
630  [Value] [varbinary](max) NOT NULL,
631PRIMARY KEY CLUSTERED
632(
633  [ResultId] ASC,
634  [RunId] ASC
635)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
636) ON [PRIMARY]
637GO
638SET ANSI_PADDING OFF
639GO
640/****** Object:  Table [dbo].[CharResultValue]    Script Date: 03/09/2010 16:21:40 ******/
641SET ANSI_NULLS ON
642GO
643SET QUOTED_IDENTIFIER ON
644GO
645SET ANSI_PADDING ON
646GO
647CREATE TABLE [dbo].[CharResultValue](
648  [ResultId] [int] NOT NULL,
649  [RunId] [int] NOT NULL,
650  [Value] [varchar](max) NOT NULL,
651PRIMARY KEY CLUSTERED
652(
653  [ResultId] ASC,
654  [RunId] ASC
655)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
656) ON [PRIMARY]
657GO
658SET ANSI_PADDING OFF
659GO
660/****** Object:  Check [CK__DataType__014935CB]    Script Date: 03/09/2010 16:21:40 ******/
661ALTER TABLE [dbo].[DataType]  WITH CHECK ADD  CONSTRAINT [CK__DataType__014935CB] CHECK  (([SqlName]='Int' AND [ClrName]='System.Int32' OR [SqlName]='Float' AND [ClrName]='System.Double' OR [SqlName]='Char' AND [ClrName]='System.String' OR [SqlName]='Bit' AND [ClrName]='System.Boolean' OR [SqlName]='BLOB' AND NOT ([ClrName]='System.String' OR [ClrName]='System.Double' OR [ClrName]='System.Int32' OR [ClrName]='System.Boolean')))
662GO
663ALTER TABLE [dbo].[DataType] CHECK CONSTRAINT [CK__DataType__014935CB]
664GO
665/****** Object:  ForeignKey [FK__Algorithm__Algor__164452B1]    Script Date: 03/09/2010 16:21:40 ******/
666ALTER TABLE [dbo].[Algorithm]  WITH CHECK ADD FOREIGN KEY([AlgorithmClassId])
667REFERENCES [dbo].[AlgorithmClass] ([Id])
668GO
669/****** Object:  ForeignKey [FK__Algorithm__Platf__173876EA]    Script Date: 03/09/2010 16:21:40 ******/
670ALTER TABLE [dbo].[Algorithm]  WITH CHECK ADD FOREIGN KEY([PlatformId])
671REFERENCES [dbo].[Platform] ([Id])
672GO
673/****** Object:  ForeignKey [FK__Algorithm__Algor__7B5B524B]    Script Date: 03/09/2010 16:21:40 ******/
674ALTER TABLE [dbo].[Algorithm_Parameter]  WITH CHECK ADD FOREIGN KEY([AlgorithmId])
675REFERENCES [dbo].[Algorithm] ([Id])
676GO
677/****** Object:  ForeignKey [FK__Algorithm__Param__7C4F7684]    Script Date: 03/09/2010 16:21:40 ******/
678ALTER TABLE [dbo].[Algorithm_Parameter]  WITH CHECK ADD FOREIGN KEY([ParameterId])
679REFERENCES [dbo].[Parameter] ([Id])
680ON UPDATE CASCADE
681ON DELETE CASCADE
682GO
683/****** Object:  ForeignKey [FK__Algorithm__Algor__25518C17]    Script Date: 03/09/2010 16:21:40 ******/
684ALTER TABLE [dbo].[Algorithm_Result]  WITH CHECK ADD FOREIGN KEY([AlgorithmId])
685REFERENCES [dbo].[Algorithm] ([Id])
686GO
687/****** Object:  ForeignKey [FK__Algorithm__Resul__2645B050]    Script Date: 03/09/2010 16:21:40 ******/
688ALTER TABLE [dbo].[Algorithm_Result]  WITH CHECK ADD FOREIGN KEY([ResultId])
689REFERENCES [dbo].[Result] ([Id])
690ON UPDATE CASCADE
691ON DELETE CASCADE
692GO
693/****** Object:  ForeignKey [FK__Algorithm__Algor__1BFD2C07]    Script Date: 03/09/2010 16:21:40 ******/
694ALTER TABLE [dbo].[AlgorithmData]  WITH CHECK ADD FOREIGN KEY([AlgorithmId])
695REFERENCES [dbo].[Algorithm] ([Id])
696ON UPDATE CASCADE
697ON DELETE CASCADE
698GO
699/****** Object:  ForeignKey [FK__BlobResul__Resul__1F98B2C1]    Script Date: 03/09/2010 16:21:40 ******/
700ALTER TABLE [dbo].[BlobResultValue]  WITH CHECK ADD FOREIGN KEY([ResultId])
701REFERENCES [dbo].[Result] ([Id])
702GO
703/****** Object:  ForeignKey [FK__BlobResul__RunId__208CD6FA]    Script Date: 03/09/2010 16:21:40 ******/
704ALTER TABLE [dbo].[BlobResultValue]  WITH CHECK ADD FOREIGN KEY([RunId])
705REFERENCES [dbo].[Run] ([Id])
706ON UPDATE CASCADE
707ON DELETE CASCADE
708GO
709/****** Object:  ForeignKey [FK__CharParam__Exper__76969D2E]    Script Date: 03/09/2010 16:21:40 ******/
710ALTER TABLE [dbo].[CharParameterValue]  WITH CHECK ADD FOREIGN KEY([ExperimentId])
711REFERENCES [dbo].[Experiment] ([Id])
712ON UPDATE CASCADE
713ON DELETE CASCADE
714GO
715/****** Object:  ForeignKey [FK__CharParam__Param__75A278F5]    Script Date: 03/09/2010 16:21:40 ******/
716ALTER TABLE [dbo].[CharParameterValue]  WITH CHECK ADD FOREIGN KEY([ParameterId])
717REFERENCES [dbo].[Parameter] ([Id])
718GO
719/****** Object:  ForeignKey [FK__CharProbl__Probl__3E1D39E1]    Script Date: 03/09/2010 16:21:40 ******/
720ALTER TABLE [dbo].[CharProblemCharacteristicValue]  WITH CHECK ADD FOREIGN KEY([ProblemCharacteristicId])
721REFERENCES [dbo].[ProblemCharacteristic] ([Id])
722GO
723/****** Object:  ForeignKey [FK__CharProbl__Probl__3F115E1A]    Script Date: 03/09/2010 16:21:40 ******/
724ALTER TABLE [dbo].[CharProblemCharacteristicValue]  WITH CHECK ADD FOREIGN KEY([ProblemId])
725REFERENCES [dbo].[Problem] ([Id])
726ON UPDATE CASCADE
727ON DELETE CASCADE
728GO
729/****** Object:  ForeignKey [FK__CharResul__Resul__19DFD96B]    Script Date: 03/09/2010 16:21:40 ******/
730ALTER TABLE [dbo].[CharResultValue]  WITH CHECK ADD FOREIGN KEY([ResultId])
731REFERENCES [dbo].[Result] ([Id])
732GO
733/****** Object:  ForeignKey [FK__CharResul__RunId__1AD3FDA4]    Script Date: 03/09/2010 16:21:40 ******/
734ALTER TABLE [dbo].[CharResultValue]  WITH CHECK ADD FOREIGN KEY([RunId])
735REFERENCES [dbo].[Run] ([Id])
736ON UPDATE CASCADE
737ON DELETE CASCADE
738GO
739/****** Object:  ForeignKey [FK__Experimen__Algor__5070F446]    Script Date: 03/09/2010 16:21:40 ******/
740ALTER TABLE [dbo].[Experiment]  WITH CHECK ADD FOREIGN KEY([AlgorithmId])
741REFERENCES [dbo].[Algorithm] ([Id])
742ON UPDATE CASCADE
743ON DELETE CASCADE
744GO
745/****** Object:  ForeignKey [FK__Experimen__Probl__5165187F]    Script Date: 03/09/2010 16:21:40 ******/
746ALTER TABLE [dbo].[Experiment]  WITH CHECK ADD FOREIGN KEY([ProblemId])
747REFERENCES [dbo].[Problem] ([Id])
748ON UPDATE CASCADE
749ON DELETE CASCADE
750GO
751/****** Object:  ForeignKey [FK__Experimen__Proje__4F7CD00D]    Script Date: 03/09/2010 16:21:40 ******/
752ALTER TABLE [dbo].[Experiment]  WITH CHECK ADD FOREIGN KEY([ProjectId])
753REFERENCES [dbo].[Project] ([Id])
754ON UPDATE CASCADE
755ON DELETE CASCADE
756GO
757/****** Object:  ForeignKey [FK__Experimen__Exper__5629CD9C]    Script Date: 03/09/2010 16:21:40 ******/
758ALTER TABLE [dbo].[ExperimentCreator]  WITH CHECK ADD FOREIGN KEY([ExperimentId])
759REFERENCES [dbo].[Experiment] ([Id])
760ON UPDATE CASCADE
761ON DELETE CASCADE
762GO
763/****** Object:  ForeignKey [FK__Experimen__UserI__571DF1D5]    Script Date: 03/09/2010 16:21:40 ******/
764ALTER TABLE [dbo].[ExperimentCreator]  WITH CHECK ADD FOREIGN KEY([UserId])
765REFERENCES [dbo].[User] ([Id])
766GO
767/****** Object:  ForeignKey [FK__FloatPara__Exper__70DDC3D8]    Script Date: 03/09/2010 16:21:40 ******/
768ALTER TABLE [dbo].[FloatParameterValue]  WITH CHECK ADD FOREIGN KEY([ExperimentId])
769REFERENCES [dbo].[Experiment] ([Id])
770ON UPDATE CASCADE
771ON DELETE CASCADE
772GO
773/****** Object:  ForeignKey [FK__FloatPara__Param__6FE99F9F]    Script Date: 03/09/2010 16:21:40 ******/
774ALTER TABLE [dbo].[FloatParameterValue]  WITH CHECK ADD FOREIGN KEY([ParameterId])
775REFERENCES [dbo].[Parameter] ([Id])
776GO
777/****** Object:  ForeignKey [FK__FloatProb__Probl__3864608B]    Script Date: 03/09/2010 16:21:40 ******/
778ALTER TABLE [dbo].[FloatProblemCharacteristicValue]  WITH CHECK ADD FOREIGN KEY([ProblemCharacteristicId])
779REFERENCES [dbo].[ProblemCharacteristic] ([Id])
780GO
781/****** Object:  ForeignKey [FK__FloatProb__Probl__395884C4]    Script Date: 03/09/2010 16:21:40 ******/
782ALTER TABLE [dbo].[FloatProblemCharacteristicValue]  WITH CHECK ADD FOREIGN KEY([ProblemId])
783REFERENCES [dbo].[Problem] ([Id])
784ON UPDATE CASCADE
785ON DELETE CASCADE
786GO
787/****** Object:  ForeignKey [FK__FloatResu__Resul__14270015]    Script Date: 03/09/2010 16:21:40 ******/
788ALTER TABLE [dbo].[FloatResultValue]  WITH CHECK ADD FOREIGN KEY([ResultId])
789REFERENCES [dbo].[Result] ([Id])
790GO
791/****** Object:  ForeignKey [FK__FloatResu__RunId__151B244E]    Script Date: 03/09/2010 16:21:40 ******/
792ALTER TABLE [dbo].[FloatResultValue]  WITH CHECK ADD FOREIGN KEY([RunId])
793REFERENCES [dbo].[Run] ([Id])
794ON UPDATE CASCADE
795ON DELETE CASCADE
796GO
797/****** Object:  ForeignKey [FK__IntParame__Exper__6B24EA82]    Script Date: 03/09/2010 16:21:40 ******/
798ALTER TABLE [dbo].[IntParameterValue]  WITH CHECK ADD FOREIGN KEY([ExperimentId])
799REFERENCES [dbo].[Experiment] ([Id])
800ON UPDATE CASCADE
801ON DELETE CASCADE
802GO
803/****** Object:  ForeignKey [FK__IntParame__Param__6A30C649]    Script Date: 03/09/2010 16:21:40 ******/
804ALTER TABLE [dbo].[IntParameterValue]  WITH CHECK ADD FOREIGN KEY([ParameterId])
805REFERENCES [dbo].[Parameter] ([Id])
806GO
807/****** Object:  ForeignKey [FK__IntProble__Probl__32AB8735]    Script Date: 03/09/2010 16:21:40 ******/
808ALTER TABLE [dbo].[IntProblemCharacteristicValue]  WITH CHECK ADD FOREIGN KEY([ProblemCharacteristicId])
809REFERENCES [dbo].[ProblemCharacteristic] ([Id])
810GO
811/****** Object:  ForeignKey [FK__IntProble__Probl__339FAB6E]    Script Date: 03/09/2010 16:21:40 ******/
812ALTER TABLE [dbo].[IntProblemCharacteristicValue]  WITH CHECK ADD FOREIGN KEY([ProblemId])
813REFERENCES [dbo].[Problem] ([Id])
814ON UPDATE CASCADE
815ON DELETE CASCADE
816GO
817/****** Object:  ForeignKey [FK__IntResult__Resul__0E6E26BF]    Script Date: 03/09/2010 16:21:40 ******/
818ALTER TABLE [dbo].[IntResultValue]  WITH CHECK ADD FOREIGN KEY([ResultId])
819REFERENCES [dbo].[Result] ([Id])
820GO
821/****** Object:  ForeignKey [FK__IntResult__RunId__0F624AF8]    Script Date: 03/09/2010 16:21:40 ******/
822ALTER TABLE [dbo].[IntResultValue]  WITH CHECK ADD FOREIGN KEY([RunId])
823REFERENCES [dbo].[Run] ([Id])
824ON UPDATE CASCADE
825ON DELETE CASCADE
826GO
827/****** Object:  ForeignKey [FK__OperatorP__DataT__02C769E9]    Script Date: 03/09/2010 16:21:40 ******/
828ALTER TABLE [dbo].[OperatorParameterValue]  WITH CHECK ADD FOREIGN KEY([DataTypeId])
829REFERENCES [dbo].[DataType] ([Id])
830GO
831/****** Object:  ForeignKey [FK__OperatorP__Exper__01D345B0]    Script Date: 03/09/2010 16:21:40 ******/
832ALTER TABLE [dbo].[OperatorParameterValue]  WITH CHECK ADD FOREIGN KEY([ExperimentId])
833REFERENCES [dbo].[Experiment] ([Id])
834ON UPDATE CASCADE
835ON DELETE CASCADE
836GO
837/****** Object:  ForeignKey [FK__OperatorP__Param__00DF2177]    Script Date: 03/09/2010 16:21:40 ******/
838ALTER TABLE [dbo].[OperatorParameterValue]  WITH CHECK ADD FOREIGN KEY([ParameterId])
839REFERENCES [dbo].[Parameter] ([Id])
840GO
841/****** Object:  ForeignKey [FK__Parameter__DataT__656C112C]    Script Date: 03/09/2010 16:21:40 ******/
842ALTER TABLE [dbo].[Parameter]  WITH CHECK ADD FOREIGN KEY([DataTypeId])
843REFERENCES [dbo].[DataType] ([Id])
844ON UPDATE CASCADE
845ON DELETE CASCADE
846GO
847/****** Object:  ForeignKey [FK__Problem__Platfor__31EC6D26]    Script Date: 03/09/2010 16:21:40 ******/
848ALTER TABLE [dbo].[Problem]  WITH CHECK ADD FOREIGN KEY([PlatformId])
849REFERENCES [dbo].[Platform] ([Id])
850GO
851/****** Object:  ForeignKey [FK__Problem__Problem__30F848ED]    Script Date: 03/09/2010 16:21:40 ******/
852ALTER TABLE [dbo].[Problem]  WITH CHECK ADD FOREIGN KEY([ProblemClassId])
853REFERENCES [dbo].[ProblemClass] ([Id])
854GO
855/****** Object:  ForeignKey [FK__Problem__Solutio__32E0915F]    Script Date: 03/09/2010 16:21:40 ******/
856ALTER TABLE [dbo].[Problem]  WITH CHECK ADD FOREIGN KEY([SolutionRepresentationid])
857REFERENCES [dbo].[SolutionRepresentation] ([Id])
858GO
859/****** Object:  ForeignKey [FK__Problem_P__Param__02084FDA]    Script Date: 03/09/2010 16:21:40 ******/
860ALTER TABLE [dbo].[Problem_Parameter]  WITH CHECK ADD FOREIGN KEY([ParameterId])
861REFERENCES [dbo].[Parameter] ([Id])
862ON UPDATE CASCADE
863ON DELETE CASCADE
864GO
865/****** Object:  ForeignKey [FK__Problem_P__Probl__01142BA1]    Script Date: 03/09/2010 16:21:40 ******/
866ALTER TABLE [dbo].[Problem_Parameter]  WITH CHECK ADD FOREIGN KEY([ProblemId])
867REFERENCES [dbo].[Problem] ([Id])
868GO
869/****** Object:  ForeignKey [FK__ProblemCh__DataT__2DE6D218]    Script Date: 03/09/2010 16:21:40 ******/
870ALTER TABLE [dbo].[ProblemCharacteristic]  WITH CHECK ADD FOREIGN KEY([DataTypeId])
871REFERENCES [dbo].[DataType] ([Id])
872ON UPDATE CASCADE
873ON DELETE CASCADE
874GO
875/****** Object:  ForeignKey [FK__ProblemDa__Probl__37A5467C]    Script Date: 03/09/2010 16:21:40 ******/
876ALTER TABLE [dbo].[ProblemData]  WITH CHECK ADD FOREIGN KEY([ProblemId])
877REFERENCES [dbo].[Problem] ([Id])
878ON UPDATE CASCADE
879ON DELETE CASCADE
880GO
881/****** Object:  ForeignKey [FK__Result__DataType__09A971A2]    Script Date: 03/09/2010 16:21:40 ******/
882ALTER TABLE [dbo].[Result]  WITH CHECK ADD FOREIGN KEY([DataTypeId])
883REFERENCES [dbo].[DataType] ([Id])
884ON UPDATE CASCADE
885ON DELETE CASCADE
886GO
887/****** Object:  ForeignKey [FK__Run__ClientId__5DCAEF64]    Script Date: 03/09/2010 16:21:40 ******/
888ALTER TABLE [dbo].[Run]  WITH CHECK ADD FOREIGN KEY([ClientId])
889REFERENCES [dbo].[Client] ([Id])
890GO
891/****** Object:  ForeignKey [FK__Run__ExperimentI__5BE2A6F2]    Script Date: 03/09/2010 16:21:40 ******/
892ALTER TABLE [dbo].[Run]  WITH CHECK ADD FOREIGN KEY([ExperimentId])
893REFERENCES [dbo].[Experiment] ([Id])
894ON UPDATE CASCADE
895ON DELETE CASCADE
896GO
897/****** Object:  ForeignKey [FK__Run__UserId__5CD6CB2B]    Script Date: 03/09/2010 16:21:40 ******/
898ALTER TABLE [dbo].[Run]  WITH CHECK ADD FOREIGN KEY([UserId])
899REFERENCES [dbo].[User] ([Id])
900GO
Note: See TracBrowser for help on using the repository browser.