Index: trunk/ippToPsps/jython/scratchdb.py
===================================================================
--- trunk/ippToPsps/jython/scratchdb.py	(revision 38823)
+++ trunk/ippToPsps/jython/scratchdb.py	(revision 38837)
@@ -475,9 +475,6 @@
         # drop and create Images table
         self.logger.infoPair("Creating DVO table", dvoImagesTable)
-        sql = "DROP TABLE " + dvoImagesTable
-
-        try: self.execute(sql)
-        except: pass
-        
+        self.dropTable(dvoImagesTable)
+
         sql = "CREATE TABLE " + dvoImagesTable + " ( \
                SOURCE_ID SMALLINT, \
@@ -495,9 +492,5 @@
         # now detection table
         self.logger.infoPair("Dropping DVO table", dvoDetectionTable)
-        sql = "DROP TABLE " + dvoDetectionTable + " IF EXISTS"
-        try: self.execute(sql)
-        except: 
-            self.logger.errorPair("problem dropping DVO table", dvoDetectionTable)
-            pass
+        self.dropTable(dvoDetectionTable)
 
         self.logger.infoPair("Creating DVO table", "dvoDetection")
@@ -514,4 +507,5 @@
                decErr FLOAT, \
                zp FLOAT, \
+               zpFactor FLOAT, \
                telluricExt FLOAT, \
                airmass FLOAT, \
@@ -554,9 +548,5 @@
 
                tableName = self.getDbFriendlyTableName(region + "." + fileType) 
-               sql = "DROP TABLE " + tableName
-               try: self.execute(sql)
-               except:
-                    self.logger.errorPair("Unable to drop table", tableName)
-                    pass
+               self.dropTable(tableName)
 
         # deletedDetectionCount = detectionCount - self.getRowCount(self.dvoDetectionTable)
@@ -583,16 +573,10 @@
 
        sql = "set @@max_heap_table_size = " + str(tableSize)
-       try: self.execute(sql)
-       except: 
-           self.logger.errorPair("Unable to set max MEMORY table size for ", self.dvoDetectionTable)
-           return False
+       self.execute(sql)
 
        # create detections table
        self.logger.infoPair("Creating table", self.dvoDetectionTable)
        sql = "CREATE TABLE " + self.dvoDetectionTable + " LIKE dvoDetection"
-       try: self.execute(sql)
-       except:
-           self.logger.errorPair("Unable to create table", self.dvoDetectionTable)
-           return False
+       self.execute(sql)
 
        # XXX changing the dvoDetectionFull table to MEMORY
@@ -660,5 +644,5 @@
 
         sql = "SELECT \
-               INDEX_, \
+               REGION_ID, \
                R_MIN+ (R_MAX - R_MIN)/2.0, \
                D_MIN + (D_MAX - D_MIN)/2.0, \
@@ -689,5 +673,5 @@
 
         region = ""
-        sql = "SELECT NAME FROM " + self.dvoSkyTable + " WHERE INDEX_ = " + str(index)
+        sql = "SELECT NAME FROM " + self.dvoSkyTable + " WHERE REGION_ID = " + str(index)
         try:
             rs = self.executeQuery(sql)