Changeset 19930
- Timestamp:
- Oct 6, 2008, 2:01:28 PM (18 years ago)
- Location:
- trunk/dbconfig
- Files:
-
- 8 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/dbconfig/cam.md
r18029 r19930 34 34 fwhm_major F32 0.0 35 35 fwhm_minor F32 0.0 36 dtime_detrend F32 0.0 37 dtime_photom F32 0.0 38 dtime_astrom F32 0.0 36 dtime_script F32 0.0 39 37 hostname STR 64 40 38 n_stars S32 0 -
trunk/dbconfig/changes.txt
r19760 r19930 535 535 536 536 537 -- Reusing astrometry time field since ppImage doesn't do that any more 538 ALTER TABLE chipProcessedImfile CHANGE COLUMN dtime_astrom dtime_total FLOAT; 539 -- Deleting fields requiring astrometric matching from chipProcessedImfile 540 ALTER TABLE chipProcessedImfile DROP COLUMN sigma_ra; 541 ALTER TABLE chipProcessedImfile DROP COLUMN sigma_dec; 542 ALTER TABLE chipProcessedImfile DROP COLUMN zp_mean; 543 ALTER TABLE chipProcessedImfile DROP COLUMN zp_stdev; 544 ALTER TABLE chipProcessedImfile DROP COLUMN n_astrom; 545 546 -- No need to propagate processing times from chip to camera 547 ALTER TABLE camProcessedExp DROP COLUMN dtime_detrend; 548 ALTER TABLE camProcessedExp DROP COLUMN dtime_photom; 549 ALTER TABLE camProcessedExp DROP COLUMN dtime_astrom; 550 551 -- Add "dtime_script" to processing results 552 ALTER TABLE chipProcessedImfile ADD COLUMN dtime_script FLOAT AFTER dtime_total; 553 ALTER TABLE camProcessedExp ADD COLUMN dtime_script FLOAT AFTER fwhm_minor; 554 ALTER TABLE fakeProcessedImfile ADD COLUMN dtime_script FLOAT AFTER dtime_fake; 555 ALTER TABLE warpSkyfile ADD COLUMN dtime_script FLOAT AFTER dtime_warp; 556 ALTER TABLE stackSumSkyfile ADD COLUMN dtime_script FLOAT AFTER dtime_phot; 557 ALTER TABLE diffSkyfile ADD COLUMN dtime_script FLOAT AFTER dtime_phot; 558 559 * 1.1.40 -
trunk/dbconfig/chip.md
r19334 r19930 27 27 fringe_1 F32 0.0 28 28 fringe_2 F32 0.0 29 sigma_ra F32 0.030 sigma_dec F32 0.031 29 ap_resid F32 0.0 32 30 ap_resid_stdev F32 0.0 33 zp_mean F32 0.034 zp_stdev F32 0.035 31 fwhm_major F32 0.0 36 32 fwhm_minor F32 0.0 37 33 dtime_detrend F32 0.0 38 34 dtime_photom F32 0.0 39 dtime_astrom F32 0.0 35 dtime_total F32 0.0 36 dtime_script F32 0.0 40 37 hostname STR 64 41 38 n_stars S32 0 42 39 n_extended S32 0 43 40 n_cr S32 0 44 n_astrom S32 045 41 path_base STR 255 46 42 fault S16 0 # Key NOT NULL -
trunk/dbconfig/config.md
r18795 r19930 2 2 pkg_name STR ippdb 3 3 pkg_namespace STR ippdb 4 pkg_version STR 1.1. 394 pkg_version STR 1.1.40 5 5 END -
trunk/dbconfig/diff.md
r19679 r19930 1 # $Id: diff.md,v 1.1 2 2008-09-23 19:58:27 billsExp $1 # $Id: diff.md,v 1.13 2008-10-07 00:01:28 price Exp $ 2 2 3 3 diffRun METADATA … … 30 30 31 31 diffSkyfile METADATA 32 diff_id S64 0 # Primary Key fkey(diff_id) ref diffRun(diff_id) 33 uri STR 255 34 path_base STR 255 35 bg F64 0.0 36 bg_stdev F64 0.0 37 stamps_num S32 0 38 stamps_mean F32 0.0 39 stamps_rms F32 0.0 40 sources S32 0 41 dtime_diff F32 0.0 42 dtime_match F32 0.0 43 dtime_phot F32 0.0 44 hostname STR 64 45 good_frac F32 0.0 # Key 46 fault S16 0 # Key 32 diff_id S64 0 # Primary Key fkey(diff_id) ref diffRun(diff_id) 33 uri STR 255 34 path_base STR 255 35 bg F64 0.0 36 bg_stdev F64 0.0 37 stamps_num S32 0 38 stamps_mean F32 0.0 39 stamps_rms F32 0.0 40 sources S32 0 41 dtime_diff F32 0.0 42 dtime_match F32 0.0 43 dtime_phot F32 0.0 44 dtime_script F32 0.0 45 hostname STR 64 46 good_frac F32 0.0 # Key 47 fault S16 0 # Key 47 48 END -
trunk/dbconfig/fake.md
r19558 r19930 19 19 uri STR 255 20 20 dtime_fake F32 0.0 21 dtime_script F32 0.0 21 22 hostname STR 64 22 23 path_base STR 255 -
trunk/dbconfig/stack.md
r19679 r19930 1 # $Id: stack.md,v 1.1 3 2008-09-23 19:58:27 billsExp $1 # $Id: stack.md,v 1.14 2008-10-07 00:01:28 price Exp $ 2 2 3 3 stackRun METADATA … … 20 20 21 21 stackSumSkyfile METADATA 22 stack_id S64 0 # Primary Key fkey(stack_id) ref stackRun(stack_id) 23 uri STR 255 24 path_base STR 255 25 bg F64 0.0 26 bg_stdev F64 0.0 27 dtime_stack F32 0.0 # Key 28 dtime_match_mean F32 0.0 # Key 29 dtime_match_stdev F32 0.0 # Key 30 dtime_initial F32 0.0 # Key 31 dtime_reject F32 0.0 # Key 32 dtime_final F32 0.0 # Key 33 dtime_phot F32 0.0 # Key 34 match_mean F32 0.0 35 match_stdev F32 0.0 36 match_rms F32 0.0 37 stamps_mean F32 0.0 38 stamps_stdev F32 0.0 39 stamps_min S32 0 40 reject_images S32 0 41 reject_pix_mean F32 0.0 42 reject_pix_stdev F32 0.0 43 sources S32 0 44 hostname STR 64 45 good_frac F32 0.0 # Key 46 fault S16 0 # Key 22 stack_id S64 0 # Primary Key fkey(stack_id) ref stackRun(stack_id) 23 uri STR 255 24 path_base STR 255 25 bg F64 0.0 26 bg_stdev F64 0.0 27 dtime_stack F32 0.0 # Key 28 dtime_match_mean F32 0.0 # Key 29 dtime_match_stdev F32 0.0 # Key 30 dtime_initial F32 0.0 # Key 31 dtime_reject F32 0.0 # Key 32 dtime_final F32 0.0 # Key 33 dtime_phot F32 0.0 # Key 34 dtime_script F32 0.0 35 match_mean F32 0.0 36 match_stdev F32 0.0 37 match_rms F32 0.0 38 stamps_mean F32 0.0 39 stamps_stdev F32 0.0 40 stamps_min S32 0 41 reject_images S32 0 42 reject_pix_mean F32 0.0 43 reject_pix_stdev F32 0.0 44 sources S32 0 45 hostname STR 64 46 good_frac F32 0.0 # Key 47 fault S16 0 # Key 47 48 END -
trunk/dbconfig/warp.md
r19363 r19930 1 # $Id: warp.md,v 1.1 8 2008-09-05 00:19:01 eugene Exp $1 # $Id: warp.md,v 1.19 2008-10-07 00:01:28 price Exp $ 2 2 3 3 # … … 34 34 35 35 warpSkyfile METADATA 36 warp_id S64 0 # Primary Key fkey(warp_id, skycell_id, tess_id) ref warpSkyCellMap(warp_id, skycell_id, tess_id) 37 skycell_id STR 64 # Primary Key 38 tess_id STR 64 # Primary Key 39 uri STR 255 40 path_base STR 255 41 data_state STR 64 # Key 42 bg F64 0.0 43 bg_stdev F64 0.0 44 dtime_warp F32 0.0 45 hostname STR 64 46 good_frac F32 0.0 # Key 47 xmin S32 0 48 xmax S32 0 49 ymin S32 0 50 ymax S32 0 51 ignored BOOL f # Key 52 fault S16 0 # Key 36 warp_id S64 0 # Primary Key fkey(warp_id, skycell_id, tess_id) ref warpSkyCellMap(warp_id, skycell_id, tess_id) 37 skycell_id STR 64 # Primary Key 38 tess_id STR 64 # Primary Key 39 uri STR 255 40 path_base STR 255 41 data_state STR 64 # Key 42 bg F64 0.0 43 bg_stdev F64 0.0 44 dtime_warp F32 0.0 45 dtime_script F32 0.0 46 hostname STR 64 47 good_frac F32 0.0 # Key 48 xmin S32 0 49 xmax S32 0 50 ymin S32 0 51 ymax S32 0 52 ignored BOOL f # Key 53 fault S16 0 # Key 53 54 END 54 55
Note:
See TracChangeset
for help on using the changeset viewer.
