Changeset 28731

Timestamp:

Jul 28, 2010, 12:23:09 PM (16 years ago)

Author:

bills

Message:

merge from trunk add sql for disttool -pendingcomponent -stage chip_bg and -stage warp_bg
add keys to data_state

Location:

tags/ipp-20100701/ippTools/share

Files:

• . (modified) (1 prop)
• Makefile.am (modified) (2 diffs)
• chiptool_revertprocessedimfile.sql (modified) (1 prop)
• disttool_pending_chip_bg.sql (copied) (copied from trunk/ippTools/share/disttool_pending_chip_bg.sql )
• disttool_pending_warp_bg.sql (copied) (copied from trunk/ippTools/share/disttool_pending_warp_bg.sql )
• pxadmin_create_tables.sql (modified) (3 diffs)

tags/ipp-20100701/ippTools/share/Makefile.am

@@ -159 +159 @@
         disttool_pending_camera.sql \
         disttool_pending_chip.sql \
+        disttool_pending_chip_bg.sql \
         disttool_pending_diff.sql \
         disttool_pending_fake.sql \
@@ -164 +165 @@
         disttool_pending_stack.sql \
         disttool_pending_warp.sql \
+        disttool_pending_warp_bg.sql \
         disttool_pending_SSdiff.sql \
         disttool_pendingfileset.sql \

tags/ipp-20100701/ippTools/share/pxadmin_create_tables.sql

@@ -375 +375 @@
     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 +974 @@
     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 +1184 @@
         KEY(fault),
         KEY(quality),
+        KEY(data_state),
         FOREIGN KEY(diff_id) REFERENCES diffRun(diff_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;