IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Apr 2, 2009, 11:55:52 AM (17 years ago)
Author:
Paul Price
Message:

Removing warpSkyfile.ignored from database, in favour of using the quality flags. This means that we can ignore skycells on the basis of usefulness (whether we can measure the PSF) rather than an arbitrary cut of 10% lit pixels (which pixels may or may not be useful).

File:
1 edited

Legend:

Unmodified
Added
Removed

  • branches/pap/ippTools/share/pxadmin_create_tables.sql

    r23532 r23677  
    1818    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    1919    PRIMARY KEY(exp_name, camera, telescope),
    20     KEY(fault))
    21 ENGINE=innodb DEFAULT CHARSET=latin1;
     20    KEY(fault)
     21) ENGINE=innodb DEFAULT CHARSET=latin1;
    2222
    2323CREATE TABLE summitImfile (
    … …  
    3434    PRIMARY KEY(exp_name, camera, telescope, class, class_id),
    3535    KEY(file_id),
    36     FOREIGN KEY (exp_name, camera, telescope)
    37         REFERENCES  summitExp(exp_name, camera, telescope))
    38 ENGINE=innodb DEFAULT CHARSET=latin1;
     36    FOREIGN KEY(exp_name, camera, telescope) REFERENCES summitExp(exp_name, camera, telescope)
     37) ENGINE=innodb DEFAULT CHARSET=latin1;
    3938
    4039CREATE TABLE pzDownloadExp (
    … …  
    4645    PRIMARY KEY(exp_name, camera, telescope),
    4746    KEY(state),
    48     FOREIGN KEY (exp_name, camera, telescope)
    49         REFERENCES  summitExp(exp_name, camera, telescope))
    50 ENGINE=innodb DEFAULT CHARSET=latin1;
     47    FOREIGN KEY(exp_name, camera, telescope) REFERENCES summitExp(exp_name, camera, telescope)
     48) ENGINE=innodb DEFAULT CHARSET=latin1;
    5149
    5250CREATE TABLE pzDownloadImfile (
    … …  
    6260    PRIMARY KEY(exp_name, camera, telescope, class, class_id),
    6361    KEY(fault),
    64     FOREIGN KEY (exp_name, camera, telescope)
    65         REFERENCES  pzDownloadExp(exp_name, camera, telescope),
    66     FOREIGN KEY (exp_name, camera, telescope, class, class_id)
    67         REFERENCES  summitImfile(exp_name, camera, telescope, class, class_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
     62    FOREIGN KEY (exp_name, camera, telescope) REFERENCES pzDownloadExp(exp_name, camera, telescope),
     63    FOREIGN KEY(exp_name, camera, telescope, class, class_id) REFERENCES summitImfile(exp_name, camera, telescope, class, class_id)
     64) ENGINE=innodb DEFAULT CHARSET=latin1;
    6865
    6966CREATE TABLE newExp (
    … …  
    9895    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    9996    PRIMARY KEY(exp_id, tmp_class_id),
    100     FOREIGN KEY (exp_id)
    101         REFERENCES  newExp(exp_id))
    102 ENGINE=innodb DEFAULT CHARSET=latin1;
     97    FOREIGN KEY(exp_id) REFERENCES newExp(exp_id)
     98) ENGINE=innodb DEFAULT CHARSET=latin1;
    10399
    104100CREATE TABLE rawExp (
    … …  
    172168    KEY(end_stage),
    173169    KEY(fault),
    174     FOREIGN KEY (exp_id)
    175         REFERENCES  newExp(exp_id))
    176 ENGINE=innodb DEFAULT CHARSET=latin1;
     170    FOREIGN KEY(exp_id) REFERENCES newExp(exp_id)
     171) ENGINE=innodb DEFAULT CHARSET=latin1;
    177172
    178173CREATE TABLE rawImfile (
    … …  
    246241    KEY(fault),
    247242    KEY(raw_image_id),
     243    KEY(quality),
    248244    UNIQUE KEY(exp_id, tmp_class_id),
    249     FOREIGN KEY (exp_id, tmp_class_id)
    250         REFERENCES newImfile(exp_id, tmp_class_id))
    251 ENGINE=innodb DEFAULT CHARSET=latin1;
     245    FOREIGN KEY(exp_id, tmp_class_id) REFERENCES newImfile(exp_id, tmp_class_id)
     246) ENGINE=innodb DEFAULT CHARSET=latin1;
    252247
    253248CREATE TABLE chipRun (
    … …  
    272267    KEY(end_stage),
    273268    INDEX(chip_id, exp_id),
    274     FOREIGN KEY (exp_id)
    275         REFERENCES rawExp(exp_id))
    276 ENGINE=innodb DEFAULT CHARSET=latin1;
     269    FOREIGN KEY(exp_id) REFERENCES rawExp(exp_id)
     270) ENGINE=innodb DEFAULT CHARSET=latin1;
    277271
    278272CREATE TABLE chipImfile (
    … …  
    282276    PRIMARY KEY(chip_id, class_id),
    283277    KEY(chip_imfile_id),
    284     FOREIGN KEY (chip_id) REFERENCES  chipRun(chip_id))
    285 ENGINE=innodb DEFAULT CHARSET=latin1;
     278    FOREIGN KEY(chip_id) REFERENCES chipRun(chip_id)
     279) ENGINE=innodb DEFAULT CHARSET=latin1;
    286280
    287281CREATE TABLE chipProcessedImfile (
    … …  
    348342    KEY(data_state),
    349343    KEY(fault),
    350     FOREIGN KEY (chip_id, exp_id) REFERENCES  chipRun(chip_id, exp_id),
    351     FOREIGN KEY (exp_id, class_id) REFERENCES  rawImfile(exp_id, class_id))
    352 ENGINE=innodb DEFAULT CHARSET=latin1;
     344    KEY(quality),
     345    FOREIGN KEY(chip_id, exp_id) REFERENCES chipRun(chip_id, exp_id),
     346    FOREIGN KEY(exp_id, class_id) REFERENCES rawImfile(exp_id, class_id)
     347) ENGINE=innodb DEFAULT CHARSET=latin1;
    353348
    354349CREATE TABLE chipMask (
    355350    label VARCHAR(64),
    356     PRIMARY KEY(label))
    357 ENGINE=innodb DEFAULT CHARSET=latin1;
     351    PRIMARY KEY(label)
     352) ENGINE=innodb DEFAULT CHARSET=latin1;
    358353
    359354CREATE TABLE camRun (
    … …  
    378373    KEY(end_stage),
    379374    INDEX(cam_id, chip_id),
    380     FOREIGN KEY (chip_id)
    381         REFERENCES chipRun(chip_id))
    382 ENGINE=innodb DEFAULT CHARSET=latin1;
     375    FOREIGN KEY(chip_id) REFERENCES chipRun(chip_id)
     376) ENGINE=innodb DEFAULT CHARSET=latin1;
    383377
    384378CREATE TABLE camProcessedExp (
    … …  
    446440    PRIMARY KEY(cam_id),
    447441    KEY(fault),
    448     FOREIGN KEY (cam_id)
    449         REFERENCES camRun(cam_id))
    450 ENGINE=innodb DEFAULT CHARSET=latin1;
     442    KEY(quality),
     443    FOREIGN KEY(cam_id) REFERENCES camRun(cam_id)
     444) ENGINE=innodb DEFAULT CHARSET=latin1;
    451445
    452446CREATE TABLE camMask (
    453447    label VARCHAR(64),
    454     PRIMARY KEY(label))
    455 ENGINE=innodb DEFAULT CHARSET=latin1;
     448    PRIMARY KEY(label)
     449) ENGINE=innodb DEFAULT CHARSET=latin1;
    456450
    457451CREATE TABLE fakeRun (
    … …  
    474468    KEY(end_stage),
    475469    INDEX(fake_id, cam_id),
    476     FOREIGN KEY (cam_id)
    477         REFERENCES camRun(cam_id))
    478 ENGINE=innodb DEFAULT CHARSET=latin1;
     470    FOREIGN KEY(cam_id) REFERENCES camRun(cam_id)
     471) ENGINE=innodb DEFAULT CHARSET=latin1;
    479472
    480473CREATE TABLE fakeProcessedImfile (
    … …  
    492485    PRIMARY KEY(fake_id, exp_id, class_id),
    493486    KEY(fault),
    494     FOREIGN KEY (fake_id)
    495         REFERENCES fakeRun(fake_id),
    496     FOREIGN KEY (exp_id, class_id)
    497         REFERENCES rawImfile(exp_id, class_id))
    498 ENGINE=innodb DEFAULT CHARSET=latin1;
     487    FOREIGN KEY(fake_id) REFERENCES fakeRun(fake_id),
     488    FOREIGN KEY(exp_id, class_id) REFERENCES rawImfile(exp_id, class_id)
     489) ENGINE=innodb DEFAULT CHARSET=latin1;
    499490
    500491CREATE TABLE fakeMask (
    501492    label VARCHAR(64),
    502     PRIMARY KEY(label))
    503 ENGINE=innodb DEFAULT CHARSET=latin1;
     493    PRIMARY KEY(label)
     494) ENGINE=innodb DEFAULT CHARSET=latin1;
    504495
    505496CREATE TABLE detRun (
    … …  
    534525    ref_det_id BIGINT,
    535526    ref_iter INT,
    536     -- parent INT, :: dropping this
    537527    PRIMARY KEY(det_id),
    538528    KEY(det_id),
    … …  
    542532    KEY(state),
    543533    KEY(label),
    544     -- KEY(parent), :: dropping this
    545     INDEX(det_id, iteration))
    546 ENGINE=innodb DEFAULT CHARSET=latin1;
     534    INDEX(det_id, iteration)
     535) ENGINE=innodb DEFAULT CHARSET=latin1;
    547536
    548537CREATE TABLE detInputExp (
    549 det_id BIGINT,
    550 iteration INT,
    551 exp_id BIGINT,
    552 include TINYINT,
    553 PRIMARY KEY(det_id, iteration, exp_id),
    554 INDEX(det_id, exp_id),
    555 INDEX(det_id, iteration),
    556 FOREIGN KEY (det_id)
    557 REFERENCES  detRun(det_id),
    558 FOREIGN KEY (exp_id)
    559 REFERENCES  rawExp(exp_id))
    560 ENGINE=innodb DEFAULT CHARSET=latin1;
     538    det_id BIGINT,
     539    iteration INT,
     540    exp_id BIGINT,
     541    include TINYINT,
     542    PRIMARY KEY(det_id, iteration, exp_id),
     543    INDEX(det_id, exp_id),
     544    INDEX(det_id, iteration),
     545    FOREIGN KEY(det_id) REFERENCES detRun(det_id),
     546    FOREIGN KEY(exp_id) REFERENCES rawExp(exp_id)
     547) ENGINE=innodb DEFAULT CHARSET=latin1;
    561548
    562549CREATE TABLE detProcessedImfile (
    … …  
    584571    INDEX(det_id, class_id),
    585572    INDEX(det_id, exp_id),
    586     FOREIGN KEY (det_id, exp_id)
    587         REFERENCES  detInputExp(det_id, exp_id),
    588     FOREIGN KEY (exp_id, class_id)
    589         REFERENCES  rawImfile(exp_id, class_id)
     573    FOREIGN KEY(det_id, exp_id) REFERENCES detInputExp(det_id, exp_id),
     574    FOREIGN KEY(exp_id, class_id) REFERENCES rawImfile(exp_id, class_id)
    590575) ENGINE=innodb DEFAULT CHARSET=latin1;
    591576
    … …  
    610595    PRIMARY KEY(det_id, exp_id),
    611596    KEY(fault),
    612     FOREIGN KEY (det_id, exp_id)
    613         REFERENCES  detInputExp(det_id, exp_id),
    614     FOREIGN KEY (det_id, exp_id)
    615         REFERENCES  detProcessedImfile(det_id, exp_id)
     597    FOREIGN KEY(det_id, exp_id) REFERENCES detInputExp(det_id, exp_id),
     598    FOREIGN KEY(det_id, exp_id) REFERENCES detProcessedImfile(det_id, exp_id)
    616599) ENGINE=innodb DEFAULT CHARSET=latin1;
    617600
    … …  
    634617    PRIMARY KEY(det_id, iteration, class_id),
    635618    KEY(fault),
    636     FOREIGN KEY (det_id, iteration)
    637         REFERENCES  detInputExp(det_id, iteration),
    638     FOREIGN KEY (det_id, class_id)
    639         REFERENCES  detProcessedImfile(det_id, class_id)
     619    FOREIGN KEY(det_id, iteration) REFERENCES detInputExp(det_id, iteration),
     620    FOREIGN KEY(det_id, class_id) REFERENCES detProcessedImfile(det_id, class_id)
    640621) ENGINE=innodb DEFAULT CHARSET=latin1;
    641622
    … …  
    649630    PRIMARY KEY(det_id, iteration, class_id),
    650631    KEY(fault),
    651     FOREIGN KEY (det_id, iteration)
    652     REFERENCES  detInputExp(det_id, iteration),
    653     FOREIGN KEY (det_id, iteration, class_id)
    654     REFERENCES  detStackedImfile(det_id, iteration, class_id)
     632    FOREIGN KEY(det_id, iteration) REFERENCES detInputExp(det_id, iteration),
     633    FOREIGN KEY(det_id, iteration, class_id) REFERENCES  detStackedImfile(det_id, iteration, class_id)
    655634) ENGINE=innodb DEFAULT CHARSET=latin1;
    656635
    … …  
    674653    KEY(fault),
    675654    INDEX(det_id, iteration),
    676     FOREIGN KEY (det_id)
    677     REFERENCES  detInputExp(det_id),
    678     FOREIGN KEY (det_id, iteration, class_id)
    679     REFERENCES  detNormalizedStatImfile(det_id, iteration, class_id)
     655    FOREIGN KEY(det_id) REFERENCES detInputExp(det_id),
     656    FOREIGN KEY(det_id, iteration, class_id) REFERENCES detNormalizedStatImfile(det_id, iteration, class_id)
    680657) ENGINE=innodb DEFAULT CHARSET=latin1;
    681658
    … …  
    697674    PRIMARY KEY(det_id, iteration),
    698675    KEY(fault),
    699     FOREIGN KEY (det_id, iteration)
    700     REFERENCES  detInputExp(det_id, iteration),
    701     FOREIGN KEY (det_id, iteration)
    702     REFERENCES  detNormalizedImfile(det_id, iteration)
     676    FOREIGN KEY(det_id, iteration) REFERENCES detInputExp(det_id, iteration),
     677    FOREIGN KEY(det_id, iteration) REFERENCES detNormalizedImfile(det_id, iteration)
    703678) ENGINE=innodb DEFAULT CHARSET=latin1;
    704679
    … …  
    735710    KEY(fault),
    736711    INDEX(det_id, iteration, exp_id),
    737     FOREIGN KEY (det_id, iteration, exp_id)
    738     REFERENCES  detInputExp(det_id, iteration, exp_id),
    739     FOREIGN KEY (det_id, exp_id, class_id)
    740     REFERENCES  detProcessedImfile(det_id, exp_id, class_id)
     712    FOREIGN KEY (det_id, iteration, exp_id) REFERENCES detInputExp(det_id, iteration, exp_id),
     713    FOREIGN KEY (det_id, exp_id, class_id) REFERENCES detProcessedImfile(det_id, exp_id, class_id)
    741714) ENGINE=innodb DEFAULT CHARSET=latin1;
    742715
    … …  
    770743       KEY(fault),
    771744       INDEX(det_id, iteration),
    772        FOREIGN KEY (det_id, iteration, exp_id)
    773        REFERENCES  detInputExp(det_id, iteration, exp_id),
    774        FOREIGN KEY (det_id, iteration, exp_id)
    775        REFERENCES  detResidImfile(det_id, iteration, exp_id)
     745       FOREIGN KEY(det_id, iteration, exp_id) REFERENCES detInputExp(det_id, iteration, exp_id),
     746       FOREIGN KEY(det_id, iteration, exp_id) REFERENCES detResidImfile(det_id, iteration, exp_id)
    776747) ENGINE=innodb DEFAULT CHARSET=latin1;
    777748
    … …  
    787758       PRIMARY KEY(det_id, iteration),
    788759       KEY(fault),
    789        FOREIGN KEY (det_id, iteration)
    790          REFERENCES  detInputExp(det_id, iteration),
    791        FOREIGN KEY (det_id, iteration)
    792          REFERENCES  detResidExp(det_id, iteration)
     760       FOREIGN KEY(det_id, iteration) REFERENCES detInputExp(det_id, iteration),
     761       FOREIGN KEY(det_id, iteration) REFERENCES detResidExp(det_id, iteration)
    793762) ENGINE=innodb DEFAULT CHARSET=latin1;
    794763
    … …  
    811780       PRIMARY KEY(det_id, iteration, class_id),
    812781       KEY(fault),
    813        FOREIGN KEY (det_id, iteration)
    814          REFERENCES  detRun(det_id, iteration)
     782       FOREIGN KEY(det_id, iteration) REFERENCES detRun(det_id, iteration)
    815783) ENGINE=innodb DEFAULT CHARSET=latin1;
    816784
    … …  
    837805    KEY(end_stage),
    838806    INDEX(warp_id, fake_id),
    839     FOREIGN KEY (fake_id)
    840         REFERENCES fakeRun(fake_id)
     807    FOREIGN KEY(fake_id) REFERENCES fakeRun(fake_id)
    841808) ENGINE=innodb DEFAULT CHARSET=latin1;
    842809
    … …  
    849816    PRIMARY KEY(warp_id, skycell_id, tess_id, class_id),
    850817    KEY(fault),
    851     FOREIGN KEY (warp_id)
    852         REFERENCES warpRun(warp_id)
     818    FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id)
    853819) ENGINE=innodb DEFAULT CHARSET=latin1;
    854820
    … …  
    859825    PRIMARY KEY(warp_id, skycell_id),
    860826    KEY(warp_skyfile_id),
    861     FOREIGN KEY (warp_id) REFERENCES  warpRun(warp_id))
    862 ENGINE=innodb DEFAULT CHARSET=latin1;
     827    FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id)
     828) ENGINE=innodb DEFAULT CHARSET=latin1;
    863829
    864830
    … …  
    880846    ymin INT,
    881847    ymax INT,
    882     ignored TINYINT,
    883848    quality SMALLINT NOT NULL,
    884849    fault SMALLINT,
    … …  
    886851    PRIMARY KEY(warp_id, skycell_id, tess_id),
    887852    KEY(good_frac),
    888     KEY(ignored), KEY(fault),
    889     FOREIGN KEY (warp_id, skycell_id, tess_id)
    890         REFERENCES warpSkyCellMap(warp_id, skycell_id, tess_id)
     853    KEY(fault),
     854    KEY(quality),
     855    FOREIGN KEY(warp_id, skycell_id, tess_id) REFERENCES warpSkyCellMap(warp_id, skycell_id, tess_id)
    891856) ENGINE=innodb DEFAULT CHARSET=latin1;
    892857
    … …  
    918883        warp_id BIGINT,
    919884        PRIMARY KEY(stack_id, warp_id),
    920         FOREIGN KEY (stack_id)  REFERENCES stackRun(stack_id),
    921         FOREIGN KEY (warp_id)  REFERENCES warpSkyfile(warp_id)
     885        FOREIGN KEY(stack_id) REFERENCES stackRun(stack_id),
     886        FOREIGN KEY(warp_id) REFERENCES warpSkyfile(warp_id)
    922887) ENGINE=innodb DEFAULT CHARSET=latin1;
    923888
    … …  
    954919        KEY(good_frac),
    955920        KEY(fault),
    956         FOREIGN KEY (stack_id)  REFERENCES  stackRun(stack_id)
     921        KEY(quality),
     922        FOREIGN KEY(stack_id) REFERENCES stackRun(stack_id)
    957923) ENGINE=innodb DEFAULT CHARSET=latin1;
    958924
    … …  
    972938        KEY(state),
    973939        KEY(tess_id),
    974         FOREIGN KEY (exp_id) REFERENCES rawExp(exp_id)
     940        FOREIGN KEY(exp_id) REFERENCES rawExp(exp_id)
    975941) ENGINE=innodb DEFAULT CHARSET=latin1;
    976942
    … …  
    992958        KEY(skycell_id),
    993959        KEY(tess_id),
    994         FOREIGN KEY (diff_id)  REFERENCES diffRun(diff_id),
    995         FOREIGN KEY (warp1, skycell_id, tess_id)  REFERENCES warpSkyfile(warp_id, skycell_id, tess_id),
    996         FOREIGN KEY (warp2, skycell_id, tess_id)  REFERENCES warpSkyfile(warp_id, skycell_id, tess_id),
    997         FOREIGN KEY (stack1)  REFERENCES stackSumSkyfile(stack_id),
    998         FOREIGN KEY (stack2)  REFERENCES stackSumSkyfile(stack_id)
     960        FOREIGN KEY(diff_id) REFERENCES diffRun(diff_id),
     961        FOREIGN KEY(warp1, skycell_id, tess_id) REFERENCES warpSkyfile(warp_id, skycell_id, tess_id),
     962        FOREIGN KEY(warp2, skycell_id, tess_id) REFERENCES warpSkyfile(warp_id, skycell_id, tess_id),
     963        FOREIGN KEY(stack1) REFERENCES stackSumSkyfile(stack_id),
     964        FOREIGN KEY(stack2) REFERENCES stackSumSkyfile(stack_id)
    999965) ENGINE=innodb DEFAULT CHARSET=latin1;
    1000966
    … …  
    1029995        KEY(good_frac),
    1030996        KEY(fault),
    1031         FOREIGN KEY (diff_id)  REFERENCES  diffRun(diff_id)
     997        KEY(quality),
     998        FOREIGN KEY(diff_id) REFERENCES diffRun(diff_id)
    1032999) ENGINE=innodb DEFAULT CHARSET=latin1;
    10331000
    … …  
    10491016        KEY(label),
    10501017        KEY(fault),
    1051         FOREIGN KEY (exp_id)  REFERENCES rawExp(exp_id),
    1052         FOREIGN KEY (diff_id) REFERENCES diffRun(diff_id)
     1018        FOREIGN KEY(exp_id)  REFERENCES rawExp(exp_id),
     1019        FOREIGN KEY(diff_id) REFERENCES diffRun(diff_id)
    10531020) ENGINE=innodb DEFAULT CHARSET=latin1;
    10541021
    … …  
    10581025        node VARCHAR(64),
    10591026        PRIMARY KEY(magic_id, diff_id, node),
    1060         FOREIGN KEY (magic_id)  REFERENCES magicRun(magic_id),
    1061         FOREIGN KEY (diff_id) REFERENCES diffRun(diff_id)
     1027        FOREIGN KEY(magic_id) REFERENCES magicRun(magic_id),
     1028        FOREIGN KEY(diff_id) REFERENCES diffRun(diff_id)
    10621029) ENGINE=innodb DEFAULT CHARSET=latin1;
    10631030
    … …  
    10701037        KEY(dep),
    10711038        INDEX(magic_id, node),
    1072         FOREIGN KEY (magic_id)  REFERENCES magicRun(magic_id)
     1039        FOREIGN KEY(magic_id) REFERENCES magicRun(magic_id)
    10731040) ENGINE=innodb DEFAULT CHARSET=latin1;
    10741041
    … …  
    10791046        fault SMALLINT,
    10801047        PRIMARY KEY(magic_id, node),
    1081         FOREIGN KEY (magic_id)  REFERENCES magicRun(magic_id),
    1082         FOREIGN KEY (magic_id, node)  REFERENCES magicTree(magic_id, node),
     1048        FOREIGN KEY(magic_id) REFERENCES magicRun(magic_id),
     1049        FOREIGN KEY(magic_id, node) REFERENCES magicTree(magic_id, node),
    10831050        KEY(fault)
    10841051) ENGINE=innodb DEFAULT CHARSET=latin1;
    … …  
    10901057        fault SMALLINT,
    10911058        PRIMARY KEY(magic_id),
    1092         FOREIGN KEY (magic_id)  REFERENCES magicRun(magic_id),
     1059        FOREIGN KEY(magic_id) REFERENCES magicRun(magic_id),
    10931060        KEY(fault)
    10941061) ENGINE=innodb DEFAULT CHARSET=latin1;
    … …  
    11111078        KEY(magic_id),
    11121079        KEY(label),
    1113         FOREIGN KEY (magic_id)  REFERENCES magicRun(magic_id)
     1080        FOREIGN KEY(magic_id) REFERENCES magicRun(magic_id)
    11141081) ENGINE=innodb DEFAULT CHARSET=latin1;
    11151082
    … …  
    11221089    PRIMARY KEY(magic_ds_id, component),
    11231090    KEY(fault),
    1124     FOREIGN KEY (magic_ds_id) REFERENCES magicDSRun(magic_ds_id)
     1091    FOREIGN KEY(magic_ds_id) REFERENCES magicDSRun(magic_ds_id)
    11251092) ENGINE=innodb DEFAULT CHARSET=latin1;
    11261093
    … …  
    11411108        KEY(cal_id),
    11421109        KEY(last_step),
    1143         FOREIGN KEY (cal_id)  REFERENCES calDB(cal_id)
     1110        FOREIGN KEY(cal_id) REFERENCES calDB(cal_id)
    11441111) ENGINE=innodb DEFAULT CHARSET=latin1;
    11451112
    … …  
    11691136        include TINYINT,
    11701137        PRIMARY KEY(corr_id, chip_id),
    1171         FOREIGN KEY (corr_id)  REFERENCES flatcorrRun(corr_id),
    1172         FOREIGN KEY (chip_id)  REFERENCES chipRun(chip_id)
     1138        FOREIGN KEY(corr_id) REFERENCES flatcorrRun(corr_id),
     1139        FOREIGN KEY(chip_id) REFERENCES chipRun(chip_id)
    11731140) ENGINE=innodb DEFAULT CHARSET=latin1;
    11741141
    … …  
    11791146        include TINYINT,
    11801147        PRIMARY KEY(corr_id, cam_id),
    1181         FOREIGN KEY (corr_id)  REFERENCES flatcorrRun(corr_id),
    1182         FOREIGN KEY (chip_id)  REFERENCES chipRun(chip_id),
    1183         FOREIGN KEY (cam_id)  REFERENCES camRun(cam_id)
     1148        FOREIGN KEY(corr_id) REFERENCES flatcorrRun(corr_id),
     1149        FOREIGN KEY(chip_id) REFERENCES chipRun(chip_id),
     1150        FOREIGN KEY(cam_id) REFERENCES camRun(cam_id)
    11841151) ENGINE=innodb DEFAULT CHARSET=latin1;
    11851152
    … …  
    12331200        PRIMARY KEY(job_id, req_id),
    12341201        KEY(job_id),
    1235         FOREIGN KEY (req_id)  REFERENCES pstampRequest(req_id)
     1202        FOREIGN KEY(req_id) REFERENCES pstampRequest(req_id)
    12361203) ENGINE=innodb DEFAULT CHARSET=latin1;
    12371204
Note: See TracChangeset for help on using the changeset viewer.