Mercurial > gemma

annotate schema/updates/1303/01.add_key_column.sql @ 5560:f2204f91d286

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Join the log lines of imports to the log exports to recover data from them. Used in SR export to extract information that where in the meta json but now are only found in the log.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 09 Feb 2022 18:34:40 +0100
parents 443867b548b5
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
4673
443867b548b5 Fix identifiers in layers generated from SQL views
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
1 ALTER TABLE sys_admin.published_services ADD key_column varchar;
443867b548b5 Fix identifiers in layers generated from SQL views
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
2
443867b548b5 Fix identifiers in layers generated from SQL views
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
3 UPDATE sys_admin.published_services SET key_column = 'isrs_code'
443867b548b5 Fix identifiers in layers generated from SQL views
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
4 WHERE schema = 'waterway' AND name = 'gauges_geoserver';
443867b548b5 Fix identifiers in layers generated from SQL views
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
5 UPDATE sys_admin.published_services SET key_column = 'id'
443867b548b5 Fix identifiers in layers generated from SQL views
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
6 WHERE schema = 'waterway'
443867b548b5 Fix identifiers in layers generated from SQL views
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
7 AND name IN(
443867b548b5 Fix identifiers in layers generated from SQL views
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
8 'sections_geoserver',
443867b548b5 Fix identifiers in layers generated from SQL views
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
9 'stretches_geoserver',
443867b548b5 Fix identifiers in layers generated from SQL views
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
10 'distance_marks_ashore_geoserver',
443867b548b5 Fix identifiers in layers generated from SQL views
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
11 'bottlenecks_geoserver');
443867b548b5 Fix identifiers in layers generated from SQL views
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
12 UPDATE sys_admin.published_services SET key_column = 'location'
443867b548b5 Fix identifiers in layers generated from SQL views
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
13 WHERE schema = 'waterway' AND name = 'distance_marks_geoserver';
443867b548b5 Fix identifiers in layers generated from SQL views
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
14
443867b548b5 Fix identifiers in layers generated from SQL views
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
15 DROP TABLE waterway.gt_pk_metadata