Changeset 24428 for branches/pap_mops/dbconfig/changes.txt

Timestamp:

Jun 16, 2009, 10:21:18 AM (17 years ago)

Author:

Paul Price

Message:

Moving workdir under publishClient so it doesn't have to be defined for every run (which is going to run regularly under pantasks)

File:

• branches/pap_mops/dbconfig/changes.txt (modified) (2 diffs)

branches/pap_mops/dbconfig/changes.txt

@@ -1128 +1128 @@
 
 -- Tables to support publishing of detections to a Science Client
+
 -- Clients to which we send stuff
 CREATE TABLE publishClient (
     client_id BIGINT AUTO_INCREMENT, -- unique identifier
+    product VARCHAR(64),             -- product name
+    stage VARCHAR(64) NOT NULL, -- stage of interest (chip, camera, diff, etc.)
+    workdir VARCHAR(255) NOT NULL, -- working directory
     comment VARCHAR(255),            -- for human memory
-    stage VARCHAR(64) NOT NULL, -- stage of interest (chip, camera, diff, etc.)
-    format VARCHAR(64),              -- format of data
-    destination VARCHAR(255) NOT NULL, -- where to send data
     PRIMARY KEY(client_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -1152 +1153 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 -- Publishing a file within a set
-CREATE TABLE publishFile (
+CREATE TABLE publishDone (
     pub_id BIGINT AUTO_INCREMENT, -- link to publishRun
-    component VARCHAR(64),        -- analagous to class_id or skycell_id
+    path_base VARCHAR(255),     -- base path of output
     fault SMALLINT NOT NULL DEFAULT 0, -- Fault code
-    PRIMARY KEY(pub_id, component),
-    KEY(component),
+    PRIMARY KEY(pub_id),
     KEY(fault),
     FOREIGN KEY(pub_id) REFERENCES publishRun(pub_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
+