# HG changeset patch
# User dfraser
# Date 1237225578 0
# Node ID c022478bc111bfe0c5d1af8ae4c4762b400f6fa2
# Parent  a89925df9d8837d9a7508ad69753d37bc0d70a00
Replace `CREATE TEMP TABLE` with the more database-independent `CREATE TEMP TABLE` (thanks Manfred) - Fixes #370

diff --git a/bitten/upgrades.py b/bitten/upgrades.py
--- a/bitten/upgrades.py
+++ b/bitten/upgrades.py
@@ -37,7 +37,7 @@
         build_log.messages = [(BuildLog.INFO, msg) for msg in log.splitlines()]
         build_log.insert(db)
 
-    cursor.execute("CREATE TEMP TABLE old_step AS SELECT * FROM bitten_step")
+    cursor.execute("CREATE TEMPORARY TABLE old_step AS SELECT * FROM bitten_step")
     cursor.execute("DROP TABLE bitten_step")
     for table in BuildStep._schema:
         for stmt in connector.to_sql(table):
@@ -52,7 +52,7 @@
     from bitten.model import BuildConfig
     cursor = db.cursor()
 
-    cursor.execute("CREATE TEMP TABLE old_config AS "
+    cursor.execute("CREATE TEMPORARY TABLE old_config AS "
                    "SELECT * FROM bitten_config")
     cursor.execute("DROP TABLE bitten_config")
 
@@ -116,7 +116,7 @@
     from bitten.model import BuildLog
     cursor = db.cursor()
 
-    cursor.execute("CREATE TEMP TABLE old_log AS "
+    cursor.execute("CREATE TEMPORARY TABLE old_log AS "
                    "SELECT * FROM bitten_log")
     cursor.execute("DROP TABLE bitten_log")
 
@@ -288,7 +288,7 @@
     from bitten.model import BuildLog
     cursor = db.cursor()
 
-    cursor.execute("CREATE TEMP TABLE old_log AS "
+    cursor.execute("CREATE TEMPORARY TABLE old_log AS "
                    "SELECT * FROM bitten_log")
     cursor.execute("DROP TABLE bitten_log")