Changeset 24038 for trunk/dbconfig

Timestamp:

May 1, 2009, 5:28:52 PM (17 years ago)

Author:

bills

Message:

on receive side of distribution, optionally create a fileset in a status data store
defer {$stage}tool -importrun until all of the files have been downloaded
in the dist.queuruns task queue rcruns

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• receive.md (modified) (2 diffs)

trunk/dbconfig/changes.txt

@@ -1088 +1088 @@
 -- This key makes it faster to find the ccd_temp for XY24
 ALTER TABLE rawImfile ADD KEY(dateobs);
+
+ALTER TABLE receiveSource ADD COLUMN status_product VARCHAR(64);
+ALTER TABLE receiveSource ADD COLUMN ds_dbname VARCHAR(64);
+ALTER TABLE receiveSource ADD COLUMN ds_dbhost VARCHAR(64);
+
+ALTER TABLE receiveFileset ADD COLUMN state VARCHAR(64);
+ALTER TABLE receiveFileset ADD COLUMN dbinfo_uri VARCHAR(255);
+ALTER TABLE receiveFileset ADD COLUMN fault SMALLINT NOT NULL DEFAULT 0;

trunk/dbconfig/receive.md

@@ -8 +8 @@
         comment         STR     255     # Key
         fileset_last    STR     128
+        status_product  STR     64
+        ds_dbname       STR     64
+        ds_dbhost       STR     64
 END
 
@@ -14 +17 @@
         source_id       S64     0       # Key fkey (source_id) ref receiveSource(source_id)
         fileset         STR     128
+        state           STR     64
+        dbinfo_uri      STR     255
+        fault           S32     0       # Key
 END