===========================================================
.___ __ __
_________________ __ __ __| _/|__|/ |_
/ ___\_` __ \__ \ | | \/ __ | | \\_ __\
/ /_/ > | \// __ \| | / /_/ | | || |
\___ /|__| (____ /____/\____ | |__||__|
/_____/ \/ \/
grep rough audit - static analysis tool
v2.8 written by @Wireghoul
=================================[justanotherhacker.com]===
gnumed-server-22.14/server/gm-move_backups_offsite.sh-56-# do not run concurrently
gnumed-server-22.14/server/gm-move_backups_offsite.sh:57:if test "`ps ax | grep $0 | grep -v grep | grep -v $$`" != "" ; then
gnumed-server-22.14/server/gm-move_backups_offsite.sh-58- echo "${HOST}: "`date`": transfer already in progress, exiting" >> ${LOG}
##############################################
gnumed-server-22.14/server/gm-backup_database.sh-75-# are we backing up the latest DB ?
gnumed-server-22.14/server/gm-backup_database.sh:76:OUR_VER=`echo ${GM_DATABASE} | cut -f 2 -d v`
gnumed-server-22.14/server/gm-backup_database.sh-77-if test -z ${GM_HOST} ; then
gnumed-server-22.14/server/gm-backup_database.sh:78: HAS_HIGHER_VER=`sudo -u postgres psql -A -t -d ${GM_DATABASE} -p ${GM_PORT} -c "SELECT exists (select 1 from pg_database where datname like 'gnumed_v%' and substring(datname from 9 for 3)::integer > '${OUR_VER}');"`
gnumed-server-22.14/server/gm-backup_database.sh-79-else
gnumed-server-22.14/server/gm-backup_database.sh:80: HAS_HIGHER_VER=`sudo -u postgres psql -A -t -h ${GM_HOST} -d ${GM_DATABASE} -p ${GM_PORT} -c "SELECT exists (select 1 from pg_database where datname like 'gnumed_v%' and substring(datname from 9 for 3)::integer > '${OUR_VER}');"`
gnumed-server-22.14/server/gm-backup_database.sh-81-fi;
##############################################
gnumed-server-22.14/server/gm-backup_database.sh-129- echo "" >> ${BACKUP_FILENAME}-roles.sql 2> /dev/null
gnumed-server-22.14/server/gm-backup_database.sh:130: ROLES=`psql -A -t -d ${GM_DATABASE} -p ${GM_PORT} -U ${GM_DBO} -c "select gm.get_users('${GM_DATABASE}');"`
gnumed-server-22.14/server/gm-backup_database.sh-131- echo "-- ${ROLES}" >> ${BACKUP_FILENAME}-roles.sql 2> /dev/null
##############################################
gnumed-server-22.14/server/gm-backup_database.sh-152- echo "" >> ${BACKUP_FILENAME}-roles.sql 2> /dev/null
gnumed-server-22.14/server/gm-backup_database.sh:153: ROLES=`psql -A -t -d ${GM_DATABASE} -p ${GM_PORT} -U ${GM_DBO} -c "select gm.get_users('${GM_DATABASE}');"`
gnumed-server-22.14/server/gm-backup_database.sh-154- echo "-- ${ROLES}" >> ${BACKUP_FILENAME}-roles.sql 2> /dev/null
##############################################
gnumed-server-22.14/server/gm-zip+sign_backups.sh-144-
gnumed-server-22.14/server/gm-zip+sign_backups.sh:145: #SHA512="SHA 512:"`sha512sum -b ${BACKUP_FILENAME}.tar.bz2`
gnumed-server-22.14/server/gm-zip+sign_backups.sh-146- SHA512=$(openssl dgst -sha512 -hex "${BZ2_FINAL}")
##############################################
gnumed-server-22.14/server/sql/gmReference-data.sql-88--- do simple schema revision tracking
gnumed-server-22.14/server/sql/gmReference-data.sql:89:delete from gm_schema_revision where filename='$RCSfile: gmReference-data.sql,v $';
gnumed-server-22.14/server/sql/gmReference-data.sql-90-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmReference-data.sql,v $', '$Revision: 1.4 $');
##############################################
gnumed-server-22.14/server/sql/gmoffice.sql-154--- do simple schema revision tracking
gnumed-server-22.14/server/sql/gmoffice.sql:155:delete from gm_schema_revision where filename='$RCSfile: gmoffice.sql,v $';
gnumed-server-22.14/server/sql/gmoffice.sql-156-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmoffice.sql,v $', '$Revision: 1.15 $');
##############################################
gnumed-server-22.14/server/sql/gmHousekeeping.sql-72--- do simple schema revision tracking
gnumed-server-22.14/server/sql/gmHousekeeping.sql:73:delete from gm_schema_revision where filename = '$RCSfile: gmHousekeeping.sql,v $';
gnumed-server-22.14/server/sql/gmHousekeeping.sql-74-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmHousekeeping.sql,v $', '$Revision: 1.8 $');
##############################################
gnumed-server-22.14/server/sql/v20-v21/fixups/v21-notifications-dynamic.sql-162- if _accessor_col = ''fk_encounter'' then -- retrieve identity PK via fk_encounter
gnumed-server-22.14/server/sql/v20-v21/fixups/v21-notifications-dynamic.sql:163: _identity_accessor_SQL := ''select fk_patient from clin.encounter where pk = $1.fk_encounter limit 1'';
gnumed-server-22.14/server/sql/v20-v21/fixups/v21-notifications-dynamic.sql-164- elsif _accessor_col = ''fk_identity'' then -- retrieve identity PK via fk_identity
##############################################
gnumed-server-22.14/server/sql/gmNotifications-dynamic.sql-86--- do simple schema revision tracking
gnumed-server-22.14/server/sql/gmNotifications-dynamic.sql:87:delete from gm_schema_revision where filename='$RCSfile: gmNotifications-dynamic.sql,v $';
gnumed-server-22.14/server/sql/gmNotifications-dynamic.sql-88-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmNotifications-dynamic.sql,v $', '$Revision: 1.2 $');
##############################################
gnumed-server-22.14/server/sql/v14-v15/dynamic/v15-i18n-dynamic.sql-27- -- reduce xx_XX@YY to xx
gnumed-server-22.14/server/sql/v14-v15/dynamic/v15-i18n-dynamic.sql:28: select into trans_str trans from i18n.translations where lang = regexp_replace(_lang, ''_.*$'', '''') and orig = _orig;
gnumed-server-22.14/server/sql/v14-v15/dynamic/v15-i18n-dynamic.sql-29-
##############################################
gnumed-server-22.14/server/sql/test-data/gmDemographics-Person-test_data.sql-23--- do simple schema revision tracking
gnumed-server-22.14/server/sql/test-data/gmDemographics-Person-test_data.sql:24:delete from gm_schema_revision where filename = '$RCSfile: gmDemographics-Person-test_data.sql,v $';
gnumed-server-22.14/server/sql/test-data/gmDemographics-Person-test_data.sql-25-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmDemographics-Person-test_data.sql,v $', '$Revision: 1.8 $');
##############################################
gnumed-server-22.14/server/sql/test-data/test_data-James_Kirk.sql-143- (select pk_staff from dem.v_staff where firstnames='Leonard Horatio' and lastnames='McCoy' and dob='1920-1-20+2:00'),
gnumed-server-22.14/server/sql/test-data/test_data-James_Kirk.sql:144: E'GIF89a0\\0000\\000\\325\\000\\000\\377\\377\\377\\275\\234\\234\\224sk\\275\\204s\\326\\275\\265\\224{s\\275\\214{\\245{k\\214cR\\275\\234\\214{ZJ\\255{c\\316\\255\\234\\306\\224{\\245sZ\\234kRcB1\\204R91!\\030\\347\\316\\275\\306\\255\\234cJ9\\265\\204cB)\\030Z9!\\316\\255\\224\\306\\245\\214\\265\\224{sR9\\214cBsZBB1!)\\030\\010\\336\\306\\255\\275\\245\\21491)\\234\\204k\\214sZ\\020\\010\\000B)\\010\\326\\306\\255RB)cZJ\\357\\347\\326RJ9\\214{R\\255\\234kskR\\275\\255{\\214\\204Zsskkkc))!\\234\\234{\\030\\030\\020BJ!\\255\\265\\224\\245\\275\\23419J\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000,\\000\\000\\000\\0000\\0000\\000@\\006\\377@\\204P\\241@\\274*\\220\\012\\347P\\330\\355lP\\223I2\\032\\321\\250\\254jj\\304R\\315X,\\020k&\\003#\\017$\\322\\342\\223Jz\\336#\\247\\223\\306*)"\\217\\274\\3052\\3507\\014\\033.\\013\\007\\003\\033\\006\\015\\014(\\023!\\033\\007\\007\\002)\\022P#S#[\\020\\035\\021\\034N,B\\036\\012\\017\\016\\013{\\026\\016\\204\\011\\032\\011\\006\\253\\015\\255\\255\\003{\\260\\015%)N#\\020:\\271:44\\012\\035\\020\\020\\036\\035\\241\\016}{\\216$\\002%\\241\\006\\003\\276\\010%*P;&\\012%%\\033\\025\\237\\022^2\\2744U\\022 mH\\237\\035%\\242\\204\\016\\030&\\030x\\203\\006!z}\\364\\013\\017\\006\\0364^33/\\0121\\000_\\2340\\021\\314\\003\\004\\014m<D\\030\\326\\241a\\236\\003\\011\\022lh\\364 S\\036\\207(2\\204\\010\\021\\243C\\014\\007.6\\2200\\010\\201\\003\\260\\012\\012^|\\222c\\203F\\033`)\\332\\304\\034\\361\\001\\234\\225p\\022\\244\\2008\\001\\341\\304\\205\\377._j\\355\\370`\\251\\2155Jr>\\240\\024\\226''\\035\\237\\015}\\014D\\214\\310\\252\\025\\003\\002\\011Z\\341c1IW\\225\\004\\0070|\\370 cF\\011\\004\\036.\\230\\260\\301I\\312\\011\\017\\017\\026\\310\\035\\345GC\\210\\011\\004D4s`b\\016\\027]\\272h\\330HH\\004\\201\\251\\001\\257\\0268\\260h!\\021\\001\\002\\00140H\\245A\\303+>\\013\\366\\361;\\221\\202\\204\\210\\0348^\\000\\303\\340\\246\\003\\002\\005\\0250\\014s\\264\\241\\006\\011G\\204\\014\\015h*\\012B\\245.*^\\370\\363\\320BAI\\005\\006Sp\\030\\016\\341\\302\\011\\014\\034\\254\\0118`h\\203\\304\\003\\016.\\016\\357\\350\\302E\\014\\021.\\036\\300\\200Q}\\373v\\017\\303\\337xP\\311\\246\\000\\015\\226\\022$\\200\\273\\222^RK\\3676\\372\\202\\310\\375aL\\015\\025\\025X|\\370}\\222C~\\026/\\304!\\007\\015/\\240\\325\\001(\\027u\\000\\036q\\020\\010g\\315\\003\\012p\\200\\301\\204<A\\000F\\012>]\\020SIo\\200 \\377\\307\\016t\\000\\007\\212\\003\\242\\320\\025U\\002\\031\\210PY\\006,\\242@\\300\\012+\\020\\300@\\006\\033\\0108\\230\\015\\022\\304\\304FJ}=\\201\\222Cy4\\305G!\\023\\321c\\344\\220\\260\\320\\223\\037\\015\\027x0\\202\\016U\\\\\\200\\300l\\036\\354\\220\\302n\\371i\\343\\001J%\\034`\\242s`6@O,|\\034 \\324\\016\\306\\005&\\301\\001\\277\\014\\367 \\211\\016\\024V@\\001$\\240\\245\\232(\\017`p\\302q\\301\\250p\\315 \\032\\224\\260\\003\\010\\340\\214\\001\\330MH\\004S\\204\\000\\246\\360\\261\\212\\227\\321u\\340\\200d\\013tYBC\\0159@\\202\\003\\026,\\300A\\003F\\220!\\003`^\\231QX(\\007\\224\\262XE\\017\\034`\\000\\001\\031\\314\\206X\\003\\226\\211\\271G1\\003\\214\\301\\217n>\\351\\311S\\011\\015&\\241M\\021\\010\\204"@\\001\\216<\\320\\023r\\007\\004\\260At$\\316\\265\\200\\007\\022\\330\\322\\205n\\012\\324\\200C\\0150\\274\\300BI\\022\\236D\\3040\\016\\234\\346\\301\\204\\021\\244+\\377\\351\\003\\357(\\326\\224\\010(l\\373\\302\\015\\212\\002\\027C\\013\\036\\334`\\022r\\303\\371\\252h(\\322\\035\\224n(\\366D\\360F\\007\\034i\\267]w(p\\267]C\\034\\214\\247B\\203\\244\\355\\353+r\\237@\\263\\334#\\010H\\330A\\005%\\264\\320\\202\\\\1dWLu.x\\007\\003p\\237\\020q\\304\\005J\\011\\300\\326\\023P@\\301\\213z7U\\221\\2058)\\360\\023F\\0118|Q\\201\\004\\025\\000t\\300p\\376E\\354\\017\\004/\\234\\2113Q[\\\\q\\205\\015 \\204\\023_\\217\\355\\350\\250\\302\\326*\\260p\\236\\004''%\\332r\\265N\\3300\\202\\022H\\017\\227\\350\\007b\\021%\\201\\031\\276\\036w\\3028\\020x\\221\\202Z/\\251]A\\005\\037\\2320\\302Y\\237\\320\\306\\307\\255\\017 \\320\\020\\002\\203L\\324\\214\\035\\021+@IKc\\005\\373\\206\\012\\347\\015\\310\\002\\313M\\215\\342\\250\\001\\032\\030 \\302\\347"dPY"0\\242PY\\014)T=\\216\\2061\\241\\364\\302\\007\\037\\206\\030\\301\\210\\351\\304\\026\\377\\225\\006\\024\\020@\\001\\005+\\276\\270\\002\\005\\264\\032\\020\\240\\011\\274\\200\\240!B \\237ie\\313\\303dN\\346SE\\216i\\301+\\210m`!/\\036\\230PuLmD\\000\\201-/(H\\014\\234\\242X\\340\\234DE\\036\\202\\330\\230\\364\\034P\\301y\\037(\\300K\\025\\037x\\260\\300\\307O\\2500\\204\\242/8`\\210\\005\\204\\220\\212\\010T\\341\\234Z\\211\\011\\026\\261P\\200\\207v0\\202\\013xeM\\003\\350\\211\\011\\260\\205\\032\\014\\\\\\340\\002\\301\\270\\000\\010\\342\\327\\250A\\014\\240\\031\\244\\360\\003=\\370\\342\\004\\023\\300\\314+\\037\\320\\200\\003J\\002\\001k\\220\\3504\\227\\333Z\\016T\\260\\223\\023p\\240D\\321a\\316\\371(\\200\\002\\012@\\305\\001~\\031\\201\\012\\274b\\203Nx\\257\\205\\305z\\3001\\312u\\270\\003\\330aJl\\032\\010\\326R@\\004\\017 @\\004/x[\\021\\311p(\\033h\\343 \\031#\\221\\243&\\322\\210H\\341\\252X\\016X\\206\\000\\274\\005\\002\\020\\224`\\001\\326+\\\\\\012T \\203Qy\\377e\\0046\\300\\240\\242\\240q\\030\\255@\\207U\\007\\310\\000\\003|\\230*\\350\\200DE\\253XL\\003^\\300\\217~\\220*\\027t`\\001J|\\021\\027B\\0000R\\222\\262\\300F\\022\\020\\000\\006\\204\\216E\\242\\023\\223b\\032\\240\\000:\\356\\252\\012P\\252B\\241\\366f\\016tx\\251\\024\\252\\031\\306\\000D\\307\\200\\011\\310\\322\\017\\266\\022\\205\\001*p\\203}\\370\\003\\004\\022\\200\\231\\006A\\0206m\\360\\321\\024\\216\\020\\200\\002\\2143!w\\374\\221S\\000L\\225b\\024 \\205k\\351\\346\\005\\315,\\032\\012j@1`\\230\\343p\\256L\\246a\\2343\\300\\331\\214\\257Rm\\244\\2065\\3751\\202\\032\\304K\\004%\\000\\317AX\\351\\013"X\\020\\023\\012p@3\\372\\340\\245\\304\\221\\317\\001 \\360\\233$U\\220\\222\\335\\024\\240d$\\260\\015\\277\\016\\342M\\2464\\205\\011gA\\213I\\004\\006\\260ap\\247:$\\340N\\015jP\\002I\\222\\240\\004*\\331\\320\\033$t\\001\\344\\020\\341"\\351\\232\\020\\007\\364\\320\\251\\2120\\204Du.\\260K\\006\\\\P\\202\\030d\\000\\006\\0358\\200\\013z\\003\\214#\\320\\2138z\\302\\240\\025\\273D\\010w9$:\\354\\342@C`\\260\\200\\026\\244\\254;\\013\\333N\\006\\360\\245\\250\\340\\200\\353 {JA\\3066\\306\\311\\000$@\\000\\206{\\303\\013H\\320\\201\\005\\270\\200\\004\\201P\\030T\\267\\203\\264\\361x\\340[\\037(i3\\215\\263\\223\\212)DA\\347RM\\0138p\\215\\030\\244A\\015-(\\031L\\241\\032\\004\\000;'
gnumed-server-22.14/server/sql/test-data/test_data-James_Kirk.sql-145-);
##############################################
gnumed-server-22.14/server/sql/v21-v22/dynamic/v22-clin-transfer_all_encounter_data.sql-52- EXECUTE format (
gnumed-server-22.14/server/sql/v21-v22/dynamic/v22-clin-transfer_all_encounter_data.sql:53: ''UPDATE %1$s SET %2$I = %3$L WHERE %2$I = %4$L'',
gnumed-server-22.14/server/sql/v21-v22/dynamic/v22-clin-transfer_all_encounter_data.sql-54- _fk_row.referencing_table,
##############################################
gnumed-server-22.14/server/sql/v21-v22/dynamic/v22-kwd-patient_media_export_icon.sql-11--- --------------------------------------------------------------
gnumed-server-22.14/server/sql/v21-v22/dynamic/v22-kwd-patient_media_export_icon.sql:12:delete from ref.keyword_expansion where keyword = '$$gnumed_patient_media_export_icon';
gnumed-server-22.14/server/sql/v21-v22/dynamic/v22-kwd-patient_media_export_icon.sql-13-
##############################################
gnumed-server-22.14/server/sql/v21-v22/dynamic/v22-kwd-patient_media_export_icon.sql-25--- --------------------------------------------------------------
gnumed-server-22.14/server/sql/v21-v22/dynamic/v22-kwd-patient_media_export_icon.sql:26:delete from ref.keyword_expansion where keyword = '$$gnumed_patient_media_export_icon_2';
gnumed-server-22.14/server/sql/v21-v22/dynamic/v22-kwd-patient_media_export_icon.sql-27-
##############################################
gnumed-server-22.14/server/sql/v21-v22/dynamic/v22-notifications-dynamic.sql-164- if _accessor_col = ''fk_encounter'' then -- retrieve identity PK via fk_encounter
gnumed-server-22.14/server/sql/v21-v22/dynamic/v22-notifications-dynamic.sql:165: _identity_accessor_SQL := ''select fk_patient from clin.encounter where pk = $1.fk_encounter limit 1'';
gnumed-server-22.14/server/sql/v21-v22/dynamic/v22-notifications-dynamic.sql-166- elsif _accessor_col = ''fk_identity'' then -- retrieve identity PK via fk_identity
##############################################
gnumed-server-22.14/server/sql/gmAudit.sql-64--- do simple schema revision tracking
gnumed-server-22.14/server/sql/gmAudit.sql:65:delete from gm_schema_revision where filename = '$RCSfile: gmAudit.sql,v $';
gnumed-server-22.14/server/sql/gmAudit.sql-66-insert into gm_schema_revision (filename, version) values ('$RCSfile: gmAudit.sql,v $', '$Revision: 1.15 $');
##############################################
gnumed-server-22.14/server/sql/gmOfficeData.sql-41--- do simple schema revision tracking
gnumed-server-22.14/server/sql/gmOfficeData.sql:42:delete from gm_schema_revision where filename='$RCSfile: gmOfficeData.sql,v $';
gnumed-server-22.14/server/sql/gmOfficeData.sql-43-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmOfficeData.sql,v $', '$Revision: 1.5 $');
##############################################
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-108-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'INFECTIOUS DISEASE OTHER/NOS','INFECTIOUS DISEASE OTHER/NOS','A20, A21, A22, A23, A24, A25, A26, A27, A28, A30, A31, A32, A38, A39.1, A39.2, A39.3, A39.4, A39.8, A39.9, A40, A41, A42, A43, A44, A48.0, A48.2, A48.3, A48.4, A48.8, A49, A59.8, A59.9, A64, A68, A69.2, A69.8, A69.9, A70, A74.8, A74.9, A75, A77, A78, A79, B37.7, B37.8, B37.9, B38, B39, B40, B41, B42, B43, B45, B46, B47, B48, B49, B55, B56, B57, B58.8, B58.9, B59, B60, B64, B89, B92, B94.8, B94.9, B95, B96, B99',NULL,'brucellosis, infection unspecified site, Lyme disease, mycoplasma, Q fever; rickettsial disease, scarlet fever, sexually transmitted disease NOS, thrush NOS, toxoplasmosis','meningococcal meningitis N71',NULL,NULL,1,'A78');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:109:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANCY NOS','MALIGNANCY NOS','C38.1, C38.2, C38.3, C38.8, C45.7, C45.9, C46.7, C46.8, C46.9, C76, C78, C79, C80, C97, D09.7, D09.9','histological evidence of malignancy','secondary/metastatic neoplasm when primary site is unknown, carcinomatosis (unknown primary)',NULL,'disease/condition of unspecified nature/site A99',NULL,1,'A79');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-110-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'TRAUMA/INJURY NOS','TRAUMA/INJURY NOS','S11, S15, S21, S25, S26, S27, S35, S37.9, S38.1, S38.3, S39, S45, S55, S65, S75, S85, S95, T09, T14.5, T14.7, T14.8, T14.9, T28.4, T28.9',NULL,'road traffic accident','multiple trauma A81; late effect of trauma A82',NULL,NULL,1,'A80');
##############################################
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-179-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'LYMPHADENITIS CHRONIC/NON-SPECIFIC','LYMPHADENITIS CHRONIC/NON-SPECIFIC','I88','enlarged tender lymph nodes present for more than 6 weeks; or demonstration of enlarged inflamed mesenteric lymph nodes by surgery/sonography/lymphography/otherwise','mesenteric lymphadenitis','acute lymphadenitis (except mesenteric) B70; acute lymphangitis S76','enlarged lymph node B02',NULL,1,'B71');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:180:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'HODGKIN''S DISEASE/LYMPHOMA','HODGKIN''S DISEASE/LYMPHOMA','C81, C82, C83, C84, C85','characteristic histologic appearance',NULL,NULL,'other malignant neoplasm blood/lymph B74; benign/unspecified neoplasm blood/lymph B75',NULL,1,'B72');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:181:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'LEUKAEMIA','LEUKAEMIA','C91, C92, C93, C94, C95','characteristic histologic appearance','all types of leukaemia',NULL,'benign/unspecified neoplasm blood/lymph B75',NULL,1,'B73');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:182:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'BENIGN/UNSPECIFIED NEOPLASM BLOOD','BENIGN/UNSPECIFIED NEOPLASM BLOOD','D15.0, D36.0, D45, D47',NULL,'benign neoplasm blood, neoplasm blood not specified as benign or malignant/when test is not available; polycythaemia rubra vera',NULL,NULL,NULL,1,'B75');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-183-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'RUPTURED SPLEEN TRAUMATIC','RUPTURED SPLEEN TRAUMATIC','S36.0',NULL,NULL,NULL,NULL,NULL,1,'B76');
##############################################
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-268-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'GASTROENTERITIS PRESUMED INFECTION','GASTROENTERITIS PRESUMED INFECTION','A09',NULL,'diarrhoea/vomiting presumed to be infective, dysentery NOS, food poisoning, gastric flu','irritable bowel syndrome D93; non-infective enteritis and gastroenteritis D94, D99',NULL,NULL,1,'D73');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:269:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM STOMACH','MALIGNANT NEOPLASM STOMACH','C16','characteristic histological appearance','carcinoma stomach',NULL,'other malignant digestive neoplasm (when primary site is uncertain) D77; benign/unspecified digestive neoplasm D78',NULL,1,'D74');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:270:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM COLON/RECTUM','MALIGNANT NEOPLASM COLON/RECTUM','C18, C19, C20, C21','characteristic histological appearance',NULL,NULL,'other digestive malignant neoplasm (when primary site is uncertain) D77; benign/unspecified digestive neoplasm D78',NULL,1,'D75');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:271:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM PANCREAS','MALIGNANT NEOPLASM PANCREAS','C25','characteristic histological appearance','carcinoma pancreas',NULL,'other digestive malignant neoplasm (when primary site is unknown) D77; benign/unspecified digestive neoplasm D78',NULL,1,'D76');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:272:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT DIGESTIVE NEOPLASM OTHER/NOS','MALIGNANT DIGESTIVE NEOPL OTHER/NOS','C00, C01, C02, C03, C04, C05, C06, C07, C08, C14.8, C15, C17, C22, C23, C24, C26, C45.1, C46.2, C48',NULL,'all other primary malignancies of digestive system, gallbladder cancer, liver cancer','malignancy of stomach, colon/rectum, pancreas D74-76; secondary malignancy of known site (code to site); secondary malignancy of unknown site A79','benign/unspecified digestive neoplasm D78',NULL,1,'D77');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:273:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEOPLASM DIGESTIVE SYSTEM BENIGN/UNSPECIFIED','NEOPLASM DIGESTIVE BENIGN/UNSPECIF','D00, D01, D10, D11, D12, D13, D20, D37, D48.3, D48.4, K62.0, K62.1',NULL,'benign digestive neoplasm/digestive neoplasm not specified as benign or malignant/when histology is not available, polyp of stomach, duodenum, colon, rectum',NULL,NULL,NULL,1,'D78');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-274-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'FOREIGN BODY DIGESTIVE SYSTEM','FOREIGN BODY DIGESTIVE SYSTEM','T18',NULL,'foreign body swallowed/in digestive tract, including mouth, oesophagus, rectum','foreign body in throat/inhaled R87',NULL,NULL,1,'D79');
##############################################
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-357-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'EYE INFECTION/INFLAMMATION OTHER','EYE INFECTION/INFLAMMATION OTHER','B00.5, B58.0, H03, H04.3, H04.4, H05.0, H05.1, H16.1, H16.2, H16.3, H16.4, H16.8, H16.9, H20, H21, H22, H30, H32',NULL,'dacryocystitis, herpes simplex of eye without corneal ulcer, infammation of the orbit, iritis, iridocyclitis, keratitis','measles keratitis A71; corneal ulcer (herpes) F85, trachoma F86; herpes zoster S70',NULL,NULL,1,'F73');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:358:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEOPLASM OF EYE/ADNEXA','NEOPLASM OF EYE/ADNEXA','C69, D09.2, D31, D48.7',NULL,'benign/malignant neoplasm of eye/adnexa',NULL,NULL,NULL,1,'F74');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-359-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'CONTUSION/HAEMORRHAGE EYE','CONTUSION/HAEMORRHAGE EYE','H11.3, S00.1, S05.1',NULL,'black eye, hyphaema, subconjunctival haemorrhage','corneal ulcer F85',NULL,NULL,1,'F75');
##############################################
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-506- fever, but without any other demonstrable cause','chorea, mitral stenosis',NULL,'heart valve disease K83; other heart disease K84',NULL,1,'K71');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:507:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEOPLASM CARDIOVASCULAR','NEOPLASM CARDIOVASCULAR','C38.0, C45.2, D15.1, D15.2, D48.7',NULL,'benign/malignant cardiovascular neoplasm','haemangioma S81',NULL,NULL,1,'K72');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-508-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'CONGENITAL ANOMALY CARDIOVASCULAR','CONGENITAL ANOMALY CARDIOVASCULAR','Q20, Q21, Q22, Q23, Q24, Q25, Q26, Q27, Q28',NULL,'atrial/ventricular septal defect, Fallot''s tetralogy, patent ductus arteriosa','haemangioma S81',NULL,NULL,1,'K73');
##############################################
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-597-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'INFECTIONS OF MUSCULOSKELETAL SYSTEM','INFECTIONS OF MUSCULOSKELETAL SYSTEM','M00, M01, M46.2, M46.3, M46.4, M46.5, M60.0, M65.0, M65.1, M71.0, M71.1, M86','infections localized in musculoskeletal system','infective tenosynovitis, osteomyelitis, pyogenic arthritis','Reiter''s disease L99; late effect of polio N70',NULL,NULL,1,'L70');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:598:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM MUSCULOSKELETAL','MALIGNANT NEOPLASM MUSCULOSKELETAL','C40, C41, C49','characteristic histological appearance','fibrosarcoma, osteosarcoma','secondary neoplasms (code to original site), benign/unspecified musculoskeletal neoplasm L97',NULL,NULL,1,'L71');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-599-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'FRACTURE: RADIUS/ULNA','FRACTURE: RADIUS/ULNA','S52','imaging evidence of a fracture; or trauma plus visible/palpable deformity or crepitus involving the bone','Colles'' fracture','pathological fracture L95, L99; non-union L99','arm symptoms L09; musculoskeletal injury NOS L81',NULL,1,'L72');
##############################################
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-621-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'ACUTE INTERNAL DAMAGE KNEE','ACUTE INTERNAL DAMAGE KNEE','S83.2, S83.3, S83.5, S83.7','an initial injury which occurred no longer than one month previously and demonstration of ligament/meniscus tear by surgery/arthroscopy/imaging, or by locking/giving way, pain, and swelling of knee','acute damage to meniscus/cruciate ligaments','acute damage to collateral ligaments L78; dislocation of patella L80; chronic internal damage to knee L99','knee symptom L15; sprain of knee L78',NULL,1,'L96');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:622:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEOPLASM BENIGN/UNSPECIFIED MUSCULOSKELETAL','NEOPLASM BENIGN/UNSPECIF MUSCULOSKEL','D16, D21, D48.0, D48.1',NULL,'benign musculoskeletal neoplasm, musculoskeletal neoplasm not specified as benign or malignant/when histology is not available','malignant musculoskeletal neoplasm L71',NULL,NULL,1,'L97');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-623-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'ACQUIRED DEFORMITY OF LIMB','ACQUIRED DEFORMITY OF LIMB','M20, M21',NULL,'bunion, genu valgum-varum, hallux valgus/varus, mallet finger, pes planus (flatfoot)','general congenital deformities and anomalies A90; musculoskeletal deformities and anomalies L82',NULL,NULL,1,'L98');
##############################################
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-685-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEUROLOGICAL INFECTION OTHER','NEUROLOGICAL INFECTION OTHER','A81, A88.8, A89, G06, G07, G08, G09',NULL,'cerebral abscess, slow virus infection','poliomyelitis N70; meningitis/encephalitis N71; acute polyneuritis N94',NULL,NULL,1,'N73');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:686:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM NERVOUS SYSTEM','MALIGNANT NEOPLASM NERVOUS SYSTEM','C47, C70, C71, C72','characteristic histological appearance',NULL,NULL,'unspecified neoplasm nervous system N76',NULL,1,'N74');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:687:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'BENIGN NEOPLASM NERVOUS SYSTEM','BENIGN NEOPLASM NERVOUS SYSTEM','D32, D33, D36.1',NULL,'acoustic neuroma, meningioma',NULL,NULL,NULL,1,'N75');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:688:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEOPLASM NERVOUS SYSTEM UNSPECIFIED','NEOPLASM NERVOUS SYSTEM UNSPECIFIED','D42, D43, D48.2',NULL,'neoplasm nervous system not specified as benign or malignant/when histology is not available','neurofibromatosis A90',NULL,NULL,1,'N76');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-689-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'HEAD INJURY OTHER','HEAD INJURY OTHER','S02.0, S02.1, S06.1, S06.2, S06.3, S06.4, S06.5, S06.6, S06.7, S06.8, S06.9, S07, S08, S09.0, S09.7, S09.8','trauma to the head, complicated by cerebral damage','cerebral contusion, cerebral injury with/without skull fracture, extradural haematoma, subdural haematoma, traumatic intracranial haemorrhage','concussion N79',NULL,NULL,1,'N80');
##############################################
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-862-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'RESPIRATORY INFECTION OTHER','RESPIRATORY INFECTION OTHER','A36, B37.1, B44, B58.3, J05.1, J31, J37, J85, J86',NULL,'chronic nasopharyngitis, chronic pharyngitis, chronic rhinitis NOS, diphtheria, empyema, epiglottitis, fungal respiratory infection, lung abscess, protozoal infection (without pneumonia)','cystic fibrosis T99',NULL,NULL,1,'R83');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:863:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM BRONCHUS/LUNG','MALIGNANT NEOPLASM BRONCHUS/LUNG','C33, C34','characteristic histologic appearance','malignancy of trachea/bronchus/lung','malignancy of unknown site A79; a secondary malignancy from known site to be coded to site','unspecified respiratory neoplasm R92',NULL,1,'R84');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:864:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM RESPIRATORY OTHER','MALIGNANT NEOPL RESPIRATORY OTHER','C09, C10, C11, C12, C13, C14.0, C14.2, C30.0, C31, C32, C38.4, C39, C45.0','characteristic histologic appearance','malignancy of larynx/mediastinum/nose/pharynx/pleura/sinus, mesothelioma','Hodgkin''s disease B72, malignancy of trachea/bronchus/lung R84','unspecified respiratory neoplasm R92',NULL,1,'R85');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:865:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'BENIGN NEOPLASM RESPIRATORY','BENIGN NEOPLASM RESPIRATORY','D14, D19','characteristic clinical or histologic appearance',NULL,'unspecified respiratory neoplasm R92; nasal polyp R99','unspecified respiratory neoplasm R92',NULL,1,'R86');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-866-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'FOREIGN BODY NOSE/LARYNX/BRONCHUS','FOREIGN BODY NOSE/LARYNX/BRONCHUS','T17','visualization of foreign body directly/endoscopically/using imaging','foreign body in lung','drowning A88; foreign body lodged in oesophagus D79; foreign body in ear H76; aspiration pneumonia R99','other complaint of respiratory system R29',NULL,1,'R87');
##############################################
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-870-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'moved to R79',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'R91');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:871:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEOPLASM RESPIRATORY UNSPECIFIED','NEOPLASM RESPIRATORY UNSPECIFIED','D02, D38',NULL,'respiratory neoplasm unspecified as benign or malignant/when histology is not available','secondary neoplasm unknown site A79; malignant respiratory neoplasm R84, R85; benign respiratory neoplasm R86',NULL,NULL,1,'R92');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-872-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'deleted, included with R82',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'R93');
##############################################
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-953-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'SKIN INFECTION OTHER','SKIN INFECTION OTHER','A46, A66, A67, L03.1, L03.2, L03.3, L03.8, L03.9, L08, L98.0',NULL,'cellulitis, erysipelas, pyoderma, strep skin infection','boil/carbuncle/other localized skin infection S11; impetigo S84; molluscum contagiosum S95; acne S96',NULL,NULL,1,'S76');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:954:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM OF SKIN','MALIGNANT NEOPLASM OF SKIN','C43, C44, C46.0, C46.1','characteristic histological appearance','basal cell carcinoma, malignant melanoma, rodent ulcer, squamous cell carcinoma of skin','premalignant lesion of skin S79','other malignant neoplasm (when primary site is uncertain) A79; neoplasm of skin unspecified as benign or malignant/when histology is not available S79',NULL,1,'S77');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-955-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'LIPOMA','LIPOMA','D17',NULL,NULL,NULL,NULL,NULL,1,'S78');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:956:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEOPLASM SKIN BENIGN/UNSPECIFIED','NEOPLASM SKIN BENIGN/UNSPECIFIED','D03, D04, D23, D48.5',NULL,'benign skin neoplasm/skin neoplasm not specified as benign or malignant/when histology is not available, dermoid cyst, premalignant lesion','residual haemorrhoidal skin tag K96; solar keratosis S80; haemangioma S81; mole/pigmented nevus S82; keloid, hyperkeratosis, seborrhoeic/senile warts S99',NULL,NULL,1,'S79');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-957-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'SOLAR KERATOSIS/SUNBURN','SOLAR KERATOSIS/SUNBURN','L55, L56, L57, L58, L59',NULL,'photosensitivity, radiation skin damage, senile keratosis, solar hyperkeratosis, polymorphous light eruption','skin damage due to man made radiation A87, A88',NULL,NULL,1,'S80');
##############################################
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1030-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'ENDOCRINE INFECTION','ENDOCRINE INFECTION','E06.0',NULL,NULL,'thyroiditis T99',NULL,NULL,1,'T70');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1031:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM THYROID','MALIGNANT NEOPLASM THYROID','C73','characteristic histological appearance',NULL,NULL,'other/unspecified endocrine neoplasm T73; goitre T81',NULL,1,'T71');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1032:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'BENIGN NEOPLASM THYROID','BENIGN NEOPLASM THYROID','D34',NULL,NULL,'other/unspecified endocrine neoplasm T73; goitre T81',NULL,NULL,1,'T72');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1033:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEOPLASM ENDOCRINE OTHER/UNSPECIFIED','NEOPLASM ENDOCRINE OTHER/UNSPECIFIED','C74, C75, D09.3, D35, D44',NULL,'other endocrine neoplasm/endocrine neoplasm not specified as benign or malignant/when histology is not available',NULL,NULL,NULL,1,'T73');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1034-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'THYROGLOSSAL DUCT/CYST','THYROGLOSSAL DUCT/CYST','Q89.2',NULL,NULL,'goitre T81',NULL,NULL,1,'T78');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1035-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'CONGENITAL ANOMALY ENDOCRINE/METABOLIC','CONGEN ANOMALY ENDOCRINE/METABOLIC','E00, Q89.1, Q89.2',NULL,'cretinism, dwarfism','thyroglossal duct (cyst) T78',NULL,NULL,1,'T80');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1036:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'GOITRE','GOITRE','E04',NULL,'non-toxic goitre, thyroid nodule','neoplasm of thyroid gland T71-T73; thyroglossal cyst T78; toxic goitre T85; hypothyroidism T86',NULL,NULL,1,'T81');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1037-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'OBESITY','OBESITY','E66','a body mass index greater than 30',NULL,'overweight T83',NULL,NULL,1,'T82');
##############################################
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1106-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'URETHRITIS','URETHRITIS','A56.2, B37.4, N34','urethral discharge with frequency, burning, pain or urgency on urination without bacteriuria by microscopy or culture; or inflammation of external urinary meatus','chlamydial urethritis, nonspecific urethritis, urethral syndrome, meatitis','gonococcal urethritis female X71; urethritis trichomonal, female X73; gonococcal urethritis male Y71','painful urination U01; frequent/urgent urination U02; irritable bladder U13; urethral discharge X29, Y03',NULL,1,'U72');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1107:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM OF KIDNEY','MALIGNANT NEOPLASM OF KIDNEY','C64, C65','characteristic histologic appearance',NULL,NULL,'neoplasm urinary tract NOS U79',NULL,1,'U75');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1108:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM OF BLADDER','MALIGNANT NEOPLASM OF BLADDER','C67','characteristic histologic appearance',NULL,NULL,'neoplasm urinary tract NOS U79',NULL,1,'U76');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1109:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM URINARY OTHER','MALIGNANT NEOPLASM URINARY OTHER','C66, C68','characteristic histologic appearance','malignant neoplasm ureter, malignant neoplasm urethra','malignant neoplasm prostate Y77','neoplasm urinary tract NOS U79',NULL,1,'U77');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1110:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEOPLASM URINARY TRACT NOS','NEOPLASM URINARY TRACT NOS','D09.0, D09.1, D41',NULL,'bladder/kidney/ureter/urethra neoplasm NOS','histologically proven urinary tract neoplasms U75, U76, U77, U78',NULL,NULL,1,'U79');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1111-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'INJURY URINARY TRACT','INJURY URINARY TRACT','S37.0, S37.1, S37.2, S37.3, T19.0, T19.1, T28.3, T28.8',NULL,'contusion kidney, foreign body in urinary tract',NULL,NULL,NULL,1,'U80');
##############################################
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1177-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'INFECTION COMPLICATING PREGNANCY','INFECTION COMPLICATING PREGNANCY','O23, O41.1, O75.2, O75.3, O86.2, O86.4, O86.8, O98',NULL,NULL,'puerperal infection W70; puerperal mastitis W94',NULL,NULL,1,'W71');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1178:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM RELATED TO PREGNANCY','MALIGNANT NEOPL RELATED TO PREGNANCY','C58',NULL,'chorioepithelioma, choriocarcinoma',NULL,NULL,NULL,1,'W72');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1179:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'BENIGN/UNSPECIFIED NEOPLASM RELATED TO PREGNANCY','BENIGN/UNSPECIF NEOPL RELAT TO PREGN','O01',NULL,'hydatidiform mole',NULL,NULL,NULL,1,'W73');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1180-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'INJURY COMPLICATING PREGNANCY','INJURY COMPLICATING PREGNANCY','T14.9',NULL,'results of injury interfering with pregnancy','new injury caused by childbirth W92, W93',NULL,NULL,1,'W75');
##############################################
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1271-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'PELVIC INFLAMMATORY DISEASE','PELVIC INFLAMMATORY DISEASE','N70, N71, N73, N74','lower abdominal pain with marked tenderness of uterus or adnexa by palpation, plus other evidence of inflammation','endometritis, oophoritis, salpingitis','sexually transmitted diseases female X70-X73; chlamydia infection female X92','pelvic congestion syndrome X99',NULL,1,'X74');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1272:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM CERVIX','MALIGNANT NEOPLASM CERVIX','C53, D06','characteristic histological appearance','carcinoma-in-situ cervix, cervical intraepithelial neoplasia (CIN) grade 3','abnormal cervix smear (CIN) grades 1 and 2 X86',NULL,NULL,1,'X75');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1273:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM BREAST FEMALE','MALIGNANT NEOPLASM BREAST FEMALE','C50','characteristic histological appearance','carcinoma-in-situ female breast, intraductal carcinoma',NULL,'breast lump X19',NULL,1,'X76');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1274:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM GENITAL FEMALE OTHER','MALIGNANT NEOPL GENITAL FEMALE OTHER','C51, C52, C54, C55, C56, C57','characteristic histological appearance','malignancy of adnexae, ovaries, uterus, vagina, vulva','carcinoma-in-situ cervix X75; other female genital carcinoma-in-situ X81','other/unspecified female genital neoplasm X81',NULL,1,'X77');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1275-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'FIBROMYOMA UTERUS','FIBROMYOMA UTERUS','D25','enlargement of the uterus not due to pregnancy or malignancy, with single or multiple firm tumours of the uterus','fibroid uterus, fibromyoma of cervix, myoma',NULL,NULL,NULL,1,'X78');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1276:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'BENIGN NEOPLASM FEMALE GENITAL','BENIGN NEOPLASM FEMALE GENITAL','D26, D27, D28',NULL,NULL,'polyp of cervix X85; physiological cyst of ovary X99',NULL,NULL,1,'X80');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1277:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'GENITAL NEOPLASM FEMALE OTHER/UNSPECIFIED','GENITAL NEOPL FEMALE OTHER/UNSPECIF','D05, D07.0, D07.1, D07.2, D07.3, D39, D48.6',NULL,'other carcinoma-in-situ','carcinoma-in-situ cervix X75; endometrial polyp X99',NULL,NULL,1,'X81');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1278-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'INJURY GENITAL FEMALE','INJURY GENITAL FEMALE','S30.2, S31.4, S31.5, S37.4, S37.5, S37.6, S38.0, S38.2, T19.2, T19.3, T28.3, T28.8',NULL,'foreign body in vagina, female circumcision','genital injury due to childbirth W92, W93',NULL,NULL,1,'X82');
##############################################
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1351-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'CONDYLOMATA ACUMINATA MALE','CONDYLOMATA ACUMINATA MALE','A63.0','characteristic appearance of lesions, or characteristic histological appearance','venereal warts, human papilloma virus infection in men',NULL,NULL,NULL,1,'Y76');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1352:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM PROSTATE','MALIGNANT NEOPLASM PROSTATE','C61','characteristic histological appearance',NULL,NULL,'benign/unspecified neoplasm male genital Y79',NULL,1,'Y77');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1353:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM MALE GENITAL OTHER','MALIGN NEOPL MALE GENITAL OTHER','C50, C60, C62, C63','characteristic histological appearance','carcinoma testis/seminoma, carcinoma male breast',NULL,'benign/unspecified neoplasm male genital Y79',NULL,1,'Y78');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1354:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'BENIGN/UNSPECIFIED NEOPLASM MALE GENITAL','BENIGN/UNSPECIF NEOPL MALE GENITAL','D07.4, D07.5, D07.6, D24, D29, D40, D48.6',NULL,'benign male genital neoplasm, neoplasm not specified as benign or malignant/when histology is not available, benign neoplasm male breast','prostatic hypertrophy Y85',NULL,NULL,1,'Y79');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1355-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'INJURY MALE GENITAL','INJURY MALE GENITAL','S30.2, S31.2, S31.3, S31.5, S38.0, S38.2, T28.3, T28.8',NULL,'circumcision',NULL,NULL,NULL,1,'Y80');
##############################################
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1443-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (6,'Other referral NEC','Other referral NEC',NULL,NULL,NULL,NULL,NULL,NULL,1,'H68');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1444:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEOPLASM OF EAR','NEOPLASM OF EAR','C30.1, D48.9',NULL,'benign/malignant neoplasm of ear','polyp ear H99; acoustic neuroma N75',NULL,NULL,1,'H75');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1445-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (1,'IRREGULAR HEARTBEAT OTHER','IRREGULAR HEARTBEAT OTHER','R00.8',NULL,NULL,'palpitations K04',NULL,NULL,1,'K05');
##############################################
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1463-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (1,'POST-PARTUM BLEEDING','POST-PARTUM BLEEDING','O72','heavy bleeding at or within 6 weeks of parturition',NULL,NULL,'other post-partum complaints W18',NULL,1,'W17');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1464:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM BLOOD OTHER','MALIGNANT NEOPLASM BLOOD OTHER','C37, C46.3, C77, C88, C90, C96',NULL,'myeloproliferative disease, multiple myeloma','Hodgkin''s disease/lymphoma B72',NULL,NULL,1,'B74');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1465-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'DIABETES INSULIN DEPENDENT','DIABETES INSULIN DEPENDENT','E10','patient requiring regular ongoing treatment with insulin after diagnosis confirmed by one of the following:(a) the classic symptoms of diabetes, such as polyuria, polydypsia, and rapid weight loss, together with unequivocal elevation of plasma glucose (b) fasting blood glucose levels of 8mmol/l (l40mg/dl) or more on two or more occasions (c) random blood glucose levels of 11mmol/l (200mg/dl) or more on two or more occasions (d) an oral Glucose Tolerance Test (75gm glucose) with one value of plasma glucose at between one and two hours of 11mmol/l (200mg/dl) or more, and plasma glucose at two hours of 11mol/l (200mg/dl) or more;\n
##############################################
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1469-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (1,'FEAR OF BREAST CANCER FEMALE','FEAR OF BREAST CANCER FEMALE','Z71.1','concern about/fear of female breast cancer in a patient without the disease/until the diagnosis is proven',NULL,'if patient has the disease, code the disease',NULL,NULL,1,'X26');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1470:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'BENIGN NEOPLASM BREAST FEMALE','BENIGN NEOPLASM BREAST FEMALE','D24','characteristic histological appearance','fibroadenoma female breast','cystic disease of breast X88','lump in breast X19',NULL,1,'X79');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1471-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'CONDYLOMATA ACUMINATA FEMALE','CONDYLOMATA ACUMINATA FEMALE','A63.0','characteristic appearance of lesions, or characteristic histological appearance','venereal warts, human papilloma virus infection',NULL,NULL,NULL,1,'X91');
##############################################
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1473-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (1,'FEAR OF SEXUAL DYSFUNCTION MALE','FEAR OF SEXUAL DYSFUNCTION MALE','Z71.1','concern about/fear of sexual dysfunction in a patient without the condition',NULL,'if the patient has sexual dysfunction, code the condition',NULL,NULL,1,'Y24');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql:1474:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'BENIGN NEOPLASM URINARY TRACT','BENIGN NEOPLASM URINARY TRACT','D30','characteristic histologic appearance','bladder papilloma, polyp of urinary tract','prostatic hypertrophy Y85','neoplasm urinary tract NOS U79',NULL,1,'U78');
gnumed-server-22.14/server/sql/v15-ref-icpc2-data.sql-1475-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (1,'SYMPTOM/COMPLAINT MUSCULOSKELETAL OTHER','SYMPT/COMPLT MUSCULOSKELETAL OTHER','R29.3, R29.8',NULL,'''growing pains'' in a child','clubbing of fingernails S22',NULL,NULL,1,'L29');
##############################################
gnumed-server-22.14/server/sql/v9-v10/dynamic/v10-i18n-dynamic.sql-30-BEGIN
gnumed-server-22.14/server/sql/v9-v10/dynamic/v10-i18n-dynamic.sql:31: perform 1 from pg_user where usename = $1;
gnumed-server-22.14/server/sql/v9-v10/dynamic/v10-i18n-dynamic.sql-32-
##############################################
gnumed-server-22.14/server/sql/v9-v10/dynamic/v10-i18n-dynamic.sql-61-BEGIN
gnumed-server-22.14/server/sql/v9-v10/dynamic/v10-i18n-dynamic.sql:62: delete from i18n.curr_lang where db_user = $1;
gnumed-server-22.14/server/sql/v9-v10/dynamic/v10-i18n-dynamic.sql-63- return;
##############################################
gnumed-server-22.14/server/sql/v9-v10/dynamic/v10-i18n-dynamic.sql-138- language sql
gnumed-server-22.14/server/sql/v9-v10/dynamic/v10-i18n-dynamic.sql:139: as 'select lang from i18n.curr_lang where db_user = $1'
gnumed-server-22.14/server/sql/v9-v10/dynamic/v10-i18n-dynamic.sql-140-;
##############################################
gnumed-server-22.14/server/sql/v9-v10/fixups/v10-dem-identity-dob_trigger-fixup.sql-55- -- when was this fixup script imported
gnumed-server-22.14/server/sql/v9-v10/fixups/v10-dem-identity-dob_trigger-fixup.sql:56: select imported from gm_schema_revision where filename = ''$RCSfile: v10-dem-identity-dob_trigger-fixup.sql,v $''
gnumed-server-22.14/server/sql/v9-v10/fixups/v10-dem-identity-dob_trigger-fixup.sql-57- )
##############################################
gnumed-server-22.14/server/sql/v17-v18/fixups/v18-cfg-depreciated_placeholders-fixup.sql-44--- --------------------------------------------------------------
gnumed-server-22.14/server/sql/v17-v18/fixups/v18-cfg-depreciated_placeholders-fixup.sql:45:delete from cfg.report_query where label = 'Find keyword expansions possibly containing depreciated $<HINT>$ syntax';
gnumed-server-22.14/server/sql/v17-v18/fixups/v18-cfg-depreciated_placeholders-fixup.sql-46-
##############################################
gnumed-server-22.14/server/sql/v19-v20/dynamic/v20-notifications-dynamic.sql-162- if _accessor_col = ''fk_encounter'' then -- retrieve identity PK via fk_encounter
gnumed-server-22.14/server/sql/v19-v20/dynamic/v20-notifications-dynamic.sql:163: _identity_accessor_SQL := ''select fk_patient from clin.encounter where pk = $1.fk_encounter limit 1'';
gnumed-server-22.14/server/sql/v19-v20/dynamic/v20-notifications-dynamic.sql-164- elsif _accessor_col = ''fk_identity'' then -- retrieve identity PK via fk_identity
##############################################
gnumed-server-22.14/server/sql/v19-v20/dynamic/v20-clin-patient-dynamic.sql-71- from dem.identity d_i
gnumed-server-22.14/server/sql/v19-v20/dynamic/v20-clin-patient-dynamic.sql:72: where d_i.pk = $1;
gnumed-server-22.14/server/sql/v19-v20/dynamic/v20-clin-patient-dynamic.sql-73- ';
##############################################
gnumed-server-22.14/server/sql/v19-v20/dynamic/v20-clin-patient-dynamic.sql-81- language sql
gnumed-server-22.14/server/sql/v19-v20/dynamic/v20-clin-patient-dynamic.sql:82: as 'select deceased from dem.identity d_i where d_i.pk = $1;';
gnumed-server-22.14/server/sql/v19-v20/dynamic/v20-clin-patient-dynamic.sql-83-
##############################################
gnumed-server-22.14/server/sql/v19-v20/dynamic/v20-clin-patient-dynamic.sql-90--- language sql
gnumed-server-22.14/server/sql/v19-v20/dynamic/v20-clin-patient-dynamic.sql:91:-- as 'select gender from dem.identity d_i where d_i.pk = $1;';
gnumed-server-22.14/server/sql/v19-v20/dynamic/v20-clin-patient-dynamic.sql-92-
##############################################
gnumed-server-22.14/server/sql/v10-v11/dynamic/v11-cfg-report_query-dynamic.sql-49- -- when was this fixup script imported
gnumed-server-22.14/server/sql/v10-v11/dynamic/v11-cfg-report_query-dynamic.sql:50: select imported from gm.schema_revision where filename = ''$RCSfile: v11-cfg-report_query-dynamic.sql,v $''
gnumed-server-22.14/server/sql/v10-v11/dynamic/v11-cfg-report_query-dynamic.sql-51- )
##############################################
gnumed-server-22.14/server/sql/v10-v11/dynamic/v11-clin-keyword_expansion-data.sql-273--- --------------------------------------------------------------
gnumed-server-22.14/server/sql/v10-v11/dynamic/v11-clin-keyword_expansion-data.sql:274:delete from clin.keyword_expansion where keyword = '$checkup-gkv';
gnumed-server-22.14/server/sql/v10-v11/dynamic/v11-clin-keyword_expansion-data.sql-275-
##############################################
gnumed-server-22.14/server/sql/gmDemographics-Person-views.sql-435--- do simple schema revision tracking
gnumed-server-22.14/server/sql/gmDemographics-Person-views.sql:436:delete from gm_schema_revision where filename = '$RCSfile: gmDemographics-Person-views.sql,v $';
gnumed-server-22.14/server/sql/gmDemographics-Person-views.sql-437-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmDemographics-Person-views.sql,v $', '$Revision: 1.55 $');
##############################################
gnumed-server-22.14/server/sql/gmNotifications-static.sql-23--- do simple schema revision tracking
gnumed-server-22.14/server/sql/gmNotifications-static.sql:24:delete from gm_schema_revision where filename='$RCSfile: gmNotifications-static.sql,v $';
gnumed-server-22.14/server/sql/gmNotifications-static.sql-25-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmNotifications-static.sql,v $', '$Revision: 1.1 $');
##############################################
gnumed-server-22.14/server/sql/gmAudit-dynamic.sql-159--- keep the "true" !
gnumed-server-22.14/server/sql/gmAudit-dynamic.sql:160:delete from gm_schema_revision where filename = '$RCSfile: gmAudit-dynamic.sql,v $';
gnumed-server-22.14/server/sql/gmAudit-dynamic.sql-161-insert into gm_schema_revision (filename, version) values ('$RCSfile: gmAudit-dynamic.sql,v $', '$Revision: 1.8 $');
##############################################
gnumed-server-22.14/server/sql/v8-v9/dynamic/v9-i18n-dynamic.sql-13- language sql
gnumed-server-22.14/server/sql/v8-v9/dynamic/v9-i18n-dynamic.sql:14: as 'select lang from i18n.curr_lang where "user" = $1'
gnumed-server-22.14/server/sql/v8-v9/dynamic/v9-i18n-dynamic.sql-15-;
##############################################
gnumed-server-22.14/server/sql/v8-v9/dynamic/v9-clin-keyword_expansion-data.sql-17--- --------------------------------------------------------------
gnumed-server-22.14/server/sql/v8-v9/dynamic/v9-clin-keyword_expansion-data.sql:18:delete from clin.keyword_expansion where keyword = '$$kuss';
gnumed-server-22.14/server/sql/v8-v9/dynamic/v9-clin-keyword_expansion-data.sql-19-
##############################################
gnumed-server-22.14/server/sql/v18-v19/dynamic/v19-notifications-dynamic.sql-237- -- retrieve identity PK via fk_encounter
gnumed-server-22.14/server/sql/v18-v19/dynamic/v19-notifications-dynamic.sql:238: _identity_accessor_SQL := ''select fk_patient from clin.encounter where pk = $1.fk_encounter limit 1'';
gnumed-server-22.14/server/sql/v18-v19/dynamic/v19-notifications-dynamic.sql-239- elsif _accessor_col = ''fk_identity'' then
##############################################
gnumed-server-22.14/server/sql/gmConfigViews.sql-287--- do simple schema revision tracking
gnumed-server-22.14/server/sql/gmConfigViews.sql:288:delete from gm_schema_revision where filename='$RCSfile: gmConfigViews.sql,v $';
gnumed-server-22.14/server/sql/gmConfigViews.sql-289-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmConfigViews.sql,v $', '$Revision: 1.8 $');
##############################################
gnumed-server-22.14/server/sql/country.specific/es/gmDemographics-Data.es.sql-88--- do simple revision tracking
gnumed-server-22.14/server/sql/country.specific/es/gmDemographics-Data.es.sql:89:delete from gm_schema_revision where filename = '$RCSfile: gmDemographics-Data.es.sql,v $';
gnumed-server-22.14/server/sql/country.specific/es/gmDemographics-Data.es.sql-90-INSERT INTO gm_schema_revision (filename, version) VALUES ('$RCSfile: gmDemographics-Data.es.sql,v $', '$Revision: 1.7 $');
##############################################
gnumed-server-22.14/server/sql/country.specific/de/gmATC.sql-93--- do simple revision tracking
gnumed-server-22.14/server/sql/country.specific/de/gmATC.sql:94:delete from gm_schema_revision where filename = '$RCSfile: gmATC.sql,v $';
gnumed-server-22.14/server/sql/country.specific/de/gmATC.sql-95-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmATC.sql,v $', '$Revision: 1.3 $');
##############################################
gnumed-server-22.14/server/sql/country.specific/de/gmClinical.de.sql-48--- do simple revision tracking
gnumed-server-22.14/server/sql/country.specific/de/gmClinical.de.sql:49:delete from gm_schema_revision where filename='$RCSfile: gmClinical.de.sql,v $';
gnumed-server-22.14/server/sql/country.specific/de/gmClinical.de.sql-50-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmClinical.de.sql,v $', '$Revision: 1.17 $');
##############################################
gnumed-server-22.14/server/sql/country.specific/de/PLZ.sql-161--- do simple revision tracking
gnumed-server-22.14/server/sql/country.specific/de/PLZ.sql:162:delete from gm_schema_revision where filename = '$RCSfile: PLZ.sql,v $';
gnumed-server-22.14/server/sql/country.specific/de/PLZ.sql-163-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: PLZ.sql,v $', '$Revision: 1.13 $');
##############################################
gnumed-server-22.14/server/sql/country.specific/de/gmVornamen.sql-3435--- do simple revision tracking
gnumed-server-22.14/server/sql/country.specific/de/gmVornamen.sql:3436:delete from gm_schema_revision where filename = '$RCSfile: gmVornamen.sql,v $';
gnumed-server-22.14/server/sql/country.specific/de/gmVornamen.sql-3437-INSERT INTO gm_schema_revision (filename, version) VALUES ('$rcsfile: gmvornamen.sql,v $', '$Revision: 1.7 $');
##############################################
gnumed-server-22.14/server/sql/country.specific/de/gmDemographics-Data.de.sql-21--- do simple revision tracking
gnumed-server-22.14/server/sql/country.specific/de/gmDemographics-Data.de.sql:22:delete from gm_schema_revision where filename = '$RCSfile: gmDemographics-Data.de.sql,v $';
gnumed-server-22.14/server/sql/country.specific/de/gmDemographics-Data.de.sql-23-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmDemographics-Data.de.sql,v $', '$Revision: 1.6 $');
##############################################
gnumed-server-22.14/server/sql/country.specific/de/gmDiagnosen.sql-89--- do simple revision tracking
gnumed-server-22.14/server/sql/country.specific/de/gmDiagnosen.sql:90:delete from gm_schema_revision where filename = '$RCSfile: gmDiagnosen.sql,v $';
gnumed-server-22.14/server/sql/country.specific/de/gmDiagnosen.sql-91-INSERT INTO gm_schema_revision (filename, version) VALUES ('$RCSfile: gmDiagnosen.sql,v $', '$Revision: 1.5 $');
##############################################
gnumed-server-22.14/server/sql/country.specific/de/Impfplan-FSME.sql-95--- do simple revision tracking
gnumed-server-22.14/server/sql/country.specific/de/Impfplan-FSME.sql:96:delete from gm_schema_revision where filename = '$RCSfile: Impfplan-FSME.sql,v $';
gnumed-server-22.14/server/sql/country.specific/de/Impfplan-FSME.sql-97-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: Impfplan-FSME.sql,v $', '$Revision: 1.6 $');
##############################################
gnumed-server-22.14/server/sql/country.specific/au/gmDemographics.au.sql-84--- do simple schema revision tracking
gnumed-server-22.14/server/sql/country.specific/au/gmDemographics.au.sql:85:delete from gm_schema_revision where filename='$RCSfile: gmDemographics.au.sql,v $';
gnumed-server-22.14/server/sql/country.specific/au/gmDemographics.au.sql-86-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmDemographics.au.sql,v $', '$Revision: 1.15 $');
##############################################
gnumed-server-22.14/server/sql/country.specific/ca/gmDemographics-Data.ca.sql-45--- do simple revision tracking
gnumed-server-22.14/server/sql/country.specific/ca/gmDemographics-Data.ca.sql:46:delete from gm_schema_revision where filename = '$RCSfile: gmDemographics-Data.ca.sql,v $';
gnumed-server-22.14/server/sql/country.specific/ca/gmDemographics-Data.ca.sql-47-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmDemographics-Data.ca.sql,v $', '$Revision: 1.5 $');
##############################################
gnumed-server-22.14/server/sql/v15-v16/fixups/v16-i18n-fixup.sql-26- -- reduce xx_XX@YY to xx
gnumed-server-22.14/server/sql/v15-v16/fixups/v16-i18n-fixup.sql:27: select into trans_str trans from i18n.translations where lang = regexp_replace(_lang, ''_.*$'', '''') and orig = _orig;
gnumed-server-22.14/server/sql/v15-v16/fixups/v16-i18n-fixup.sql-28-
##############################################
gnumed-server-22.14/server/sql/gmDemographics-GIS-views.sql-488--- do simple schema revision tracking
gnumed-server-22.14/server/sql/gmDemographics-GIS-views.sql:489:delete from gm_schema_revision where filename='$RCSfile: gmDemographics-GIS-views.sql,v $';
gnumed-server-22.14/server/sql/gmDemographics-GIS-views.sql-490-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmDemographics-GIS-views.sql,v $', '$Revision: 1.31 $');
##############################################
gnumed-server-22.14/server/gm-restore_database.sh-40- echo " ERROR: Cannot access backup file. Aborting."
gnumed-server-22.14/server/gm-restore_database.sh:41: echo " "`ls -al ${BACKUP}`
gnumed-server-22.14/server/gm-restore_database.sh-42- exit 1
##############################################
gnumed-server-22.14/server/gm-restore_database.sh-52- echo " ERROR: Cannot read configuration file ${CONF}. Aborting."
gnumed-server-22.14/server/gm-restore_database.sh:53: echo " "`ls -al ${CONF}`
gnumed-server-22.14/server/gm-restore_database.sh-54- exit 1
##############################################
gnumed-server-22.14/server/gm-restore_database.sh-88- echo " ERROR: Cannot copy backup file. Aborting."
gnumed-server-22.14/server/gm-restore_database.sh:89: echo " "`ls -al ${BACKUP}`
gnumed-server-22.14/server/gm-restore_database.sh-90- exit 1
##############################################
gnumed-server-22.14/server/gm-restore_database.sh-95-echo "==> Unpacking backup file ..."
gnumed-server-22.14/server/gm-restore_database.sh:96:BACKUP=${WORK_DIR}`basename ${BACKUP}`
gnumed-server-22.14/server/gm-restore_database.sh-97-if [[ "${BACKUP}" =~ .*\.bz2 ]] ; then
##############################################
gnumed-server-22.14/server/gm-restore_database.sh-105- fi
gnumed-server-22.14/server/gm-restore_database.sh:106: BACKUP=${WORK_DIR}`basename ${BACKUP} .bz2`
gnumed-server-22.14/server/gm-restore_database.sh-107-fi
##############################################
gnumed-server-22.14/server/gm-restore_database.sh-117-fi
gnumed-server-22.14/server/gm-restore_database.sh:118:BACKUP=${WORK_DIR}`basename ${BACKUP} .tar`
gnumed-server-22.14/server/gm-restore_database.sh-119-rm ${BACKUP}.tar
##############################################
gnumed-server-22.14/server/gm-restore_database.sh-137-echo "==> Checking target database status ..."
gnumed-server-22.14/server/gm-restore_database.sh:138:TARGET_DB=`head -n 40 ${BACKUP}-database.sql | grep -i "create database gnumed_v" | cut -f 3 -d " "`
gnumed-server-22.14/server/gm-restore_database.sh-139-if test $? -ne 0 ; then
##############################################
gnumed-server-22.14/server/gm-restore_database.sh-147-echo " db: ${TARGET_DB}"
gnumed-server-22.14/server/gm-restore_database.sh:148:if test `sudo -u postgres psql -l -p ${GM_PORT} | grep ${TARGET_DB} | wc -l` -ne 0 ; then
gnumed-server-22.14/server/gm-restore_database.sh-149- echo " ERROR: Target database ${TARGET_DB} already exists. Aborting."
##############################################
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html-102741- from dem.identity d_i
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html:102742: where d_i.pk = $1;
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html-102743- </pre>
##############################################
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html-102751-
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html:102752: <pre>select deceased from dem.identity d_i where d_i.pk = $1;</pre>
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html-102753-
##############################################
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html-103116- EXECUTE format (
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html:103117: 'UPDATE %1$s SET %2$I = %3$L WHERE %2$I = %4$L',
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html-103118- _fk_row.referencing_table,
##############################################
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html-124871- if _accessor_col = 'fk_encounter' then -- retrieve identity PK via fk_encounter
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html:124872: _identity_accessor_SQL := 'select fk_patient from clin.encounter where pk = $1.fk_encounter limit 1';
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html-124873- elsif _accessor_col = 'fk_identity' then -- retrieve identity PK via fk_identity
##############################################
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html-125394-BEGIN
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html:125395: perform 1 from pg_user where usename = $1;
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html-125396- if not FOUND then
##############################################
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html-125959- -- reduce xx_XX@YY to xx
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html:125960: select into trans_str trans from i18n.translations where lang = regexp_replace(_lang, '_.*$', '') and orig = _orig;
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html-125961- if not found then
##############################################
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html-126030-
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html:126031: <pre>select lang from i18n.curr_lang where db_user = $1</pre>
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html-126032-
##############################################
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html-126146-BEGIN
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html:126147: delete from i18n.curr_lang where db_user = $1;
gnumed-server-22.14/server/doc/schema/gnumed-entire_schema.html-126148- return;
##############################################
gnumed-server-22.14/server/gm-dump_schema.sh-83- echo "" >> ${BACKUP_FILENAME}-roles.sql 2> /dev/null
gnumed-server-22.14/server/gm-dump_schema.sh:84: ROLES=`psql -A -d ${TARGET_DB} -p ${GM_PORT} -U ${GM_DBO} -c "select gm.get_users('${TARGET_DB}');"`
gnumed-server-22.14/server/gm-dump_schema.sh-85- echo "-- ${ROLES}" >> ${BACKUP_FILENAME}-roles.sql 2> /dev/null
##############################################
gnumed-server-22.14/server/gm-dump_schema.sh-104- echo "" >> ${BACKUP_FILENAME}-roles.sql 2> /dev/null
gnumed-server-22.14/server/gm-dump_schema.sh:105: ROLES= `psql -A -d ${TARGET_DB} -p ${GM_PORT} -U ${GM_DBO} -c "select gm.get_users('${TARGET_DB}');"`
gnumed-server-22.14/server/gm-dump_schema.sh-106- echo "-- ${ROLES}" >> ${BACKUP_FILENAME}-roles.sql 2> /dev/null
##############################################
gnumed-server-22.14/server/gm-backup_data.sh-74-# are we backing up the latest DB ?
gnumed-server-22.14/server/gm-backup_data.sh:75:OUR_VER=`echo ${GM_DATABASE} | cut -f 2 -d v`
gnumed-server-22.14/server/gm-backup_data.sh-76-if test -z ${GM_HOST} ; then
gnumed-server-22.14/server/gm-backup_data.sh:77: HAS_HIGHER_VER=`sudo -u postgres psql -A -t -d ${GM_DATABASE} -p ${GM_PORT} -c "SELECT exists (select 1 from pg_database where datname like 'gnumed_v%' and substring(datname from 9 for 3)::integer > '${OUR_VER}');"`
gnumed-server-22.14/server/gm-backup_data.sh-78-else
gnumed-server-22.14/server/gm-backup_data.sh:79: HAS_HIGHER_VER=`sudo -u postgres psql -A -t -h ${GM_HOST} -d ${GM_DATABASE} -p ${GM_PORT} -c "SELECT exists (select 1 from pg_database where datname like 'gnumed_v%' and substring(datname from 9 for 3)::integer > '${OUR_VER}');"`
gnumed-server-22.14/server/gm-backup_data.sh-80-fi;
##############################################
gnumed-server-22.14/server/gm-pg_upgradecluster-helper-57-CMD="use PgCommon; \$p = get_cluster_port \"${OLD_VER}\", \"${CLUSTER_NAME}\"; print \"\$p\\n\""
gnumed-server-22.14/server/gm-pg_upgradecluster-helper:58:PORT=`perl -I/usr/share/postgresql-common/ -e "$CMD"`
gnumed-server-22.14/server/gm-pg_upgradecluster-helper-59-
##############################################
gnumed-server-22.14/server/gm-pg_upgradecluster-helper-66- CMD="use PgCommon; \$p = get_cluster_port \"${NEW_VER}\", \"${CLUSTER_NAME}\"; print \"\$p\\n\""
gnumed-server-22.14/server/gm-pg_upgradecluster-helper:67: PORT=`perl -I/usr/share/postgresql-common/ -e "$CMD"`
gnumed-server-22.14/server/gm-pg_upgradecluster-helper-68- echo "Accessing port: ${PORT}" >> ${LOG_FILE} 2>&1
##############################################
gnumed-server-22.14/server/gm-restore_data.sh-53-echo "==> Testing target database status ..."
gnumed-server-22.14/server/gm-restore_data.sh:54:if test `sudo -u postgres psql -l -p ${GM_PORT} | grep ${TARGET_DB} | wc -l` -eq 0 ; then
gnumed-server-22.14/server/gm-restore_data.sh-55- echo " ERROR: Target database ${TARGET_DB} does not exist. Aborting."
##############################################
gnumed-server-22.14/server/gm-restore_data.sh-101-echo "==> Unpacking backup file ..."
gnumed-server-22.14/server/gm-restore_data.sh:102:BACKUP=${WORK_DIR}/`basename ${BACKUP}`
gnumed-server-22.14/server/gm-restore_data.sh-103-if [[ "$BACKUP" =~ .*\.bz2 ]] ; then
##############################################
gnumed-server-22.14/server/gm-restore_data.sh-108- fi
gnumed-server-22.14/server/gm-restore_data.sh:109: BACKUP=`basename ${BACKUP} .bz2`
gnumed-server-22.14/server/gm-restore_data.sh-110-fi
##############################################
gnumed-server-22.14/server/gm-restore_data.sh-115-fi
gnumed-server-22.14/server/gm-restore_data.sh:116:BACKUP=`basename ${BACKUP} .tar`
gnumed-server-22.14/server/gm-restore_data.sh-117-
##############################################
gnumed-server-22.14/server/gm-backup.sh-156-# -r -> -g for older versions
gnumed-server-22.14/server/gm-backup.sh:157:#ROLES=`psql --no-psqlrc --no-align --tuples-only --dbname="${GM_DATABASE}" ${_PG_HOST_ARG} ${_PG_PORT_ARG} --username="${GM_DBO}" --command="select gm.get_users('${GM_DATABASE}');"`
gnumed-server-22.14/server/gm-backup.sh-158-ROLES=$(psql --no-psqlrc --no-align --tuples-only --dbname="${GM_DATABASE}" ${_PG_HOST_ARG} ${_PG_PORT_ARG} --username="${GM_DBO}" --command="select gm.get_users('${GM_DATABASE}');")
##############################################
gnumed-server-22.14/server/bootstrap/upgrade-db.sh-94- TEMPLATE_DB="gnumed_v${PREV_VER}"
gnumed-server-22.14/server/bootstrap/upgrade-db.sh:95: VER_EXISTS=`su -c "psql -l ${PORT_DEF}" -l postgres | grep ${TEMPLATE_DB}`
gnumed-server-22.14/server/bootstrap/upgrade-db.sh-96- if test "${VER_EXISTS}" == "" ; then
##############################################
gnumed-server-22.14/server/bootstrap/upgrade-db.sh-136- # Does TARGET database exist ?
gnumed-server-22.14/server/bootstrap/upgrade-db.sh:137: VER_EXISTS=`su -c "psql -l ${PORT_DEF}" -l postgres | grep gnumed_v${NEXT_VER}`
gnumed-server-22.14/server/bootstrap/upgrade-db.sh-138- if test "${VER_EXISTS}" != "" ; then
##############################################
gnumed-server-22.14/server/bootstrap/bootstrap-latest.sh-51-for DB_VER in ${ALL_PREV_VERS} ; do
gnumed-server-22.14/server/bootstrap/bootstrap-latest.sh:52: VER_EXISTS=`su -c "psql -l ${PORT_DEF}" -l postgres | grep gnumed_v${DB_VER}`
gnumed-server-22.14/server/bootstrap/bootstrap-latest.sh-53- if test "${VER_EXISTS}" != "" ; then
##############################################
gnumed-server-22.14/server/bootstrap/bootstrap_gm_db_system.py-1237- RAISE NOTICE 'validating [%] on [%.%]', r.conname, r.nspname, r.relname;
gnumed-server-22.14/server/bootstrap/bootstrap_gm_db_system.py:1238: EXECUTE 'UPDATE pg_constraint SET convalidated=false WHERE conname=$1 AND connamespace=$2 AND conrelid=$3' USING r.conname, r.connamespace, r.conrelid;
gnumed-server-22.14/server/bootstrap/bootstrap_gm_db_system.py-1239- EXECUTE 'ALTER TABLE ' || r.nspname || '.' || r.relname || ' VALIDATE CONSTRAINT "' || r.conname || '"';
##############################################
gnumed-server-22.14/server/gm-restore.sh-40- echo " ERROR: Cannot access backup file. Aborting."
gnumed-server-22.14/server/gm-restore.sh:41: echo " "`ls -al ${BACKUP}`
gnumed-server-22.14/server/gm-restore.sh-42- exit 1
##############################################
gnumed-server-22.14/server/gm-restore.sh-52- echo " ERROR: Cannot read configuration file ${CONF}. Aborting."
gnumed-server-22.14/server/gm-restore.sh:53: echo " "`ls -al ${CONF}`
gnumed-server-22.14/server/gm-restore.sh-54- exit 1
##############################################
gnumed-server-22.14/server/gm-restore.sh-98- echo " ERROR: Cannot copy backup file. Aborting."
gnumed-server-22.14/server/gm-restore.sh:99: echo " "`ls -al ${BACKUP}`
gnumed-server-22.14/server/gm-restore.sh-100- echo " log: ${LOG}"
##############################################
gnumed-server-22.14/server/gm-restore.sh-106-echo "==> Unpacking backup file ..."
gnumed-server-22.14/server/gm-restore.sh:107:BACKUP=${WORK_DIR}`basename ${BACKUP}`
gnumed-server-22.14/server/gm-restore.sh-108-if [[ "${BACKUP}" =~ .*\.bz2 ]] ; then
##############################################
gnumed-server-22.14/server/gm-restore.sh-117- fi
gnumed-server-22.14/server/gm-restore.sh:118: BACKUP=${WORK_DIR}`basename ${BACKUP} .bz2`
gnumed-server-22.14/server/gm-restore.sh-119-fi
##############################################
gnumed-server-22.14/server/gm-restore.sh-130-fi
gnumed-server-22.14/server/gm-restore.sh:131:BACKUP=${WORK_DIR}`basename ${BACKUP} .tar`
gnumed-server-22.14/server/gm-restore.sh-132-rm ${BACKUP}.tar &>> ${LOG}
##############################################
gnumed-server-22.14/server/gm-restore.sh-136-echo "==> Checking target database status ..."
gnumed-server-22.14/server/gm-restore.sh:137:TARGET_DB=`pg_restore --create --schema-only ${BACKUP}.dir | head -n 40 | grep -i 'create database gnumed_v' | cut -f 3 -d ' '`
gnumed-server-22.14/server/gm-restore.sh-138-ERROR="$?"
##############################################
gnumed-server-22.14/server/gm-restore.sh-151-echo " db: ${TARGET_DB}"
gnumed-server-22.14/server/gm-restore.sh:152:if test `sudo -u postgres psql -l -p ${GM_PORT} | grep ${TARGET_DB} | wc -l` -ne 0 ; then
gnumed-server-22.14/server/gm-restore.sh-153- echo ""
##############################################
gnumed-server-22.14/Gnumed/gm-move_backups_offsite.sh-56-# do not run concurrently
gnumed-server-22.14/Gnumed/gm-move_backups_offsite.sh:57:if test "`ps ax | grep $0 | grep -v grep | grep -v $$`" != "" ; then
gnumed-server-22.14/Gnumed/gm-move_backups_offsite.sh-58- echo "${HOST}: "`date`": transfer already in progress, exiting" >> ${LOG}
##############################################
gnumed-server-22.14/Gnumed/gm-backup_database.sh-75-# are we backing up the latest DB ?
gnumed-server-22.14/Gnumed/gm-backup_database.sh:76:OUR_VER=`echo ${GM_DATABASE} | cut -f 2 -d v`
gnumed-server-22.14/Gnumed/gm-backup_database.sh-77-if test -z ${GM_HOST} ; then
gnumed-server-22.14/Gnumed/gm-backup_database.sh:78: HAS_HIGHER_VER=`sudo -u postgres psql -A -t -d ${GM_DATABASE} -p ${GM_PORT} -c "SELECT exists (select 1 from pg_database where datname like 'gnumed_v%' and substring(datname from 9 for 3)::integer > '${OUR_VER}');"`
gnumed-server-22.14/Gnumed/gm-backup_database.sh-79-else
gnumed-server-22.14/Gnumed/gm-backup_database.sh:80: HAS_HIGHER_VER=`sudo -u postgres psql -A -t -h ${GM_HOST} -d ${GM_DATABASE} -p ${GM_PORT} -c "SELECT exists (select 1 from pg_database where datname like 'gnumed_v%' and substring(datname from 9 for 3)::integer > '${OUR_VER}');"`
gnumed-server-22.14/Gnumed/gm-backup_database.sh-81-fi;
##############################################
gnumed-server-22.14/Gnumed/gm-backup_database.sh-129- echo "" >> ${BACKUP_FILENAME}-roles.sql 2> /dev/null
gnumed-server-22.14/Gnumed/gm-backup_database.sh:130: ROLES=`psql -A -t -d ${GM_DATABASE} -p ${GM_PORT} -U ${GM_DBO} -c "select gm.get_users('${GM_DATABASE}');"`
gnumed-server-22.14/Gnumed/gm-backup_database.sh-131- echo "-- ${ROLES}" >> ${BACKUP_FILENAME}-roles.sql 2> /dev/null
##############################################
gnumed-server-22.14/Gnumed/gm-backup_database.sh-152- echo "" >> ${BACKUP_FILENAME}-roles.sql 2> /dev/null
gnumed-server-22.14/Gnumed/gm-backup_database.sh:153: ROLES=`psql -A -t -d ${GM_DATABASE} -p ${GM_PORT} -U ${GM_DBO} -c "select gm.get_users('${GM_DATABASE}');"`
gnumed-server-22.14/Gnumed/gm-backup_database.sh-154- echo "-- ${ROLES}" >> ${BACKUP_FILENAME}-roles.sql 2> /dev/null
##############################################
gnumed-server-22.14/Gnumed/gm-zip+sign_backups.sh-144-
gnumed-server-22.14/Gnumed/gm-zip+sign_backups.sh:145: #SHA512="SHA 512:"`sha512sum -b ${BACKUP_FILENAME}.tar.bz2`
gnumed-server-22.14/Gnumed/gm-zip+sign_backups.sh-146- SHA512=$(openssl dgst -sha512 -hex "${BZ2_FINAL}")
##############################################
gnumed-server-22.14/Gnumed/sql/gmReference-data.sql-88--- do simple schema revision tracking
gnumed-server-22.14/Gnumed/sql/gmReference-data.sql:89:delete from gm_schema_revision where filename='$RCSfile: gmReference-data.sql,v $';
gnumed-server-22.14/Gnumed/sql/gmReference-data.sql-90-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmReference-data.sql,v $', '$Revision: 1.4 $');
##############################################
gnumed-server-22.14/Gnumed/sql/gmoffice.sql-154--- do simple schema revision tracking
gnumed-server-22.14/Gnumed/sql/gmoffice.sql:155:delete from gm_schema_revision where filename='$RCSfile: gmoffice.sql,v $';
gnumed-server-22.14/Gnumed/sql/gmoffice.sql-156-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmoffice.sql,v $', '$Revision: 1.15 $');
##############################################
gnumed-server-22.14/Gnumed/sql/gmHousekeeping.sql-72--- do simple schema revision tracking
gnumed-server-22.14/Gnumed/sql/gmHousekeeping.sql:73:delete from gm_schema_revision where filename = '$RCSfile: gmHousekeeping.sql,v $';
gnumed-server-22.14/Gnumed/sql/gmHousekeeping.sql-74-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmHousekeeping.sql,v $', '$Revision: 1.8 $');
##############################################
gnumed-server-22.14/Gnumed/sql/v20-v21/fixups/v21-notifications-dynamic.sql-162- if _accessor_col = ''fk_encounter'' then -- retrieve identity PK via fk_encounter
gnumed-server-22.14/Gnumed/sql/v20-v21/fixups/v21-notifications-dynamic.sql:163: _identity_accessor_SQL := ''select fk_patient from clin.encounter where pk = $1.fk_encounter limit 1'';
gnumed-server-22.14/Gnumed/sql/v20-v21/fixups/v21-notifications-dynamic.sql-164- elsif _accessor_col = ''fk_identity'' then -- retrieve identity PK via fk_identity
##############################################
gnumed-server-22.14/Gnumed/sql/gmNotifications-dynamic.sql-86--- do simple schema revision tracking
gnumed-server-22.14/Gnumed/sql/gmNotifications-dynamic.sql:87:delete from gm_schema_revision where filename='$RCSfile: gmNotifications-dynamic.sql,v $';
gnumed-server-22.14/Gnumed/sql/gmNotifications-dynamic.sql-88-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmNotifications-dynamic.sql,v $', '$Revision: 1.2 $');
##############################################
gnumed-server-22.14/Gnumed/sql/v14-v15/dynamic/v15-i18n-dynamic.sql-27- -- reduce xx_XX@YY to xx
gnumed-server-22.14/Gnumed/sql/v14-v15/dynamic/v15-i18n-dynamic.sql:28: select into trans_str trans from i18n.translations where lang = regexp_replace(_lang, ''_.*$'', '''') and orig = _orig;
gnumed-server-22.14/Gnumed/sql/v14-v15/dynamic/v15-i18n-dynamic.sql-29-
##############################################
gnumed-server-22.14/Gnumed/sql/test-data/gmDemographics-Person-test_data.sql-23--- do simple schema revision tracking
gnumed-server-22.14/Gnumed/sql/test-data/gmDemographics-Person-test_data.sql:24:delete from gm_schema_revision where filename = '$RCSfile: gmDemographics-Person-test_data.sql,v $';
gnumed-server-22.14/Gnumed/sql/test-data/gmDemographics-Person-test_data.sql-25-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmDemographics-Person-test_data.sql,v $', '$Revision: 1.8 $');
##############################################
gnumed-server-22.14/Gnumed/sql/test-data/test_data-James_Kirk.sql-143- (select pk_staff from dem.v_staff where firstnames='Leonard Horatio' and lastnames='McCoy' and dob='1920-1-20+2:00'),
gnumed-server-22.14/Gnumed/sql/test-data/test_data-James_Kirk.sql:144: E'GIF89a0\\0000\\000\\325\\000\\000\\377\\377\\377\\275\\234\\234\\224sk\\275\\204s\\326\\275\\265\\224{s\\275\\214{\\245{k\\214cR\\275\\234\\214{ZJ\\255{c\\316\\255\\234\\306\\224{\\245sZ\\234kRcB1\\204R91!\\030\\347\\316\\275\\306\\255\\234cJ9\\265\\204cB)\\030Z9!\\316\\255\\224\\306\\245\\214\\265\\224{sR9\\214cBsZBB1!)\\030\\010\\336\\306\\255\\275\\245\\21491)\\234\\204k\\214sZ\\020\\010\\000B)\\010\\326\\306\\255RB)cZJ\\357\\347\\326RJ9\\214{R\\255\\234kskR\\275\\255{\\214\\204Zsskkkc))!\\234\\234{\\030\\030\\020BJ!\\255\\265\\224\\245\\275\\23419J\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000,\\000\\000\\000\\0000\\0000\\000@\\006\\377@\\204P\\241@\\274*\\220\\012\\347P\\330\\355lP\\223I2\\032\\321\\250\\254jj\\304R\\315X,\\020k&\\003#\\017$\\322\\342\\223Jz\\336#\\247\\223\\306*)"\\217\\274\\3052\\3507\\014\\033.\\013\\007\\003\\033\\006\\015\\014(\\023!\\033\\007\\007\\002)\\022P#S#[\\020\\035\\021\\034N,B\\036\\012\\017\\016\\013{\\026\\016\\204\\011\\032\\011\\006\\253\\015\\255\\255\\003{\\260\\015%)N#\\020:\\271:44\\012\\035\\020\\020\\036\\035\\241\\016}{\\216$\\002%\\241\\006\\003\\276\\010%*P;&\\012%%\\033\\025\\237\\022^2\\2744U\\022 mH\\237\\035%\\242\\204\\016\\030&\\030x\\203\\006!z}\\364\\013\\017\\006\\0364^33/\\0121\\000_\\2340\\021\\314\\003\\004\\014m<D\\030\\326\\241a\\236\\003\\011\\022lh\\364 S\\036\\207(2\\204\\010\\021\\243C\\014\\007.6\\2200\\010\\201\\003\\260\\012\\012^|\\222c\\203F\\033`)\\332\\304\\034\\361\\001\\234\\225p\\022\\244\\2008\\001\\341\\304\\205\\377._j\\355\\370`\\251\\2155Jr>\\240\\024\\226''\\035\\237\\015}\\014D\\214\\310\\252\\025\\003\\002\\011Z\\341c1IW\\225\\004\\0070|\\370 cF\\011\\004\\036.\\230\\260\\301I\\312\\011\\017\\017\\026\\310\\035\\345GC\\210\\011\\004D4s`b\\016\\027]\\272h\\330HH\\004\\201\\251\\001\\257\\0268\\260h!\\021\\001\\002\\00140H\\245A\\303+>\\013\\366\\361;\\221\\202\\204\\210\\0348^\\000\\303\\340\\246\\003\\002\\005\\0250\\014s\\264\\241\\006\\011G\\204\\014\\015h*\\012B\\245.*^\\370\\363\\320BAI\\005\\006Sp\\030\\016\\341\\302\\011\\014\\034\\254\\0118`h\\203\\304\\003\\016.\\016\\357\\350\\302E\\014\\021.\\036\\300\\200Q}\\373v\\017\\303\\337xP\\311\\246\\000\\015\\226\\022$\\200\\273\\222^RK\\3676\\372\\202\\310\\375aL\\015\\025\\025X|\\370}\\222C~\\026/\\304!\\007\\015/\\240\\325\\001(\\027u\\000\\036q\\020\\010g\\315\\003\\012p\\200\\301\\204<A\\000F\\012>]\\020SIo\\200 \\377\\307\\016t\\000\\007\\212\\003\\242\\320\\025U\\002\\031\\210PY\\006,\\242@\\300\\012+\\020\\300@\\006\\033\\0108\\230\\015\\022\\304\\304FJ}=\\201\\222Cy4\\305G!\\023\\321c\\344\\220\\260\\320\\223\\037\\015\\027x0\\202\\016U\\\\\\200\\300l\\036\\354\\220\\302n\\371i\\343\\001J%\\034`\\242s`6@O,|\\034 \\324\\016\\306\\005&\\301\\001\\277\\014\\367 \\211\\016\\024V@\\001$\\240\\245\\232(\\017`p\\302q\\301\\250p\\315 \\032\\224\\260\\003\\010\\340\\214\\001\\330MH\\004S\\204\\000\\246\\360\\261\\212\\227\\321u\\340\\200d\\013tYBC\\0159@\\202\\003\\026,\\300A\\003F\\220!\\003`^\\231QX(\\007\\224\\262XE\\017\\034`\\000\\001\\031\\314\\206X\\003\\226\\211\\271G1\\003\\214\\301\\217n>\\351\\311S\\011\\015&\\241M\\021\\010\\204"@\\001\\216<\\320\\023r\\007\\004\\260At$\\316\\265\\200\\007\\022\\330\\322\\205n\\012\\324\\200C\\0150\\274\\300BI\\022\\236D\\3040\\016\\234\\346\\301\\204\\021\\244+\\377\\351\\003\\357(\\326\\224\\010(l\\373\\302\\015\\212\\002\\027C\\013\\036\\334`\\022r\\303\\371\\252h(\\322\\035\\224n(\\366D\\360F\\007\\034i\\267]w(p\\267]C\\034\\214\\247B\\203\\244\\355\\353+r\\237@\\263\\334#\\010H\\330A\\005%\\264\\320\\202\\\\1dWLu.x\\007\\003p\\237\\020q\\304\\005J\\011\\300\\326\\023P@\\301\\213z7U\\221\\2058)\\360\\023F\\0118|Q\\201\\004\\025\\000t\\300p\\376E\\354\\017\\004/\\234\\2113Q[\\\\q\\205\\015 \\204\\023_\\217\\355\\350\\250\\302\\326*\\260p\\236\\004''%\\332r\\265N\\3300\\202\\022H\\017\\227\\350\\007b\\021%\\201\\031\\276\\036w\\3028\\020x\\221\\202Z/\\251]A\\005\\037\\2320\\302Y\\237\\320\\306\\307\\255\\017 \\320\\020\\002\\203L\\324\\214\\035\\021+@IKc\\005\\373\\206\\012\\347\\015\\310\\002\\313M\\215\\342\\250\\001\\032\\030 \\302\\347"dPY"0\\242PY\\014)T=\\216\\2061\\241\\364\\302\\007\\037\\206\\030\\301\\210\\351\\304\\026\\377\\225\\006\\024\\020@\\001\\005+\\276\\270\\002\\005\\264\\032\\020\\240\\011\\274\\200\\240!B \\237ie\\313\\303dN\\346SE\\216i\\301+\\210m`!/\\036\\230PuLmD\\000\\201-/(H\\014\\234\\242X\\340\\234DE\\036\\202\\330\\230\\364\\034P\\301y\\037(\\300K\\025\\037x\\260\\300\\307O\\2500\\204\\242/8`\\210\\005\\204\\220\\212\\010T\\341\\234Z\\211\\011\\026\\261P\\200\\207v0\\202\\013xeM\\003\\350\\211\\011\\260\\205\\032\\014\\\\\\340\\002\\301\\270\\000\\010\\342\\327\\250A\\014\\240\\031\\244\\360\\003=\\370\\342\\004\\023\\300\\314+\\037\\320\\200\\003J\\002\\001k\\220\\3504\\227\\333Z\\016T\\260\\223\\023p\\240D\\321a\\316\\371(\\200\\002\\012@\\305\\001~\\031\\201\\012\\274b\\203Nx\\257\\205\\305z\\3001\\312u\\270\\003\\330aJl\\032\\010\\326R@\\004\\017 @\\004/x[\\021\\311p(\\033h\\343 \\031#\\221\\243&\\322\\210H\\341\\252X\\016X\\206\\000\\274\\005\\002\\020\\224`\\001\\326+\\\\\\012T \\203Qy\\377e\\0046\\300\\240\\242\\240q\\030\\255@\\207U\\007\\310\\000\\003|\\230*\\350\\200DE\\253XL\\003^\\300\\217~\\220*\\027t`\\001J|\\021\\027B\\0000R\\222\\262\\300F\\022\\020\\000\\006\\204\\216E\\242\\023\\223b\\032\\240\\000:\\356\\252\\012P\\252B\\241\\366f\\016tx\\251\\024\\252\\031\\306\\000D\\307\\200\\011\\310\\322\\017\\266\\022\\205\\001*p\\203}\\370\\003\\004\\022\\200\\231\\006A\\0206m\\360\\321\\024\\216\\020\\200\\002\\2143!w\\374\\221S\\000L\\225b\\024 \\205k\\351\\346\\005\\315,\\032\\012j@1`\\230\\343p\\256L\\246a\\2343\\300\\331\\214\\257Rm\\244\\2065\\3751\\202\\032\\304K\\004%\\000\\317AX\\351\\013"X\\020\\023\\012p@3\\372\\340\\245\\304\\221\\317\\001 \\360\\233$U\\220\\222\\335\\024\\240d$\\260\\015\\277\\016\\342M\\2464\\205\\011gA\\213I\\004\\006\\260ap\\247:$\\340N\\015jP\\002I\\222\\240\\004*\\331\\320\\033$t\\001\\344\\020\\341"\\351\\232\\020\\007\\364\\320\\251\\2120\\204Du.\\260K\\006\\\\P\\202\\030d\\000\\006\\0358\\200\\013z\\003\\214#\\320\\2138z\\302\\240\\025\\273D\\010w9$:\\354\\342@C`\\260\\200\\026\\244\\254;\\013\\333N\\006\\360\\245\\250\\340\\200\\353 {JA\\3066\\306\\311\\000$@\\000\\206{\\303\\013H\\320\\201\\005\\270\\200\\004\\201P\\030T\\267\\203\\264\\361x\\340[\\037(i3\\215\\263\\223\\212)DA\\347RM\\0138p\\215\\030\\244A\\015-(\\031L\\241\\032\\004\\000;'
gnumed-server-22.14/Gnumed/sql/test-data/test_data-James_Kirk.sql-145-);
##############################################
gnumed-server-22.14/Gnumed/sql/v21-v22/dynamic/v22-clin-transfer_all_encounter_data.sql-52- EXECUTE format (
gnumed-server-22.14/Gnumed/sql/v21-v22/dynamic/v22-clin-transfer_all_encounter_data.sql:53: ''UPDATE %1$s SET %2$I = %3$L WHERE %2$I = %4$L'',
gnumed-server-22.14/Gnumed/sql/v21-v22/dynamic/v22-clin-transfer_all_encounter_data.sql-54- _fk_row.referencing_table,
##############################################
gnumed-server-22.14/Gnumed/sql/v21-v22/dynamic/v22-kwd-patient_media_export_icon.sql-11--- --------------------------------------------------------------
gnumed-server-22.14/Gnumed/sql/v21-v22/dynamic/v22-kwd-patient_media_export_icon.sql:12:delete from ref.keyword_expansion where keyword = '$$gnumed_patient_media_export_icon';
gnumed-server-22.14/Gnumed/sql/v21-v22/dynamic/v22-kwd-patient_media_export_icon.sql-13-
##############################################
gnumed-server-22.14/Gnumed/sql/v21-v22/dynamic/v22-kwd-patient_media_export_icon.sql-25--- --------------------------------------------------------------
gnumed-server-22.14/Gnumed/sql/v21-v22/dynamic/v22-kwd-patient_media_export_icon.sql:26:delete from ref.keyword_expansion where keyword = '$$gnumed_patient_media_export_icon_2';
gnumed-server-22.14/Gnumed/sql/v21-v22/dynamic/v22-kwd-patient_media_export_icon.sql-27-
##############################################
gnumed-server-22.14/Gnumed/sql/v21-v22/dynamic/v22-notifications-dynamic.sql-164- if _accessor_col = ''fk_encounter'' then -- retrieve identity PK via fk_encounter
gnumed-server-22.14/Gnumed/sql/v21-v22/dynamic/v22-notifications-dynamic.sql:165: _identity_accessor_SQL := ''select fk_patient from clin.encounter where pk = $1.fk_encounter limit 1'';
gnumed-server-22.14/Gnumed/sql/v21-v22/dynamic/v22-notifications-dynamic.sql-166- elsif _accessor_col = ''fk_identity'' then -- retrieve identity PK via fk_identity
##############################################
gnumed-server-22.14/Gnumed/sql/gmAudit.sql-64--- do simple schema revision tracking
gnumed-server-22.14/Gnumed/sql/gmAudit.sql:65:delete from gm_schema_revision where filename = '$RCSfile: gmAudit.sql,v $';
gnumed-server-22.14/Gnumed/sql/gmAudit.sql-66-insert into gm_schema_revision (filename, version) values ('$RCSfile: gmAudit.sql,v $', '$Revision: 1.15 $');
##############################################
gnumed-server-22.14/Gnumed/sql/gmOfficeData.sql-41--- do simple schema revision tracking
gnumed-server-22.14/Gnumed/sql/gmOfficeData.sql:42:delete from gm_schema_revision where filename='$RCSfile: gmOfficeData.sql,v $';
gnumed-server-22.14/Gnumed/sql/gmOfficeData.sql-43-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmOfficeData.sql,v $', '$Revision: 1.5 $');
##############################################
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-108-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'INFECTIOUS DISEASE OTHER/NOS','INFECTIOUS DISEASE OTHER/NOS','A20, A21, A22, A23, A24, A25, A26, A27, A28, A30, A31, A32, A38, A39.1, A39.2, A39.3, A39.4, A39.8, A39.9, A40, A41, A42, A43, A44, A48.0, A48.2, A48.3, A48.4, A48.8, A49, A59.8, A59.9, A64, A68, A69.2, A69.8, A69.9, A70, A74.8, A74.9, A75, A77, A78, A79, B37.7, B37.8, B37.9, B38, B39, B40, B41, B42, B43, B45, B46, B47, B48, B49, B55, B56, B57, B58.8, B58.9, B59, B60, B64, B89, B92, B94.8, B94.9, B95, B96, B99',NULL,'brucellosis, infection unspecified site, Lyme disease, mycoplasma, Q fever; rickettsial disease, scarlet fever, sexually transmitted disease NOS, thrush NOS, toxoplasmosis','meningococcal meningitis N71',NULL,NULL,1,'A78');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:109:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANCY NOS','MALIGNANCY NOS','C38.1, C38.2, C38.3, C38.8, C45.7, C45.9, C46.7, C46.8, C46.9, C76, C78, C79, C80, C97, D09.7, D09.9','histological evidence of malignancy','secondary/metastatic neoplasm when primary site is unknown, carcinomatosis (unknown primary)',NULL,'disease/condition of unspecified nature/site A99',NULL,1,'A79');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-110-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'TRAUMA/INJURY NOS','TRAUMA/INJURY NOS','S11, S15, S21, S25, S26, S27, S35, S37.9, S38.1, S38.3, S39, S45, S55, S65, S75, S85, S95, T09, T14.5, T14.7, T14.8, T14.9, T28.4, T28.9',NULL,'road traffic accident','multiple trauma A81; late effect of trauma A82',NULL,NULL,1,'A80');
##############################################
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-179-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'LYMPHADENITIS CHRONIC/NON-SPECIFIC','LYMPHADENITIS CHRONIC/NON-SPECIFIC','I88','enlarged tender lymph nodes present for more than 6 weeks; or demonstration of enlarged inflamed mesenteric lymph nodes by surgery/sonography/lymphography/otherwise','mesenteric lymphadenitis','acute lymphadenitis (except mesenteric) B70; acute lymphangitis S76','enlarged lymph node B02',NULL,1,'B71');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:180:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'HODGKIN''S DISEASE/LYMPHOMA','HODGKIN''S DISEASE/LYMPHOMA','C81, C82, C83, C84, C85','characteristic histologic appearance',NULL,NULL,'other malignant neoplasm blood/lymph B74; benign/unspecified neoplasm blood/lymph B75',NULL,1,'B72');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:181:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'LEUKAEMIA','LEUKAEMIA','C91, C92, C93, C94, C95','characteristic histologic appearance','all types of leukaemia',NULL,'benign/unspecified neoplasm blood/lymph B75',NULL,1,'B73');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:182:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'BENIGN/UNSPECIFIED NEOPLASM BLOOD','BENIGN/UNSPECIFIED NEOPLASM BLOOD','D15.0, D36.0, D45, D47',NULL,'benign neoplasm blood, neoplasm blood not specified as benign or malignant/when test is not available; polycythaemia rubra vera',NULL,NULL,NULL,1,'B75');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-183-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'RUPTURED SPLEEN TRAUMATIC','RUPTURED SPLEEN TRAUMATIC','S36.0',NULL,NULL,NULL,NULL,NULL,1,'B76');
##############################################
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-268-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'GASTROENTERITIS PRESUMED INFECTION','GASTROENTERITIS PRESUMED INFECTION','A09',NULL,'diarrhoea/vomiting presumed to be infective, dysentery NOS, food poisoning, gastric flu','irritable bowel syndrome D93; non-infective enteritis and gastroenteritis D94, D99',NULL,NULL,1,'D73');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:269:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM STOMACH','MALIGNANT NEOPLASM STOMACH','C16','characteristic histological appearance','carcinoma stomach',NULL,'other malignant digestive neoplasm (when primary site is uncertain) D77; benign/unspecified digestive neoplasm D78',NULL,1,'D74');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:270:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM COLON/RECTUM','MALIGNANT NEOPLASM COLON/RECTUM','C18, C19, C20, C21','characteristic histological appearance',NULL,NULL,'other digestive malignant neoplasm (when primary site is uncertain) D77; benign/unspecified digestive neoplasm D78',NULL,1,'D75');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:271:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM PANCREAS','MALIGNANT NEOPLASM PANCREAS','C25','characteristic histological appearance','carcinoma pancreas',NULL,'other digestive malignant neoplasm (when primary site is unknown) D77; benign/unspecified digestive neoplasm D78',NULL,1,'D76');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:272:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT DIGESTIVE NEOPLASM OTHER/NOS','MALIGNANT DIGESTIVE NEOPL OTHER/NOS','C00, C01, C02, C03, C04, C05, C06, C07, C08, C14.8, C15, C17, C22, C23, C24, C26, C45.1, C46.2, C48',NULL,'all other primary malignancies of digestive system, gallbladder cancer, liver cancer','malignancy of stomach, colon/rectum, pancreas D74-76; secondary malignancy of known site (code to site); secondary malignancy of unknown site A79','benign/unspecified digestive neoplasm D78',NULL,1,'D77');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:273:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEOPLASM DIGESTIVE SYSTEM BENIGN/UNSPECIFIED','NEOPLASM DIGESTIVE BENIGN/UNSPECIF','D00, D01, D10, D11, D12, D13, D20, D37, D48.3, D48.4, K62.0, K62.1',NULL,'benign digestive neoplasm/digestive neoplasm not specified as benign or malignant/when histology is not available, polyp of stomach, duodenum, colon, rectum',NULL,NULL,NULL,1,'D78');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-274-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'FOREIGN BODY DIGESTIVE SYSTEM','FOREIGN BODY DIGESTIVE SYSTEM','T18',NULL,'foreign body swallowed/in digestive tract, including mouth, oesophagus, rectum','foreign body in throat/inhaled R87',NULL,NULL,1,'D79');
##############################################
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-357-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'EYE INFECTION/INFLAMMATION OTHER','EYE INFECTION/INFLAMMATION OTHER','B00.5, B58.0, H03, H04.3, H04.4, H05.0, H05.1, H16.1, H16.2, H16.3, H16.4, H16.8, H16.9, H20, H21, H22, H30, H32',NULL,'dacryocystitis, herpes simplex of eye without corneal ulcer, infammation of the orbit, iritis, iridocyclitis, keratitis','measles keratitis A71; corneal ulcer (herpes) F85, trachoma F86; herpes zoster S70',NULL,NULL,1,'F73');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:358:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEOPLASM OF EYE/ADNEXA','NEOPLASM OF EYE/ADNEXA','C69, D09.2, D31, D48.7',NULL,'benign/malignant neoplasm of eye/adnexa',NULL,NULL,NULL,1,'F74');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-359-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'CONTUSION/HAEMORRHAGE EYE','CONTUSION/HAEMORRHAGE EYE','H11.3, S00.1, S05.1',NULL,'black eye, hyphaema, subconjunctival haemorrhage','corneal ulcer F85',NULL,NULL,1,'F75');
##############################################
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-506- fever, but without any other demonstrable cause','chorea, mitral stenosis',NULL,'heart valve disease K83; other heart disease K84',NULL,1,'K71');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:507:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEOPLASM CARDIOVASCULAR','NEOPLASM CARDIOVASCULAR','C38.0, C45.2, D15.1, D15.2, D48.7',NULL,'benign/malignant cardiovascular neoplasm','haemangioma S81',NULL,NULL,1,'K72');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-508-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'CONGENITAL ANOMALY CARDIOVASCULAR','CONGENITAL ANOMALY CARDIOVASCULAR','Q20, Q21, Q22, Q23, Q24, Q25, Q26, Q27, Q28',NULL,'atrial/ventricular septal defect, Fallot''s tetralogy, patent ductus arteriosa','haemangioma S81',NULL,NULL,1,'K73');
##############################################
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-597-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'INFECTIONS OF MUSCULOSKELETAL SYSTEM','INFECTIONS OF MUSCULOSKELETAL SYSTEM','M00, M01, M46.2, M46.3, M46.4, M46.5, M60.0, M65.0, M65.1, M71.0, M71.1, M86','infections localized in musculoskeletal system','infective tenosynovitis, osteomyelitis, pyogenic arthritis','Reiter''s disease L99; late effect of polio N70',NULL,NULL,1,'L70');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:598:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM MUSCULOSKELETAL','MALIGNANT NEOPLASM MUSCULOSKELETAL','C40, C41, C49','characteristic histological appearance','fibrosarcoma, osteosarcoma','secondary neoplasms (code to original site), benign/unspecified musculoskeletal neoplasm L97',NULL,NULL,1,'L71');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-599-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'FRACTURE: RADIUS/ULNA','FRACTURE: RADIUS/ULNA','S52','imaging evidence of a fracture; or trauma plus visible/palpable deformity or crepitus involving the bone','Colles'' fracture','pathological fracture L95, L99; non-union L99','arm symptoms L09; musculoskeletal injury NOS L81',NULL,1,'L72');
##############################################
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-621-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'ACUTE INTERNAL DAMAGE KNEE','ACUTE INTERNAL DAMAGE KNEE','S83.2, S83.3, S83.5, S83.7','an initial injury which occurred no longer than one month previously and demonstration of ligament/meniscus tear by surgery/arthroscopy/imaging, or by locking/giving way, pain, and swelling of knee','acute damage to meniscus/cruciate ligaments','acute damage to collateral ligaments L78; dislocation of patella L80; chronic internal damage to knee L99','knee symptom L15; sprain of knee L78',NULL,1,'L96');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:622:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEOPLASM BENIGN/UNSPECIFIED MUSCULOSKELETAL','NEOPLASM BENIGN/UNSPECIF MUSCULOSKEL','D16, D21, D48.0, D48.1',NULL,'benign musculoskeletal neoplasm, musculoskeletal neoplasm not specified as benign or malignant/when histology is not available','malignant musculoskeletal neoplasm L71',NULL,NULL,1,'L97');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-623-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'ACQUIRED DEFORMITY OF LIMB','ACQUIRED DEFORMITY OF LIMB','M20, M21',NULL,'bunion, genu valgum-varum, hallux valgus/varus, mallet finger, pes planus (flatfoot)','general congenital deformities and anomalies A90; musculoskeletal deformities and anomalies L82',NULL,NULL,1,'L98');
##############################################
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-685-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEUROLOGICAL INFECTION OTHER','NEUROLOGICAL INFECTION OTHER','A81, A88.8, A89, G06, G07, G08, G09',NULL,'cerebral abscess, slow virus infection','poliomyelitis N70; meningitis/encephalitis N71; acute polyneuritis N94',NULL,NULL,1,'N73');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:686:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM NERVOUS SYSTEM','MALIGNANT NEOPLASM NERVOUS SYSTEM','C47, C70, C71, C72','characteristic histological appearance',NULL,NULL,'unspecified neoplasm nervous system N76',NULL,1,'N74');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:687:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'BENIGN NEOPLASM NERVOUS SYSTEM','BENIGN NEOPLASM NERVOUS SYSTEM','D32, D33, D36.1',NULL,'acoustic neuroma, meningioma',NULL,NULL,NULL,1,'N75');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:688:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEOPLASM NERVOUS SYSTEM UNSPECIFIED','NEOPLASM NERVOUS SYSTEM UNSPECIFIED','D42, D43, D48.2',NULL,'neoplasm nervous system not specified as benign or malignant/when histology is not available','neurofibromatosis A90',NULL,NULL,1,'N76');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-689-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'HEAD INJURY OTHER','HEAD INJURY OTHER','S02.0, S02.1, S06.1, S06.2, S06.3, S06.4, S06.5, S06.6, S06.7, S06.8, S06.9, S07, S08, S09.0, S09.7, S09.8','trauma to the head, complicated by cerebral damage','cerebral contusion, cerebral injury with/without skull fracture, extradural haematoma, subdural haematoma, traumatic intracranial haemorrhage','concussion N79',NULL,NULL,1,'N80');
##############################################
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-862-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'RESPIRATORY INFECTION OTHER','RESPIRATORY INFECTION OTHER','A36, B37.1, B44, B58.3, J05.1, J31, J37, J85, J86',NULL,'chronic nasopharyngitis, chronic pharyngitis, chronic rhinitis NOS, diphtheria, empyema, epiglottitis, fungal respiratory infection, lung abscess, protozoal infection (without pneumonia)','cystic fibrosis T99',NULL,NULL,1,'R83');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:863:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM BRONCHUS/LUNG','MALIGNANT NEOPLASM BRONCHUS/LUNG','C33, C34','characteristic histologic appearance','malignancy of trachea/bronchus/lung','malignancy of unknown site A79; a secondary malignancy from known site to be coded to site','unspecified respiratory neoplasm R92',NULL,1,'R84');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:864:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM RESPIRATORY OTHER','MALIGNANT NEOPL RESPIRATORY OTHER','C09, C10, C11, C12, C13, C14.0, C14.2, C30.0, C31, C32, C38.4, C39, C45.0','characteristic histologic appearance','malignancy of larynx/mediastinum/nose/pharynx/pleura/sinus, mesothelioma','Hodgkin''s disease B72, malignancy of trachea/bronchus/lung R84','unspecified respiratory neoplasm R92',NULL,1,'R85');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:865:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'BENIGN NEOPLASM RESPIRATORY','BENIGN NEOPLASM RESPIRATORY','D14, D19','characteristic clinical or histologic appearance',NULL,'unspecified respiratory neoplasm R92; nasal polyp R99','unspecified respiratory neoplasm R92',NULL,1,'R86');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-866-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'FOREIGN BODY NOSE/LARYNX/BRONCHUS','FOREIGN BODY NOSE/LARYNX/BRONCHUS','T17','visualization of foreign body directly/endoscopically/using imaging','foreign body in lung','drowning A88; foreign body lodged in oesophagus D79; foreign body in ear H76; aspiration pneumonia R99','other complaint of respiratory system R29',NULL,1,'R87');
##############################################
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-870-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'moved to R79',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'R91');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:871:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEOPLASM RESPIRATORY UNSPECIFIED','NEOPLASM RESPIRATORY UNSPECIFIED','D02, D38',NULL,'respiratory neoplasm unspecified as benign or malignant/when histology is not available','secondary neoplasm unknown site A79; malignant respiratory neoplasm R84, R85; benign respiratory neoplasm R86',NULL,NULL,1,'R92');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-872-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'deleted, included with R82',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'R93');
##############################################
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-953-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'SKIN INFECTION OTHER','SKIN INFECTION OTHER','A46, A66, A67, L03.1, L03.2, L03.3, L03.8, L03.9, L08, L98.0',NULL,'cellulitis, erysipelas, pyoderma, strep skin infection','boil/carbuncle/other localized skin infection S11; impetigo S84; molluscum contagiosum S95; acne S96',NULL,NULL,1,'S76');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:954:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM OF SKIN','MALIGNANT NEOPLASM OF SKIN','C43, C44, C46.0, C46.1','characteristic histological appearance','basal cell carcinoma, malignant melanoma, rodent ulcer, squamous cell carcinoma of skin','premalignant lesion of skin S79','other malignant neoplasm (when primary site is uncertain) A79; neoplasm of skin unspecified as benign or malignant/when histology is not available S79',NULL,1,'S77');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-955-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'LIPOMA','LIPOMA','D17',NULL,NULL,NULL,NULL,NULL,1,'S78');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:956:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEOPLASM SKIN BENIGN/UNSPECIFIED','NEOPLASM SKIN BENIGN/UNSPECIFIED','D03, D04, D23, D48.5',NULL,'benign skin neoplasm/skin neoplasm not specified as benign or malignant/when histology is not available, dermoid cyst, premalignant lesion','residual haemorrhoidal skin tag K96; solar keratosis S80; haemangioma S81; mole/pigmented nevus S82; keloid, hyperkeratosis, seborrhoeic/senile warts S99',NULL,NULL,1,'S79');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-957-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'SOLAR KERATOSIS/SUNBURN','SOLAR KERATOSIS/SUNBURN','L55, L56, L57, L58, L59',NULL,'photosensitivity, radiation skin damage, senile keratosis, solar hyperkeratosis, polymorphous light eruption','skin damage due to man made radiation A87, A88',NULL,NULL,1,'S80');
##############################################
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1030-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'ENDOCRINE INFECTION','ENDOCRINE INFECTION','E06.0',NULL,NULL,'thyroiditis T99',NULL,NULL,1,'T70');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1031:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM THYROID','MALIGNANT NEOPLASM THYROID','C73','characteristic histological appearance',NULL,NULL,'other/unspecified endocrine neoplasm T73; goitre T81',NULL,1,'T71');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1032:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'BENIGN NEOPLASM THYROID','BENIGN NEOPLASM THYROID','D34',NULL,NULL,'other/unspecified endocrine neoplasm T73; goitre T81',NULL,NULL,1,'T72');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1033:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEOPLASM ENDOCRINE OTHER/UNSPECIFIED','NEOPLASM ENDOCRINE OTHER/UNSPECIFIED','C74, C75, D09.3, D35, D44',NULL,'other endocrine neoplasm/endocrine neoplasm not specified as benign or malignant/when histology is not available',NULL,NULL,NULL,1,'T73');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1034-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'THYROGLOSSAL DUCT/CYST','THYROGLOSSAL DUCT/CYST','Q89.2',NULL,NULL,'goitre T81',NULL,NULL,1,'T78');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1035-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'CONGENITAL ANOMALY ENDOCRINE/METABOLIC','CONGEN ANOMALY ENDOCRINE/METABOLIC','E00, Q89.1, Q89.2',NULL,'cretinism, dwarfism','thyroglossal duct (cyst) T78',NULL,NULL,1,'T80');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1036:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'GOITRE','GOITRE','E04',NULL,'non-toxic goitre, thyroid nodule','neoplasm of thyroid gland T71-T73; thyroglossal cyst T78; toxic goitre T85; hypothyroidism T86',NULL,NULL,1,'T81');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1037-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'OBESITY','OBESITY','E66','a body mass index greater than 30',NULL,'overweight T83',NULL,NULL,1,'T82');
##############################################
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1106-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'URETHRITIS','URETHRITIS','A56.2, B37.4, N34','urethral discharge with frequency, burning, pain or urgency on urination without bacteriuria by microscopy or culture; or inflammation of external urinary meatus','chlamydial urethritis, nonspecific urethritis, urethral syndrome, meatitis','gonococcal urethritis female X71; urethritis trichomonal, female X73; gonococcal urethritis male Y71','painful urination U01; frequent/urgent urination U02; irritable bladder U13; urethral discharge X29, Y03',NULL,1,'U72');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1107:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM OF KIDNEY','MALIGNANT NEOPLASM OF KIDNEY','C64, C65','characteristic histologic appearance',NULL,NULL,'neoplasm urinary tract NOS U79',NULL,1,'U75');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1108:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM OF BLADDER','MALIGNANT NEOPLASM OF BLADDER','C67','characteristic histologic appearance',NULL,NULL,'neoplasm urinary tract NOS U79',NULL,1,'U76');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1109:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM URINARY OTHER','MALIGNANT NEOPLASM URINARY OTHER','C66, C68','characteristic histologic appearance','malignant neoplasm ureter, malignant neoplasm urethra','malignant neoplasm prostate Y77','neoplasm urinary tract NOS U79',NULL,1,'U77');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1110:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEOPLASM URINARY TRACT NOS','NEOPLASM URINARY TRACT NOS','D09.0, D09.1, D41',NULL,'bladder/kidney/ureter/urethra neoplasm NOS','histologically proven urinary tract neoplasms U75, U76, U77, U78',NULL,NULL,1,'U79');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1111-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'INJURY URINARY TRACT','INJURY URINARY TRACT','S37.0, S37.1, S37.2, S37.3, T19.0, T19.1, T28.3, T28.8',NULL,'contusion kidney, foreign body in urinary tract',NULL,NULL,NULL,1,'U80');
##############################################
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1177-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'INFECTION COMPLICATING PREGNANCY','INFECTION COMPLICATING PREGNANCY','O23, O41.1, O75.2, O75.3, O86.2, O86.4, O86.8, O98',NULL,NULL,'puerperal infection W70; puerperal mastitis W94',NULL,NULL,1,'W71');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1178:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM RELATED TO PREGNANCY','MALIGNANT NEOPL RELATED TO PREGNANCY','C58',NULL,'chorioepithelioma, choriocarcinoma',NULL,NULL,NULL,1,'W72');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1179:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'BENIGN/UNSPECIFIED NEOPLASM RELATED TO PREGNANCY','BENIGN/UNSPECIF NEOPL RELAT TO PREGN','O01',NULL,'hydatidiform mole',NULL,NULL,NULL,1,'W73');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1180-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'INJURY COMPLICATING PREGNANCY','INJURY COMPLICATING PREGNANCY','T14.9',NULL,'results of injury interfering with pregnancy','new injury caused by childbirth W92, W93',NULL,NULL,1,'W75');
##############################################
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1271-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'PELVIC INFLAMMATORY DISEASE','PELVIC INFLAMMATORY DISEASE','N70, N71, N73, N74','lower abdominal pain with marked tenderness of uterus or adnexa by palpation, plus other evidence of inflammation','endometritis, oophoritis, salpingitis','sexually transmitted diseases female X70-X73; chlamydia infection female X92','pelvic congestion syndrome X99',NULL,1,'X74');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1272:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM CERVIX','MALIGNANT NEOPLASM CERVIX','C53, D06','characteristic histological appearance','carcinoma-in-situ cervix, cervical intraepithelial neoplasia (CIN) grade 3','abnormal cervix smear (CIN) grades 1 and 2 X86',NULL,NULL,1,'X75');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1273:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM BREAST FEMALE','MALIGNANT NEOPLASM BREAST FEMALE','C50','characteristic histological appearance','carcinoma-in-situ female breast, intraductal carcinoma',NULL,'breast lump X19',NULL,1,'X76');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1274:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM GENITAL FEMALE OTHER','MALIGNANT NEOPL GENITAL FEMALE OTHER','C51, C52, C54, C55, C56, C57','characteristic histological appearance','malignancy of adnexae, ovaries, uterus, vagina, vulva','carcinoma-in-situ cervix X75; other female genital carcinoma-in-situ X81','other/unspecified female genital neoplasm X81',NULL,1,'X77');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1275-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'FIBROMYOMA UTERUS','FIBROMYOMA UTERUS','D25','enlargement of the uterus not due to pregnancy or malignancy, with single or multiple firm tumours of the uterus','fibroid uterus, fibromyoma of cervix, myoma',NULL,NULL,NULL,1,'X78');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1276:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'BENIGN NEOPLASM FEMALE GENITAL','BENIGN NEOPLASM FEMALE GENITAL','D26, D27, D28',NULL,NULL,'polyp of cervix X85; physiological cyst of ovary X99',NULL,NULL,1,'X80');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1277:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'GENITAL NEOPLASM FEMALE OTHER/UNSPECIFIED','GENITAL NEOPL FEMALE OTHER/UNSPECIF','D05, D07.0, D07.1, D07.2, D07.3, D39, D48.6',NULL,'other carcinoma-in-situ','carcinoma-in-situ cervix X75; endometrial polyp X99',NULL,NULL,1,'X81');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1278-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'INJURY GENITAL FEMALE','INJURY GENITAL FEMALE','S30.2, S31.4, S31.5, S37.4, S37.5, S37.6, S38.0, S38.2, T19.2, T19.3, T28.3, T28.8',NULL,'foreign body in vagina, female circumcision','genital injury due to childbirth W92, W93',NULL,NULL,1,'X82');
##############################################
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1351-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'CONDYLOMATA ACUMINATA MALE','CONDYLOMATA ACUMINATA MALE','A63.0','characteristic appearance of lesions, or characteristic histological appearance','venereal warts, human papilloma virus infection in men',NULL,NULL,NULL,1,'Y76');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1352:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM PROSTATE','MALIGNANT NEOPLASM PROSTATE','C61','characteristic histological appearance',NULL,NULL,'benign/unspecified neoplasm male genital Y79',NULL,1,'Y77');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1353:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM MALE GENITAL OTHER','MALIGN NEOPL MALE GENITAL OTHER','C50, C60, C62, C63','characteristic histological appearance','carcinoma testis/seminoma, carcinoma male breast',NULL,'benign/unspecified neoplasm male genital Y79',NULL,1,'Y78');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1354:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'BENIGN/UNSPECIFIED NEOPLASM MALE GENITAL','BENIGN/UNSPECIF NEOPL MALE GENITAL','D07.4, D07.5, D07.6, D24, D29, D40, D48.6',NULL,'benign male genital neoplasm, neoplasm not specified as benign or malignant/when histology is not available, benign neoplasm male breast','prostatic hypertrophy Y85',NULL,NULL,1,'Y79');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1355-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'INJURY MALE GENITAL','INJURY MALE GENITAL','S30.2, S31.2, S31.3, S31.5, S38.0, S38.2, T28.3, T28.8',NULL,'circumcision',NULL,NULL,NULL,1,'Y80');
##############################################
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1443-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (6,'Other referral NEC','Other referral NEC',NULL,NULL,NULL,NULL,NULL,NULL,1,'H68');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1444:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'NEOPLASM OF EAR','NEOPLASM OF EAR','C30.1, D48.9',NULL,'benign/malignant neoplasm of ear','polyp ear H99; acoustic neuroma N75',NULL,NULL,1,'H75');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1445-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (1,'IRREGULAR HEARTBEAT OTHER','IRREGULAR HEARTBEAT OTHER','R00.8',NULL,NULL,'palpitations K04',NULL,NULL,1,'K05');
##############################################
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1463-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (1,'POST-PARTUM BLEEDING','POST-PARTUM BLEEDING','O72','heavy bleeding at or within 6 weeks of parturition',NULL,NULL,'other post-partum complaints W18',NULL,1,'W17');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1464:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'MALIGNANT NEOPLASM BLOOD OTHER','MALIGNANT NEOPLASM BLOOD OTHER','C37, C46.3, C77, C88, C90, C96',NULL,'myeloproliferative disease, multiple myeloma','Hodgkin''s disease/lymphoma B72',NULL,NULL,1,'B74');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1465-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'DIABETES INSULIN DEPENDENT','DIABETES INSULIN DEPENDENT','E10','patient requiring regular ongoing treatment with insulin after diagnosis confirmed by one of the following:(a) the classic symptoms of diabetes, such as polyuria, polydypsia, and rapid weight loss, together with unequivocal elevation of plasma glucose (b) fasting blood glucose levels of 8mmol/l (l40mg/dl) or more on two or more occasions (c) random blood glucose levels of 11mmol/l (200mg/dl) or more on two or more occasions (d) an oral Glucose Tolerance Test (75gm glucose) with one value of plasma glucose at between one and two hours of 11mmol/l (200mg/dl) or more, and plasma glucose at two hours of 11mol/l (200mg/dl) or more;\n
##############################################
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1469-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (1,'FEAR OF BREAST CANCER FEMALE','FEAR OF BREAST CANCER FEMALE','Z71.1','concern about/fear of female breast cancer in a patient without the disease/until the diagnosis is proven',NULL,'if patient has the disease, code the disease',NULL,NULL,1,'X26');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1470:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'BENIGN NEOPLASM BREAST FEMALE','BENIGN NEOPLASM BREAST FEMALE','D24','characteristic histological appearance','fibroadenoma female breast','cystic disease of breast X88','lump in breast X19',NULL,1,'X79');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1471-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'CONDYLOMATA ACUMINATA FEMALE','CONDYLOMATA ACUMINATA FEMALE','A63.0','characteristic appearance of lesions, or characteristic histological appearance','venereal warts, human papilloma virus infection',NULL,NULL,NULL,1,'X91');
##############################################
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1473-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (1,'FEAR OF SEXUAL DYSFUNCTION MALE','FEAR OF SEXUAL DYSFUNCTION MALE','Z71.1','concern about/fear of sexual dysfunction in a patient without the condition',NULL,'if the patient has sexual dysfunction, code the condition',NULL,NULL,1,'Y24');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql:1474:INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (7,'BENIGN NEOPLASM URINARY TRACT','BENIGN NEOPLASM URINARY TRACT','D30','characteristic histologic appearance','bladder papilloma, polyp of urinary tract','prostatic hypertrophy Y85','neoplasm urinary tract NOS U79',NULL,1,'U78');
gnumed-server-22.14/Gnumed/sql/v15-ref-icpc2-data.sql-1475-INSERT INTO staging.icpc (COMPONENT, DESCRIPTION, SHORT, ICD_10, CRIT, INCL, EXCL, CONS, NOTE, icpc, CODE) VALUES (1,'SYMPTOM/COMPLAINT MUSCULOSKELETAL OTHER','SYMPT/COMPLT MUSCULOSKELETAL OTHER','R29.3, R29.8',NULL,'''growing pains'' in a child','clubbing of fingernails S22',NULL,NULL,1,'L29');
##############################################
gnumed-server-22.14/Gnumed/sql/v9-v10/dynamic/v10-i18n-dynamic.sql-30-BEGIN
gnumed-server-22.14/Gnumed/sql/v9-v10/dynamic/v10-i18n-dynamic.sql:31: perform 1 from pg_user where usename = $1;
gnumed-server-22.14/Gnumed/sql/v9-v10/dynamic/v10-i18n-dynamic.sql-32-
##############################################
gnumed-server-22.14/Gnumed/sql/v9-v10/dynamic/v10-i18n-dynamic.sql-61-BEGIN
gnumed-server-22.14/Gnumed/sql/v9-v10/dynamic/v10-i18n-dynamic.sql:62: delete from i18n.curr_lang where db_user = $1;
gnumed-server-22.14/Gnumed/sql/v9-v10/dynamic/v10-i18n-dynamic.sql-63- return;
##############################################
gnumed-server-22.14/Gnumed/sql/v9-v10/dynamic/v10-i18n-dynamic.sql-138- language sql
gnumed-server-22.14/Gnumed/sql/v9-v10/dynamic/v10-i18n-dynamic.sql:139: as 'select lang from i18n.curr_lang where db_user = $1'
gnumed-server-22.14/Gnumed/sql/v9-v10/dynamic/v10-i18n-dynamic.sql-140-;
##############################################
gnumed-server-22.14/Gnumed/sql/v9-v10/fixups/v10-dem-identity-dob_trigger-fixup.sql-55- -- when was this fixup script imported
gnumed-server-22.14/Gnumed/sql/v9-v10/fixups/v10-dem-identity-dob_trigger-fixup.sql:56: select imported from gm_schema_revision where filename = ''$RCSfile: v10-dem-identity-dob_trigger-fixup.sql,v $''
gnumed-server-22.14/Gnumed/sql/v9-v10/fixups/v10-dem-identity-dob_trigger-fixup.sql-57- )
##############################################
gnumed-server-22.14/Gnumed/sql/v17-v18/fixups/v18-cfg-depreciated_placeholders-fixup.sql-44--- --------------------------------------------------------------
gnumed-server-22.14/Gnumed/sql/v17-v18/fixups/v18-cfg-depreciated_placeholders-fixup.sql:45:delete from cfg.report_query where label = 'Find keyword expansions possibly containing depreciated $<HINT>$ syntax';
gnumed-server-22.14/Gnumed/sql/v17-v18/fixups/v18-cfg-depreciated_placeholders-fixup.sql-46-
##############################################
gnumed-server-22.14/Gnumed/sql/v19-v20/dynamic/v20-notifications-dynamic.sql-162- if _accessor_col = ''fk_encounter'' then -- retrieve identity PK via fk_encounter
gnumed-server-22.14/Gnumed/sql/v19-v20/dynamic/v20-notifications-dynamic.sql:163: _identity_accessor_SQL := ''select fk_patient from clin.encounter where pk = $1.fk_encounter limit 1'';
gnumed-server-22.14/Gnumed/sql/v19-v20/dynamic/v20-notifications-dynamic.sql-164- elsif _accessor_col = ''fk_identity'' then -- retrieve identity PK via fk_identity
##############################################
gnumed-server-22.14/Gnumed/sql/v19-v20/dynamic/v20-clin-patient-dynamic.sql-71- from dem.identity d_i
gnumed-server-22.14/Gnumed/sql/v19-v20/dynamic/v20-clin-patient-dynamic.sql:72: where d_i.pk = $1;
gnumed-server-22.14/Gnumed/sql/v19-v20/dynamic/v20-clin-patient-dynamic.sql-73- ';
##############################################
gnumed-server-22.14/Gnumed/sql/v19-v20/dynamic/v20-clin-patient-dynamic.sql-81- language sql
gnumed-server-22.14/Gnumed/sql/v19-v20/dynamic/v20-clin-patient-dynamic.sql:82: as 'select deceased from dem.identity d_i where d_i.pk = $1;';
gnumed-server-22.14/Gnumed/sql/v19-v20/dynamic/v20-clin-patient-dynamic.sql-83-
##############################################
gnumed-server-22.14/Gnumed/sql/v19-v20/dynamic/v20-clin-patient-dynamic.sql-90--- language sql
gnumed-server-22.14/Gnumed/sql/v19-v20/dynamic/v20-clin-patient-dynamic.sql:91:-- as 'select gender from dem.identity d_i where d_i.pk = $1;';
gnumed-server-22.14/Gnumed/sql/v19-v20/dynamic/v20-clin-patient-dynamic.sql-92-
##############################################
gnumed-server-22.14/Gnumed/sql/v10-v11/dynamic/v11-cfg-report_query-dynamic.sql-49- -- when was this fixup script imported
gnumed-server-22.14/Gnumed/sql/v10-v11/dynamic/v11-cfg-report_query-dynamic.sql:50: select imported from gm.schema_revision where filename = ''$RCSfile: v11-cfg-report_query-dynamic.sql,v $''
gnumed-server-22.14/Gnumed/sql/v10-v11/dynamic/v11-cfg-report_query-dynamic.sql-51- )
##############################################
gnumed-server-22.14/Gnumed/sql/v10-v11/dynamic/v11-clin-keyword_expansion-data.sql-273--- --------------------------------------------------------------
gnumed-server-22.14/Gnumed/sql/v10-v11/dynamic/v11-clin-keyword_expansion-data.sql:274:delete from clin.keyword_expansion where keyword = '$checkup-gkv';
gnumed-server-22.14/Gnumed/sql/v10-v11/dynamic/v11-clin-keyword_expansion-data.sql-275-
##############################################
gnumed-server-22.14/Gnumed/sql/gmDemographics-Person-views.sql-435--- do simple schema revision tracking
gnumed-server-22.14/Gnumed/sql/gmDemographics-Person-views.sql:436:delete from gm_schema_revision where filename = '$RCSfile: gmDemographics-Person-views.sql,v $';
gnumed-server-22.14/Gnumed/sql/gmDemographics-Person-views.sql-437-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmDemographics-Person-views.sql,v $', '$Revision: 1.55 $');
##############################################
gnumed-server-22.14/Gnumed/sql/gmNotifications-static.sql-23--- do simple schema revision tracking
gnumed-server-22.14/Gnumed/sql/gmNotifications-static.sql:24:delete from gm_schema_revision where filename='$RCSfile: gmNotifications-static.sql,v $';
gnumed-server-22.14/Gnumed/sql/gmNotifications-static.sql-25-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmNotifications-static.sql,v $', '$Revision: 1.1 $');
##############################################
gnumed-server-22.14/Gnumed/sql/gmAudit-dynamic.sql-159--- keep the "true" !
gnumed-server-22.14/Gnumed/sql/gmAudit-dynamic.sql:160:delete from gm_schema_revision where filename = '$RCSfile: gmAudit-dynamic.sql,v $';
gnumed-server-22.14/Gnumed/sql/gmAudit-dynamic.sql-161-insert into gm_schema_revision (filename, version) values ('$RCSfile: gmAudit-dynamic.sql,v $', '$Revision: 1.8 $');
##############################################
gnumed-server-22.14/Gnumed/sql/v8-v9/dynamic/v9-i18n-dynamic.sql-13- language sql
gnumed-server-22.14/Gnumed/sql/v8-v9/dynamic/v9-i18n-dynamic.sql:14: as 'select lang from i18n.curr_lang where "user" = $1'
gnumed-server-22.14/Gnumed/sql/v8-v9/dynamic/v9-i18n-dynamic.sql-15-;
##############################################
gnumed-server-22.14/Gnumed/sql/v8-v9/dynamic/v9-clin-keyword_expansion-data.sql-17--- --------------------------------------------------------------
gnumed-server-22.14/Gnumed/sql/v8-v9/dynamic/v9-clin-keyword_expansion-data.sql:18:delete from clin.keyword_expansion where keyword = '$$kuss';
gnumed-server-22.14/Gnumed/sql/v8-v9/dynamic/v9-clin-keyword_expansion-data.sql-19-
##############################################
gnumed-server-22.14/Gnumed/sql/v18-v19/dynamic/v19-notifications-dynamic.sql-237- -- retrieve identity PK via fk_encounter
gnumed-server-22.14/Gnumed/sql/v18-v19/dynamic/v19-notifications-dynamic.sql:238: _identity_accessor_SQL := ''select fk_patient from clin.encounter where pk = $1.fk_encounter limit 1'';
gnumed-server-22.14/Gnumed/sql/v18-v19/dynamic/v19-notifications-dynamic.sql-239- elsif _accessor_col = ''fk_identity'' then
##############################################
gnumed-server-22.14/Gnumed/sql/gmConfigViews.sql-287--- do simple schema revision tracking
gnumed-server-22.14/Gnumed/sql/gmConfigViews.sql:288:delete from gm_schema_revision where filename='$RCSfile: gmConfigViews.sql,v $';
gnumed-server-22.14/Gnumed/sql/gmConfigViews.sql-289-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmConfigViews.sql,v $', '$Revision: 1.8 $');
##############################################
gnumed-server-22.14/Gnumed/sql/country.specific/es/gmDemographics-Data.es.sql-88--- do simple revision tracking
gnumed-server-22.14/Gnumed/sql/country.specific/es/gmDemographics-Data.es.sql:89:delete from gm_schema_revision where filename = '$RCSfile: gmDemographics-Data.es.sql,v $';
gnumed-server-22.14/Gnumed/sql/country.specific/es/gmDemographics-Data.es.sql-90-INSERT INTO gm_schema_revision (filename, version) VALUES ('$RCSfile: gmDemographics-Data.es.sql,v $', '$Revision: 1.7 $');
##############################################
gnumed-server-22.14/Gnumed/sql/country.specific/de/gmATC.sql-93--- do simple revision tracking
gnumed-server-22.14/Gnumed/sql/country.specific/de/gmATC.sql:94:delete from gm_schema_revision where filename = '$RCSfile: gmATC.sql,v $';
gnumed-server-22.14/Gnumed/sql/country.specific/de/gmATC.sql-95-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmATC.sql,v $', '$Revision: 1.3 $');
##############################################
gnumed-server-22.14/Gnumed/sql/country.specific/de/gmClinical.de.sql-48--- do simple revision tracking
gnumed-server-22.14/Gnumed/sql/country.specific/de/gmClinical.de.sql:49:delete from gm_schema_revision where filename='$RCSfile: gmClinical.de.sql,v $';
gnumed-server-22.14/Gnumed/sql/country.specific/de/gmClinical.de.sql-50-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmClinical.de.sql,v $', '$Revision: 1.17 $');
##############################################
gnumed-server-22.14/Gnumed/sql/country.specific/de/PLZ.sql-161--- do simple revision tracking
gnumed-server-22.14/Gnumed/sql/country.specific/de/PLZ.sql:162:delete from gm_schema_revision where filename = '$RCSfile: PLZ.sql,v $';
gnumed-server-22.14/Gnumed/sql/country.specific/de/PLZ.sql-163-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: PLZ.sql,v $', '$Revision: 1.13 $');
##############################################
gnumed-server-22.14/Gnumed/sql/country.specific/de/gmVornamen.sql-3435--- do simple revision tracking
gnumed-server-22.14/Gnumed/sql/country.specific/de/gmVornamen.sql:3436:delete from gm_schema_revision where filename = '$RCSfile: gmVornamen.sql,v $';
gnumed-server-22.14/Gnumed/sql/country.specific/de/gmVornamen.sql-3437-INSERT INTO gm_schema_revision (filename, version) VALUES ('$rcsfile: gmvornamen.sql,v $', '$Revision: 1.7 $');
##############################################
gnumed-server-22.14/Gnumed/sql/country.specific/de/gmDemographics-Data.de.sql-21--- do simple revision tracking
gnumed-server-22.14/Gnumed/sql/country.specific/de/gmDemographics-Data.de.sql:22:delete from gm_schema_revision where filename = '$RCSfile: gmDemographics-Data.de.sql,v $';
gnumed-server-22.14/Gnumed/sql/country.specific/de/gmDemographics-Data.de.sql-23-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmDemographics-Data.de.sql,v $', '$Revision: 1.6 $');
##############################################
gnumed-server-22.14/Gnumed/sql/country.specific/de/gmDiagnosen.sql-89--- do simple revision tracking
gnumed-server-22.14/Gnumed/sql/country.specific/de/gmDiagnosen.sql:90:delete from gm_schema_revision where filename = '$RCSfile: gmDiagnosen.sql,v $';
gnumed-server-22.14/Gnumed/sql/country.specific/de/gmDiagnosen.sql-91-INSERT INTO gm_schema_revision (filename, version) VALUES ('$RCSfile: gmDiagnosen.sql,v $', '$Revision: 1.5 $');
##############################################
gnumed-server-22.14/Gnumed/sql/country.specific/de/Impfplan-FSME.sql-95--- do simple revision tracking
gnumed-server-22.14/Gnumed/sql/country.specific/de/Impfplan-FSME.sql:96:delete from gm_schema_revision where filename = '$RCSfile: Impfplan-FSME.sql,v $';
gnumed-server-22.14/Gnumed/sql/country.specific/de/Impfplan-FSME.sql-97-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: Impfplan-FSME.sql,v $', '$Revision: 1.6 $');
##############################################
gnumed-server-22.14/Gnumed/sql/country.specific/au/gmDemographics.au.sql-84--- do simple schema revision tracking
gnumed-server-22.14/Gnumed/sql/country.specific/au/gmDemographics.au.sql:85:delete from gm_schema_revision where filename='$RCSfile: gmDemographics.au.sql,v $';
gnumed-server-22.14/Gnumed/sql/country.specific/au/gmDemographics.au.sql-86-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmDemographics.au.sql,v $', '$Revision: 1.15 $');
##############################################
gnumed-server-22.14/Gnumed/sql/country.specific/ca/gmDemographics-Data.ca.sql-45--- do simple revision tracking
gnumed-server-22.14/Gnumed/sql/country.specific/ca/gmDemographics-Data.ca.sql:46:delete from gm_schema_revision where filename = '$RCSfile: gmDemographics-Data.ca.sql,v $';
gnumed-server-22.14/Gnumed/sql/country.specific/ca/gmDemographics-Data.ca.sql-47-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmDemographics-Data.ca.sql,v $', '$Revision: 1.5 $');
##############################################
gnumed-server-22.14/Gnumed/sql/v15-v16/fixups/v16-i18n-fixup.sql-26- -- reduce xx_XX@YY to xx
gnumed-server-22.14/Gnumed/sql/v15-v16/fixups/v16-i18n-fixup.sql:27: select into trans_str trans from i18n.translations where lang = regexp_replace(_lang, ''_.*$'', '''') and orig = _orig;
gnumed-server-22.14/Gnumed/sql/v15-v16/fixups/v16-i18n-fixup.sql-28-
##############################################
gnumed-server-22.14/Gnumed/sql/gmDemographics-GIS-views.sql-488--- do simple schema revision tracking
gnumed-server-22.14/Gnumed/sql/gmDemographics-GIS-views.sql:489:delete from gm_schema_revision where filename='$RCSfile: gmDemographics-GIS-views.sql,v $';
gnumed-server-22.14/Gnumed/sql/gmDemographics-GIS-views.sql-490-INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmDemographics-GIS-views.sql,v $', '$Revision: 1.31 $');
##############################################
gnumed-server-22.14/Gnumed/gm-restore_database.sh-40- echo " ERROR: Cannot access backup file. Aborting."
gnumed-server-22.14/Gnumed/gm-restore_database.sh:41: echo " "`ls -al ${BACKUP}`
gnumed-server-22.14/Gnumed/gm-restore_database.sh-42- exit 1
##############################################
gnumed-server-22.14/Gnumed/gm-restore_database.sh-52- echo " ERROR: Cannot read configuration file ${CONF}. Aborting."
gnumed-server-22.14/Gnumed/gm-restore_database.sh:53: echo " "`ls -al ${CONF}`
gnumed-server-22.14/Gnumed/gm-restore_database.sh-54- exit 1
##############################################
gnumed-server-22.14/Gnumed/gm-restore_database.sh-88- echo " ERROR: Cannot copy backup file. Aborting."
gnumed-server-22.14/Gnumed/gm-restore_database.sh:89: echo " "`ls -al ${BACKUP}`
gnumed-server-22.14/Gnumed/gm-restore_database.sh-90- exit 1
##############################################
gnumed-server-22.14/Gnumed/gm-restore_database.sh-95-echo "==> Unpacking backup file ..."
gnumed-server-22.14/Gnumed/gm-restore_database.sh:96:BACKUP=${WORK_DIR}`basename ${BACKUP}`
gnumed-server-22.14/Gnumed/gm-restore_database.sh-97-if [[ "${BACKUP}" =~ .*\.bz2 ]] ; then
##############################################
gnumed-server-22.14/Gnumed/gm-restore_database.sh-105- fi
gnumed-server-22.14/Gnumed/gm-restore_database.sh:106: BACKUP=${WORK_DIR}`basename ${BACKUP} .bz2`
gnumed-server-22.14/Gnumed/gm-restore_database.sh-107-fi
##############################################
gnumed-server-22.14/Gnumed/gm-restore_database.sh-117-fi
gnumed-server-22.14/Gnumed/gm-restore_database.sh:118:BACKUP=${WORK_DIR}`basename ${BACKUP} .tar`
gnumed-server-22.14/Gnumed/gm-restore_database.sh-119-rm ${BACKUP}.tar
##############################################
gnumed-server-22.14/Gnumed/gm-restore_database.sh-137-echo "==> Checking target database status ..."
gnumed-server-22.14/Gnumed/gm-restore_database.sh:138:TARGET_DB=`head -n 40 ${BACKUP}-database.sql | grep -i "create database gnumed_v" | cut -f 3 -d " "`
gnumed-server-22.14/Gnumed/gm-restore_database.sh-139-if test $? -ne 0 ; then
##############################################
gnumed-server-22.14/Gnumed/gm-restore_database.sh-147-echo " db: ${TARGET_DB}"
gnumed-server-22.14/Gnumed/gm-restore_database.sh:148:if test `sudo -u postgres psql -l -p ${GM_PORT} | grep ${TARGET_DB} | wc -l` -ne 0 ; then
gnumed-server-22.14/Gnumed/gm-restore_database.sh-149- echo " ERROR: Target database ${TARGET_DB} already exists. Aborting."
##############################################
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html-102741- from dem.identity d_i
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html:102742: where d_i.pk = $1;
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html-102743- </pre>
##############################################
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html-102751-
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html:102752: <pre>select deceased from dem.identity d_i where d_i.pk = $1;</pre>
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html-102753-
##############################################
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html-103116- EXECUTE format (
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html:103117: 'UPDATE %1$s SET %2$I = %3$L WHERE %2$I = %4$L',
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html-103118- _fk_row.referencing_table,
##############################################
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html-124871- if _accessor_col = 'fk_encounter' then -- retrieve identity PK via fk_encounter
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html:124872: _identity_accessor_SQL := 'select fk_patient from clin.encounter where pk = $1.fk_encounter limit 1';
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html-124873- elsif _accessor_col = 'fk_identity' then -- retrieve identity PK via fk_identity
##############################################
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html-125394-BEGIN
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html:125395: perform 1 from pg_user where usename = $1;
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html-125396- if not FOUND then
##############################################
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html-125959- -- reduce xx_XX@YY to xx
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html:125960: select into trans_str trans from i18n.translations where lang = regexp_replace(_lang, '_.*$', '') and orig = _orig;
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html-125961- if not found then
##############################################
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html-126030-
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html:126031: <pre>select lang from i18n.curr_lang where db_user = $1</pre>
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html-126032-
##############################################
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html-126146-BEGIN
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html:126147: delete from i18n.curr_lang where db_user = $1;
gnumed-server-22.14/Gnumed/doc/schema/gnumed-entire_schema.html-126148- return;
##############################################
gnumed-server-22.14/Gnumed/gm-dump_schema.sh-83- echo "" >> ${BACKUP_FILENAME}-roles.sql 2> /dev/null
gnumed-server-22.14/Gnumed/gm-dump_schema.sh:84: ROLES=`psql -A -d ${TARGET_DB} -p ${GM_PORT} -U ${GM_DBO} -c "select gm.get_users('${TARGET_DB}');"`
gnumed-server-22.14/Gnumed/gm-dump_schema.sh-85- echo "-- ${ROLES}" >> ${BACKUP_FILENAME}-roles.sql 2> /dev/null
##############################################
gnumed-server-22.14/Gnumed/gm-dump_schema.sh-104- echo "" >> ${BACKUP_FILENAME}-roles.sql 2> /dev/null
gnumed-server-22.14/Gnumed/gm-dump_schema.sh:105: ROLES= `psql -A -d ${TARGET_DB} -p ${GM_PORT} -U ${GM_DBO} -c "select gm.get_users('${TARGET_DB}');"`
gnumed-server-22.14/Gnumed/gm-dump_schema.sh-106- echo "-- ${ROLES}" >> ${BACKUP_FILENAME}-roles.sql 2> /dev/null
##############################################
gnumed-server-22.14/Gnumed/gm-backup_data.sh-74-# are we backing up the latest DB ?
gnumed-server-22.14/Gnumed/gm-backup_data.sh:75:OUR_VER=`echo ${GM_DATABASE} | cut -f 2 -d v`
gnumed-server-22.14/Gnumed/gm-backup_data.sh-76-if test -z ${GM_HOST} ; then
gnumed-server-22.14/Gnumed/gm-backup_data.sh:77: HAS_HIGHER_VER=`sudo -u postgres psql -A -t -d ${GM_DATABASE} -p ${GM_PORT} -c "SELECT exists (select 1 from pg_database where datname like 'gnumed_v%' and substring(datname from 9 for 3)::integer > '${OUR_VER}');"`
gnumed-server-22.14/Gnumed/gm-backup_data.sh-78-else
gnumed-server-22.14/Gnumed/gm-backup_data.sh:79: HAS_HIGHER_VER=`sudo -u postgres psql -A -t -h ${GM_HOST} -d ${GM_DATABASE} -p ${GM_PORT} -c "SELECT exists (select 1 from pg_database where datname like 'gnumed_v%' and substring(datname from 9 for 3)::integer > '${OUR_VER}');"`
gnumed-server-22.14/Gnumed/gm-backup_data.sh-80-fi;
##############################################
gnumed-server-22.14/Gnumed/gm-pg_upgradecluster-helper-57-CMD="use PgCommon; \$p = get_cluster_port \"${OLD_VER}\", \"${CLUSTER_NAME}\"; print \"\$p\\n\""
gnumed-server-22.14/Gnumed/gm-pg_upgradecluster-helper:58:PORT=`perl -I/usr/share/postgresql-common/ -e "$CMD"`
gnumed-server-22.14/Gnumed/gm-pg_upgradecluster-helper-59-
##############################################
gnumed-server-22.14/Gnumed/gm-pg_upgradecluster-helper-66- CMD="use PgCommon; \$p = get_cluster_port \"${NEW_VER}\", \"${CLUSTER_NAME}\"; print \"\$p\\n\""
gnumed-server-22.14/Gnumed/gm-pg_upgradecluster-helper:67: PORT=`perl -I/usr/share/postgresql-common/ -e "$CMD"`
gnumed-server-22.14/Gnumed/gm-pg_upgradecluster-helper-68- echo "Accessing port: ${PORT}" >> ${LOG_FILE} 2>&1
##############################################
gnumed-server-22.14/Gnumed/gm-restore_data.sh-53-echo "==> Testing target database status ..."
gnumed-server-22.14/Gnumed/gm-restore_data.sh:54:if test `sudo -u postgres psql -l -p ${GM_PORT} | grep ${TARGET_DB} | wc -l` -eq 0 ; then
gnumed-server-22.14/Gnumed/gm-restore_data.sh-55- echo " ERROR: Target database ${TARGET_DB} does not exist. Aborting."
##############################################
gnumed-server-22.14/Gnumed/gm-restore_data.sh-101-echo "==> Unpacking backup file ..."
gnumed-server-22.14/Gnumed/gm-restore_data.sh:102:BACKUP=${WORK_DIR}/`basename ${BACKUP}`
gnumed-server-22.14/Gnumed/gm-restore_data.sh-103-if [[ "$BACKUP" =~ .*\.bz2 ]] ; then
##############################################
gnumed-server-22.14/Gnumed/gm-restore_data.sh-108- fi
gnumed-server-22.14/Gnumed/gm-restore_data.sh:109: BACKUP=`basename ${BACKUP} .bz2`
gnumed-server-22.14/Gnumed/gm-restore_data.sh-110-fi
##############################################
gnumed-server-22.14/Gnumed/gm-restore_data.sh-115-fi
gnumed-server-22.14/Gnumed/gm-restore_data.sh:116:BACKUP=`basename ${BACKUP} .tar`
gnumed-server-22.14/Gnumed/gm-restore_data.sh-117-
##############################################
gnumed-server-22.14/Gnumed/gm-backup.sh-156-# -r -> -g for older versions
gnumed-server-22.14/Gnumed/gm-backup.sh:157:#ROLES=`psql --no-psqlrc --no-align --tuples-only --dbname="${GM_DATABASE}" ${_PG_HOST_ARG} ${_PG_PORT_ARG} --username="${GM_DBO}" --command="select gm.get_users('${GM_DATABASE}');"`
gnumed-server-22.14/Gnumed/gm-backup.sh-158-ROLES=$(psql --no-psqlrc --no-align --tuples-only --dbname="${GM_DATABASE}" ${_PG_HOST_ARG} ${_PG_PORT_ARG} --username="${GM_DBO}" --command="select gm.get_users('${GM_DATABASE}');")
##############################################
gnumed-server-22.14/Gnumed/bootstrap/upgrade-db.sh-94- TEMPLATE_DB="gnumed_v${PREV_VER}"
gnumed-server-22.14/Gnumed/bootstrap/upgrade-db.sh:95: VER_EXISTS=`su -c "psql -l ${PORT_DEF}" -l postgres | grep ${TEMPLATE_DB}`
gnumed-server-22.14/Gnumed/bootstrap/upgrade-db.sh-96- if test "${VER_EXISTS}" == "" ; then
##############################################
gnumed-server-22.14/Gnumed/bootstrap/upgrade-db.sh-136- # Does TARGET database exist ?
gnumed-server-22.14/Gnumed/bootstrap/upgrade-db.sh:137: VER_EXISTS=`su -c "psql -l ${PORT_DEF}" -l postgres | grep gnumed_v${NEXT_VER}`
gnumed-server-22.14/Gnumed/bootstrap/upgrade-db.sh-138- if test "${VER_EXISTS}" != "" ; then
##############################################
gnumed-server-22.14/Gnumed/bootstrap/bootstrap-latest.sh-51-for DB_VER in ${ALL_PREV_VERS} ; do
gnumed-server-22.14/Gnumed/bootstrap/bootstrap-latest.sh:52: VER_EXISTS=`su -c "psql -l ${PORT_DEF}" -l postgres | grep gnumed_v${DB_VER}`
gnumed-server-22.14/Gnumed/bootstrap/bootstrap-latest.sh-53- if test "${VER_EXISTS}" != "" ; then
##############################################
gnumed-server-22.14/Gnumed/bootstrap/bootstrap_gm_db_system.py-1237- RAISE NOTICE 'validating [%] on [%.%]', r.conname, r.nspname, r.relname;
gnumed-server-22.14/Gnumed/bootstrap/bootstrap_gm_db_system.py:1238: EXECUTE 'UPDATE pg_constraint SET convalidated=false WHERE conname=$1 AND connamespace=$2 AND conrelid=$3' USING r.conname, r.connamespace, r.conrelid;
gnumed-server-22.14/Gnumed/bootstrap/bootstrap_gm_db_system.py-1239- EXECUTE 'ALTER TABLE ' || r.nspname || '.' || r.relname || ' VALIDATE CONSTRAINT "' || r.conname || '"';
##############################################
gnumed-server-22.14/Gnumed/gm-restore.sh-40- echo " ERROR: Cannot access backup file. Aborting."
gnumed-server-22.14/Gnumed/gm-restore.sh:41: echo " "`ls -al ${BACKUP}`
gnumed-server-22.14/Gnumed/gm-restore.sh-42- exit 1
##############################################
gnumed-server-22.14/Gnumed/gm-restore.sh-52- echo " ERROR: Cannot read configuration file ${CONF}. Aborting."
gnumed-server-22.14/Gnumed/gm-restore.sh:53: echo " "`ls -al ${CONF}`
gnumed-server-22.14/Gnumed/gm-restore.sh-54- exit 1
##############################################
gnumed-server-22.14/Gnumed/gm-restore.sh-98- echo " ERROR: Cannot copy backup file. Aborting."
gnumed-server-22.14/Gnumed/gm-restore.sh:99: echo " "`ls -al ${BACKUP}`
gnumed-server-22.14/Gnumed/gm-restore.sh-100- echo " log: ${LOG}"
##############################################
gnumed-server-22.14/Gnumed/gm-restore.sh-106-echo "==> Unpacking backup file ..."
gnumed-server-22.14/Gnumed/gm-restore.sh:107:BACKUP=${WORK_DIR}`basename ${BACKUP}`
gnumed-server-22.14/Gnumed/gm-restore.sh-108-if [[ "${BACKUP}" =~ .*\.bz2 ]] ; then
##############################################
gnumed-server-22.14/Gnumed/gm-restore.sh-117- fi
gnumed-server-22.14/Gnumed/gm-restore.sh:118: BACKUP=${WORK_DIR}`basename ${BACKUP} .bz2`
gnumed-server-22.14/Gnumed/gm-restore.sh-119-fi
##############################################
gnumed-server-22.14/Gnumed/gm-restore.sh-130-fi
gnumed-server-22.14/Gnumed/gm-restore.sh:131:BACKUP=${WORK_DIR}`basename ${BACKUP} .tar`
gnumed-server-22.14/Gnumed/gm-restore.sh-132-rm ${BACKUP}.tar &>> ${LOG}
##############################################
gnumed-server-22.14/Gnumed/gm-restore.sh-136-echo "==> Checking target database status ..."
gnumed-server-22.14/Gnumed/gm-restore.sh:137:TARGET_DB=`pg_restore --create --schema-only ${BACKUP}.dir | head -n 40 | grep -i 'create database gnumed_v' | cut -f 3 -d ' '`
gnumed-server-22.14/Gnumed/gm-restore.sh-138-ERROR="$?"
##############################################
gnumed-server-22.14/Gnumed/gm-restore.sh-151-echo " db: ${TARGET_DB}"
gnumed-server-22.14/Gnumed/gm-restore.sh:152:if test `sudo -u postgres psql -l -p ${GM_PORT} | grep ${TARGET_DB} | wc -l` -ne 0 ; then
gnumed-server-22.14/Gnumed/gm-restore.sh-153- echo ""
##############################################
gnumed-server-22.14/debian/rules-10- cp -a server/bootstrap/[a-z]* debian/$(DEB_SOURCE)/var/lib/gnumed/server/bootstrap
gnumed-server-22.14/debian/rules:11: for conffile in `find debian/$(DEB_SOURCE)/var/lib/gnumed/server/bootstrap -maxdepth 1 -type f -name \*.conf` ; do \
gnumed-server-22.14/debian/rules-12- sed -i 's/^\(interactive[[:space:]]*=[[:space:]]*\)yes/\1no/' "$$conffile" ; \
##############################################
gnumed-server-22.14/debian/rules-17- "$$script" = "server/gm-move_backups_offsite.sh" ] ; then \
gnumed-server-22.14/debian/rules:18: cp -a "$$script" debian/$(DEB_SOURCE)/usr/bin/`basename "$$script" .sh` ; \
gnumed-server-22.14/debian/rules-19- else \
gnumed-server-22.14/debian/rules:20: cp -a "$$script" debian/$(DEB_SOURCE)/usr/sbin/`basename "$$script" .sh` ; \
gnumed-server-22.14/debian/rules-21- fi \