changeset 457:62ffb6c8a42e

Remove unnecessary schema qualifiers
author Tom Gottfried <tom@intevation.de>
date Wed, 22 Aug 2018 12:37:34 +0200
parents a8e217119085
children 01deefb7ec7a
files schema/gemma.sql
diffstat 1 files changed, 3 insertions(+), 3 deletions(-) [+]
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,