Mercurial > gemma

comparison schema/gemma.sql @ 457:62ffb6c8a42e

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Remove unnecessary schema qualifiers
author Tom Gottfried <tom@intevation.de>
date Wed, 22 Aug 2018 12:37:34 +0200
parents a74b8c2a4e75
children 3af7ca761f6a
comparison
equal deleted inserted replaced
456:a8e217119085 457:62ffb6c8a42e
49 ; 49 ;
50 50
51 51
52 -- Namespace to be accessed by sys_admin only 52 -- Namespace to be accessed by sys_admin only
53 CREATE SCHEMA sys_admin 53 CREATE SCHEMA sys_admin
54 CREATE TABLE sys_admin.system_config ( 54 CREATE TABLE system_config (
55 config_key varchar PRIMARY KEY, 55 config_key varchar PRIMARY KEY,
56 config_val varchar 56 config_val varchar
57 ) 57 )
58 58
59 CREATE TABLE sys_admin.external_services ( 59 CREATE TABLE external_services (
60 local_name varchar PRIMARY KEY, 60 local_name varchar PRIMARY KEY,
61 remote_url varchar NOT NULL, 61 remote_url varchar NOT NULL,
62 is_wfs boolean NOT NULL DEFAULT TRUE 62 is_wfs boolean NOT NULL DEFAULT TRUE
63 ) 63 )
64 64
65 CREATE TABLE sys_admin.published_services ( 65 CREATE TABLE published_services (
66 name varchar PRIMARY KEY, 66 name varchar PRIMARY KEY,
67 style bytea, 67 style bytea,
68 as_wms boolean NOT NULL DEFAULT TRUE, 68 as_wms boolean NOT NULL DEFAULT TRUE,
69 as_wfs boolean NOT NULL DEFAULT TRUE 69 as_wfs boolean NOT NULL DEFAULT TRUE
70 ) 70 )