IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Jul 16, 2008, 9:25:00 AM (18 years ago)
Author:
Paul Price
Message:

Reformatting some of my tables. Adding "filter" to stackRun.

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/pxadmin_create_tables.sql

    r18520 r18576  
    713713) ENGINE=innodb DEFAULT CHARSET=latin1;
    714714
    715 CREATE 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;
    716 CREATE 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;
    717 CREATE TABLE stackSumSkyfile (stack_id BIGINT, uri VARCHAR(255), path_base VARCHAR(255), bg DOUBLE, bg_stdev DOUBLE, dtime_stack FLOAT, hostname VARCHAR(64), good_frac FLOAT, fault SMALLINT, PRIMARY KEY(stack_id), KEY(dtime_stack), KEY(good_frac), KEY(fault), FOREIGN KEY (stack_id)  REFERENCES  stackRun(stack_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    718 CREATE TABLE diffRun (diff_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(diff_id), KEY(diff_id), KEY(state), KEY(skycell_id), KEY(tess_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    719 CREATE TABLE diffInputSkyfile (diff_id BIGINT, template TINYINT, stack_id BIGINT, warp_id BIGINT, skycell_id VARCHAR(64), tess_id VARCHAR(64), kind VARCHAR(64), PRIMARY KEY(diff_id, template), KEY(stack_id), KEY(warp_id), KEY(skycell_id), KEY(tess_id), KEY(kind), FOREIGN KEY (diff_id)  REFERENCES  diffRun(diff_id), FOREIGN KEY (stack_id)  REFERENCES  stackSumSkyfile(stack_id), FOREIGN KEY (warp_id, skycell_id, tess_id)  REFERENCES  warpSkyfile(warp_id, skycell_id, tess_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    720 CREATE TABLE diffSkyfile (diff_id BIGINT, uri VARCHAR(255), path_base VARCHAR(255), bg DOUBLE, bg_stdev DOUBLE, stamps_num INT, stamps_rms FLOAT, sources INT, dtime_diff FLOAT, hostname VARCHAR(64), good_frac FLOAT, fault SMALLINT, PRIMARY KEY(diff_id), KEY(good_frac), KEY(fault), FOREIGN KEY (diff_id)  REFERENCES  diffRun(diff_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
     715CREATE TABLE stackRun (
     716        stack_id BIGINT AUTO_INCREMENT,
     717        state VARCHAR(64),
     718        workdir VARCHAR(255),
     719        dvodb VARCHAR(255),
     720        registered DATETIME,
     721        skycell_id VARCHAR(64),
     722        tess_id VARCHAR(64),
     723        filter VARCHAR(64),
     724        PRIMARY KEY(stack_id),
     725        KEY(stack_id),
     726        KEY(state),
     727        KEY(skycell_id),
     728        KEY(tess_id)
     729) ENGINE=innodb DEFAULT CHARSET=latin1;
     730
     731CREATE TABLE stackInputSkyfile (
     732        stack_id BIGINT,
     733        warp_id BIGINT,
     734        PRIMARY KEY(stack_id, warp_id),
     735        FOREIGN KEY (stack_id)  REFERENCES  stackRun(stack_id),
     736        FOREIGN KEY (warp_id)  REFERENCES  warpSkyfile(warp_id)
     737) ENGINE=innodb DEFAULT CHARSET=latin1;
     738
     739CREATE TABLE stackSumSkyfile (
     740        stack_id BIGINT,
     741        uri VARCHAR(255),
     742        path_base VARCHAR(255),
     743        bg DOUBLE,
     744        bg_stdev DOUBLE,
     745        dtime_stack FLOAT,
     746        hostname VARCHAR(64),
     747        good_frac FLOAT,
     748        fault SMALLINT,
     749        PRIMARY KEY(stack_id),
     750        KEY(dtime_stack),
     751        KEY(good_frac),
     752        KEY(fault),
     753        FOREIGN KEY (stack_id)  REFERENCES  stackRun(stack_id)
     754) ENGINE=innodb DEFAULT CHARSET=latin1;
     755
     756CREATE TABLE diffRun (
     757        diff_id BIGINT AUTO_INCREMENT,
     758        state VARCHAR(64),
     759        workdir VARCHAR(255),
     760        dvodb VARCHAR(255),
     761        registered DATETIME,
     762        skycell_id VARCHAR(64),
     763        tess_id VARCHAR(64),
     764        PRIMARY KEY(diff_id),
     765        KEY(diff_id),
     766        KEY(state),
     767        KEY(skycell_id),
     768        KEY(tess_id)
     769) ENGINE=innodb DEFAULT CHARSET=latin1;
     770
     771CREATE TABLE diffInputSkyfile (
     772        diff_id BIGINT,
     773        template TINYINT,
     774        stack_id BIGINT,
     775        warp_id BIGINT,
     776        skycell_id VARCHAR(64),
     777        tess_id VARCHAR(64),
     778        kind VARCHAR(64),
     779        PRIMARY KEY(diff_id, template),
     780        KEY(stack_id),
     781        KEY(warp_id),
     782        KEY(skycell_id),
     783        KEY(tess_id),
     784        KEY(kind),
     785        FOREIGN KEY (diff_id)  REFERENCES  diffRun(diff_id),
     786        FOREIGN KEY (stack_id)  REFERENCES  stackSumSkyfile(stack_id),
     787        FOREIGN KEY (warp_id, skycell_id, tess_id)  REFERENCES  warpSkyfile(warp_id, skycell_id, tess_id)
     788) ENGINE=innodb DEFAULT CHARSET=latin1;
     789
     790CREATE TABLE diffSkyfile (
     791        diff_id BIGINT,
     792        uri VARCHAR(255),
     793        path_base VARCHAR(255),
     794        bg DOUBLE,
     795        bg_stdev DOUBLE,
     796        stamps_num INT,
     797        stamps_rms FLOAT,
     798        sources INT,
     799        dtime_diff FLOAT,
     800        hostname VARCHAR(64),
     801        good_frac FLOAT,
     802        fault SMALLINT,
     803        PRIMARY KEY(diff_id),
     804        KEY(good_frac),
     805        KEY(fault),
     806        FOREIGN KEY (diff_id)  REFERENCES  diffRun(diff_id)
     807) ENGINE=innodb DEFAULT CHARSET=latin1;
    721808
    722809CREATE TABLE magicRun (
Note: See TracChangeset for help on using the changeset viewer.