CREATE TABLE src_format (
id SERIAL PRIMARY KEY,
format_name TEXT NOT NULL,
- unique (format_name)
+ UNIQUE (format_name)
)
""")
c.execute("INSERT INTO src_format (format_name) VALUES('1.0')")
c.execute("""
CREATE TABLE suite_src_formats (
- suite INT4 NOT NULL,
- src_format INT4 NOT NULL,
- unique (suite, src_format)
+ suite INT4 NOT NULL REFERENCES suite(id),
+ src_format INT4 NOT NULL REFERENCES src_format(id),
+ PRIMARY KEY (suite, src_format)
)
""")
c.execute("UPDATE config SET value = '15' WHERE name = 'db_revision'")
self.db.commit()
- except psycopg2.ProgrammingError, msg:
+ except psycopg2.ProgrammingError as msg:
self.db.rollback()
- raise DBUpdateError, "Unable to apply source format update 15, rollback issued. Error message : %s" % (str(msg))
+ raise DBUpdateError("Unable to apply source format update 15, rollback issued. Error message : %s" % (str(msg)))