1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
|
-- project: GNUMed
-- database GIS - spanish counties, according to National Institute of Statistics (http://www.ine.es)
-- ===================================================================
-- $Source: /home/ncq/Projekte/cvs2git/vcs-mirror/gnumed/gnumed/server/sql/country.specific/es/gmDemographics-Data.es.sql,v $
-- $Id: gmDemographics-Data.es.sql,v 1.7 2006-01-09 13:46:19 ncq Exp $
-- author: Carlos Moro
-- license: GPL v2 or later
-- ===================================================================
-- force terminate + exit(3) on errors if non-interactive
\set ON_ERROR_STOP 1
set client_encoding to 'LATIN1';
-- ===================================================================
select i18n.upd_tx('es_ES', 'Spain', 'Espaa');
-- Carlos, please reconcile:
--INSERT into dem.state(code, country, name) VALUES ('AN','ES',i18n.i18n('Andalusia'));
--INSERT into dem.state(code, country, name) VALUES ('AR','ES',i18n.i18n('Aragon'));
--INSERT into dem.state(code, country, name) VALUES ('AS','ES',i18n.i18n('Asturias'));
--INSERT into dem.state(code, country, name) VALUES ('BI','ES',i18n.i18n('Balearic Islands'));
--INSERT into dem.state(code, country, name) VALUES ('BC','ES',i18n.i18n('Basque Country'));
--INSERT into dem.state(code, country, name) VALUES ('CI','ES',i18n.i18n('Canary Islands'));
--INSERT into dem.state(code, country, name) VALUES ('CA','ES',i18n.i18n('Cantabria'));
--INSERT into dem.state(code, country, name) VALUES ('CL','ES',i18n.i18n('Castilla y Leon'));
--INSERT into dem.state(code, country, name) VALUES ('CM','ES',i18n.i18n('Castilla-La Mancha'));
--INSERT into dem.state(code, country, name) VALUES ('CT','ES',i18n.i18n('Catalonia'));
--INSERT into dem.state(code, country, name) VALUES ('EX','ES',i18n.i18n('Extremadura'));
--INSERT into dem.state(code, country, name) VALUES ('GA','ES',i18n.i18n('Galicia'));
--INSERT into dem.state(code, country, name) VALUES ('LR','ES',i18n.i18n('La Rioja'));
--INSERT into dem.state(code, country, name) VALUES ('MA','ES',i18n.i18n('Madrid'));
--INSERT into dem.state(code, country, name) VALUES ('MU','ES',i18n.i18n('Murcia'));
--INSERT into dem.state(code, country, name) VALUES ('NA','ES',i18n.i18n('Navarre'));
--INSERT into dem.state(code, country, name) VALUES ('VA','ES',i18n.i18n('Valencia'));
-- spanish geographic information (mostly of type 'state')
INSERT into dem.state(code,country,name) VALUES ('01','ES',i18n.i18n('lava'));
INSERT into dem.state(code,country,name) VALUES ('02','ES',i18n.i18n('Albacete'));
INSERT into dem.state(code,country,name) VALUES ('03','ES',i18n.i18n('Alicante'));
INSERT into dem.state(code,country,name) VALUES ('04','ES',i18n.i18n('Almera'));
INSERT into dem.state(code,country,name) VALUES ('33','ES',i18n.i18n('Asturias'));
INSERT into dem.state(code,country,name) VALUES ('05','ES',i18n.i18n('vila'));
INSERT into dem.state(code,country,name) VALUES ('06','ES',i18n.i18n('Badajoz'));
INSERT into dem.state(code,country,name) VALUES ('07','ES',i18n.i18n('Baleares'));
INSERT into dem.state(code,country,name) VALUES ('08','ES',i18n.i18n('Barcelona'));
INSERT into dem.state(code,country,name) VALUES ('09','ES',i18n.i18n('Burgos'));
INSERT into dem.state(code,country,name) VALUES ('10','ES',i18n.i18n('Cceres'));
INSERT into dem.state(code,country,name) VALUES ('11','ES',i18n.i18n('Cdiz'));
INSERT into dem.state(code,country,name) VALUES ('12','ES',i18n.i18n('Castelln'));
INSERT into dem.state(code,country,name) VALUES ('13','ES',i18n.i18n('Ciudad Real'));
INSERT into dem.state(code,country,name) VALUES ('14','ES',i18n.i18n('Crdoba'));
INSERT into dem.state(code,country,name) VALUES ('15','ES',i18n.i18n('Corua'));
INSERT into dem.state(code,country,name) VALUES ('16','ES',i18n.i18n('Cuenca'));
INSERT into dem.state(code,country,name) VALUES ('17','ES',i18n.i18n('Gerona'));
INSERT into dem.state(code,country,name) VALUES ('18','ES',i18n.i18n('Granada'));
INSERT into dem.state(code,country,name) VALUES ('19','ES',i18n.i18n('Guadalajara'));
INSERT into dem.state(code,country,name) VALUES ('20','ES',i18n.i18n('Guipzcoa'));
INSERT into dem.state(code,country,name) VALUES ('21','ES',i18n.i18n('Huelva'));
INSERT into dem.state(code,country,name) VALUES ('22','ES',i18n.i18n('Huesca'));
INSERT into dem.state(code,country,name) VALUES ('23','ES',i18n.i18n('Jan'));
INSERT into dem.state(code,country,name) VALUES ('24','ES',i18n.i18n('Len'));
INSERT into dem.state(code,country,name) VALUES ('25','ES',i18n.i18n('Lrida'));
INSERT into dem.state(code,country,name) VALUES ('27','ES',i18n.i18n('Lugo'));
INSERT into dem.state(code,country,name) VALUES ('28','ES',i18n.i18n('Madrid'));
INSERT into dem.state(code,country,name) VALUES ('29','ES',i18n.i18n('Mlaga'));
INSERT into dem.state(code,country,name) VALUES ('30','ES',i18n.i18n('Murcia'));
INSERT into dem.state(code,country,name) VALUES ('31','ES',i18n.i18n('Navarra'));
INSERT into dem.state(code,country,name) VALUES ('32','ES',i18n.i18n('Orense'));
INSERT into dem.state(code,country,name) VALUES ('34','ES',i18n.i18n('Palencia'));
INSERT into dem.state(code,country,name) VALUES ('35','ES',i18n.i18n('Palmas (Las)'));
INSERT into dem.state(code,country,name) VALUES ('36','ES',i18n.i18n('Pontevedra'));
INSERT into dem.state(code,country,name) VALUES ('26','ES',i18n.i18n('Rioja (La)'));
INSERT into dem.state(code,country,name) VALUES ('37','ES',i18n.i18n('Salamanca'));
INSERT into dem.state(code,country,name) VALUES ('38','ES',i18n.i18n('Santa Cruz de Tenerife'));
INSERT into dem.state(code,country,name) VALUES ('40','ES',i18n.i18n('Segovia'));
INSERT into dem.state(code,country,name) VALUES ('41','ES',i18n.i18n('Sevilla'));
INSERT into dem.state(code,country,name) VALUES ('42','ES',i18n.i18n('Soria'));
INSERT into dem.state(code,country,name) VALUES ('43','ES',i18n.i18n('Tarragona'));
INSERT into dem.state(code,country,name) VALUES ('44','ES',i18n.i18n('Teruel'));
INSERT into dem.state(code,country,name) VALUES ('45','ES',i18n.i18n('Toledo'));
INSERT into dem.state(code,country,name) VALUES ('46','ES',i18n.i18n('Valencia'));
INSERT into dem.state(code,country,name) VALUES ('47','ES',i18n.i18n('Valladolid'));
INSERT into dem.state(code,country,name) VALUES ('48','ES',i18n.i18n('Vizcaya'));
INSERT into dem.state(code,country,name) VALUES ('49','ES',i18n.i18n('Zamora'));
INSERT into dem.state(code,country,name) VALUES ('50','ES',i18n.i18n('Zaragoza'));
select dem.gm_upd_default_states();
-- ===================================================================
-- do simple revision tracking
delete from gm_schema_revision where filename = '$RCSfile: gmDemographics-Data.es.sql,v $';
INSERT INTO gm_schema_revision (filename, version) VALUES ('$RCSfile: gmDemographics-Data.es.sql,v $', '$Revision: 1.7 $');
-- ===================================================================
-- $Log: gmDemographics-Data.es.sql,v $
-- Revision 1.7 2006-01-09 13:46:19 ncq
-- - adjust to schema "i18n" qualification
--
-- Revision 1.6 2006/01/06 10:12:03 ncq
-- - add missing grants
-- - add_table_for_audit() now in "audit" schema
-- - demographics now in "dem" schema
-- - add view v_inds4vaccine
-- - move staff_role from clinical into demographics
-- - put add_coded_term() into "clin" schema
-- - put German things into "de_de" schema
--
-- Revision 1.5 2005/09/25 17:52:45 ncq
-- - carlos needs to take a look, his data and the data from Jim's file
-- are different
--
-- Revision 1.4 2005/09/19 16:27:05 ncq
-- - update default states
--
-- Revision 1.3 2005/07/14 21:31:43 ncq
-- - partially use improved schema revision tracking
--
-- Revision 1.2 2005/06/10 07:22:53 ncq
-- - translate Spain into Spanish
--
-- Revision 1.1 2005/05/15 12:03:51 ncq
-- - Spanish counties/states
--
|
