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