/var/lib/gnumed/server/sql/gmConfig-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 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 | --=====================================================================
-- GNUmed distributed database configuration tables
-- $Source: /home/ncq/Projekte/cvs2git/vcs-mirror/gnumed/gnumed/server/sql/gmConfig-static.sql,v $
-- $Revision: 1.2 $
-- structure of configuration database for GNUmed
-- neccessary to allow for distributed servers
-- Copyright by Dr. Horst Herb
-- This is free software in the sense of the General Public License (GPL v2 or later)
-- For details regarding GPL v2 or later licensing see http://gnu.org
-- ===================================================================
-- force terminate + exit(3) on errors if non-interactive
\set ON_ERROR_STOP 1
--=====================================================================
create schema cfg authorization "gm-dbo";
comment on schema cfg is
'This schema holds all the configuration data.';
--=====================================================================
CREATE TABLE cfg.db (
id SERIAL PRIMARY KEY,
name CHAR(35),
port INT DEFAULT 5432,
host text DEFAULT 'localhost',
opt text DEFAULT '',
tty text DEFAULT ''
);
--=====================================================================
CREATE TABLE cfg.distributed_db (
id SERIAL PRIMARY KEY,
name char(35)
);
--=====================================================
CREATE TABLE cfg.config (
id SERIAL PRIMARY KEY,
profile CHAR(25) DEFAULT 'default',
username CHAR(25) DEFAULT CURRENT_USER,
ddb INT REFERENCES cfg.distributed_db(id)
DEFAULT NULL,
db INT REFERENCES cfg.db(id),
crypt_pwd text DEFAULT NULL,
crypt_algo text DEFAULT NULL,
pwd_hash text DEFAULT NULL,
hash_algo text DEFAULT NULL
);
-- ======================================================
create table cfg.db_logon_banner (
message text
check (trim(message) != ''),
singularizer boolean
unique
default true
check (singularizer is true)
);
-- ======================================================
-- generic program options storage space
-- ======================================================
create table cfg.cfg_type_enum (
name text
unique
not null
);
-- ======================================================
create table cfg.cfg_template (
pk serial primary key,
name text
NOT NULL
DEFAULT 'must set this !',
type text
not null
references cfg.cfg_type_enum(name),
cfg_group text
not null
default 'xxxDEFAULTxxx',
description text
not null
default 'programmer is an avid Camel Book Reader'
);
-- ======================================================
create table cfg.cfg_item (
pk SERIAL PRIMARY KEY,
fk_template integer
not null
references cfg.cfg_template(pk),
owner name
not null
default CURRENT_USER,
workplace text
not null
default 'xxxDEFAULTxxx',
cookie text
not null
default 'xxxDEFAULTxxx',
unique (fk_template, owner, workplace, cookie)
);
-- ======================================================
create table cfg.cfg_string (
fk_item integer
not null
references cfg.cfg_item(pk)
on update cascade
on delete cascade,
value text not null
);
-- ======================================================
create table cfg.cfg_numeric (
fk_item integer
not null
references cfg.cfg_item(pk)
on update cascade
on delete cascade,
value numeric not null
);
-- ======================================================
create table cfg.cfg_str_array (
fk_item integer
not null
references cfg.cfg_item(pk)
on update cascade
on delete cascade,
value text[] not null
);
-- ======================================================
create table cfg.cfg_data (
fk_item integer
not null
references cfg.cfg_item(pk)
on update cascade
on delete cascade,
value bytea
not null
);
-- =============================================
-- do simple schema revision tracking
select log_script_insertion('$RCSfile: gmConfig-static.sql,v $', '$Revision: 1.2 $');
--=====================================================================
|