Changeset 19684

Timestamp:

Sep 23, 2008, 10:12:05 AM (18 years ago)

Author:

eugene

Message:

adding solar system info (sun and moon data)

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (2 diffs)
• tasks.md (modified) (3 diffs)

trunk/dbconfig/changes.txt

@@ -485 +485 @@
     REFERENCES  detNormalizedExp(det_id, iteration);
 
-
-
 --- Additions for stack/diff QA by PAP.
 ALTER TABLE diffSkyfile ADD COLUMN stamps_mean FLOAT AFTER stamps_num;
@@ -508 +506 @@
 ALTER TABLE stackSumSkyfile ADD COLUMN reject_pix_stdev FLOAT AFTER reject_pix_mean;
 ALTER TABLE stackSumSkyfile ADD COLUMN sources INT AFTER reject_pix_stdev;
-
 ALTER TABLE stackSumSkyfile DROP COLUMN data_state;
 ALTER TABLE diffSkyfile DROP COLUMN data_state;
+
+-- Adding the new solar-system info (sun & moon data)
+ALTER TABLE rawExp CHANGE COLUMN solangle sun_angle FLOAT;
+ALTER TABLE rawExp ADD COLUMN sun_alt    FLOAT AFTER sun_angle;
+ALTER TABLE rawExp ADD COLUMN moon_angle FLOAT AFTER sun_alt;
+ALTER TABLE rawExp ADD COLUMN moon_alt   FLOAT AFTER moon_angle;
+ALTER TABLE rawExp ADD COLUMN moon_phase FLOAT AFTER moon_alt;
+
+ALTER TABLE rawImfile ADD COLUMN sun_angle  FLOAT AFTER object;
+ALTER TABLE rawImfile ADD COLUMN sun_alt    FLOAT AFTER sun_angle;
+ALTER TABLE rawImfile ADD COLUMN moon_angle FLOAT AFTER sun_alt;
+ALTER TABLE rawImfile ADD COLUMN moon_alt   FLOAT AFTER moon_angle;
+ALTER TABLE rawImfile ADD COLUMN moon_phase FLOAT AFTER moon_alt;

trunk/dbconfig/tasks.md

@@ -1 @@
-# $Id: tasks.md,v 1.154 2008-05-31 02:19:17 jhoblitt Exp $
+# $Id: tasks.md,v 1.155 2008-09-23 20:12:05 eugene Exp $
 
 # this table records all exposure ID ever seen from the summit
@@ -160 +160 @@
     user_5      F64         0.0
     object      STR         64
-    solang      F32         0.0
+    sun_angle   F32         0.0
+    sun_alt     F32         0.0
+    moon_angle  F32         0.0
+    moon_alt    F32         0.0
+    moon_phase  F32         0.0
     hostname    STR         64
     fault       S16         0       # Key NOT NULL
@@ -221 +225 @@
     user_5      F64         0.0
     object      STR         64
+    sun_angle   F32         0.0
+    sun_alt     F32         0.0
+    moon_angle  F32         0.0
+    moon_alt    F32         0.0
+    moon_phase  F32         0.0
     hostname    STR         64
     fault       S16         0       # Key NOT NULL