Index: /trunk/dbconfig/changes.txt
===================================================================
--- /trunk/dbconfig/changes.txt	(revision 19683)
+++ /trunk/dbconfig/changes.txt	(revision 19684)
@@ -485,6 +485,4 @@
     REFERENCES  detNormalizedExp(det_id, iteration);
 
-
-
 --- Additions for stack/diff QA by PAP.
 ALTER TABLE diffSkyfile ADD COLUMN stamps_mean FLOAT AFTER stamps_num;
@@ -508,5 +506,17 @@
 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;
Index: /trunk/dbconfig/tasks.md
===================================================================
--- /trunk/dbconfig/tasks.md	(revision 19683)
+++ /trunk/dbconfig/tasks.md	(revision 19684)
@@ -1,3 +1,3 @@
-# $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,5 +160,9 @@
     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,4 +225,9 @@
     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