1 | USE [HeuristicLab.OKB]
|
---|
2 | GO
|
---|
3 | /****** Object: Table [dbo].[AlgorithmClass] Script Date: 09/25/2010 01:33:11 ******/
|
---|
4 | SET ANSI_NULLS ON
|
---|
5 | GO
|
---|
6 | SET QUOTED_IDENTIFIER ON
|
---|
7 | GO
|
---|
8 | CREATE TABLE [dbo].[AlgorithmClass](
|
---|
9 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
10 | [Name] [nvarchar](200) NOT NULL,
|
---|
11 | [Description] [nvarchar](max) NULL,
|
---|
12 | CONSTRAINT [PK_AlgorithmClass_Id] PRIMARY KEY CLUSTERED
|
---|
13 | (
|
---|
14 | [Id] ASC
|
---|
15 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
|
---|
16 | CONSTRAINT [UQ_AlgorithmClass_Name] UNIQUE NONCLUSTERED
|
---|
17 | (
|
---|
18 | [Name] ASC
|
---|
19 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
20 | ) ON [PRIMARY]
|
---|
21 | GO
|
---|
22 | SET IDENTITY_INSERT [dbo].[AlgorithmClass] ON
|
---|
23 | INSERT [dbo].[AlgorithmClass] ([Id], [Name], [Description]) VALUES (1, N'Unknown', N'Unknown or undefined algorithm class.')
|
---|
24 | SET IDENTITY_INSERT [dbo].[AlgorithmClass] OFF
|
---|
25 | /****** Object: Table [dbo].[Platform] Script Date: 09/25/2010 01:33:11 ******/
|
---|
26 | SET ANSI_NULLS ON
|
---|
27 | GO
|
---|
28 | SET QUOTED_IDENTIFIER ON
|
---|
29 | GO
|
---|
30 | CREATE TABLE [dbo].[Platform](
|
---|
31 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
32 | [Name] [nvarchar](200) NOT NULL,
|
---|
33 | [Description] [nvarchar](max) NULL,
|
---|
34 | CONSTRAINT [PK_Platform_Id] PRIMARY KEY CLUSTERED
|
---|
35 | (
|
---|
36 | [Id] ASC
|
---|
37 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
|
---|
38 | CONSTRAINT [UQ_Platform_Name] UNIQUE NONCLUSTERED
|
---|
39 | (
|
---|
40 | [Name] ASC
|
---|
41 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
42 | ) ON [PRIMARY]
|
---|
43 | GO
|
---|
44 | SET IDENTITY_INSERT [dbo].[Platform] ON
|
---|
45 | INSERT [dbo].[Platform] ([Id], [Name], [Description]) VALUES (1, N'Unknown', N'Unknown or undefined platform.')
|
---|
46 | INSERT [dbo].[Platform] ([Id], [Name], [Description]) VALUES (2, N'HeuristicLab 3.3', NULL)
|
---|
47 | SET IDENTITY_INSERT [dbo].[Platform] OFF
|
---|
48 | /****** Object: Table [dbo].[ProblemClass] Script Date: 09/25/2010 01:33:11 ******/
|
---|
49 | SET ANSI_NULLS ON
|
---|
50 | GO
|
---|
51 | SET QUOTED_IDENTIFIER ON
|
---|
52 | GO
|
---|
53 | CREATE TABLE [dbo].[ProblemClass](
|
---|
54 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
55 | [Name] [nvarchar](200) NOT NULL,
|
---|
56 | [Description] [nvarchar](max) NULL,
|
---|
57 | CONSTRAINT [PK_ProblemClass_Id] PRIMARY KEY CLUSTERED
|
---|
58 | (
|
---|
59 | [Id] ASC
|
---|
60 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
|
---|
61 | CONSTRAINT [UQ_ProblemClass_Name] UNIQUE NONCLUSTERED
|
---|
62 | (
|
---|
63 | [Name] ASC
|
---|
64 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
65 | ) ON [PRIMARY]
|
---|
66 | GO
|
---|
67 | SET IDENTITY_INSERT [dbo].[ProblemClass] ON
|
---|
68 | INSERT [dbo].[ProblemClass] ([Id], [Name], [Description]) VALUES (1, N'Unknown', N'Unknown or undefined problem class.')
|
---|
69 | SET IDENTITY_INSERT [dbo].[ProblemClass] OFF
|
---|
70 | /****** Object: Table [dbo].[Problem] Script Date: 09/25/2010 01:33:11 ******/
|
---|
71 | SET ANSI_NULLS ON
|
---|
72 | GO
|
---|
73 | SET QUOTED_IDENTIFIER ON
|
---|
74 | GO
|
---|
75 | CREATE TABLE [dbo].[Problem](
|
---|
76 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
77 | [ProblemClassId] [bigint] NOT NULL,
|
---|
78 | [PlatformId] [bigint] NOT NULL,
|
---|
79 | [Name] [nvarchar](200) NOT NULL,
|
---|
80 | [Description] [nvarchar](max) NULL,
|
---|
81 | CONSTRAINT [PK_Problem_Id] PRIMARY KEY CLUSTERED
|
---|
82 | (
|
---|
83 | [Id] ASC
|
---|
84 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
|
---|
85 | CONSTRAINT [UQ_Problem_Name_PlattformId] UNIQUE NONCLUSTERED
|
---|
86 | (
|
---|
87 | [Name] ASC,
|
---|
88 | [PlatformId] ASC
|
---|
89 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
90 | ) ON [PRIMARY]
|
---|
91 | GO
|
---|
92 | /****** Object: Table [dbo].[DataType] Script Date: 09/25/2010 01:33:11 ******/
|
---|
93 | SET ANSI_NULLS ON
|
---|
94 | GO
|
---|
95 | SET QUOTED_IDENTIFIER ON
|
---|
96 | GO
|
---|
97 | CREATE TABLE [dbo].[DataType](
|
---|
98 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
99 | [PlatformId] [bigint] NOT NULL,
|
---|
100 | [Name] [nvarchar](max) NOT NULL,
|
---|
101 | [SqlName] [nvarchar](200) NOT NULL,
|
---|
102 | CONSTRAINT [PK_DataType_Id] PRIMARY KEY CLUSTERED
|
---|
103 | (
|
---|
104 | [Id] ASC
|
---|
105 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
106 | ) ON [PRIMARY]
|
---|
107 | GO
|
---|
108 | /****** Object: Table [dbo].[Algorithm] Script Date: 09/25/2010 01:33:11 ******/
|
---|
109 | SET ANSI_NULLS ON
|
---|
110 | GO
|
---|
111 | SET QUOTED_IDENTIFIER ON
|
---|
112 | GO
|
---|
113 | CREATE TABLE [dbo].[Algorithm](
|
---|
114 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
115 | [AlgorithmClassId] [bigint] NOT NULL,
|
---|
116 | [PlatformId] [bigint] NOT NULL,
|
---|
117 | [Name] [nvarchar](200) NOT NULL,
|
---|
118 | [Description] [nvarchar](max) NULL,
|
---|
119 | CONSTRAINT [PK_Algorithm_Id] PRIMARY KEY CLUSTERED
|
---|
120 | (
|
---|
121 | [Id] ASC
|
---|
122 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
|
---|
123 | CONSTRAINT [UQ_Algorithm_Name_PlattformId] UNIQUE NONCLUSTERED
|
---|
124 | (
|
---|
125 | [Name] ASC,
|
---|
126 | [PlatformId] ASC
|
---|
127 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
128 | ) ON [PRIMARY]
|
---|
129 | GO
|
---|
130 | /****** Object: Table [dbo].[ProblemParameter] Script Date: 09/25/2010 01:33:11 ******/
|
---|
131 | SET ANSI_NULLS ON
|
---|
132 | GO
|
---|
133 | SET QUOTED_IDENTIFIER ON
|
---|
134 | GO
|
---|
135 | CREATE TABLE [dbo].[ProblemParameter](
|
---|
136 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
137 | [ProblemId] [bigint] NOT NULL,
|
---|
138 | [Name] [nvarchar](200) NOT NULL,
|
---|
139 | [Alias] [nvarchar](200) NULL,
|
---|
140 | [Description] [nvarchar](max) NULL,
|
---|
141 | [DataTypeId] [bigint] NOT NULL,
|
---|
142 | CONSTRAINT [PK_ProblemParameter_Id] PRIMARY KEY CLUSTERED
|
---|
143 | (
|
---|
144 | [Id] ASC
|
---|
145 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
|
---|
146 | CONSTRAINT [UQ_ProblemParameter_Name_ProblemId] UNIQUE NONCLUSTERED
|
---|
147 | (
|
---|
148 | [Name] ASC,
|
---|
149 | [ProblemId] ASC
|
---|
150 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
151 | ) ON [PRIMARY]
|
---|
152 | GO
|
---|
153 | /****** Object: Table [dbo].[ProblemData] Script Date: 09/25/2010 01:33:11 ******/
|
---|
154 | SET ANSI_NULLS ON
|
---|
155 | GO
|
---|
156 | SET QUOTED_IDENTIFIER ON
|
---|
157 | GO
|
---|
158 | SET ANSI_PADDING ON
|
---|
159 | GO
|
---|
160 | CREATE TABLE [dbo].[ProblemData](
|
---|
161 | [ProblemId] [bigint] NOT NULL,
|
---|
162 | [DataTypeId] [bigint] NOT NULL,
|
---|
163 | [Data] [varbinary](max) NOT NULL,
|
---|
164 | CONSTRAINT [PK_ProblemData_ProblemId] PRIMARY KEY CLUSTERED
|
---|
165 | (
|
---|
166 | [ProblemId] ASC
|
---|
167 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
168 | ) ON [PRIMARY]
|
---|
169 | GO
|
---|
170 | SET ANSI_PADDING OFF
|
---|
171 | GO
|
---|
172 | /****** Object: Table [dbo].[AlgorithmUser] Script Date: 09/25/2010 01:33:11 ******/
|
---|
173 | SET ANSI_NULLS ON
|
---|
174 | GO
|
---|
175 | SET QUOTED_IDENTIFIER ON
|
---|
176 | GO
|
---|
177 | CREATE TABLE [dbo].[AlgorithmUser](
|
---|
178 | [AlgorithmId] [bigint] NOT NULL,
|
---|
179 | [UserId] [uniqueidentifier] NOT NULL,
|
---|
180 | CONSTRAINT [PK_AlgorithmUser_AlgorithmId_UserId] PRIMARY KEY CLUSTERED
|
---|
181 | (
|
---|
182 | [AlgorithmId] ASC,
|
---|
183 | [UserId] ASC
|
---|
184 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
185 | ) ON [PRIMARY]
|
---|
186 | GO
|
---|
187 | /****** Object: Table [dbo].[Experiment] Script Date: 09/25/2010 01:33:11 ******/
|
---|
188 | SET ANSI_NULLS ON
|
---|
189 | GO
|
---|
190 | SET QUOTED_IDENTIFIER ON
|
---|
191 | GO
|
---|
192 | CREATE TABLE [dbo].[Experiment](
|
---|
193 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
194 | [AlgorithmId] [bigint] NOT NULL,
|
---|
195 | [ProblemId] [bigint] NOT NULL,
|
---|
196 | CONSTRAINT [PK_Experiment_Id] PRIMARY KEY CLUSTERED
|
---|
197 | (
|
---|
198 | [Id] ASC
|
---|
199 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
200 | ) ON [PRIMARY]
|
---|
201 | GO
|
---|
202 | CREATE NONCLUSTERED INDEX [IX_Experiment_AlgorithmId_ProblemId] ON [dbo].[Experiment]
|
---|
203 | (
|
---|
204 | [AlgorithmId] ASC,
|
---|
205 | [ProblemId] ASC
|
---|
206 | )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]
|
---|
207 | GO
|
---|
208 | /****** Object: Table [dbo].[AlgorithmParameter] Script Date: 09/25/2010 01:33:11 ******/
|
---|
209 | SET ANSI_NULLS ON
|
---|
210 | GO
|
---|
211 | SET QUOTED_IDENTIFIER ON
|
---|
212 | GO
|
---|
213 | CREATE TABLE [dbo].[AlgorithmParameter](
|
---|
214 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
215 | [AlgorithmId] [bigint] NOT NULL,
|
---|
216 | [Name] [nvarchar](200) NOT NULL,
|
---|
217 | [Alias] [nvarchar](200) NULL,
|
---|
218 | [Description] [nvarchar](max) NULL,
|
---|
219 | [DataTypeId] [bigint] NOT NULL,
|
---|
220 | CONSTRAINT [PK_AlgorithmParameter_Id] PRIMARY KEY CLUSTERED
|
---|
221 | (
|
---|
222 | [Id] ASC
|
---|
223 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
|
---|
224 | CONSTRAINT [UQ_AlgorithmParameter_Name_AlgorithmId] UNIQUE NONCLUSTERED
|
---|
225 | (
|
---|
226 | [Name] ASC,
|
---|
227 | [AlgorithmId] ASC
|
---|
228 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
229 | ) ON [PRIMARY]
|
---|
230 | GO
|
---|
231 | /****** Object: Table [dbo].[AlgorithmData] Script Date: 09/25/2010 01:33:11 ******/
|
---|
232 | SET ANSI_NULLS ON
|
---|
233 | GO
|
---|
234 | SET QUOTED_IDENTIFIER ON
|
---|
235 | GO
|
---|
236 | SET ANSI_PADDING ON
|
---|
237 | GO
|
---|
238 | CREATE TABLE [dbo].[AlgorithmData](
|
---|
239 | [AlgorithmId] [bigint] NOT NULL,
|
---|
240 | [DataTypeId] [bigint] NOT NULL,
|
---|
241 | [Data] [varbinary](max) NOT NULL,
|
---|
242 | CONSTRAINT [PK_AlgorithmData_AlgorithmId] PRIMARY KEY CLUSTERED
|
---|
243 | (
|
---|
244 | [AlgorithmId] ASC
|
---|
245 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
246 | ) ON [PRIMARY]
|
---|
247 | GO
|
---|
248 | SET ANSI_PADDING OFF
|
---|
249 | GO
|
---|
250 | /****** Object: Table [dbo].[Result] Script Date: 09/25/2010 01:33:11 ******/
|
---|
251 | SET ANSI_NULLS ON
|
---|
252 | GO
|
---|
253 | SET QUOTED_IDENTIFIER ON
|
---|
254 | GO
|
---|
255 | CREATE TABLE [dbo].[Result](
|
---|
256 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
257 | [AlgorithmId] [bigint] NOT NULL,
|
---|
258 | [Name] [nvarchar](200) NOT NULL,
|
---|
259 | [Alias] [nvarchar](200) NULL,
|
---|
260 | [Description] [nvarchar](max) NULL,
|
---|
261 | [DataTypeId] [bigint] NOT NULL,
|
---|
262 | CONSTRAINT [PK_Result_Id] PRIMARY KEY CLUSTERED
|
---|
263 | (
|
---|
264 | [Id] ASC
|
---|
265 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
|
---|
266 | CONSTRAINT [UQ_Result_Name_AlgorithmId] UNIQUE NONCLUSTERED
|
---|
267 | (
|
---|
268 | [Name] ASC,
|
---|
269 | [AlgorithmId] ASC
|
---|
270 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
271 | ) ON [PRIMARY]
|
---|
272 | GO
|
---|
273 | /****** Object: Table [dbo].[ProblemUser] Script Date: 09/25/2010 01:33:11 ******/
|
---|
274 | SET ANSI_NULLS ON
|
---|
275 | GO
|
---|
276 | SET QUOTED_IDENTIFIER ON
|
---|
277 | GO
|
---|
278 | CREATE TABLE [dbo].[ProblemUser](
|
---|
279 | [ProblemId] [bigint] NOT NULL,
|
---|
280 | [UserId] [uniqueidentifier] NOT NULL,
|
---|
281 | CONSTRAINT [PK_ProblemUser_ProblemId_UserId] PRIMARY KEY CLUSTERED
|
---|
282 | (
|
---|
283 | [ProblemId] ASC,
|
---|
284 | [UserId] ASC
|
---|
285 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
286 | ) ON [PRIMARY]
|
---|
287 | GO
|
---|
288 | /****** Object: Table [dbo].[ProblemParameterStringValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
289 | SET ANSI_NULLS ON
|
---|
290 | GO
|
---|
291 | SET QUOTED_IDENTIFIER ON
|
---|
292 | GO
|
---|
293 | CREATE TABLE [dbo].[ProblemParameterStringValue](
|
---|
294 | [ProblemParameterId] [bigint] NOT NULL,
|
---|
295 | [ExperimentId] [bigint] NOT NULL,
|
---|
296 | [DataTypeId] [bigint] NOT NULL,
|
---|
297 | [Value] [nvarchar](max) NOT NULL,
|
---|
298 | CONSTRAINT [PK_ProblemParameterStringValue_ProblemParameterId_ExperimentId] PRIMARY KEY CLUSTERED
|
---|
299 | (
|
---|
300 | [ProblemParameterId] ASC,
|
---|
301 | [ExperimentId] ASC
|
---|
302 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
303 | ) ON [PRIMARY]
|
---|
304 | GO
|
---|
305 | /****** Object: Table [dbo].[ProblemParameterIntValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
306 | SET ANSI_NULLS ON
|
---|
307 | GO
|
---|
308 | SET QUOTED_IDENTIFIER ON
|
---|
309 | GO
|
---|
310 | CREATE TABLE [dbo].[ProblemParameterIntValue](
|
---|
311 | [ProblemParameterId] [bigint] NOT NULL,
|
---|
312 | [ExperimentId] [bigint] NOT NULL,
|
---|
313 | [DataTypeId] [bigint] NOT NULL,
|
---|
314 | [Value] [bigint] NOT NULL,
|
---|
315 | CONSTRAINT [PK_ProblemParameterIntValue_ProblemParameterId_ExperimentId] PRIMARY KEY CLUSTERED
|
---|
316 | (
|
---|
317 | [ProblemParameterId] ASC,
|
---|
318 | [ExperimentId] ASC
|
---|
319 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
320 | ) ON [PRIMARY]
|
---|
321 | GO
|
---|
322 | /****** Object: Table [dbo].[ProblemParameterFloatValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
323 | SET ANSI_NULLS ON
|
---|
324 | GO
|
---|
325 | SET QUOTED_IDENTIFIER ON
|
---|
326 | GO
|
---|
327 | CREATE TABLE [dbo].[ProblemParameterFloatValue](
|
---|
328 | [ProblemParameterId] [bigint] NOT NULL,
|
---|
329 | [ExperimentId] [bigint] NOT NULL,
|
---|
330 | [DataTypeId] [bigint] NOT NULL,
|
---|
331 | [Value] [float] NOT NULL,
|
---|
332 | CONSTRAINT [PK_ProblemParameterFloatValue_ProblemParameterId_ExperimentId] PRIMARY KEY CLUSTERED
|
---|
333 | (
|
---|
334 | [ProblemParameterId] ASC,
|
---|
335 | [ExperimentId] 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]
|
---|
338 | GO
|
---|
339 | /****** Object: Table [dbo].[ProblemParameterBoolValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
340 | SET ANSI_NULLS ON
|
---|
341 | GO
|
---|
342 | SET QUOTED_IDENTIFIER ON
|
---|
343 | GO
|
---|
344 | CREATE TABLE [dbo].[ProblemParameterBoolValue](
|
---|
345 | [ProblemParameterId] [bigint] NOT NULL,
|
---|
346 | [ExperimentId] [bigint] NOT NULL,
|
---|
347 | [DataTypeId] [bigint] NOT NULL,
|
---|
348 | [Value] [bit] NOT NULL,
|
---|
349 | CONSTRAINT [PK_ProblemParameterBoolValue_ProblemParameterId_ExperimentId] PRIMARY KEY CLUSTERED
|
---|
350 | (
|
---|
351 | [ProblemParameterId] ASC,
|
---|
352 | [ExperimentId] ASC
|
---|
353 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
354 | ) ON [PRIMARY]
|
---|
355 | GO
|
---|
356 | /****** Object: Table [dbo].[ProblemParameterBlobValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
357 | SET ANSI_NULLS ON
|
---|
358 | GO
|
---|
359 | SET QUOTED_IDENTIFIER ON
|
---|
360 | GO
|
---|
361 | SET ANSI_PADDING ON
|
---|
362 | GO
|
---|
363 | CREATE TABLE [dbo].[ProblemParameterBlobValue](
|
---|
364 | [ProblemParameterId] [bigint] NOT NULL,
|
---|
365 | [ExperimentId] [bigint] NOT NULL,
|
---|
366 | [DataTypeId] [bigint] NOT NULL,
|
---|
367 | [Value] [varbinary](max) NOT NULL,
|
---|
368 | CONSTRAINT [PK_ProblemParameterBlobValue_ProblemParameterId_ExperimentId] PRIMARY KEY CLUSTERED
|
---|
369 | (
|
---|
370 | [ProblemParameterId] ASC,
|
---|
371 | [ExperimentId] ASC
|
---|
372 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
373 | ) ON [PRIMARY]
|
---|
374 | GO
|
---|
375 | SET ANSI_PADDING OFF
|
---|
376 | GO
|
---|
377 | /****** Object: Table [dbo].[AlgorithmParameterStringValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
378 | SET ANSI_NULLS ON
|
---|
379 | GO
|
---|
380 | SET QUOTED_IDENTIFIER ON
|
---|
381 | GO
|
---|
382 | CREATE TABLE [dbo].[AlgorithmParameterStringValue](
|
---|
383 | [AlgorithmParameterId] [bigint] NOT NULL,
|
---|
384 | [ExperimentId] [bigint] NOT NULL,
|
---|
385 | [DataTypeId] [bigint] NOT NULL,
|
---|
386 | [Value] [nvarchar](max) NOT NULL,
|
---|
387 | CONSTRAINT [PK_AlgorithmParameterStringValue_ParameterId_ExperimentId] PRIMARY KEY CLUSTERED
|
---|
388 | (
|
---|
389 | [AlgorithmParameterId] ASC,
|
---|
390 | [ExperimentId] 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]
|
---|
393 | GO
|
---|
394 | /****** Object: Table [dbo].[AlgorithmParameterIntValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
395 | SET ANSI_NULLS ON
|
---|
396 | GO
|
---|
397 | SET QUOTED_IDENTIFIER ON
|
---|
398 | GO
|
---|
399 | CREATE TABLE [dbo].[AlgorithmParameterIntValue](
|
---|
400 | [AlgorithmParameterId] [bigint] NOT NULL,
|
---|
401 | [ExperimentId] [bigint] NOT NULL,
|
---|
402 | [DataTypeId] [bigint] NOT NULL,
|
---|
403 | [Value] [bigint] NOT NULL,
|
---|
404 | CONSTRAINT [PK_AlgorithmParameterIntValue_AlgorithmParameterId_ExperimentId] PRIMARY KEY CLUSTERED
|
---|
405 | (
|
---|
406 | [AlgorithmParameterId] ASC,
|
---|
407 | [ExperimentId] ASC
|
---|
408 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
409 | ) ON [PRIMARY]
|
---|
410 | GO
|
---|
411 | /****** Object: Table [dbo].[AlgorithmParameterFloatValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
412 | SET ANSI_NULLS ON
|
---|
413 | GO
|
---|
414 | SET QUOTED_IDENTIFIER ON
|
---|
415 | GO
|
---|
416 | CREATE TABLE [dbo].[AlgorithmParameterFloatValue](
|
---|
417 | [AlgorithmParameterId] [bigint] NOT NULL,
|
---|
418 | [ExperimentId] [bigint] NOT NULL,
|
---|
419 | [DataTypeId] [bigint] NOT NULL,
|
---|
420 | [Value] [float] NOT NULL,
|
---|
421 | CONSTRAINT [PK_AlgorithmParameterFloatValue_AlgorithmParameterId_ExperimentId] PRIMARY KEY CLUSTERED
|
---|
422 | (
|
---|
423 | [AlgorithmParameterId] ASC,
|
---|
424 | [ExperimentId] ASC
|
---|
425 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
426 | ) ON [PRIMARY]
|
---|
427 | GO
|
---|
428 | /****** Object: Table [dbo].[AlgorithmParameterBoolValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
429 | SET ANSI_NULLS ON
|
---|
430 | GO
|
---|
431 | SET QUOTED_IDENTIFIER ON
|
---|
432 | GO
|
---|
433 | CREATE TABLE [dbo].[AlgorithmParameterBoolValue](
|
---|
434 | [AlgorithmParameterId] [bigint] NOT NULL,
|
---|
435 | [ExperimentId] [bigint] NOT NULL,
|
---|
436 | [DataTypeId] [bigint] NOT NULL,
|
---|
437 | [Value] [bit] NOT NULL,
|
---|
438 | CONSTRAINT [PK_AlgorithmParameterBoolValue_AlgorithmParameterId_ExperimentId] PRIMARY KEY CLUSTERED
|
---|
439 | (
|
---|
440 | [AlgorithmParameterId] ASC,
|
---|
441 | [ExperimentId] ASC
|
---|
442 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
443 | ) ON [PRIMARY]
|
---|
444 | GO
|
---|
445 | /****** Object: Table [dbo].[AlgorithmParameterBlobValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
446 | SET ANSI_NULLS ON
|
---|
447 | GO
|
---|
448 | SET QUOTED_IDENTIFIER ON
|
---|
449 | GO
|
---|
450 | SET ANSI_PADDING ON
|
---|
451 | GO
|
---|
452 | CREATE TABLE [dbo].[AlgorithmParameterBlobValue](
|
---|
453 | [AlgorithmParameterId] [bigint] NOT NULL,
|
---|
454 | [ExperimentId] [bigint] NOT NULL,
|
---|
455 | [DataTypeId] [bigint] NOT NULL,
|
---|
456 | [Value] [varbinary](max) NOT NULL,
|
---|
457 | CONSTRAINT [PK_AlgorithmParameterBlobValue_AlgorithmParameterId_ExperimentId] PRIMARY KEY CLUSTERED
|
---|
458 | (
|
---|
459 | [AlgorithmParameterId] ASC,
|
---|
460 | [ExperimentId] ASC
|
---|
461 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
462 | ) ON [PRIMARY]
|
---|
463 | GO
|
---|
464 | SET ANSI_PADDING OFF
|
---|
465 | GO
|
---|
466 | /****** Object: Table [dbo].[Run] Script Date: 09/25/2010 01:33:11 ******/
|
---|
467 | SET ANSI_NULLS ON
|
---|
468 | GO
|
---|
469 | SET QUOTED_IDENTIFIER ON
|
---|
470 | GO
|
---|
471 | CREATE TABLE [dbo].[Run](
|
---|
472 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
473 | [ExperimentId] [bigint] NOT NULL,
|
---|
474 | [RandomSeed] [int] NOT NULL,
|
---|
475 | [FinishedDate] [datetime2](7) NULL,
|
---|
476 | [UserId] [uniqueidentifier] NOT NULL,
|
---|
477 | [ClientId] [uniqueidentifier] NOT NULL,
|
---|
478 | CONSTRAINT [PK_Run_Id] PRIMARY KEY CLUSTERED
|
---|
479 | (
|
---|
480 | [Id] ASC
|
---|
481 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
482 | ) ON [PRIMARY]
|
---|
483 | GO
|
---|
484 | CREATE NONCLUSTERED INDEX [IX_Run_ExperimentId] ON [dbo].[Run]
|
---|
485 | (
|
---|
486 | [ExperimentId] ASC
|
---|
487 | )
|
---|
488 | INCLUDE ( [Id],
|
---|
489 | [FinishedDate],
|
---|
490 | [UserId],
|
---|
491 | [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]
|
---|
492 | GO
|
---|
493 | /****** Object: Table [dbo].[ResultStringValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
494 | SET ANSI_NULLS ON
|
---|
495 | GO
|
---|
496 | SET QUOTED_IDENTIFIER ON
|
---|
497 | GO
|
---|
498 | CREATE TABLE [dbo].[ResultStringValue](
|
---|
499 | [ResultId] [bigint] NOT NULL,
|
---|
500 | [RunId] [bigint] NOT NULL,
|
---|
501 | [DataTypeId] [bigint] NOT NULL,
|
---|
502 | [Value] [nvarchar](max) NOT NULL,
|
---|
503 | CONSTRAINT [PK_ResultStringValue_ResultId_RunId] PRIMARY KEY CLUSTERED
|
---|
504 | (
|
---|
505 | [ResultId] ASC,
|
---|
506 | [RunId] ASC
|
---|
507 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
508 | ) ON [PRIMARY]
|
---|
509 | GO
|
---|
510 | /****** Object: Table [dbo].[ResultIntValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
511 | SET ANSI_NULLS ON
|
---|
512 | GO
|
---|
513 | SET QUOTED_IDENTIFIER ON
|
---|
514 | GO
|
---|
515 | CREATE TABLE [dbo].[ResultIntValue](
|
---|
516 | [ResultId] [bigint] NOT NULL,
|
---|
517 | [RunId] [bigint] NOT NULL,
|
---|
518 | [DataTypeId] [bigint] NOT NULL,
|
---|
519 | [Value] [bigint] NOT NULL,
|
---|
520 | CONSTRAINT [PK_ResultIntValue_ResultId_RunId] PRIMARY KEY CLUSTERED
|
---|
521 | (
|
---|
522 | [ResultId] ASC,
|
---|
523 | [RunId] ASC
|
---|
524 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
525 | ) ON [PRIMARY]
|
---|
526 | GO
|
---|
527 | /****** Object: Table [dbo].[ResultFloatValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
528 | SET ANSI_NULLS ON
|
---|
529 | GO
|
---|
530 | SET QUOTED_IDENTIFIER ON
|
---|
531 | GO
|
---|
532 | CREATE TABLE [dbo].[ResultFloatValue](
|
---|
533 | [ResultId] [bigint] NOT NULL,
|
---|
534 | [RunId] [bigint] NOT NULL,
|
---|
535 | [DataTypeId] [bigint] NOT NULL,
|
---|
536 | [Value] [float] NOT NULL,
|
---|
537 | CONSTRAINT [PK_ResultFloatValue_ResultId_RunId] PRIMARY KEY CLUSTERED
|
---|
538 | (
|
---|
539 | [ResultId] ASC,
|
---|
540 | [RunId] 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 | /****** Object: Table [dbo].[ResultBoolValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
545 | SET ANSI_NULLS ON
|
---|
546 | GO
|
---|
547 | SET QUOTED_IDENTIFIER ON
|
---|
548 | GO
|
---|
549 | CREATE TABLE [dbo].[ResultBoolValue](
|
---|
550 | [ResultId] [bigint] NOT NULL,
|
---|
551 | [RunId] [bigint] NOT NULL,
|
---|
552 | [DataTypeId] [bigint] NOT NULL,
|
---|
553 | [Value] [bit] NOT NULL,
|
---|
554 | CONSTRAINT [PK_ResultBoolValue_ResultId_RunId] PRIMARY KEY CLUSTERED
|
---|
555 | (
|
---|
556 | [ResultId] ASC,
|
---|
557 | [RunId] ASC
|
---|
558 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
559 | ) ON [PRIMARY]
|
---|
560 | GO
|
---|
561 | /****** Object: Table [dbo].[ResultBlobValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
562 | SET ANSI_NULLS ON
|
---|
563 | GO
|
---|
564 | SET QUOTED_IDENTIFIER ON
|
---|
565 | GO
|
---|
566 | SET ANSI_PADDING ON
|
---|
567 | GO
|
---|
568 | CREATE TABLE [dbo].[ResultBlobValue](
|
---|
569 | [ResultId] [bigint] NOT NULL,
|
---|
570 | [RunId] [bigint] NOT NULL,
|
---|
571 | [DataTypeId] [bigint] NOT NULL,
|
---|
572 | [Value] [varbinary](max) NOT NULL,
|
---|
573 | CONSTRAINT [PK_ResultBlobValue_ResultId_RunId] PRIMARY KEY CLUSTERED
|
---|
574 | (
|
---|
575 | [ResultId] ASC,
|
---|
576 | [RunId] ASC
|
---|
577 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
578 | ) ON [PRIMARY]
|
---|
579 | GO
|
---|
580 | SET ANSI_PADDING OFF
|
---|
581 | GO
|
---|
582 | /****** Object: Check [CK_DataType_SqlName] Script Date: 09/25/2010 01:33:11 ******/
|
---|
583 | ALTER TABLE [dbo].[DataType] WITH CHECK ADD CONSTRAINT [CK_DataType_SqlName] CHECK (([SqlName]='bigint' OR [SqlName]='bit' OR [SqlName]='float' OR [SqlName]='nvarchar' OR [SqlName]='varbinary'))
|
---|
584 | GO
|
---|
585 | ALTER TABLE [dbo].[DataType] CHECK CONSTRAINT [CK_DataType_SqlName]
|
---|
586 | GO
|
---|
587 | /****** Object: ForeignKey [FK_AlgorithmClass_Algorithm] Script Date: 09/25/2010 01:33:11 ******/
|
---|
588 | ALTER TABLE [dbo].[Algorithm] WITH CHECK ADD CONSTRAINT [FK_AlgorithmClass_Algorithm] FOREIGN KEY([AlgorithmClassId])
|
---|
589 | REFERENCES [dbo].[AlgorithmClass] ([Id])
|
---|
590 | GO
|
---|
591 | ALTER TABLE [dbo].[Algorithm] CHECK CONSTRAINT [FK_AlgorithmClass_Algorithm]
|
---|
592 | GO
|
---|
593 | /****** Object: ForeignKey [FK_Platform_Algorithm] Script Date: 09/25/2010 01:33:11 ******/
|
---|
594 | ALTER TABLE [dbo].[Algorithm] WITH CHECK ADD CONSTRAINT [FK_Platform_Algorithm] FOREIGN KEY([PlatformId])
|
---|
595 | REFERENCES [dbo].[Platform] ([Id])
|
---|
596 | GO
|
---|
597 | ALTER TABLE [dbo].[Algorithm] CHECK CONSTRAINT [FK_Platform_Algorithm]
|
---|
598 | GO
|
---|
599 | /****** Object: ForeignKey [FK_Algorithm_AlgorithmData] Script Date: 09/25/2010 01:33:11 ******/
|
---|
600 | ALTER TABLE [dbo].[AlgorithmData] WITH CHECK ADD CONSTRAINT [FK_Algorithm_AlgorithmData] FOREIGN KEY([AlgorithmId])
|
---|
601 | REFERENCES [dbo].[Algorithm] ([Id])
|
---|
602 | ON UPDATE CASCADE
|
---|
603 | ON DELETE CASCADE
|
---|
604 | GO
|
---|
605 | ALTER TABLE [dbo].[AlgorithmData] CHECK CONSTRAINT [FK_Algorithm_AlgorithmData]
|
---|
606 | GO
|
---|
607 | /****** Object: ForeignKey [FK_DataType_AlgorithmData] Script Date: 09/25/2010 01:33:11 ******/
|
---|
608 | ALTER TABLE [dbo].[AlgorithmData] WITH CHECK ADD CONSTRAINT [FK_DataType_AlgorithmData] FOREIGN KEY([DataTypeId])
|
---|
609 | REFERENCES [dbo].[DataType] ([Id])
|
---|
610 | GO
|
---|
611 | ALTER TABLE [dbo].[AlgorithmData] CHECK CONSTRAINT [FK_DataType_AlgorithmData]
|
---|
612 | GO
|
---|
613 | /****** Object: ForeignKey [FK_Algorithm_AlgorithmParameter] Script Date: 09/25/2010 01:33:11 ******/
|
---|
614 | ALTER TABLE [dbo].[AlgorithmParameter] WITH CHECK ADD CONSTRAINT [FK_Algorithm_AlgorithmParameter] FOREIGN KEY([AlgorithmId])
|
---|
615 | REFERENCES [dbo].[Algorithm] ([Id])
|
---|
616 | GO
|
---|
617 | ALTER TABLE [dbo].[AlgorithmParameter] CHECK CONSTRAINT [FK_Algorithm_AlgorithmParameter]
|
---|
618 | GO
|
---|
619 | /****** Object: ForeignKey [FK_DataType_AlgorithmParameter] Script Date: 09/25/2010 01:33:11 ******/
|
---|
620 | ALTER TABLE [dbo].[AlgorithmParameter] WITH CHECK ADD CONSTRAINT [FK_DataType_AlgorithmParameter] FOREIGN KEY([DataTypeId])
|
---|
621 | REFERENCES [dbo].[DataType] ([Id])
|
---|
622 | GO
|
---|
623 | ALTER TABLE [dbo].[AlgorithmParameter] CHECK CONSTRAINT [FK_DataType_AlgorithmParameter]
|
---|
624 | GO
|
---|
625 | /****** Object: ForeignKey [FK_AlgorithmParameter_AlgorithmParameterBlobValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
626 | ALTER TABLE [dbo].[AlgorithmParameterBlobValue] WITH CHECK ADD CONSTRAINT [FK_AlgorithmParameter_AlgorithmParameterBlobValue] FOREIGN KEY([AlgorithmParameterId])
|
---|
627 | REFERENCES [dbo].[AlgorithmParameter] ([Id])
|
---|
628 | GO
|
---|
629 | ALTER TABLE [dbo].[AlgorithmParameterBlobValue] CHECK CONSTRAINT [FK_AlgorithmParameter_AlgorithmParameterBlobValue]
|
---|
630 | GO
|
---|
631 | /****** Object: ForeignKey [FK_DataType_AlgorithmParameterBlobValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
632 | ALTER TABLE [dbo].[AlgorithmParameterBlobValue] WITH CHECK ADD CONSTRAINT [FK_DataType_AlgorithmParameterBlobValue] FOREIGN KEY([DataTypeId])
|
---|
633 | REFERENCES [dbo].[DataType] ([Id])
|
---|
634 | GO
|
---|
635 | ALTER TABLE [dbo].[AlgorithmParameterBlobValue] CHECK CONSTRAINT [FK_DataType_AlgorithmParameterBlobValue]
|
---|
636 | GO
|
---|
637 | /****** Object: ForeignKey [FK_Experiment_AlgorithmParameterBlobValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
638 | ALTER TABLE [dbo].[AlgorithmParameterBlobValue] WITH CHECK ADD CONSTRAINT [FK_Experiment_AlgorithmParameterBlobValue] FOREIGN KEY([ExperimentId])
|
---|
639 | REFERENCES [dbo].[Experiment] ([Id])
|
---|
640 | GO
|
---|
641 | ALTER TABLE [dbo].[AlgorithmParameterBlobValue] CHECK CONSTRAINT [FK_Experiment_AlgorithmParameterBlobValue]
|
---|
642 | GO
|
---|
643 | /****** Object: ForeignKey [FK_AlgorithmParameter_AlgorithmParameterBoolValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
644 | ALTER TABLE [dbo].[AlgorithmParameterBoolValue] WITH CHECK ADD CONSTRAINT [FK_AlgorithmParameter_AlgorithmParameterBoolValue] FOREIGN KEY([AlgorithmParameterId])
|
---|
645 | REFERENCES [dbo].[AlgorithmParameter] ([Id])
|
---|
646 | GO
|
---|
647 | ALTER TABLE [dbo].[AlgorithmParameterBoolValue] CHECK CONSTRAINT [FK_AlgorithmParameter_AlgorithmParameterBoolValue]
|
---|
648 | GO
|
---|
649 | /****** Object: ForeignKey [FK_DataType_AlgorithmParameterBoolValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
650 | ALTER TABLE [dbo].[AlgorithmParameterBoolValue] WITH CHECK ADD CONSTRAINT [FK_DataType_AlgorithmParameterBoolValue] FOREIGN KEY([DataTypeId])
|
---|
651 | REFERENCES [dbo].[DataType] ([Id])
|
---|
652 | GO
|
---|
653 | ALTER TABLE [dbo].[AlgorithmParameterBoolValue] CHECK CONSTRAINT [FK_DataType_AlgorithmParameterBoolValue]
|
---|
654 | GO
|
---|
655 | /****** Object: ForeignKey [FK_Experiment_AlgorithmParameterBoolValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
656 | ALTER TABLE [dbo].[AlgorithmParameterBoolValue] WITH CHECK ADD CONSTRAINT [FK_Experiment_AlgorithmParameterBoolValue] FOREIGN KEY([ExperimentId])
|
---|
657 | REFERENCES [dbo].[Experiment] ([Id])
|
---|
658 | GO
|
---|
659 | ALTER TABLE [dbo].[AlgorithmParameterBoolValue] CHECK CONSTRAINT [FK_Experiment_AlgorithmParameterBoolValue]
|
---|
660 | GO
|
---|
661 | /****** Object: ForeignKey [FK_AlgorithmParameter_AlgorithmParameterFloatValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
662 | ALTER TABLE [dbo].[AlgorithmParameterFloatValue] WITH CHECK ADD CONSTRAINT [FK_AlgorithmParameter_AlgorithmParameterFloatValue] FOREIGN KEY([AlgorithmParameterId])
|
---|
663 | REFERENCES [dbo].[AlgorithmParameter] ([Id])
|
---|
664 | GO
|
---|
665 | ALTER TABLE [dbo].[AlgorithmParameterFloatValue] CHECK CONSTRAINT [FK_AlgorithmParameter_AlgorithmParameterFloatValue]
|
---|
666 | GO
|
---|
667 | /****** Object: ForeignKey [FK_DataType_AlgorithmParameterFloatValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
668 | ALTER TABLE [dbo].[AlgorithmParameterFloatValue] WITH CHECK ADD CONSTRAINT [FK_DataType_AlgorithmParameterFloatValue] FOREIGN KEY([DataTypeId])
|
---|
669 | REFERENCES [dbo].[DataType] ([Id])
|
---|
670 | GO
|
---|
671 | ALTER TABLE [dbo].[AlgorithmParameterFloatValue] CHECK CONSTRAINT [FK_DataType_AlgorithmParameterFloatValue]
|
---|
672 | GO
|
---|
673 | /****** Object: ForeignKey [FK_Experiment_AlgorithmParameterFloatValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
674 | ALTER TABLE [dbo].[AlgorithmParameterFloatValue] WITH CHECK ADD CONSTRAINT [FK_Experiment_AlgorithmParameterFloatValue] FOREIGN KEY([ExperimentId])
|
---|
675 | REFERENCES [dbo].[Experiment] ([Id])
|
---|
676 | GO
|
---|
677 | ALTER TABLE [dbo].[AlgorithmParameterFloatValue] CHECK CONSTRAINT [FK_Experiment_AlgorithmParameterFloatValue]
|
---|
678 | GO
|
---|
679 | /****** Object: ForeignKey [FK_AlgorithmParameter_AlgorithmParameterIntValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
680 | ALTER TABLE [dbo].[AlgorithmParameterIntValue] WITH CHECK ADD CONSTRAINT [FK_AlgorithmParameter_AlgorithmParameterIntValue] FOREIGN KEY([AlgorithmParameterId])
|
---|
681 | REFERENCES [dbo].[AlgorithmParameter] ([Id])
|
---|
682 | GO
|
---|
683 | ALTER TABLE [dbo].[AlgorithmParameterIntValue] CHECK CONSTRAINT [FK_AlgorithmParameter_AlgorithmParameterIntValue]
|
---|
684 | GO
|
---|
685 | /****** Object: ForeignKey [FK_DataType_AlgorithmParameterIntValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
686 | ALTER TABLE [dbo].[AlgorithmParameterIntValue] WITH CHECK ADD CONSTRAINT [FK_DataType_AlgorithmParameterIntValue] FOREIGN KEY([DataTypeId])
|
---|
687 | REFERENCES [dbo].[DataType] ([Id])
|
---|
688 | GO
|
---|
689 | ALTER TABLE [dbo].[AlgorithmParameterIntValue] CHECK CONSTRAINT [FK_DataType_AlgorithmParameterIntValue]
|
---|
690 | GO
|
---|
691 | /****** Object: ForeignKey [FK_Experiment_AlgorithmParameterIntValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
692 | ALTER TABLE [dbo].[AlgorithmParameterIntValue] WITH CHECK ADD CONSTRAINT [FK_Experiment_AlgorithmParameterIntValue] FOREIGN KEY([ExperimentId])
|
---|
693 | REFERENCES [dbo].[Experiment] ([Id])
|
---|
694 | GO
|
---|
695 | ALTER TABLE [dbo].[AlgorithmParameterIntValue] CHECK CONSTRAINT [FK_Experiment_AlgorithmParameterIntValue]
|
---|
696 | GO
|
---|
697 | /****** Object: ForeignKey [FK_AlgorithmParameter_AlgorithmParameterStringValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
698 | ALTER TABLE [dbo].[AlgorithmParameterStringValue] WITH CHECK ADD CONSTRAINT [FK_AlgorithmParameter_AlgorithmParameterStringValue] FOREIGN KEY([AlgorithmParameterId])
|
---|
699 | REFERENCES [dbo].[AlgorithmParameter] ([Id])
|
---|
700 | GO
|
---|
701 | ALTER TABLE [dbo].[AlgorithmParameterStringValue] CHECK CONSTRAINT [FK_AlgorithmParameter_AlgorithmParameterStringValue]
|
---|
702 | GO
|
---|
703 | /****** Object: ForeignKey [FK_DataType_AlgorithmParameterStringValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
704 | ALTER TABLE [dbo].[AlgorithmParameterStringValue] WITH CHECK ADD CONSTRAINT [FK_DataType_AlgorithmParameterStringValue] FOREIGN KEY([DataTypeId])
|
---|
705 | REFERENCES [dbo].[DataType] ([Id])
|
---|
706 | GO
|
---|
707 | ALTER TABLE [dbo].[AlgorithmParameterStringValue] CHECK CONSTRAINT [FK_DataType_AlgorithmParameterStringValue]
|
---|
708 | GO
|
---|
709 | /****** Object: ForeignKey [FK_Experiment_AlgorithmParameterStringValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
710 | ALTER TABLE [dbo].[AlgorithmParameterStringValue] WITH CHECK ADD CONSTRAINT [FK_Experiment_AlgorithmParameterStringValue] FOREIGN KEY([ExperimentId])
|
---|
711 | REFERENCES [dbo].[Experiment] ([Id])
|
---|
712 | GO
|
---|
713 | ALTER TABLE [dbo].[AlgorithmParameterStringValue] CHECK CONSTRAINT [FK_Experiment_AlgorithmParameterStringValue]
|
---|
714 | GO
|
---|
715 | /****** Object: ForeignKey [FK_Algorithm_AlgorithmUser] Script Date: 09/25/2010 01:33:11 ******/
|
---|
716 | ALTER TABLE [dbo].[AlgorithmUser] WITH CHECK ADD CONSTRAINT [FK_Algorithm_AlgorithmUser] FOREIGN KEY([AlgorithmId])
|
---|
717 | REFERENCES [dbo].[Algorithm] ([Id])
|
---|
718 | ON UPDATE CASCADE
|
---|
719 | ON DELETE CASCADE
|
---|
720 | GO
|
---|
721 | ALTER TABLE [dbo].[AlgorithmUser] CHECK CONSTRAINT [FK_Algorithm_AlgorithmUser]
|
---|
722 | GO
|
---|
723 | /****** Object: ForeignKey [FK_Platform_DataType] Script Date: 09/25/2010 01:33:11 ******/
|
---|
724 | ALTER TABLE [dbo].[DataType] WITH CHECK ADD CONSTRAINT [FK_Platform_DataType] FOREIGN KEY([PlatformId])
|
---|
725 | REFERENCES [dbo].[Platform] ([Id])
|
---|
726 | GO
|
---|
727 | ALTER TABLE [dbo].[DataType] CHECK CONSTRAINT [FK_Platform_DataType]
|
---|
728 | GO
|
---|
729 | /****** Object: ForeignKey [FK_Algorithm_Experiment] Script Date: 09/25/2010 01:33:11 ******/
|
---|
730 | ALTER TABLE [dbo].[Experiment] WITH CHECK ADD CONSTRAINT [FK_Algorithm_Experiment] FOREIGN KEY([AlgorithmId])
|
---|
731 | REFERENCES [dbo].[Algorithm] ([Id])
|
---|
732 | GO
|
---|
733 | ALTER TABLE [dbo].[Experiment] CHECK CONSTRAINT [FK_Algorithm_Experiment]
|
---|
734 | GO
|
---|
735 | /****** Object: ForeignKey [FK_Problem_Experiment] Script Date: 09/25/2010 01:33:11 ******/
|
---|
736 | ALTER TABLE [dbo].[Experiment] WITH CHECK ADD CONSTRAINT [FK_Problem_Experiment] FOREIGN KEY([ProblemId])
|
---|
737 | REFERENCES [dbo].[Problem] ([Id])
|
---|
738 | GO
|
---|
739 | ALTER TABLE [dbo].[Experiment] CHECK CONSTRAINT [FK_Problem_Experiment]
|
---|
740 | GO
|
---|
741 | /****** Object: ForeignKey [FK_Platform_Problem] Script Date: 09/25/2010 01:33:11 ******/
|
---|
742 | ALTER TABLE [dbo].[Problem] WITH CHECK ADD CONSTRAINT [FK_Platform_Problem] FOREIGN KEY([PlatformId])
|
---|
743 | REFERENCES [dbo].[Platform] ([Id])
|
---|
744 | GO
|
---|
745 | ALTER TABLE [dbo].[Problem] CHECK CONSTRAINT [FK_Platform_Problem]
|
---|
746 | GO
|
---|
747 | /****** Object: ForeignKey [FK_ProblemClass_Problem] Script Date: 09/25/2010 01:33:11 ******/
|
---|
748 | ALTER TABLE [dbo].[Problem] WITH CHECK ADD CONSTRAINT [FK_ProblemClass_Problem] FOREIGN KEY([ProblemClassId])
|
---|
749 | REFERENCES [dbo].[ProblemClass] ([Id])
|
---|
750 | GO
|
---|
751 | ALTER TABLE [dbo].[Problem] CHECK CONSTRAINT [FK_ProblemClass_Problem]
|
---|
752 | GO
|
---|
753 | /****** Object: ForeignKey [FK_DataType_ProblemData] Script Date: 09/25/2010 01:33:11 ******/
|
---|
754 | ALTER TABLE [dbo].[ProblemData] WITH CHECK ADD CONSTRAINT [FK_DataType_ProblemData] FOREIGN KEY([DataTypeId])
|
---|
755 | REFERENCES [dbo].[DataType] ([Id])
|
---|
756 | GO
|
---|
757 | ALTER TABLE [dbo].[ProblemData] CHECK CONSTRAINT [FK_DataType_ProblemData]
|
---|
758 | GO
|
---|
759 | /****** Object: ForeignKey [FK_Problem_ProblemData] Script Date: 09/25/2010 01:33:11 ******/
|
---|
760 | ALTER TABLE [dbo].[ProblemData] WITH CHECK ADD CONSTRAINT [FK_Problem_ProblemData] FOREIGN KEY([ProblemId])
|
---|
761 | REFERENCES [dbo].[Problem] ([Id])
|
---|
762 | ON UPDATE CASCADE
|
---|
763 | ON DELETE CASCADE
|
---|
764 | GO
|
---|
765 | ALTER TABLE [dbo].[ProblemData] CHECK CONSTRAINT [FK_Problem_ProblemData]
|
---|
766 | GO
|
---|
767 | /****** Object: ForeignKey [FK_DataType_ProblemParameter] Script Date: 09/25/2010 01:33:11 ******/
|
---|
768 | ALTER TABLE [dbo].[ProblemParameter] WITH CHECK ADD CONSTRAINT [FK_DataType_ProblemParameter] FOREIGN KEY([DataTypeId])
|
---|
769 | REFERENCES [dbo].[DataType] ([Id])
|
---|
770 | GO
|
---|
771 | ALTER TABLE [dbo].[ProblemParameter] CHECK CONSTRAINT [FK_DataType_ProblemParameter]
|
---|
772 | GO
|
---|
773 | /****** Object: ForeignKey [FK_Problem_ProblemParameter] Script Date: 09/25/2010 01:33:11 ******/
|
---|
774 | ALTER TABLE [dbo].[ProblemParameter] WITH CHECK ADD CONSTRAINT [FK_Problem_ProblemParameter] FOREIGN KEY([ProblemId])
|
---|
775 | REFERENCES [dbo].[Problem] ([Id])
|
---|
776 | GO
|
---|
777 | ALTER TABLE [dbo].[ProblemParameter] CHECK CONSTRAINT [FK_Problem_ProblemParameter]
|
---|
778 | GO
|
---|
779 | /****** Object: ForeignKey [FK_DataType_ProblemParameterBlobValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
780 | ALTER TABLE [dbo].[ProblemParameterBlobValue] WITH CHECK ADD CONSTRAINT [FK_DataType_ProblemParameterBlobValue] FOREIGN KEY([DataTypeId])
|
---|
781 | REFERENCES [dbo].[DataType] ([Id])
|
---|
782 | GO
|
---|
783 | ALTER TABLE [dbo].[ProblemParameterBlobValue] CHECK CONSTRAINT [FK_DataType_ProblemParameterBlobValue]
|
---|
784 | GO
|
---|
785 | /****** Object: ForeignKey [FK_Experiment_ProblemParameterBlobValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
786 | ALTER TABLE [dbo].[ProblemParameterBlobValue] WITH CHECK ADD CONSTRAINT [FK_Experiment_ProblemParameterBlobValue] FOREIGN KEY([ExperimentId])
|
---|
787 | REFERENCES [dbo].[Experiment] ([Id])
|
---|
788 | GO
|
---|
789 | ALTER TABLE [dbo].[ProblemParameterBlobValue] CHECK CONSTRAINT [FK_Experiment_ProblemParameterBlobValue]
|
---|
790 | GO
|
---|
791 | /****** Object: ForeignKey [FK_ProblemParameter_ProblemParameterBlobValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
792 | ALTER TABLE [dbo].[ProblemParameterBlobValue] WITH CHECK ADD CONSTRAINT [FK_ProblemParameter_ProblemParameterBlobValue] FOREIGN KEY([ProblemParameterId])
|
---|
793 | REFERENCES [dbo].[ProblemParameter] ([Id])
|
---|
794 | GO
|
---|
795 | ALTER TABLE [dbo].[ProblemParameterBlobValue] CHECK CONSTRAINT [FK_ProblemParameter_ProblemParameterBlobValue]
|
---|
796 | GO
|
---|
797 | /****** Object: ForeignKey [FK_DataType_ProblemParameterBoolValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
798 | ALTER TABLE [dbo].[ProblemParameterBoolValue] WITH CHECK ADD CONSTRAINT [FK_DataType_ProblemParameterBoolValue] FOREIGN KEY([DataTypeId])
|
---|
799 | REFERENCES [dbo].[DataType] ([Id])
|
---|
800 | GO
|
---|
801 | ALTER TABLE [dbo].[ProblemParameterBoolValue] CHECK CONSTRAINT [FK_DataType_ProblemParameterBoolValue]
|
---|
802 | GO
|
---|
803 | /****** Object: ForeignKey [FK_Experiment_ProblemParameterBoolValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
804 | ALTER TABLE [dbo].[ProblemParameterBoolValue] WITH CHECK ADD CONSTRAINT [FK_Experiment_ProblemParameterBoolValue] FOREIGN KEY([ExperimentId])
|
---|
805 | REFERENCES [dbo].[Experiment] ([Id])
|
---|
806 | GO
|
---|
807 | ALTER TABLE [dbo].[ProblemParameterBoolValue] CHECK CONSTRAINT [FK_Experiment_ProblemParameterBoolValue]
|
---|
808 | GO
|
---|
809 | /****** Object: ForeignKey [FK_ProblemParameter_ProblemParameterBoolValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
810 | ALTER TABLE [dbo].[ProblemParameterBoolValue] WITH CHECK ADD CONSTRAINT [FK_ProblemParameter_ProblemParameterBoolValue] FOREIGN KEY([ProblemParameterId])
|
---|
811 | REFERENCES [dbo].[ProblemParameter] ([Id])
|
---|
812 | GO
|
---|
813 | ALTER TABLE [dbo].[ProblemParameterBoolValue] CHECK CONSTRAINT [FK_ProblemParameter_ProblemParameterBoolValue]
|
---|
814 | GO
|
---|
815 | /****** Object: ForeignKey [FK_DataType_ProblemParameterFloatValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
816 | ALTER TABLE [dbo].[ProblemParameterFloatValue] WITH CHECK ADD CONSTRAINT [FK_DataType_ProblemParameterFloatValue] FOREIGN KEY([DataTypeId])
|
---|
817 | REFERENCES [dbo].[DataType] ([Id])
|
---|
818 | GO
|
---|
819 | ALTER TABLE [dbo].[ProblemParameterFloatValue] CHECK CONSTRAINT [FK_DataType_ProblemParameterFloatValue]
|
---|
820 | GO
|
---|
821 | /****** Object: ForeignKey [FK_Experiment_ProblemParameterFloatValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
822 | ALTER TABLE [dbo].[ProblemParameterFloatValue] WITH CHECK ADD CONSTRAINT [FK_Experiment_ProblemParameterFloatValue] FOREIGN KEY([ExperimentId])
|
---|
823 | REFERENCES [dbo].[Experiment] ([Id])
|
---|
824 | GO
|
---|
825 | ALTER TABLE [dbo].[ProblemParameterFloatValue] CHECK CONSTRAINT [FK_Experiment_ProblemParameterFloatValue]
|
---|
826 | GO
|
---|
827 | /****** Object: ForeignKey [FK_ProblemParameter_ProblemParameterFloatValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
828 | ALTER TABLE [dbo].[ProblemParameterFloatValue] WITH CHECK ADD CONSTRAINT [FK_ProblemParameter_ProblemParameterFloatValue] FOREIGN KEY([ProblemParameterId])
|
---|
829 | REFERENCES [dbo].[ProblemParameter] ([Id])
|
---|
830 | GO
|
---|
831 | ALTER TABLE [dbo].[ProblemParameterFloatValue] CHECK CONSTRAINT [FK_ProblemParameter_ProblemParameterFloatValue]
|
---|
832 | GO
|
---|
833 | /****** Object: ForeignKey [FK_DataType_ProblemParameterIntValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
834 | ALTER TABLE [dbo].[ProblemParameterIntValue] WITH CHECK ADD CONSTRAINT [FK_DataType_ProblemParameterIntValue] FOREIGN KEY([DataTypeId])
|
---|
835 | REFERENCES [dbo].[DataType] ([Id])
|
---|
836 | GO
|
---|
837 | ALTER TABLE [dbo].[ProblemParameterIntValue] CHECK CONSTRAINT [FK_DataType_ProblemParameterIntValue]
|
---|
838 | GO
|
---|
839 | /****** Object: ForeignKey [FK_Experiment_ProblemParameterIntValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
840 | ALTER TABLE [dbo].[ProblemParameterIntValue] WITH CHECK ADD CONSTRAINT [FK_Experiment_ProblemParameterIntValue] FOREIGN KEY([ExperimentId])
|
---|
841 | REFERENCES [dbo].[Experiment] ([Id])
|
---|
842 | GO
|
---|
843 | ALTER TABLE [dbo].[ProblemParameterIntValue] CHECK CONSTRAINT [FK_Experiment_ProblemParameterIntValue]
|
---|
844 | GO
|
---|
845 | /****** Object: ForeignKey [FK_ProblemParameter_ProblemParameterIntValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
846 | ALTER TABLE [dbo].[ProblemParameterIntValue] WITH CHECK ADD CONSTRAINT [FK_ProblemParameter_ProblemParameterIntValue] FOREIGN KEY([ProblemParameterId])
|
---|
847 | REFERENCES [dbo].[ProblemParameter] ([Id])
|
---|
848 | GO
|
---|
849 | ALTER TABLE [dbo].[ProblemParameterIntValue] CHECK CONSTRAINT [FK_ProblemParameter_ProblemParameterIntValue]
|
---|
850 | GO
|
---|
851 | /****** Object: ForeignKey [FK_DataType_ProblemParameterStringValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
852 | ALTER TABLE [dbo].[ProblemParameterStringValue] WITH CHECK ADD CONSTRAINT [FK_DataType_ProblemParameterStringValue] FOREIGN KEY([DataTypeId])
|
---|
853 | REFERENCES [dbo].[DataType] ([Id])
|
---|
854 | GO
|
---|
855 | ALTER TABLE [dbo].[ProblemParameterStringValue] CHECK CONSTRAINT [FK_DataType_ProblemParameterStringValue]
|
---|
856 | GO
|
---|
857 | /****** Object: ForeignKey [FK_Experiment_ProblemParameterStringValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
858 | ALTER TABLE [dbo].[ProblemParameterStringValue] WITH CHECK ADD CONSTRAINT [FK_Experiment_ProblemParameterStringValue] FOREIGN KEY([ExperimentId])
|
---|
859 | REFERENCES [dbo].[Experiment] ([Id])
|
---|
860 | GO
|
---|
861 | ALTER TABLE [dbo].[ProblemParameterStringValue] CHECK CONSTRAINT [FK_Experiment_ProblemParameterStringValue]
|
---|
862 | GO
|
---|
863 | /****** Object: ForeignKey [FK_ProblemParameter_ProblemParameterStringValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
864 | ALTER TABLE [dbo].[ProblemParameterStringValue] WITH CHECK ADD CONSTRAINT [FK_ProblemParameter_ProblemParameterStringValue] FOREIGN KEY([ProblemParameterId])
|
---|
865 | REFERENCES [dbo].[ProblemParameter] ([Id])
|
---|
866 | GO
|
---|
867 | ALTER TABLE [dbo].[ProblemParameterStringValue] CHECK CONSTRAINT [FK_ProblemParameter_ProblemParameterStringValue]
|
---|
868 | GO
|
---|
869 | /****** Object: ForeignKey [FK_Problem_ProblemUser] Script Date: 09/25/2010 01:33:11 ******/
|
---|
870 | ALTER TABLE [dbo].[ProblemUser] WITH CHECK ADD CONSTRAINT [FK_Problem_ProblemUser] FOREIGN KEY([ProblemId])
|
---|
871 | REFERENCES [dbo].[Problem] ([Id])
|
---|
872 | ON UPDATE CASCADE
|
---|
873 | ON DELETE CASCADE
|
---|
874 | GO
|
---|
875 | ALTER TABLE [dbo].[ProblemUser] CHECK CONSTRAINT [FK_Problem_ProblemUser]
|
---|
876 | GO
|
---|
877 | /****** Object: ForeignKey [FK_Algorithm_Result] Script Date: 09/25/2010 01:33:11 ******/
|
---|
878 | ALTER TABLE [dbo].[Result] WITH CHECK ADD CONSTRAINT [FK_Algorithm_Result] FOREIGN KEY([AlgorithmId])
|
---|
879 | REFERENCES [dbo].[Algorithm] ([Id])
|
---|
880 | GO
|
---|
881 | ALTER TABLE [dbo].[Result] CHECK CONSTRAINT [FK_Algorithm_Result]
|
---|
882 | GO
|
---|
883 | /****** Object: ForeignKey [FK_DataType_Result] Script Date: 09/25/2010 01:33:11 ******/
|
---|
884 | ALTER TABLE [dbo].[Result] WITH CHECK ADD CONSTRAINT [FK_DataType_Result] FOREIGN KEY([DataTypeId])
|
---|
885 | REFERENCES [dbo].[DataType] ([Id])
|
---|
886 | GO
|
---|
887 | ALTER TABLE [dbo].[Result] CHECK CONSTRAINT [FK_DataType_Result]
|
---|
888 | GO
|
---|
889 | /****** Object: ForeignKey [FK_DataType_ResultBlobValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
890 | ALTER TABLE [dbo].[ResultBlobValue] WITH CHECK ADD CONSTRAINT [FK_DataType_ResultBlobValue] FOREIGN KEY([DataTypeId])
|
---|
891 | REFERENCES [dbo].[DataType] ([Id])
|
---|
892 | GO
|
---|
893 | ALTER TABLE [dbo].[ResultBlobValue] CHECK CONSTRAINT [FK_DataType_ResultBlobValue]
|
---|
894 | GO
|
---|
895 | /****** Object: ForeignKey [FK_Result_ResultBlobValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
896 | ALTER TABLE [dbo].[ResultBlobValue] WITH CHECK ADD CONSTRAINT [FK_Result_ResultBlobValue] FOREIGN KEY([ResultId])
|
---|
897 | REFERENCES [dbo].[Result] ([Id])
|
---|
898 | GO
|
---|
899 | ALTER TABLE [dbo].[ResultBlobValue] CHECK CONSTRAINT [FK_Result_ResultBlobValue]
|
---|
900 | GO
|
---|
901 | /****** Object: ForeignKey [FK_Run_ResultBlobValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
902 | ALTER TABLE [dbo].[ResultBlobValue] WITH CHECK ADD CONSTRAINT [FK_Run_ResultBlobValue] FOREIGN KEY([RunId])
|
---|
903 | REFERENCES [dbo].[Run] ([Id])
|
---|
904 | GO
|
---|
905 | ALTER TABLE [dbo].[ResultBlobValue] CHECK CONSTRAINT [FK_Run_ResultBlobValue]
|
---|
906 | GO
|
---|
907 | /****** Object: ForeignKey [FK_DataType_ResultBoolValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
908 | ALTER TABLE [dbo].[ResultBoolValue] WITH CHECK ADD CONSTRAINT [FK_DataType_ResultBoolValue] FOREIGN KEY([DataTypeId])
|
---|
909 | REFERENCES [dbo].[DataType] ([Id])
|
---|
910 | GO
|
---|
911 | ALTER TABLE [dbo].[ResultBoolValue] CHECK CONSTRAINT [FK_DataType_ResultBoolValue]
|
---|
912 | GO
|
---|
913 | /****** Object: ForeignKey [FK_Result_ResultBoolValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
914 | ALTER TABLE [dbo].[ResultBoolValue] WITH CHECK ADD CONSTRAINT [FK_Result_ResultBoolValue] FOREIGN KEY([ResultId])
|
---|
915 | REFERENCES [dbo].[Result] ([Id])
|
---|
916 | GO
|
---|
917 | ALTER TABLE [dbo].[ResultBoolValue] CHECK CONSTRAINT [FK_Result_ResultBoolValue]
|
---|
918 | GO
|
---|
919 | /****** Object: ForeignKey [FK_Run_ResultBoolValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
920 | ALTER TABLE [dbo].[ResultBoolValue] WITH CHECK ADD CONSTRAINT [FK_Run_ResultBoolValue] FOREIGN KEY([RunId])
|
---|
921 | REFERENCES [dbo].[Run] ([Id])
|
---|
922 | GO
|
---|
923 | ALTER TABLE [dbo].[ResultBoolValue] CHECK CONSTRAINT [FK_Run_ResultBoolValue]
|
---|
924 | GO
|
---|
925 | /****** Object: ForeignKey [FK_DataType_ResultFloatValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
926 | ALTER TABLE [dbo].[ResultFloatValue] WITH CHECK ADD CONSTRAINT [FK_DataType_ResultFloatValue] FOREIGN KEY([DataTypeId])
|
---|
927 | REFERENCES [dbo].[DataType] ([Id])
|
---|
928 | GO
|
---|
929 | ALTER TABLE [dbo].[ResultFloatValue] CHECK CONSTRAINT [FK_DataType_ResultFloatValue]
|
---|
930 | GO
|
---|
931 | /****** Object: ForeignKey [FK_Result_ResultFloatValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
932 | ALTER TABLE [dbo].[ResultFloatValue] WITH CHECK ADD CONSTRAINT [FK_Result_ResultFloatValue] FOREIGN KEY([ResultId])
|
---|
933 | REFERENCES [dbo].[Result] ([Id])
|
---|
934 | GO
|
---|
935 | ALTER TABLE [dbo].[ResultFloatValue] CHECK CONSTRAINT [FK_Result_ResultFloatValue]
|
---|
936 | GO
|
---|
937 | /****** Object: ForeignKey [FK_Run_ResultFloatValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
938 | ALTER TABLE [dbo].[ResultFloatValue] WITH CHECK ADD CONSTRAINT [FK_Run_ResultFloatValue] FOREIGN KEY([RunId])
|
---|
939 | REFERENCES [dbo].[Run] ([Id])
|
---|
940 | GO
|
---|
941 | ALTER TABLE [dbo].[ResultFloatValue] CHECK CONSTRAINT [FK_Run_ResultFloatValue]
|
---|
942 | GO
|
---|
943 | /****** Object: ForeignKey [FK_DataType_ResultIntValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
944 | ALTER TABLE [dbo].[ResultIntValue] WITH CHECK ADD CONSTRAINT [FK_DataType_ResultIntValue] FOREIGN KEY([DataTypeId])
|
---|
945 | REFERENCES [dbo].[DataType] ([Id])
|
---|
946 | GO
|
---|
947 | ALTER TABLE [dbo].[ResultIntValue] CHECK CONSTRAINT [FK_DataType_ResultIntValue]
|
---|
948 | GO
|
---|
949 | /****** Object: ForeignKey [FK_Result_ResultIntValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
950 | ALTER TABLE [dbo].[ResultIntValue] WITH CHECK ADD CONSTRAINT [FK_Result_ResultIntValue] FOREIGN KEY([ResultId])
|
---|
951 | REFERENCES [dbo].[Result] ([Id])
|
---|
952 | GO
|
---|
953 | ALTER TABLE [dbo].[ResultIntValue] CHECK CONSTRAINT [FK_Result_ResultIntValue]
|
---|
954 | GO
|
---|
955 | /****** Object: ForeignKey [FK_Run_ResultIntValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
956 | ALTER TABLE [dbo].[ResultIntValue] WITH CHECK ADD CONSTRAINT [FK_Run_ResultIntValue] FOREIGN KEY([RunId])
|
---|
957 | REFERENCES [dbo].[Run] ([Id])
|
---|
958 | GO
|
---|
959 | ALTER TABLE [dbo].[ResultIntValue] CHECK CONSTRAINT [FK_Run_ResultIntValue]
|
---|
960 | GO
|
---|
961 | /****** Object: ForeignKey [FK_DataType_ResultStringValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
962 | ALTER TABLE [dbo].[ResultStringValue] WITH CHECK ADD CONSTRAINT [FK_DataType_ResultStringValue] FOREIGN KEY([DataTypeId])
|
---|
963 | REFERENCES [dbo].[DataType] ([Id])
|
---|
964 | GO
|
---|
965 | ALTER TABLE [dbo].[ResultStringValue] CHECK CONSTRAINT [FK_DataType_ResultStringValue]
|
---|
966 | GO
|
---|
967 | /****** Object: ForeignKey [FK_Result_ResultStringValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
968 | ALTER TABLE [dbo].[ResultStringValue] WITH CHECK ADD CONSTRAINT [FK_Result_ResultStringValue] FOREIGN KEY([ResultId])
|
---|
969 | REFERENCES [dbo].[Result] ([Id])
|
---|
970 | GO
|
---|
971 | ALTER TABLE [dbo].[ResultStringValue] CHECK CONSTRAINT [FK_Result_ResultStringValue]
|
---|
972 | GO
|
---|
973 | /****** Object: ForeignKey [FK_Run_ResultStringValue] Script Date: 09/25/2010 01:33:11 ******/
|
---|
974 | ALTER TABLE [dbo].[ResultStringValue] WITH CHECK ADD CONSTRAINT [FK_Run_ResultStringValue] FOREIGN KEY([RunId])
|
---|
975 | REFERENCES [dbo].[Run] ([Id])
|
---|
976 | GO
|
---|
977 | ALTER TABLE [dbo].[ResultStringValue] CHECK CONSTRAINT [FK_Run_ResultStringValue]
|
---|
978 | GO
|
---|
979 | /****** Object: ForeignKey [FK_Experiment_Run] Script Date: 09/25/2010 01:33:11 ******/
|
---|
980 | ALTER TABLE [dbo].[Run] WITH CHECK ADD CONSTRAINT [FK_Experiment_Run] FOREIGN KEY([ExperimentId])
|
---|
981 | REFERENCES [dbo].[Experiment] ([Id])
|
---|
982 | GO
|
---|
983 | ALTER TABLE [dbo].[Run] CHECK CONSTRAINT [FK_Experiment_Run]
|
---|
984 | GO
|
---|