PageRenderTime 18ms CodeModel.GetById 10ms app.highlight 4ms RepoModel.GetById 1ms app.codeStats 0ms

/database/layers_prod_updates/008_ger_display_name_update_30062011.sql

http://alageospatialportal.googlecode.com/
SQL | 8 lines | 5 code | 3 blank | 0 comment | 0 complexity | f0d104e62c2f384b6ae69eca23cb5d3d MD5 | raw file
1\set ON_ERROR_STOP 1
2begin;
3
4update layers set displayname = description where name in ('ger_slopes_to_summit','ger_kosciuszko_to_coast','ger_k2c_management_regions_oct2009','ger_s2s_priority_area_billabong_creek_v01','ger_s2s_priority_areas_v05');
5
6update layers set displayname = 'Great Eastern Ranges Initiative Boundary', description = 'Great Eastern Ranges Initiative Boundary' where name = 'ger_geri_boundary_v102_australia';
7
8commit;