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
|
# GNUmed database system bootstrapping config file
#-------------------------------------------------
# license: GPL v2 or later
# author: Karsten Hilbert@gmx.net
#----------------------------------
[installation]
interactive = yes
keep temp files = no
description = $description$
This will update an existing GNUmed database.
It does so by applying all fixup SQL scripts
appropriate to the version of the database.
$description$
bundles = $bundles$
v18-fixups
$bundles$
#----------------------------------
[bundle v18-fixups]
database alias = gnumed_v18
minimum postgresql version = 8.4
schema base directory = ../sql/v17-v18/fixups/
schema = $schema$
v18-role-permissions-fixup.sql
v18-cfg-depreciated_placeholders-fixup.sql
v18-cfg-report_query-fixup.sql
v18-dem-v_message_inbox-fixup.sql
v18-clin-encounter-fixup.sql
v18-clin-soapU_check-fixup.sql
v18-clin-keyword_expansion-data-fixup.sql
v18-clin-results_review_change-fixup.sql
v18-ref-Epworth_Sleepiness_Scale_1997-fixup.sql
v18-ref-bacterial_conjunctivitis_score-fixup.sql
v18-ref-Bird_PMR_1979-fixup.sql
v18-ref-DEGAM_HWI_2012-fixup.sql
v18-ref-MELD_score-fixup.sql
v18-ref-recalls_template-fixup.sql
v18-i18n-french_translations.sql
v18-bill-bill_item-fixup.sql
v18-ref-paperwork_templates-fixup.sql
$schema$
#----------------------------------
[database gnumed_v18]
name = gnumed_v18
override name by = GM_CORE_DB
drop target database = 0
use existing target database = 1
target version = v18
transfer users = 0
template database = template1
server alias = local host
notification disable = 1
audit disable = 1
audit trail parent table = audit.audit_trail
audit trail table prefix = log_
audit fields table = audit.audit_fields
schema base directory = ../sql/v17-v18/
schema = $schema$
$schema$
superuser schema = $superuser schema$
$superuser schema$
upgrade plausibility checks = $upgrade plausibility checks$
$upgrade plausibility checks$
script base directory = ../sql/v17-v18/python/
data import scripts = $data import scripts$
v18-import-form-templates.py
$data import scripts$
#----------------------------------
[server local host]
name =
port = 5432
template database = template1
super user alias = postgres
schema base directory = ../sql/v17-v18/
schema = $schema$
$schema$
#----------------------------------
[user GNUmed owner]
name = gm-dbo
password =
[user postgres]
name = postgres
#password =
#----------------------------------
# these really shouldn't be changed
#----------------------------------
[GnuMed defaults]
database owner alias = GNUmed owner
groups = $groups$
$groups$
#----------------------------------
|
