Context Navigation

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

Visit:

Last change on this file since 4321 was 4321, checked in by swagner, 14 years ago
Worked on OKB user authentication (#1167)
Property svn:mime-type set to `application/octet-stream`
File size: 62.6 KB

Line
1	USE [HeuristicLab.OKB]
2	GO
3	/**** Object: Table [dbo].[User] Script Date: 03/09/2010 16:21:40 ****/
4	SET ANSI_NULLS ON
5	GO
6	SET QUOTED_IDENTIFIER ON
7	GO
8	SET ANSI_PADDING ON
9	GO
10	CREATE TABLE [dbo].[User](
11	[Id] [uniqueidentifier] NOT NULL DEFAULT NEWID(),
12	[Name] [varchar](200) NOT NULL,
13	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]
18	GO
19	SET ANSI_PADDING OFF
20	GO
21	/**** Object: Table [dbo].[SolutionRepresentation] Script Date: 03/09/2010 16:21:40 ****/
22	SET ANSI_NULLS ON
23	GO
24	SET QUOTED_IDENTIFIER ON
25	GO
26	SET ANSI_PADDING ON
27	GO
28	CREATE TABLE [dbo].[SolutionRepresentation](
29	[Id] [int] IDENTITY(1,1) NOT NULL,
30	[Name] [varchar](200) NOT NULL,
31	[Description] [varchar](max) NULL,
32	PRIMARY 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],
36	UNIQUE 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]
41	GO
42	SET ANSI_PADDING OFF
43	GO
44	/**** Object: Table [dbo].[ProblemClass] Script Date: 03/09/2010 16:21:40 ****/
45	SET ANSI_NULLS ON
46	GO
47	SET QUOTED_IDENTIFIER ON
48	GO
49	SET ANSI_PADDING ON
50	GO
51	CREATE TABLE [dbo].[ProblemClass](
52	[Id] [int] IDENTITY(1,1) NOT NULL,
53	[Name] [varchar](200) NOT NULL,
54	[Description] [varchar](100) NULL,
55	PRIMARY 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],
59	UNIQUE 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]
64	GO
65	SET ANSI_PADDING OFF
66	GO
67	/**** Object: Table [dbo].[Project] Script Date: 03/09/2010 16:21:40 ****/
68	SET ANSI_NULLS ON
69	GO
70	SET QUOTED_IDENTIFIER ON
71	GO
72	SET ANSI_PADDING ON
73	GO
74	CREATE TABLE [dbo].[Project](
75	[Id] [int] IDENTITY(1,1) NOT NULL,
76	[Name] [varchar](200) NOT NULL,
77	[Description] [varchar](max) NULL,
78	PRIMARY 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]
83	GO
84	SET ANSI_PADDING OFF
85	GO
86	/**** Object: Table [dbo].[DataType] Script Date: 03/09/2010 16:21:40 ****/
87	SET ANSI_NULLS ON
88	GO
89	SET QUOTED_IDENTIFIER ON
90	GO
91	SET ANSI_PADDING ON
92	GO
93	CREATE TABLE [dbo].[DataType](
94	[Id] [int] IDENTITY(1,1) NOT NULL,
95	[SqlName] [varchar](200) NOT NULL,
96	[ClrName] [varchar](max) NOT NULL,
97	PRIMARY 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]
102	GO
103	SET ANSI_PADDING OFF
104	GO
105	SET IDENTITY_INSERT [dbo].[DataType] ON
106	INSERT [dbo].[DataType] ([Id], [SqlName], [ClrName]) VALUES (1, N'Int', N'System.Int32')
107	INSERT [dbo].[DataType] ([Id], [SqlName], [ClrName]) VALUES (2, N'Float', N'System.Double')
108	INSERT [dbo].[DataType] ([Id], [SqlName], [ClrName]) VALUES (3, N'Char', N'System.String')
109	INSERT [dbo].[DataType] ([Id], [SqlName], [ClrName]) VALUES (4, N'Blob', N'System.Object')
110	INSERT [dbo].[DataType] ([Id], [SqlName], [ClrName]) VALUES (5, N'BLOB', N'IOperator')
111	INSERT [dbo].[DataType] ([Id], [SqlName], [ClrName]) VALUES (6, N'Bit', N'System.Boolean')
112	SET IDENTITY_INSERT [dbo].[DataType] OFF
113	/**** Object: Table [dbo].[Client] Script Date: 03/09/2010 16:21:40 ****/
114	SET ANSI_NULLS ON
115	GO
116	SET QUOTED_IDENTIFIER ON
117	GO
118	SET ANSI_PADDING ON
119	GO
120	CREATE TABLE [dbo].[Client](
121	[Id] [uniqueidentifier] NOT NULL DEFAULT NEWID(),
122	[Name] [varchar](200) NOT NULL,
123	PRIMARY 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],
127	UNIQUE 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]
132	GO
133	SET ANSI_PADDING OFF
134	GO
135	/**** Object: Table [dbo].[AlgorithmClass] Script Date: 03/09/2010 16:21:40 ****/
136	SET ANSI_NULLS ON
137	GO
138	SET QUOTED_IDENTIFIER ON
139	GO
140	SET ANSI_PADDING ON
141	GO
142	CREATE TABLE [dbo].[AlgorithmClass](
143	[Id] [int] IDENTITY(1,1) NOT NULL,
144	[Name] [varchar](200) NOT NULL,
145	[Description] [varchar](max) NULL,
146	PRIMARY 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],
150	UNIQUE 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]
155	GO
156	SET ANSI_PADDING OFF
157	GO
158	/**** Object: Table [dbo].[Platform] Script Date: 03/09/2010 16:21:40 ****/
159	SET ANSI_NULLS ON
160	GO
161	SET QUOTED_IDENTIFIER ON
162	GO
163	SET ANSI_PADDING ON
164	GO
165	CREATE TABLE [dbo].[Platform](
166	[Id] [int] IDENTITY(1,1) NOT NULL,
167	[Name] [varchar](200) NOT NULL,
168	[Description] [varchar](max) NULL,
169	PRIMARY 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],
173	UNIQUE 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]
178	GO
179	SET ANSI_PADDING OFF
180	GO
181	SET IDENTITY_INSERT [dbo].[Platform] ON
182	INSERT [dbo].[Platform] ([Id], [Name], [Description]) VALUES (1, N'HL 2.5', N'HeuristicLab 2.5')
183	INSERT [dbo].[Platform] ([Id], [Name], [Description]) VALUES (2, N'HL 3.3', N'HeuristicLab 3.3')
184	SET IDENTITY_INSERT [dbo].[Platform] OFF
185	/**** Object: Table [dbo].[Parameter] Script Date: 03/09/2010 16:21:40 ****/
186	SET ANSI_NULLS ON
187	GO
188	SET QUOTED_IDENTIFIER ON
189	GO
190	SET ANSI_PADDING ON
191	GO
192	CREATE 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,
197	PRIMARY 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],
201	UNIQUE 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]
206	GO
207	SET ANSI_PADDING OFF
208	GO
209	/**** Object: Table [dbo].[Algorithm] Script Date: 03/09/2010 16:21:40 ****/
210	SET ANSI_NULLS ON
211	GO
212	SET QUOTED_IDENTIFIER ON
213	GO
214	SET ANSI_PADDING ON
215	GO
216	CREATE 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,
222	PRIMARY 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],
226	UNIQUE 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]
231	GO
232	SET ANSI_PADDING OFF
233	GO
234	/**** Object: Table [dbo].[Result] Script Date: 03/09/2010 16:21:40 ****/
235	SET ANSI_NULLS ON
236	GO
237	SET QUOTED_IDENTIFIER ON
238	GO
239	SET ANSI_PADDING ON
240	GO
241	CREATE 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,
246	PRIMARY 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],
250	UNIQUE 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]
255	GO
256	SET ANSI_PADDING OFF
257	GO
258	/**** Object: Table [dbo].[Problem] Script Date: 03/09/2010 16:21:40 ****/
259	SET ANSI_NULLS ON
260	GO
261	SET QUOTED_IDENTIFIER ON
262	GO
263	SET ANSI_PADDING ON
264	GO
265	CREATE 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,
272	PRIMARY 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],
276	UNIQUE 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]
281	GO
282	SET ANSI_PADDING OFF
283	GO
284	/**** Object: Table [dbo].[ProblemCharacteristic] Script Date: 03/09/2010 16:21:40 ****/
285	SET ANSI_NULLS ON
286	GO
287	SET QUOTED_IDENTIFIER ON
288	GO
289	SET ANSI_PADDING ON
290	GO
291	CREATE 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,
296	PRIMARY 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],
300	UNIQUE 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]
305	GO
306	SET ANSI_PADDING OFF
307	GO
308	/**** Object: Table [dbo].[Problem_Parameter] Script Date: 03/09/2010 16:21:40 ****/
309	SET ANSI_NULLS ON
310	GO
311	SET QUOTED_IDENTIFIER ON
312	GO
313	CREATE TABLE [dbo].[Problem_Parameter](
314	[ProblemId] [int] NOT NULL,
315	[ParameterId] [int] NOT NULL,
316	PRIMARY 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]
322	GO
323	/**** Object: Table [dbo].[ProblemData] Script Date: 03/09/2010 16:21:40 ****/
324	SET ANSI_NULLS ON
325	GO
326	SET QUOTED_IDENTIFIER ON
327	GO
328	SET ANSI_PADDING ON
329	GO
330	CREATE TABLE [dbo].[ProblemData](
331	[ProblemId] [int] NOT NULL,
332	[Data] [varbinary](max) NOT NULL,
333	PRIMARY 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]
338	GO
339	SET ANSI_PADDING OFF
340	GO
341	/**** Object: Table [dbo].[IntProblemCharacteristicValue] Script Date: 03/09/2010 16:21:40 ****/
342	SET ANSI_NULLS ON
343	GO
344	SET QUOTED_IDENTIFIER ON
345	GO
346	CREATE TABLE [dbo].[IntProblemCharacteristicValue](
347	[ProblemCharacteristicId] [int] NOT NULL,
348	[ProblemId] [int] NOT NULL,
349	[Value] [int] NOT NULL,
350	PRIMARY 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]
356	GO
357	/**** Object: Table [dbo].[AlgorithmData] Script Date: 03/09/2010 16:21:40 ****/
358	SET ANSI_NULLS ON
359	GO
360	SET QUOTED_IDENTIFIER ON
361	GO
362	SET ANSI_PADDING ON
363	GO
364	CREATE TABLE [dbo].[AlgorithmData](
365	[AlgorithmId] [int] NOT NULL,
366	[Data] [varbinary](max) NOT NULL,
367	PRIMARY 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]
372	GO
373	SET ANSI_PADDING OFF
374	GO
375	/**** Object: Table [dbo].[Algorithm_Result] Script Date: 03/09/2010 16:21:40 ****/
376	SET ANSI_NULLS ON
377	GO
378	SET QUOTED_IDENTIFIER ON
379	GO
380	CREATE TABLE [dbo].[Algorithm_Result](
381	[AlgorithmId] [int] NOT NULL,
382	[ResultId] [int] NOT NULL,
383	PRIMARY 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]
389	GO
390	/**** Object: Table [dbo].[Algorithm_Parameter] Script Date: 03/09/2010 16:21:40 ****/
391	SET ANSI_NULLS ON
392	GO
393	SET QUOTED_IDENTIFIER ON
394	GO
395	CREATE TABLE [dbo].[Algorithm_Parameter](
396	[AlgorithmId] [int] NOT NULL,
397	[ParameterId] [int] NOT NULL,
398	PRIMARY 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]
404	GO
405	/**** Object: Table [dbo].[Experiment] Script Date: 03/09/2010 16:21:40 ****/
406	SET ANSI_NULLS ON
407	GO
408	SET QUOTED_IDENTIFIER ON
409	GO
410	CREATE 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,
415	PRIMARY 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]
420	GO
421	CREATE 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]
427	GO
428	CREATE 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]
433	GO
434	/**** Object: Table [dbo].[CharProblemCharacteristicValue] Script Date: 03/09/2010 16:21:40 ****/
435	SET ANSI_NULLS ON
436	GO
437	SET QUOTED_IDENTIFIER ON
438	GO
439	SET ANSI_PADDING ON
440	GO
441	CREATE TABLE [dbo].[CharProblemCharacteristicValue](
442	[ProblemCharacteristicId] [int] NOT NULL,
443	[ProblemId] [int] NOT NULL,
444	[Value] [varchar](max) NOT NULL,
445	PRIMARY 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]
451	GO
452	SET ANSI_PADDING OFF
453	GO
454	/**** Object: Table [dbo].[FloatProblemCharacteristicValue] Script Date: 03/09/2010 16:21:40 ****/
455	SET ANSI_NULLS ON
456	GO
457	SET QUOTED_IDENTIFIER ON
458	GO
459	CREATE TABLE [dbo].[FloatProblemCharacteristicValue](
460	[ProblemCharacteristicId] [int] NOT NULL,
461	[ProblemId] [int] NOT NULL,
462	[Value] [float] NOT NULL,
463	PRIMARY 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]
469	GO
470	/**** Object: Table [dbo].[FloatParameterValue] Script Date: 03/09/2010 16:21:40 ****/
471	SET ANSI_NULLS ON
472	GO
473	SET QUOTED_IDENTIFIER ON
474	GO
475	CREATE TABLE [dbo].[FloatParameterValue](
476	[ParameterId] [int] NOT NULL,
477	[ExperimentId] [int] NOT NULL,
478	[Value] [float] NOT NULL,
479	PRIMARY 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]
485	GO
486	/**** Object: Table [dbo].[CharParameterValue] Script Date: 03/09/2010 16:21:40 ****/
487	SET ANSI_NULLS ON
488	GO
489	SET QUOTED_IDENTIFIER ON
490	GO
491	SET ANSI_PADDING ON
492	GO
493	CREATE TABLE [dbo].[CharParameterValue](
494	[ParameterId] [int] NOT NULL,
495	[ExperimentId] [int] NOT NULL,
496	[Value] [varchar](max) NOT NULL,
497	PRIMARY 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]
503	GO
504	SET ANSI_PADDING OFF
505	GO
506	/**** Object: Table [dbo].[OperatorParameterValue] Script Date: 03/09/2010 16:21:40 ****/
507	SET ANSI_NULLS ON
508	GO
509	SET QUOTED_IDENTIFIER ON
510	GO
511	SET ANSI_PADDING ON
512	GO
513	CREATE TABLE [dbo].[OperatorParameterValue](
514	[ParameterId] [int] NOT NULL,
515	[ExperimentId] [int] NOT NULL,
516	[Value] [varbinary](max) NOT NULL,
517	[DataTypeId] [int] NOT NULL,
518	PRIMARY 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]
524	GO
525	SET ANSI_PADDING OFF
526	GO
527	/**** Object: Table [dbo].[Run] Script Date: 03/09/2010 16:21:40 ****/
528	SET ANSI_NULLS ON
529	GO
530	SET QUOTED_IDENTIFIER ON
531	GO
532	CREATE 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,
538	PRIMARY 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]
543	GO
544	CREATE NONCLUSTERED INDEX [Run_FullIndex] ON [dbo].[Run]
545	(
546	[ExperimentId] ASC
547	)
548	INCLUDE ( [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]
552	GO
553	/**** Object: Table [dbo].[IntParameterValue] Script Date: 03/09/2010 16:21:40 ****/
554	SET ANSI_NULLS ON
555	GO
556	SET QUOTED_IDENTIFIER ON
557	GO
558	CREATE TABLE [dbo].[IntParameterValue](
559	[ParameterId] [int] NOT NULL,
560	[ExperimentId] [int] NOT NULL,
561	[Value] [int] NOT NULL,
562	PRIMARY 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]
568	GO
569	/**** Object: Table [dbo].[FloatResultValue] Script Date: 03/09/2010 16:21:40 ****/
570	SET ANSI_NULLS ON
571	GO
572	SET QUOTED_IDENTIFIER ON
573	GO
574	CREATE TABLE [dbo].[FloatResultValue](
575	[ResultId] [int] NOT NULL,
576	[RunId] [int] NOT NULL,
577	[Value] [float] NOT NULL,
578	PRIMARY 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]
584	GO
585	/**** Object: Table [dbo].[IntResultValue] Script Date: 03/09/2010 16:21:40 ****/
586	SET ANSI_NULLS ON
587	GO
588	SET QUOTED_IDENTIFIER ON
589	GO
590	CREATE TABLE [dbo].[IntResultValue](
591	[ResultId] [int] NOT NULL,
592	[RunId] [int] NOT NULL,
593	[Value] [int] NOT NULL,
594	PRIMARY 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]
600	GO
601	/**** Object: Table [dbo].[BlobResultValue] Script Date: 03/09/2010 16:21:40 ****/
602	SET ANSI_NULLS ON
603	GO
604	SET QUOTED_IDENTIFIER ON
605	GO
606	SET ANSI_PADDING ON
607	GO
608	CREATE TABLE [dbo].[BlobResultValue](
609	[ResultId] [int] NOT NULL,
610	[RunId] [int] NOT NULL,
611	[Value] [varbinary](max) NOT NULL,
612	PRIMARY 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]
618	GO
619	SET ANSI_PADDING OFF
620	GO
621	/**** Object: Table [dbo].[CharResultValue] Script Date: 03/09/2010 16:21:40 ****/
622	SET ANSI_NULLS ON
623	GO
624	SET QUOTED_IDENTIFIER ON
625	GO
626	SET ANSI_PADDING ON
627	GO
628	CREATE TABLE [dbo].[CharResultValue](
629	[ResultId] [int] NOT NULL,
630	[RunId] [int] NOT NULL,
631	[Value] [varchar](max) NOT NULL,
632	PRIMARY 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]
638	GO
639	SET ANSI_PADDING OFF
640	GO
641	/**** Object: Check [CK__DataType__014935CB] Script Date: 03/09/2010 16:21:40 ****/
642	ALTER 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')))
643	GO
644	ALTER TABLE [dbo].[DataType] CHECK CONSTRAINT [CK__DataType__014935CB]
645	GO
646	/**** Object: ForeignKey [FK__Algorithm__Algor__164452B1] Script Date: 03/09/2010 16:21:40 ****/
647	ALTER TABLE [dbo].[Algorithm] WITH CHECK ADD FOREIGN KEY([AlgorithmClassId])
648	REFERENCES [dbo].[AlgorithmClass] ([Id])
649	GO
650	/**** Object: ForeignKey [FK__Algorithm__Platf__173876EA] Script Date: 03/09/2010 16:21:40 ****/
651	ALTER TABLE [dbo].[Algorithm] WITH CHECK ADD FOREIGN KEY([PlatformId])
652	REFERENCES [dbo].[Platform] ([Id])
653	GO
654	/**** Object: ForeignKey [FK__Algorithm__Algor__7B5B524B] Script Date: 03/09/2010 16:21:40 ****/
655	ALTER TABLE [dbo].[Algorithm_Parameter] WITH CHECK ADD FOREIGN KEY([AlgorithmId])
656	REFERENCES [dbo].[Algorithm] ([Id])
657	GO
658	/**** Object: ForeignKey [FK__Algorithm__Param__7C4F7684] Script Date: 03/09/2010 16:21:40 ****/
659	ALTER TABLE [dbo].[Algorithm_Parameter] WITH CHECK ADD FOREIGN KEY([ParameterId])
660	REFERENCES [dbo].[Parameter] ([Id])
661	ON UPDATE CASCADE
662	ON DELETE CASCADE
663	GO
664	/**** Object: ForeignKey [FK__Algorithm__Algor__25518C17] Script Date: 03/09/2010 16:21:40 ****/
665	ALTER TABLE [dbo].[Algorithm_Result] WITH CHECK ADD FOREIGN KEY([AlgorithmId])
666	REFERENCES [dbo].[Algorithm] ([Id])
667	GO
668	/**** Object: ForeignKey [FK__Algorithm__Resul__2645B050] Script Date: 03/09/2010 16:21:40 ****/
669	ALTER TABLE [dbo].[Algorithm_Result] WITH CHECK ADD FOREIGN KEY([ResultId])
670	REFERENCES [dbo].[Result] ([Id])
671	ON UPDATE CASCADE
672	ON DELETE CASCADE
673	GO
674	/**** Object: ForeignKey [FK__Algorithm__Algor__1BFD2C07] Script Date: 03/09/2010 16:21:40 ****/
675	ALTER TABLE [dbo].[AlgorithmData] WITH CHECK ADD FOREIGN KEY([AlgorithmId])
676	REFERENCES [dbo].[Algorithm] ([Id])
677	ON UPDATE CASCADE
678	ON DELETE CASCADE
679	GO
680	/**** Object: ForeignKey [FK__BlobResul__Resul__1F98B2C1] Script Date: 03/09/2010 16:21:40 ****/
681	ALTER TABLE [dbo].[BlobResultValue] WITH CHECK ADD FOREIGN KEY([ResultId])
682	REFERENCES [dbo].[Result] ([Id])
683	GO
684	/**** Object: ForeignKey [FK__BlobResul__RunId__208CD6FA] Script Date: 03/09/2010 16:21:40 ****/
685	ALTER TABLE [dbo].[BlobResultValue] WITH CHECK ADD FOREIGN KEY([RunId])
686	REFERENCES [dbo].[Run] ([Id])
687	ON UPDATE CASCADE
688	ON DELETE CASCADE
689	GO
690	/**** Object: ForeignKey [FK__CharParam__Exper__76969D2E] Script Date: 03/09/2010 16:21:40 ****/
691	ALTER TABLE [dbo].[CharParameterValue] WITH CHECK ADD FOREIGN KEY([ExperimentId])
692	REFERENCES [dbo].[Experiment] ([Id])
693	ON UPDATE CASCADE
694	ON DELETE CASCADE
695	GO
696	/**** Object: ForeignKey [FK__CharParam__Param__75A278F5] Script Date: 03/09/2010 16:21:40 ****/
697	ALTER TABLE [dbo].[CharParameterValue] WITH CHECK ADD FOREIGN KEY([ParameterId])
698	REFERENCES [dbo].[Parameter] ([Id])
699	GO
700	/**** Object: ForeignKey [FK__CharProbl__Probl__3E1D39E1] Script Date: 03/09/2010 16:21:40 ****/
701	ALTER TABLE [dbo].[CharProblemCharacteristicValue] WITH CHECK ADD FOREIGN KEY([ProblemCharacteristicId])
702	REFERENCES [dbo].[ProblemCharacteristic] ([Id])
703	GO
704	/**** Object: ForeignKey [FK__CharProbl__Probl__3F115E1A] Script Date: 03/09/2010 16:21:40 ****/
705	ALTER TABLE [dbo].[CharProblemCharacteristicValue] WITH CHECK ADD FOREIGN KEY([ProblemId])
706	REFERENCES [dbo].[Problem] ([Id])
707	ON UPDATE CASCADE
708	ON DELETE CASCADE
709	GO
710	/**** Object: ForeignKey [FK__CharResul__Resul__19DFD96B] Script Date: 03/09/2010 16:21:40 ****/
711	ALTER TABLE [dbo].[CharResultValue] WITH CHECK ADD FOREIGN KEY([ResultId])
712	REFERENCES [dbo].[Result] ([Id])
713	GO
714	/**** Object: ForeignKey [FK__CharResul__RunId__1AD3FDA4] Script Date: 03/09/2010 16:21:40 ****/
715	ALTER TABLE [dbo].[CharResultValue] WITH CHECK ADD FOREIGN KEY([RunId])
716	REFERENCES [dbo].[Run] ([Id])
717	ON UPDATE CASCADE
718	ON DELETE CASCADE
719	GO
720	/**** Object: ForeignKey [FK__Experimen__Algor__5070F446] Script Date: 03/09/2010 16:21:40 ****/
721	ALTER TABLE [dbo].[Experiment] WITH CHECK ADD FOREIGN KEY([AlgorithmId])
722	REFERENCES [dbo].[Algorithm] ([Id])
723	ON UPDATE CASCADE
724	ON DELETE CASCADE
725	GO
726	/**** Object: ForeignKey [FK__Experimen__Probl__5165187F] Script Date: 03/09/2010 16:21:40 ****/
727	ALTER TABLE [dbo].[Experiment] WITH CHECK ADD FOREIGN KEY([ProblemId])
728	REFERENCES [dbo].[Problem] ([Id])
729	ON UPDATE CASCADE
730	ON DELETE CASCADE
731	GO
732	/**** Object: ForeignKey [FK__Experimen__Proje__4F7CD00D] Script Date: 03/09/2010 16:21:40 ****/
733	ALTER TABLE [dbo].[Experiment] WITH CHECK ADD FOREIGN KEY([ProjectId])
734	REFERENCES [dbo].[Project] ([Id])
735	ON UPDATE CASCADE
736	ON DELETE CASCADE
737	GO
738	/**** Object: ForeignKey [FK__FloatPara__Exper__70DDC3D8] Script Date: 03/09/2010 16:21:40 ****/
739	ALTER TABLE [dbo].[FloatParameterValue] WITH CHECK ADD FOREIGN KEY([ExperimentId])
740	REFERENCES [dbo].[Experiment] ([Id])
741	ON UPDATE CASCADE
742	ON DELETE CASCADE
743	GO
744	/**** Object: ForeignKey [FK__FloatPara__Param__6FE99F9F] Script Date: 03/09/2010 16:21:40 ****/
745	ALTER TABLE [dbo].[FloatParameterValue] WITH CHECK ADD FOREIGN KEY([ParameterId])
746	REFERENCES [dbo].[Parameter] ([Id])
747	GO
748	/**** Object: ForeignKey [FK__FloatProb__Probl__3864608B] Script Date: 03/09/2010 16:21:40 ****/
749	ALTER TABLE [dbo].[FloatProblemCharacteristicValue] WITH CHECK ADD FOREIGN KEY([ProblemCharacteristicId])
750	REFERENCES [dbo].[ProblemCharacteristic] ([Id])
751	GO
752	/**** Object: ForeignKey [FK__FloatProb__Probl__395884C4] Script Date: 03/09/2010 16:21:40 ****/
753	ALTER TABLE [dbo].[FloatProblemCharacteristicValue] WITH CHECK ADD FOREIGN KEY([ProblemId])
754	REFERENCES [dbo].[Problem] ([Id])
755	ON UPDATE CASCADE
756	ON DELETE CASCADE
757	GO
758	/**** Object: ForeignKey [FK__FloatResu__Resul__14270015] Script Date: 03/09/2010 16:21:40 ****/
759	ALTER TABLE [dbo].[FloatResultValue] WITH CHECK ADD FOREIGN KEY([ResultId])
760	REFERENCES [dbo].[Result] ([Id])
761	GO
762	/**** Object: ForeignKey [FK__FloatResu__RunId__151B244E] Script Date: 03/09/2010 16:21:40 ****/
763	ALTER TABLE [dbo].[FloatResultValue] WITH CHECK ADD FOREIGN KEY([RunId])
764	REFERENCES [dbo].[Run] ([Id])
765	ON UPDATE CASCADE
766	ON DELETE CASCADE
767	GO
768	/**** Object: ForeignKey [FK__IntParame__Exper__6B24EA82] Script Date: 03/09/2010 16:21:40 ****/
769	ALTER TABLE [dbo].[IntParameterValue] WITH CHECK ADD FOREIGN KEY([ExperimentId])
770	REFERENCES [dbo].[Experiment] ([Id])
771	ON UPDATE CASCADE
772	ON DELETE CASCADE
773	GO
774	/**** Object: ForeignKey [FK__IntParame__Param__6A30C649] Script Date: 03/09/2010 16:21:40 ****/
775	ALTER TABLE [dbo].[IntParameterValue] WITH CHECK ADD FOREIGN KEY([ParameterId])
776	REFERENCES [dbo].[Parameter] ([Id])
777	GO
778	/**** Object: ForeignKey [FK__IntProble__Probl__32AB8735] Script Date: 03/09/2010 16:21:40 ****/
779	ALTER TABLE [dbo].[IntProblemCharacteristicValue] WITH CHECK ADD FOREIGN KEY([ProblemCharacteristicId])
780	REFERENCES [dbo].[ProblemCharacteristic] ([Id])
781	GO
782	/**** Object: ForeignKey [FK__IntProble__Probl__339FAB6E] Script Date: 03/09/2010 16:21:40 ****/
783	ALTER TABLE [dbo].[IntProblemCharacteristicValue] WITH CHECK ADD FOREIGN KEY([ProblemId])
784	REFERENCES [dbo].[Problem] ([Id])
785	ON UPDATE CASCADE
786	ON DELETE CASCADE
787	GO
788	/**** Object: ForeignKey [FK__IntResult__Resul__0E6E26BF] Script Date: 03/09/2010 16:21:40 ****/
789	ALTER TABLE [dbo].[IntResultValue] WITH CHECK ADD FOREIGN KEY([ResultId])
790	REFERENCES [dbo].[Result] ([Id])
791	GO
792	/**** Object: ForeignKey [FK__IntResult__RunId__0F624AF8] Script Date: 03/09/2010 16:21:40 ****/
793	ALTER TABLE [dbo].[IntResultValue] WITH CHECK ADD FOREIGN KEY([RunId])
794	REFERENCES [dbo].[Run] ([Id])
795	ON UPDATE CASCADE
796	ON DELETE CASCADE
797	GO
798	/**** Object: ForeignKey [FK__OperatorP__DataT__02C769E9] Script Date: 03/09/2010 16:21:40 ****/
799	ALTER TABLE [dbo].[OperatorParameterValue] WITH CHECK ADD FOREIGN KEY([DataTypeId])
800	REFERENCES [dbo].[DataType] ([Id])
801	GO
802	/**** Object: ForeignKey [FK__OperatorP__Exper__01D345B0] Script Date: 03/09/2010 16:21:40 ****/
803	ALTER TABLE [dbo].[OperatorParameterValue] WITH CHECK ADD FOREIGN KEY([ExperimentId])
804	REFERENCES [dbo].[Experiment] ([Id])
805	ON UPDATE CASCADE
806	ON DELETE CASCADE
807	GO
808	/**** Object: ForeignKey [FK__OperatorP__Param__00DF2177] Script Date: 03/09/2010 16:21:40 ****/
809	ALTER TABLE [dbo].[OperatorParameterValue] WITH CHECK ADD FOREIGN KEY([ParameterId])
810	REFERENCES [dbo].[Parameter] ([Id])
811	GO
812	/**** Object: ForeignKey [FK__Parameter__DataT__656C112C] Script Date: 03/09/2010 16:21:40 ****/
813	ALTER TABLE [dbo].[Parameter] WITH CHECK ADD FOREIGN KEY([DataTypeId])
814	REFERENCES [dbo].[DataType] ([Id])
815	ON UPDATE CASCADE
816	ON DELETE CASCADE
817	GO
818	/**** Object: ForeignKey [FK__Problem__Platfor__31EC6D26] Script Date: 03/09/2010 16:21:40 ****/
819	ALTER TABLE [dbo].[Problem] WITH CHECK ADD FOREIGN KEY([PlatformId])
820	REFERENCES [dbo].[Platform] ([Id])
821	GO
822	/**** Object: ForeignKey [FK__Problem__Problem__30F848ED] Script Date: 03/09/2010 16:21:40 ****/
823	ALTER TABLE [dbo].[Problem] WITH CHECK ADD FOREIGN KEY([ProblemClassId])
824	REFERENCES [dbo].[ProblemClass] ([Id])
825	GO
826	/**** Object: ForeignKey [FK__Problem__Solutio__32E0915F] Script Date: 03/09/2010 16:21:40 ****/
827	ALTER TABLE [dbo].[Problem] WITH CHECK ADD FOREIGN KEY([SolutionRepresentationid])
828	REFERENCES [dbo].[SolutionRepresentation] ([Id])
829	GO
830	/**** Object: ForeignKey [FK__Problem_P__Param__02084FDA] Script Date: 03/09/2010 16:21:40 ****/
831	ALTER TABLE [dbo].[Problem_Parameter] WITH CHECK ADD FOREIGN KEY([ParameterId])
832	REFERENCES [dbo].[Parameter] ([Id])
833	ON UPDATE CASCADE
834	ON DELETE CASCADE
835	GO
836	/**** Object: ForeignKey [FK__Problem_P__Probl__01142BA1] Script Date: 03/09/2010 16:21:40 ****/
837	ALTER TABLE [dbo].[Problem_Parameter] WITH CHECK ADD FOREIGN KEY([ProblemId])
838	REFERENCES [dbo].[Problem] ([Id])
839	GO
840	/**** Object: ForeignKey [FK__ProblemCh__DataT__2DE6D218] Script Date: 03/09/2010 16:21:40 ****/
841	ALTER TABLE [dbo].[ProblemCharacteristic] WITH CHECK ADD FOREIGN KEY([DataTypeId])
842	REFERENCES [dbo].[DataType] ([Id])
843	ON UPDATE CASCADE
844	ON DELETE CASCADE
845	GO
846	/**** Object: ForeignKey [FK__ProblemDa__Probl__37A5467C] Script Date: 03/09/2010 16:21:40 ****/
847	ALTER TABLE [dbo].[ProblemData] WITH CHECK ADD FOREIGN KEY([ProblemId])
848	REFERENCES [dbo].[Problem] ([Id])
849	ON UPDATE CASCADE
850	ON DELETE CASCADE
851	GO
852	/**** Object: ForeignKey [FK__Result__DataType__09A971A2] Script Date: 03/09/2010 16:21:40 ****/
853	ALTER TABLE [dbo].[Result] WITH CHECK ADD FOREIGN KEY([DataTypeId])
854	REFERENCES [dbo].[DataType] ([Id])
855	ON UPDATE CASCADE
856	ON DELETE CASCADE
857	GO
858	/**** Object: ForeignKey [FK__Run__ClientId__5DCAEF64] Script Date: 03/09/2010 16:21:40 ****/
859	ALTER TABLE [dbo].[Run] WITH CHECK ADD FOREIGN KEY([ClientId])
860	REFERENCES [dbo].[Client] ([Id])
861	GO
862	/**** Object: ForeignKey [FK__Run__ExperimentI__5BE2A6F2] Script Date: 03/09/2010 16:21:40 ****/
863	ALTER TABLE [dbo].[Run] WITH CHECK ADD FOREIGN KEY([ExperimentId])
864	REFERENCES [dbo].[Experiment] ([Id])
865	ON UPDATE CASCADE
866	ON DELETE CASCADE
867	GO
868	/**** Object: ForeignKey [FK__Run__UserId__5CD6CB2B] Script Date: 03/09/2010 16:21:40 ****/
869	ALTER TABLE [dbo].[Run] WITH CHECK ADD FOREIGN KEY([UserId])
870	REFERENCES [dbo].[User] ([Id])
871	GO

Note: See TracBrowser for help on using the repository browser.

Download in other formats:

Update cookies preferences