Index: trunk/dbconfig/cam.md =================================================================== --- trunk/dbconfig/cam.md (revision 27962) +++ trunk/dbconfig/cam.md (revision 28043) @@ -14,4 +14,10 @@ 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,4 +97,10 @@ 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 Index: trunk/dbconfig/changes.txt =================================================================== --- trunk/dbconfig/changes.txt (revision 27962) +++ trunk/dbconfig/changes.txt (revision 28043) @@ -1605,4 +1605,6 @@ 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,2 +1618,64 @@ 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; + Index: trunk/dbconfig/chip.md =================================================================== --- trunk/dbconfig/chip.md (revision 27962) +++ trunk/dbconfig/chip.md (revision 28043) @@ -14,4 +14,10 @@ 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,4 +99,10 @@ 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 Index: trunk/dbconfig/diff.md =================================================================== --- trunk/dbconfig/diff.md (revision 27962) +++ trunk/dbconfig/diff.md (revision 28043) @@ -15,4 +15,10 @@ 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,3 +68,9 @@ 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 Index: trunk/dbconfig/stack.md =================================================================== --- trunk/dbconfig/stack.md (revision 27962) +++ trunk/dbconfig/stack.md (revision 28043) @@ -14,4 +14,5 @@ tess_id STR 64 # Key filter STR 64 + software_ver STR 16 note STR 255 END @@ -49,4 +50,5 @@ good_frac F32 0.0 # Key fault S16 0 # Key + software_ver STR 16 quality S16 0 END Index: trunk/dbconfig/warp.md =================================================================== --- trunk/dbconfig/warp.md (revision 27962) +++ trunk/dbconfig/warp.md (revision 28043) @@ -25,4 +25,10 @@ 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,4 +68,10 @@ 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