Index: trunk/ippToPsps/jython/diffbatch.py
===================================================================
--- trunk/ippToPsps/jython/diffbatch.py	(revision 38397)
+++ trunk/ippToPsps/jython/diffbatch.py	(revision 38602)
@@ -163,13 +163,13 @@
       
        # make some generic tables
-           sql = "CREATE TABLE DiffMeta_"+str(num)+" like DiffMeta"
-           try: self.scratchDb.execute(sql)
-           except: raise
-           sql = "CREATE TABLE DiffToImage_"+str(num)+" like DiffToImage"
-           try: self.scratchDb.execute(sql)
-           except: raise
-           sql = "CREATE TABLE DiffDetection_"+str(num)+" like DiffDetection"
-           try: self.scratchDb.execute(sql)
-           except: raise
+           #sql = "CREATE TABLE DiffMeta_"+str(num)+" like DiffMeta"
+           #try: self.scratchDb.execute(sql)
+           #except: raise
+           #sql = "CREATE TABLE DiffToImage_"+str(num)+" like DiffToImage"
+           #try: self.scratchDb.execute(sql)
+           #except: raise
+           #sql = "CREATE TABLE DiffDetection_"+str(num)+" like DiffDetection"
+           #try: self.scratchDb.execute(sql)
+           #except: raise
 
 
@@ -199,4 +199,8 @@
         diffSkyFileID = self.number[num]
         self.logger.infoPair("Proccesing table", "DiffMeta_"+str(num))
+
+        sql = "CREATE TABLE DiffMeta_"+str(num)+" like DiffMeta"
+        try: self.scratchDb.execute(sql)
+        except: raise
 
         sqlLine = sqlUtility("INSERT INTO DiffMeta_"+str(num)+" (")
@@ -246,4 +250,7 @@
         ippTableName =  "SkyChip_psf_"+str(num)
         diffSkyFileID = self.number[num]
+        sql = "CREATE TABLE DiffDetection_"+str(num)+" like DiffDetection"
+        try: self.scratchDb.execute(sql)
+        except: raise
         #results['ORIGINALTOTAL'] = self.scratchDb.getRowCount(ippTableName)
 
@@ -405,4 +412,10 @@
         self.logger.infoPair("Procesing table", "DiffToImage")
 
+        sql = "CREATE TABLE DiffToImage_"+str(num)+" like DiffToImage"
+        try: self.scratchDb.execute(sql)
+        except: raise
+        #sql = "CREATE TABLE DiffDetection_"+str(num)+" like DiffDetection"
+        #try: self.scratchDb.execute(sql)
+        #except: raise
         imageIDs = self.gpc1Db.getImageIDsForThisDiffID(int(diffSkyFileID))
 
@@ -481,5 +494,5 @@
                a.airmass      = b.airmass, \
                a.expTime      = b.expTime, \
-               a.infoFlag2    = (b.flags << 13) | a.infoFlag2 \
+               a.infoFlag3    = b.flags  \
                WHERE a.ippDetectID = b.ippDetectID \
                AND b.imageID = " + str(imageID)