Index: trunk/dbconfig/cam.md =================================================================== --- trunk/dbconfig/cam.md (revision 19760) +++ trunk/dbconfig/cam.md (revision 19930) @@ -34,7 +34,5 @@ fwhm_major F32 0.0 fwhm_minor F32 0.0 - dtime_detrend F32 0.0 - dtime_photom F32 0.0 - dtime_astrom F32 0.0 + dtime_script F32 0.0 hostname STR 64 n_stars S32 0 Index: trunk/dbconfig/changes.txt =================================================================== --- trunk/dbconfig/changes.txt (revision 19760) +++ trunk/dbconfig/changes.txt (revision 19930) @@ -535,2 +535,25 @@ +-- Reusing astrometry time field since ppImage doesn't do that any more +ALTER TABLE chipProcessedImfile CHANGE COLUMN dtime_astrom dtime_total FLOAT; +-- Deleting fields requiring astrometric matching from chipProcessedImfile +ALTER TABLE chipProcessedImfile DROP COLUMN sigma_ra; +ALTER TABLE chipProcessedImfile DROP COLUMN sigma_dec; +ALTER TABLE chipProcessedImfile DROP COLUMN zp_mean; +ALTER TABLE chipProcessedImfile DROP COLUMN zp_stdev; +ALTER TABLE chipProcessedImfile DROP COLUMN n_astrom; + +-- No need to propagate processing times from chip to camera +ALTER TABLE camProcessedExp DROP COLUMN dtime_detrend; +ALTER TABLE camProcessedExp DROP COLUMN dtime_photom; +ALTER TABLE camProcessedExp DROP COLUMN dtime_astrom; + +-- Add "dtime_script" to processing results +ALTER TABLE chipProcessedImfile ADD COLUMN dtime_script FLOAT AFTER dtime_total; +ALTER TABLE camProcessedExp ADD COLUMN dtime_script FLOAT AFTER fwhm_minor; +ALTER TABLE fakeProcessedImfile ADD COLUMN dtime_script FLOAT AFTER dtime_fake; +ALTER TABLE warpSkyfile ADD COLUMN dtime_script FLOAT AFTER dtime_warp; +ALTER TABLE stackSumSkyfile ADD COLUMN dtime_script FLOAT AFTER dtime_phot; +ALTER TABLE diffSkyfile ADD COLUMN dtime_script FLOAT AFTER dtime_phot; + +* 1.1.40 Index: trunk/dbconfig/chip.md =================================================================== --- trunk/dbconfig/chip.md (revision 19760) +++ trunk/dbconfig/chip.md (revision 19930) @@ -27,20 +27,16 @@ fringe_1 F32 0.0 fringe_2 F32 0.0 - sigma_ra F32 0.0 - sigma_dec F32 0.0 ap_resid F32 0.0 ap_resid_stdev F32 0.0 - zp_mean F32 0.0 - zp_stdev F32 0.0 fwhm_major F32 0.0 fwhm_minor F32 0.0 dtime_detrend F32 0.0 dtime_photom F32 0.0 - dtime_astrom F32 0.0 + dtime_total F32 0.0 + dtime_script F32 0.0 hostname STR 64 n_stars S32 0 n_extended S32 0 n_cr S32 0 - n_astrom S32 0 path_base STR 255 fault S16 0 # Key NOT NULL Index: trunk/dbconfig/config.md =================================================================== --- trunk/dbconfig/config.md (revision 19760) +++ trunk/dbconfig/config.md (revision 19930) @@ -2,4 +2,4 @@ pkg_name STR ippdb pkg_namespace STR ippdb - pkg_version STR 1.1.39 + pkg_version STR 1.1.40 END Index: trunk/dbconfig/diff.md =================================================================== --- trunk/dbconfig/diff.md (revision 19760) +++ trunk/dbconfig/diff.md (revision 19930) @@ -1,3 +1,3 @@ -# $Id: diff.md,v 1.12 2008-09-23 19:58:27 bills Exp $ +# $Id: diff.md,v 1.13 2008-10-07 00:01:28 price Exp $ diffRun METADATA @@ -30,18 +30,19 @@ diffSkyfile METADATA - diff_id S64 0 # Primary Key fkey(diff_id) ref diffRun(diff_id) - uri STR 255 - path_base STR 255 - bg F64 0.0 - bg_stdev F64 0.0 - stamps_num S32 0 - stamps_mean F32 0.0 - stamps_rms F32 0.0 - sources S32 0 - dtime_diff F32 0.0 - dtime_match F32 0.0 - dtime_phot F32 0.0 - hostname STR 64 - good_frac F32 0.0 # Key - fault S16 0 # Key + diff_id S64 0 # Primary Key fkey(diff_id) ref diffRun(diff_id) + uri STR 255 + path_base STR 255 + bg F64 0.0 + bg_stdev F64 0.0 + stamps_num S32 0 + stamps_mean F32 0.0 + stamps_rms F32 0.0 + sources S32 0 + dtime_diff F32 0.0 + dtime_match F32 0.0 + dtime_phot F32 0.0 + dtime_script F32 0.0 + hostname STR 64 + good_frac F32 0.0 # Key + fault S16 0 # Key END Index: trunk/dbconfig/fake.md =================================================================== --- trunk/dbconfig/fake.md (revision 19760) +++ trunk/dbconfig/fake.md (revision 19930) @@ -19,4 +19,5 @@ uri STR 255 dtime_fake F32 0.0 + dtime_script F32 0.0 hostname STR 64 path_base STR 255 Index: trunk/dbconfig/stack.md =================================================================== --- trunk/dbconfig/stack.md (revision 19760) +++ trunk/dbconfig/stack.md (revision 19930) @@ -1,3 +1,3 @@ -# $Id: stack.md,v 1.13 2008-09-23 19:58:27 bills Exp $ +# $Id: stack.md,v 1.14 2008-10-07 00:01:28 price Exp $ stackRun METADATA @@ -20,28 +20,29 @@ stackSumSkyfile METADATA - stack_id S64 0 # Primary Key fkey(stack_id) ref stackRun(stack_id) - uri STR 255 - path_base STR 255 - bg F64 0.0 - bg_stdev F64 0.0 - dtime_stack F32 0.0 # Key - dtime_match_mean F32 0.0 # Key - dtime_match_stdev F32 0.0 # Key - dtime_initial F32 0.0 # Key - dtime_reject F32 0.0 # Key - dtime_final F32 0.0 # Key - dtime_phot F32 0.0 # Key - match_mean F32 0.0 - match_stdev F32 0.0 - match_rms F32 0.0 - stamps_mean F32 0.0 - stamps_stdev F32 0.0 - stamps_min S32 0 - reject_images S32 0 - reject_pix_mean F32 0.0 - reject_pix_stdev F32 0.0 - sources S32 0 - hostname STR 64 - good_frac F32 0.0 # Key - fault S16 0 # Key + stack_id S64 0 # Primary Key fkey(stack_id) ref stackRun(stack_id) + uri STR 255 + path_base STR 255 + bg F64 0.0 + bg_stdev F64 0.0 + dtime_stack F32 0.0 # Key + dtime_match_mean F32 0.0 # Key + dtime_match_stdev F32 0.0 # Key + dtime_initial F32 0.0 # Key + dtime_reject F32 0.0 # Key + dtime_final F32 0.0 # Key + dtime_phot F32 0.0 # Key + dtime_script F32 0.0 + match_mean F32 0.0 + match_stdev F32 0.0 + match_rms F32 0.0 + stamps_mean F32 0.0 + stamps_stdev F32 0.0 + stamps_min S32 0 + reject_images S32 0 + reject_pix_mean F32 0.0 + reject_pix_stdev F32 0.0 + sources S32 0 + hostname STR 64 + good_frac F32 0.0 # Key + fault S16 0 # Key END Index: trunk/dbconfig/warp.md =================================================================== --- trunk/dbconfig/warp.md (revision 19760) +++ trunk/dbconfig/warp.md (revision 19930) @@ -1,3 +1,3 @@ -# $Id: warp.md,v 1.18 2008-09-05 00:19:01 eugene Exp $ +# $Id: warp.md,v 1.19 2008-10-07 00:01:28 price Exp $ # @@ -34,21 +34,22 @@ warpSkyfile METADATA - warp_id S64 0 # Primary Key fkey(warp_id, skycell_id, tess_id) ref warpSkyCellMap(warp_id, skycell_id, tess_id) - skycell_id STR 64 # Primary Key - tess_id STR 64 # Primary Key - uri STR 255 - path_base STR 255 - data_state STR 64 # Key - bg F64 0.0 - bg_stdev F64 0.0 - dtime_warp F32 0.0 - hostname STR 64 - good_frac F32 0.0 # Key - xmin S32 0 - xmax S32 0 - ymin S32 0 - ymax S32 0 - ignored BOOL f # Key - fault S16 0 # Key + warp_id S64 0 # Primary Key fkey(warp_id, skycell_id, tess_id) ref warpSkyCellMap(warp_id, skycell_id, tess_id) + skycell_id STR 64 # Primary Key + tess_id STR 64 # Primary Key + uri STR 255 + path_base STR 255 + data_state STR 64 # Key + bg F64 0.0 + bg_stdev F64 0.0 + dtime_warp F32 0.0 + dtime_script F32 0.0 + hostname STR 64 + good_frac F32 0.0 # Key + xmin S32 0 + xmax S32 0 + ymin S32 0 + ymax S32 0 + ignored BOOL f # Key + fault S16 0 # Key END