Context Navigation

close Warning: Can't use blame annotator:
svn blame failed on branches/OKB/HeuristicLab.Services.OKB.DataAccess/3.3/SQL Scripts/Initialize OKB.sql: 195004 - Cannot calculate blame information for binary file 'file:///var/www/vhosts/heuristiclab.com/svn/core/branches/OKB/HeuristicLab.Services.OKB.DataAccess/3.3/SQL%20Scripts/Initialize%20OKB.sql'

Initialize OKB.sql @ 5046

Visit:

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

Rev	Line
	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

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

Context Navigation

source: branches/OKB/HeuristicLab.Services.OKB.DataAccess/3.3/SQL Scripts/Initialize OKB.sql @ 5046

Download in other formats: