IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Apr 9, 2009, 4:00:49 PM (17 years ago)
Author:
giebink
Message:

corrected for updated schema

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/pxadmin_create_mirror_tables.sql

    r23771 r23785  
    168168    fault SMALLINT NOT NULL,
    169169    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     170    magicked TINYINT,
    170171    PRIMARY KEY(exp_id),
    171172    KEY(exp_name),
    … …  
    235236    ignored TINYINT DEFAULT 0,
    236237    hostname VARCHAR(64),
     238    quality SMALLINT NOT NULL DEFAULT 0,
    237239    fault SMALLINT NOT NULL,
    238240    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    … …  
    766768    end_stage VARCHAR(64),
    767769    registered DATETIME,
     770    magicked TINYINT,
    768771    PRIMARY KEY(warp_id),
    769772    KEY(warp_id),
    … …  
    812815    ymin INT,
    813816    ymax INT,
     817    quality SMALLINT NOT NULL DEFAULT 0,
    814818    ignored TINYINT,
    815819    fault SMALLINT,
    … …  
    875879        hostname VARCHAR(64),
    876880        good_frac FLOAT,
     881        quality SMALLINT NOT NULL DEFAULT 0,
    877882        fault SMALLINT,
    878883        PRIMARY KEY(stack_id),
    … …  
    892897        tess_id VARCHAR(64),
    893898        exp_id  BIGINT,
     899        magicked TINYINT,
    894900        PRIMARY KEY(diff_id),
    895901        KEY(diff_id),
    … …  
    941947        hostname VARCHAR(64),
    942948        good_frac FLOAT,
     949        quality SMALLINT NOT NULL DEFAULT 0,
    943950        fault SMALLINT,
    944951        magicked TINYINT,
Note: See TracChangeset for help on using the changeset viewer.