Merge remote-tracking branch 'jcristau/cs-set-log-suite'

[dak.git] / dak / dakdb / update79.py

diff --git a/dak/dakdb/update79.py b/dak/dakdb/update79.py
old mode 100644 (file)
new mode 100755 (executable)
index 954f393..81a7b23
--- a/dak/dakdb/update79.py
+++ b/dak/dakdb/update79.py
@@ -38,6 +38,7 @@ def do_update(self):
         c = self.db.cursor()
 
         c.execute("CREATE SCHEMA world");
+        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")
@@ -62,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))