Mercurial > gemma

comparison schema/gemma.sql @ 831:fa417ff1f355

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Extended schema to save feature style information.
author Sascha Wilde <wilde@intevation.de>
date Thu, 27 Sep 2018 23:59:36 +0200
parents d32516051d08
children f0b6852c14d1 69394644bc73
comparison
equal deleted inserted replaced
830:56fa02c93766 831:fa417ff1f355
173 ) 173 )
174 ; 174 ;
175 ALTER TABLE internal.user_profiles ADD 175 ALTER TABLE internal.user_profiles ADD
176 country char(2) NOT NULL REFERENCES users.responsibility_areas; 176 country char(2) NOT NULL REFERENCES users.responsibility_areas;
177 177
178
179 -- Namespace for system wide configuration
180 CREATE SCHEMA systemconf
181 CREATE TABLE feature_colours (
182 feature_name varchar,
183 style_attr varchar,
184 r int NOT NULL CHECK (r >= 0 AND r < 256),
185 g int NOT NULL CHECK (g >= 0 AND g < 256),
186 b int NOT NULL CHECK (b >= 0 AND b < 256),
187 a numeric NOT NULL CHECK (a >= 0 AND a <= 1),
188 PRIMARY KEY (feature_name, style_attr)
189 )
190 ;
178 191
179 -- Namespace for waterway data that can change in a running system 192 -- Namespace for waterway data that can change in a running system
180 CREATE SCHEMA waterway 193 CREATE SCHEMA waterway
181 194
182 -- Eventually obsolete. 195 -- Eventually obsolete.