From 2271cebad8877936f1e68a2d435886659a0b6bf9 Mon Sep 17 00:00:00 2001 From: Tim Otten Date: Wed, 17 May 2023 03:01:04 -0700 Subject: [PATCH] Extract paper_size --- sql/civicrm_option_groups.php | 4 -- .../paper_size.sqldata.php | 72 +++++++++++++++++++ xml/templates/civicrm_data.tpl | 65 ----------------- 3 files changed, 72 insertions(+), 69 deletions(-) create mode 100644 sql/civicrm_option_groups/paper_size.sqldata.php diff --git a/sql/civicrm_option_groups.php b/sql/civicrm_option_groups.php index 65300f43ad..902f47c205 100644 --- a/sql/civicrm_option_groups.php +++ b/sql/civicrm_option_groups.php @@ -19,10 +19,6 @@ $readOptionGroups = function (): array { }; return $readOptionGroups() + [ - 'paper_size' => CRM_Core_CodeGen_OptionGroup::create('paper_size') - ->addMetadata([ - 'title' => ts('Paper Size'), - ]), 'pdf_format' => CRM_Core_CodeGen_OptionGroup::create('pdf_format') ->addMetadata([ 'title' => ts('PDF Page Format'), diff --git a/sql/civicrm_option_groups/paper_size.sqldata.php b/sql/civicrm_option_groups/paper_size.sqldata.php new file mode 100644 index 0000000000..fd942ecb42 --- /dev/null +++ b/sql/civicrm_option_groups/paper_size.sqldata.php @@ -0,0 +1,72 @@ +addMetadata([ + 'title' => ts('Paper Size'), + ]) + ->addValues(['label', 'name', 'value'], [ + [ts('Letter'), 'letter', '{"metric":"in","width":8.5,"height":11}', 'is_default' => 1], + [ts('Legal'), 'legal', '{"metric":"in","width":8.5,"height":14}'], + [ts('Ledger'), 'ledger', '{"metric":"in","width":17,"height":11}'], + [ts('Tabloid'), 'tabloid', '{"metric":"in","width":11,"height":17}'], + [ts('Executive'), 'executive', '{"metric":"in","width":7.25,"height":10.5}'], + [ts('Folio'), 'folio', '{"metric":"in","width":8.5,"height":13}'], + [ts('Envelope #9'), 'envelope-9', '{"metric":"pt","width":638.93,"height":278.93}'], + [ts('Envelope #10'), 'envelope-10', '{"metric":"pt","width":684,"height":297}'], + [ts('Envelope #11'), 'envelope-11', '{"metric":"pt","width":747,"height":324}'], + [ts('Envelope #12'), 'envelope-12', '{"metric":"pt","width":792,"height":342}'], + [ts('Envelope #14'), 'envelope-14', '{"metric":"pt","width":828,"height":360}'], + [ts('Envelope ISO B4'), 'envelope-b4', '{"metric":"pt","width":1000.63,"height":708.66}'], + [ts('Envelope ISO B5'), 'envelope-b5', '{"metric":"pt","width":708.66,"height":498.9}'], + [ts('Envelope ISO B6'), 'envelope-b6', '{"metric":"pt","width":498.9,"height":354.33}'], + [ts('Envelope ISO C3'), 'envelope-c3', '{"metric":"pt","width":1298.27,"height":918.42}'], + [ts('Envelope ISO C4'), 'envelope-c4', '{"metric":"pt","width":918.42,"height":649.13}'], + [ts('Envelope ISO C5'), 'envelope-c5', '{"metric":"pt","width":649.13,"height":459.21}'], + [ts('Envelope ISO C6'), 'envelope-c6', '{"metric":"pt","width":459.21,"height":323.15}'], + [ts('Envelope ISO DL'), 'envelope-dl', '{"metric":"pt","width":623.622,"height":311.811}'], + [ts('ISO A0'), 'a0', '{"metric":"pt","width":2383.94,"height":3370.39}'], + [ts('ISO A1'), 'a1', '{"metric":"pt","width":1683.78,"height":2383.94}'], + [ts('ISO A2'), 'a2', '{"metric":"pt","width":1190.55,"height":1683.78}'], + [ts('ISO A3'), 'a3', '{"metric":"pt","width":841.89,"height":1190.55}'], + [ts('ISO A4'), 'a4', '{"metric":"pt","width":595.28,"height":841.89}'], + [ts('ISO A5'), 'a5', '{"metric":"pt","width":419.53,"height":595.28}'], + [ts('ISO A6'), 'a6', '{"metric":"pt","width":297.64,"height":419.53}'], + [ts('ISO A7'), 'a7', '{"metric":"pt","width":209.76,"height":297.64}'], + [ts('ISO A8'), 'a8', '{"metric":"pt","width":147.4,"height":209.76}'], + [ts('ISO A9'), 'a9', '{"metric":"pt","width":104.88,"height":147.4}'], + [ts('ISO A10'), 'a10', '{"metric":"pt","width":73.7,"height":104.88}'], + [ts('ISO B0'), 'b0', '{"metric":"pt","width":2834.65,"height":4008.19}'], + [ts('ISO B1'), 'b1', '{"metric":"pt","width":2004.09,"height":2834.65}'], + [ts('ISO B2'), 'b2', '{"metric":"pt","width":1417.32,"height":2004.09}'], + [ts('ISO B3'), 'b3', '{"metric":"pt","width":1000.63,"height":1417.32}'], + [ts('ISO B4'), 'b4', '{"metric":"pt","width":708.66,"height":1000.63}'], + [ts('ISO B5'), 'b5', '{"metric":"pt","width":498.9,"height":708.66}'], + [ts('ISO B6'), 'b6', '{"metric":"pt","width":354.33,"height":498.9}'], + [ts('ISO B7'), 'b7', '{"metric":"pt","width":249.45,"height":354.33}'], + [ts('ISO B8'), 'b8', '{"metric":"pt","width":175.75,"height":249.45}'], + [ts('ISO B9'), 'b9', '{"metric":"pt","width":124.72,"height":175.75}'], + [ts('ISO B10'), 'b10', '{"metric":"pt","width":87.87,"height":124.72}'], + [ts('ISO C0'), 'c0', '{"metric":"pt","width":2599.37,"height":3676.54}'], + [ts('ISO C1'), 'c1', '{"metric":"pt","width":1836.85,"height":2599.37}'], + [ts('ISO C2'), 'c2', '{"metric":"pt","width":1298.27,"height":1836.85}'], + [ts('ISO C3'), 'c3', '{"metric":"pt","width":918.43,"height":1298.27}'], + [ts('ISO C4'), 'c4', '{"metric":"pt","width":649.13,"height":918.43}'], + [ts('ISO C5'), 'c5', '{"metric":"pt","width":459.21,"height":649.13}'], + [ts('ISO C6'), 'c6', '{"metric":"pt","width":323.15,"height":459.21}'], + [ts('ISO C7'), 'c7', '{"metric":"pt","width":229.61,"height":323.15}'], + [ts('ISO C8'), 'c8', '{"metric":"pt","width":161.57,"height":229.61}'], + [ts('ISO C9'), 'c9', '{"metric":"pt","width":113.39,"height":161.57}'], + [ts('ISO C10'), 'c10', '{"metric":"pt","width":79.37,"height":113.39}'], + [ts('ISO RA0'), 'ra0', '{"metric":"pt","width":2437.8,"height":3458.27}'], + [ts('ISO RA1'), 'ra1', '{"metric":"pt","width":1729.13,"height":2437.8}'], + [ts('ISO RA2'), 'ra2', '{"metric":"pt","width":1218.9,"height":1729.13}'], + [ts('ISO RA3'), 'ra3', '{"metric":"pt","width":864.57,"height":1218.9}'], + [ts('ISO RA4'), 'ra4', '{"metric":"pt","width":609.45,"height":864.57}'], + [ts('ISO SRA0'), 'sra0', '{"metric":"pt","width":2551.18,"height":3628.35}'], + [ts('ISO SRA1'), 'sra1', '{"metric":"pt","width":1814.17,"height":2551.18}'], + [ts('ISO SRA2'), 'sra2', '{"metric":"pt","width":1275.59,"height":1814.17}'], + [ts('ISO SRA3'), 'sra3', '{"metric":"pt","width":907.09,"height":1275.59}'], + [ts('ISO SRA4'), 'sra4', '{"metric":"pt","width":637.8,"height":907.09}'], + ]) + ->addDefaults([ + 'filter' => NULL, + ]); diff --git a/xml/templates/civicrm_data.tpl b/xml/templates/civicrm_data.tpl index bee06cc8ef..edd23f3729 100644 --- a/xml/templates/civicrm_data.tpl +++ b/xml/templates/civicrm_data.tpl @@ -134,7 +134,6 @@ VALUES SELECT @option_group_id_pi := max(id) from civicrm_option_group where name = 'payment_instrument'; -SELECT @option_group_id_paperSize := max(id) from civicrm_option_group where name = 'paper_size'; SELECT @option_group_id_label := max(id) from civicrm_option_group where name = 'label_format'; SELECT @option_group_id_aco := max(id) from civicrm_option_group where name = 'activity_contacts'; SELECT @option_group_id_arel := max(id) from civicrm_option_group where name = 'account_relationship'; @@ -174,70 +173,6 @@ INSERT INTO `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `visibility_id`, `icon`) VALUES --- Paper Sizes - (@option_group_id_paperSize, '{ts escape="sql"}Letter{/ts}', '{literal}{"metric":"in","width":8.5,"height":11}{/literal}', 'letter', NULL, NULL, 1, 1, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}Legal{/ts}', '{literal}{"metric":"in","width":8.5,"height":14}{/literal}', 'legal', NULL, NULL, 0, 2, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}Ledger{/ts}', '{literal}{"metric":"in","width":17,"height":11}{/literal}', 'ledger', NULL, NULL, 0, 3, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}Tabloid{/ts}', '{literal}{"metric":"in","width":11,"height":17}{/literal}', 'tabloid', NULL, NULL, 0, 4, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}Executive{/ts}', '{literal}{"metric":"in","width":7.25,"height":10.5}{/literal}', 'executive', NULL, NULL, 0, 5, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}Folio{/ts}', '{literal}{"metric":"in","width":8.5,"height":13}{/literal}', 'folio', NULL, NULL, 0, 6, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}Envelope #9{/ts}', '{literal}{"metric":"pt","width":638.93,"height":278.93}{/literal}', 'envelope-9', NULL, NULL, 0, 7, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}Envelope #10{/ts}', '{literal}{"metric":"pt","width":684,"height":297}{/literal}', 'envelope-10', NULL, NULL, 0, 8, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}Envelope #11{/ts}', '{literal}{"metric":"pt","width":747,"height":324}{/literal}', 'envelope-11', NULL, NULL, 0, 9, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}Envelope #12{/ts}', '{literal}{"metric":"pt","width":792,"height":342}{/literal}', 'envelope-12', NULL, NULL, 0, 10, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}Envelope #14{/ts}', '{literal}{"metric":"pt","width":828,"height":360}{/literal}', 'envelope-14', NULL, NULL, 0, 11, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}Envelope ISO B4{/ts}', '{literal}{"metric":"pt","width":1000.63,"height":708.66}{/literal}', 'envelope-b4', NULL, NULL, 0, 12, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}Envelope ISO B5{/ts}', '{literal}{"metric":"pt","width":708.66,"height":498.9}{/literal}', 'envelope-b5', NULL, NULL, 0, 13, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}Envelope ISO B6{/ts}', '{literal}{"metric":"pt","width":498.9,"height":354.33}{/literal}', 'envelope-b6', NULL, NULL, 0, 14, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}Envelope ISO C3{/ts}', '{literal}{"metric":"pt","width":1298.27,"height":918.42}{/literal}', 'envelope-c3', NULL, NULL, 0, 15, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}Envelope ISO C4{/ts}', '{literal}{"metric":"pt","width":918.42,"height":649.13}{/literal}', 'envelope-c4', NULL, NULL, 0, 16, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}Envelope ISO C5{/ts}', '{literal}{"metric":"pt","width":649.13,"height":459.21}{/literal}', 'envelope-c5', NULL, NULL, 0, 17, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}Envelope ISO C6{/ts}', '{literal}{"metric":"pt","width":459.21,"height":323.15}{/literal}', 'envelope-c6', NULL, NULL, 0, 18, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}Envelope ISO DL{/ts}', '{literal}{"metric":"pt","width":623.622,"height":311.811}{/literal}', 'envelope-dl', NULL, NULL, 0, 19, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO A0{/ts}', '{literal}{"metric":"pt","width":2383.94,"height":3370.39}{/literal}', 'a0', NULL, NULL, 0, 20, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO A1{/ts}', '{literal}{"metric":"pt","width":1683.78,"height":2383.94}{/literal}', 'a1', NULL, NULL, 0, 21, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO A2{/ts}', '{literal}{"metric":"pt","width":1190.55,"height":1683.78}{/literal}', 'a2', NULL, NULL, 0, 22, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO A3{/ts}', '{literal}{"metric":"pt","width":841.89,"height":1190.55}{/literal}', 'a3', NULL, NULL, 0, 23, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO A4{/ts}', '{literal}{"metric":"pt","width":595.28,"height":841.89}{/literal}', 'a4', NULL, NULL, 0, 24, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO A5{/ts}', '{literal}{"metric":"pt","width":419.53,"height":595.28}{/literal}', 'a5', NULL, NULL, 0, 25, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO A6{/ts}', '{literal}{"metric":"pt","width":297.64,"height":419.53}{/literal}', 'a6', NULL, NULL, 0, 26, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO A7{/ts}', '{literal}{"metric":"pt","width":209.76,"height":297.64}{/literal}', 'a7', NULL, NULL, 0, 27, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO A8{/ts}', '{literal}{"metric":"pt","width":147.4,"height":209.76}{/literal}', 'a8', NULL, NULL, 0, 28, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO A9{/ts}', '{literal}{"metric":"pt","width":104.88,"height":147.4}{/literal}', 'a9', NULL, NULL, 0, 29, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO A10{/ts}', '{literal}{"metric":"pt","width":73.7,"height":104.88}{/literal}', 'a10', NULL, NULL, 0, 30, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO B0{/ts}', '{literal}{"metric":"pt","width":2834.65,"height":4008.19}{/literal}', 'b0', NULL, NULL, 0, 31, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO B1{/ts}', '{literal}{"metric":"pt","width":2004.09,"height":2834.65}{/literal}', 'b1', NULL, NULL, 0, 32, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO B2{/ts}', '{literal}{"metric":"pt","width":1417.32,"height":2004.09}{/literal}', 'b2', NULL, NULL, 0, 33, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO B3{/ts}', '{literal}{"metric":"pt","width":1000.63,"height":1417.32}{/literal}', 'b3', NULL, NULL, 0, 34, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO B4{/ts}', '{literal}{"metric":"pt","width":708.66,"height":1000.63}{/literal}', 'b4', NULL, NULL, 0, 35, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO B5{/ts}', '{literal}{"metric":"pt","width":498.9,"height":708.66}{/literal}', 'b5', NULL, NULL, 0, 36, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO B6{/ts}', '{literal}{"metric":"pt","width":354.33,"height":498.9}{/literal}', 'b6', NULL, NULL, 0, 37, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO B7{/ts}', '{literal}{"metric":"pt","width":249.45,"height":354.33}{/literal}', 'b7', NULL, NULL, 0, 38, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO B8{/ts}', '{literal}{"metric":"pt","width":175.75,"height":249.45}{/literal}', 'b8', NULL, NULL, 0, 39, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO B9{/ts}', '{literal}{"metric":"pt","width":124.72,"height":175.75}{/literal}', 'b9', NULL, NULL, 0, 40, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO B10{/ts}', '{literal}{"metric":"pt","width":87.87,"height":124.72}{/literal}', 'b10', NULL, NULL, 0, 41, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO C0{/ts}', '{literal}{"metric":"pt","width":2599.37,"height":3676.54}{/literal}', 'c0', NULL, NULL, 0, 42, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO C1{/ts}', '{literal}{"metric":"pt","width":1836.85,"height":2599.37}{/literal}', 'c1', NULL, NULL, 0, 43, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO C2{/ts}', '{literal}{"metric":"pt","width":1298.27,"height":1836.85}{/literal}', 'c2', NULL, NULL, 0, 44, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO C3{/ts}', '{literal}{"metric":"pt","width":918.43,"height":1298.27}{/literal}', 'c3', NULL, NULL, 0, 45, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO C4{/ts}', '{literal}{"metric":"pt","width":649.13,"height":918.43}{/literal}', 'c4', NULL, NULL, 0, 46, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO C5{/ts}', '{literal}{"metric":"pt","width":459.21,"height":649.13}{/literal}', 'c5', NULL, NULL, 0, 47, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO C6{/ts}', '{literal}{"metric":"pt","width":323.15,"height":459.21}{/literal}', 'c6', NULL, NULL, 0, 48, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO C7{/ts}', '{literal}{"metric":"pt","width":229.61,"height":323.15}{/literal}', 'c7', NULL, NULL, 0, 49, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO C8{/ts}', '{literal}{"metric":"pt","width":161.57,"height":229.61}{/literal}', 'c8', NULL, NULL, 0, 50, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO C9{/ts}', '{literal}{"metric":"pt","width":113.39,"height":161.57}{/literal}', 'c9', NULL, NULL, 0, 51, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO C10{/ts}', '{literal}{"metric":"pt","width":79.37,"height":113.39}{/literal}', 'c10', NULL, NULL, 0, 52, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO RA0{/ts}', '{literal}{"metric":"pt","width":2437.8,"height":3458.27}{/literal}', 'ra0', NULL, NULL, 0, 53, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO RA1{/ts}', '{literal}{"metric":"pt","width":1729.13,"height":2437.8}{/literal}', 'ra1', NULL, NULL, 0, 54, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO RA2{/ts}', '{literal}{"metric":"pt","width":1218.9,"height":1729.13}{/literal}', 'ra2', NULL, NULL, 0, 55, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO RA3{/ts}', '{literal}{"metric":"pt","width":864.57,"height":1218.9}{/literal}', 'ra3', NULL, NULL, 0, 56, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO RA4{/ts}', '{literal}{"metric":"pt","width":609.45,"height":864.57}{/literal}', 'ra4', NULL, NULL, 0, 57, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO SRA0{/ts}', '{literal}{"metric":"pt","width":2551.18,"height":3628.35}{/literal}', 'sra0', NULL, NULL, 0, 58, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO SRA1{/ts}', '{literal}{"metric":"pt","width":1814.17,"height":2551.18}{/literal}', 'sra1', NULL, NULL, 0, 59, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO SRA2{/ts}', '{literal}{"metric":"pt","width":1275.59,"height":1814.17}{/literal}', 'sra2', NULL, NULL, 0, 60, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO SRA3{/ts}', '{literal}{"metric":"pt","width":907.09,"height":1275.59}{/literal}', 'sra3', NULL, NULL, 0, 61, NULL, 0, 0, 1, NULL, NULL, NULL), - (@option_group_id_paperSize, '{ts escape="sql"}ISO SRA4{/ts}', '{literal}{"metric":"pt","width":637.8,"height":907.09}{/literal}', 'sra4', NULL, NULL, 0, 62, NULL, 0, 0, 1, NULL, NULL, NULL), - -- activity_contacts (@option_group_id_aco, '{ts escape="sql"}Activity Assignees{/ts}', 1, 'Activity Assignees', NULL, 0, 0, 3, NULL, 0, 0, 1, NULL, NULL, NULL), (@option_group_id_aco, '{ts escape="sql"}Activity Source{/ts}', 2, 'Activity Source', NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL, NULL), -- 2.25.1