Changeset 18532

Timestamp:

Jul 15, 2008, 9:42:08 AM (18 years ago)

Author:

bills

Message:

Changes to the pstamp database tables.

pstampRequest

removed outFileset
removed resultsFile
added outProduct
added name from request file header must be unique
added reqType 'pstamp', 'dquery' or more in future
added fault

pstampJob

renamed result fault for consistency
added rownum

pstampDataStore

outProduct does not need to be unique

File:

• trunk/dbconfig/pstamp.md (modified) (3 diffs)

trunk/dbconfig/pstamp.md

@@ -3 +3 @@
     state       STR         64
     lastFileset STR         64
-    outProduct  STR         64      # UNIQUE
+    outProduct  STR         64
     uri         STR         255
 END
@@ -11 +11 @@
     ds_id       S64         0
     state       STR         64
-    outFileset  STR         64      # UNIQUE
+    name        STR         64      # UNIQUE
+    reqType     STR         16
+    outProduct  STR         64
     uri         STR         255
-    resultsFile S16         0
+    fault       S32         0
 END
 
@@ -19 +21 @@
     job_id      S64         0       # Primary Key AUTO_INCREMENT
     req_id      S64         0       # Primary Key fkey(req_id) ref pstampRequest(req_id)
+    rownum      STR         64
     state       STR         64
     jobType     STR         16
-    result      S32         0
+    fault       S32         0
     uri         STR         255
     outputBase  STR         255