sha1sum TEXT NOT NULL,
sha256sum TEXT NOT NULL )""")
+ c.execute("""CREATE TABLE changes_pending_files_map (
+ file_id INT4 NOT NULL REFERENCES changes_pending_files (id),
+ change_id INT4 NOT NULL REFERENCES known_changes (id),
+
+ PRIMARY KEY (file_id, change_id))""")
+
c.execute("""CREATE TABLE changes_pending_source (
id SERIAL PRIMARY KEY,
change_id INT4 NOT NULL REFERENCES known_changes (id),
print "Getting rid of old queue table"
c.execute("""DROP TABLE queue""")
+ print "Moving known_changes table"
+ c.execute("""ALTER TABLE known_changes RENAME TO changes""")
+
print "Sorting out permissions"
for t in ['build_queue', 'policy_queue', 'build_queue_files',