Context Navigation

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

Initialize OKB.sql @ 5955

Visit:

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

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

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

Context Navigation

source: branches/OKB (trunk integration)/HeuristicLab.Services.OKB.DataAccess/3.3/SQL Scripts/Initialize OKB.sql @ 5955

Download in other formats: