Index: trunk/ippToPsps/jython/scratchdb.py
===================================================================
--- trunk/ippToPsps/jython/scratchdb.py	(revision 31841)
+++ trunk/ippToPsps/jython/scratchdb.py	(revision 31950)
@@ -23,5 +23,5 @@
 
         if useFull:
-            self.dvoMeta = "dvoMetaNew"
+            self.dvoMeta = "dvoMetaFull"
             self.dvoDetection = "dvoDetectionFull"
         else:
@@ -55,9 +55,9 @@
     Gets DVO image flags
     '''
-    def getDvoImageFlags(self, sourceID, externID):
+    def getDvoImageFlags(self, sourceID, imageID):
 
         flags = 0
 
-        sql = "SELECT flags FROM " + self.dvoMeta + " WHERE sourceID = %s AND externID = %s" % (sourceID, externID)
+        sql = "SELECT flags FROM " + self.dvoMeta + " WHERE sourceID = %s AND imageID = %s" % (sourceID, imageID)
         try:
             rs = self.executeQuery(sql)  
@@ -69,28 +69,11 @@
 
     '''
-    Gets imageID from extern ID
-    '''
-    def getImageIDFromExternID(self, sourceID, externID):
-
-        imageID = -1
-
-        sql = "SELECT imageID FROM " + self.dvoMeta + " WHERE sourceID = %s AND externID = %s" % (sourceID, externID)
-        try:
-            rs = self.executeQuery(sql)  
-            rs.first()
-            imageID = rs.getInt(1)
-        except:
-            self.logger.exception("Unable to get imageID from dvo meta table using " + sql)
-
-        return imageID
-
-    '''
     Gets photcode (aka photoCalID from dvo table)
     '''
-    def getPhotoCalID(self, sourceID, externID):
+    def getPhotoCalID(self, sourceID, imageID):
 
         photcode = -1
 
-        sql = "SELECT photcode FROM " + self.dvoMeta + " WHERE sourceID = %s AND externID = %s" % (sourceID, externID)
+        sql = "SELECT photcode FROM " + self.dvoMeta + " WHERE sourceID = %s AND imageID = %s" % (sourceID, imageID)
         try:
             rs = self.executeQuery(sql)  
@@ -117,9 +100,7 @@
         sql = "INSERT INTO dvoMeta ( \
                sourceID, \
-               imageID, \
-               externID \
+               imageID \
                ) VALUES (\
                " + str(sourceID) + ", \
-               " + str(imageID) + " ,   \
                " + str(imageID) + "    \
                )"
@@ -171,5 +152,4 @@
                sourceID INT, \
                imageID INT, \
-               externID INT, \
                flags INT, \
                photcode INT, \