Changeset 28089 for trunk/dbconfig

Timestamp:

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

Author:

watersc1

Message:

Hopefully final edits for maskstats code

Location:

trunk/dbconfig

Files:

• cam.md (modified) (2 diffs)
• changes.txt (modified) (1 diff)

trunk/dbconfig/cam.md

@@ -15 +15 @@
     magicked    S64         0
     software_ver    STR         16
-    maskfrac_npix F32       0.0
-    maskfrac_static F32     0.0
-    maskfrac_dynamic F32    0.0
-    maskfrac_magic  F32     0.0
-    maskfrac_advisory F32   0.0
+    maskfrac_ref_npix S32       0
+    maskfrac_ref_static F32         0.0
+    maskfrac_ref_dynamic F32    0.0
+    maskfrac_ref_magic  F32     0.0
+    maskfrac_ref_advisory F32   0.0
+    maskfrac_max_npix S32       0
+    maskfrac_max_static F32         0.0
+    maskfrac_max_dynamic F32    0.0
+    maskfrac_max_magic  F32     0.0
+    maskfrac_max_advisory F32   0.0
     note        STR         255
 END
@@ -98 +103 @@
     fault          S16      0       # Key NOT NULL
     software_ver    STR         16
-    maskfrac_npix S32       0
-    maskfrac_static F32     0.0
-    maskfrac_dynamic F32    0.0
-    maskfrac_magic  F32     0.0
-    maskfrac_advisory F32   0.0
+    maskfrac_ref_npix S32       0
+    maskfrac_ref_static F32         0.0
+    maskfrac_ref_dynamic F32    0.0
+    maskfrac_ref_magic  F32     0.0
+    maskfrac_ref_advisory F32   0.0
+    maskfrac_max_npix S32       0
+    maskfrac_max_static F32         0.0
+    maskfrac_max_dynamic F32    0.0
+    maskfrac_max_magic  F32     0.0
+    maskfrac_max_advisory F32   0.0
     quality        S16      0
 END

trunk/dbconfig/changes.txt

@@ -1684 +1684 @@
 ALTER TABLE warpRun CHANGE maskfrac_npix maskfrac_npix FLOAT; 
 ALTER TABLE diffRun CHANGE maskfrac_npix maskfrac_npix FLOAT;
+
+ALTER TABLE camRun CHANGE maskfrac_npix maskfrac_ref_npix FLOAT;
+ALTER TABLE camRun CHANGE maskfrac_static maskfrac_ref_static FLOAT;
+ALTER TABLE camRun CHANGE maskfrac_dynamic maskfrac_ref_dynamic FLOAT;
+ALTER TABLE camRun CHANGE maskfrac_magic maskfrac_ref_magic FLOAT;
+ALTER TABLE camRun CHANGE maskfrac_advisory maskfrac_ref_advisory FLOAT;
+
+ALTER TABLE camProcessedExp CHANGE maskfrac_npix maskfrac_ref_npix INT;
+ALTER TABLE camProcessedExp CHANGE maskfrac_static maskfrac_ref_static FLOAT;
+ALTER TABLE camProcessedExp CHANGE maskfrac_dynamic maskfrac_ref_dynamic FLOAT;
+ALTER TABLE camProcessedExp CHANGE maskfrac_magic maskfrac_ref_magic FLOAT;
+ALTER TABLE camProcessedExp CHANGE maskfrac_advisory maskfrac_ref_advisory FLOAT;
+
+ALTER TABLE camRun ADD COLUMN maskfrac_max_npix FLOAT after maskfrac_ref_advisory;
+ALTER TABLE camRun ADD COLUMN maskfrac_max_static FLOAT after maskfrac_max_npix;
+ALTER TABLE camRun ADD COLUMN maskfrac_max_dynamic FLOAT after maskfrac_max_static;
+ALTER TABLE camRun ADD COLUMN maskfrac_max_magic FLOAT after maskfrac_max_dynamic;
+ALTER TABLE camRun ADD COLUMN maskfrac_max_advisory FLOAT after maskfrac_max_magic;
+
+ALTER TABLE camProcessedExp ADD COLUMN maskfrac_max_npix INT after maskfrac_ref_advisory;
+ALTER TABLE camProcessedExp ADD COLUMN maskfrac_max_static FLOAT after maskfrac_max_npix;
+ALTER TABLE camProcessedExp ADD COLUMN maskfrac_max_dynamic FLOAT after maskfrac_max_static;
+ALTER TABLE camProcessedExp ADD COLUMN maskfrac_max_magic FLOAT after maskfrac_max_dynamic;
+ALTER TABLE camProcessedExp ADD COLUMN maskfrac_max_advisory FLOAT after maskfrac_max_magic;