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
|
-- project: GNUMed
-- database GIS - Canadian geographic information as per Jim Busser:
-- CA CANADA
-- List source: Canadian General Standards Board
-- (CGSB), 1997-03-18; IGN 1989;
-- Canadian Postal Guide;
-- E-mail on Nunavut from Standards Council of Canada (SCC), 1999-09-02;
-- update 2001; update 2002
-- Code source: Canadian Postal Guide
-- ===================================================================
-- $Source: /home/ncq/Projekte/cvs2git/vcs-mirror/gnumed/gnumed/server/sql/country.specific/ca/gmDemographics-Data.ca.sql,v $
-- $Id: gmDemographics-Data.ca.sql,v 1.5 2006-01-09 13:46:19 ncq Exp $
-- author: Karsten Hilbert
-- license: GPL v2 or later
-- ===================================================================
-- force terminate + exit(3) on errors if non-interactive
\set ON_ERROR_STOP 1
set client_encoding to 'LATIN1';
-- ===================================================================
insert into dem.state (code, country, name) values ('AB', 'CA', i18n.i18n('Alberta'));
insert into dem.state (code, country, name) values ('BC', 'CA', i18n.i18n('British Columbia'));
insert into dem.state (code, country, name) values ('MB', 'CA', i18n.i18n('Manitoba'));
insert into dem.state (code, country, name) values ('NB', 'CA', i18n.i18n('New Brunswick'));
insert into dem.state (code, country, name) values ('NL', 'CA', i18n.i18n('Newfoundland and Labrador'));
insert into dem.state (code, country, name) values ('NS', 'CA', i18n.i18n('Nova Scotia'));
insert into dem.state (code, country, name) values ('ON', 'CA', i18n.i18n('Ontario'));
insert into dem.state (code, country, name) values ('PE', 'CA', i18n.i18n('Prince Edward Island'));
insert into dem.state (code, country, name) values ('QC', 'CA', i18n.i18n('Quebec'));
insert into dem.state (code, country, name) values ('SK', 'CA', i18n.i18n('Saskatchewan'));
insert into dem.state (code, country, name) values ('NT', 'CA', i18n.i18n('Northwest Territories'));
insert into dem.state (code, country, name) values ('NU', 'CA', i18n.i18n('Nunavut'));
insert into dem.state (code, country, name) values ('YT', 'CA', i18n.i18n('Yukon Territory'));
select i18n.upd_tx('fr_CA', 'British Columbia', 'Colombie-Britannique');
select i18n.upd_tx('fr_CA', 'New Brunswick', 'Nouveau-Brunswick');
select i18n.upd_tx('fr_CA', 'Newfoundland and Labrador', 'Terre-Neuve-et-Labrador');
select i18n.upd_tx('fr_CA', 'Nova Scotia', 'Nouvelle-cosse');
select i18n.upd_tx('fr_CA', 'Prince Edward Island', 'le-du-Prince-douard');
select i18n.upd_tx('fr_CA', 'Quebec', 'Qubec');
select i18n.upd_tx('fr_CA', 'Northwest Territories', 'Territoires du Nord-Ouest');
select i18n.upd_tx('fr_CA', 'Yukon Territory', 'Territoire du Yukon');
select dem.gm_upd_default_states();
-- ===================================================================
-- do simple revision tracking
delete from gm_schema_revision where filename = '$RCSfile: gmDemographics-Data.ca.sql,v $';
INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmDemographics-Data.ca.sql,v $', '$Revision: 1.5 $');
-- ===================================================================
-- $Log: gmDemographics-Data.ca.sql,v $
-- Revision 1.5 2006-01-09 13:46:19 ncq
-- - adjust to schema "i18n" qualification
--
-- Revision 1.4 2006/01/06 10:12:02 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.3 2005/09/19 16:25:41 ncq
-- - update default states
--
-- Revision 1.2 2005/07/14 21:31:43 ncq
-- - partially use improved schema revision tracking
--
-- Revision 1.1 2005/06/07 21:58:58 ncq
-- - Canadian provinces in English and French :-)
--
|
