/var/lib/gnumed/server/sql/gmProviderInbox-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 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 | -- =============================================
-- GNUmed - static tables for the provider inbox
-- =============================================
-- $Source: /home/ncq/Projekte/cvs2git/vcs-mirror/gnumed/gnumed/server/sql/gmProviderInbox-static.sql,v $
-- $Id: gmProviderInbox-static.sql,v 1.3 2006-01-22 18:13:37 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 dem.inbox_item_category (
pk serial primary key,
description text
unique
not null
check (trim(coalesce(description, 'xxxDEFAULTxxx')) != ''),
is_user boolean
not null
default true
) inherits (audit.audit_fields);
select audit.add_table_for_audit('dem', 'inbox_item_category');
-- ---------------------------------------------
create table dem.inbox_item_type (
pk serial primary key,
fk_inbox_item_category integer
not null
references dem.inbox_item_category(pk),
description text
unique
not null
check (trim(coalesce(description, 'xxxDEFAULTxxx')) != ''),
is_user boolean
not null
default true
) inherits (audit.audit_fields);
select audit.add_table_for_audit('dem', 'inbox_item_type');
-- ---------------------------------------------
create table dem.provider_inbox (
pk serial primary key,
fk_staff integer
not null
references dem.staff(pk),
fk_inbox_item_type integer
not null
references dem.inbox_item_type(pk),
comment text
default null
check (trim(coalesce(comment, 'xxxDEFAULTxxx')) != ''),
ufk_context integer,
data text,
importance smallint
default 0
check (importance=-1 or importance=0 or importance=1),
unique(fk_staff, fk_inbox_item_type, ufk_context)
) inherits (audit.audit_fields);
select audit.add_table_for_audit('dem', 'provider_inbox');
-- =============================================
-- do simple schema revision tracking
select log_script_insertion('$RCSfile: gmProviderInbox-static.sql,v $2', '$Revision: 1.3 $');
-- =============================================
-- $Log: gmProviderInbox-static.sql,v $
-- Revision 1.3 2006-01-22 18:13:37 ncq
-- - add "data" column to provider inbox and add to view
-- - improve comments
-- - default importance to 0
--
-- Revision 1.2 2006/01/09 13:44:02 ncq
-- - add inbox item type category and adjust view
--
-- Revision 1.1 2006/01/07 15:22:23 ncq
-- - initial attempt at provider inbox tables
--
|