Mercurial > gemma
comparison schema/gemma.sql @ 831:fa417ff1f355
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. |