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

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

diff --git a/pithos/backends/lib/sqlalchemy/groups.py b/pithos/backends/lib/sqlalchemy/groups.py
index f10f7d9..cff3bb6 100644 (file)
--- a/pithos/backends/lib/sqlalchemy/groups.py
+++ b/pithos/backends/lib/sqlalchemy/groups.py
@@ -47,7 +47,7 @@ class Groups(DBWorker):
         columns.append(Column('owner', String(255), primary_key=True))
         columns.append(Column('name', String(255), primary_key=True))
         columns.append(Column('member', String(255), primary_key=True))
-        self.groups = Table('groups', metadata, *columns)
+        self.groups = Table('groups', metadata, *columns, mysql_engine='InnoDB')
         
         # place an index on member
         Index('idx_groups_member', self.groups.c.member)