Changeset 28089 for trunk/ippTools/share/pxadmin_create_tables.sql

Timestamp:

May 25, 2010, 1:17:19 PM (16 years ago)

Author:

watersc1

Message:

Hopefully final edits for maskstats code

File:

• trunk/ippTools/share/pxadmin_create_tables.sql (modified) (2 diffs)

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -400 +400 @@
     magicked BIGINT,
     software_ver VARCHAR(16),
-    maskfrac_npix FLOAT,
-    maskfrac_static FLOAT,
-    maskfrac_dynamic FLOAT,
-    maskfrac_magic FLOAT,
-    maskfrac_advisory FLOAT,
+    maskfrac_ref_npix FLOAT,
+    maskfrac_ref_static FLOAT,
+    maskfrac_ref_dynamic FLOAT,
+    maskfrac_ref_magic FLOAT,
+    maskfrac_ref_advisory FLOAT,
+    maskfrac_max_npix FLOAT,
+    maskfrac_max_static FLOAT,
+    maskfrac_max_dynamic FLOAT,
+    maskfrac_max_magic FLOAT,
+    maskfrac_max_advisory FLOAT,
     note VARCHAR(255),
     PRIMARY KEY(cam_id),
@@ -483 +488 @@
     fault SMALLINT NOT NULL,
     software_ver VARCHAR(16),
-    maskfrac_npix INT,
-    maskfrac_static FLOAT,
-    maskfrac_dynamic FLOAT,
-    maskfrac_magic FLOAT,
-    maskfrac_advisory FLOAT,
+    maskfrac_ref_npix INT,
+    maskfrac_ref_static FLOAT,
+    maskfrac_ref_dynamic FLOAT,
+    maskfrac_ref_magic FLOAT,
+    maskfrac_ref_advisory FLOAT,
+    maskfrac_max_npix INT,
+    maskfrac_max_static FLOAT,
+    maskfrac_max_dynamic FLOAT,
+    maskfrac_max_magic FLOAT,
+    maskfrac_max_advisory FLOAT,
     PRIMARY KEY(cam_id),
     KEY(fault),