Changeset 17872 for trunk/dbconfig/tasks.md

Timestamp:

May 30, 2008, 4:19:52 PM (18 years ago)

Author:

jhoblitt

Message:

add epoch fields to pz*, new*, & raw* tables

File:

• trunk/dbconfig/tasks.md (modified) (10 diffs)

trunk/dbconfig/tasks.md

@@ -1 @@
-# $Id: tasks.md,v 1.153 2008-05-29 02:36:29 jhoblitt Exp $
+# $Id: tasks.md,v 1.154 2008-05-31 02:19:17 jhoblitt Exp $
 
 # this table records all exposure ID ever seen from the summit
@@ -24 +24 @@
     telescope   STR         64      # Primary Key
     uri         STR         255
+    epoch       UTC         0001-01-01T00:00:00Z
 END
 
@@ -38 +39 @@
     imfiles     S32         0
     fault       S16         0       # Key NOT NULL
+    epoch       UTC         0001-01-01T00:00:00Z
 END
 
@@ -53 +55 @@
     class_id    STR         64      # Primary Key
     uri         STR         255
+    epoch       UTC         0001-01-01T00:00:00Z
 END
 
@@ -62 +65 @@
     telescope   STR         64      # Primary Key
     state       STR         64      # Key 
+    epoch       UTC         0001-01-01T00:00:00Z
 END
 
@@ -72 +76 @@
     uri         STR         255
     fault       S16         0       # Key NOT NULL
+    epoch       UTC         0001-01-01T00:00:00Z
 END
 
@@ -87 +92 @@
     end_stage   STR         64      # Key
     label       STR         64      # Key
+    epoch       UTC         0001-01-01T00:00:00Z
 END
 
@@ -95 +101 @@
     tmp_class_id STR        64      # Primary Key
     uri         STR         255
+    epoch       UTC         0001-01-01T00:00:00Z
 END
 
@@ -156 +163 @@
     hostname    STR         64
     fault       S16         0       # Key NOT NULL
+    epoch       UTC         0001-01-01T00:00:00Z
 END
 
@@ -215 +223 @@
     hostname    STR         64
     fault       S16         0       # Key NOT NULL
-END
+    epoch       UTC         0001-01-01T00:00:00Z
+END