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
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
|
# GNUmed database system bootstrapping config file
#-------------------------------------------------
# license: GPL v2 or later
# author: Karsten Hilbert@gmx.net
#----------------------------------
[revision control]
file = $Source: /home/ncq/Projekte/cvs2git/vcs-mirror/gnumed/gnumed/server/bootstrap/update_db-v4_v5.conf,v $
version = $Revision: 1.15 $
#----------------------------------
[installation]
interactive = yes
keep temp files = no
description = $description$
This will update an existing GNUmed version 4
database to the version 5 schema. It does not do
any harm to the data contained within.
The existing database is cloned first. The copy is
then modified. The original database remains unchanged.
$description$
bundles = $bundles$
v4-v5-static
v4-v5-dynamic
$bundles$
#----------------------------------
[bundle v4-v5-static]
database alias = gnumed_v5
minimum postgresql version = 7.4
schema base directory = ../sql/v4-v5/static/
schema = $schema$
cfg-drop_old_tables.sql
cfg-cfg_item.sql
cfg-cfg_str_array.sql
blobs-doc_obj.sql
clin-allergy.sql
$schema$
#----------------------------------
[bundle v4-v5-dynamic]
database alias = gnumed_v5
minimum postgresql version = 7.4
schema base directory = ../sql/v4-v5/dynamic/
schema = $schema$
blobs-v_obj4doc_no_data.sql
blobs-v_latest_mugshot.sql
blobs-v_reviewed_doc_objects.sql
dem-v_provider_inbox.sql
dem-enum_ext_id_types.sql
dem-idx_identity_dob_ymd.sql
clin-encounter.sql
clin-v_most_recent_encounters.sql
clin-f_protect_clin_root_item.sql
clin-v_narrative4search.sql
clin-allergy.sql
$schema$
#----------------------------------
[database gnumed_v5]
name = gnumed_v5
override name by = GM_CORE_DB
drop target database = 1
target version = v5
template database = gnumed_v4
template version = v4
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/v4-v5/
schema = $schema$
$schema$
superuser schema = $superuser schema$
superuser/transfer_users.sql
$superuser schema$
#----------------------------------
[server local host]
name =
port = 5432
template database = template1
super user alias = postgres
schema base directory = ../sql/v4-v5/
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$
#----------------------------------
# $Log: update_db-v4_v5.conf,v $
# Revision 1.15 2009-05-04 11:47:32 ncq
# - add commented out password option as a hint for Windows
#
# Revision 1.14 2007/11/09 14:43:20 ncq
# - disable auditing
#
# Revision 1.13 2007/11/07 22:56:27 ncq
# - set notification disable = 1
#
# Revision 1.12 2007/04/20 08:31:16 ncq
# - delete temp files
#
# Revision 1.11 2007/03/27 17:37:57 ncq
# - add Release 0.2.5 workplace, backported from branch
#
# Revision 1.10 2007/03/26 16:47:37 ncq
# - static script needs to be in static section
#
# Revision 1.9 2007/03/26 16:10:30 ncq
# - set target version to v5
#
# Revision 1.8 2007/03/18 14:15:40 ncq
# - add clin-allergy.sql
#
# Revision 1.7 2007/03/08 15:11:09 ncq
# - added filename to blobs object view
#
# Revision 1.6 2007/02/18 12:21:28 ncq
# - drop target database if it exists
#
# Revision 1.5 2007/02/10 23:49:45 ncq
# - add more dynamic scripts
#
# Revision 1.4 2007/02/09 15:01:44 ncq
# - include Syan's clin.v_most_recent_encounters speedup
#
# Revision 1.3 2007/02/05 16:10:40 ncq
# - add dynamic scripts
#
# Revision 1.2 2007/01/29 12:04:17 ncq
# - add blobs-doc_obj.sql
#
# Revision 1.1 2007/01/24 10:54:36 ncq
# - work started on v5 server
#
#
|
