remove path from primary key

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

diff --git a/pithos/backends/lib/sqlalchemy/policy.py b/pithos/backends/lib/sqlalchemy/policy.py
index cfab422..5513f4c 100644 (file)
--- a/pithos/backends/lib/sqlalchemy/policy.py
+++ b/pithos/backends/lib/sqlalchemy/policy.py
@@ -44,8 +44,8 @@ class Policy(DBWorker):
         DBWorker.__init__(self, **params)
         metadata = MetaData()
         columns=[]
-        columns.append(Column('path', String(2048), primary_key=True))
-        columns.append(Column('key', String(255), primary_key=True))
+        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)
         metadata.create_all(self.engine)