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")
""")
- 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))