Index: /trunk/dbconfig/cam.md =================================================================== --- /trunk/dbconfig/cam.md (revision 19939) +++ /trunk/dbconfig/cam.md (revision 19940) @@ -34,7 +34,35 @@ fwhm_major F32 0.0 fwhm_minor F32 0.0 + + iq_m2 F32 0.0 + iq_m2_err F32 0.0 + iq_m2_lq F32 0.0 + iq_m2_uq F32 0.0 + + iq_m2c F32 0.0 + iq_m2c_err F32 0.0 + iq_m2c_lq F32 0.0 + iq_m2c_uq F32 0.0 + + iq_m2s F32 0.0 + iq_m2s_err F32 0.0 + iq_m2s_lq F32 0.0 + iq_m2s_uq F32 0.0 + + iq_m3 F32 0.0 + iq_m3_err F32 0.0 + iq_m3_lq F32 0.0 + iq_m3_uq F32 0.0 + + iq_m4 F32 0.0 + iq_m4_err F32 0.0 + iq_m4_lq F32 0.0 + iq_m4_uq F32 0.0 + dtime_script F32 0.0 hostname STR 64 n_stars S32 0 + n_psfstars S32 0 + n_iqstars S32 0 n_extended S32 0 n_cr S32 0 Index: /trunk/dbconfig/changes.txt =================================================================== --- /trunk/dbconfig/changes.txt (revision 19939) +++ /trunk/dbconfig/changes.txt (revision 19940) @@ -537,4 +537,5 @@ -- 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; @@ -558,2 +559,63 @@ * 1.1.40 + +-- Add moments statistics (M2, M3, M4) + +ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2 FLOAT AFTER fwhm_minor; +ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2_err FLOAT AFTER iq_m2; +ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2_lq FLOAT AFTER iq_m2_err; +ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2_uq FLOAT AFTER iq_m2_lq; + +ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2c FLOAT AFTER iq_m2_uq; +ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2c_err FLOAT AFTER iq_m2c; +ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2c_lq FLOAT AFTER iq_m2c_err; +ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2c_uq FLOAT AFTER iq_m2c_lq; + +ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2s FLOAT AFTER iq_m2c_uq; +ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2s_err FLOAT AFTER iq_m2s; +ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2s_lq FLOAT AFTER iq_m2s_err; +ALTER TABLE chipProcessedImfile ADD COLUMN iq_m2s_uq FLOAT AFTER iq_m2s_lq; + +ALTER TABLE chipProcessedImfile ADD COLUMN iq_m3 FLOAT AFTER iq_m2s_uq; +ALTER TABLE chipProcessedImfile ADD COLUMN iq_m3_err FLOAT AFTER iq_m3; +ALTER TABLE chipProcessedImfile ADD COLUMN iq_m3_lq FLOAT AFTER iq_m3_err; +ALTER TABLE chipProcessedImfile ADD COLUMN iq_m3_uq FLOAT AFTER iq_m3_lq; + +ALTER TABLE chipProcessedImfile ADD COLUMN iq_m4 FLOAT AFTER iq_m3_uq; +ALTER TABLE chipProcessedImfile ADD COLUMN iq_m4_err FLOAT AFTER iq_m4; +ALTER TABLE chipProcessedImfile ADD COLUMN iq_m4_lq FLOAT AFTER iq_m4_err; +ALTER TABLE chipProcessedImfile ADD COLUMN iq_m4_uq FLOAT AFTER iq_m4_lq; + +ALTER TABLE chipProcessedImfile ADD COLUMN n_psfstars INT AFTER n_stars; +ALTER TABLE chipProcessedImfile ADD COLUMN n_iqstars INT AFTER n_psfstars; + + +ALTER TABLE camProcessedExp ADD COLUMN iq_m2 FLOAT AFTER fwhm_minor; +ALTER TABLE camProcessedExp ADD COLUMN iq_m2_err FLOAT AFTER iq_m2; +ALTER TABLE camProcessedExp ADD COLUMN iq_m2_lq FLOAT AFTER iq_m2_err; +ALTER TABLE camProcessedExp ADD COLUMN iq_m2_uq FLOAT AFTER iq_m2_lq; + +ALTER TABLE camProcessedExp ADD COLUMN iq_m2c FLOAT AFTER iq_m2_uq; +ALTER TABLE camProcessedExp ADD COLUMN iq_m2c_err FLOAT AFTER iq_m2c; +ALTER TABLE camProcessedExp ADD COLUMN iq_m2c_lq FLOAT AFTER iq_m2c_err; +ALTER TABLE camProcessedExp ADD COLUMN iq_m2c_uq FLOAT AFTER iq_m2c_lq; + +ALTER TABLE camProcessedExp ADD COLUMN iq_m2s FLOAT AFTER iq_m2c_uq; +ALTER TABLE camProcessedExp ADD COLUMN iq_m2s_err FLOAT AFTER iq_m2s; +ALTER TABLE camProcessedExp ADD COLUMN iq_m2s_lq FLOAT AFTER iq_m2s_err; +ALTER TABLE camProcessedExp ADD COLUMN iq_m2s_uq FLOAT AFTER iq_m2s_lq; + +ALTER TABLE camProcessedExp ADD COLUMN iq_m3 FLOAT AFTER iq_m2s_uq; +ALTER TABLE camProcessedExp ADD COLUMN iq_m3_err FLOAT AFTER iq_m3; +ALTER TABLE camProcessedExp ADD COLUMN iq_m3_lq FLOAT AFTER iq_m3_err; +ALTER TABLE camProcessedExp ADD COLUMN iq_m3_uq FLOAT AFTER iq_m3_lq; + +ALTER TABLE camProcessedExp ADD COLUMN iq_m4 FLOAT AFTER iq_m3_uq; +ALTER TABLE camProcessedExp ADD COLUMN iq_m4_err FLOAT AFTER iq_m4; +ALTER TABLE camProcessedExp ADD COLUMN iq_m4_lq FLOAT AFTER iq_m4_err; +ALTER TABLE camProcessedExp ADD COLUMN iq_m4_uq FLOAT AFTER iq_m4_lq; + +ALTER TABLE camProcessedExp ADD COLUMN n_psfstars INT AFTER n_stars; +ALTER TABLE camProcessedExp ADD COLUMN n_iqstars INT AFTER n_psfstars; + +* 1.1.41 Index: /trunk/dbconfig/chip.md =================================================================== --- /trunk/dbconfig/chip.md (revision 19939) +++ /trunk/dbconfig/chip.md (revision 19940) @@ -31,10 +31,39 @@ fwhm_major F32 0.0 fwhm_minor F32 0.0 + + iq_m2 F32 0.0 + iq_m2_err F32 0.0 + iq_m2_lq F32 0.0 + iq_m2_uq F32 0.0 + + iq_m2c F32 0.0 + iq_m2c_err F32 0.0 + iq_m2c_lq F32 0.0 + iq_m2c_uq F32 0.0 + + iq_m2s F32 0.0 + iq_m2s_err F32 0.0 + iq_m2s_lq F32 0.0 + iq_m2s_uq F32 0.0 + + iq_m3 F32 0.0 + iq_m3_err F32 0.0 + iq_m3_lq F32 0.0 + iq_m3_uq F32 0.0 + + iq_m4 F32 0.0 + iq_m4_err F32 0.0 + iq_m4_lq F32 0.0 + iq_m4_uq F32 0.0 + dtime_detrend F32 0.0 dtime_photom F32 0.0 dtime_total F32 0.0 dtime_script F32 0.0 + hostname STR 64 n_stars S32 0 + n_psfstars S32 0 + n_iqstars S32 0 n_extended S32 0 n_cr S32 0 Index: /trunk/dbconfig/config.md =================================================================== --- /trunk/dbconfig/config.md (revision 19939) +++ /trunk/dbconfig/config.md (revision 19940) @@ -2,4 +2,4 @@ pkg_name STR ippdb pkg_namespace STR ippdb - pkg_version STR 1.1.40 + pkg_version STR 1.1.41 END