/var/lib/gnumed/server/sql/gmUnmatchedData-static.sql is in gnumed-server 16.17-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
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 | -- =============================================
-- GNUmed - static tables for unmatched incoming data
-- =============================================
-- $Source: /home/ncq/Projekte/cvs2git/vcs-mirror/gnumed/gnumed/server/sql/gmUnmatchedData-static.sql,v $
-- $Id: gmUnmatchedData-static.sql,v 1.5 2006-01-06 10:12:02 ncq Exp $
-- license: GPL v2 or later
-- author: Karsten.Hilbert@gmx.net
-- =============================================
-- force terminate + exit(3) on errors if non-interactive
\set ON_ERROR_STOP 1
-- ---------------------------------------------
create table clin.incoming_data_unmatched (
pk serial primary key,
fk_patient_candidates integer[],
request_id text,
firstnames text,
lastnames text,
dob date,
postcode text,
other_info text,
type text,
data bytea
not null
) inherits (audit.audit_fields);
select audit.add_table_for_audit('clin', 'incoming_data_unmatched');
-- =============================================
select log_script_insertion('$RCSfile: gmUnmatchedData-static.sql,v $4', '$Revision: 1.5 $');
-- =============================================
-- $Log: gmUnmatchedData-static.sql,v $
-- Revision 1.5 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.4 2006/01/05 16:04:37 ncq
-- - move auditing to its own schema "audit"
--
-- Revision 1.3 2005/11/27 13:00:59 ncq
-- - since schema "clin" exists now we better use it
--
-- Revision 1.2 2005/11/01 08:53:50 ncq
-- - factor out re-runnables
--
-- Revision 1.1 2005/10/30 21:57:51 ncq
-- - incoming data tables: unmatched/unmatchable
--
--
|