Index: branches/pap_mops/dbconfig/changes.txt
===================================================================
--- branches/pap_mops/dbconfig/changes.txt	(revision 24377)
+++ branches/pap_mops/dbconfig/changes.txt	(revision 24428)
@@ -1128,11 +1128,12 @@
 
 -- 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,11 +1153,11 @@
 ) 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;
+