Mercurial > gemma
diff schema/gemma.sql @ 457:62ffb6c8a42e
Remove unnecessary schema qualifiers
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 22 Aug 2018 12:37:34 +0200 |
parents | a74b8c2a4e75 |
children | 3af7ca761f6a |
line wrap: on
line diff
--- 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,