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

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

Worked on OKB user authentication (#1167)

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