Index: /branches/pap_mops/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- /branches/pap_mops/ippTools/share/pxadmin_create_tables.sql	(revision 24374)
+++ /branches/pap_mops/ippTools/share/pxadmin_create_tables.sql	(revision 24375)
@@ -1381,5 +1381,5 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
--- Publishing a set
+-- Publishing a set of data (e.g., a specific diffRun)
 CREATE TABLE publishRun (
     pub_id BIGINT AUTO_INCREMENT, -- unique identifier
@@ -1392,32 +1392,14 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+-- Publishing a file within a set
 CREATE TABLE publishFile (
     pub_id BIGINT AUTO_INCREMENT, -- link to publishRun
-    component VARCHAR(64),        --
-
-
-
-publishClient   METADATA
-    client_id   S64         0       # Primary Key AUTO_INCREMENT
-    comment     STR         255
-    stage       STR         64
-    format      STR         64
-    destination STR         255
-END
-
-publishRun      METADATA
-    pub_id      S64         0       # Primary Key AUTO_INCREMENT
-    client_id   S64         0
-    stage_id    S64         0
-    state       STR         64
-END
-
-publishFile     METADATA
-    pub_id      S64         0       # Primary Key
-    component   STR         64      # Primary Key
-    fault       S16         0
-END
-
-
+    component VARCHAR(64),        -- analagous to class_id or skycell_id
+    fault SMALLINT NOT NULL DEFAULT 0, -- Fault code
+    PRIMARY KEY(pub_id, component),
+    KEY(component),
+    KEY(fault),
+    FOREIGN KEY(pub_id) REFERENCES publishRun(pub_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;