Changeset 27450 for trunk

Timestamp:

Mar 26, 2010, 11:07:48 AM (16 years ago)

Author:

bills

Message:

add alternate to distRun get inputs from alternate location
add magicDSFile.nondiffed_frac the fraction of pixels masked due to no overlap with diffSkycell

Location:

trunk

Files:

• dbconfig/changes.txt (modified) (1 diff)
• dbconfig/dist.md (modified) (1 diff)
• dbconfig/magic.md (modified) (1 diff)
• ippTools/share/pxadmin_create_tables.sql (modified) (2 diffs)

trunk/dbconfig/changes.txt

@@ -1538 +1538 @@
 -- Version 1.1.66
 
+ALTER TABLE magicDSFile ADD COLUMN nondiff_frac FLOAT AFTER streak_frac;
+ALTER TABLE distRun ADD COLUMN alternate TINYINT DEFAULT 0 AFTER no_magic;

trunk/dbconfig/dist.md

@@ -20 +20 @@
     clean       BOOL        f
     no_magic    BOOL        f
+    alternate   BOOL        f
     state       STR         64      # Key
     time_stamp  UTC         0001-01-01T00:00:00Z

trunk/dbconfig/magic.md

@@ -70 +70 @@
     recovery_path_base STR        255
     streak_frac F32         0
+    nondiff_frac F32         0
     run_time    F32         0
     fault       S16         0

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1185 +1185 @@
     recovery_path_base VARCHAR(255),
     streak_frac FLOAT,
+    nondiff_frac FLOAT,
     run_time FLOAT,
     fault SMALLINT,
@@ -1355 +1356 @@
     clean       TINYINT,
     no_magic    TINYINT,
+    alternate   TINYINT,
     state       VARCHAR(64),
     time_stamp  TIMESTAMP DEFAULT CURRENT_TIMESTAMP,