diff roundup/backends/back_mysql.py @ 3585:438adf66eb1a

escape all uses of "schema" in mysql backend [SF#1397569]
author Richard Jones <richard@users.sourceforge.net>
date Fri, 03 Mar 2006 01:02:26 +0000
parents 7be25d75c3d5
children f7399e2aa610
line wrap: on
line diff
--- a/roundup/backends/back_mysql.py	Fri Mar 03 01:00:41 2006 +0000
+++ b/roundup/backends/back_mysql.py	Fri Mar 03 01:02:26 2006 +0000
@@ -1,4 +1,4 @@
-#$Id: back_mysql.py,v 1.66 2006-01-30 00:36:26 richard Exp $
+#$Id: back_mysql.py,v 1.67 2006-03-03 01:02:26 richard Exp $
 #
 # Copyright (c) 2003 Martynas Sklyzmantas, Andrey Lebedev <andrey@micro.lt>
 #
@@ -166,7 +166,7 @@
             if message[0] != ER.NO_SUCH_TABLE:
                 raise DatabaseError, message
             self.init_dbschema()
-            self.sql("CREATE TABLE schema (schema TEXT) TYPE=%s"%
+            self.sql("CREATE TABLE `schema` (`schema` TEXT) TYPE=%s"%
                 self.mysql_backend)
             self.sql('''CREATE TABLE ids (name VARCHAR(255),
                 num INTEGER) TYPE=%s'''%self.mysql_backend)

Roundup Issue Tracker: http://roundup-tracker.org/