Changeset 28043 for trunk/dbconfig

Timestamp:

May 19, 2010, 5:13:52 PM (16 years ago)

Author:

watersc1

Message:

Merging czw_branch (maskstats and software versions) back into the trunk

Location:

trunk

Files:

• . (modified) (1 prop)
• dbconfig/cam.md (modified) (2 diffs)
• dbconfig/changes.txt (modified) (2 diffs)
• dbconfig/chip.md (modified) (2 diffs)
• dbconfig/diff.md (modified) (2 diffs)
• dbconfig/stack.md (modified) (2 diffs)
• dbconfig/warp.md (modified) (2 diffs)

trunk/dbconfig/cam.md

@@ -14 +14 @@
     end_stage   STR         64      # Key
     magicked    S64         0
+    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
     note        STR         255
 END
@@ -91 +97 @@
     path_base      STR      255
     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
     quality        S16      0
 END

trunk/dbconfig/changes.txt

@@ -1605 +1605 @@
 ALTER TABLE distTarget ADD KEY(stage), ADD KEY(dist_group), ADD KEY(filter), ADD KEY(state);
 
+-- Version 1.1.67
+
 CREATE TABLE Label (
     label       VARCHAR(64),
@@ -1616 +1618 @@
 
 ALTER TABLE pstampRequest ADD COLUMN outdir VARCHAR(64) after uri;
+
+-- Version 1.1.68
+ALTER TABLE chipRun ADD COLUMN software_ver VARCHAR(16) after magicked;
+ALTER TABLE chipRun ADD COLUMN maskfrac_npix INT after software_ver;
+ALTER TABLE chipRun ADD COLUMN maskfrac_static FLOAT after maskfrac_npix;
+ALTER TABLE chipRun ADD COLUMN maskfrac_dynamic FLOAT after maskfrac_static;
+ALTER TABLE chipRun ADD COLUMN maskfrac_magic FLOAT after maskfrac_dynamic;
+ALTER TABLE chipRun ADD COLUMN maskfrac_advisory FLOAT after maskfrac_magic;
+
+ALTER TABLE chipProcessedImfile ADD COLUMN software_ver VARCHAR(16) after magicked;
+ALTER TABLE chipProcessedImfile ADD COLUMN maskfrac_npix INT after software_ver;
+ALTER TABLE chipProcessedImfile ADD COLUMN maskfrac_static FLOAT after maskfrac_npix;
+ALTER TABLE chipProcessedImfile ADD COLUMN maskfrac_dynamic FLOAT after maskfrac_static;
+ALTER TABLE chipProcessedImfile ADD COLUMN maskfrac_magic FLOAT after maskfrac_dynamic;
+ALTER TABLE chipProcessedImfile ADD COLUMN maskfrac_advisory FLOAT after maskfrac_magic;
+
+ALTER TABLE camRun ADD COLUMN software_ver VARCHAR(16) after magicked;
+ALTER TABLE camRun ADD COLUMN maskfrac_npix INT after software_ver;
+ALTER TABLE camRun ADD COLUMN maskfrac_static FLOAT after maskfrac_npix;
+ALTER TABLE camRun ADD COLUMN maskfrac_dynamic FLOAT after maskfrac_static;
+ALTER TABLE camRun ADD COLUMN maskfrac_magic FLOAT after maskfrac_dynamic;
+ALTER TABLE camRun ADD COLUMN maskfrac_advisory FLOAT after maskfrac_magic;
+
+ALTER TABLE camProcessedExp ADD COLUMN software_ver VARCHAR(16) after fault;
+ALTER TABLE camProcessedExp ADD COLUMN maskfrac_npix INT after software_ver;
+ALTER TABLE camProcessedExp ADD COLUMN maskfrac_static FLOAT after maskfrac_npix;
+ALTER TABLE camProcessedExp ADD COLUMN maskfrac_dynamic FLOAT after maskfrac_static;
+ALTER TABLE camProcessedExp ADD COLUMN maskfrac_magic FLOAT after maskfrac_dynamic;
+ALTER TABLE camProcessedExp ADD COLUMN maskfrac_advisory FLOAT after maskfrac_magic;
+
+ALTER TABLE warpRun ADD COLUMN software_ver VARCHAR(16) after magicked;
+ALTER TABLE warpRun ADD COLUMN maskfrac_npix INT after software_ver;
+ALTER TABLE warpRun ADD COLUMN maskfrac_static FLOAT after maskfrac_npix;
+ALTER TABLE warpRun ADD COLUMN maskfrac_dynamic FLOAT after maskfrac_static;
+ALTER TABLE warpRun ADD COLUMN maskfrac_magic FLOAT after maskfrac_dynamic;
+ALTER TABLE warpRun ADD COLUMN maskfrac_advisory FLOAT after maskfrac_magic;
+
+ALTER TABLE warpSkyfile ADD COLUMN software_ver VARCHAR(16) after magicked;
+ALTER TABLE warpSkyfile ADD COLUMN maskfrac_npix INT after software_ver;
+ALTER TABLE warpSkyfile ADD COLUMN maskfrac_static FLOAT after maskfrac_npix;
+ALTER TABLE warpSkyfile ADD COLUMN maskfrac_dynamic FLOAT after maskfrac_static;
+ALTER TABLE warpSkyfile ADD COLUMN maskfrac_magic FLOAT after maskfrac_dynamic;
+ALTER TABLE warpSkyfile ADD COLUMN maskfrac_advisory FLOAT after maskfrac_magic;
+
+ALTER TABLE stackRun ADD COLUMN software_ver VARCHAR(16) after filter;
+
+ALTER TABLE stackSumSkyfile ADD COLUMN software_ver VARCHAR(16) after fault;
+
+ALTER TABLE diffRun ADD COLUMN software_ver VARCHAR(16) after magicked;
+ALTER TABLE diffRun ADD COLUMN maskfrac_npix INT after software_ver;
+ALTER TABLE diffRun ADD COLUMN maskfrac_static FLOAT after maskfrac_npix;
+ALTER TABLE diffRun ADD COLUMN maskfrac_dynamic FLOAT after maskfrac_static;
+ALTER TABLE diffRun ADD COLUMN maskfrac_magic FLOAT after maskfrac_dynamic;
+ALTER TABLE diffRun ADD COLUMN maskfrac_advisory FLOAT after maskfrac_magic;
+
+ALTER TABLE diffSkyfile ADD COLUMN software_ver VARCHAR(16) after magicked;
+ALTER TABLE diffSkyfile ADD COLUMN maskfrac_npix INT after software_ver;
+ALTER TABLE diffSkyfile ADD COLUMN maskfrac_static FLOAT after maskfrac_npix;
+ALTER TABLE diffSkyfile ADD COLUMN maskfrac_dynamic FLOAT after maskfrac_static;
+ALTER TABLE diffSkyfile ADD COLUMN maskfrac_magic FLOAT after maskfrac_dynamic;
+ALTER TABLE diffSkyfile ADD COLUMN maskfrac_advisory FLOAT after maskfrac_magic;
+

trunk/dbconfig/chip.md

@@ -14 +14 @@
     end_stage   STR         64      # Key
     magicked    S64         0
+    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
     note        STR         255
 END
@@ -93 +99 @@
     quality         S16     0
     magicked        S64     0
+    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
 END
 

trunk/dbconfig/diff.md

@@ -15 +15 @@
     exposure    BOOL        f
     magicked    S64         0
+    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
     diff_mode   S16         0
     note        STR         255
@@ -62 +68 @@
     quality      S16        0
     magicked    S64         0
+    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
 END

trunk/dbconfig/stack.md

@@ -14 +14 @@
     tess_id     STR         64      # Key
     filter      STR         64
+    software_ver    STR         16
     note        STR         255
 END
@@ -49 +50 @@
     good_frac          F32    0.0     # Key
     fault              S16    0       # Key
+    software_ver    STR         16
     quality            S16    0
 END

trunk/dbconfig/warp.md

@@ -25 +25 @@
     registered  TAI         NULL
     magicked    S64         0
+    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
     note        STR         255
 END
@@ -62 +68 @@
     quality        S16      0
     magicked       S64      0
+    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
 END