c.execute("""
CREATE TABLE metadata_keys (
key_id SERIAL NOT NULL UNIQUE,
- key TEXT NOT NULL UNIQUE
+ key TEXT NOT NULL UNIQUE,
+
+ PRIMARY KEY (key_id)
)
""")
bin_id INT4 NOT NULL REFERENCES binaries(id) ON DELETE CASCADE,
key_id INT4 NOT NULL REFERENCES metadata_keys(key_id),
value TEXT NOT NULL,
- UNIQUE (bin_id, key_id)
+
+ PRIMARY KEY (bin_id, key_id)
)
""")
src_id INT4 NOT NULL REFERENCES source(id) ON DELETE CASCADE,
key_id INT4 NOT NULL REFERENCES metadata_keys(key_id),
value TEXT NOT NULL,
- UNIQUE (src_id, key_id)
+
+ PRIMARY KEY (src_id, key_id)
)
""")
c.execute("UPDATE config SET value = '46' WHERE name = 'db_revision'")
self.db.commit()
- except psycopg2.ProgrammingError, msg:
+ except psycopg2.ProgrammingError as msg:
self.db.rollback()
- raise DBUpdateError, 'Unable to apply update 46, rollback issued. Error message : %s' % (str(msg))
+ raise DBUpdateError('Unable to apply update 46, rollback issued. Error message : %s' % (str(msg)))