Index: /tags/ipp-20100701/ippTools/share/Makefile.am
===================================================================
--- /tags/ipp-20100701/ippTools/share/Makefile.am	(revision 28730)
+++ /tags/ipp-20100701/ippTools/share/Makefile.am	(revision 28731)
@@ -159,4 +159,5 @@
 	disttool_pending_camera.sql \
 	disttool_pending_chip.sql \
+	disttool_pending_chip_bg.sql \
 	disttool_pending_diff.sql \
 	disttool_pending_fake.sql \
@@ -164,4 +165,5 @@
 	disttool_pending_stack.sql \
 	disttool_pending_warp.sql \
+	disttool_pending_warp_bg.sql \
 	disttool_pending_SSdiff.sql \
 	disttool_pendingfileset.sql \
Index: /tags/ipp-20100701/ippTools/share/disttool_pending_chip_bg.sql
===================================================================
--- /tags/ipp-20100701/ippTools/share/disttool_pending_chip_bg.sql	(revision 28731)
+++ /tags/ipp-20100701/ippTools/share/disttool_pending_chip_bg.sql	(revision 28731)
@@ -0,0 +1,32 @@
+SELECT
+    distRun.dist_id,
+    distRun.label,
+    distTarget.dist_group,
+    stage,
+    stage_id,
+    chipBackgroundImfile.class_id AS component,
+    distRun.clean,
+    rawExp.camera,
+    CONCAT_WS('.', outroot, CONVERT(distRun.dist_id, CHAR)) as outdir,
+    chipBackgroundImfile.path_base,
+    chipBackgroundImfile.path_base as chip_path_base,
+    chipBackgroundRun.state,
+    chipBackgroundRun.state AS data_state,
+    0 AS quality,
+    distRun.no_magic,
+    chipBackgroundImfile.magicked
+FROM distRun
+JOIN distTarget USING(target_id, stage, clean)
+JOIN chipBackgroundRun ON chipBackgroundRun.chip_bg_id = distRun.stage_id
+JOIN chipRun using(chip_id)
+JOIN rawExp using(exp_id)
+JOIN chipBackgroundImfile ON chipBackgroundImfile.chip_bg_id = stage_id
+LEFT JOIN distComponent 
+    ON distRun.dist_id = distComponent.dist_id 
+    AND chipBackgroundImfile.class_id = distComponent.component
+WHERE
+    distRun.state = 'new'
+    AND distRun.stage = 'chip_bg'
+    AND distComponent.dist_id IS NULL
+    AND ((chipBackgroundRun.magicked > 0) OR distRun.no_magic)
+    AND (chipBackgroundRun.state = 'full')
Index: /tags/ipp-20100701/ippTools/share/disttool_pending_warp_bg.sql
===================================================================
--- /tags/ipp-20100701/ippTools/share/disttool_pending_warp_bg.sql	(revision 28731)
+++ /tags/ipp-20100701/ippTools/share/disttool_pending_warp_bg.sql	(revision 28731)
@@ -0,0 +1,35 @@
+SELECT
+    distRun.dist_id,
+    distRun.label,
+    distTarget.dist_group,
+    stage,
+    stage_id,
+    warpBackgroundSkyfile.skycell_id AS component,
+    clean,
+    rawExp.camera,
+    CONCAT_WS('.', outroot, CONVERT(distRun.dist_id, CHAR)) as outdir,
+    warpBackgroundSkyfile.path_base,
+    CAST(NULL AS CHAR(255)) as chip_path_base,
+    warpBackgroundRun.state,
+    NULL as data_state,
+    0 as quality,
+    distRun.no_magic,
+    warpBackgroundSkyfile.magicked
+FROM distRun
+JOIN distTarget USING(target_id, stage, clean)
+JOIN warpBackgroundRun ON stage_id = warp_bg_id
+JOIN warpBackgroundSkyfile using(warp_bg_id)
+JOIN warpRun using(warp_id)
+JOIN fakeRun USING(fake_id)
+JOIN camRun USING(cam_id)
+JOIN chipRun ON camRun.chip_id = chipRun.chip_id
+JOIN rawExp using(exp_id)
+LEFT JOIN distComponent 
+    ON distRun.dist_id = distComponent.dist_id 
+    AND warpBackgroundSkyfile.skycell_id = distComponent.component
+WHERE
+    distRun.state = 'new'
+    AND distRun.stage = 'warp_bg'
+    AND distComponent.dist_id IS NULL
+    AND ((warpBackgroundRun.magicked > 0) OR distRun.no_magic)
+    AND (warpBackgroundRun.state = 'full')
Index: /tags/ipp-20100701/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- /tags/ipp-20100701/ippTools/share/pxadmin_create_tables.sql	(revision 28730)
+++ /tags/ipp-20100701/ippTools/share/pxadmin_create_tables.sql	(revision 28731)
@@ -375,4 +375,5 @@
     KEY(fault),
     KEY(quality),
+    KEY(data_state),
     FOREIGN KEY(chip_id, exp_id) REFERENCES chipRun(chip_id, exp_id),
     FOREIGN KEY(exp_id, class_id) REFERENCES rawImfile(exp_id, class_id)
@@ -973,4 +974,5 @@
     KEY(fault),
     KEY(quality),
+    KEY(data_state),
     FOREIGN KEY(warp_id, skycell_id, tess_id) REFERENCES warpSkyCellMap(warp_id, skycell_id, tess_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -1182,4 +1184,5 @@
         KEY(fault),
         KEY(quality),
+        KEY(data_state),
         FOREIGN KEY(diff_id) REFERENCES diffRun(diff_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;