IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Jun 7, 2010, 12:00:46 PM (16 years ago)
Author:
watersc1
Message:

Final changes before trunk->branch merge.

Then, simtest to see if it all works correctly.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/czw_branch/20100519/ippTools/share/pxadmin_create_tables.sql

    r28164 r28245  
    983983CREATE TABLE warpSummary (
    984984       warp_id BIGINT,
    985        tangent_plane VARCHAR(64) NOT NULL,
     985       projection_cell VARCHAR(64) NOT NULL,
    986986       path_base     VARCHAR(255) NOT NULL,
    987987       PRIMARY KEY(warp_id),
    988        KEY(tangent_plane),
     988       KEY(projection_cell),
    989989       FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id)
    990990) ENGINE=innodb DEFAULT CHARSET=latin1;
     
    10621062CREATE TABLE stackSummary (
    10631063    stack_id     BIGINT,
    1064     tangent_plane VARCHAR(64) NOT NULL,
     1064    projection_cell VARCHAR(64) NOT NULL,
    10651065    path_base   VARCHAR(255) NOT NULL,
    10661066    PRIMARY KEY(stack_id),
    1067     KEY(tangent_plane),
     1067    KEY(projection_cell),
    10681068    FOREIGN KEY(stack_id) REFERENCES stackRun(stack_id)
    10691069) ENGINE=innodb DEFAULT CHARSET=latin1;
     
    10721072    sass_id      BIGINT AUTO_INCREMENT,
    10731073    data_group   VARCHAR(64) NOT NULL,
    1074     tangent_plane VARCHAR(64) NOT NULL,
     1074    projection_cell VARCHAR(64) NOT NULL,
    10751075    tess_id       VARCHAR(64) NOT NULL,
    10761076    filter        VARCHAR(64) NOT NULL,
    10771077    PRIMARY KEY(sass_id),
    10781078    KEY(data_group),
    1079     KEY(tangent_plane),
     1079    KEY(projection_cell),
    10801080    KEY(tess_id)
    10811081) ENGINE=innodb DEFAULT CHARSET=latin1;
     
    11871187CREATE TABLE diffSummary (
    11881188    diff_id     BIGINT,
    1189     tangent_plane VARCHAR(64) NOT NULL,
     1189    projection_cell VARCHAR(64) NOT NULL,
    11901190    path_base   VARCHAR(255) NOT NULL,
    11911191    PRIMARY KEY(diff_id),
    1192     KEY(tangent_plane),
     1192    KEY(projection_cell),
    11931193    FOREIGN KEY(diff_id) REFERENCES diffRun(diff_id)
    11941194) ENGINE=innodb DEFAULT CHARSET=latin1;
Note: See TracChangeset for help on using the changeset viewer.