specify mysql engine = innodb while creating tables & allow 0s in AUTO_INCREMENT...

[pithos] / pithos / backends / lib / sqlalchemy / policy.py

diff --git a/pithos/backends/lib/sqlalchemy/policy.py b/pithos/backends/lib/sqlalchemy/policy.py
index 5513f4c..a7833a0 100644 (file)
--- a/pithos/backends/lib/sqlalchemy/policy.py
+++ b/pithos/backends/lib/sqlalchemy/policy.py
@@ -47,7 +47,7 @@ class Policy(DBWorker):
         columns.append(Column('path', String(2048), index=True))
         columns.append(Column('key', String(255)))
         columns.append(Column('value', String(255)))
-        self.policies = Table('policy', metadata, *columns)
+        self.policies = Table('policy', metadata, *columns, mysql_engine='InnoDB')
         metadata.create_all(self.engine)
     
     def policy_set(self, path, policy):