Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 23785)
+++ trunk/ippTools/share/Makefile.am	(revision 23842)
@@ -100,4 +100,5 @@
      disttool_definebyquery_warp.sql \
      disttool_pendingcomponent.sql \
+     disttool_pendingfileset.sql \
      disttool_processedcomponent.sql \
      disttool_revertrun_update.sql \
Index: trunk/ippTools/share/disttool_pendingfileset.sql
===================================================================
--- trunk/ippTools/share/disttool_pendingfileset.sql	(revision 23842)
+++ trunk/ippTools/share/disttool_pendingfileset.sql	(revision 23842)
@@ -0,0 +1,15 @@
+SELECT
+    dist_id,
+    target_id,
+    distRun.stage,
+    stage_id,
+    CONCAT_WS('.', distRun.outroot, CONVERT(distRun.dist_id, CHAR)) as dist_dir,
+    rcDSProduct.*
+FROM rcDestination 
+JOIN rcInterest USING(dest_id) 
+JOIN distTarget USING(target_id) 
+JOIN rcDSProduct USING(prod_id)
+JOIN distRun USING(target_id) 
+LEFT JOIN rcDSFileset USING(prod_id, dist_id)
+WHERE distRun.state = 'full'
+    AND rcDSFileset.fs_id IS NULL
Index: trunk/ippTools/share/disttool_processedcomponent.sql
===================================================================
--- trunk/ippTools/share/disttool_processedcomponent.sql	(revision 23785)
+++ trunk/ippTools/share/disttool_processedcomponent.sql	(revision 23842)
@@ -1,2 +1,14 @@
-SELECT *
-FROM    distComponent
+SELECT 
+    dist_id,
+    target_id,
+    stage,
+    stage_id,
+    component,
+    CONCAT_WS('.', outroot, CONVERT(dist_id, CHAR)) as outdir,
+    bytes,
+    md5sum,
+    name,
+    distComponent.state,
+    distComponent.fault
+FROM    distRun
+JOIN distComponent USING(dist_id)
Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 23785)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 23842)
@@ -1250,5 +1250,4 @@
     dbname      VARCHAR(64),
     dbhost      VARCHAR(64),
-    prod_root   VARCHAR(255),
     PRIMARY KEY(prod_id)
 )  ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -1281,10 +1280,13 @@
     dist_id     BIGINT,
     prod_id     BIGINT,
-    name        VARCHAR(64),
+    name        VARCHAR(255),
     state       VARCHAR(64),
     registered  TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
-    PRIMARY KEY(fs_id),
+    fault       SMALLINT DEFAULT 0,
+    PRIMARY KEY(dist_id, prod_id),
+    KEY(fs_id),
     FOREIGN KEY(dist_id) REFERENCES distRun(dist_id),
     FOREIGN KEY(prod_id) REFERENCES rcDSProduct(prod_id)
+--    KEY(dist_id, prod_id)
 )  ENGINE=innodb DEFAULT CHARSET=latin1;