X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fdakdb%2Fupdate17.py;h=beca9425020e6b3df6004eccdf6dea1299a54541;hb=3b50b545815298b77b8eb68930acb6fde01ea4d4;hp=b5bbb3cce22bd805cdfc92a39bc1a55caf7438c9;hpb=ebbc5a6d36f10612e6b5c2d112b5081fbc8e0831;p=dak.git diff --git a/dak/dakdb/update17.py b/dak/dakdb/update17.py old mode 100644 new mode 100755 index b5bbb3cc..beca9425 --- a/dak/dakdb/update17.py +++ b/dak/dakdb/update17.py @@ -44,7 +44,7 @@ def do_update(self): file text, binary_id integer, UNIQUE(file,binary_id))""" ) - + c.execute("""ALTER TABLE ONLY bin_contents ADD CONSTRAINT bin_contents_bin_fkey FOREIGN KEY (binary_id) REFERENCES binaries(id) @@ -54,6 +54,7 @@ def do_update(self): c.execute("GRANT ALL ON bin_contents TO ftpmaster;") c.execute("GRANT SELECT ON bin_contents TO public;") + c.execute("UPDATE config SET value = '17' WHERE name = 'db_revision'") self.db.commit()