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

Visit:

Last change on this file since 10851 was 8049, checked in by ascheibe, 12 years ago
#1174 integrated OKB services parts into trunk
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	[UserGroupId] [uniqueidentifier] NOT NULL,
	220	CONSTRAINT [PK_AlgorithmUser_AlgorithmId_UserId] PRIMARY KEY CLUSTERED
	221	(
	222	[AlgorithmId] ASC,
	223	[UserGroupId] 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	[CreatedDate] [datetime2](7) NOT NULL,
	237	[UserId] [uniqueidentifier] NOT NULL,
	238	[ClientId] [uniqueidentifier] NOT NULL,
	239	CONSTRAINT [PK_Run_Id] PRIMARY KEY CLUSTERED
	240	(
	241	[Id] ASC
	242	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	243	) ON [PRIMARY]
	244	GO
	245	/**** Object: Table [dbo].[ProblemUser] Script Date: 01/31/2011 02:17:22 ****/
	246	SET ANSI_NULLS ON
	247	GO
	248	SET QUOTED_IDENTIFIER ON
	249	GO
	250	CREATE TABLE [dbo].[ProblemUser](
	251	[ProblemId] [bigint] NOT NULL,
	252	[UserGroupId] [uniqueidentifier] NOT NULL,
	253	CONSTRAINT [PK_ProblemUser_ProblemId_UserId] PRIMARY KEY CLUSTERED
	254	(
	255	[ProblemId] ASC,
	256	[UserGroupId] 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	/**** Object: Table [dbo].[Value] Script Date: 01/31/2011 02:17:22 ****/
	261	SET ANSI_NULLS ON
	262	GO
	263	SET QUOTED_IDENTIFIER ON
	264	GO
	265	CREATE TABLE [dbo].[Value](
	266	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	267	[RunId] [bigint] NOT NULL,
	268	[ValueNameId] [bigint] NOT NULL,
	269	[DataTypeId] [bigint] NOT NULL,
	270	[BoolValue] [bit] SPARSE NULL,
	271	[IntValue] [int] SPARSE NULL,
	272	[LongValue] [bigint] SPARSE NULL,
	273	[FloatValue] [real] SPARSE NULL,
	274	[DoubleValue] [float] SPARSE NULL,
	275	[StringValue] [nvarchar](max) SPARSE NULL,
	276	[BinaryDataId] [bigint] SPARSE NULL,
	277	CONSTRAINT [PK_Value_Id] PRIMARY KEY CLUSTERED
	278	(
	279	[Id] ASC
	280	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	281	) ON [PRIMARY]
	282	GO
	283	/**** Object: ForeignKey [FK_AlgorithmClass_Algorithm] Script Date: 01/31/2011 02:17:22 ****/
	284	ALTER TABLE [dbo].[Algorithm] WITH CHECK ADD CONSTRAINT [FK_AlgorithmClass_Algorithm] FOREIGN KEY([AlgorithmClassId])
	285	REFERENCES [dbo].[AlgorithmClass] ([Id])
	286	GO
	287	ALTER TABLE [dbo].[Algorithm] CHECK CONSTRAINT [FK_AlgorithmClass_Algorithm]
	288	GO
	289	/**** Object: ForeignKey [FK_BinaryData_Algorithm] Script Date: 01/31/2011 02:17:22 ****/
	290	ALTER TABLE [dbo].[Algorithm] WITH CHECK ADD CONSTRAINT [FK_BinaryData_Algorithm] FOREIGN KEY([BinaryDataId])
	291	REFERENCES [dbo].[BinaryData] ([Id])
	292	GO
	293	ALTER TABLE [dbo].[Algorithm] CHECK CONSTRAINT [FK_BinaryData_Algorithm]
	294	GO
	295	/**** Object: ForeignKey [FK_DataType_Algorithm] Script Date: 01/31/2011 02:17:22 ****/
	296	ALTER TABLE [dbo].[Algorithm] WITH CHECK ADD CONSTRAINT [FK_DataType_Algorithm] FOREIGN KEY([DataTypeId])
	297	REFERENCES [dbo].[DataType] ([Id])
	298	GO
	299	ALTER TABLE [dbo].[Algorithm] CHECK CONSTRAINT [FK_DataType_Algorithm]
	300	GO
	301	/**** Object: ForeignKey [FK_Platform_Algorithm] Script Date: 01/31/2011 02:17:22 ****/
	302	ALTER TABLE [dbo].[Algorithm] WITH CHECK ADD CONSTRAINT [FK_Platform_Algorithm] FOREIGN KEY([PlatformId])
	303	REFERENCES [dbo].[Platform] ([Id])
	304	GO
	305	ALTER TABLE [dbo].[Algorithm] CHECK CONSTRAINT [FK_Platform_Algorithm]
	306	GO
	307	/**** Object: ForeignKey [FK_Algorithm_AlgorithmUser] Script Date: 01/31/2011 02:17:22 ****/
	308	ALTER TABLE [dbo].[AlgorithmUser] WITH CHECK ADD CONSTRAINT [FK_Algorithm_AlgorithmUser] FOREIGN KEY([AlgorithmId])
	309	REFERENCES [dbo].[Algorithm] ([Id])
	310	ON UPDATE CASCADE
	311	ON DELETE CASCADE
	312	GO
	313	ALTER TABLE [dbo].[AlgorithmUser] CHECK CONSTRAINT [FK_Algorithm_AlgorithmUser]
	314	GO
	315	/**** Object: ForeignKey [FK_Characteristic_CharacteristicValue] Script Date: 01/31/2011 02:17:22 ****/
	316	ALTER TABLE [dbo].[CharacteristicValue] WITH CHECK ADD CONSTRAINT [FK_Characteristic_CharacteristicValue] FOREIGN KEY([CharacteristicId])
	317	REFERENCES [dbo].[Characteristic] ([Id])
	318	GO
	319	ALTER TABLE [dbo].[CharacteristicValue] CHECK CONSTRAINT [FK_Characteristic_CharacteristicValue]
	320	GO
	321	/**** Object: ForeignKey [FK_DataType_CharacteristicValue] Script Date: 01/31/2011 02:17:22 ****/
	322	ALTER TABLE [dbo].[CharacteristicValue] WITH CHECK ADD CONSTRAINT [FK_DataType_CharacteristicValue] FOREIGN KEY([DataTypeId])
	323	REFERENCES [dbo].[DataType] ([Id])
	324	GO
	325	ALTER TABLE [dbo].[CharacteristicValue] CHECK CONSTRAINT [FK_DataType_CharacteristicValue]
	326	GO
	327	/**** Object: ForeignKey [FK_Problem_CharacteristicValue] Script Date: 01/31/2011 02:17:22 ****/
	328	ALTER TABLE [dbo].[CharacteristicValue] WITH CHECK ADD CONSTRAINT [FK_Problem_CharacteristicValue] FOREIGN KEY([ProblemId])
	329	REFERENCES [dbo].[Problem] ([Id])
	330	GO
	331	ALTER TABLE [dbo].[CharacteristicValue] CHECK CONSTRAINT [FK_Problem_CharacteristicValue]
	332	GO
	333	/**** Object: ForeignKey [FK_BinaryData_Problem] Script Date: 01/31/2011 02:17:22 ****/
	334	ALTER TABLE [dbo].[Problem] WITH CHECK ADD CONSTRAINT [FK_BinaryData_Problem] FOREIGN KEY([BinaryDataId])
	335	REFERENCES [dbo].[BinaryData] ([Id])
	336	GO
	337	ALTER TABLE [dbo].[Problem] CHECK CONSTRAINT [FK_BinaryData_Problem]
	338	GO
	339	/**** Object: ForeignKey [FK_DataType_Problem] Script Date: 01/31/2011 02:17:22 ****/
	340	ALTER TABLE [dbo].[Problem] WITH CHECK ADD CONSTRAINT [FK_DataType_Problem] FOREIGN KEY([DataTypeId])
	341	REFERENCES [dbo].[DataType] ([Id])
	342	GO
	343	ALTER TABLE [dbo].[Problem] CHECK CONSTRAINT [FK_DataType_Problem]
	344	GO
	345	/**** Object: ForeignKey [FK_Platform_Problem] Script Date: 01/31/2011 02:17:22 ****/
	346	ALTER TABLE [dbo].[Problem] WITH CHECK ADD CONSTRAINT [FK_Platform_Problem] FOREIGN KEY([PlatformId])
	347	REFERENCES [dbo].[Platform] ([Id])
	348	GO
	349	ALTER TABLE [dbo].[Problem] CHECK CONSTRAINT [FK_Platform_Problem]
	350	GO
	351	/**** Object: ForeignKey [FK_ProblemClass_Problem] Script Date: 01/31/2011 02:17:22 ****/
	352	ALTER TABLE [dbo].[Problem] WITH CHECK ADD CONSTRAINT [FK_ProblemClass_Problem] FOREIGN KEY([ProblemClassId])
	353	REFERENCES [dbo].[ProblemClass] ([Id])
	354	GO
	355	ALTER TABLE [dbo].[Problem] CHECK CONSTRAINT [FK_ProblemClass_Problem]
	356	GO
	357	/**** Object: ForeignKey [FK_Problem_ProblemUser] Script Date: 01/31/2011 02:17:22 ****/
	358	ALTER TABLE [dbo].[ProblemUser] WITH CHECK ADD CONSTRAINT [FK_Problem_ProblemUser] FOREIGN KEY([ProblemId])
	359	REFERENCES [dbo].[Problem] ([Id])
	360	ON UPDATE CASCADE
	361	ON DELETE CASCADE
	362	GO
	363	ALTER TABLE [dbo].[ProblemUser] CHECK CONSTRAINT [FK_Problem_ProblemUser]
	364	GO
	365	/**** Object: ForeignKey [FK_Algorithm_Run] Script Date: 01/31/2011 02:17:22 ****/
	366	ALTER TABLE [dbo].[Run] WITH CHECK ADD CONSTRAINT [FK_Algorithm_Run] FOREIGN KEY([AlgorithmId])
	367	REFERENCES [dbo].[Algorithm] ([Id])
	368	GO
	369	ALTER TABLE [dbo].[Run] CHECK CONSTRAINT [FK_Algorithm_Run]
	370	GO
	371	/**** Object: ForeignKey [FK_Problem_Run] Script Date: 01/31/2011 02:17:22 ****/
	372	ALTER TABLE [dbo].[Run] WITH CHECK ADD CONSTRAINT [FK_Problem_Run] FOREIGN KEY([ProblemId])
	373	REFERENCES [dbo].[Problem] ([Id])
	374	GO
	375	ALTER TABLE [dbo].[Run] CHECK CONSTRAINT [FK_Problem_Run]
	376	GO
	377	/**** Object: ForeignKey [FK_BinaryData_Value] Script Date: 01/31/2011 02:17:22 ****/
	378	ALTER TABLE [dbo].[Value] WITH CHECK ADD CONSTRAINT [FK_BinaryData_Value] FOREIGN KEY([BinaryDataId])
	379	REFERENCES [dbo].[BinaryData] ([Id])
	380	GO
	381	ALTER TABLE [dbo].[Value] CHECK CONSTRAINT [FK_BinaryData_Value]
	382	GO
	383	/**** Object: ForeignKey [FK_DataType_Value] Script Date: 01/31/2011 02:17:22 ****/
	384	ALTER TABLE [dbo].[Value] WITH CHECK ADD CONSTRAINT [FK_DataType_Value] FOREIGN KEY([DataTypeId])
	385	REFERENCES [dbo].[DataType] ([Id])
	386	GO
	387	ALTER TABLE [dbo].[Value] CHECK CONSTRAINT [FK_DataType_Value]
	388	GO
	389	/**** Object: ForeignKey [FK_Run_Value] Script Date: 01/31/2011 02:17:22 ****/
	390	ALTER TABLE [dbo].[Value] WITH CHECK ADD CONSTRAINT [FK_Run_Value] FOREIGN KEY([RunId])
	391	REFERENCES [dbo].[Run] ([Id])
	392	GO
	393	ALTER TABLE [dbo].[Value] CHECK CONSTRAINT [FK_Run_Value]
	394	GO
	395	/**** Object: ForeignKey [FK_ValueName_Value] Script Date: 01/31/2011 02:17:22 ****/
	396	ALTER TABLE [dbo].[Value] WITH CHECK ADD CONSTRAINT [FK_ValueName_Value] FOREIGN KEY([ValueNameId])
	397	REFERENCES [dbo].[ValueName] ([Id])
	398	GO
	399	ALTER TABLE [dbo].[Value] CHECK CONSTRAINT [FK_ValueName_Value]
	400	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 @ 10851

Download in other formats: