X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fdakdb%2Fupdate79.py;h=81a7b239dcdbf8e230d69eb618a357b4fb0dbf48;hb=98d086ddda3772fb58c1bfa97478e8044596b569;hp=ca20450e6c770b313a5d59c74d15da65ce968893;hpb=e2a848e480d8aabbfef4620a571088030af1013f;p=dak.git diff --git a/dak/dakdb/update79.py b/dak/dakdb/update79.py index ca20450e..81a7b239 100755 --- a/dak/dakdb/update79.py +++ b/dak/dakdb/update79.py @@ -38,7 +38,7 @@ def do_update(self): c = self.db.cursor() c.execute("CREATE SCHEMA world"); - c.execute("GRANT USAGE ON SCHEMA workd TO PUBLIC") + c.execute("GRANT USAGE ON SCHEMA world TO PUBLIC") c.execute("ALTER DEFAULT PRIVILEGES IN SCHEMA world GRANT SELECT ON TABLES TO PUBLIC") c.execute("ALTER DEFAULT PRIVILEGES IN SCHEMA world GRANT ALL ON TABLES TO ftpmaster") c.execute("ALTER DEFAULT PRIVILEGES IN SCHEMA world GRANT SELECT ON SEQUENCES TO PUBLIC") @@ -63,9 +63,9 @@ def do_update(self): """) - c.execute("UPDATE config SET value = '78' WHERE name = 'db_revision'") + c.execute("UPDATE config SET value = '79' WHERE name = 'db_revision'") self.db.commit() except psycopg2.ProgrammingError as msg: self.db.rollback() - raise DBUpdateError('Unable to apply sick update 78, rollback issued. Error message: {0}'.format(msg)) + raise DBUpdateError('Unable to apply sick update 79, rollback issued. Error message: {0}'.format(msg))