changeset 4237:c831dcad8a10

add db update skript for the sysconfig removal * Dropping the namespace `sysconfig` as cascade also removes the table, the contents and the priviledges. Is a part of 4318:27ed6f709195.
author Bernhard Reiter <bernhard@intevation.de>
date Wed, 21 Aug 2019 17:17:00 +0200
parents 27ed6f709195
children fe24cdde614d
files schema/updates/1110/01.remove_systemconf.sql schema/version.sql
diffstat 2 files changed, 2 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/updates/1110/01.remove_systemconf.sql	Wed Aug 21 17:17:00 2019 +0200
@@ -0,0 +1,1 @@
+DROP SCHEMA systemconf CASCADE;
--- a/schema/version.sql	Wed Aug 21 16:17:46 2019 +0200
+++ b/schema/version.sql	Wed Aug 21 17:17:00 2019 +0200
@@ -1,1 +1,1 @@
-INSERT INTO gemma_schema_version(version) VALUES (1107);
+INSERT INTO gemma_schema_version(version) VALUES (1110);