Context Navigation

close Warning: Can't use blame annotator:
svn blame failed on trunk/sources/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/trunk/sources/HeuristicLab.Services.OKB.DataAccess/3.3/SQL%20Scripts/Initialize%20OKB.sql'

Initialize OKB.sql @ 4277

Visit:

Last change on this file since 4277 was 4277, checked in by swagner, 14 years ago
Added SQL script for creating the OKB database (#1166)
Property svn:mime-type set to `application/octet-stream`
File size: 64.8 KB

Rev	Line
	1	USE [OKB]
	2	GO
	3	/**** Object: Table [dbo].[User] Script Date: 03/09/2010 16:21:40 ****/
	4	SET ANSI_NULLS ON
	5	GO
	6	SET QUOTED_IDENTIFIER ON
	7	GO
	8	SET ANSI_PADDING ON
	9	GO
	10	CREATE TABLE [dbo].[User](
	11	[Id] [uniqueidentifier] NOT NULL DEFAULT NEWID(),
	12	[Name] [varchar](200) NOT NULL,
	13	PRIMARY KEY CLUSTERED
	14	(
	15	[Id] ASC
	16	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
	17	UNIQUE NONCLUSTERED
	18	(
	19	[Name] ASC
	20	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	21	) ON [PRIMARY]
	22	GO
	23	SET ANSI_PADDING OFF
	24	GO
	25	/**** Object: Table [dbo].[SolutionRepresentation] Script Date: 03/09/2010 16:21:40 ****/
	26	SET ANSI_NULLS ON
	27	GO
	28	SET QUOTED_IDENTIFIER ON
	29	GO
	30	SET ANSI_PADDING ON
	31	GO
	32	CREATE TABLE [dbo].[SolutionRepresentation](
	33	[Id] [int] IDENTITY(1,1) NOT NULL,
	34	[Name] [varchar](200) NOT NULL,
	35	[Description] [varchar](max) NULL,
	36	PRIMARY KEY CLUSTERED
	37	(
	38	[Id] ASC
	39	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
	40	UNIQUE NONCLUSTERED
	41	(
	42	[Name] ASC
	43	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	44	) ON [PRIMARY]
	45	GO
	46	SET ANSI_PADDING OFF
	47	GO
	48	/**** Object: Table [dbo].[ProblemClass] Script Date: 03/09/2010 16:21:40 ****/
	49	SET ANSI_NULLS ON
	50	GO
	51	SET QUOTED_IDENTIFIER ON
	52	GO
	53	SET ANSI_PADDING ON
	54	GO
	55	CREATE TABLE [dbo].[ProblemClass](
	56	[Id] [int] IDENTITY(1,1) NOT NULL,
	57	[Name] [varchar](200) NOT NULL,
	58	[Description] [varchar](100) NULL,
	59	PRIMARY KEY CLUSTERED
	60	(
	61	[Id] ASC
	62	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
	63	UNIQUE NONCLUSTERED
	64	(
	65	[Name] ASC
	66	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	67	) ON [PRIMARY]
	68	GO
	69	SET ANSI_PADDING OFF
	70	GO
	71	/**** Object: Table [dbo].[Project] Script Date: 03/09/2010 16:21:40 ****/
	72	SET ANSI_NULLS ON
	73	GO
	74	SET QUOTED_IDENTIFIER ON
	75	GO
	76	SET ANSI_PADDING ON
	77	GO
	78	CREATE TABLE [dbo].[Project](
	79	[Id] [int] IDENTITY(1,1) NOT NULL,
	80	[Name] [varchar](200) NOT NULL,
	81	[Description] [varchar](max) NULL,
	82	PRIMARY KEY CLUSTERED
	83	(
	84	[Id] ASC
	85	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	86	) ON [PRIMARY]
	87	GO
	88	SET ANSI_PADDING OFF
	89	GO
	90	/**** Object: Table [dbo].[DataType] Script Date: 03/09/2010 16:21:40 ****/
	91	SET ANSI_NULLS ON
	92	GO
	93	SET QUOTED_IDENTIFIER ON
	94	GO
	95	SET ANSI_PADDING ON
	96	GO
	97	CREATE TABLE [dbo].[DataType](
	98	[Id] [int] IDENTITY(1,1) NOT NULL,
	99	[SqlName] [varchar](200) NOT NULL,
	100	[ClrName] [varchar](max) NOT NULL,
	101	PRIMARY KEY CLUSTERED
	102	(
	103	[Id] ASC
	104	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	105	) ON [PRIMARY]
	106	GO
	107	SET ANSI_PADDING OFF
	108	GO
	109	SET IDENTITY_INSERT [dbo].[DataType] ON
	110	INSERT [dbo].[DataType] ([Id], [SqlName], [ClrName]) VALUES (1, N'Int', N'System.Int32')
	111	INSERT [dbo].[DataType] ([Id], [SqlName], [ClrName]) VALUES (2, N'Float', N'System.Double')
	112	INSERT [dbo].[DataType] ([Id], [SqlName], [ClrName]) VALUES (3, N'Char', N'System.String')
	113	INSERT [dbo].[DataType] ([Id], [SqlName], [ClrName]) VALUES (4, N'Blob', N'System.Object')
	114	INSERT [dbo].[DataType] ([Id], [SqlName], [ClrName]) VALUES (5, N'BLOB', N'IOperator')
	115	INSERT [dbo].[DataType] ([Id], [SqlName], [ClrName]) VALUES (6, N'Bit', N'System.Boolean')
	116	SET IDENTITY_INSERT [dbo].[DataType] OFF
	117	/**** Object: Table [dbo].[Client] Script Date: 03/09/2010 16:21:40 ****/
	118	SET ANSI_NULLS ON
	119	GO
	120	SET QUOTED_IDENTIFIER ON
	121	GO
	122	SET ANSI_PADDING ON
	123	GO
	124	CREATE TABLE [dbo].[Client](
	125	[Id] [uniqueidentifier] NOT NULL DEFAULT NEWID(),
	126	[Name] [varchar](200) NOT NULL,
	127	PRIMARY KEY CLUSTERED
	128	(
	129	[Id] ASC
	130	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
	131	UNIQUE NONCLUSTERED
	132	(
	133	[Name] ASC
	134	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	135	) ON [PRIMARY]
	136	GO
	137	SET ANSI_PADDING OFF
	138	GO
	139	/**** Object: Table [dbo].[AlgorithmClass] Script Date: 03/09/2010 16:21:40 ****/
	140	SET ANSI_NULLS ON
	141	GO
	142	SET QUOTED_IDENTIFIER ON
	143	GO
	144	SET ANSI_PADDING ON
	145	GO
	146	CREATE TABLE [dbo].[AlgorithmClass](
	147	[Id] [int] IDENTITY(1,1) NOT NULL,
	148	[Name] [varchar](200) NOT NULL,
	149	[Description] [varchar](max) NULL,
	150	PRIMARY KEY CLUSTERED
	151	(
	152	[Id] ASC
	153	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
	154	UNIQUE NONCLUSTERED
	155	(
	156	[Name] ASC
	157	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	158	) ON [PRIMARY]
	159	GO
	160	SET ANSI_PADDING OFF
	161	GO
	162	/**** Object: Table [dbo].[Platform] Script Date: 03/09/2010 16:21:40 ****/
	163	SET ANSI_NULLS ON
	164	GO
	165	SET QUOTED_IDENTIFIER ON
	166	GO
	167	SET ANSI_PADDING ON
	168	GO
	169	CREATE TABLE [dbo].[Platform](
	170	[Id] [int] IDENTITY(1,1) NOT NULL,
	171	[Name] [varchar](200) NOT NULL,
	172	[Description] [varchar](max) NULL,
	173	PRIMARY KEY CLUSTERED
	174	(
	175	[Id] ASC
	176	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
	177	UNIQUE NONCLUSTERED
	178	(
	179	[Name] ASC
	180	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	181	) ON [PRIMARY]
	182	GO
	183	SET ANSI_PADDING OFF
	184	GO
	185	SET IDENTITY_INSERT [dbo].[Platform] ON
	186	INSERT [dbo].[Platform] ([Id], [Name], [Description]) VALUES (1, N'HL 2.5', N'HeuristicLab 2.5')
	187	INSERT [dbo].[Platform] ([Id], [Name], [Description]) VALUES (2, N'HL 3.3', N'HeuristicLab 3.3')
	188	SET IDENTITY_INSERT [dbo].[Platform] OFF
	189	/**** Object: Table [dbo].[Parameter] Script Date: 03/09/2010 16:21:40 ****/
	190	SET ANSI_NULLS ON
	191	GO
	192	SET QUOTED_IDENTIFIER ON
	193	GO
	194	SET ANSI_PADDING ON
	195	GO
	196	CREATE TABLE [dbo].[Parameter](
	197	[Id] [int] IDENTITY(1,1) NOT NULL,
	198	[Name] [varchar](900) NULL,
	199	[Description] [varchar](max) NULL,
	200	[DataTypeId] [int] NOT NULL,
	201	PRIMARY KEY CLUSTERED
	202	(
	203	[Id] ASC
	204	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
	205	UNIQUE NONCLUSTERED
	206	(
	207	[Name] ASC
	208	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	209	) ON [PRIMARY]
	210	GO
	211	SET ANSI_PADDING OFF
	212	GO
	213	/**** Object: Table [dbo].[Algorithm] Script Date: 03/09/2010 16:21:40 ****/
	214	SET ANSI_NULLS ON
	215	GO
	216	SET QUOTED_IDENTIFIER ON
	217	GO
	218	SET ANSI_PADDING ON
	219	GO
	220	CREATE TABLE [dbo].[Algorithm](
	221	[Id] [int] IDENTITY(1,1) NOT NULL,
	222	[AlgorithmClassId] [int] NOT NULL,
	223	[PlatformId] [int] NOT NULL,
	224	[Name] [varchar](200) NOT NULL,
	225	[Description] [varchar](max) NULL,
	226	PRIMARY KEY CLUSTERED
	227	(
	228	[Id] ASC
	229	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
	230	UNIQUE NONCLUSTERED
	231	(
	232	[Name] ASC
	233	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	234	) ON [PRIMARY]
	235	GO
	236	SET ANSI_PADDING OFF
	237	GO
	238	/**** Object: Table [dbo].[Result] Script Date: 03/09/2010 16:21:40 ****/
	239	SET ANSI_NULLS ON
	240	GO
	241	SET QUOTED_IDENTIFIER ON
	242	GO
	243	SET ANSI_PADDING ON
	244	GO
	245	CREATE TABLE [dbo].[Result](
	246	[Id] [int] IDENTITY(1,1) NOT NULL,
	247	[Name] [varchar](200) NOT NULL,
	248	[Description] [varchar](max) NULL,
	249	[DataTypeId] [int] NOT NULL,
	250	PRIMARY KEY CLUSTERED
	251	(
	252	[Id] ASC
	253	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
	254	UNIQUE NONCLUSTERED
	255	(
	256	[Name] ASC
	257	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	258	) ON [PRIMARY]
	259	GO
	260	SET ANSI_PADDING OFF
	261	GO
	262	/**** Object: Table [dbo].[Problem] Script Date: 03/09/2010 16:21:40 ****/
	263	SET ANSI_NULLS ON
	264	GO
	265	SET QUOTED_IDENTIFIER ON
	266	GO
	267	SET ANSI_PADDING ON
	268	GO
	269	CREATE TABLE [dbo].[Problem](
	270	[Id] [int] IDENTITY(1,1) NOT NULL,
	271	[ProblemClassId] [int] NOT NULL,
	272	[PlatformId] [int] NOT NULL,
	273	[SolutionRepresentationid] [int] NOT NULL,
	274	[Name] [varchar](200) NOT NULL,
	275	[Description] [varchar](max) NULL,
	276	PRIMARY KEY CLUSTERED
	277	(
	278	[Id] ASC
	279	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
	280	UNIQUE NONCLUSTERED
	281	(
	282	[Name] ASC
	283	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	284	) ON [PRIMARY]
	285	GO
	286	SET ANSI_PADDING OFF
	287	GO
	288	/**** Object: Table [dbo].[ProblemCharacteristic] Script Date: 03/09/2010 16:21:40 ****/
	289	SET ANSI_NULLS ON
	290	GO
	291	SET QUOTED_IDENTIFIER ON
	292	GO
	293	SET ANSI_PADDING ON
	294	GO
	295	CREATE TABLE [dbo].[ProblemCharacteristic](
	296	[Id] [int] IDENTITY(1,1) NOT NULL,
	297	[Name] [varchar](200) NOT NULL,
	298	[Description] [varchar](max) NULL,
	299	[DataTypeId] [int] NOT NULL,
	300	PRIMARY KEY CLUSTERED
	301	(
	302	[Id] ASC
	303	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
	304	UNIQUE NONCLUSTERED
	305	(
	306	[Name] ASC
	307	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	308	) ON [PRIMARY]
	309	GO
	310	SET ANSI_PADDING OFF
	311	GO
	312	/**** Object: Table [dbo].[Problem_Parameter] Script Date: 03/09/2010 16:21:40 ****/
	313	SET ANSI_NULLS ON
	314	GO
	315	SET QUOTED_IDENTIFIER ON
	316	GO
	317	CREATE TABLE [dbo].[Problem_Parameter](
	318	[ProblemId] [int] NOT NULL,
	319	[ParameterId] [int] NOT NULL,
	320	PRIMARY KEY CLUSTERED
	321	(
	322	[ProblemId] ASC,
	323	[ParameterId] ASC
	324	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	325	) ON [PRIMARY]
	326	GO
	327	/**** Object: Table [dbo].[ProblemData] Script Date: 03/09/2010 16:21:40 ****/
	328	SET ANSI_NULLS ON
	329	GO
	330	SET QUOTED_IDENTIFIER ON
	331	GO
	332	SET ANSI_PADDING ON
	333	GO
	334	CREATE TABLE [dbo].[ProblemData](
	335	[ProblemId] [int] NOT NULL,
	336	[Data] [varbinary](max) NOT NULL,
	337	PRIMARY KEY CLUSTERED
	338	(
	339	[ProblemId] ASC
	340	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	341	) ON [PRIMARY] TEXTIMAGE_ON [DATA]
	342	GO
	343	SET ANSI_PADDING OFF
	344	GO
	345	/**** Object: Table [dbo].[IntProblemCharacteristicValue] Script Date: 03/09/2010 16:21:40 ****/
	346	SET ANSI_NULLS ON
	347	GO
	348	SET QUOTED_IDENTIFIER ON
	349	GO
	350	CREATE TABLE [dbo].[IntProblemCharacteristicValue](
	351	[ProblemCharacteristicId] [int] NOT NULL,
	352	[ProblemId] [int] NOT NULL,
	353	[Value] [int] NOT NULL,
	354	PRIMARY KEY CLUSTERED
	355	(
	356	[ProblemCharacteristicId] ASC,
	357	[ProblemId] ASC
	358	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	359	) ON [PRIMARY]
	360	GO
	361	/**** Object: Table [dbo].[AlgorithmData] Script Date: 03/09/2010 16:21:40 ****/
	362	SET ANSI_NULLS ON
	363	GO
	364	SET QUOTED_IDENTIFIER ON
	365	GO
	366	SET ANSI_PADDING ON
	367	GO
	368	CREATE TABLE [dbo].[AlgorithmData](
	369	[AlgorithmId] [int] NOT NULL,
	370	[Data] [varbinary](max) NOT NULL,
	371	PRIMARY KEY CLUSTERED
	372	(
	373	[AlgorithmId] ASC
	374	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	375	) ON [PRIMARY] TEXTIMAGE_ON [DATA]
	376	GO
	377	SET ANSI_PADDING OFF
	378	GO
	379	/**** Object: Table [dbo].[Algorithm_Result] Script Date: 03/09/2010 16:21:40 ****/
	380	SET ANSI_NULLS ON
	381	GO
	382	SET QUOTED_IDENTIFIER ON
	383	GO
	384	CREATE TABLE [dbo].[Algorithm_Result](
	385	[AlgorithmId] [int] NOT NULL,
	386	[ResultId] [int] NOT NULL,
	387	PRIMARY KEY CLUSTERED
	388	(
	389	[AlgorithmId] ASC,
	390	[ResultId] 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].[Algorithm_Parameter] Script Date: 03/09/2010 16:21:40 ****/
	395	SET ANSI_NULLS ON
	396	GO
	397	SET QUOTED_IDENTIFIER ON
	398	GO
	399	CREATE TABLE [dbo].[Algorithm_Parameter](
	400	[AlgorithmId] [int] NOT NULL,
	401	[ParameterId] [int] NOT NULL,
	402	PRIMARY KEY CLUSTERED
	403	(
	404	[AlgorithmId] ASC,
	405	[ParameterId] ASC
	406	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	407	) ON [PRIMARY]
	408	GO
	409	/**** Object: Table [dbo].[Experiment] Script Date: 03/09/2010 16:21:40 ****/
	410	SET ANSI_NULLS ON
	411	GO
	412	SET QUOTED_IDENTIFIER ON
	413	GO
	414	CREATE TABLE [dbo].[Experiment](
	415	[Id] [int] IDENTITY(1,1) NOT NULL,
	416	[ProjectId] [int] NOT NULL,
	417	[AlgorithmId] [int] NOT NULL,
	418	[ProblemId] [int] NOT NULL,
	419	PRIMARY KEY CLUSTERED
	420	(
	421	[Id] ASC
	422	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	423	) ON [PRIMARY]
	424	GO
	425	CREATE NONCLUSTERED INDEX [FullExperimentIndex] ON [dbo].[Experiment]
	426	(
	427	[ProjectId] ASC,
	428	[AlgorithmId] ASC,
	429	[ProblemId] ASC
	430	)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]
	431	GO
	432	CREATE NONCLUSTERED INDEX [SimpleExperiementIndex] ON [dbo].[Experiment]
	433	(
	434	[AlgorithmId] ASC,
	435	[ProblemId] ASC
	436	)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]
	437	GO
	438	/**** Object: Table [dbo].[CharProblemCharacteristicValue] Script Date: 03/09/2010 16:21:40 ****/
	439	SET ANSI_NULLS ON
	440	GO
	441	SET QUOTED_IDENTIFIER ON
	442	GO
	443	SET ANSI_PADDING ON
	444	GO
	445	CREATE TABLE [dbo].[CharProblemCharacteristicValue](
	446	[ProblemCharacteristicId] [int] NOT NULL,
	447	[ProblemId] [int] NOT NULL,
	448	[Value] [varchar](max) NOT NULL,
	449	PRIMARY KEY CLUSTERED
	450	(
	451	[ProblemCharacteristicId] ASC,
	452	[ProblemId] ASC
	453	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	454	) ON [PRIMARY]
	455	GO
	456	SET ANSI_PADDING OFF
	457	GO
	458	/**** Object: Table [dbo].[FloatProblemCharacteristicValue] Script Date: 03/09/2010 16:21:40 ****/
	459	SET ANSI_NULLS ON
	460	GO
	461	SET QUOTED_IDENTIFIER ON
	462	GO
	463	CREATE TABLE [dbo].[FloatProblemCharacteristicValue](
	464	[ProblemCharacteristicId] [int] NOT NULL,
	465	[ProblemId] [int] NOT NULL,
	466	[Value] [float] NOT NULL,
	467	PRIMARY KEY CLUSTERED
	468	(
	469	[ProblemCharacteristicId] ASC,
	470	[ProblemId] ASC
	471	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	472	) ON [PRIMARY]
	473	GO
	474	/**** Object: Table [dbo].[FloatParameterValue] Script Date: 03/09/2010 16:21:40 ****/
	475	SET ANSI_NULLS ON
	476	GO
	477	SET QUOTED_IDENTIFIER ON
	478	GO
	479	CREATE TABLE [dbo].[FloatParameterValue](
	480	[ParameterId] [int] NOT NULL,
	481	[ExperimentId] [int] NOT NULL,
	482	[Value] [float] NOT NULL,
	483	PRIMARY KEY CLUSTERED
	484	(
	485	[ParameterId] ASC,
	486	[ExperimentId] ASC
	487	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	488	) ON [PRIMARY]
	489	GO
	490	/**** Object: Table [dbo].[ExperimentCreator] Script Date: 03/09/2010 16:21:40 ****/
	491	SET ANSI_NULLS ON
	492	GO
	493	SET QUOTED_IDENTIFIER ON
	494	GO
	495	CREATE TABLE [dbo].[ExperimentCreator](
	496	[ExperimentId] [int] NOT NULL,
	497	[UserId] [uniqueidentifier] NOT NULL,
	498	PRIMARY KEY CLUSTERED
	499	(
	500	[ExperimentId] ASC,
	501	[UserId] ASC
	502	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	503	) ON [PRIMARY]
	504	GO
	505	/**** Object: Table [dbo].[CharParameterValue] Script Date: 03/09/2010 16:21:40 ****/
	506	SET ANSI_NULLS ON
	507	GO
	508	SET QUOTED_IDENTIFIER ON
	509	GO
	510	SET ANSI_PADDING ON
	511	GO
	512	CREATE TABLE [dbo].[CharParameterValue](
	513	[ParameterId] [int] NOT NULL,
	514	[ExperimentId] [int] NOT NULL,
	515	[Value] [varchar](max) NOT NULL,
	516	PRIMARY KEY CLUSTERED
	517	(
	518	[ParameterId] ASC,
	519	[ExperimentId] ASC
	520	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	521	) ON [PRIMARY]
	522	GO
	523	SET ANSI_PADDING OFF
	524	GO
	525	/**** Object: Table [dbo].[OperatorParameterValue] Script Date: 03/09/2010 16:21:40 ****/
	526	SET ANSI_NULLS ON
	527	GO
	528	SET QUOTED_IDENTIFIER ON
	529	GO
	530	SET ANSI_PADDING ON
	531	GO
	532	CREATE TABLE [dbo].[OperatorParameterValue](
	533	[ParameterId] [int] NOT NULL,
	534	[ExperimentId] [int] NOT NULL,
	535	[Value] [varbinary](max) NOT NULL,
	536	[DataTypeId] [int] NOT NULL,
	537	PRIMARY KEY CLUSTERED
	538	(
	539	[ParameterId] ASC,
	540	[ExperimentId] 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] TEXTIMAGE_ON [DATA]
	543	GO
	544	SET ANSI_PADDING OFF
	545	GO
	546	/**** Object: Table [dbo].[Run] Script Date: 03/09/2010 16:21:40 ****/
	547	SET ANSI_NULLS ON
	548	GO
	549	SET QUOTED_IDENTIFIER ON
	550	GO
	551	CREATE TABLE [dbo].[Run](
	552	[Id] [int] IDENTITY(1,1) NOT NULL,
	553	[ExperimentId] [int] NOT NULL,
	554	[FinishedDate] [datetime2](7) NULL,
	555	[UserId] [uniqueidentifier] NOT NULL,
	556	[ClientId] [uniqueidentifier] NOT NULL,
	557	PRIMARY KEY CLUSTERED
	558	(
	559	[Id] ASC
	560	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	561	) ON [PRIMARY]
	562	GO
	563	CREATE NONCLUSTERED INDEX [Run_FullIndex] ON [dbo].[Run]
	564	(
	565	[ExperimentId] ASC
	566	)
	567	INCLUDE ( [Id],
	568	[FinishedDate],
	569	[UserId],
	570	[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]
	571	GO
	572	/**** Object: Table [dbo].[IntParameterValue] Script Date: 03/09/2010 16:21:40 ****/
	573	SET ANSI_NULLS ON
	574	GO
	575	SET QUOTED_IDENTIFIER ON
	576	GO
	577	CREATE TABLE [dbo].[IntParameterValue](
	578	[ParameterId] [int] NOT NULL,
	579	[ExperimentId] [int] NOT NULL,
	580	[Value] [int] NOT NULL,
	581	PRIMARY KEY CLUSTERED
	582	(
	583	[ParameterId] ASC,
	584	[ExperimentId] ASC
	585	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	586	) ON [PRIMARY]
	587	GO
	588	/**** Object: Table [dbo].[FloatResultValue] Script Date: 03/09/2010 16:21:40 ****/
	589	SET ANSI_NULLS ON
	590	GO
	591	SET QUOTED_IDENTIFIER ON
	592	GO
	593	CREATE TABLE [dbo].[FloatResultValue](
	594	[ResultId] [int] NOT NULL,
	595	[RunId] [int] NOT NULL,
	596	[Value] [float] NOT NULL,
	597	PRIMARY KEY CLUSTERED
	598	(
	599	[ResultId] ASC,
	600	[RunId] ASC
	601	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	602	) ON [PRIMARY]
	603	GO
	604	/**** Object: Table [dbo].[IntResultValue] Script Date: 03/09/2010 16:21:40 ****/
	605	SET ANSI_NULLS ON
	606	GO
	607	SET QUOTED_IDENTIFIER ON
	608	GO
	609	CREATE TABLE [dbo].[IntResultValue](
	610	[ResultId] [int] NOT NULL,
	611	[RunId] [int] NOT NULL,
	612	[Value] [int] NOT NULL,
	613	PRIMARY KEY CLUSTERED
	614	(
	615	[ResultId] ASC,
	616	[RunId] ASC
	617	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	618	) ON [PRIMARY]
	619	GO
	620	/**** Object: Table [dbo].[BlobResultValue] Script Date: 03/09/2010 16:21:40 ****/
	621	SET ANSI_NULLS ON
	622	GO
	623	SET QUOTED_IDENTIFIER ON
	624	GO
	625	SET ANSI_PADDING ON
	626	GO
	627	CREATE TABLE [dbo].[BlobResultValue](
	628	[ResultId] [int] NOT NULL,
	629	[RunId] [int] NOT NULL,
	630	[Value] [varbinary](max) NOT NULL,
	631	PRIMARY KEY CLUSTERED
	632	(
	633	[ResultId] ASC,
	634	[RunId] ASC
	635	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	636	) ON [PRIMARY]
	637	GO
	638	SET ANSI_PADDING OFF
	639	GO
	640	/**** Object: Table [dbo].[CharResultValue] Script Date: 03/09/2010 16:21:40 ****/
	641	SET ANSI_NULLS ON
	642	GO
	643	SET QUOTED_IDENTIFIER ON
	644	GO
	645	SET ANSI_PADDING ON
	646	GO
	647	CREATE TABLE [dbo].[CharResultValue](
	648	[ResultId] [int] NOT NULL,
	649	[RunId] [int] NOT NULL,
	650	[Value] [varchar](max) NOT NULL,
	651	PRIMARY KEY CLUSTERED
	652	(
	653	[ResultId] ASC,
	654	[RunId] ASC
	655	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	656	) ON [PRIMARY]
	657	GO
	658	SET ANSI_PADDING OFF
	659	GO
	660	/**** Object: Check [CK__DataType__014935CB] Script Date: 03/09/2010 16:21:40 ****/
	661	ALTER TABLE [dbo].[DataType] WITH CHECK ADD CONSTRAINT [CK__DataType__014935CB] CHECK (([SqlName]='Int' AND [ClrName]='System.Int32' OR [SqlName]='Float' AND [ClrName]='System.Double' OR [SqlName]='Char' AND [ClrName]='System.String' OR [SqlName]='Bit' AND [ClrName]='System.Boolean' OR [SqlName]='BLOB' AND NOT ([ClrName]='System.String' OR [ClrName]='System.Double' OR [ClrName]='System.Int32' OR [ClrName]='System.Boolean')))
	662	GO
	663	ALTER TABLE [dbo].[DataType] CHECK CONSTRAINT [CK__DataType__014935CB]
	664	GO
	665	/**** Object: ForeignKey [FK__Algorithm__Algor__164452B1] Script Date: 03/09/2010 16:21:40 ****/
	666	ALTER TABLE [dbo].[Algorithm] WITH CHECK ADD FOREIGN KEY([AlgorithmClassId])
	667	REFERENCES [dbo].[AlgorithmClass] ([Id])
	668	GO
	669	/**** Object: ForeignKey [FK__Algorithm__Platf__173876EA] Script Date: 03/09/2010 16:21:40 ****/
	670	ALTER TABLE [dbo].[Algorithm] WITH CHECK ADD FOREIGN KEY([PlatformId])
	671	REFERENCES [dbo].[Platform] ([Id])
	672	GO
	673	/**** Object: ForeignKey [FK__Algorithm__Algor__7B5B524B] Script Date: 03/09/2010 16:21:40 ****/
	674	ALTER TABLE [dbo].[Algorithm_Parameter] WITH CHECK ADD FOREIGN KEY([AlgorithmId])
	675	REFERENCES [dbo].[Algorithm] ([Id])
	676	GO
	677	/**** Object: ForeignKey [FK__Algorithm__Param__7C4F7684] Script Date: 03/09/2010 16:21:40 ****/
	678	ALTER TABLE [dbo].[Algorithm_Parameter] WITH CHECK ADD FOREIGN KEY([ParameterId])
	679	REFERENCES [dbo].[Parameter] ([Id])
	680	ON UPDATE CASCADE
	681	ON DELETE CASCADE
	682	GO
	683	/**** Object: ForeignKey [FK__Algorithm__Algor__25518C17] Script Date: 03/09/2010 16:21:40 ****/
	684	ALTER TABLE [dbo].[Algorithm_Result] WITH CHECK ADD FOREIGN KEY([AlgorithmId])
	685	REFERENCES [dbo].[Algorithm] ([Id])
	686	GO
	687	/**** Object: ForeignKey [FK__Algorithm__Resul__2645B050] Script Date: 03/09/2010 16:21:40 ****/
	688	ALTER TABLE [dbo].[Algorithm_Result] WITH CHECK ADD FOREIGN KEY([ResultId])
	689	REFERENCES [dbo].[Result] ([Id])
	690	ON UPDATE CASCADE
	691	ON DELETE CASCADE
	692	GO
	693	/**** Object: ForeignKey [FK__Algorithm__Algor__1BFD2C07] Script Date: 03/09/2010 16:21:40 ****/
	694	ALTER TABLE [dbo].[AlgorithmData] WITH CHECK ADD FOREIGN KEY([AlgorithmId])
	695	REFERENCES [dbo].[Algorithm] ([Id])
	696	ON UPDATE CASCADE
	697	ON DELETE CASCADE
	698	GO
	699	/**** Object: ForeignKey [FK__BlobResul__Resul__1F98B2C1] Script Date: 03/09/2010 16:21:40 ****/
	700	ALTER TABLE [dbo].[BlobResultValue] WITH CHECK ADD FOREIGN KEY([ResultId])
	701	REFERENCES [dbo].[Result] ([Id])
	702	GO
	703	/**** Object: ForeignKey [FK__BlobResul__RunId__208CD6FA] Script Date: 03/09/2010 16:21:40 ****/
	704	ALTER TABLE [dbo].[BlobResultValue] WITH CHECK ADD FOREIGN KEY([RunId])
	705	REFERENCES [dbo].[Run] ([Id])
	706	ON UPDATE CASCADE
	707	ON DELETE CASCADE
	708	GO
	709	/**** Object: ForeignKey [FK__CharParam__Exper__76969D2E] Script Date: 03/09/2010 16:21:40 ****/
	710	ALTER TABLE [dbo].[CharParameterValue] WITH CHECK ADD FOREIGN KEY([ExperimentId])
	711	REFERENCES [dbo].[Experiment] ([Id])
	712	ON UPDATE CASCADE
	713	ON DELETE CASCADE
	714	GO
	715	/**** Object: ForeignKey [FK__CharParam__Param__75A278F5] Script Date: 03/09/2010 16:21:40 ****/
	716	ALTER TABLE [dbo].[CharParameterValue] WITH CHECK ADD FOREIGN KEY([ParameterId])
	717	REFERENCES [dbo].[Parameter] ([Id])
	718	GO
	719	/**** Object: ForeignKey [FK__CharProbl__Probl__3E1D39E1] Script Date: 03/09/2010 16:21:40 ****/
	720	ALTER TABLE [dbo].[CharProblemCharacteristicValue] WITH CHECK ADD FOREIGN KEY([ProblemCharacteristicId])
	721	REFERENCES [dbo].[ProblemCharacteristic] ([Id])
	722	GO
	723	/**** Object: ForeignKey [FK__CharProbl__Probl__3F115E1A] Script Date: 03/09/2010 16:21:40 ****/
	724	ALTER TABLE [dbo].[CharProblemCharacteristicValue] WITH CHECK ADD FOREIGN KEY([ProblemId])
	725	REFERENCES [dbo].[Problem] ([Id])
	726	ON UPDATE CASCADE
	727	ON DELETE CASCADE
	728	GO
	729	/**** Object: ForeignKey [FK__CharResul__Resul__19DFD96B] Script Date: 03/09/2010 16:21:40 ****/
	730	ALTER TABLE [dbo].[CharResultValue] WITH CHECK ADD FOREIGN KEY([ResultId])
	731	REFERENCES [dbo].[Result] ([Id])
	732	GO
	733	/**** Object: ForeignKey [FK__CharResul__RunId__1AD3FDA4] Script Date: 03/09/2010 16:21:40 ****/
	734	ALTER TABLE [dbo].[CharResultValue] WITH CHECK ADD FOREIGN KEY([RunId])
	735	REFERENCES [dbo].[Run] ([Id])
	736	ON UPDATE CASCADE
	737	ON DELETE CASCADE
	738	GO
	739	/**** Object: ForeignKey [FK__Experimen__Algor__5070F446] Script Date: 03/09/2010 16:21:40 ****/
	740	ALTER TABLE [dbo].[Experiment] WITH CHECK ADD FOREIGN KEY([AlgorithmId])
	741	REFERENCES [dbo].[Algorithm] ([Id])
	742	ON UPDATE CASCADE
	743	ON DELETE CASCADE
	744	GO
	745	/**** Object: ForeignKey [FK__Experimen__Probl__5165187F] Script Date: 03/09/2010 16:21:40 ****/
	746	ALTER TABLE [dbo].[Experiment] WITH CHECK ADD FOREIGN KEY([ProblemId])
	747	REFERENCES [dbo].[Problem] ([Id])
	748	ON UPDATE CASCADE
	749	ON DELETE CASCADE
	750	GO
	751	/**** Object: ForeignKey [FK__Experimen__Proje__4F7CD00D] Script Date: 03/09/2010 16:21:40 ****/
	752	ALTER TABLE [dbo].[Experiment] WITH CHECK ADD FOREIGN KEY([ProjectId])
	753	REFERENCES [dbo].[Project] ([Id])
	754	ON UPDATE CASCADE
	755	ON DELETE CASCADE
	756	GO
	757	/**** Object: ForeignKey [FK__Experimen__Exper__5629CD9C] Script Date: 03/09/2010 16:21:40 ****/
	758	ALTER TABLE [dbo].[ExperimentCreator] WITH CHECK ADD FOREIGN KEY([ExperimentId])
	759	REFERENCES [dbo].[Experiment] ([Id])
	760	ON UPDATE CASCADE
	761	ON DELETE CASCADE
	762	GO
	763	/**** Object: ForeignKey [FK__Experimen__UserI__571DF1D5] Script Date: 03/09/2010 16:21:40 ****/
	764	ALTER TABLE [dbo].[ExperimentCreator] WITH CHECK ADD FOREIGN KEY([UserId])
	765	REFERENCES [dbo].[User] ([Id])
	766	GO
	767	/**** Object: ForeignKey [FK__FloatPara__Exper__70DDC3D8] Script Date: 03/09/2010 16:21:40 ****/
	768	ALTER TABLE [dbo].[FloatParameterValue] WITH CHECK ADD FOREIGN KEY([ExperimentId])
	769	REFERENCES [dbo].[Experiment] ([Id])
	770	ON UPDATE CASCADE
	771	ON DELETE CASCADE
	772	GO
	773	/**** Object: ForeignKey [FK__FloatPara__Param__6FE99F9F] Script Date: 03/09/2010 16:21:40 ****/
	774	ALTER TABLE [dbo].[FloatParameterValue] WITH CHECK ADD FOREIGN KEY([ParameterId])
	775	REFERENCES [dbo].[Parameter] ([Id])
	776	GO
	777	/**** Object: ForeignKey [FK__FloatProb__Probl__3864608B] Script Date: 03/09/2010 16:21:40 ****/
	778	ALTER TABLE [dbo].[FloatProblemCharacteristicValue] WITH CHECK ADD FOREIGN KEY([ProblemCharacteristicId])
	779	REFERENCES [dbo].[ProblemCharacteristic] ([Id])
	780	GO
	781	/**** Object: ForeignKey [FK__FloatProb__Probl__395884C4] Script Date: 03/09/2010 16:21:40 ****/
	782	ALTER TABLE [dbo].[FloatProblemCharacteristicValue] WITH CHECK ADD FOREIGN KEY([ProblemId])
	783	REFERENCES [dbo].[Problem] ([Id])
	784	ON UPDATE CASCADE
	785	ON DELETE CASCADE
	786	GO
	787	/**** Object: ForeignKey [FK__FloatResu__Resul__14270015] Script Date: 03/09/2010 16:21:40 ****/
	788	ALTER TABLE [dbo].[FloatResultValue] WITH CHECK ADD FOREIGN KEY([ResultId])
	789	REFERENCES [dbo].[Result] ([Id])
	790	GO
	791	/**** Object: ForeignKey [FK__FloatResu__RunId__151B244E] Script Date: 03/09/2010 16:21:40 ****/
	792	ALTER TABLE [dbo].[FloatResultValue] WITH CHECK ADD FOREIGN KEY([RunId])
	793	REFERENCES [dbo].[Run] ([Id])
	794	ON UPDATE CASCADE
	795	ON DELETE CASCADE
	796	GO
	797	/**** Object: ForeignKey [FK__IntParame__Exper__6B24EA82] Script Date: 03/09/2010 16:21:40 ****/
	798	ALTER TABLE [dbo].[IntParameterValue] WITH CHECK ADD FOREIGN KEY([ExperimentId])
	799	REFERENCES [dbo].[Experiment] ([Id])
	800	ON UPDATE CASCADE
	801	ON DELETE CASCADE
	802	GO
	803	/**** Object: ForeignKey [FK__IntParame__Param__6A30C649] Script Date: 03/09/2010 16:21:40 ****/
	804	ALTER TABLE [dbo].[IntParameterValue] WITH CHECK ADD FOREIGN KEY([ParameterId])
	805	REFERENCES [dbo].[Parameter] ([Id])
	806	GO
	807	/**** Object: ForeignKey [FK__IntProble__Probl__32AB8735] Script Date: 03/09/2010 16:21:40 ****/
	808	ALTER TABLE [dbo].[IntProblemCharacteristicValue] WITH CHECK ADD FOREIGN KEY([ProblemCharacteristicId])
	809	REFERENCES [dbo].[ProblemCharacteristic] ([Id])
	810	GO
	811	/**** Object: ForeignKey [FK__IntProble__Probl__339FAB6E] Script Date: 03/09/2010 16:21:40 ****/
	812	ALTER TABLE [dbo].[IntProblemCharacteristicValue] WITH CHECK ADD FOREIGN KEY([ProblemId])
	813	REFERENCES [dbo].[Problem] ([Id])
	814	ON UPDATE CASCADE
	815	ON DELETE CASCADE
	816	GO
	817	/**** Object: ForeignKey [FK__IntResult__Resul__0E6E26BF] Script Date: 03/09/2010 16:21:40 ****/
	818	ALTER TABLE [dbo].[IntResultValue] WITH CHECK ADD FOREIGN KEY([ResultId])
	819	REFERENCES [dbo].[Result] ([Id])
	820	GO
	821	/**** Object: ForeignKey [FK__IntResult__RunId__0F624AF8] Script Date: 03/09/2010 16:21:40 ****/
	822	ALTER TABLE [dbo].[IntResultValue] WITH CHECK ADD FOREIGN KEY([RunId])
	823	REFERENCES [dbo].[Run] ([Id])
	824	ON UPDATE CASCADE
	825	ON DELETE CASCADE
	826	GO
	827	/**** Object: ForeignKey [FK__OperatorP__DataT__02C769E9] Script Date: 03/09/2010 16:21:40 ****/
	828	ALTER TABLE [dbo].[OperatorParameterValue] WITH CHECK ADD FOREIGN KEY([DataTypeId])
	829	REFERENCES [dbo].[DataType] ([Id])
	830	GO
	831	/**** Object: ForeignKey [FK__OperatorP__Exper__01D345B0] Script Date: 03/09/2010 16:21:40 ****/
	832	ALTER TABLE [dbo].[OperatorParameterValue] WITH CHECK ADD FOREIGN KEY([ExperimentId])
	833	REFERENCES [dbo].[Experiment] ([Id])
	834	ON UPDATE CASCADE
	835	ON DELETE CASCADE
	836	GO
	837	/**** Object: ForeignKey [FK__OperatorP__Param__00DF2177] Script Date: 03/09/2010 16:21:40 ****/
	838	ALTER TABLE [dbo].[OperatorParameterValue] WITH CHECK ADD FOREIGN KEY([ParameterId])
	839	REFERENCES [dbo].[Parameter] ([Id])
	840	GO
	841	/**** Object: ForeignKey [FK__Parameter__DataT__656C112C] Script Date: 03/09/2010 16:21:40 ****/
	842	ALTER TABLE [dbo].[Parameter] WITH CHECK ADD FOREIGN KEY([DataTypeId])
	843	REFERENCES [dbo].[DataType] ([Id])
	844	ON UPDATE CASCADE
	845	ON DELETE CASCADE
	846	GO
	847	/**** Object: ForeignKey [FK__Problem__Platfor__31EC6D26] Script Date: 03/09/2010 16:21:40 ****/
	848	ALTER TABLE [dbo].[Problem] WITH CHECK ADD FOREIGN KEY([PlatformId])
	849	REFERENCES [dbo].[Platform] ([Id])
	850	GO
	851	/**** Object: ForeignKey [FK__Problem__Problem__30F848ED] Script Date: 03/09/2010 16:21:40 ****/
	852	ALTER TABLE [dbo].[Problem] WITH CHECK ADD FOREIGN KEY([ProblemClassId])
	853	REFERENCES [dbo].[ProblemClass] ([Id])
	854	GO
	855	/**** Object: ForeignKey [FK__Problem__Solutio__32E0915F] Script Date: 03/09/2010 16:21:40 ****/
	856	ALTER TABLE [dbo].[Problem] WITH CHECK ADD FOREIGN KEY([SolutionRepresentationid])
	857	REFERENCES [dbo].[SolutionRepresentation] ([Id])
	858	GO
	859	/**** Object: ForeignKey [FK__Problem_P__Param__02084FDA] Script Date: 03/09/2010 16:21:40 ****/
	860	ALTER TABLE [dbo].[Problem_Parameter] WITH CHECK ADD FOREIGN KEY([ParameterId])
	861	REFERENCES [dbo].[Parameter] ([Id])
	862	ON UPDATE CASCADE
	863	ON DELETE CASCADE
	864	GO
	865	/**** Object: ForeignKey [FK__Problem_P__Probl__01142BA1] Script Date: 03/09/2010 16:21:40 ****/
	866	ALTER TABLE [dbo].[Problem_Parameter] WITH CHECK ADD FOREIGN KEY([ProblemId])
	867	REFERENCES [dbo].[Problem] ([Id])
	868	GO
	869	/**** Object: ForeignKey [FK__ProblemCh__DataT__2DE6D218] Script Date: 03/09/2010 16:21:40 ****/
	870	ALTER TABLE [dbo].[ProblemCharacteristic] WITH CHECK ADD FOREIGN KEY([DataTypeId])
	871	REFERENCES [dbo].[DataType] ([Id])
	872	ON UPDATE CASCADE
	873	ON DELETE CASCADE
	874	GO
	875	/**** Object: ForeignKey [FK__ProblemDa__Probl__37A5467C] Script Date: 03/09/2010 16:21:40 ****/
	876	ALTER TABLE [dbo].[ProblemData] WITH CHECK ADD FOREIGN KEY([ProblemId])
	877	REFERENCES [dbo].[Problem] ([Id])
	878	ON UPDATE CASCADE
	879	ON DELETE CASCADE
	880	GO
	881	/**** Object: ForeignKey [FK__Result__DataType__09A971A2] Script Date: 03/09/2010 16:21:40 ****/
	882	ALTER TABLE [dbo].[Result] WITH CHECK ADD FOREIGN KEY([DataTypeId])
	883	REFERENCES [dbo].[DataType] ([Id])
	884	ON UPDATE CASCADE
	885	ON DELETE CASCADE
	886	GO
	887	/**** Object: ForeignKey [FK__Run__ClientId__5DCAEF64] Script Date: 03/09/2010 16:21:40 ****/
	888	ALTER TABLE [dbo].[Run] WITH CHECK ADD FOREIGN KEY([ClientId])
	889	REFERENCES [dbo].[Client] ([Id])
	890	GO
	891	/**** Object: ForeignKey [FK__Run__ExperimentI__5BE2A6F2] Script Date: 03/09/2010 16:21:40 ****/
	892	ALTER TABLE [dbo].[Run] WITH CHECK ADD FOREIGN KEY([ExperimentId])
	893	REFERENCES [dbo].[Experiment] ([Id])
	894	ON UPDATE CASCADE
	895	ON DELETE CASCADE
	896	GO
	897	/**** Object: ForeignKey [FK__Run__UserId__5CD6CB2B] Script Date: 03/09/2010 16:21:40 ****/
	898	ALTER TABLE [dbo].[Run] WITH CHECK ADD FOREIGN KEY([UserId])
	899	REFERENCES [dbo].[User] ([Id])
	900	GO

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

Context Navigation

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

Download in other formats: