# HG changeset patch # User Tom Gottfried # Date 1534934254 -7200 # Node ID 62ffb6c8a42e69811c84ea5b63ed22e85c1c3856 # Parent a8e217119085664ebb08690a49ac41df999dcc84 Remove unnecessary schema qualifiers diff -r a8e217119085 -r 62ffb6c8a42e schema/gemma.sql --- a/schema/gemma.sql Wed Aug 22 13:14:13 2018 +0200 +++ b/schema/gemma.sql Wed Aug 22 12:37:34 2018 +0200 @@ -51,18 +51,18 @@ -- Namespace to be accessed by sys_admin only CREATE SCHEMA sys_admin - CREATE TABLE sys_admin.system_config ( + CREATE TABLE system_config ( config_key varchar PRIMARY KEY, config_val varchar ) - CREATE TABLE sys_admin.external_services ( + CREATE TABLE external_services ( local_name varchar PRIMARY KEY, remote_url varchar NOT NULL, is_wfs boolean NOT NULL DEFAULT TRUE ) - CREATE TABLE sys_admin.published_services ( + CREATE TABLE published_services ( name varchar PRIMARY KEY, style bytea, as_wms boolean NOT NULL DEFAULT TRUE,