Changeset 31366 for trunk/ippToPsps/jython/mysql.py

Timestamp:

Apr 25, 2011, 9:39:58 AM (15 years ago)

Author:

rhenders

Message:

now uses column as part of index name

File:

• trunk/ippToPsps/jython/mysql.py (modified) (1 diff)

trunk/ippToPsps/jython/mysql.py

@@ -72 +72 @@
         self.logger.debug("Creating index on column '"+column+"' for table '"+table+"'")
 
-        sql = "CREATE INDEX "+table+"_index ON "+table+" ("+column+")"
+        sql = "CREATE INDEX "+table+"_"+column+"_index ON "+table+" ("+column+")"
         try:
             self.stmt.execute(sql)