IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Jun 10, 2008, 4:02:14 PM (18 years ago)
Author:
jhoblitt
Message:

MERGE from HEAD

File:
1 edited

Legend:

Unmodified
Added
Removed

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

    r17856 r18076  
    33    telescope VARCHAR(64),
    44    uri VARCHAR(255),
     5    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    56    PRIMARY KEY(camera, telescope)
    67) ENGINE=innodb DEFAULT CHARSET=latin1;
    … …  
    1516    imfiles INT,
    1617    fault SMALLINT NOT NULL,
     18    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    1719    PRIMARY KEY(exp_name, camera, telescope),
    1820    KEY(fault))
    … …  
    2931    class_id VARCHAR(64),
    3032    uri VARCHAR(255),
     33    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    3134    PRIMARY KEY(exp_name, camera, telescope, class, class_id),
    3235    KEY(file_id),
    … …  
    4043    telescope VARCHAR(64),
    4144    state VARCHAR(64),
     45    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    4246    PRIMARY KEY(exp_name, camera, telescope),
    4347    KEY(state),
    … …  
    5458    uri VARCHAR(255),
    5559    fault SMALLINT NOT NULL,
     60    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    5661    PRIMARY KEY(exp_name, camera, telescope, class, class_id),
    5762    KEY(fault),
    … …  
    6166        REFERENCES  summitImfile(exp_name, camera, telescope, class, class_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    6267
    63 CREATE TABLE newExp (exp_id BIGINT AUTO_INCREMENT, tmp_exp_name VARCHAR(64), tmp_camera VARCHAR(64), tmp_telescope VARCHAR(64), state VARCHAR(64), workdir VARCHAR(255), workdir_state VARCHAR(64), reduction VARCHAR(64), dvodb VARCHAR(255), tess_id VARCHAR(64), end_stage VARCHAR(64), label VARCHAR(64), PRIMARY KEY(exp_id), KEY(exp_id), KEY(tmp_exp_name), KEY(tmp_camera), KEY(tmp_telescope), KEY(state), KEY(workdir_state), KEY(end_stage), KEY(label)) ENGINE=innodb DEFAULT CHARSET=latin1;
    64 CREATE TABLE newImfile (exp_id BIGINT, tmp_class_id VARCHAR(64), uri VARCHAR(255), PRIMARY KEY(exp_id, tmp_class_id), FOREIGN KEY (exp_id)  REFERENCES  newExp(exp_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    65 CREATE TABLE rawExp (exp_id BIGINT, exp_name VARCHAR(64), camera VARCHAR(64), telescope VARCHAR(64), dateobs DATETIME, exp_tag VARCHAR(255), exp_type VARCHAR(64), filelevel VARCHAR(64), workdir VARCHAR(255), reduction VARCHAR(64), dvodb VARCHAR(255), tess_id VARCHAR(64), end_stage VARCHAR(64), filter VARCHAR(64), comment VARCHAR(80), airmass FLOAT, ra DOUBLE, decl DOUBLE, exp_time FLOAT, sat_pixel_frac FLOAT, bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, alt DOUBLE, az DOUBLE, ccd_temp FLOAT, posang DOUBLE, m1_x FLOAT, m1_y FLOAT, m1_z FLOAT, m1_tip FLOAT, m1_tilt FLOAT, m2_x FLOAT, m2_y FLOAT, m2_z FLOAT, m2_tip FLOAT, m2_tilt FLOAT, env_temperature FLOAT, env_humidity FLOAT, env_wind_speed FLOAT, env_wind_dir FLOAT, teltemp_m1 FLOAT, teltemp_m1cell FLOAT, teltemp_m2 FLOAT, teltemp_spider FLOAT, teltemp_truss FLOAT, teltemp_extra FLOAT, pon_time FLOAT, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, object VARCHAR(64), solang FLOAT, hostname VARCHAR(64), fault SMALLINT NOT NULL, PRIMARY KEY(exp_id), KEY(exp_name), KEY(end_stage), KEY(fault), FOREIGN KEY (exp_id)  REFERENCES  newExp(exp_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    66 CREATE TABLE rawImfile (exp_id BIGINT, exp_name VARCHAR(64), camera VARCHAR(64), telescope VARCHAR(64), dateobs DATETIME, tmp_class_id VARCHAR(64), class_id VARCHAR(64), uri VARCHAR(255), exp_type VARCHAR(64), filelevel VARCHAR(64), filter VARCHAR(64), comment VARCHAR(80), airmass FLOAT, ra DOUBLE, decl DOUBLE, exp_time FLOAT, sat_pixel_frac FLOAT, bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, alt DOUBLE, az DOUBLE, ccd_temp FLOAT, posang DOUBLE, m1_x FLOAT, m1_y FLOAT, m1_z FLOAT, m1_tip FLOAT, m1_tilt FLOAT, m2_x FLOAT, m2_y FLOAT, m2_z FLOAT, m2_tip FLOAT, m2_tilt FLOAT, env_temperature FLOAT, env_humidity FLOAT, env_wind_speed FLOAT, env_wind_dir FLOAT, teltemp_m1 FLOAT, teltemp_m1cell FLOAT, teltemp_m2 FLOAT, teltemp_spider FLOAT, teltemp_truss FLOAT, teltemp_extra FLOAT, pon_time FLOAT, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, object VARCHAR(64), hostname VARCHAR(64), fault SMALLINT NOT NULL, PRIMARY KEY(exp_id, class_id), KEY(tmp_class_id), KEY(fault), UNIQUE KEY(exp_id, tmp_class_id), FOREIGN KEY (exp_id, tmp_class_id)  REFERENCES  newImfile(exp_id, tmp_class_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
     68CREATE TABLE newExp (
     69    exp_id BIGINT AUTO_INCREMENT,
     70    tmp_exp_name VARCHAR(64),
     71    tmp_camera VARCHAR(64),
     72    tmp_telescope VARCHAR(64),
     73    state VARCHAR(64),
     74    workdir VARCHAR(255),
     75    workdir_state VARCHAR(64),
     76    reduction VARCHAR(64),
     77    dvodb VARCHAR(255),
     78    tess_id VARCHAR(64),
     79    end_stage VARCHAR(64),
     80    label VARCHAR(64),
     81    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     82    PRIMARY KEY(exp_id),
     83    KEY(exp_id),
     84    KEY(tmp_exp_name),
     85    KEY(tmp_camera),
     86    KEY(tmp_telescope),
     87    KEY(state),
     88    KEY(workdir_state),
     89    KEY(end_stage),
     90    KEY(label)
     91) ENGINE=innodb DEFAULT CHARSET=latin1;
     92
     93CREATE TABLE newImfile (
     94    exp_id BIGINT,
     95    tmp_class_id VARCHAR(64),
     96    uri VARCHAR(255),
     97    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     98    PRIMARY KEY(exp_id, tmp_class_id),
     99    FOREIGN KEY (exp_id)
     100        REFERENCES  newExp(exp_id))
     101ENGINE=innodb DEFAULT CHARSET=latin1;
     102
     103CREATE TABLE rawExp (
     104    exp_id BIGINT,
     105    exp_name VARCHAR(64),
     106    camera VARCHAR(64),
     107    telescope VARCHAR(64),
     108    dateobs DATETIME,
     109    exp_tag VARCHAR(255),
     110    exp_type VARCHAR(64),
     111    filelevel VARCHAR(64),
     112    workdir VARCHAR(255),
     113    reduction VARCHAR(64),
     114    dvodb VARCHAR(255),
     115    tess_id VARCHAR(64),
     116    end_stage VARCHAR(64),
     117    filter VARCHAR(64),
     118    comment VARCHAR(80),
     119    airmass FLOAT,
     120    ra DOUBLE,
     121    decl DOUBLE,
     122    exp_time FLOAT,
     123    sat_pixel_frac FLOAT,
     124    bg DOUBLE,
     125    bg_stdev DOUBLE,
     126    bg_mean_stdev DOUBLE,
     127    alt DOUBLE,
     128    az DOUBLE,
     129    ccd_temp FLOAT,
     130    posang DOUBLE,
     131    m1_x FLOAT,
     132    m1_y FLOAT,
     133    m1_z FLOAT,
     134    m1_tip FLOAT,
     135    m1_tilt FLOAT,
     136    m2_x FLOAT,
     137    m2_y FLOAT,
     138    m2_z FLOAT,
     139    m2_tip FLOAT,
     140    m2_tilt FLOAT,
     141    env_temperature FLOAT,
     142    env_humidity FLOAT,
     143    env_wind_speed FLOAT,
     144    env_wind_dir FLOAT,
     145    teltemp_m1 FLOAT,
     146    teltemp_m1cell FLOAT,
     147    teltemp_m2 FLOAT,
     148    teltemp_spider FLOAT,
     149    teltemp_truss FLOAT,
     150    teltemp_extra FLOAT,
     151    pon_time FLOAT,
     152    user_1 DOUBLE,
     153    user_2 DOUBLE,
     154    user_3 DOUBLE,
     155    user_4 DOUBLE,
     156    user_5 DOUBLE,
     157    object VARCHAR(64),
     158    solang FLOAT,
     159    hostname VARCHAR(64),
     160    fault SMALLINT NOT NULL,
     161    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     162    PRIMARY KEY(exp_id),
     163    KEY(exp_name),
     164    KEY(end_stage),
     165    KEY(fault),
     166    FOREIGN KEY (exp_id)
     167        REFERENCES  newExp(exp_id))
     168ENGINE=innodb DEFAULT CHARSET=latin1;
     169
     170CREATE TABLE rawImfile (
     171    exp_id BIGINT,
     172    exp_name VARCHAR(64),
     173    camera VARCHAR(64),
     174    telescope VARCHAR(64),
     175    dateobs DATETIME,
     176    tmp_class_id VARCHAR(64),
     177    class_id VARCHAR(64),
     178    uri VARCHAR(255),
     179    exp_type VARCHAR(64),
     180    filelevel VARCHAR(64),
     181    filter VARCHAR(64),
     182    comment VARCHAR(80),
     183    airmass FLOAT,
     184    ra DOUBLE,
     185    decl DOUBLE,
     186    exp_time FLOAT,
     187    sat_pixel_frac FLOAT,
     188    bg DOUBLE,
     189    bg_stdev DOUBLE,
     190    bg_mean_stdev DOUBLE,
     191    alt DOUBLE,
     192    az DOUBLE,
     193    ccd_temp FLOAT,
     194    posang DOUBLE,
     195    m1_x FLOAT,
     196    m1_y FLOAT,
     197    m1_z FLOAT,
     198    m1_tip FLOAT,
     199    m1_tilt FLOAT,
     200    m2_x FLOAT,
     201    m2_y FLOAT,
     202    m2_z FLOAT,
     203    m2_tip FLOAT,
     204    m2_tilt FLOAT,
     205    env_temperature FLOAT,
     206    env_humidity FLOAT,
     207    env_wind_speed FLOAT,
     208    env_wind_dir FLOAT,
     209    teltemp_m1 FLOAT,
     210    teltemp_m1cell FLOAT,
     211    teltemp_m2 FLOAT,
     212    teltemp_spider FLOAT,
     213    teltemp_truss FLOAT,
     214    teltemp_extra FLOAT,
     215    pon_time FLOAT,
     216    user_1 DOUBLE,
     217    user_2 DOUBLE,
     218    user_3 DOUBLE,
     219    user_4 DOUBLE,
     220    user_5 DOUBLE,
     221    object VARCHAR(64),
     222    hostname VARCHAR(64),
     223    fault SMALLINT NOT NULL,
     224    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     225    PRIMARY KEY(exp_id, class_id),
     226    KEY(tmp_class_id),
     227    KEY(fault),
     228    UNIQUE KEY(exp_id, tmp_class_id),
     229    FOREIGN KEY (exp_id, tmp_class_id)
     230        REFERENCES newImfile(exp_id, tmp_class_id))
     231ENGINE=innodb DEFAULT CHARSET=latin1;
     232
    67233CREATE TABLE guidePendingExp (guide_id BIGINT AUTO_INCREMENT, exp_id BIGINT, recipe VARCHAR(64), PRIMARY KEY(guide_id), KEY(guide_id), KEY(exp_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    68 CREATE TABLE chipRun (chip_id BIGINT AUTO_INCREMENT, exp_id BIGINT, state VARCHAR(64), workdir VARCHAR(255), workdir_state VARCHAR(64), label VARCHAR(64), reduction VARCHAR(64), expgroup VARCHAR(64), dvodb VARCHAR(255), tess_id VARCHAR(64), end_stage VARCHAR(64), PRIMARY KEY(chip_id), KEY(chip_id), KEY(exp_id), KEY(state), KEY(workdir_state), KEY(label), KEY(expgroup), KEY(end_stage), INDEX(chip_id, exp_id), FOREIGN KEY  (exp_id)  REFERENCES  rawExp(exp_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    69 CREATE TABLE chipProcessedImfile (chip_id BIGINT, exp_id BIGINT, class_id VARCHAR(64), uri VARCHAR(255), bg FLOAT, bg_stdev FLOAT, bg_mean_stdev FLOAT, bias FLOAT, bias_stdev FLOAT, fringe_0 FLOAT, fringe_1 FLOAT, fringe_2 FLOAT, sigma_ra FLOAT, sigma_dec FLOAT, ap_resid FLOAT, ap_resid_stdev FLOAT, zp_mean FLOAT, zp_stdev FLOAT, fwhm_major FLOAT, fwhm_minor FLOAT, dtime_detrend FLOAT, dtime_photom FLOAT, dtime_astrom FLOAT, hostname VARCHAR(64), n_stars INT, n_extended INT, n_cr INT, n_astrom INT, path_base VARCHAR(255), fault SMALLINT NOT NULL, PRIMARY KEY(chip_id, exp_id, class_id), KEY(fault), FOREIGN KEY  (chip_id, exp_id)  REFERENCES  chipRun(chip_id, exp_id), FOREIGN KEY  (exp_id, class_id)  REFERENCES  rawImfile(exp_id, class_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    70 CREATE TABLE chipMask (label VARCHAR(64), PRIMARY KEY(label)) ENGINE=innodb DEFAULT CHARSET=latin1;
    71 CREATE TABLE camRun (cam_id BIGINT AUTO_INCREMENT, chip_id BIGINT, state VARCHAR(64), workdir VARCHAR(255), workdir_state VARCHAR(64), label VARCHAR(64), reduction VARCHAR(64), expgroup VARCHAR(64), dvodb VARCHAR(255), tess_id VARCHAR(64), end_stage VARCHAR(64), PRIMARY KEY(cam_id), KEY(cam_id), KEY(chip_id), KEY(state), KEY(workdir_state), KEY(label), KEY(expgroup), KEY(end_stage), INDEX(cam_id, chip_id), FOREIGN KEY (chip_id)  REFERENCES  chipRun(chip_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    72 CREATE TABLE camProcessedExp (cam_id BIGINT, chip_id BIGINT, uri VARCHAR(255), bg FLOAT, bg_stdev FLOAT, bg_mean_stdev FLOAT, bias FLOAT, bias_stdev FLOAT, fringe_0 FLOAT, fringe_1 FLOAT, fringe_2 FLOAT, sigma_ra FLOAT, sigma_dec FLOAT, ap_resid FLOAT, ap_resid_stdev FLOAT, zp_mean FLOAT, zp_stdev FLOAT, fwhm_major FLOAT, fwhm_minor FLOAT, dtime_detrend FLOAT, dtime_photom FLOAT, dtime_astrom FLOAT, hostname VARCHAR(64), n_stars INT, n_extended INT, n_cr INT, n_astrom INT, path_base VARCHAR(255), fault SMALLINT NOT NULL, PRIMARY KEY(cam_id, chip_id), KEY(fault), FOREIGN KEY (cam_id, chip_id)  REFERENCES  camRun(cam_id, chip_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    73 CREATE TABLE camMask (label VARCHAR(64), PRIMARY KEY(label)) ENGINE=innodb DEFAULT CHARSET=latin1;
    74 CREATE TABLE detRun (det_id BIGINT AUTO_INCREMENT, iteration INT, det_type VARCHAR(64), mode VARCHAR(64), state VARCHAR(64), filelevel VARCHAR(64), workdir VARCHAR(255), camera VARCHAR(64), telescope VARCHAR(64), exp_type VARCHAR(64), reduction VARCHAR(64), filter VARCHAR(64), airmass_min FLOAT, airmass_max FLOAT, exp_time_min FLOAT, exp_time_max FLOAT, ccd_temp_min FLOAT, ccd_temp_max FLOAT, posang_min DOUBLE, posang_max DOUBLE, registered DATETIME, time_begin DATETIME, time_end DATETIME, use_begin DATETIME, use_end DATETIME, solang_min FLOAT, solang_max FLOAT, label VARCHAR(64), parent INT, PRIMARY KEY(det_id), KEY(det_id), KEY(iteration), KEY(det_type), KEY(mode), KEY(state), KEY(label), KEY(parent), INDEX(det_id, iteration)) ENGINE=innodb DEFAULT CHARSET=latin1;
    75 CREATE TABLE detInputExp (det_id BIGINT, iteration INT, exp_id BIGINT, include TINYINT, PRIMARY KEY(det_id, iteration, exp_id), INDEX(det_id, exp_id), INDEX(det_id, iteration), FOREIGN KEY (det_id)  REFERENCES  detRun(det_id), FOREIGN KEY (exp_id)  REFERENCES  rawExp(exp_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    76 CREATE TABLE detProcessedImfile (det_id BIGINT, exp_id BIGINT, class_id VARCHAR(64), uri VARCHAR(255), recipe VARCHAR(64), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, fringe_0 DOUBLE, fringe_1 DOUBLE, fringe_2 DOUBLE, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, path_base VARCHAR(255), fault SMALLINT NOT NULL, PRIMARY KEY(det_id, exp_id, class_id), KEY(fault), INDEX(det_id, class_id), INDEX(det_id, exp_id), FOREIGN KEY (det_id, exp_id)  REFERENCES  detInputExp(det_id, exp_id), FOREIGN KEY (exp_id, class_id)  REFERENCES  rawImfile(exp_id, class_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    77 CREATE TABLE detProcessedExp (det_id BIGINT, exp_id BIGINT, recipe VARCHAR(64), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, fringe_0 DOUBLE, fringe_1 DOUBLE, fringe_2 DOUBLE, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, path_base VARCHAR(255), fault SMALLINT NOT NULL, PRIMARY KEY(det_id, exp_id), KEY(fault), FOREIGN KEY (det_id, exp_id)  REFERENCES  detInputExp(det_id, exp_id), FOREIGN KEY (det_id, exp_id)  REFERENCES  detProcessedImfile(det_id, exp_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    78 CREATE TABLE detStackedImfile (det_id BIGINT, iteration INT, class_id VARCHAR(64), uri VARCHAR(255), recipe VARCHAR(64), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration, class_id), KEY(fault), FOREIGN KEY (det_id, iteration)  REFERENCES  detInputExp(det_id, iteration), FOREIGN KEY (det_id, class_id)  REFERENCES  detProcessedImfile(det_id, class_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    79 CREATE TABLE detNormalizedStatImfile (det_id BIGINT, iteration INT, class_id VARCHAR(64), norm FLOAT, fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration, class_id), KEY(fault), FOREIGN KEY (det_id, iteration)  REFERENCES  detInputExp(det_id, iteration), FOREIGN KEY (det_id, iteration, class_id)  REFERENCES  detStackedImfile(det_id, iteration, class_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    80 CREATE TABLE detNormalizedImfile (det_id BIGINT, iteration INT, class_id VARCHAR(64), uri VARCHAR(255), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, path_base VARCHAR(255), fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration, class_id), KEY(fault), INDEX(det_id, iteration), FOREIGN KEY (det_id)  REFERENCES  detInputExp(det_id), FOREIGN KEY (det_id, iteration, class_id)  REFERENCES  detNormalizedStatImfile(det_id, iteration, class_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    81 CREATE TABLE detNormalizedExp (det_id BIGINT, iteration INT, recipe VARCHAR(64), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, path_base VARCHAR(255), fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration), KEY(fault), FOREIGN KEY (det_id, iteration)  REFERENCES  detInputExp(det_id, iteration), FOREIGN KEY (det_id, iteration)  REFERENCES  detNormalizedImfile(det_id, iteration)) ENGINE=innodb DEFAULT CHARSET=latin1;
    82 CREATE TABLE detResidImfile (det_id BIGINT, iteration INT, exp_id BIGINT, class_id VARCHAR(64), uri VARCHAR(255), recipe VARCHAR(64), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, bg_skewness DOUBLE, bg_kurtosis DOUBLE, bin_stdev DOUBLE, fringe_0 DOUBLE, fringe_1 DOUBLE, fringe_2 DOUBLE, fringe_resid_0 DOUBLE, fringe_resid_1 DOUBLE, fringe_resid_2 DOUBLE, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, path_base VARCHAR(255), fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration, exp_id, class_id), KEY(fault), INDEX(det_id, iteration, exp_id), FOREIGN KEY (det_id, iteration, exp_id)  REFERENCES  detInputExp(det_id, iteration, exp_id), FOREIGN KEY (det_id, exp_id, class_id)  REFERENCES  detProcessedImfile(det_id, exp_id, class_id), FOREIGN KEY (det_id, iteration)  REFERENCES  detNormalizedExp(det_id, iteration)) ENGINE=innodb DEFAULT CHARSET=latin1;
     234
     235CREATE TABLE chipRun (
     236    chip_id BIGINT AUTO_INCREMENT,
     237    exp_id BIGINT,
     238    state VARCHAR(64),
     239    workdir VARCHAR(255),
     240    workdir_state VARCHAR(64),
     241    label VARCHAR(64),
     242    reduction VARCHAR(64),
     243     expgroup VARCHAR(64),
     244    dvodb VARCHAR(255),
     245    tess_id VARCHAR(64),
     246    end_stage VARCHAR(64),
     247    PRIMARY KEY(chip_id),
     248    KEY(chip_id), KEY(exp_id),
     249    KEY(state),
     250    KEY(workdir_state),
     251    KEY(label),
     252    KEY(expgroup),
     253    KEY(end_stage),
     254    INDEX(chip_id, exp_id),
     255    FOREIGN KEY (exp_id) 
     256        REFERENCES rawExp(exp_id))
     257ENGINE=innodb DEFAULT CHARSET=latin1;
     258
     259CREATE TABLE chipProcessedImfile (
     260    chip_id BIGINT,
     261    exp_id BIGINT,
     262    class_id VARCHAR(64),
     263    uri VARCHAR(255),
     264    bg FLOAT,
     265    bg_stdev FLOAT,
     266    bg_mean_stdev FLOAT,
     267    bias FLOAT,
     268    bias_stdev FLOAT,
     269    fringe_0 FLOAT,
     270    fringe_1 FLOAT,
     271    fringe_2 FLOAT,
     272    sigma_ra FLOAT,
     273    sigma_dec FLOAT,
     274    ap_resid FLOAT,
     275    ap_resid_stdev FLOAT,
     276    zp_mean FLOAT,
     277    zp_stdev FLOAT,
     278    fwhm_major FLOAT,
     279    fwhm_minor FLOAT,
     280    dtime_detrend FLOAT,
     281    dtime_photom FLOAT,
     282    dtime_astrom FLOAT,
     283    hostname VARCHAR(64),
     284    n_stars INT,
     285    n_extended INT,
     286    n_cr INT,
     287    n_astrom INT,
     288    path_base VARCHAR(255),
     289    fault SMALLINT NOT NULL,
     290    PRIMARY KEY(chip_id, exp_id, class_id),
     291    KEY(fault),
     292    FOREIGN KEY (chip_id, exp_id) 
     293        REFERENCES  chipRun(chip_id, exp_id),
     294    FOREIGN KEY (exp_id, class_id)
     295        REFERENCES  rawImfile(exp_id, class_id))
     296ENGINE=innodb DEFAULT CHARSET=latin1;
     297
     298CREATE TABLE chipMask (
     299    label VARCHAR(64),
     300    PRIMARY KEY(label))
     301ENGINE=innodb DEFAULT CHARSET=latin1;
     302
     303CREATE TABLE camRun (
     304    cam_id BIGINT AUTO_INCREMENT,
     305    chip_id BIGINT,
     306    state VARCHAR(64),
     307    workdir VARCHAR(255),
     308    workdir_state VARCHAR(64),
     309    label VARCHAR(64),
     310    reduction VARCHAR(64),
     311    expgroup VARCHAR(64),
     312    dvodb VARCHAR(255),
     313    tess_id VARCHAR(64),
     314    end_stage VARCHAR(64),
     315    PRIMARY KEY(cam_id),
     316    KEY(cam_id),
     317    KEY(chip_id),
     318    KEY(state),
     319    KEY(workdir_state),
     320    KEY(label),
     321    KEY(expgroup),
     322    KEY(end_stage),
     323    INDEX(cam_id, chip_id),
     324    FOREIGN KEY (chip_id) 
     325        REFERENCES chipRun(chip_id))
     326ENGINE=innodb DEFAULT CHARSET=latin1;
     327
     328CREATE TABLE camProcessedExp (
     329    cam_id BIGINT,
     330    uri VARCHAR(255),
     331    bg FLOAT,
     332    bg_stdev FLOAT,
     333    bg_mean_stdev FLOAT,
     334    bias FLOAT,
     335    bias_stdev FLOAT,
     336    fringe_0 FLOAT,
     337    fringe_1 FLOAT,
     338    fringe_2 FLOAT,
     339    sigma_ra FLOAT,
     340    sigma_dec FLOAT,
     341    ap_resid FLOAT,
     342    ap_resid_stdev FLOAT,
     343    zp_mean FLOAT,
     344    zp_stdev FLOAT,
     345    fwhm_major FLOAT,
     346    fwhm_minor FLOAT,
     347    dtime_detrend FLOAT,
     348    dtime_photom FLOAT,
     349    dtime_astrom FLOAT,
     350    hostname VARCHAR(64),
     351    n_stars INT,
     352    n_extended INT,
     353    n_cr INT,
     354    n_astrom INT,
     355    path_base VARCHAR(255),
     356    fault SMALLINT NOT NULL,
     357    PRIMARY KEY(cam_id),
     358    KEY(fault),
     359    FOREIGN KEY (cam_id) 
     360        REFERENCES camRun(cam_id))
     361ENGINE=innodb DEFAULT CHARSET=latin1;
     362
     363CREATE TABLE camMask (
     364    label VARCHAR(64),
     365    PRIMARY KEY(label))
     366ENGINE=innodb DEFAULT CHARSET=latin1;
     367
     368CREATE TABLE fakeRun (
     369    fake_id BIGINT AUTO_INCREMENT,
     370    cam_id BIGINT,
     371    state VARCHAR(64),
     372    workdir VARCHAR(255),
     373    label VARCHAR(64),
     374    reduction VARCHAR(64),
     375    expgroup VARCHAR(64),
     376    dvodb VARCHAR(255),
     377    tess_id VARCHAR(64),
     378    end_stage VARCHAR(64),
     379    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     380    PRIMARY KEY(fake_id),
     381    KEY(cam_id),
     382    KEY(state),
     383    KEY(label),
     384    KEY(expgroup),
     385    KEY(end_stage),
     386    INDEX(fake_id, cam_id),
     387    FOREIGN KEY (cam_id) 
     388        REFERENCES camRun(cam_id))
     389ENGINE=innodb DEFAULT CHARSET=latin1;
     390
     391CREATE TABLE fakeProcessedImfile (
     392    fake_id BIGINT AUTO_INCREMENT,
     393    exp_id BIGINT,
     394    class_id VARCHAR(64),
     395    uri VARCHAR(255),
     396    dtime_fake FLOAT,
     397    hostname VARCHAR(64),
     398    path_base VARCHAR(255),
     399    fault SMALLINT NOT NULL,
     400    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     401    PRIMARY KEY(fake_id, exp_id, class_id),
     402    KEY(fault),
     403    FOREIGN KEY (fake_id) 
     404        REFERENCES fakeRun(fake_id),
     405    FOREIGN KEY (exp_id, class_id) 
     406        REFERENCES rawImfile(exp_id, class_id))
     407ENGINE=innodb DEFAULT CHARSET=latin1;
     408
     409CREATE TABLE fakeMask (
     410    label VARCHAR(64),
     411    PRIMARY KEY(label))
     412ENGINE=innodb DEFAULT CHARSET=latin1;
     413
     414CREATE TABLE detRun (
     415    det_id BIGINT AUTO_INCREMENT,
     416    iteration INT,
     417    det_type VARCHAR(64),
     418    mode VARCHAR(64),
     419    state VARCHAR(64),
     420    filelevel VARCHAR(64),
     421    workdir VARCHAR(255),
     422    camera VARCHAR(64),
     423    telescope VARCHAR(64),
     424    exp_type VARCHAR(64),
     425    reduction VARCHAR(64),
     426    filter VARCHAR(64),
     427    airmass_min FLOAT,
     428    airmass_max FLOAT,
     429    exp_time_min FLOAT,
     430    exp_time_max FLOAT,
     431    ccd_temp_min FLOAT,
     432    ccd_temp_max FLOAT,
     433    posang_min DOUBLE,
     434    posang_max DOUBLE,
     435    registered DATETIME,
     436    time_begin DATETIME,
     437    time_end DATETIME,
     438    use_begin DATETIME,
     439    use_end DATETIME,
     440    solang_min FLOAT,
     441    solang_max FLOAT,
     442    label VARCHAR(64),
     443    parent INT,
     444    PRIMARY KEY(det_id),
     445    KEY(det_id),
     446    KEY(iteration),
     447    KEY(det_type),
     448    KEY(mode),
     449    KEY(state),
     450    KEY(label),
     451    KEY(parent),
     452    INDEX(det_id, iteration))
     453ENGINE=innodb DEFAULT CHARSET=latin1;
     454
     455CREATE TABLE detInputExp (
     456det_id BIGINT,
     457iteration INT,
     458exp_id BIGINT,
     459include TINYINT,
     460PRIMARY KEY(det_id, iteration, exp_id),
     461INDEX(det_id, exp_id),
     462INDEX(det_id, iteration),
     463FOREIGN KEY (det_id) 
     464REFERENCES  detRun(det_id),
     465FOREIGN KEY (exp_id) 
     466REFERENCES  rawExp(exp_id))
     467ENGINE=innodb DEFAULT CHARSET=latin1;
     468
     469CREATE TABLE detProcessedImfile (
     470    det_id BIGINT,
     471    exp_id BIGINT,
     472    class_id VARCHAR(64),
     473    uri VARCHAR(255),
     474    recipe VARCHAR(64),
     475    bg DOUBLE,
     476    bg_stdev DOUBLE,
     477    bg_mean_stdev DOUBLE,
     478    fringe_0 DOUBLE,
     479    fringe_1 DOUBLE,
     480    fringe_2 DOUBLE,
     481    user_1 DOUBLE,
     482    user_2 DOUBLE,
     483    user_3 DOUBLE,
     484    user_4 DOUBLE,
     485    user_5 DOUBLE,
     486    path_base VARCHAR(255),
     487    fault SMALLINT NOT NULL,
     488    PRIMARY KEY(det_id, exp_id, class_id),
     489    KEY(fault),
     490    INDEX(det_id, class_id),
     491    INDEX(det_id, exp_id),
     492    FOREIGN KEY (det_id, exp_id) 
     493        REFERENCES  detInputExp(det_id, exp_id),
     494    FOREIGN KEY (exp_id, class_id) 
     495        REFERENCES  rawImfile(exp_id, class_id)
     496) ENGINE=innodb DEFAULT CHARSET=latin1;
     497
     498CREATE TABLE detProcessedExp (
     499    det_id BIGINT,
     500    exp_id BIGINT,
     501    recipe VARCHAR(64),
     502    bg DOUBLE,
     503    bg_stdev DOUBLE,
     504    bg_mean_stdev DOUBLE,
     505    fringe_0 DOUBLE,
     506    fringe_1 DOUBLE,
     507    fringe_2 DOUBLE,
     508    user_1 DOUBLE,
     509    user_2 DOUBLE,
     510    user_3 DOUBLE,
     511    user_4 DOUBLE,
     512    user_5 DOUBLE,
     513    path_base VARCHAR(255),
     514    fault SMALLINT NOT NULL,
     515    PRIMARY KEY(det_id, exp_id),
     516    KEY(fault),
     517    FOREIGN KEY (det_id, exp_id) 
     518        REFERENCES  detInputExp(det_id, exp_id),
     519    FOREIGN KEY (det_id, exp_id) 
     520        REFERENCES  detProcessedImfile(det_id, exp_id)
     521) ENGINE=innodb DEFAULT CHARSET=latin1;
     522
     523CREATE TABLE detStackedImfile (
     524    det_id BIGINT,
     525    iteration INT,
     526    class_id VARCHAR(64),
     527    uri VARCHAR(255),
     528    recipe VARCHAR(64),
     529    bg DOUBLE,
     530    bg_stdev DOUBLE,
     531    bg_mean_stdev DOUBLE,
     532    user_1 DOUBLE,
     533    user_2 DOUBLE,
     534    user_3 DOUBLE,
     535    user_4 DOUBLE,
     536    user_5 DOUBLE,
     537    fault SMALLINT NOT NULL,
     538    PRIMARY KEY(det_id, iteration, class_id),
     539    KEY(fault),
     540    FOREIGN KEY (det_id, iteration) 
     541        REFERENCES  detInputExp(det_id, iteration),
     542    FOREIGN KEY (det_id, class_id) 
     543        REFERENCES  detProcessedImfile(det_id, class_id)
     544) ENGINE=innodb DEFAULT CHARSET=latin1;
     545
     546CREATE TABLE detNormalizedStatImfile (
     547    det_id BIGINT,
     548    iteration INT,
     549    class_id VARCHAR(64),
     550    norm FLOAT,
     551    fault SMALLINT NOT NULL,
     552    PRIMARY KEY(det_id, iteration, class_id),
     553    KEY(fault),
     554    FOREIGN KEY (det_id, iteration) 
     555    REFERENCES  detInputExp(det_id, iteration),
     556    FOREIGN KEY (det_id, iteration, class_id) 
     557    REFERENCES  detStackedImfile(det_id, iteration, class_id)
     558) ENGINE=innodb DEFAULT CHARSET=latin1;
     559
     560CREATE TABLE detNormalizedImfile (
     561    det_id BIGINT,
     562    iteration INT,
     563    class_id VARCHAR(64),
     564    uri VARCHAR(255),
     565    bg DOUBLE,
     566    bg_stdev DOUBLE,
     567    bg_mean_stdev DOUBLE,
     568    user_1 DOUBLE,
     569    user_2 DOUBLE,
     570    user_3 DOUBLE,
     571    user_4 DOUBLE,
     572    user_5 DOUBLE,
     573    path_base VARCHAR(255),
     574    fault SMALLINT NOT NULL,
     575    PRIMARY KEY(det_id, iteration, class_id),
     576    KEY(fault),
     577    INDEX(det_id, iteration),
     578    FOREIGN KEY (det_id) 
     579    REFERENCES  detInputExp(det_id),
     580    FOREIGN KEY (det_id, iteration, class_id) 
     581    REFERENCES  detNormalizedStatImfile(det_id, iteration, class_id)
     582) ENGINE=innodb DEFAULT CHARSET=latin1;
     583
     584CREATE TABLE detNormalizedExp (
     585    det_id BIGINT,
     586    iteration INT,
     587    recipe VARCHAR(64),
     588    bg DOUBLE,
     589    bg_stdev DOUBLE,
     590    bg_mean_stdev DOUBLE,
     591    user_1 DOUBLE,
     592    user_2 DOUBLE,
     593    user_3 DOUBLE,
     594    user_4 DOUBLE,
     595    user_5 DOUBLE,
     596    path_base VARCHAR(255),
     597    fault SMALLINT NOT NULL,
     598    PRIMARY KEY(det_id, iteration),
     599    KEY(fault),
     600    FOREIGN KEY (det_id, iteration) 
     601    REFERENCES  detInputExp(det_id, iteration),
     602    FOREIGN KEY (det_id, iteration) 
     603    REFERENCES  detNormalizedImfile(det_id, iteration)
     604) ENGINE=innodb DEFAULT CHARSET=latin1;
     605
     606CREATE TABLE detResidImfile (
     607    det_id BIGINT,
     608    iteration INT,
     609    exp_id BIGINT,
     610    class_id VARCHAR(64),
     611    uri VARCHAR(255),
     612    recipe VARCHAR(64),
     613    bg DOUBLE,
     614    bg_stdev DOUBLE,
     615    bg_mean_stdev DOUBLE,
     616    bg_skewness DOUBLE,
     617    bg_kurtosis DOUBLE,
     618    bin_stdev DOUBLE,
     619    fringe_0 DOUBLE,
     620    fringe_1 DOUBLE,
     621    fringe_2 DOUBLE,
     622    fringe_resid_0 DOUBLE,
     623    fringe_resid_1 DOUBLE,
     624    fringe_resid_2 DOUBLE,
     625    user_1 DOUBLE,
     626    user_2 DOUBLE,
     627    user_3 DOUBLE,
     628    user_4 DOUBLE,
     629    user_5 DOUBLE,
     630    path_base VARCHAR(255),
     631    fault SMALLINT NOT NULL,
     632    PRIMARY KEY(det_id, iteration, exp_id, class_id),
     633    KEY(fault),
     634    INDEX(det_id, iteration, exp_id),
     635    FOREIGN KEY (det_id, iteration, exp_id) 
     636    REFERENCES  detInputExp(det_id, iteration, exp_id),
     637    FOREIGN KEY (det_id, exp_id, class_id) 
     638    REFERENCES  detProcessedImfile(det_id, exp_id, class_id),
     639    FOREIGN KEY (det_id, iteration) 
     640    REFERENCES  detNormalizedExp(det_id, iteration)
     641) ENGINE=innodb DEFAULT CHARSET=latin1;
     642
    83643CREATE TABLE detResidExp (det_id BIGINT, iteration INT, exp_id BIGINT, recipe VARCHAR(64), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, bg_skewness DOUBLE, bg_kurtosis DOUBLE, bin_stdev DOUBLE, fringe_0 DOUBLE, fringe_1 DOUBLE, fringe_2 DOUBLE, fringe_resid_0 DOUBLE, fringe_resid_1 DOUBLE, fringe_resid_2 DOUBLE, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, path_base VARCHAR(255), accept TINYINT, fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration, exp_id), KEY(fault), INDEX(det_id, iteration), FOREIGN KEY (det_id, iteration, exp_id)  REFERENCES  detInputExp(det_id, iteration, exp_id), FOREIGN KEY (det_id, iteration, exp_id)  REFERENCES  detResidImfile(det_id, iteration, exp_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    84644CREATE TABLE detRunSummary (det_id BIGINT, iteration INT, bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, accept TINYINT, fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration), KEY(fault), FOREIGN KEY (det_id, iteration)  REFERENCES  detInputExp(det_id, iteration), FOREIGN KEY (det_id, iteration)  REFERENCES  detResidExp(det_id, iteration)) ENGINE=innodb DEFAULT CHARSET=latin1;
    85645CREATE TABLE detRegisteredImfile (det_id BIGINT, iteration INT, class_id VARCHAR(64), uri VARCHAR(255), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, path_base VARCHAR(255), fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration, class_id), KEY(fault), FOREIGN KEY (det_id, iteration)  REFERENCES  detRun(det_id, iteration)) ENGINE=innodb DEFAULT CHARSET=latin1;
    86 CREATE TABLE warpRun (warp_id BIGINT AUTO_INCREMENT, cam_id BIGINT, mode VARCHAR(64), state VARCHAR(64), workdir VARCHAR(255), workdir_state VARCHAR(64), label VARCHAR(64), dvodb VARCHAR(255), tess_id VARCHAR(64), end_stage VARCHAR(64), registered DATETIME, magiced TINYINT, PRIMARY KEY(warp_id), KEY(warp_id), KEY(cam_id), KEY(mode), KEY(state), KEY(workdir_state), KEY(label), KEY(end_stage), KEY(magiced), INDEX(warp_id, cam_id), FOREIGN KEY (cam_id)  REFERENCES  camProcessedExp(cam_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    87 CREATE TABLE warpSkyCellMap (warp_id BIGINT, skycell_id VARCHAR(64), tess_id VARCHAR(64), cam_id BIGINT, class_id VARCHAR(64), fault SMALLINT, PRIMARY KEY(warp_id, skycell_id, tess_id, cam_id, class_id), KEY(fault), FOREIGN KEY (warp_id, cam_id)  REFERENCES  warpRun(warp_id, cam_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    88 CREATE TABLE warpSkyfile (warp_id BIGINT, skycell_id VARCHAR(64), tess_id VARCHAR(64), uri VARCHAR(255), path_base VARCHAR(255), bg DOUBLE, bg_stdev DOUBLE, dtime_warp FLOAT, hostname VARCHAR(64), good_frac FLOAT, xmin INT, xmax INT, ymin INT, ymax INT, ignored TINYINT, fault SMALLINT, PRIMARY KEY(warp_id, skycell_id, tess_id), KEY(good_frac), KEY(ignored), KEY(fault), FOREIGN KEY (warp_id, skycell_id, tess_id)  REFERENCES  warpSkyCellMap(warp_id, skycell_id, tess_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    89 CREATE TABLE warpMask (label VARCHAR(64), PRIMARY KEY(label)) ENGINE=innodb DEFAULT CHARSET=latin1;
     646
     647CREATE TABLE warpRun (
     648    warp_id BIGINT AUTO_INCREMENT,
     649    fake_id BIGINT,
     650    mode VARCHAR(64),
     651    state VARCHAR(64),
     652    workdir VARCHAR(255),
     653    workdir_state VARCHAR(64),
     654    label VARCHAR(64),
     655    dvodb VARCHAR(255),
     656    tess_id VARCHAR(64),
     657    end_stage VARCHAR(64),
     658    registered DATETIME,
     659    magiced TINYINT,
     660    PRIMARY KEY(warp_id),
     661    KEY(warp_id),
     662    KEY(fake_id),
     663    KEY(mode),
     664    KEY(state),
     665    KEY(workdir_state),
     666    KEY(label),
     667    KEY(end_stage),
     668    KEY(magiced),
     669    INDEX(warp_id, fake_id),
     670    FOREIGN KEY (fake_id) 
     671        REFERENCES fakeRun(fake_id)
     672) ENGINE=innodb DEFAULT CHARSET=latin1;
     673
     674CREATE TABLE warpSkyCellMap (
     675    warp_id BIGINT,
     676    skycell_id VARCHAR(64),
     677    tess_id VARCHAR(64),
     678    class_id VARCHAR(64),
     679    fault SMALLINT,
     680    PRIMARY KEY(warp_id, skycell_id, tess_id, class_id),
     681    KEY(fault),
     682    FOREIGN KEY (warp_id)
     683        REFERENCES warpRun(warp_id)
     684) ENGINE=innodb DEFAULT CHARSET=latin1;
     685
     686CREATE TABLE warpSkyfile (
     687    warp_id BIGINT,
     688    skycell_id VARCHAR(64),
     689    tess_id VARCHAR(64),
     690    uri VARCHAR(255),
     691    path_base VARCHAR(255),
     692    bg DOUBLE,
     693    bg_stdev DOUBLE,
     694    dtime_warp FLOAT,
     695    hostname VARCHAR(64),
     696    good_frac FLOAT,
     697    xmin INT,
     698    xmax INT,
     699    ymin INT,
     700    ymax INT,
     701    ignored TINYINT,
     702    fault SMALLINT,
     703    PRIMARY KEY(warp_id, skycell_id, tess_id),
     704    KEY(good_frac),
     705    KEY(ignored), KEY(fault),
     706    FOREIGN KEY (warp_id, skycell_id, tess_id) 
     707        REFERENCES warpSkyCellMap(warp_id, skycell_id, tess_id)
     708) ENGINE=innodb DEFAULT CHARSET=latin1;
     709
     710CREATE TABLE warpMask (
     711    label VARCHAR(64),
     712    PRIMARY KEY(label)
     713) ENGINE=innodb DEFAULT CHARSET=latin1;
     714
    90715CREATE TABLE stackRun (stack_id BIGINT AUTO_INCREMENT, state VARCHAR(64), workdir VARCHAR(255), dvodb VARCHAR(255), registered DATETIME, skycell_id VARCHAR(64), tess_id VARCHAR(64), PRIMARY KEY(stack_id), KEY(stack_id), KEY(state), KEY(skycell_id), KEY(tess_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    91716CREATE TABLE stackInputSkyfile (stack_id BIGINT, warp_id BIGINT, PRIMARY KEY(stack_id, warp_id), FOREIGN KEY (stack_id)  REFERENCES  stackRun(stack_id), FOREIGN KEY (warp_id)  REFERENCES  warpSkyfile(warp_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
Note: See TracChangeset for help on using the changeset viewer.