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 @ 5698

Visit:

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

Download in other formats: