/gnumed-server.16.14/server/sql/country.specific/de/gmDemographics-Data.de.sql

# · SQL · 60 lines · 7 code · 5 blank · 48 comment · 0 complexity · 09821db6642020e48f6bd769d2a49e2a MD5 · raw file 

    

  1. -- GNUmed
    2. 

  2. -- $Source: /home/ncq/Projekte/cvs2git/vcs-mirror/gnumed/gnumed/server/sql/country.specific/de/gmDemographics-Data.de.sql,v $
    3. 

  3. -- $Revision: 1.6 $
    4. 

  4. 

  5. -- license: GPL v2 or later
    6. 

  6. -- author: Karsten Hilbert <Karsten.Hilbert@gmx.net>
    7. 

  7. 

  8. -- =============================================
    9. 

  9. -- force terminate + exit(3) on errors if non-interactive
    10. 

  10. \set ON_ERROR_STOP 1
    11. 

  11. 

  12. set client_encoding to 'LATIN1';
    13. 

  13. -- =============================================
    14. 

  14. -- external ID types
    15. 

  15. insert into dem.enum_ext_id_types (name, issuer, context) values ('KV-Nummer', 'KV', 'c');
    16. 

  16. insert into dem.enum_ext_id_types (name, issuer, context) values ('Mitgliedsnummer', 'Krankenkasse', 'p');
    17. 

  17. insert into dem.enum_ext_id_types (name, issuer, context) values ('BLZ', 'Bank', 'o');
    18. 

  18. 

  19. --insert into dem.enum_ext_id_types (name, issuer, context) values ('', '', '');
    20. 

  20. -- =============================================
    21. 

  21. -- do simple revision tracking
    22. 

  22. delete from gm_schema_revision where filename = '$RCSfile: gmDemographics-Data.de.sql,v $';
    23. 

  23. INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmDemographics-Data.de.sql,v $', '$Revision: 1.6 $');
    24. 

  24. 

  25. -- =============================================
    26. 

  26. -- $Log: gmDemographics-Data.de.sql,v $
    27. 

  27. -- Revision 1.6  2006-01-06 10:12:02  ncq
    28. 

  28. -- - add missing grants
    29. 

  29. -- - add_table_for_audit() now in "audit" schema
    30. 

  30. -- - demographics now in "dem" schema
    31. 

  31. -- - add view v_inds4vaccine
    32. 

  32. -- - move staff_role from clinical into demographics
    33. 

  33. -- - put add_coded_term() into "clin" schema
    34. 

  34. -- - put German things into "de_de" schema
    35. 

  35. --
    36. 

  36. -- Revision 1.5  2005/09/19 16:38:52  ncq
    37. 

  37. -- - adjust to removed is_core from gm_schema_revision
    38. 

  38. --
    39. 

  39. -- Revision 1.4  2005/07/14 21:31:43  ncq
    40. 

  40. -- - partially use improved schema revision tracking
    41. 

  41. --
    42. 

  42. -- Revision 1.3  2005/03/31 20:10:16  ncq
    43. 

  43. -- - aggregate translations
    44. 

  44. --
    45. 

  45. -- Revision 1.2  2004/03/04 10:53:07  ncq
    46. 

  46. -- - add a bunch of external id types
    47. 

  47. --
    48. 

  48. -- Revision 1.1  2003/08/05 08:16:00  ncq
    49. 

  49. -- - cleanup/renaming
    50. 

  50. --
    51. 

  51. -- Revision 1.3  2003/06/11 14:03:44  ncq
    52. 

  52. -- - set encoding
    53. 

  53. --
    54. 

  54. -- Revision 1.2  2003/05/12 12:43:40  ncq
    55. 

  55. -- - gmI18N, gmServices and gmSchemaRevision are imported globally at the
    56. 

  56. --   database level now, don't include them in individual schema file anymore
    57. 

  57. --
    58. 

  58. -- Revision 1.1  2003/01/22 23:40:18  ncq
    59. 

  59. -- - first version
    60. 

  60. --
    61.