Mercurial > gemma
comparison schema/updates/1303/01.add_key_column.sql @ 4673:443867b548b5
Fix identifiers in layers generated from SQL views
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Tue, 15 Oct 2019 15:59:38 +0200 |
parents | |
children |
comparison
equal
deleted
inserted
replaced
4672:c7dc1a6da93d | 4673:443867b548b5 |
---|---|
1 ALTER TABLE sys_admin.published_services ADD key_column varchar; | |
2 | |
3 UPDATE sys_admin.published_services SET key_column = 'isrs_code' | |
4 WHERE schema = 'waterway' AND name = 'gauges_geoserver'; | |
5 UPDATE sys_admin.published_services SET key_column = 'id' | |
6 WHERE schema = 'waterway' | |
7 AND name IN( | |
8 'sections_geoserver', | |
9 'stretches_geoserver', | |
10 'distance_marks_ashore_geoserver', | |
11 'bottlenecks_geoserver'); | |
12 UPDATE sys_admin.published_services SET key_column = 'location' | |
13 WHERE schema = 'waterway' AND name = 'distance_marks_geoserver'; | |
14 | |
15 DROP TABLE waterway.gt_pk_metadata |