Changeset 17802 for trunk/dbconfig

Timestamp:

May 23, 2008, 5:09:17 PM (18 years ago)

Author:

Paul Price

Message:

Adding hostname to registration

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• tasks.md (modified) (3 diffs)

trunk/dbconfig/changes.txt

@@ -157 +157 @@
 ALTER TABLE warpSkyfile ADD COLUMN (xmin INT, xmax INT, ymin INT, ymax INT);
 ALTER TABLE diffSkyfile ADD COLUMN (stamps_num INT, stamps_rms FLOAT, sources INT);
+ALTER TABLE rawImfile ADD COLUMN hostname VARCHAR(64) AFTER solang;
+ALTER TABLE diffSkyfile ADD COLUMN hostname VARCHAR(64) AFTER object;

trunk/dbconfig/tasks.md

@@ -1 @@
-# $Id: tasks.md,v 1.151 2008-05-22 21:17:33 jhoblitt Exp $
+# $Id: tasks.md,v 1.152 2008-05-24 03:09:11 price Exp $
 
 # this table records all exposure ID ever seen from the summit
@@ -154 +154 @@
     object      STR         64
     solang      F32         0.0
+    hostname    STR         64
     fault       S16         0       # Key NOT NULL
 END
@@ -212 +213 @@
     user_5      F64         0.0
     object      STR         64
-    fault       S16         0       # Key NOT NULL
-END
+    hostname    STR         64
+    fault       S16         0       # Key NOT NULL
+END