# GNUmed database system bootstrapping config file
#-------------------------------------------------
# license: GPL
# author: Karsten Hilbert@gmx.net

#----------------------------------
[revision control]
file = $Source: /sources/gnumed/gnumed/gnumed/server/bootstrap/update_db-v6_v7.conf,v $
version = $Revision: 1.13 $

#----------------------------------
[installation]
interactive = yes

keep temp files = no

description = $description$
This will update an existing GNUmed version 6
database to the version 7 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$
v6-v7-static
v6-v7-dynamic
$bundles$

#----------------------------------
[bundle v6-v7-static]
database alias = gnumed_v7
minimum postgresql version = 8.1
schema base directory = ../sql/v6-v7/static/
schema = $schema$
ref-form_tables.sql
$schema$

#----------------------------------
[bundle v6-v7-dynamic]
database alias = gnumed_v7
minimum postgresql version = 8.1
schema base directory = ../sql/v6-v7/dynamic/
schema = $schema$
cfg-cfg_str_array.sql
cfg-cfg_string.sql
cfg-report_query.sql
ref-form_tables.sql
clin-allergy.sql
clin-v_pat_allergies.sql
blobs-v_doc_med.sql
blobs-v_doc_desc.sql
blobs-v_obj4doc_no_data.sql
blobs-v_reviewed_doc_objects.sql
blobs-v_latest_mugshot.sql
clin-v_narrative4search.sql
clin-v_emr_journal.sql
clin-form_instances.sql
dem-v_provider_inbox.sql
dem-dob_is_in_range.sql
i18n-translations.sql
$schema$

#----------------------------------
[database gnumed_v7]
name = gnumed_v7
override name by = GM_CORE_DB
drop target database = 1
target version = v7
transfer users = 1
template database = gnumed_v6
template version = v6
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/v6-v7/
schema = $schema$
$schema$

superuser schema = $superuser schema$
$superuser schema$

upgrade plausibility checks = $upgrade plausibility checks$
identities::::select count(1) from dem.identity
select count(1) from dem.identity
names::::select count(1) from dem.names
select count(1) from dem.names
addresses::::select count(1) from dem.address
select count(1) from dem.address
episodes::::select count(1) from clin.episode
select count(1) from clin.episode
encounters::::select count(1) from clin.encounter
select count(1) from clin.encounter
issues::::select count(1) from clin.health_issue
select count(1) from clin.health_issue
documents::::select count(1) from blobs.doc_med
select count(1) from blobs.doc_med
pages::::select count(1) from blobs.doc_obj
select count(1) from blobs.doc_obj
allergies::::select count(1) from clin.allergy
select count(1) from clin.allergy
$upgrade plausibility checks$


script base directory = ../sql/v6-v7/python/
data import scripts = $data import scripts$
import-form-templates.py
$data import scripts$

#----------------------------------
[server local host]
name = 
port = 5432
template database = template1
super user alias = postgres
schema base directory = ../sql/v6-v7/
schema = $schema$
$schema$

#----------------------------------
[user GNUmed owner]
name = gm-dbo
password = 

[user postgres]
name = postgres

#----------------------------------
# these really shouldn't be changed
#----------------------------------
[GnuMed defaults]

database owner alias = GNUmed owner

groups = $groups$
$groups$

#----------------------------------
# $Log: update_db-v6_v7.conf,v $
# Revision 1.13  2007/11/09 14:43:20  ncq
# - disable auditing
#
# Revision 1.12  2007/11/07 22:56:27  ncq
# - set notification disable = 1
#
# Revision 1.11  2007/09/24 18:39:06  ncq
# - work on v7
#
# Revision 1.10  2007/09/18 22:54:23  ncq
# - add first data import script
#
# Revision 1.9  2007/09/16 22:43:22  ncq
# - add file
#
# Revision 1.8  2007/09/10 12:38:34  ncq
# - include dem.dob_is_in_range.sql
#
# Revision 1.7  2007/08/29 14:44:19  ncq
# - add cfg_report_query.sql
#
# Revision 1.6  2007/08/12 00:15:53  ncq
# - include cfg.cfg_string.sql
#
# Revision 1.5  2007/07/18 14:43:28  ncq
# - include forms handling stuff
#
# Revision 1.4  2007/07/10 20:25:14  ncq
# - add script
#
# Revision 1.3  2007/06/12 13:22:12  ncq
# - include new translations
#
# Revision 1.2  2007/06/11 19:54:01  ncq
# - include more dropped views
#
# Revision 1.1  2007/06/11 18:42:29  ncq
# - new
#
# Revision 1.7  2007/05/07 16:45:31  ncq
# - add target version v6
#
# Revision 1.6  2007/05/07 16:31:40  ncq
# - cleanup, include papersizes, new db main func in gm.
#
# Revision 1.5  2007/04/21 19:40:20  ncq
# - add mods on blobs.doc_obj
#
# Revision 1.4  2007/04/20 08:24:39  ncq
# - delete temp files
# - require 8.1
#
# Revision 1.3  2007/04/07 22:48:20  ncq
# - factor out dynamic/static stuff
#
# Revision 1.2  2007/04/06 23:19:10  ncq
# - include data mining table
#
# Revision 1.1  2007/04/02 14:15:53  ncq
# - added
#
# Revision 1.11  2007/03/27 17:37:57  ncq
# - add Release 0.2.5 workplace, backported from branch
#