1 | USE [HeuristicLab.OKB]
|
---|
2 | GO
|
---|
3 | /****** Object: Table [dbo].[ProblemClass] Script Date: 01/24/2011 03:13:48 ******/
|
---|
4 | SET ANSI_NULLS ON
|
---|
5 | GO
|
---|
6 | SET QUOTED_IDENTIFIER ON
|
---|
7 | GO
|
---|
8 | CREATE TABLE [dbo].[ProblemClass](
|
---|
9 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
10 | [Name] [nvarchar](200) NOT NULL,
|
---|
11 | [Description] [nvarchar](max) NULL,
|
---|
12 | CONSTRAINT [PK_ProblemClass_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_ProblemClass_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].[ProblemClass] ON
|
---|
23 | INSERT [dbo].[ProblemClass] ([Id], [Name], [Description]) VALUES (1, N'Unknown', N'Unknown or undefined problem class.')
|
---|
24 | SET IDENTITY_INSERT [dbo].[ProblemClass] OFF
|
---|
25 | /****** Object: Table [dbo].[BinaryValue] Script Date: 01/24/2011 03:13:48 ******/
|
---|
26 | SET ANSI_NULLS ON
|
---|
27 | GO
|
---|
28 | SET QUOTED_IDENTIFIER ON
|
---|
29 | GO
|
---|
30 | SET ANSI_PADDING ON
|
---|
31 | GO
|
---|
32 | CREATE TABLE [dbo].[BinaryValue](
|
---|
33 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
34 | [Value] [varbinary](max) NOT NULL,
|
---|
35 | CONSTRAINT [PK_BinaryValue_Id] PRIMARY KEY CLUSTERED
|
---|
36 | (
|
---|
37 | [Id] ASC
|
---|
38 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
39 | ) ON [PRIMARY]
|
---|
40 | GO
|
---|
41 | SET ANSI_PADDING OFF
|
---|
42 | GO
|
---|
43 | /****** Object: Table [dbo].[AlgorithmClass] Script Date: 01/24/2011 03:13:48 ******/
|
---|
44 | SET ANSI_NULLS ON
|
---|
45 | GO
|
---|
46 | SET QUOTED_IDENTIFIER ON
|
---|
47 | GO
|
---|
48 | CREATE TABLE [dbo].[AlgorithmClass](
|
---|
49 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
50 | [Name] [nvarchar](200) NOT NULL,
|
---|
51 | [Description] [nvarchar](max) NULL,
|
---|
52 | CONSTRAINT [PK_AlgorithmClass_Id] PRIMARY KEY CLUSTERED
|
---|
53 | (
|
---|
54 | [Id] ASC
|
---|
55 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
|
---|
56 | CONSTRAINT [UQ_AlgorithmClass_Name] UNIQUE NONCLUSTERED
|
---|
57 | (
|
---|
58 | [Name] ASC
|
---|
59 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
60 | ) ON [PRIMARY]
|
---|
61 | GO
|
---|
62 | SET IDENTITY_INSERT [dbo].[AlgorithmClass] ON
|
---|
63 | INSERT [dbo].[AlgorithmClass] ([Id], [Name], [Description]) VALUES (1, N'Unknown', N'Unknown or undefined algorithm class.')
|
---|
64 | SET IDENTITY_INSERT [dbo].[AlgorithmClass] OFF
|
---|
65 | /****** Object: Table [dbo].[Platform] Script Date: 01/24/2011 03:13:48 ******/
|
---|
66 | SET ANSI_NULLS ON
|
---|
67 | GO
|
---|
68 | SET QUOTED_IDENTIFIER ON
|
---|
69 | GO
|
---|
70 | CREATE TABLE [dbo].[Platform](
|
---|
71 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
72 | [Name] [nvarchar](200) NOT NULL,
|
---|
73 | [Description] [nvarchar](max) NULL,
|
---|
74 | CONSTRAINT [PK_Platform_Id] PRIMARY KEY CLUSTERED
|
---|
75 | (
|
---|
76 | [Id] ASC
|
---|
77 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
|
---|
78 | CONSTRAINT [UQ_Platform_Name] UNIQUE NONCLUSTERED
|
---|
79 | (
|
---|
80 | [Name] 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 IDENTITY_INSERT [dbo].[Platform] ON
|
---|
85 | INSERT [dbo].[Platform] ([Id], [Name], [Description]) VALUES (1, N'Unknown', N'Unknown or undefined platform.')
|
---|
86 | INSERT [dbo].[Platform] ([Id], [Name], [Description]) VALUES (2, N'HeuristicLab 3.3', NULL)
|
---|
87 | SET IDENTITY_INSERT [dbo].[Platform] OFF
|
---|
88 | /****** Object: Table [dbo].[DataType] Script Date: 01/24/2011 03:13:48 ******/
|
---|
89 | SET ANSI_NULLS ON
|
---|
90 | GO
|
---|
91 | SET QUOTED_IDENTIFIER ON
|
---|
92 | GO
|
---|
93 | CREATE TABLE [dbo].[DataType](
|
---|
94 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
95 | [PlatformId] [bigint] NOT NULL,
|
---|
96 | [Name] [nvarchar](max) NOT NULL,
|
---|
97 | [TypeName] [nvarchar](max) NOT NULL,
|
---|
98 | CONSTRAINT [PK_DataType_Id] PRIMARY KEY CLUSTERED
|
---|
99 | (
|
---|
100 | [Id] ASC
|
---|
101 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
102 | ) ON [PRIMARY]
|
---|
103 | GO
|
---|
104 | /****** Object: Table [dbo].[Algorithm] Script Date: 01/24/2011 03:13:48 ******/
|
---|
105 | SET ANSI_NULLS ON
|
---|
106 | GO
|
---|
107 | SET QUOTED_IDENTIFIER ON
|
---|
108 | GO
|
---|
109 | CREATE TABLE [dbo].[Algorithm](
|
---|
110 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
111 | [AlgorithmClassId] [bigint] NOT NULL,
|
---|
112 | [PlatformId] [bigint] NOT NULL,
|
---|
113 | [DataTypeId] [bigint] NOT NULL,
|
---|
114 | [BinaryValueId] [bigint] NOT NULL,
|
---|
115 | [Name] [nvarchar](200) NOT NULL,
|
---|
116 | [Description] [nvarchar](max) NULL,
|
---|
117 | CONSTRAINT [PK_Algorithm_Id] PRIMARY KEY CLUSTERED
|
---|
118 | (
|
---|
119 | [Id] ASC
|
---|
120 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
|
---|
121 | CONSTRAINT [UQ_Algorithm_Name_PlatformId] UNIQUE NONCLUSTERED
|
---|
122 | (
|
---|
123 | [Name] ASC,
|
---|
124 | [PlatformId] ASC
|
---|
125 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
126 | ) ON [PRIMARY]
|
---|
127 | GO
|
---|
128 | /****** Object: Table [dbo].[Problem] Script Date: 01/24/2011 03:13:48 ******/
|
---|
129 | SET ANSI_NULLS ON
|
---|
130 | GO
|
---|
131 | SET QUOTED_IDENTIFIER ON
|
---|
132 | GO
|
---|
133 | CREATE TABLE [dbo].[Problem](
|
---|
134 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
135 | [ProblemClassId] [bigint] NOT NULL,
|
---|
136 | [PlatformId] [bigint] NOT NULL,
|
---|
137 | [DataTypeId] [bigint] NOT NULL,
|
---|
138 | [BinaryValueId] [bigint] NOT NULL,
|
---|
139 | [Name] [nvarchar](200) NOT NULL,
|
---|
140 | [Description] [nvarchar](max) NULL,
|
---|
141 | CONSTRAINT [PK_Problem_Id] PRIMARY KEY CLUSTERED
|
---|
142 | (
|
---|
143 | [Id] ASC
|
---|
144 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
|
---|
145 | CONSTRAINT [UQ_Problem_Name_PlatformId] UNIQUE NONCLUSTERED
|
---|
146 | (
|
---|
147 | [Name] ASC,
|
---|
148 | [PlatformId] ASC
|
---|
149 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
150 | ) ON [PRIMARY]
|
---|
151 | GO
|
---|
152 | /****** Object: Table [dbo].[ProblemUser] Script Date: 01/24/2011 03:13:48 ******/
|
---|
153 | SET ANSI_NULLS ON
|
---|
154 | GO
|
---|
155 | SET QUOTED_IDENTIFIER ON
|
---|
156 | GO
|
---|
157 | CREATE TABLE [dbo].[ProblemUser](
|
---|
158 | [ProblemId] [bigint] NOT NULL,
|
---|
159 | [UserId] [uniqueidentifier] NOT NULL,
|
---|
160 | CONSTRAINT [PK_ProblemUser_ProblemId_UserId] PRIMARY KEY CLUSTERED
|
---|
161 | (
|
---|
162 | [ProblemId] ASC,
|
---|
163 | [UserId] ASC
|
---|
164 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
165 | ) ON [PRIMARY]
|
---|
166 | GO
|
---|
167 | /****** Object: Table [dbo].[Experiment] Script Date: 01/24/2011 03:13:48 ******/
|
---|
168 | SET ANSI_NULLS ON
|
---|
169 | GO
|
---|
170 | SET QUOTED_IDENTIFIER ON
|
---|
171 | GO
|
---|
172 | CREATE TABLE [dbo].[Experiment](
|
---|
173 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
174 | [AlgorithmId] [bigint] NOT NULL,
|
---|
175 | [ProblemId] [bigint] NOT NULL,
|
---|
176 | CONSTRAINT [PK_Experiment_Id] PRIMARY KEY CLUSTERED
|
---|
177 | (
|
---|
178 | [Id] ASC
|
---|
179 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
180 | ) ON [PRIMARY]
|
---|
181 | GO
|
---|
182 | CREATE NONCLUSTERED INDEX [IX_Experiment_AlgorithmId_ProblemId] ON [dbo].[Experiment]
|
---|
183 | (
|
---|
184 | [AlgorithmId] ASC,
|
---|
185 | [ProblemId] ASC
|
---|
186 | )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]
|
---|
187 | GO
|
---|
188 | /****** Object: Table [dbo].[AlgorithmUser] Script Date: 01/24/2011 03:13:48 ******/
|
---|
189 | SET ANSI_NULLS ON
|
---|
190 | GO
|
---|
191 | SET QUOTED_IDENTIFIER ON
|
---|
192 | GO
|
---|
193 | CREATE TABLE [dbo].[AlgorithmUser](
|
---|
194 | [AlgorithmId] [bigint] NOT NULL,
|
---|
195 | [UserId] [uniqueidentifier] NOT NULL,
|
---|
196 | CONSTRAINT [PK_AlgorithmUser_AlgorithmId_UserId] PRIMARY KEY CLUSTERED
|
---|
197 | (
|
---|
198 | [AlgorithmId] ASC,
|
---|
199 | [UserId] ASC
|
---|
200 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
201 | ) ON [PRIMARY]
|
---|
202 | GO
|
---|
203 | /****** Object: Table [dbo].[Parameter] Script Date: 01/24/2011 03:13:48 ******/
|
---|
204 | SET ANSI_NULLS ON
|
---|
205 | GO
|
---|
206 | SET QUOTED_IDENTIFIER ON
|
---|
207 | GO
|
---|
208 | CREATE TABLE [dbo].[Parameter](
|
---|
209 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
210 | [ExperimentId] [bigint] NOT NULL,
|
---|
211 | [DataTypeId] [bigint] NOT NULL,
|
---|
212 | [Name] [nvarchar](max) NOT NULL,
|
---|
213 | [BoolValue] [bit] SPARSE NULL,
|
---|
214 | [IntValue] [int] SPARSE NULL,
|
---|
215 | [LongValue] [bigint] SPARSE NULL,
|
---|
216 | [FloatValue] [real] SPARSE NULL,
|
---|
217 | [DoubleValue] [float] SPARSE NULL,
|
---|
218 | [StringValue] [nvarchar](max) SPARSE NULL,
|
---|
219 | [BinaryValueId] [bigint] SPARSE NULL,
|
---|
220 | CONSTRAINT [PK_Parameter_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 | ) ON [PRIMARY]
|
---|
225 | GO
|
---|
226 | /****** Object: Table [dbo].[Run] Script Date: 01/24/2011 03:13:48 ******/
|
---|
227 | SET ANSI_NULLS ON
|
---|
228 | GO
|
---|
229 | SET QUOTED_IDENTIFIER ON
|
---|
230 | GO
|
---|
231 | CREATE TABLE [dbo].[Run](
|
---|
232 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
233 | [ExperimentId] [bigint] NOT NULL,
|
---|
234 | [RandomSeed] [bigint] NOT NULL,
|
---|
235 | [CreatedDate] [datetime2](7) NOT NULL,
|
---|
236 | [UserId] [uniqueidentifier] NOT NULL,
|
---|
237 | [ClientId] [uniqueidentifier] NOT NULL,
|
---|
238 | CONSTRAINT [PK_Run_Id] PRIMARY KEY CLUSTERED
|
---|
239 | (
|
---|
240 | [Id] ASC
|
---|
241 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
242 | ) ON [PRIMARY]
|
---|
243 | GO
|
---|
244 | CREATE NONCLUSTERED INDEX [IX_Run_ExperimentId] ON [dbo].[Run]
|
---|
245 | (
|
---|
246 | [ExperimentId] ASC
|
---|
247 | )
|
---|
248 | INCLUDE ( [Id],
|
---|
249 | [CreatedDate],
|
---|
250 | [UserId],
|
---|
251 | [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]
|
---|
252 | GO
|
---|
253 | /****** Object: Table [dbo].[Result] Script Date: 01/24/2011 03:13:48 ******/
|
---|
254 | SET ANSI_NULLS ON
|
---|
255 | GO
|
---|
256 | SET QUOTED_IDENTIFIER ON
|
---|
257 | GO
|
---|
258 | CREATE TABLE [dbo].[Result](
|
---|
259 | [Id] [bigint] IDENTITY(1,1) NOT NULL,
|
---|
260 | [RunId] [bigint] NOT NULL,
|
---|
261 | [DataTypeId] [bigint] NOT NULL,
|
---|
262 | [Name] [nvarchar](max) NOT NULL,
|
---|
263 | [BoolValue] [bit] SPARSE NULL,
|
---|
264 | [IntValue] [int] SPARSE NULL,
|
---|
265 | [LongValue] [bigint] SPARSE NULL,
|
---|
266 | [FloatValue] [real] SPARSE NULL,
|
---|
267 | [DoubleValue] [float] SPARSE NULL,
|
---|
268 | [StringValue] [nvarchar](max) SPARSE NULL,
|
---|
269 | [BinaryValueId] [bigint] SPARSE NULL,
|
---|
270 | CONSTRAINT [PK_Result_Id] PRIMARY KEY CLUSTERED
|
---|
271 | (
|
---|
272 | [Id] ASC
|
---|
273 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
274 | ) ON [PRIMARY]
|
---|
275 | GO
|
---|
276 | /****** Object: ForeignKey [FK_AlgorithmClass_Algorithm] Script Date: 01/24/2011 03:13:48 ******/
|
---|
277 | ALTER TABLE [dbo].[Algorithm] WITH CHECK ADD CONSTRAINT [FK_AlgorithmClass_Algorithm] FOREIGN KEY([AlgorithmClassId])
|
---|
278 | REFERENCES [dbo].[AlgorithmClass] ([Id])
|
---|
279 | GO
|
---|
280 | ALTER TABLE [dbo].[Algorithm] CHECK CONSTRAINT [FK_AlgorithmClass_Algorithm]
|
---|
281 | GO
|
---|
282 | /****** Object: ForeignKey [FK_BinaryValue_Algorithm] Script Date: 01/24/2011 03:13:48 ******/
|
---|
283 | ALTER TABLE [dbo].[Algorithm] WITH CHECK ADD CONSTRAINT [FK_BinaryValue_Algorithm] FOREIGN KEY([BinaryValueId])
|
---|
284 | REFERENCES [dbo].[BinaryValue] ([Id])
|
---|
285 | GO
|
---|
286 | ALTER TABLE [dbo].[Algorithm] CHECK CONSTRAINT [FK_BinaryValue_Algorithm]
|
---|
287 | GO
|
---|
288 | /****** Object: ForeignKey [FK_DataType_Algorithm] Script Date: 01/24/2011 03:13:48 ******/
|
---|
289 | ALTER TABLE [dbo].[Algorithm] WITH CHECK ADD CONSTRAINT [FK_DataType_Algorithm] FOREIGN KEY([DataTypeId])
|
---|
290 | REFERENCES [dbo].[DataType] ([Id])
|
---|
291 | GO
|
---|
292 | ALTER TABLE [dbo].[Algorithm] CHECK CONSTRAINT [FK_DataType_Algorithm]
|
---|
293 | GO
|
---|
294 | /****** Object: ForeignKey [FK_Platform_Algorithm] Script Date: 01/24/2011 03:13:48 ******/
|
---|
295 | ALTER TABLE [dbo].[Algorithm] WITH CHECK ADD CONSTRAINT [FK_Platform_Algorithm] FOREIGN KEY([PlatformId])
|
---|
296 | REFERENCES [dbo].[Platform] ([Id])
|
---|
297 | GO
|
---|
298 | ALTER TABLE [dbo].[Algorithm] CHECK CONSTRAINT [FK_Platform_Algorithm]
|
---|
299 | GO
|
---|
300 | /****** Object: ForeignKey [FK_Algorithm_AlgorithmUser] Script Date: 01/24/2011 03:13:48 ******/
|
---|
301 | ALTER TABLE [dbo].[AlgorithmUser] WITH CHECK ADD CONSTRAINT [FK_Algorithm_AlgorithmUser] FOREIGN KEY([AlgorithmId])
|
---|
302 | REFERENCES [dbo].[Algorithm] ([Id])
|
---|
303 | ON UPDATE CASCADE
|
---|
304 | ON DELETE CASCADE
|
---|
305 | GO
|
---|
306 | ALTER TABLE [dbo].[AlgorithmUser] CHECK CONSTRAINT [FK_Algorithm_AlgorithmUser]
|
---|
307 | GO
|
---|
308 | /****** Object: ForeignKey [FK_Platform_DataType] Script Date: 01/24/2011 03:13:48 ******/
|
---|
309 | ALTER TABLE [dbo].[DataType] WITH CHECK ADD CONSTRAINT [FK_Platform_DataType] FOREIGN KEY([PlatformId])
|
---|
310 | REFERENCES [dbo].[Platform] ([Id])
|
---|
311 | GO
|
---|
312 | ALTER TABLE [dbo].[DataType] CHECK CONSTRAINT [FK_Platform_DataType]
|
---|
313 | GO
|
---|
314 | /****** Object: ForeignKey [FK_Algorithm_Experiment] Script Date: 01/24/2011 03:13:48 ******/
|
---|
315 | ALTER TABLE [dbo].[Experiment] WITH CHECK ADD CONSTRAINT [FK_Algorithm_Experiment] FOREIGN KEY([AlgorithmId])
|
---|
316 | REFERENCES [dbo].[Algorithm] ([Id])
|
---|
317 | GO
|
---|
318 | ALTER TABLE [dbo].[Experiment] CHECK CONSTRAINT [FK_Algorithm_Experiment]
|
---|
319 | GO
|
---|
320 | /****** Object: ForeignKey [FK_Problem_Experiment] Script Date: 01/24/2011 03:13:48 ******/
|
---|
321 | ALTER TABLE [dbo].[Experiment] WITH CHECK ADD CONSTRAINT [FK_Problem_Experiment] FOREIGN KEY([ProblemId])
|
---|
322 | REFERENCES [dbo].[Problem] ([Id])
|
---|
323 | GO
|
---|
324 | ALTER TABLE [dbo].[Experiment] CHECK CONSTRAINT [FK_Problem_Experiment]
|
---|
325 | GO
|
---|
326 | /****** Object: ForeignKey [FK_BinaryValue_Parameter] Script Date: 01/24/2011 03:13:48 ******/
|
---|
327 | ALTER TABLE [dbo].[Parameter] WITH CHECK ADD CONSTRAINT [FK_BinaryValue_Parameter] FOREIGN KEY([BinaryValueId])
|
---|
328 | REFERENCES [dbo].[BinaryValue] ([Id])
|
---|
329 | GO
|
---|
330 | ALTER TABLE [dbo].[Parameter] CHECK CONSTRAINT [FK_BinaryValue_Parameter]
|
---|
331 | GO
|
---|
332 | /****** Object: ForeignKey [FK_DataType_Parameter] Script Date: 01/24/2011 03:13:48 ******/
|
---|
333 | ALTER TABLE [dbo].[Parameter] WITH CHECK ADD CONSTRAINT [FK_DataType_Parameter] FOREIGN KEY([DataTypeId])
|
---|
334 | REFERENCES [dbo].[DataType] ([Id])
|
---|
335 | GO
|
---|
336 | ALTER TABLE [dbo].[Parameter] CHECK CONSTRAINT [FK_DataType_Parameter]
|
---|
337 | GO
|
---|
338 | /****** Object: ForeignKey [FK_Experiment_Parameter] Script Date: 01/24/2011 03:13:48 ******/
|
---|
339 | ALTER TABLE [dbo].[Parameter] WITH CHECK ADD CONSTRAINT [FK_Experiment_Parameter] FOREIGN KEY([ExperimentId])
|
---|
340 | REFERENCES [dbo].[Experiment] ([Id])
|
---|
341 | GO
|
---|
342 | ALTER TABLE [dbo].[Parameter] CHECK CONSTRAINT [FK_Experiment_Parameter]
|
---|
343 | GO
|
---|
344 | /****** Object: ForeignKey [FK_BinaryValue_Problem] Script Date: 01/24/2011 03:13:48 ******/
|
---|
345 | ALTER TABLE [dbo].[Problem] WITH CHECK ADD CONSTRAINT [FK_BinaryValue_Problem] FOREIGN KEY([BinaryValueId])
|
---|
346 | REFERENCES [dbo].[BinaryValue] ([Id])
|
---|
347 | GO
|
---|
348 | ALTER TABLE [dbo].[Problem] CHECK CONSTRAINT [FK_BinaryValue_Problem]
|
---|
349 | GO
|
---|
350 | /****** Object: ForeignKey [FK_DataType_Problem] Script Date: 01/24/2011 03:13:48 ******/
|
---|
351 | ALTER TABLE [dbo].[Problem] WITH CHECK ADD CONSTRAINT [FK_DataType_Problem] FOREIGN KEY([DataTypeId])
|
---|
352 | REFERENCES [dbo].[DataType] ([Id])
|
---|
353 | GO
|
---|
354 | ALTER TABLE [dbo].[Problem] CHECK CONSTRAINT [FK_DataType_Problem]
|
---|
355 | GO
|
---|
356 | /****** Object: ForeignKey [FK_Platform_Problem] Script Date: 01/24/2011 03:13:48 ******/
|
---|
357 | ALTER TABLE [dbo].[Problem] WITH CHECK ADD CONSTRAINT [FK_Platform_Problem] FOREIGN KEY([PlatformId])
|
---|
358 | REFERENCES [dbo].[Platform] ([Id])
|
---|
359 | GO
|
---|
360 | ALTER TABLE [dbo].[Problem] CHECK CONSTRAINT [FK_Platform_Problem]
|
---|
361 | GO
|
---|
362 | /****** Object: ForeignKey [FK_ProblemClass_Problem] Script Date: 01/24/2011 03:13:48 ******/
|
---|
363 | ALTER TABLE [dbo].[Problem] WITH CHECK ADD CONSTRAINT [FK_ProblemClass_Problem] FOREIGN KEY([ProblemClassId])
|
---|
364 | REFERENCES [dbo].[ProblemClass] ([Id])
|
---|
365 | GO
|
---|
366 | ALTER TABLE [dbo].[Problem] CHECK CONSTRAINT [FK_ProblemClass_Problem]
|
---|
367 | GO
|
---|
368 | /****** Object: ForeignKey [FK_Problem_ProblemUser] Script Date: 01/24/2011 03:13:48 ******/
|
---|
369 | ALTER TABLE [dbo].[ProblemUser] WITH CHECK ADD CONSTRAINT [FK_Problem_ProblemUser] FOREIGN KEY([ProblemId])
|
---|
370 | REFERENCES [dbo].[Problem] ([Id])
|
---|
371 | ON UPDATE CASCADE
|
---|
372 | ON DELETE CASCADE
|
---|
373 | GO
|
---|
374 | ALTER TABLE [dbo].[ProblemUser] CHECK CONSTRAINT [FK_Problem_ProblemUser]
|
---|
375 | GO
|
---|
376 | /****** Object: ForeignKey [FK_BinaryValue_Result] Script Date: 01/24/2011 03:13:48 ******/
|
---|
377 | ALTER TABLE [dbo].[Result] WITH CHECK ADD CONSTRAINT [FK_BinaryValue_Result] FOREIGN KEY([BinaryValueId])
|
---|
378 | REFERENCES [dbo].[BinaryValue] ([Id])
|
---|
379 | GO
|
---|
380 | ALTER TABLE [dbo].[Result] CHECK CONSTRAINT [FK_BinaryValue_Result]
|
---|
381 | GO
|
---|
382 | /****** Object: ForeignKey [FK_DataType_Result] Script Date: 01/24/2011 03:13:48 ******/
|
---|
383 | ALTER TABLE [dbo].[Result] WITH CHECK ADD CONSTRAINT [FK_DataType_Result] FOREIGN KEY([DataTypeId])
|
---|
384 | REFERENCES [dbo].[DataType] ([Id])
|
---|
385 | GO
|
---|
386 | ALTER TABLE [dbo].[Result] CHECK CONSTRAINT [FK_DataType_Result]
|
---|
387 | GO
|
---|
388 | /****** Object: ForeignKey [FK_Run_Result] Script Date: 01/24/2011 03:13:48 ******/
|
---|
389 | ALTER TABLE [dbo].[Result] WITH CHECK ADD CONSTRAINT [FK_Run_Result] FOREIGN KEY([RunId])
|
---|
390 | REFERENCES [dbo].[Run] ([Id])
|
---|
391 | GO
|
---|
392 | ALTER TABLE [dbo].[Result] CHECK CONSTRAINT [FK_Run_Result]
|
---|
393 | GO
|
---|
394 | /****** Object: ForeignKey [FK_Experiment_Run] Script Date: 01/24/2011 03:13:48 ******/
|
---|
395 | ALTER TABLE [dbo].[Run] WITH CHECK ADD CONSTRAINT [FK_Experiment_Run] FOREIGN KEY([ExperimentId])
|
---|
396 | REFERENCES [dbo].[Experiment] ([Id])
|
---|
397 | GO
|
---|
398 | ALTER TABLE [dbo].[Run] CHECK CONSTRAINT [FK_Experiment_Run]
|
---|
399 | GO
|
---|