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