Index: trunk/ippToPsps/jython/mysql.py
===================================================================
--- trunk/ippToPsps/jython/mysql.py	(revision 31400)
+++ trunk/ippToPsps/jython/mysql.py	(revision 31401)
@@ -65,4 +65,16 @@
         except: return
 
+    '''
+    Alters a column to be unique
+    '''
+    def makeColumnUnique(self, table, column):
+
+        self.logger.debug("Making '"+column+"' unique on table '"+table+"'")
+
+        sql = "ALTER TABLE " + table + " ADD UNIQUE (" + column + ")"
+        try:
+            self.stmt.execute(sql)
+        except: pass
+            #self.logger.warn("Index already in place on '" + column + "' for table '" + table + "'")
     '''
     Adds an index to the supplied table and column
@@ -97,5 +109,4 @@
 
       sql = "UPDATE " + tableName + " SET " + column + " = " + sub + " WHERE " + column + " IS NULL"
-      print sql
       self.stmt.execute(sql)
 
