Index: trunk/ippToPsps/jython/scratchdb.py
===================================================================
--- trunk/ippToPsps/jython/scratchdb.py	(revision 38854)
+++ trunk/ippToPsps/jython/scratchdb.py	(revision 38879)
@@ -222,4 +222,19 @@
 
     '''
+    Updates a table with the recalibration stats grabbed from dvoImages table
+    '''
+    def updateRecalStats(self, table, externID, pltScale):
+
+        sql = "UPDATE "+table+" AS a,"+self.dvoImagesTable+" AS b \
+               SET \
+               a.recalAstroScatX = b.XPIX_SYS_ERR *"+pltScale+", \
+               a.recalAstroScatY = b.YPIX_SYS_ERR *"+pltScale+", \
+               a.recalNAstroStars = b.N_FIT_ASTROM, \
+               a.recalPhotoScat  = b.MAG_SYS_ERR, \
+               a.recalNPhotoStars = b.N_FIT_PHOTOM \
+               WHERE b.EXTERN_ID = "+externID
+        self.execute(sql)
+
+    '''
     Inserts a new sourceID/imageID combo into dvoImages
     '''
@@ -483,4 +498,9 @@
                FLAGS INT, \
                PHOTCODE SMALLINT, \
+               XPIX_SYS_ERR FLOAT, \
+               YPIX_SYS_ERR FLOAT, \
+               N_FIT_ASTROM INT, \
+               MAG_SYS_ERR FLOAT, \
+               N_FIT_PHOTOM INT, \
                PRIMARY KEY (IMAGE_ID, EXTERN_ID) \
                )"