PageRenderTime 11ms CodeModel.GetById 8ms app.highlight 2ms RepoModel.GetById 0ms app.codeStats 0ms

/database/layers_prod_updates/023_enable_layers_010911.sql

http://alageospatialportal.googlecode.com/
SQL | 39 lines | 39 code | 0 blank | 0 comment | 0 complexity | 9166ba96742664df1cad9497cd986fd5 MD5 | raw file
 1\set ON_ERROR_STOP 1
 2begin;
 3update layers
 4set enabled = TRUE
 5where name in ('add_nrm',
 6'DEM_d8-9s',
 7'DEM_dem-9s',
 8'dolo_acid',
 9'dolo_phys',
10'fci',
11'gypsum',
12'lime',
13'lv',
14'ofi',
15'osfci',
16'ph',
17'popn_dens06',
18'ror',
19'seifa',
20'sla_dwell06',
21'sla_edu_deg',
22'sla_edu_voc',
23'sla_empaffm',
24'sla_inc_high',
25'sla_inc_low',
26'sla_internet',
27'sla_median_a',
28'sla_older_wa',
29'sla_popch',
30'sla_popdens',
31'sla_prime_wa',
32'sla_unemp',
33'slope',
34'Substrate_magnetics',
35'threatnd_com',
36'totk',
37'totn',
38'totp');
39commit;