Test Skyserver.SQL.py (id cbeba89afadb) (err)
Skyserver.stable.out.FILTERED 2019-01-10 01:18:45.135598100 +0100Skyserver.test.out.FILTERED 2019-01-10 01:18:45.166826200 +0100
1 Statistics about stdout of test 'Skyserver` in directory 'sql/test/Skyserver`: 1 1 Statistics about stdout of test 'Skyserver` in directory 'sql/test/Skyserver`: 1
2 105 lines, 325 words, 855 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 51 lines, 163 words, 513 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 105 lines, 325 words, 855 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 51 lines, 163 words, 513 chars in lines not matching '^$|^(\| |)#` 3
4 # 141 lines, 466 words, 2179 chars in all lines 4 ! 4 # 3540 lines, 14179 words, 95160 chars in all lines 4
5 5 5 5
..................
# 14:14:17 >
29 tables 29 67 tables 67
+ 68 #START TRANSACTION; 68
+ 69 #CREATE TABLE RC3( 69
+ 70 # name varchar(20) NOT NULL, 70
+ 71 # aliases varchar(20) NULL, 71
+ 72 # PGC_name varchar(10) NULL, 72
+ 73 # ra float NOT NULL, 73
+ 74 # "dec" float NOT NULL, 74
+ 75 # good_position int NOT NULL, 75
+ 76 # galactic_l float NULL, 76
+ 77 # galactic_b float NULL, 77
+ 78 # superGalactic_l float NULL, 78
+ 79 # superGalactic_b float NULL, 79
+ 80 # PosAngle float NULL, 80
+ 81 # rc2_type char(7) NULL, 81
+ 82 # rc2_typeSource char(6) NULL, 82
+ 83 # T_type float NULL, 83
+ 84 # T_typeErr float NULL, 84
+ 85 # LC_rc2 float NULL, 85
+ 86 # LC_rc2Err float NULL, 86
+ 87 # n_L float NULL, 87
+ 88 # B_T float NULL, 88
+ 89 # B_TErr float NULL, 89
+ 90 # B_Tsource char(1) NULL, 90
+ 91 #CREATE TABLE Stetson( 91
+ 92 # name varchar(20) NOT NULL, 92
+ 93 # ra float NOT NULL, 93
+ 94 # "dec" float NOT NULL, 94
+ 95 # B float NULL, 95
+ 96 # BErr float NULL, 96
+ 97 # nB_tot int NULL, 97
+ 98 # nB int NULL, 98
+ 99 # V float NULL, 99
+ 100 # VErr float NULL, 100
+ 101 # nV_tot int NULL, 101
+ 102 # nV int NULL, 102
+ 103 # R float NULL, 103
+ 104 # RErr float NULL, 104
+ 105 # nR_tot int NULL, 105
+ 106 # nR int NULL, 106
+ 107 # I float NULL, 107
+ 108 # IErr float NULL, 108
+ 109 # nI_tot int NULL, 109
+ 110 # nI int NULL, 110
+ 111 # vary float NULL, 111
+ 112 # objid bigint NULL, 112
+ 113 # CONSTRAINT pk_Stetson_name PRIMARY KEY 113
+ 114 #( 114
+ 115 # name 115
+ 116 #) 116
+ 117 #); 117
+ 118 #CREATE TABLE QsoCatalogAll( 118
+ 119 # SpecObjID bigint NOT NULL, 119
+ 120 # bestObjID bigint NOT NULL, 120
+ 121 # targetObjID bigint NOT NULL, 121
+ 122 # zone int NOT NULL, 122
+ 123 # ra float NOT NULL, 123
+ 124 # "dec" float NOT NULL, 124
+ 125 # Confidence float NOT NULL, 125
+ 126 # SpecObjQso tinyint NOT NULL, 126
+ 127 # BestObjQso tinyint NOT NULL, 127
+ 128 # TargetObjQso tinyint NOT NULL, 128
+ 129 # CONSTRAINT pk_QsoCatalogAll_zone_ra_SpecObj PRIMARY KEY 129
+ 130 #( 130
+ 131 # zone, 131
+ 132 # ra, 132
+ 133 # SpecObjID, 133
+ 134 # bestObjID, 134
+ 135 # targetObjID 135
+ 136 #) 136
+ 137 #); 137
+ 138 #CREATE TABLE QsoConcordance( 138
+ 139 # RowC real NOT NULL, 139
+ 140 # ColC real NOT NULL, 140
+ 141 # RowC_i real NOT NULL, 141
+ 142 # ColC_i real NOT NULL, 142
+ 143 # extinction_u real NOT NULL, 143
+ 144 # extinction_g real NOT NULL, 144
+ 145 # extinction_r real NOT NULL, 145
+ 146 # extinction_i real NOT NULL, 146
+ 147 # extinction_z real NOT NULL, 147
+ 148 # bestObjID bigint NOT NULL, 148
+ 149 # targetObjID bigint NOT NULL, 149
+ 150 # SpecObjID bigint NOT NULL, 150
+ 151 # zone int NOT NULL, 151
+ 152 # ra float NOT NULL, 152
+ 153 # "dec" float NOT NULL, 153
+ 154 # QsoConfidence float NOT NULL, 154
+ 155 # SpecObjFlagedQso tinyint NOT NULL, 155
+ 156 # BestObjFlagedQso tinyint NOT NULL, 156
+ 157 #CREATE TABLE Target( 157
+ 158 # targetID bigint NOT NULL, 158
+ 159 # run smallint NOT NULL, 159
+ 160 # rerun smallint NOT NULL, 160
+ 161 # camcol tinyint NOT NULL, 161
+ 162 # field int NOT NULL, 162
+ 163 # obj int NOT NULL, 163
+ 164 # regionID int NOT NULL, 164
+ 165 # ra float NOT NULL, 165
+ 166 # "dec" float NOT NULL, 166
+ 167 # duplicate tinyint NOT NULL, 167
+ 168 # htmID bigint NOT NULL, 168
+ 169 # cx float NOT NULL, 169
+ 170 # cy float NOT NULL, 170
+ 171 # cz float NOT NULL, 171
+ 172 # bestObjID bigint NOT NULL, 172
+ 173 # specObjID bigint NOT NULL, 173
+ 174 # bestMode tinyint NOT NULL, 174
+ 175 # loadVersion int NOT NULL, 175
+ 176 # CONSTRAINT pk_Target_targetID PRIMARY KEY 176
+ 177 #( 177
+ 178 # targetID 178
+ 179 #CREATE TABLE TilingRun( 179
+ 180 # tileRun smallint NOT NULL, 180
+ 181 # tileVersion varchar(32) NOT NULL, 181
+ 182 # tilepId varchar(32) NOT NULL, 182
+ 183 # programType int NOT NULL, 183
+ 184 # programName varchar(32) NOT NULL, 184
+ 185 # primTargetMask int NOT NULL, 185
+ 186 # secTargetMask int NOT NULL, 186
+ 187 # loadVersion int NOT NULL, 187
+ 188 # CONSTRAINT pk_TilingRun_tileRun PRIMARY KEY 188
+ 189 #( 189
+ 190 # tileRun 190
+ 191 #) 191
+ 192 #); 192
+ 193 #CREATE TABLE TargetParam( 193
+ 194 # targetVersion varchar(32) NOT NULL, 194
+ 195 # name varchar(32) NOT NULL, 195
+ 196 # value varchar(32) NOT NULL, 196
+ 197 # CONSTRAINT pk_TargetParam_targetVersion_nam PRIMARY KEY 197
+ 198 #( 198
+ 199 # targetVersion, 199
+ 200 # name 200
+ 201 #) 201
+ 202 #); 202
+ 203 #CREATE TABLE Rmatrix( 203
+ 204 # mode varchar(16) NOT NULL, 204
+ 205 # "row" smallint NOT NULL, 205
+ 206 # x float NOT NULL, 206
+ 207 # y float NOT NULL, 207
+ 208 # z float NOT NULL, 208
+ 209 # CONSTRAINT pk_RMatrix_mode_row PRIMARY KEY 209
+ 210 #( 210
+ 211 # mode, 211
+ 212 # "row" 212
+ 213 #) 213
+ 214 #); 214
+ 215 #CREATE TABLE Region( 215
+ 216 # regionid bigint GENERATED ALWAYS AS IDENTITY NOT NULL, 216
+ 217 # id bigint NOT NULL, 217
+ 218 # type varchar(16) NOT NULL, 218
+ 219 # comment varchar(1024) NOT NULL, 219
+ 220 # ismask tinyint NOT NULL DEFAULT (0), 220
+ 221 # area float NOT NULL DEFAULT (0), 221
+ 222 # regionString text NOT NULL DEFAULT (''), 222
+ 223 # sql text NOT NULL DEFAULT (''), 223
+ 224 # xml text NOT NULL DEFAULT (''), 224
+ 225 # CONSTRAINT pk_Region_regionId PRIMARY KEY 225
+ 226 #( 226
+ 227 # regionid 227
+ 228 #) 228
+ 229 #); 229
+ 230 #CREATE TABLE SiteDBs( 230
+ 231 # dbname varchar(64) NOT NULL, 231
+ 232 # description varchar(128) NOT NULL, 232
+ 233 # active char(1) NOT NULL 233
+ 234 #); 234
+ 235 #CREATE TABLE QueryResults( 235
+ 236 # query varchar(10) NOT NULL, 236
+ 237 # cpu_sec float NOT NULL, 237
+ 238 # elapsed_time float NOT NULL, 238
+ 239 # physical_IO float NOT NULL, 239
+ 240 # row_count bigint NOT NULL, 240
+ 241 # time timestamp NOT NULL DEFAULT (localtimestamp), 241
+ 242 # comment varchar(100) NULL DEFAULT (''), 242
+ 243 # CONSTRAINT pk_QueryResults_query_time PRIMARY KEY 243
+ 244 #( 244
+ 245 # query, 245
+ 246 # time 246
+ 247 #) 247
+ 248 #); 248
+ 249 #CREATE TABLE RecentQueries( 249
+ 250 # ipAddr varchar(30) NOT NULL, 250
+ 251 # lastQueryTime timestamp NOT NULL, 251
+ 252 # CONSTRAINT pk_RecentQueries_ipAddr_lastQuer PRIMARY KEY 252
+ 253 #( 253
+ 254 # ipAddr, 254
+ 255 # lastQueryTime 255
+ 256 #) 256
+ 257 #); 257
+ 258 #CREATE TABLE SiteConstants( 258
+ 259 # name varchar(64) NOT NULL, 259
+ 260 # value varchar(64) NOT NULL, 260
+ 261 # comment varchar(256) NOT NULL, 261
+ 262 # CONSTRAINT pk_SiteConstants_name PRIMARY KEY 262
+ 263 #( 263
+ 264 # name 264
+ 265 #) 265
+ 266 #); 266
+ 267 #CREATE TABLE Glossary( 267
+ 268 # "key" varchar(128) NOT NULL, 268
+ 269 # name varchar(128) NOT NULL, 269
+ 270 # ucd varchar(128) NOT NULL, 270
+ 271 # "text" varchar(7200) NOT NULL, 271
+ 272 # CONSTRAINT pk_Glossary_key PRIMARY KEY 272
+ 273 #( 273
+ 274 # "key" 274
+ 275 #) 275
+ 276 #); 276
+ 277 #CREATE TABLE Algorithm( 277
+ 278 # "key" varchar(128) NOT NULL, 278
+ 279 # name varchar(128) NOT NULL, 279
+ 280 # ucd varchar(128) NOT NULL, 280
+ 281 # "text" text NOT NULL, 281
+ 282 # CONSTRAINT pk_Algorithm_key PRIMARY KEY 282
+ 283 #( 283
+ 284 # "key" 284
+ 285 #) 285
+ 286 #); 286
+ 287 #CREATE TABLE TableDesc( 287
+ 288 # "key" varchar(128) NOT NULL, 288
+ 289 # type varchar(128) NOT NULL, 289
+ 290 # ucd varchar(128) NOT NULL, 290
+ 291 # "text" varchar(7200) NOT NULL, 291
+ 292 # CONSTRAINT pk_TableDesc_key PRIMARY KEY 292
+ 293 #( 293
+ 294 # "key" 294
+ 295 #) 295
+ 296 #); 296
+ 297 #CREATE TABLE DBObjects( 297
+ 298 # name varchar(128) NOT NULL, 298
+ 299 # type varchar(64) NOT NULL, 299
+ 300 # access varchar(8) NOT NULL, 300
+ 301 # description varchar(256) NOT NULL, 301
+ 302 # "text" varchar(7200) NOT NULL, 302
+ 303 # rank int NOT NULL DEFAULT (0), 303
+ 304 # CONSTRAINT pk_DBObjects_name PRIMARY KEY 304
+ 305 #( 305
+ 306 # name 306
+ 307 #) 307
+ 308 #); 308
+ 309 #CREATE TABLE History( 309
+ 310 # id int GENERATED ALWAYS AS IDENTITY NOT NULL, 310
+ 311 # filename varchar(128) NOT NULL, 311
+ 312 # date varchar(64) NOT NULL, 312
+ 313 # name varchar(64) NOT NULL, 313
+ 314 # description varchar(7200) NOT NULL, 314
+ 315 # CONSTRAINT pk_History_id PRIMARY KEY 315
+ 316 #( 316
+ 317 # id 317
+ 318 #) 318
+ 319 #); 319
+ 320 #CREATE TABLE Dependency( 320
+ 321 # filename varchar(128) NOT NULL, 321
+ 322 # parent varchar(128) NOT NULL, 322
+ 323 # child varchar(128) NOT NULL, 323
+ 324 # CONSTRAINT pk_Dependency_parent_child PRIMARY KEY 324
+ 325 #( 325
+ 326 # parent, 326
+ 327 # child 327
+ 328 #) 328
+ 329 #); 329
+ 330 #CREATE TABLE PubHistory( 330
+ 331 # name varchar(64) NOT NULL, 331
+ 332 # nrows int NOT NULL, 332
+ 333 # tend timestamp NOT NULL, 333
+ 334 # loadversion int NOT NULL, 334
+ 335 # CONSTRAINT pk_PubHistory_name_loadversion PRIMARY KEY 335
+ 336 #( 336
+ 337 # name, 337
+ 338 # loadversion 338
+ 339 #) 339
+ 340 #); 340
+ 341 #CREATE TABLE LoadHistory( 341
+ 342 # loadversion int NOT NULL, 342
+ 343 # tstart timestamp NOT NULL, 343
+ 344 # tend timestamp NOT NULL, 344
+ 345 # dbname varchar(64) NOT NULL, 345
+ 346 # CONSTRAINT pk_LoadHistory_loadVersion_tStar PRIMARY KEY 346
+ 347 #( 347
+ 348 # loadversion, 348
+ 349 # tstart 349
+ 350 #) 350
+ 351 #); 351
+ 352 #CREATE TABLE "Diagnostics"( 352
+ 353 # name varchar(64) NOT NULL, 353
+ 354 # type varchar(8) NOT NULL, 354
+ 355 # "count" bigint NULL, 355
+ 356 # CONSTRAINT pk_Diagnostics_name PRIMARY KEY 356
+ 357 #( 357
+ 358 # name 358
+ 359 #) 359
+ 360 #); 360
+ 361 #CREATE TABLE SiteDiagnostics( 361
+ 362 # name varchar(64) NOT NULL, 362
+ 363 # type varchar(8) NOT NULL, 363
+ 364 # count bigint NULL, 364
+ 365 # CONSTRAINT pk_SiteDiagnostics_name PRIMARY KEY 365
+ 366 #( 366
+ 367 # name 367
+ 368 #) 368
+ 369 #); 369
+ 370 #CREATE TABLE Versions( 370
+ 371 # event varchar(256) NOT NULL, 371
+ 372 # previous varchar(64) NOT NULL, 372
+ 373 # checksum varchar(64) NOT NULL, 373
+ 374 # version varchar(64) NOT NULL, 374
+ 375 # description varchar(256) NOT NULL, 375
+ 376 # "text" varchar(2000) NOT NULL, 376
+ 377 # who varchar(256) NOT NULL, 377
+ 378 # "when" varchar(256) NOT NULL, 378
+ 379 # CONSTRAINT pk_Versions_version PRIMARY KEY 379
+ 380 #( 380
+ 381 # version 381
+ 382 #) 382
+ 383 #); 383
+ 384 #CREATE TABLE PartitionMap( 384
+ 385 # fileGroupName varchar(100) NOT NULL, 385
+ 386 # size real NOT NULL, 386
+ 387 # comment varchar(4000) NULL, 387
+ 388 # CONSTRAINT pk_PartitionMap_fileGroupName PRIMARY KEY 388
+ 389 #( 389
+ 390 # fileGroupName 390
+ 391 #) 391
+ 392 #); 392
+ 393 #CREATE TABLE DataConstants( 393
+ 394 # field varchar(128) NOT NULL, 394
+ 395 # name varchar(128) NOT NULL, 395
+ 396 # value bigint , --NOT NULL, 396
+ 397 # description varchar(2000) NOT NULL, 397
+ 398 # CONSTRAINT pk_DataConstants_field_name PRIMARY KEY 398
+ 399 #( 399
+ 400 # field, 400
+ 401 # name 401
+ 402 #) 402
+ 403 #); 403
+ 404 #CREATE TABLE SDSSConstants( 404
+ 405 # name varchar(32) NOT NULL, 405
+ 406 # value float NOT NULL, 406
+ 407 # unit varchar(32) NOT NULL, 407
+ 408 # description varchar(2000) NOT NULL, 408
+ 409 # CONSTRAINT pk_SDSSConstants_name PRIMARY KEY 409
+ 410 #( 410
+ 411 # name 411
+ 412 #) 412
+ 413 #); 413
+ 414 #CREATE TABLE StripeDefs( 414
+ 415 # stripe int NOT NULL, 415
+ 416 # hemisphere varchar(64) NOT NULL, 416
+ 417 # eta float NOT NULL, 417
+ 418 # lambdaMin float NOT NULL, 418
+ 419 # lambdaMax float NOT NULL, 419
+ 420 # htmArea varchar(1024), --NOT NULL, 420
+ 421 # CONSTRAINT pk_StripeDefs_stripe PRIMARY KEY 421
+ 422 #( 422
+ 423 # stripe 423
+ 424 #) 424
+ 425 #); 425
+ 426 #CREATE TABLE RunShift( 426
+ 427 # run int NOT NULL, 427
+ 428 # shift float NOT NULL, 428
+ 429 # CONSTRAINT pk_RunShift_run PRIMARY KEY 429
+ 430 #( 430
+ 431 # run 431
+ 432 #) 432
+ 433 #); 433
+ 434 #CREATE TABLE ProfileDefs( 434
+ 435 # bin int NOT NULL, 435
+ 436 # cell int NOT NULL, 436
+ 437 # sinc int NOT NULL, 437
+ 438 # rInner float NOT NULL, 438
+ 439 # rOuter float NOT NULL, 439
+ 440 # aAnn float NOT NULL, 440
+ 441 # aDisk float NOT NULL, 441
+ 442 # CONSTRAINT pk_ProfileDefs_bin PRIMARY KEY 442
+ 443 #( 443
+ 444 # bin 444
+ 445 #) 445
+ 446 #); 446
+ 447 #CREATE TABLE Mask( 447
+ 448 # maskID bigint NOT NULL, 448
+ 449 # run smallint NOT NULL, 449
+ 450 # rerun smallint NOT NULL, 450
+ 451 # camcol tinyint NOT NULL, 451
+ 452 # field smallint NOT NULL, 452
+ 453 # mask smallint NOT NULL, 453
+ 454 # filter tinyint NOT NULL, 454
+ 455 # ra float NOT NULL, 455
+ 456 # "dec" float NOT NULL, 456
+ 457 # radius float NOT NULL, 457
+ 458 # area varchar(4096) NOT NULL, 458
+ 459 # type int NOT NULL, 459
+ 460 # seeing real NOT NULL, 460
+ 461 # cx float NOT NULL DEFAULT (0), 461
+ 462 # cy float NOT NULL DEFAULT (0), 462
+ 463 # cz float NOT NULL DEFAULT (0), 463
+ 464 # htmID bigint NOT NULL DEFAULT (0), 464
+ 465 # CONSTRAINT pk_Mask_maskID PRIMARY KEY 465
+ 466 #( 466
+ 467 #CREATE TABLE "Match"( 467
+ 468 # objID1 bigint NOT NULL, 468
+ 469 # objID2 bigint NOT NULL, 469
+ 470 # run1 smallint NOT NULL, 470
+ 471 # run2 smallint NOT NULL, 471
+ 472 # type1 tinyint NOT NULL, 472
+ 473 # type2 tinyint NOT NULL, 473
+ 474 # mode1 tinyint NOT NULL, 474
+ 475 # mode2 tinyint NOT NULL, 475
+ 476 # distance float NOT NULL, 476
+ 477 # miss char(1) NOT NULL, 477
+ 478 # matchHead bigint NOT NULL, 478
+ 479 # CONSTRAINT pk_Match_objID1_objID2 PRIMARY KEY 479
+ 480 #( 480
+ 481 # objID1, 481
+ 482 # objID2 482
+ 483 #) 483
+ 484 #); 484
+ 485 #CREATE TABLE SpecObjAll( 485
+ 486 # specObjID bigint NOT NULL, 486
+ 487 # mjd int NOT NULL, 487
+ 488 # plate smallint NOT NULL, 488
+ 489 # tile smallint NOT NULL, 489
+ 490 # xFocal float NOT NULL, 490
+ 491 # yFocal float NOT NULL, 491
+ 492 # fiberID smallint NOT NULL, 492
+ 493 # z real NOT NULL, 493
+ 494 # zErr real NOT NULL, 494
+ 495 # zConf real NOT NULL, 495
+ 496 # zStatus smallint NOT NULL, 496
+ 497 # specClass smallint NOT NULL, 497
+ 498 # zWarning int NOT NULL, 498
+ 499 # velDisp real NOT NULL, 499
+ 500 # velDispErr real NOT NULL, 500
+ 501 # eCoeff_0 real NOT NULL, 501
+ 502 # eCoeff_1 real NOT NULL, 502
+ 503 # eCoeff_2 real NOT NULL, 503
+ 504 # eCoeff_3 real NOT NULL, 504
+ 505 # eCoeff_4 real NOT NULL, 505
+ 506 #CREATE TABLE HoleObj( 506
+ 507 # holeID bigint NOT NULL, 507
+ 508 # plateID bigint NOT NULL, 508
+ 509 # holeType int NOT NULL, 509
+ 510 # objType int NOT NULL, 510
+ 511 # targetID bigint NOT NULL, 511
+ 512 # fiberID smallint NOT NULL, 512
+ 513 # xFocal float NOT NULL, 513
+ 514 # yFocal float NOT NULL, 514
+ 515 # ra float NOT NULL, 515
+ 516 # "dec" float NOT NULL, 516
+ 517 # loadVersion int NOT NULL, 517
+ 518 # CONSTRAINT pk_HoleObj_HoleID PRIMARY KEY 518
+ 519 #( 519
+ 520 # holeID 520
+ 521 #) 521
+ 522 #); 522
+ 523 #CREATE TABLE SpecPhotoAll( 523
+ 524 # specObjID bigint NOT NULL, 524
+ 525 # mjd int NOT NULL, 525
+ 526 # plate smallint NOT NULL, 526
+ 527 # tile smallint NOT NULL, 527
+ 528 # fiberID smallint NOT NULL, 528
+ 529 # z real NOT NULL, 529
+ 530 # zErr real NOT NULL, 530
+ 531 # zConf real NOT NULL, 531
+ 532 # zStatus smallint NOT NULL, 532
+ 533 # specClass smallint NOT NULL, 533
+ 534 # zWarning int NOT NULL, 534
+ 535 # ra float NOT NULL, 535
+ 536 # "dec" float NOT NULL, 536
+ 537 # cx float NOT NULL, 537
+ 538 # cy float NOT NULL, 538
+ 539 # cz float NOT NULL, 539
+ 540 # htmID bigint NOT NULL, 540
+ 541 # primTarget int NOT NULL, 541
+ 542 # secTarget int NOT NULL, 542
+ 543 # sciencePrimary smallint NOT NULL, 543
+ 544 # plateID bigint NOT NULL, 544
+ 545 #CREATE TABLE QuasarCatalog( 545
+ 546 # SDSSName varchar(64) NOT NULL, 546
+ 547 # RA float NOT NULL, 547
+ 548 # "dec" float NOT NULL, 548
+ 549 # z real NOT NULL, 549
+ 550 # psfmag_u real NOT NULL, 550
+ 551 # psfmagerr_u real NOT NULL, 551
+ 552 # psfmag_g real NOT NULL, 552
+ 553 # psfmagerr_g real NOT NULL, 553
+ 554 # psfmag_r real NOT NULL, 554
+ 555 # psfmagerr_r real NOT NULL, 555
+ 556 # psfmag_i real NOT NULL, 556
+ 557 # psfmagerr_i real NOT NULL, 557
+ 558 # psfmag_z real NOT NULL, 558
+ 559 # psfmagerr_z real NOT NULL, 559
+ 560 # A_u real NOT NULL, 560
+ 561 # lgNH real NOT NULL, 561
+ 562 # FIRSTmag real NOT NULL, 562
+ 563 # FIRST_sn real NOT NULL, 563
+ 564 # FIRST_sep real NOT NULL, 564
+ 565 # FIRST_flux_at_opt smallint NOT NULL, 565
+ 566 #CREATE TABLE SpecLineIndex( 566
+ 567 # specLineIndexID bigint NOT NULL, 567
+ 568 # name varchar(16) NOT NULL, 568
+ 569 # ew real NOT NULL, 569
+ 570 # ewErr real NOT NULL, 570
+ 571 # mag real NOT NULL, 571
+ 572 # magErr real NOT NULL, 572
+ 573 # waveMin real NOT NULL, 573
+ 574 # waveMax real NOT NULL, 574
+ 575 # z real NOT NULL, 575
+ 576 # sn real NOT NULL, 576
+ 577 # specobjID bigint NOT NULL, 577
+ 578 # CONSTRAINT pk_SpecLineIndex_specLineIndexID PRIMARY KEY 578
+ 579 #( 579
+ 580 # specLineIndexID 580
+ 581 #) 581
+ 582 #); 582
+ 583 #CREATE TABLE SpecLineAll( 583
+ 584 # specLineID bigint NOT NULL, 584
+ 585 # wave real NOT NULL, 585
+ 586 # waveErr real NOT NULL, 586
+ 587 # waveMin real NOT NULL, 587
+ 588 # waveMax real NOT NULL, 588
+ 589 # sigma real NOT NULL, 589
+ 590 # sigmaErr real NOT NULL, 590
+ 591 # sigmaMin real NOT NULL, 591
+ 592 # sigmaMax real NOT NULL, 592
+ 593 # height real NOT NULL, 593
+ 594 # heightErr real NOT NULL, 594
+ 595 # continuum real NOT NULL, 595
+ 596 # ew real NOT NULL, 596
+ 597 # ewErr real NOT NULL, 597
+ 598 # ewMin real NOT NULL, 598
+ 599 # specIndex real NOT NULL, 599
+ 600 # nSigma real NOT NULL, 600
+ 601 # chisq real NOT NULL, 601
+ 602 # nu smallint NOT NULL, 602
+ 603 # restWave real NOT NULL, 603
+ 604 # lineID int NOT NULL, 604
+ 605 #CREATE TABLE XCRedshift( 605
+ 606 # xcRedShiftID bigint NOT NULL, 606
+ 607 # tempNo int NOT NULL, 607
+ 608 # peakNo int NOT NULL, 608
+ 609 # shift real NOT NULL, 609
+ 610 # z real NOT NULL, 610
+ 611 # zErr real NOT NULL, 611
+ 612 # r real NOT NULL, 612
+ 613 # zConf real NOT NULL, 613
+ 614 # height real NOT NULL, 614
+ 615 # width real NOT NULL, 615
+ 616 # widthErr real NOT NULL, 616
+ 617 # delta real NOT NULL, 617
+ 618 # rms real NOT NULL, 618
+ 619 # specObjID bigint NOT NULL, 619
+ 620 # CONSTRAINT pk_XCRedshift_xcRedshiftID PRIMARY KEY 620
+ 621 #( 621
+ 622 # xcRedShiftID 622
+ 623 #) 623
+ 624 #); 624
+ 625 #CREATE TABLE ELRedShift( 625
+ 626 # elRedShiftID bigint NOT NULL, 626
+ 627 # z real NOT NULL, 627
+ 628 # zErr real NOT NULL, 628
+ 629 # zConf real NOT NULL, 629
+ 630 # nFit int NOT NULL, 630
+ 631 # wtFit real NOT NULL, 631
+ 632 # specObjID bigint NOT NULL, 632
+ 633 # CONSTRAINT pk_ELRedShift_elRedShiftID PRIMARY KEY 633
+ 634 #( 634
+ 635 # elRedShiftID 635
+ 636 #) 636
+ 637 #); 637
+ 638 #CREATE TABLE TargetInfo( 638
+ 639 # targetObjID bigint NOT NULL, 639
+ 640 # targetID bigint NOT NULL, 640
+ 641 # skyVersion int NOT NULL, 641
+ 642 # primTarget int NOT NULL, 642
+ 643 # secTarget int NOT NULL, 643
+ 644 # priority int NOT NULL, 644
+ 645 # programType int NOT NULL, 645
+ 646 # programName varchar(32) NOT NULL, 646
+ 647 # targetMode tinyint NOT NULL, 647
+ 648 # loadVersion int NOT NULL, 648
+ 649 # CONSTRAINT pk_TargetInfo_skyVersion_targetI PRIMARY KEY 649
+ 650 #( 650
+ 651 # skyVersion, 651
+ 652 # targetID 652
+ 653 #) 653
+ 654 #); 654
+ 655 #CREATE TABLE TiledTargetAll( 655
+ 656 # tile smallint NOT NULL, 656
+ 657 # targetID bigint NOT NULL, 657
+ 658 # ra float NOT NULL, 658
+ 659 # "dec" float NOT NULL, 659
+ 660 # htmID bigint NOT NULL, 660
+ 661 # cx float NOT NULL, 661
+ 662 # cy float NOT NULL, 662
+ 663 # cz float NOT NULL, 663
+ 664 # objType int NOT NULL, 664
+ 665 # duplicate tinyint NOT NULL, 665
+ 666 # untiled tinyint NOT NULL, 666
+ 667 # loadVersion int NOT NULL, 667
+ 668 # CONSTRAINT pk_TiledTargetAll_targetID_tile PRIMARY KEY 668
+ 669 #( 669
+ 670 # targetID, 670
+ 671 # tile 671
+ 672 #) 672
+ 673 #); 673
+ 674 #CREATE TABLE PlateX( 674
+ 675 # plateID bigint NOT NULL, 675
+ 676 # spRerun int NOT NULL, 676
+ 677 # mjd int NOT NULL, 677
+ 678 # plate smallint NOT NULL, 678
+ 679 # tile smallint NOT NULL, 679
+ 680 # mapMjd int NOT NULL, 680
+ 681 # nExp smallint NOT NULL, 681
+ 682 # tai real NOT NULL, 682
+ 683 # raBoresight float NOT NULL, 683
+ 684 # decBoresight float NOT NULL, 684
+ 685 # taiHMS varchar(64) NOT NULL, 685
+ 686 # expTime real NOT NULL, 686
+ 687 # expTimeB1 real NOT NULL, 687
+ 688 # expTimeB2 real NOT NULL, 688
+ 689 # expTimeR1 real NOT NULL, 689
+ 690 # expTimeR2 real NOT NULL, 690
+ 691 # helioRV real NOT NULL, 691
+ 692 # ra real NOT NULL, 692
+ 693 # "dec" real NOT NULL, 693
+ 694 # cx float NOT NULL, 694
+ 695 # cy float NOT NULL, 695
+ 696 #CREATE TABLE Sector2Tile( 696
+ 697 # regionID bigint NOT NULL, 697
+ 698 # type varchar(16) NOT NULL, 698
+ 699 # tile smallint NOT NULL, 699
+ 700 # isMask int NOT NULL, 700
+ 701 # CONSTRAINT pk_Sector2Tile_regionId_tile PRIMARY KEY 701
+ 702 #( 702
+ 703 # regionID, 703
+ 704 # tile 704
+ 705 #) 705
+ 706 #); 706
+ 707 #CREATE TABLE TilingInfo( 707
+ 708 # tileRun smallint NOT NULL, 708
+ 709 # tid int NOT NULL, 709
+ 710 # tile smallint NOT NULL, 710
+ 711 # tiPriority int NOT NULL, 711
+ 712 # tiMask int NOT NULL, 712
+ 713 # collisionGroupID int NOT NULL, 713
+ 714 # targetID bigint NOT NULL, 714
+ 715 # loadVersion int NOT NULL, 715
+ 716 # CONSTRAINT pk_TilingInfo_tileRun_targetID PRIMARY KEY 716
+ 717 #( 717
+ 718 # tileRun, 718
+ 719 # targetID 719
+ 720 #) 720
+ 721 #); 721
+ 722 #CREATE TABLE TileAll( 722
+ 723 # tile smallint NOT NULL, 723
+ 724 # tileRun smallint NOT NULL, 724
+ 725 # raCen float NOT NULL, 725
+ 726 # decCen float NOT NULL, 726
+ 727 # htmID bigint NOT NULL, 727
+ 728 # cx float NOT NULL, 728
+ 729 # cy float NOT NULL, 729
+ 730 # cz float NOT NULL, 730
+ 731 # untiled tinyint NOT NULL, 731
+ 732 # nTargets int NOT NULL, 732
+ 733 # programType int NOT NULL, 733
+ 734 # programName varchar(32) NOT NULL, 734
+ 735 # extinction_u real NOT NULL, 735
+ 736 # extinction_g real NOT NULL, 736
+ 737 # extinction_r real NOT NULL, 737
+ 738 # extinction_i real NOT NULL, 738
+ 739 # extinction_z real NOT NULL, 739
+ 740 # completeTileVersion varchar(32) NOT NULL, 740
+ 741 # loadVersion int NOT NULL, 741
+ 742 #CREATE TABLE TilingNote( 742
+ 743 # tilingNoteID int NOT NULL, 743
+ 744 # tileRun smallint NOT NULL, 744
+ 745 # tilingNote text NOT NULL, 745
+ 746 # CONSTRAINT pk_TilingNote_tilingNoteID PRIMARY KEY 746
+ 747 #( 747
+ 748 # tilingNoteID 748
+ 749 #) 749
+ 750 #); 750
+ 751 #CREATE TABLE TilingGeometry( 751
+ 752 # tilingGeometryID int NOT NULL, 752
+ 753 # tileRun smallint NOT NULL, 753
+ 754 # stripe int NOT NULL, 754
+ 755 # nsbx varchar(1) NOT NULL, 755
+ 756 # isMask tinyint NOT NULL, 756
+ 757 # coordType int NOT NULL, 757
+ 758 # lambdamu_0 float NOT NULL, 758
+ 759 # lambdamu_1 float NOT NULL, 759
+ 760 # etanu_0 float NOT NULL, 760
+ 761 # etanu_1 float NOT NULL, 761
+ 762 # lambdaLimit_0 float NOT NULL, 762
+ 763 # lambdaLimit_1 float NOT NULL, 763
+ 764 # targetVersion varchar(32) NOT NULL, 764
+ 765 # firstArea float NOT NULL, 765
+ 766 # loadVersion int NOT NULL, 766
+ 767 # CONSTRAINT pk_TilingGeometry_tilingGeometry PRIMARY KEY 767
+ 768 #( 768
+ 769 # tilingGeometryID 769
+ 770 #CREATE TABLE RegionConvex( 770
+ 771 # regionID bigint NOT NULL, 771
+ 772 # convexID bigint NOT NULL, 772
+ 773 # patch int NOT NULL, 773
+ 774 # type varchar(16) NOT NULL, 774
+ 775 # radius float NOT NULL DEFAULT (0), 775
+ 776 # ra float NOT NULL DEFAULT (0), 776
+ 777 # "dec" float NOT NULL DEFAULT (0), 777
+ 778 # x float NOT NULL DEFAULT (0), 778
+ 779 # y float NOT NULL DEFAULT (0), 779
+ 780 # z float NOT NULL DEFAULT (0), 780
+ 781 # c float NOT NULL DEFAULT (0), 781
+ 782 # htmid bigint NOT NULL DEFAULT (0), 782
+ 783 # convexString varchar(7900) NOT NULL DEFAULT (''), 783
+ 784 # CONSTRAINT pk_RegionConvex_regionid_convexi PRIMARY KEY 784
+ 785 #( 785
+ 786 # regionID, 786
+ 787 #CREATE TABLE Region2Box( 787
+ 788 # regionType varchar(16) NOT NULL, 788
+ 789 # id bigint NOT NULL, 789
+ 790 # boxType varchar(16) NOT NULL, 790
+ 791 # boxid bigint NOT NULL, 791
+ 792 # CONSTRAINT pk_Region2Box_regionType_id_boxI PRIMARY KEY 792
+ 793 #( 793
+ 794 # regionType, 794
+ 795 # id, 795
+ 796 # boxid 796
+ 797 #) 797
+ 798 #); 798
+ 799 #CREATE TABLE RegionArcs( 799
+ 800 # regionid bigint NOT NULL, 800
+ 801 # convexid bigint NOT NULL, 801
+ 802 # constraintid bigint NOT NULL, 802
+ 803 # patch int NOT NULL, 803
+ 804 # state int NOT NULL, 804
+ 805 # draw int NOT NULL, 805
+ 806 # ra1 float NOT NULL, 806
+ 807 # dec1 float NOT NULL, 807
+ 808 # ra2 float NOT NULL, 808
+ 809 # dec2 float NOT NULL, 809
+ 810 # x float NOT NULL, 810
+ 811 # y float NOT NULL, 811
+ 812 # z float NOT NULL, 812
+ 813 # c float NOT NULL, 813
+ 814 # length float NOT NULL DEFAULT (0.0), 814
+ 815 # arcid int GENERATED ALWAYS AS IDENTITY NOT NULL, 815
+ 816 # CONSTRAINT pk_RegionArcs_regionId_convexid_ PRIMARY KEY 816
+ 817 #( 817
+ 818 # regionid, 818
+ 819 # convexid, 819
+ 820 # arcid 820
+ 821 #CREATE TABLE Sector( 821
+ 822 # type varchar(16) NOT NULL, 822
+ 823 # regionID bigint NOT NULL, 823
+ 824 # nTiles int NOT NULL, 824
+ 825 # targetVersion varchar(32) NOT NULL, 825
+ 826 # area real NOT NULL, 826
+ 827 # CONSTRAINT pk_Sector_regionId PRIMARY KEY 827
+ 828 #( 828
+ 829 # regionID 829
+ 830 #) 830
+ 831 #); 831
+ 832 #CREATE TABLE HalfSpace( 832
+ 833 # constraintid bigint GENERATED ALWAYS AS IDENTITY NOT NULL, 833
+ 834 # regionid bigint NOT NULL, 834
+ 835 # convexid bigint NOT NULL, 835
+ 836 # x float NOT NULL, 836
+ 837 # y float NOT NULL, 837
+ 838 # z float NOT NULL, 838
+ 839 # c float NOT NULL, 839
+ 840 # CONSTRAINT pk_HalfSpace_constraintid PRIMARY KEY 840
+ 841 #( 841
+ 842 # constraintid 842
+ 843 #) 843
+ 844 #); 844
+ 845 #CREATE TABLE Inventory( 845
+ 846 # filename varchar(128) NOT NULL, 846
+ 847 # name varchar(128) NOT NULL, 847
+ 848 # type varchar(2) NOT NULL, 848
+ 849 # CONSTRAINT pk_Inventory_filename_name PRIMARY KEY 849
+ 850 #( 850
+ 851 # filename, 851
+ 852 # name 852
+ 853 #) 853
+ 854 #); 854
+ 855 #CREATE TABLE DBColumns( 855
+ 856 # tablename varchar(128) NOT NULL, 856
+ 857 # name varchar(64), -- NOT NULL, 857
+ 858 # unit varchar(64), -- NOT NULL, 858
+ 859 # ucd varchar(128), --NOT NULL, 859
+ 860 # enum varchar(64), -- NOT NULL, 860
+ 861 # description varchar(2000),-- NOT NULL, 861
+ 862 # rank int NOT NULL DEFAULT (0), 862
+ 863 # CONSTRAINT pk_DBColumns_tableName_name PRIMARY KEY 863
+ 864 #( 864
+ 865 # tablename, 865
+ 866 # name 866
+ 867 #) 867
+ 868 #); 868
+ 869 #CREATE TABLE DBViewCols( 869
+ 870 # name varchar(64) NOT NULL, 870
+ 871 # viewname varchar(128) NOT NULL, 871
+ 872 # parent varchar(128) NOT NULL, 872
+ 873 # CONSTRAINT pk_DBViewCols_viewName_name PRIMARY KEY 873
+ 874 #( 874
+ 875 # viewname, 875
+ 876 # name 876
+ 877 #) 877
+ 878 #); 878
+ 879 #CREATE TABLE IndexMap( 879
+ 880 # indexmapid int GENERATED ALWAYS AS IDENTITY NOT NULL, 880
+ 881 # code varchar(2) NOT NULL, 881
+ 882 # type varchar(32) NOT NULL, 882
+ 883 # tableName varchar(128) NOT NULL, 883
+ 884 # fieldList varchar(1000) NOT NULL, 884
+ 885 # foreignKey varchar(1000) NOT NULL, 885
+ 886 # indexgroup varchar(128) NOT NULL, 886
+ 887 # CONSTRAINT pk_IndexMap_indexmapid PRIMARY KEY 887
+ 888 #( 888
+ 889 # indexmapid 889
+ 890 #) 890
+ 891 #); 891
+ 892 #CREATE TABLE BestTarget2Sector( 892
+ 893 # objID bigint NOT NULL, 893
+ 894 # regionID bigint NOT NULL, 894
+ 895 # status int NOT NULL, 895
+ 896 # primTarget int NOT NULL, 896
+ 897 # secTarget int NOT NULL, 897
+ 898 # petroMag_r real NOT NULL, 898
+ 899 # extinction_r real NOT NULL, 899
+ 900 # CONSTRAINT pk_BestTarget2Sector_objid_regio PRIMARY KEY 900
+ 901 #( 901
+ 902 # objID, 902
+ 903 # regionID 903
+ 904 #) 904
+ 905 #); 905
+ 906 #CREATE TABLE Segment( 906
+ 907 # segmentID bigint NOT NULL, 907
+ 908 # skyVersion tinyint NOT NULL, 908
+ 909 # run smallint NOT NULL, 909
+ 910 # camCol tinyint NOT NULL, 910
+ 911 # rerun smallint NOT NULL, 911
+ 912 # field0 int NOT NULL, 912
+ 913 # nFields int NOT NULL, 913
+ 914 # dscale int NOT NULL, 914
+ 915 # chunkID bigint NOT NULL, 915
+ 916 # startMu int NOT NULL, 916
+ 917 # endMu int NOT NULL, 917
+ 918 # stripe int NOT NULL, 918
+ 919 # strip smallint NOT NULL, 919
+ 920 # status smallint NOT NULL, 920
+ 921 # resolved smallint NOT NULL, 921
+ 922 # exported smallint NOT NULL, 922
+ 923 # families smallint NOT NULL, 923
+ 924 # equinox float NOT NULL, 924
+ 925 # node float NOT NULL, 925
+ 926 # incl float NOT NULL, 926
+ 927 #CREATE TABLE Field( 927
+ 928 # fieldID bigint NOT NULL, 928
+ 929 # skyVersion tinyint NOT NULL, 929
+ 930 # run smallint NOT NULL, 930
+ 931 # rerun smallint NOT NULL, 931
+ 932 # camcol tinyint NOT NULL, 932
+ 933 # field smallint NOT NULL, 933
+ 934 # nObjects smallint NOT NULL, 934
+ 935 # nChild int NOT NULL, 935
+ 936 # nGalaxy int NOT NULL, 936
+ 937 # nStars int NOT NULL, 937
+ 938 # numStars_u int NOT NULL, 938
+ 939 # numStars_g int NOT NULL, 939
+ 940 # numStars_r int NOT NULL, 940
+ 941 # numStars_i int NOT NULL, 941
+ 942 # numStars_z int NOT NULL, 942
+ 943 # nCR_u int NOT NULL, 943
+ 944 # nCR_g int NOT NULL, 944
+ 945 # nCR_r int NOT NULL, 945
+ 946 # nCR_i int NOT NULL, 946
+ 947 # nCR_z int NOT NULL, 947
+ 948 # nBrightObj_u int NOT NULL, 948
+ 949 #CREATE TABLE PhotoObjAll( 949
+ 950 # objID bigint NOT NULL, 950
+ 951 # skyVersion tinyint NOT NULL, 951
+ 952 # run smallint NOT NULL, 952
+ 953 # rerun smallint NOT NULL, 953
+ 954 # camcol tinyint NOT NULL, 954
+ 955 # field smallint NOT NULL, 955
+ 956 # obj smallint NOT NULL, 956
+ 957 # mode tinyint NOT NULL, 957
+ 958 # nChild smallint NOT NULL, 958
+ 959 # type smallint NOT NULL, 959
+ 960 # probPSF real NOT NULL, 960
+ 961 # insideMask tinyint NOT NULL, 961
+ 962 # flags bigint NOT NULL, 962
+ 963 # rowc real NOT NULL, 963
+ 964 # rowcErr real NOT NULL, 964
+ 965 # colc real NOT NULL, 965
+ 966 # colcErr real NOT NULL, 966
+ 967 # rowv real NOT NULL, 967
+ 968 # rowvErr real NOT NULL, 968
+ 969 # colv real NOT NULL, 969
+ 970 #CREATE TABLE PhotoTag( 970
+ 971 # objID bigint NOT NULL, 971
+ 972 # skyVersion tinyint NOT NULL, 972
+ 973 # run smallint NOT NULL, 973
+ 974 # rerun smallint NOT NULL, 974
+ 975 # camcol tinyint NOT NULL, 975
+ 976 # field smallint NOT NULL, 976
+ 977 # obj smallint NOT NULL, 977
+ 978 # mode tinyint NOT NULL, 978
+ 979 # nChild smallint NOT NULL, 979
+ 980 # type smallint NOT NULL, 980
+ 981 # probPSF real NOT NULL, 981
+ 982 # insideMask tinyint NOT NULL, 982
+ 983 # flags bigint NOT NULL, 983
+ 984 # psfMag_u real NOT NULL, 984
+ 985 # psfMag_g real NOT NULL, 985
+ 986 # psfMag_r real NOT NULL, 986
+ 987 # psfMag_i real NOT NULL, 987
+ 988 # psfMag_z real NOT NULL, 988
+ 989 # psfMagErr_u real NOT NULL, 989
+ 990 # psfMagErr_g real NOT NULL, 990
+ 991 #CREATE TABLE Frame( 991
+ 992 # fieldID bigint NOT NULL, 992
+ 993 # zoom int NOT NULL, 993
+ 994 # run int NOT NULL, 994
+ 995 # rerun int NOT NULL, 995
+ 996 # camcol int NOT NULL, 996
+ 997 # field int NOT NULL, 997
+ 998 # stripe int NOT NULL, 998
+ 999 # strip int NOT NULL, 999
+ 1000 # a float NOT NULL, 1000
+ 1001 # b float NOT NULL, 1001
+ 1002 # c float NOT NULL, 1002
+ 1003 # d float NOT NULL, 1003
+ 1004 # e float NOT NULL, 1004
+ 1005 # f float NOT NULL, 1005
+ 1006 # node float NOT NULL, 1006
+ 1007 # incl float NOT NULL, 1007
+ 1008 # raMin float NOT NULL, 1008
+ 1009 # raMax float NOT NULL, 1009
+ 1010 # decMin float NOT NULL, 1010
+ 1011 # decMax float NOT NULL, 1011
+ 1012 # mu float NOT NULL DEFAULT (0), 1012
+ 1013 # nu float NOT NULL DEFAULT (0), 1013
+ 1014 # ra float NOT NULL DEFAULT (0), 1014
+ 1015 #CREATE TABLE RunQA( 1015
+ 1016 # fieldID bigint NOT NULL, 1016
+ 1017 # skyVersion tinyint NOT NULL, 1017
+ 1018 # first tinyint NOT NULL, 1018
+ 1019 # run smallint NOT NULL, 1019
+ 1020 # rerun smallint NOT NULL, 1020
+ 1021 # camcol tinyint NOT NULL, 1021
+ 1022 # field smallint NOT NULL, 1022
+ 1023 # fieldQall tinyint NOT NULL, 1023
+ 1024 # opdbq tinyint NOT NULL, 1024
+ 1025 # appsfq tinyint NOT NULL, 1025
+ 1026 # pcmedq tinyint NOT NULL, 1026
+ 1027 # pcrmsq tinyint NOT NULL, 1027
+ 1028 # PSFwcondq tinyint NOT NULL, 1028
+ 1029 # pc_s real NOT NULL, 1029
+ 1030 # pc_w real NOT NULL, 1030
+ 1031 # pc_x real NOT NULL, 1031
+ 1032 # pc_y real NOT NULL, 1032
+ 1033 # rmsPC_s real NOT NULL, 1033
+ 1034 # rmsPC_w real NOT NULL, 1034
+ 1035 # rmsPC_x real NOT NULL, 1035
+ 1036 #CREATE TABLE FieldProfile( 1036
+ 1037 # bin tinyint NOT NULL, 1037
+ 1038 # band tinyint NOT NULL, 1038
+ 1039 # profMean real NOT NULL, 1039
+ 1040 # profMed real NOT NULL, 1040
+ 1041 # profSig real NOT NULL, 1041
+ 1042 # fieldID bigint NOT NULL, 1042
+ 1043 # CONSTRAINT pk_FieldProfile_fieldID_bin_band PRIMARY KEY 1043
+ 1044 #( 1044
+ 1045 # fieldID, 1045
+ 1046 # bin, 1046
+ 1047 # band 1047
+ 1048 #) 1048
+ 1049 #); 1049
+ 1050 #CREATE TABLE PhotoProfile( 1050
+ 1051 # bin tinyint NOT NULL, 1051
+ 1052 # band tinyint NOT NULL, 1052
+ 1053 # profMean real NOT NULL, 1053
+ 1054 # profErr real NOT NULL, 1054
+ 1055 # objID bigint NOT NULL, 1055
+ 1056 # CONSTRAINT pk_PhotoProfile_objID_bin_band PRIMARY KEY 1056
+ 1057 #( 1057
+ 1058 # objID, 1058
+ 1059 # bin, 1059
+ 1060 # band 1060
+ 1061 #) 1061
+ 1062 #); 1062
+ 1063 #CREATE TABLE USNOB( 1063
+ 1064 # raErr float NOT NULL, 1064
+ 1065 # decErr float NOT NULL, 1065
+ 1066 # raDecCorr float NOT NULL, 1066
+ 1067 # delta real NOT NULL, 1067
+ 1068 # "match" int NOT NULL, 1068
+ 1069 # pmL real NOT NULL, 1069
+ 1070 # pmB real NOT NULL, 1070
+ 1071 # pmRa real NOT NULL, 1071
+ 1072 # pmDec real NOT NULL, 1072
+ 1073 # pmRaErr real NOT NULL, 1073
+ 1074 # pmDecErr real NOT NULL, 1074
+ 1075 # sigRa real NOT NULL, 1075
+ 1076 # sigDec real NOT NULL, 1076
+ 1077 # nFit int NOT NULL, 1077
+ 1078 # O real NOT NULL, 1078
+ 1079 # E real NOT NULL, 1079
+ 1080 # J real NOT NULL, 1080
+ 1081 # F real NOT NULL, 1081
+ 1082 # N real NOT NULL, 1082
+ 1083 # dist20 real NOT NULL, 1083
+ 1084 # dist22 real NOT NULL, 1084
+ 1085 # objid bigint NOT NULL, 1085
+ 1086 # CONSTRAINT pk_USNOB_objID PRIMARY KEY 1086
+ 1087 #CREATE TABLE USNO( 1087
+ 1088 # delta real NOT NULL, 1088
+ 1089 # "match" int NOT NULL, 1089
+ 1090 # propermotion real NOT NULL, 1090
+ 1091 # angle real NOT NULL, 1091
+ 1092 # blue real NOT NULL, 1092
+ 1093 # red real NOT NULL, 1093
+ 1094 # objID bigint NOT NULL, 1094
+ 1095 # CONSTRAINT pk_USNO_objID PRIMARY KEY 1095
+ 1096 #( 1096
+ 1097 # objID 1097
+ 1098 #) 1098
+ 1099 #); 1099
+ 1100 #CREATE TABLE PhotoAuxAll( 1100
+ 1101 # objid bigint NOT NULL, 1101
+ 1102 # mode tinyint NOT NULL, 1102
+ 1103 # b float NOT NULL, 1103
+ 1104 # l float NOT NULL, 1104
+ 1105 # raErr float NOT NULL, 1105
+ 1106 # decErr float NOT NULL, 1106
+ 1107 # raDecCorr float NOT NULL, 1107
+ 1108 # CONSTRAINT pk_PhotoAuxAll_objID PRIMARY KEY 1108
+ 1109 #( 1109
+ 1110 # objid 1110
+ 1111 #) 1111
+ 1112 #); 1112
+ 1113 #CREATE TABLE Photoz( 1113
+ 1114 # pId int NOT NULL, 1114
+ 1115 # rank int NOT NULL, 1115
+ 1116 # version varchar(6) NOT NULL, 1116
+ 1117 # class int NOT NULL, 1117
+ 1118 # objID bigint NOT NULL, 1118
+ 1119 # chiSq real NOT NULL, 1119
+ 1120 # z real NOT NULL, 1120
+ 1121 # zErr real NOT NULL, 1121
+ 1122 # t real NOT NULL, 1122
+ 1123 # tErr real NOT NULL, 1123
+ 1124 # c_tt real NOT NULL, 1124
+ 1125 # c_tz real NOT NULL, 1125
+ 1126 # c_zz real NOT NULL, 1126
+ 1127 # fitRadius int NOT NULL, 1127
+ 1128 # fitThreshold real NOT NULL, 1128
+ 1129 # quality int NOT NULL, 1129
+ 1130 # dmod real NOT NULL, 1130
+ 1131 # rest_ug real NOT NULL, 1131
+ 1132 # rest_gr real NOT NULL, 1132
+ 1133 # rest_ri real NOT NULL, 1133
+ 1134 # rest_iz real NOT NULL, 1134
+ 1135 # kcorr_u real NOT NULL, 1135
+ 1136 #CREATE TABLE First( 1136
+ 1137 # delta real NOT NULL, 1137
+ 1138 # "match" int NOT NULL, 1138
+ 1139 # peak real NOT NULL, 1139
+ 1140 # integr real NOT NULL, 1140
+ 1141 # rms real NOT NULL, 1141
+ 1142 # major real NOT NULL, 1142
+ 1143 # minor real NOT NULL, 1143
+ 1144 # pa real NOT NULL, 1144
+ 1145 # id int NOT NULL, 1145
+ 1146 # lambda float NOT NULL, 1146
+ 1147 # eta float NOT NULL, 1147
+ 1148 # objID bigint NOT NULL, 1148
+ 1149 # CONSTRAINT pk_First_objID PRIMARY KEY 1149
+ 1150 #( 1150
+ 1151 # objID 1151
+ 1152 #) 1152
+ 1153 #); 1153
+ 1154 #CREATE TABLE Rosat( 1154
+ 1155 # delta real NOT NULL, 1155
+ 1156 # "match" int NOT NULL, 1156
+ 1157 # cps real NOT NULL, 1157
+ 1158 # hard1 real NOT NULL, 1158
+ 1159 # hard2 real NOT NULL, 1159
+ 1160 # extent real NOT NULL, 1160
+ 1161 # exposure real NOT NULL, 1161
+ 1162 # posErr real NOT NULL, 1162
+ 1163 # cpsErr real NOT NULL, 1163
+ 1164 # hard1Err real NOT NULL, 1164
+ 1165 # hard2Err real NOT NULL, 1165
+ 1166 # extentLike real NOT NULL, 1166
+ 1167 # detectLike real NOT NULL, 1167
+ 1168 # objID bigint NOT NULL, 1168
+ 1169 # CONSTRAINT pk_Rosat_objID PRIMARY KEY 1169
+ 1170 #( 1170
+ 1171 # objID 1171
+ 1172 #) 1172
+ 1173 #); 1173
+ 1174 #CREATE TABLE ObjMask( 1174
+ 1175 # objID bigint NOT NULL, 1175
+ 1176 # size int NOT NULL, 1176
+ 1177 # nspan int NOT NULL, 1177
+ 1178 # row0 int NOT NULL, 1178
+ 1179 # col0 int NOT NULL, 1179
+ 1180 # rmin int NOT NULL, 1180
+ 1181 # rmax int NOT NULL, 1181
+ 1182 # cmin int NOT NULL, 1182
+ 1183 # cmax int NOT NULL, 1183
+ 1184 # npix int NOT NULL, 1184
+ 1185 # span text NOT NULL, 1185
+ 1186 # CONSTRAINT pk_ObjMask_objID PRIMARY KEY 1186
+ 1187 #( 1187
+ 1188 # objID 1188
+ 1189 #) 1189
+ 1190 #); 1190
+ 1191 #CREATE TABLE MatchHead( 1191
+ 1192 # objID bigint NOT NULL, 1192
+ 1193 # averageRa float NOT NULL DEFAULT (0), 1193
+ 1194 # averageDec float NOT NULL DEFAULT (0), 1194
+ 1195 # varRa float NOT NULL DEFAULT (0), 1195
+ 1196 # varDec float NOT NULL DEFAULT (0), 1196
+ 1197 # matchCount tinyint NOT NULL DEFAULT (0), 1197
+ 1198 # missCount tinyint NOT NULL DEFAULT (0), 1198
+ 1199 # CONSTRAINT pk_MatchHead_objID PRIMARY KEY 1199
+ 1200 #( 1200
+ 1201 # objID 1201
+ 1202 #) 1202
+ 1203 #); 1203
+ 1204 #CREATE TABLE MaskedObject( 1204
+ 1205 # objid bigint NOT NULL, 1205
+ 1206 # maskID bigint NOT NULL, 1206
+ 1207 # maskType int NOT NULL, 1207
+ 1208 # CONSTRAINT pk_MaskedObject_objid_maskid PRIMARY KEY 1208
+ 1209 #( 1209
+ 1210 # objid, 1210
+ 1211 # maskID 1211
+ 1212 #) 1212
+ 1213 #); 1213
+ 1214 #CREATE TABLE Neighbors( 1214
+ 1215 # objID bigint NOT NULL, 1215
+ 1216 # neighborObjID bigint NOT NULL, 1216
+ 1217 # distance float NOT NULL, 1217
+ 1218 # type tinyint NOT NULL, 1218
+ 1219 # neighborType tinyint NOT NULL, 1219
+ 1220 # mode tinyint NOT NULL, 1220
+ 1221 # neighborMode tinyint NOT NULL, 1221
+ 1222 # CONSTRAINT pk_Neighbors_objID_NeighborObjID PRIMARY KEY 1222
+ 1223 #( 1223
+ 1224 # objID, 1224
+ 1225 # neighborObjID 1225
+ 1226 #) 1226
+ 1227 #); 1227
+ 1228 #CREATE TABLE Zone( 1228
+ 1229 # zoneID int NOT NULL, 1229
+ 1230 # ra float NOT NULL, 1230
+ 1231 # "dec" float NOT NULL, 1231
+ 1232 # objID bigint NOT NULL, 1232
+ 1233 # type tinyint NOT NULL, 1233
+ 1234 # mode tinyint NOT NULL, 1234
+ 1235 # cx float NOT NULL, 1235
+ 1236 # cy float NOT NULL, 1236
+ 1237 # cz float NOT NULL, 1237
+ 1238 # native tinyint NOT NULL, 1238
+ 1239 # CONSTRAINT pk_Zone_zoneID_ra_objID PRIMARY KEY 1239
+ 1240 #( 1240
+ 1241 # zoneID, 1241
+ 1242 # ra, 1242
+ 1243 # objID 1243
+ 1244 #) 1244
+ 1245 #); 1245
+ 1246 #CREATE TABLE FileGroupMap( 1246
+ 1247 # tableName varchar(128) NOT NULL, 1247
+ 1248 # tableFileGroup varchar(100) NOT NULL, 1248
+ 1249 # indexFileGroup varchar(100) NOT NULL, 1249
+ 1250 # comment varchar(4000) NULL, 1250
+ 1251 # CONSTRAINT pk_FileGroupMap_tableName PRIMARY KEY 1251
+ 1252 #( 1252
+ 1253 # tableName 1253
+ 1254 #) 1254
+ 1255 #); 1255
+ 1256 #CREATE TABLE Chunk( 1256
+ 1257 # chunkID bigint NOT NULL, 1257
+ 1258 # skyVersion tinyint NOT NULL, 1258
+ 1259 # targetVersion varchar(32) NOT NULL, 1259
+ 1260 # startMu int NOT NULL, 1260
+ 1261 # endMu int NOT NULL, 1261
+ 1262 # stripe int NOT NULL, 1262
+ 1263 # exportVersion varchar(32) NOT NULL, 1263
+ 1264 # loadVersion int NOT NULL, 1264
+ 1265 # CONSTRAINT pk_Chunk_chunkID PRIMARY KEY 1265
+ 1266 #( 1266
+ 1267 # chunkID 1267
+ 1268 #) 1268
+ 1269 #); 1269
+ 1270 #CREATE TABLE sysobjects( 1270
+ 1271 # id int, 1271
+ 1272 # uid int, 1272
+ 1273 # nme char(100) 1273
+ 1274 #); 1274
+ 1275 #CREATE TABLE sysusers( 1275
+ 1276 # id int, 1276
+ 1277 # uid int, 1277
+ 1278 # nme char(100) 1278
+ 1279 #); 1279
+ 1280 #CREATE TABLE systypes( 1280
+ 1281 # id int, 1281
+ 1282 # uid int, 1282
+ 1283 # nme char(100), 1283
+ 1284 # xtype char(100) 1284
+ 1285 #); 1285
+ 1286 #CREATE TABLE syscolumns( 1286
+ 1287 # id int, 1287
+ 1288 # colid int, 1288
+ 1289 # isoutparam int, 1289
+ 1290 # length int, 1290
+ 1291 # uid int, 1291
+ 1292 # nme char(100), 1292
+ 1293 # xtype char(100) 1293
+ 1294 #); 1294
+ 1295 #CREATE TABLE spt_datatype_info( 1295
+ 1296 # length int, 1296
+ 1297 # ss_dtype varchar(100), 1297
+ 1298 # "AUTO_INCREMENT" varchar(100) 1298
+ 1299 #); 1299
+ 1300 #COMMIT; 1300
+ 1301 #SET SCHEMA "skyserver"; 1301
+ 1302 #COPY 25000 RECORDS INTO RC3 FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/RC3.dat.bz2' USING DELIMITERS E'\t', E'\015\n', '"'; 1302
30 [ 0 ] 30 1303 [ 0 ] 1303
31 [ 2042 ] 31 ! 1304 #COPY 1000 RECORDS INTO QsoCatalogAll FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/QsoCatalogAll.dat.bz2' USING DELIMITERS E'\t', E'\015\n', '"'; 1304
32 [ 0 ] 32 1305 [ 0 ] 1305
..................
# 14:14:17 >
32 [ 0 ] 32 1305 [ 0 ] 1305
+ 1306 #COPY 100 RECORDS INTO QsoConcordance FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/QsoConcordance.dat.bz2' USING DELIMITERS E'\t', E'\015\n', '"'; 1306
33 [ 0 ] 33 1307 [ 0 ] 1307
34 [ 923 ] 34 ! 1308 #COPY 1000 RECORDS INTO TargetParam FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/TargetParam.dat.bz2' USING DELIMITERS E'\t', E'\015\n', '"'; 1308
35 [ 88 ] 35 -
36 [ 0 ] 36 1309 [ 0 ] 1309
37 [ 12 ] 37 -
38 #select 'Region'; 38 1310 #select 'Region'; 1310
..................
# L2 # name
45 [ "Region" ] 45 1317 [ "Region" ] 1317
+ 1318 #COPY 28000 RECORDS INTO Region FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/Region1.dat.bz2' USING DELIMITERS E'\t', '|', '"'; 1318
46 [ 1 ] 46 1319 [ 1 ] 1319
47 [ 8 ] 47 ! 1320 #COPY 1000 RECORDS INTO QueryResults FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/QueryResults.dat.bz2' USING DELIMITERS E'\t', E'\015\n', '"'; 1320
48 [ 0 ] 48 1321 [ 0 ] 1321
..................
# L2 # name
48 [ 0 ] 48 1321 [ 0 ] 1321
+ 1322 #COPY 1000 RECORDS INTO RecentQueries FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/RecentQueries.dat.bz2' USING DELIMITERS E'\t', E'\015\n', '"'; 1322
49 [ 0 ] 49 1323 [ 0 ] 1323
50 [ 7 ] 50 ! 1324 #COPY 1000 RECORDS INTO Glossary FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/Glossary1.dat.bz2' USING DELIMITERS E'\t', '|'; 1324
51 [ 165 ] 51 1325 [ 165 ] 1325
..................
# L2 # name
52 [ 23 ] 52 1327 [ 23 ] 1327
+ 1328 #COPY 1000 RECORDS INTO TableDesc FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/TableDesc1.dat.bz2' USING DELIMITERS E'\t', '|', '"'; 1328
53 [ 94 ] 53 1329 [ 94 ] 1329
54 [ 421 ] 54 ! 1330 #COPY 1000 RECORDS INTO PubHistory FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/PubHistory.dat.bz2' USING DELIMITERS E'\t', E'\015\n', '"'; 1330
55 [ 664 ] 55 -
56 [ 398 ] 56 -
57 [ 0 ] 57 1331 [ 0 ] 1331
..................
# L2 # name
57 [ 0 ] 57 1331 [ 0 ] 1331
+ 1332 #COPY 1000 RECORDS INTO LoadHistory FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/LoadHistory.dat.bz2' USING DELIMITERS E'\t', E'\015\n', '"'; 1332
58 [ 0 ] 58 1333 [ 0 ] 1333
59 [ 536 ] 59 ! 1334 #COPY 1000 RECORDS INTO DataConstants FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/DataConstants1.dat.bz2' USING DELIMITERS E'\t', '|', '"'; 1334
60 [ 536 ] 60 -
61 [ 9 ] 61 -
62 [ 11 ] 62 -
63 [ 326 ] 63 1335 [ 326 ] 1335
64 [ 47 ] 64 ! 1336 #COPY 20000 RECORDS INTO Mask FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/Mask.dat.bz2' USING DELIMITERS E'\t', E'\015\n', '"'; 1336
65 [ 48 ] 65 -
66 [ 9 ] 66 -
67 [ 15 ] 67 -
68 [ 0 ] 68 -
69 [ 16 ] 69 -
70 [ 41 ] 70 -
71 [ 4 ] 71 -
72 [ 0 ] 72 1337 [ 0 ] 1337
+ 1338 #COPY 1000 RECORDS INTO SpecPhotoAll FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/SpecPhotoAll.dat.bz2' USING DELIMITERS E'\t', E'\015\n', '"'; 1338
+ 1339 [ 0 ] 1339
+ 1340 #COPY 1000 RECORDS INTO QuasarCatalog FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/QuasarCatalog.dat.bz2' USING DELIMITERS E'\t', E'\015\n', '"'; 1340
73 [ 0 ] 73 1341 [ 0 ] 1341
74 [ 2017 ] 74 -
75 [ 2173 ] 75 -
76 [ 37 ] 76 -
77 [ 923 ] 77 -
78 #select 'TiledTargetAll'; 78 1342 #select 'TiledTargetAll'; 1342
..................
# L2 # name
85 [ "TiledTargetAll" ] 85 1349 [ "TiledTargetAll" ] 1349
86 [ 968 ] 86 ! 1350 #COPY 1000 RECORDS INTO TilingNote FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/TilingNote.dat.bz2' USING DELIMITERS E'\t', E'\015\n', '"'; 1350
87 [ 12 ] 87 -
88 [ 1 ] 88 -
89 [ 7312 ] 89 -
90 [ 12 ] 90 -
91 [ 0 ] 91 1351 [ 0 ] 1351
92 [ 219 ] 92 ! 1352 #COPY 40000 RECORDS INTO RegionConvex FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/RegionConvex.dat.bz2' USING DELIMITERS E'\t', E'\015\n', '"'; 1352
93 [ 0 ] 93 1353 [ 0 ] 1353
94 [ 1 ] 94 -
95 [ 22 ] 95 -
96 [ 1 ] 96 -
97 [ 22 ] 97 -
98 [ 421 ] 98 -
99 [ 2031 ] 99 -
100 [ 88 ] 100 -
101 [ 196 ] 101 -
102 [ 11 ] 102 -
103 [ 1 ] 103 -
104 [ 1 ] 104 -
105 [ 187 ] 105 -
106 #select count(*) from PhotoObjAll; 106 1354 #select count(*) from PhotoObjAll; 1354
..................
# L3 # name
110 % bigint # type 110 1358 % bigint # type 1358
111 % 3 # length 111 ! 1359 % 1 # length 1359
112 [ 187 ] 112 ! 1360 [ 0 ] 1360
113 [ 187 ] 113 ! 1361 #COPY 1000 RECORDS INTO Photoz FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/Photoz.dat.bz2' USING DELIMITERS E'\t', E'\015\n', '"'; 1361
114 [ 4 ] 114 -
115 [ 1 ] 115 -
116 [ 50 ] 116 -
117 [ 6415 ] 117 -
118 [ 26 ] 118 -
119 [ 19 ] 119 -
120 [ 187 ] 120 -
121 [ 0 ] 121 1362 [ 0 ] 1362
..................
# L3 # name
122 [ 0 ] 122 1364 [ 0 ] 1364
+ 1365 #COPY 1000 RECORDS INTO Rosat FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/Rosat.dat.bz2' USING DELIMITERS E'\t', E'\015\n', '"'; 1365
123 [ 0 ] 123 1366 [ 0 ] 1366
124 [ 177 ] 124 ! 1367 #COPY 3000 RECORDS INTO MaskedObject FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/MaskedObject.dat.bz2' USING DELIMITERS E'\t', E'\015\n', '"'; 1367
125 [ 16 ] 125 -
126 [ 0 ] 126 1368 [ 0 ] 1368
127 [ 770 ] 127 ! 1369 #COPY 1000 RECORDS INTO FileGroupMap FROM 'C:\\monettesting\\cbeba89afadb-9-2-2\\MonetDB\\sql\\test\\Skyserver\\Tests\\..\\microsky/FileGroupMap.dat.bz2' USING DELIMITERS E'\t', E'\015\n', '"'; 1369
128 [ 0 ] 128 1370 [ 0 ] 1370
129 [ 84 ] 129 -
130 #select 'ALL DONE'; 130 1371 #select 'ALL DONE'; 1371