Open-ILS/src/sql/Pg/upgrade/0611.data.magic_macros.sql

   1 -- Evergreen DB patch 0611.data.magic_macros.sql
   2 BEGIN;
   3
   4 -- check whether patch can be applied
   5 SELECT evergreen.upgrade_deps_block_check('0611', :eg_version);
   6
   7 INSERT into config.org_unit_setting_type
   8 ( name, label, description, datatype ) VALUES
   9 (
  10         'circ.staff_client.receipt.header_text',
  11         oils_i18n_gettext(
  12             'circ.staff_client.receipt.header_text',
  13             'Receipt Template: Content of header_text include',
  14             'coust',
  15             'label'
  16         ),
  17         oils_i18n_gettext(
  18             'circ.staff_client.receipt.header_text',
  19             'Text/HTML/Macros to be inserted into receipt templates in place of %INCLUDE(header_text)%',
  20             'coust',
  21             'description'
  22         ),
  23         'string'
  24     )
  25 ,(
  26         'circ.staff_client.receipt.footer_text',
  27         oils_i18n_gettext(
  28             'circ.staff_client.receipt.footer_text',
  29             'Receipt Template: Content of footer_text include',
  30             'coust',
  31             'label'
  32         ),
  33         oils_i18n_gettext(
  34             'circ.staff_client.receipt.footer_text',
  35             'Text/HTML/Macros to be inserted into receipt templates in place of %INCLUDE(footer_text)%',
  36             'coust',
  37             'description'
  38         ),
  39         'string'
  40     )
  41 ,(
  42         'circ.staff_client.receipt.notice_text',
  43         oils_i18n_gettext(
  44             'circ.staff_client.receipt.notice_text',
  45             'Receipt Template: Content of notice_text include',
  46             'coust',
  47             'label'
  48         ),
  49         oils_i18n_gettext(
  50             'circ.staff_client.receipt.notice_text',
  51             'Text/HTML/Macros to be inserted into receipt templates in place of %INCLUDE(notice_text)%',
  52             'coust',
  53             'description'
  54         ),
  55         'string'
  56     )
  57 ,(
  58         'circ.staff_client.receipt.alert_text',
  59         oils_i18n_gettext(
  60             'circ.staff_client.receipt.alert_text',
  61             'Receipt Template: Content of alert_text include',
  62             'coust',
  63             'label'
  64         ),
  65         oils_i18n_gettext(
  66             'circ.staff_client.receipt.alert_text',
  67             'Text/HTML/Macros to be inserted into receipt templates in place of %INCLUDE(alert_text)%',
  68             'coust',
  69             'description'
  70         ),
  71         'string'
  72     )
  73 ,(
  74         'circ.staff_client.receipt.event_text',
  75         oils_i18n_gettext(
  76             'circ.staff_client.receipt.event_text',
  77             'Receipt Template: Content of event_text include',
  78             'coust',
  79             'label'
  80         ),
  81         oils_i18n_gettext(
  82             'circ.staff_client.receipt.event_text',
  83             'Text/HTML/Macros to be inserted into receipt templates in place of %INCLUDE(event_text)%',
  84             'coust',
  85             'description'
  86         ),
  87         'string'
  88     );
  89
  90 COMMIT;