Changeset 28089 for trunk/dbconfig/changes.txt

Timestamp:

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

Author:

watersc1

Message:

Hopefully final edits for maskstats code

File:

• trunk/dbconfig/changes.txt (modified) (1 diff)

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;