IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Apr 2, 2009, 12:46:28 PM (17 years ago)
Author:
Paul Price
Message:

Ensure quality is non-NULL, defaulting to 0 (good quality).

File:
1 edited

Legend:

Unmodified
Added
Removed

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

    r23677 r23683  
    232232    ignored TINYINT DEFAULT 0,
    233233    hostname VARCHAR(64),
    234     quality SMALLINT NOT NULL,
     234    quality SMALLINT NOT NULL DEFAULT 0,
    235235    fault SMALLINT NOT NULL,
    236236    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    … …  
    336336    n_cr INT,
    337337    path_base VARCHAR(255),
    338     quality SMALLINT NOT NULL,
     338    quality SMALLINT NOT NULL DEFAULT 0,
    339339    fault SMALLINT NOT NULL,
    340340    magicked BIGINT,
    … …  
    436436    n_astrom INT,
    437437    path_base VARCHAR(255),
    438     quality SMALLINT NOT NULL,
     438    quality SMALLINT NOT NULL DEFAULT 0,
    439439    fault SMALLINT NOT NULL,
    440440    PRIMARY KEY(cam_id),
    … …  
    846846    ymin INT,
    847847    ymax INT,
    848     quality SMALLINT NOT NULL,
     848    quality SMALLINT NOT NULL DEFAULT 0,
    849849    fault SMALLINT,
    850850    magicked TINYINT,
    … …  
    913913        hostname VARCHAR(64),
    914914        good_frac FLOAT,
    915         quality SMALLINT NOT NULL,
     915        quality SMALLINT NOT NULL DEFAULT 0,
    916916        fault SMALLINT,
    917917        PRIMARY KEY(stack_id),
    … …  
    989989        hostname VARCHAR(64),
    990990        good_frac FLOAT,
    991         quality SMALLINT NOT NULL,
     991        quality SMALLINT NOT NULL DEFAULT 0,
    992992        fault SMALLINT,
    993993        magicked TINYINT,
Note: See TracChangeset for help on using the changeset viewer.