-- Table structure for table `cache_toolbar`
--

CREATE TABLE `cache_toolbar` (
  `cid` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.',
  `data` longblob COMMENT 'A collection of data to cache.',
  `expire` bigint NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or -1 for never.',
  `created` decimal(14,3) NOT NULL DEFAULT '0.000' COMMENT 'A timestamp with millisecond precision indicating when the cache entry was created.',
  `serialized` smallint NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).',
  `tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Space-separated list of cache tags for this entry.',
  `checksum` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The tag invalidation checksum when this entry was saved.',
  PRIMARY KEY (`cid`),
  KEY `expire` (`expire`),
  KEY `created` (`created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Storage for the cache API.';

--
-- Dumping data for table `cache_toolbar`
--


--
-- Table structure for table `cachetags`
--

CREATE TABLE `cachetags` (
  `tag` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'Namespace-prefixed tag string.',
  `invalidations` int NOT NULL DEFAULT '0' COMMENT 'Number incremented when the tag is invalidated.',
  PRIMARY KEY (`tag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Cache table for tracking cache tag invalidations.';

--
-- Dumping data for table `cachetags`
--

INSERT INTO `cachetags` VALUES ('4xx-response',248),('block_content:1',1),('block_content:10',1),('block_content:11',1),('block_content:12',1),('block_content:13',1),('block_content:14',1),('block_content:15',1),('block_content:16',2),('block_content:17',1),('block_content:18',2),('block_content:19',1),('block_content:20',1),('block_content:21',2),('block_content:22',1),('block_content:23',4),('block_content:24',3),('block_content:25',1),('block_content:29',1),('block_content:31',4),('block_content:32',2),('block_content:33',2),('block_content:4',1),('block_content:5',1),('block_content:6',4),('block_content:7',1),('block_content:8',1),('block_content:9',1),('block_content_list',57),('block_content_list:basic',12),('block_content_list:donate_now',1),('block_content_list:features_block',5),('block_content_list:get_involved',7),('block_content_list:hamburger',2),('block_content_list:image',5),('block_content_list:learn_more',10),('block_content_list:slider',14),('block_content_list:ways_to_give',6),('block_content_view',30),('breakpoints',148),('civicrm_contact_list',1),('civicrm_email_list',1),('config:action_list',2),('config:admin_toolbar.settings',1),('config:announcements_feed.settings',1),('config:automated_cron.settings',1),('config:backup_migrate.backup_migrate_destination.private_files',9),('config:backup_migrate.backup_migrate_schedule.daily_schedule',9),('config:backup_migrate.backup_migrate_source.default_db',9),('config:backup_migrate.backup_migrate_source.entire_site',9),('config:backup_migrate.backup_migrate_source.private_files',9),('config:backup_migrate.backup_migrate_source.public_files',9),('config:backup_migrate_destination_list',1),('config:backup_migrate_schedule_list',1),('config:backup_migrate_source_list',1),('config:blb_breakpoint_list',2),('config:blb_layout_list',2),('config:blb_layout_option_list',1),('config:block.block.claro_breadcrumbs',11),('config:block.block.claro_content',11),('config:block.block.claro_help',11),('config:block.block.claro_help_search',11),('config:block.block.claro_local_actions',11),('config:block.block.claro_messages',11),('config:block.block.claro_page_title',11),('config:block.block.claro_primary_local_tasks',11),('config:block.block.claro_secondary_local_tasks',11),('config:block.block.fencesforfido_account_menu',19),('config:block.block.fencesforfido_bottombar',17),('config:block.block.fencesforfido_breadcrumbs',2),('config:block.block.fencesforfido_content',19),('config:block.block.fencesforfido_donatenowbutton',14),('config:block.block.fencesforfido_donatenowbutton_2',5),('config:block.block.fencesforfido_footer',12),('config:block.block.fencesforfido_getinvolved',9),('config:block.block.fencesforfido_getinvolved_2',2),('config:block.block.fencesforfido_hamburgericon',13),('config:block.block.fencesforfido_help',3),('config:block.block.fencesforfido_heroslider',16),('config:block.block.fencesforfido_imageslider',6),('config:block.block.fencesforfido_learnmore',9),('config:block.block.fencesforfido_learnmore_2',4),('config:block.block.fencesforfido_mainnavigation',5),('config:block.block.fencesforfido_main_menu',17),('config:block.block.fencesforfido_messages',2),('config:block.block.fencesforfido_mobilemenu',10),('config:block.block.fencesforfido_page_title',19),('config:block.block.fencesforfido_powered',3),('config:block.block.fencesforfido_primary_admin_actions',2),('config:block.block.fencesforfido_primary_local_tasks',2),('config:block.block.fencesforfido_search_form_narrow',2),('config:block.block.fencesforfido_search_form_wide',2),('config:block.block.fencesforfido_secondary_local_tasks',2),('config:block.block.fencesforfido_sitebranding',21),('config:block.block.fencesforfido_site_branding',6),('config:block.block.fencesforfido_slider',7),('config:block.block.fencesforfido_syndicate',3),('config:block.block.fencesforfido_testslider',10),('config:block.block.fencesforfido_testtes',2),('config:block.block.fencesforfido_topbar',18),('config:block.block.fencesforfido_waystogive',9),('config:block.block.nordic_cryo_account_menu',2),('config:block.block.nordic_cryo_breadcrumbs',2),('config:block.block.nordic_cryo_content',2),('config:block.block.nordic_cryo_help',2),('config:block.block.nordic_cryo_main_menu',2),('config:block.block.nordic_cryo_messages',2),('config:block.block.nordic_cryo_page_title',2),('config:block.block.nordic_cryo_powered',2),('config:block.block.nordic_cryo_primary_admin_actions',2),('config:block.block.nordic_cryo_primary_local_tasks',2),('config:block.block.nordic_cryo_search_form_narrow',2),('config:block.block.nordic_cryo_search_form_wide',2),('config:block.block.nordic_cryo_secondary_local_tasks',2),('config:block.block.nordic_cryo_site_branding',2),('config:block.block.nordic_cryo_syndicate',2),('config:block.block.olivero_account_menu',4),('config:block.block.olivero_breadcrumbs',11),('config:block.block.olivero_content',11),('config:block.block.olivero_help',11),('config:block.block.olivero_main_menu',11),('config:block.block.olivero_messages',11),('config:block.block.olivero_page_title',11),('config:block.block.olivero_powered',11),('config:block.block.olivero_primary_admin_actions',11),('config:block.block.olivero_primary_local_tasks',11),('config:block.block.olivero_search_form_narrow',11),('config:block.block.olivero_search_form_wide',11),('config:block.block.olivero_secondary_local_tasks',11),('config:block.block.olivero_site_branding',11),('config:block.block.olivero_syndicate',11),('config:block_content.type.basic',11),('config:block_content.type.image',1),('config:block_content.type.slider',4),('config:block_content.type.test_img',1),('config:block_content_type_list',12),('config:block_group_content_list',3),('config:block_list',92),('config:bootstrap_layout_builder.breakpoint.desktop',10),('config:bootstrap_layout_builder.breakpoint.mobile',10),('config:bootstrap_layout_builder.breakpoint.tablet',10),('config:bootstrap_layout_builder.layout.blb_col_1',10),('config:bootstrap_layout_builder.layout.blb_col_10',10),('config:bootstrap_layout_builder.layout.blb_col_11',10),('config:bootstrap_layout_builder.layout.blb_col_12',10),('config:bootstrap_layout_builder.layout.blb_col_2',10),('config:bootstrap_layout_builder.layout.blb_col_3',10),('config:bootstrap_layout_builder.layout.blb_col_4',9),('config:bootstrap_layout_builder.layout.blb_col_5',9),('config:bootstrap_layout_builder.layout.blb_col_6',9),('config:bootstrap_layout_builder.layout.blb_col_7',9),('config:bootstrap_layout_builder.layout.blb_col_8',9),('config:bootstrap_layout_builder.layout.blb_col_9',9),('config:bootstrap_layout_builder.layout_option.blb_col_2_25_75',9),('config:bootstrap_layout_builder.layout_option.blb_col_2_75_25',9),('config:bootstrap_layout_builder.layout_option.blb_col_2_full_width',9),('config:bootstrap_layout_builder.layout_option.blb_col_2_two_equal_columns',9),('config:bootstrap_layout_builder.layout_option.blb_col_3_25_25_50',9),('config:bootstrap_layout_builder.layout_option.blb_col_3_25_50_25',9),('config:bootstrap_layout_builder.layout_option.blb_col_3_50_25_25',9),('config:bootstrap_layout_builder.layout_option.blb_col_3_full_width',9),('config:bootstrap_layout_builder.layout_option.blb_col_3_three_equal_columns',9),('config:bootstrap_layout_builder.layout_option.blb_col_4_2_4_2_4',9),('config:bootstrap_layout_builder.layout_option.blb_col_4_2_4_4_2',9),('config:bootstrap_layout_builder.layout_option.blb_col_4_4_2_2_4',9),('config:bootstrap_layout_builder.layout_option.blb_col_4_4_4_2_2',9),('config:bootstrap_layout_builder.layout_option.blb_col_4_four_equal_columns',9),('config:bootstrap_layout_builder.layout_option.blb_col_4_full_width',9),('config:bootstrap_layout_builder.layout_option.blb_col_5_2_2_2_2_4',9),('config:bootstrap_layout_builder.layout_option.blb_col_5_2_2_2_4_2',9),('config:bootstrap_layout_builder.layout_option.blb_col_5_2_2_4_2_2',9),('config:bootstrap_layout_builder.layout_option.blb_col_5_2_4_2_2_2',9),('config:bootstrap_layout_builder.layout_option.blb_col_5_4_2_2_2_2',9),('config:bootstrap_layout_builder.layout_option.blb_col_5_full_width',9),('config:bootstrap_layout_builder.layout_option.blb_col_6_full_width',9),('config:bootstrap_layout_builder.layout_option.blb_col_6_six_equal_columns',9),('config:bootstrap_layout_builder.settings',2),('config:bootstrap_styles.settings',2),('config:civicrmtheme.settings',1),('config:civicrm_entity.settings',1),('config:comment.settings',1),('config:comment.type.comment',11),('config:contact.form.feedback',11),('config:contact.form.personal',11),('config:contact.settings',1),('config:core.base_field_override.node.home_page.promote',1),('config:core.base_field_override.node.page.promote',11),('config:core.date_format.fallback',11),('config:core.date_format.html_date',11),('config:core.date_format.html_datetime',11),('config:core.date_format.html_month',11),('config:core.date_format.html_time',11),('config:core.date_format.html_week',11),('config:core.date_format.html_year',11),('config:core.date_format.html_yearless_date',11),('config:core.date_format.long',11),('config:core.date_format.medium',11),('config:core.date_format.olivero_medium',11),('config:core.date_format.short',11),('config:core.entity_form_display.block_content.basic.default',3),('config:core.entity_form_display.block_content.donate_now.default',2),('config:core.entity_form_display.block_content.get_involved.default',1),('config:core.entity_form_display.block_content.hamburger.default',1),('config:core.entity_form_display.block_content.image.default',4),('config:core.entity_form_display.block_content.learn_more.default',1),('config:core.entity_form_display.block_content.slider.default',17),('config:core.entity_form_display.block_content.test_img.default',2),('config:core.entity_form_display.block_content.ways_to_give.default',1),('config:core.entity_form_display.comment.comment.default',3),('config:core.entity_form_display.media.image.default',1),('config:core.entity_form_display.media.image.media_library',1),('config:core.entity_form_display.media.image_type.default',1),('config:core.entity_form_display.media.image_type.media_library',1),('config:core.entity_form_display.node.article.default',9),('config:core.entity_form_display.node.home_page.default',2),('config:core.entity_form_display.node.page.default',4),('config:core.entity_form_display.user.user.default',3),('config:core.entity_form_mode.media.media_library',9),('config:core.entity_form_mode.user.register',11),('config:core.entity_view_display.block_content.basic.default',2),('config:core.entity_view_display.block_content.donate_now.default',3),('config:core.entity_view_display.block_content.get_involved.default',1),('config:core.entity_view_display.block_content.image.default',3),('config:core.entity_view_display.block_content.learn_more.default',1),('config:core.entity_view_display.block_content.slider.default',18),('config:core.entity_view_display.block_content.test_img.default',2),('config:core.entity_view_display.block_content.ways_to_give.default',1),('config:core.entity_view_display.comment.comment.default',1),('config:core.entity_view_display.media.image_type.default',1),('config:core.entity_view_display.media.image_type.media_library',1),('config:core.entity_view_display.node.article.default',7),('config:core.entity_view_display.node.article.rss',7),('config:core.entity_view_display.node.article.teaser',7),('config:core.entity_view_display.node.home_page.default',4),('config:core.entity_view_display.node.home_page.teaser',1),('config:core.entity_view_display.node.page.default',13),('config:core.entity_view_display.node.page.full',1),('config:core.entity_view_display.node.page.teaser',2),('config:core.entity_view_display.user.user.compact',1),('config:core.entity_view_display.user.user.default',1),('config:core.entity_view_mode.block_content.full',11),('config:core.entity_view_mode.comment.full',11),('config:core.entity_view_mode.media.full',9),('config:core.entity_view_mode.media.media_library',9),('config:core.entity_view_mode.node.full',11),('config:core.entity_view_mode.node.rss',11),('config:core.entity_view_mode.node.search_index',11),('config:core.entity_view_mode.node.search_result',11),('config:core.entity_view_mode.node.teaser',11),('config:core.entity_view_mode.taxonomy_term.full',11),('config:core.entity_view_mode.user.compact',11),('config:core.entity_view_mode.user.full',11),('config:core.extension',43),('config:core.menu.static_menu_link_overrides',2),('config:dblog.settings',1),('config:editor.editor.basic_html',1),('config:editor.editor.full_html',11),('config:editor.editor.webform_default',1),('config:editor_list',1),('config:entity_form_display_list',35),('config:entity_form_mode_list',1),('config:entity_view_display_list',45),('config:entity_view_mode_list',2),('config:fencesforfido.settings',9),('config:field.field.block_content.basic.body',11),('config:field.field.block_content.image.body',1),('config:field.field.block_content.image.field_image',2),('config:field.field.block_content.slider.body',4),('config:field.field.block_content.slider.field_image',1),('config:field.field.block_content.slider.field_silider_image',2),('config:field.field.block_content.slider.field_slider_image',3),('config:field.field.block_content.slider.field_text',2),('config:field.field.block_content.slider.field_title',2),('config:field.field.block_content.test_img.body',1),('config:field.field.block_content.test_img.field_test',1),('config:field.field.comment.comment.comment_body',11),('config:field.field.media.image_type.field_media_image_1',1),('config:field.field.node.article.body',11),('config:field.field.node.article.comment',11),('config:field.field.node.article.field_image',11),('config:field.field.node.article.field_tags',11),('config:field.field.node.article.layout_builder__layout',1),('config:field.field.node.home_page.body',1),('config:field.field.node.page.body',11),('config:field.field.user.user.user_picture',11),('config:field.settings',1),('config:field.storage.block_content.body',1),('config:field.storage.block_content.field_image',2),('config:field.storage.block_content.field_silider_image',2),('config:field.storage.block_content.field_slider_image',3),('config:field.storage.block_content.field_test',1),('config:field.storage.block_content.field_text',2),('config:field.storage.block_content.field_title',2),('config:field.storage.comment.comment_body',1),('config:field.storage.media.field_media_image_1',1),('config:field.storage.node.body',1),('config:field.storage.node.comment',1),('config:field.storage.node.field_image',1),('config:field.storage.node.field_tags',1),('config:field.storage.user.user_picture',1),('config:field_ui.settings',1),('config:file.settings',1),('config:filter.format.basic_html',11),('config:filter.format.full_html',11),('config:filter.format.plain_text',11),('config:filter.format.restricted_html',11),('config:filter.format.webform_default',10),('config:filter.settings',1),('config:filter_format_list',1),('config:flexslider.optionset.default',6),('config:flexslider.settings',2),('config:flexslider_list',2),('config:image.settings',1),('config:image.style.flexslider_full',15),('config:image.style.flexslider_thumbnail',18),('config:image.style.large',21),('config:image.style.media_library',19),('config:image.style.medium',21),('config:image.style.thumbnail',21),('config:image.style.wide',21),('config:image_style_list',4),('config:language.content_settings.block_content.image',1),('config:language.content_settings.block_content.slider',4),('config:language.content_settings.block_content.test_img',1),('config:language.content_settings.node.home_page',1),('config:language.content_settings.path_alias.path_alias',1),('config:language.entity.und',11),('config:language.entity.zxx',11),('config:language.mappings',1),('config:language.negotiation',1),('config:language.types',19),('config:locale.settings',1),('config:media.settings',1),('config:media.type.image_type',1),('config:media_library.settings',1),('config:media_type_list',3),('config:menu_list',1),('config:menu_ui.settings',1),('config:node.settings',1),('config:node.type.article',11),('config:node.type.home_page',1),('config:node.type.page',11),('config:node_type_list',2),('config:olivero.settings',1),('config:search.page.help_search',11),('config:search.page.node_search',11),('config:search.page.user_search',11),('config:search.settings',1),('config:shortcut.set.default',11),('config:system.action.comment_delete_action',11),('config:system.action.comment_publish_action',11),('config:system.action.comment_save_action',11),('config:system.action.comment_unpublish_action',11),('config:system.action.media_delete_action',9),('config:system.action.media_publish_action',9),('config:system.action.media_save_action',9),('config:system.action.media_unpublish_action',9),('config:system.action.node_delete_action',11),('config:system.action.node_make_sticky_action',11),('config:system.action.node_make_unsticky_action',11),('config:system.action.node_promote_action',11),('config:system.action.node_publish_action',11),('config:system.action.node_save_action',11),('config:system.action.node_unpromote_action',11),('config:system.action.node_unpublish_action',11),('config:system.action.taxonomy_term_publish_action',11),('config:system.action.taxonomy_term_unpublish_action',11),('config:system.action.user_block_user_action',11),('config:system.action.user_cancel_user_action',11),('config:system.action.user_unblock_user_action',11),('config:system.action.webform_archive_action',10),('config:system.action.webform_close_action',10),('config:system.action.webform_delete_action',10),('config:system.action.webform_open_action',10),('config:system.action.webform_submission_delete_action',10),('config:system.action.webform_submission_make_lock_action',10),('config:system.action.webform_submission_make_sticky_action',10),('config:system.action.webform_submission_make_unlock_action',10),('config:system.action.webform_submission_make_unsticky_action',10),('config:system.action.webform_unarchive_action',10),('config:system.advisories',1),('config:system.cron',1),('config:system.date',1),('config:system.diff',1),('config:system.feature_flags',1),('config:system.file',1),('config:system.image',1),('config:system.image.gd',1),('config:system.logging',1),('config:system.mail',2),('config:system.maintenance',11),('config:system.menu.account',150),('config:system.menu.admin',150),('config:system.menu.footer',150),('config:system.menu.main',158),('config:system.menu.tools',150),('config:system.performance',6),('config:system.rss',1),('config:system.site',12),('config:system.theme',5),('config:system.theme.global',3),('config:taxonomy.settings',1),('config:taxonomy.vocabulary.tags',11),('config:text.settings',1),('config:update.settings',1),('config:user.flood',1),('config:user.mail',11),('config:user.role.administrator',18),('config:user.role.anonymous',20),('config:user.role.authenticated',19),('config:user.role.content_editor',19),('config:user.settings',11),('config:user_role_list',9),('config:views.settings',1),('config:views.view.archive',11),('config:views.view.block_content',11),('config:views.view.comment',11),('config:views.view.comments_recent',11),('config:views.view.content',11),('config:views.view.content_recent',11),('config:views.view.files',11),('config:views.view.frontpage',11),('config:views.view.glossary',11),('config:views.view.media',4),('config:views.view.media_library',4),('config:views.view.taxonomy_term',11),('config:views.view.user_admin_people',11),('config:views.view.watchdog',11),('config:views.view.webform_submissions',11),('config:views.view.who_s_new',11),('config:views.view.who_s_online',11),('config:view_list',2),('config:webform.settings',10),('config:webform.webform.contact',18),('config:webform.webform_options.country_codes',10),('config:webform.webform_options.country_names',10),('config:webform.webform_options.days',10),('config:webform.webform_options.education',10),('config:webform.webform_options.employment_status',10),('config:webform.webform_options.ethnicity',10),('config:webform.webform_options.gender',10),('config:webform.webform_options.industry',10),('config:webform.webform_options.languages',10),('config:webform.webform_options.likert_agreement',10),('config:webform.webform_options.likert_comparison',10),('config:webform.webform_options.likert_importance',10),('config:webform.webform_options.likert_quality',10),('config:webform.webform_options.likert_satisfaction',10),('config:webform.webform_options.likert_ten_scale',10),('config:webform.webform_options.likert_would_you',10),('config:webform.webform_options.marital_status',10),('config:webform.webform_options.months',10),('config:webform.webform_options.phone_types',10),('config:webform.webform_options.province_codes',10),('config:webform.webform_options.province_names',10),('config:webform.webform_options.relationship',10),('config:webform.webform_options.sex',10),('config:webform.webform_options.sex_icao',10),('config:webform.webform_options.size',10),('config:webform.webform_options.state_codes',10),('config:webform.webform_options.state_names',10),('config:webform.webform_options.state_province_codes',10),('config:webform.webform_options.state_province_names',10),('config:webform.webform_options.time_zones',10),('config:webform.webform_options.titles',10),('config:webform.webform_options.translations',10),('config:webform.webform_options.yes_no',10),('config:webform_list',9),('config:webform_options_custom_list',1),('config:webform_options_list',1),('entity_bundles',48),('entity_field_info',250),('entity_types',283),('file:1',1),('file:10',1),('file:11',1),('file:12',1),('file:13',1),('file:14',1),('file:15',1),('file:16',1),('file:17',1),('file:18',1),('file:19',1),('file:2',1),('file:20',1),('file:21',1),('file:22',1),('file:23',1),('file:24',1),('file:25',1),('file:26',1),('file:27',1),('file:28',2),('file:29',2),('file:3',1),('file:30',2),('file:31',2),('file:32',2),('file:4',1),('file:5',1),('file:6',1),('file:7',1),('file:8',1),('file:9',1),('file_list',55),('http_response',143),('library_info',5),('local_task',167),('media:1',1),('media_list',7),('media_list:image',7),('media_view',2),('menu_link_content:1',1),('menu_link_content:2',1),('menu_link_content:3',1),('menu_link_content:4',1),('menu_link_content:5',1),('menu_link_content:6',1),('menu_link_content:7',1),('menu_link_content_list',8),('menu_link_content_list:menu_link_content',8),('node:1',1),('node:10',13),('node:11',7),('node:2',1),('node:3',1),('node:4',1),('node:5',2),('node:6',1),('node:7',1),('node:8',2),('node:9',2),('node_list',40),('node_list:article',2),('node_list:home_page',5),('node_list:page',34),('node_view',17),('rendered',43),('routes',141),('route_match',154),('search_index:help_search',17),('search_index:node_search',13),('views_data',27),('webform_submission_list',9),('webform_submission_view',8);

--
-- Table structure for table `civicrm_acl`
--

CREATE TABLE `civicrm_acl` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique table ID',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'ACL Name.',
  `deny` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this ACL entry Allow  (0) or Deny (1) ?',
  `entity_table` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Table of the object possessing this ACL entry (Contact, Group, or ACL Group)',
  `entity_id` int unsigned DEFAULT NULL COMMENT 'ID of the object possessing this ACL',
  `operation` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'What operation does this ACL entry control?',
  `object_table` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'The table of the object controlled by this ACL entry',
  `object_id` int unsigned DEFAULT NULL COMMENT 'The ID of the object controlled by this ACL entry',
  `acl_table` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'If this is a grant/revoke entry, what table are we granting?',
  `acl_id` int unsigned DEFAULT NULL COMMENT 'ID of the ACL or ACL group being granted/revoked',
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT 'Is this property active?',
  `priority` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `index_acl_id` (`acl_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_acl`
--

INSERT INTO `civicrm_acl` VALUES (1,'Edit All Contacts',0,'civicrm_acl_role',1,'Edit','civicrm_group',0,NULL,NULL,1,1);

--
-- Table structure for table `civicrm_acl_cache`
--

CREATE TABLE `civicrm_acl_cache` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique table ID',
  `contact_id` int unsigned DEFAULT NULL COMMENT 'Foreign Key to Contact',
  `acl_id` int unsigned NOT NULL COMMENT 'Foreign Key to ACL',
  `modified_date` timestamp NULL DEFAULT NULL COMMENT 'When was this cache entry last modified',
  PRIMARY KEY (`id`),
  KEY `index_contact_id` (`contact_id`),
  KEY `index_acl_id` (`acl_id`),
  KEY `index_modified_date` (`modified_date`),
  CONSTRAINT `FK_civicrm_acl_cache_acl_id` FOREIGN KEY (`acl_id`) REFERENCES `civicrm_acl` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_acl_cache`
--


--
-- Table structure for table `civicrm_acl_contact_cache`
--

CREATE TABLE `civicrm_acl_contact_cache` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key',
  `user_id` int unsigned DEFAULT NULL COMMENT 'FK to civicrm_contact (could be null for anon user)',
  `contact_id` int unsigned NOT NULL COMMENT 'FK to civicrm_contact',
  `operation` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'What operation does this user have permission on?',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_user_contact_operation` (`user_id`,`contact_id`,`operation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_acl_contact_cache`
--


--
-- Table structure for table `civicrm_acl_entity_role`
--

CREATE TABLE `civicrm_acl_entity_role` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique table ID',
  `acl_role_id` int unsigned NOT NULL COMMENT 'Foreign Key to ACL Role (which is an option value pair and hence an implicit FK)',
  `entity_table` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Table of the object joined to the ACL Role (Contact or Group)',
  `entity_id` int unsigned NOT NULL COMMENT 'ID of the group/contact object being joined',
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT 'Is this property active?',
  PRIMARY KEY (`id`),
  KEY `index_role` (`acl_role_id`),
  KEY `index_entity` (`entity_table`,`entity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_acl_entity_role`
--

INSERT INTO `civicrm_acl_entity_role` VALUES (1,1,'civicrm_group',1,1);

--
-- Table structure for table `civicrm_action_log`
--

CREATE TABLE `civicrm_action_log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `contact_id` int unsigned DEFAULT NULL COMMENT 'FK to Contact ID',
  `entity_id` int unsigned NOT NULL COMMENT 'FK to id of the entity that the action was performed on. Pseudo - FK.',
  `entity_table` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'name of the entity table for the above id, e.g. civicrm_activity, civicrm_participant',
  `action_schedule_id` int unsigned NOT NULL COMMENT 'FK to the action schedule that this action originated from.',
  `action_date_time` datetime DEFAULT NULL COMMENT 'date time that the action was performed on.',
  `is_error` tinyint NOT NULL DEFAULT '0' COMMENT 'Was there any error sending the reminder?',
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Description / text in case there was an error encountered.',
  `repetition_number` int unsigned DEFAULT NULL COMMENT 'Keeps track of the sequence number of this repetition.',
  `reference_date` datetime DEFAULT NULL COMMENT 'Stores the date from the entity which triggered this reminder action (e.g. membership.end_date for most membership renewal reminders)',
  PRIMARY KEY (`id`),
  KEY `FK_civicrm_action_log_contact_id` (`contact_id`),
  KEY `FK_civicrm_action_log_action_schedule_id` (`action_schedule_id`),
  CONSTRAINT `FK_civicrm_action_log_action_schedule_id` FOREIGN KEY (`action_schedule_id`) REFERENCES `civicrm_action_schedule` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_action_log_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_action_log`
--


--
-- Table structure for table `civicrm_action_schedule`
--

CREATE TABLE `civicrm_action_schedule` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name of the scheduled action',
  `title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Title of the action(reminder)',
  `recipient` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Recipient',
  `limit_to` int DEFAULT NULL COMMENT 'Is this the recipient criteria limited to OR in addition to?',
  `entity_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Entity value',
  `entity_status` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Entity status',
  `start_action_offset` int unsigned DEFAULT '0' COMMENT 'Reminder Interval.',
  `start_action_unit` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Time units for reminder.',
  `start_action_condition` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Reminder Action',
  `start_action_date` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Entity date',
  `is_repeat` tinyint NOT NULL DEFAULT '0',
  `repetition_frequency_unit` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Time units for repetition of reminder.',
  `repetition_frequency_interval` int unsigned DEFAULT '0' COMMENT 'Time interval for repeating the reminder.',
  `end_frequency_unit` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Time units till repetition of reminder.',
  `end_frequency_interval` int unsigned DEFAULT '0' COMMENT 'Time interval till repeating the reminder.',
  `end_action` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Reminder Action till repeating the reminder.',
  `end_date` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Entity end date',
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT 'Is this option active?',
  `recipient_manual` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Contact IDs to which reminder should be sent.',
  `recipient_listing` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'listing based on recipient field.',
  `body_text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Body of the mailing in text format.',
  `body_html` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Body of the mailing in html format.',
  `sms_body_text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Content of the SMS text.',
  `subject` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Subject of mailing',
  `record_activity` tinyint NOT NULL DEFAULT '0' COMMENT 'Record Activity for this reminder?',
  `mapping_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Name/ID of the mapping to use on this table',
  `group_id` int unsigned DEFAULT NULL COMMENT 'FK to Group',
  `msg_template_id` int unsigned DEFAULT NULL COMMENT 'FK to the message template.',
  `sms_template_id` int unsigned DEFAULT NULL COMMENT 'FK to the message template.',
  `absolute_date` date DEFAULT NULL COMMENT 'Date on which the reminder be sent.',
  `from_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Name in "from" field',
  `from_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Email address in "from" field',
  `mode` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Email' COMMENT 'Send the message as email or sms or both.',
  `sms_provider_id` int unsigned DEFAULT NULL,
  `used_for` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Used for repeating entity',
  `filter_contact_language` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Used for multilingual installation',
  `communication_language` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Used for multilingual installation',
  `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'When was the scheduled reminder created.',
  `modified_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'When the reminder was created or modified.',
  `effective_start_date` timestamp NULL DEFAULT NULL COMMENT 'Earliest date to consider start events from.',
  `effective_end_date` timestamp NULL DEFAULT NULL COMMENT 'Latest date to consider end events from.',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_name` (`name`),
  KEY `FK_civicrm_action_schedule_group_id` (`group_id`),
  KEY `FK_civicrm_action_schedule_msg_template_id` (`msg_template_id`),
  KEY `FK_civicrm_action_schedule_sms_template_id` (`sms_template_id`),
  KEY `FK_civicrm_action_schedule_sms_provider_id` (`sms_provider_id`),
  CONSTRAINT `FK_civicrm_action_schedule_group_id` FOREIGN KEY (`group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_action_schedule_msg_template_id` FOREIGN KEY (`msg_template_id`) REFERENCES `civicrm_msg_template` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_action_schedule_sms_provider_id` FOREIGN KEY (`sms_provider_id`) REFERENCES `civicrm_sms_provider` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_action_schedule_sms_template_id` FOREIGN KEY (`sms_template_id`) REFERENCES `civicrm_msg_template` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_action_schedule`
--


--
-- Table structure for table `civicrm_activity`
--

CREATE TABLE `civicrm_activity` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique  Other Activity ID',
  `source_record_id` int unsigned DEFAULT NULL COMMENT 'Artificial FK to original transaction (e.g. contribution) IF it is not an Activity. Entity table is discovered by filtering by the appropriate activity_type_id.',
  `activity_type_id` int unsigned NOT NULL DEFAULT '1' COMMENT 'FK to civicrm_option_value.id, that has to be valid, registered activity type.',
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'The subject/purpose/short description of the activity.',
  `activity_date_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'Date and time this activity is scheduled to occur. Formerly named scheduled_date_time.',
  `duration` int unsigned DEFAULT NULL COMMENT 'Planned or actual duration of activity expressed in minutes. Conglomerate of former duration_hours and duration_minutes.',
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Location of the activity (optional, open text).',
  `phone_id` int unsigned DEFAULT NULL COMMENT 'Phone ID of the number called (optional - used if an existing phone number is selected).',
  `phone_number` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Phone number in case the number does not exist in the civicrm_phone table.',
  `details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Details about the activity (agenda, notes, etc).',
  `status_id` int unsigned DEFAULT NULL COMMENT 'ID of the status this activity is currently in. Foreign key to civicrm_option_value.',
  `priority_id` int unsigned DEFAULT NULL COMMENT 'ID of the priority given to this activity. Foreign key to civicrm_option_value.',
  `parent_id` int unsigned DEFAULT NULL COMMENT 'Parent meeting ID (if this is a follow-up item).',
  `is_test` tinyint NOT NULL DEFAULT '0',
  `medium_id` int unsigned DEFAULT NULL COMMENT 'Activity Medium, Implicit FK to civicrm_option_value where option_group = encounter_medium.',
  `is_auto` tinyint NOT NULL DEFAULT '0',
  `relationship_id` int unsigned DEFAULT NULL COMMENT 'FK to Relationship ID',
  `is_current_revision` tinyint NOT NULL DEFAULT '1' COMMENT 'Unused deprecated column.',
  `original_id` int unsigned DEFAULT NULL COMMENT 'Unused deprecated column.',
  `result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Currently being used to store result id for survey activity, FK to option value.',
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `campaign_id` int unsigned DEFAULT NULL COMMENT 'The campaign for which this activity has been triggered.',
  `engagement_level` int unsigned DEFAULT NULL COMMENT 'Assign a specific level of engagement to this activity. Used for tracking constituents in ladder of engagement.',
  `weight` int DEFAULT NULL,
  `is_star` tinyint NOT NULL DEFAULT '0' COMMENT 'Activity marked as favorite.',
  `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'When was the activity was created.',
  `modified_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'When was the activity (or closely related entity) was created or modified or deleted.',
  PRIMARY KEY (`id`),
  KEY `UI_source_record_id` (`source_record_id`),
  KEY `UI_activity_type_id` (`activity_type_id`),
  KEY `index_activity_date_time` (`activity_date_time`),
  KEY `index_status_id` (`status_id`),
  KEY `index_is_current_revision` (`is_current_revision`),
  KEY `index_is_deleted` (`is_deleted`),
  KEY `FK_civicrm_activity_phone_id` (`phone_id`),
  KEY `FK_civicrm_activity_parent_id` (`parent_id`),
  KEY `FK_civicrm_activity_relationship_id` (`relationship_id`),
  KEY `FK_civicrm_activity_original_id` (`original_id`),
  KEY `FK_civicrm_activity_campaign_id` (`campaign_id`),
  CONSTRAINT `FK_civicrm_activity_campaign_id` FOREIGN KEY (`campaign_id`) REFERENCES `civicrm_campaign` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_activity_original_id` FOREIGN KEY (`original_id`) REFERENCES `civicrm_activity` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_activity_parent_id` FOREIGN KEY (`parent_id`) REFERENCES `civicrm_activity` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_activity_phone_id` FOREIGN KEY (`phone_id`) REFERENCES `civicrm_phone` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_activity_relationship_id` FOREIGN KEY (`relationship_id`) REFERENCES `civicrm_relationship` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_activity`
--


--
-- Table structure for table `civicrm_activity_contact`
--

CREATE TABLE `civicrm_activity_contact` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Activity contact id',
  `activity_id` int unsigned NOT NULL COMMENT 'Foreign key to the activity for this record.',
  `contact_id` int unsigned NOT NULL COMMENT 'Foreign key to the contact for this record.',
  `record_type_id` int unsigned DEFAULT NULL COMMENT 'Determines the contact''s role in the activity (source, target, or assignee).',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_activity_contact` (`contact_id`,`activity_id`,`record_type_id`),
  KEY `index_record_type` (`activity_id`,`record_type_id`),
  CONSTRAINT `FK_civicrm_activity_contact_activity_id` FOREIGN KEY (`activity_id`) REFERENCES `civicrm_activity` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_activity_contact_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_activity_contact`
--


--
-- Table structure for table `civicrm_address`
--

CREATE TABLE `civicrm_address` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Address ID',
  `contact_id` int unsigned DEFAULT NULL COMMENT 'FK to Contact ID',
  `location_type_id` int unsigned DEFAULT NULL COMMENT 'Which Location does this address belong to.',
  `is_primary` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this the primary address.',
  `is_billing` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this the billing address.',
  `street_address` varchar(96) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Concatenation of all routable street address components (prefix, street number, street name, suffix, unit\n      number OR P.O. Box). Apps should be able to determine physical location with this data (for mapping, mail\n      delivery, etc.).',
  `street_number` int DEFAULT NULL COMMENT 'Numeric portion of address number on the street, e.g. For 112A Main St, the street_number = 112.',
  `street_number_suffix` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Non-numeric portion of address number on the street, e.g. For 112A Main St, the street_number_suffix = A',
  `street_number_predirectional` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Directional prefix, e.g. SE Main St, SE is the prefix.',
  `street_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Actual street name, excluding St, Dr, Rd, Ave, e.g. For 112 Main St, the street_name = Main.',
  `street_type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'St, Rd, Dr, etc.',
  `street_number_postdirectional` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Directional prefix, e.g. Main St S, S is the suffix.',
  `street_unit` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Secondary unit designator, e.g. Apt 3 or Unit # 14, or Bldg 1200',
  `supplemental_address_1` varchar(96) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Supplemental Address Information, Line 1',
  `supplemental_address_2` varchar(96) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Supplemental Address Information, Line 2',
  `supplemental_address_3` varchar(96) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Supplemental Address Information, Line 3',
  `city` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'City, Town or Village Name.',
  `county_id` int unsigned DEFAULT NULL COMMENT 'Which County does this address belong to.',
  `state_province_id` int unsigned DEFAULT NULL COMMENT 'Which State_Province does this address belong to.',
  `postal_code_suffix` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Store the suffix, like the +4 part in the USPS system.',
  `postal_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Store both US (zip5) AND international postal codes. App is responsible for country/region appropriate validation.',
  `usps_adc` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'USPS Bulk mailing code.',
  `country_id` int unsigned DEFAULT NULL COMMENT 'Which Country does this address belong to.',
  `geo_code_1` double DEFAULT NULL COMMENT 'Latitude',
  `geo_code_2` double DEFAULT NULL COMMENT 'Longitude',
  `manual_geo_code` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this a manually entered geo code',
  `timezone` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Timezone expressed as a UTC offset - e.g. United States CST would be written as "UTC-6".',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `master_id` int unsigned DEFAULT NULL COMMENT 'FK to Address ID',
  PRIMARY KEY (`id`),
  KEY `index_location_type` (`location_type_id`),
  KEY `index_is_primary` (`is_primary`),
  KEY `index_is_billing` (`is_billing`),
  KEY `index_street_name` (`street_name`),
  KEY `index_city` (`city`),
  KEY `index_geo_code_1_geo_code_2` (`geo_code_1`,`geo_code_2`),
  KEY `FK_civicrm_address_contact_id` (`contact_id`),
  KEY `FK_civicrm_address_county_id` (`county_id`),
  KEY `FK_civicrm_address_state_province_id` (`state_province_id`),
  KEY `FK_civicrm_address_country_id` (`country_id`),
  KEY `FK_civicrm_address_master_id` (`master_id`),
  CONSTRAINT `FK_civicrm_address_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_address_country_id` FOREIGN KEY (`country_id`) REFERENCES `civicrm_country` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_address_county_id` FOREIGN KEY (`county_id`) REFERENCES `civicrm_county` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_address_master_id` FOREIGN KEY (`master_id`) REFERENCES `civicrm_address` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_address_state_province_id` FOREIGN KEY (`state_province_id`) REFERENCES `civicrm_state_province` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_address`
--


--
-- Table structure for table `civicrm_address_format`
--

CREATE TABLE `civicrm_address_format` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Address Format ID',
  `format` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'The format of an address',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_address_format`
--


--
-- Table structure for table `civicrm_batch`
--

CREATE TABLE `civicrm_batch` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Address ID',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Variable name/programmatic handle for this batch.',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Friendly Name.',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Description of this batch set.',
  `created_id` int unsigned DEFAULT NULL COMMENT 'FK to Contact ID',
  `created_date` datetime DEFAULT NULL COMMENT 'When was this item created',
  `modified_id` int unsigned DEFAULT NULL COMMENT 'FK to Contact ID',
  `modified_date` datetime DEFAULT NULL COMMENT 'When was this item modified',
  `saved_search_id` int unsigned DEFAULT NULL COMMENT 'FK to Saved Search ID',
  `status_id` int unsigned NOT NULL COMMENT 'fk to Batch Status options in civicrm_option_values',
  `type_id` int unsigned DEFAULT NULL COMMENT 'fk to Batch Type options in civicrm_option_values',
  `mode_id` int unsigned DEFAULT NULL COMMENT 'fk to Batch mode options in civicrm_option_values',
  `total` decimal(20,2) DEFAULT NULL COMMENT 'Total amount for this batch.',
  `item_count` int unsigned DEFAULT NULL COMMENT 'Number of items in a batch.',
  `payment_instrument_id` int unsigned DEFAULT NULL COMMENT 'fk to Payment Instrument options in civicrm_option_values',
  `exported_date` datetime DEFAULT NULL,
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'cache entered data',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_name` (`name`),
  KEY `FK_civicrm_batch_created_id` (`created_id`),
  KEY `FK_civicrm_batch_modified_id` (`modified_id`),
  KEY `FK_civicrm_batch_saved_search_id` (`saved_search_id`),
  CONSTRAINT `FK_civicrm_batch_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_batch_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_batch_saved_search_id` FOREIGN KEY (`saved_search_id`) REFERENCES `civicrm_saved_search` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_batch`
--


--
-- Table structure for table `civicrm_cache`
--

CREATE TABLE `civicrm_cache` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique table ID',
  `group_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'group name for cache element, useful in cleaning cache elements',
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Unique path name for cache element',
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'data associated with this path',
  `component_id` int unsigned DEFAULT NULL COMMENT 'Component that this menu item belongs to',
  `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'When was the cache item created',
  `expired_date` timestamp NULL DEFAULT NULL COMMENT 'When should the cache item expire',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_group_name_path` (`group_name`,`path`),
  KEY `index_expired_date` (`expired_date`),
  KEY `FK_civicrm_cache_component_id` (`component_id`),
  CONSTRAINT `FK_civicrm_cache_component_id` FOREIGN KEY (`component_id`) REFERENCES `civicrm_component` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=219 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_cache`
--

INSERT INTO `civicrm_cache` VALUES (1,'settings','settingsMetadata_1_','[encoded data, 153932 characters]',NULL,'2024-02-09 09:56:36','2024-02-09 15:56:37'),(2,'settings','defaults_domain','[encoded data, 11196 characters]',NULL,'2024-02-09 09:56:36','2024-02-09 15:56:37'),(3,'44947b8307d689cc0eac0f7f4e9398b0','mapper_moduleFiles','YToxMTp7aTowO2E6Mzp7czo2OiJwcmVmaXgiO3M6MjE6InNlcXVlbnRpYWxjcmVkaXRub3RlcyI7czo4OiJmdWxsTmFtZSI7czoyMToic2VxdWVudGlhbGNyZWRpdG5vdGVzIjtzOjg6ImZpbGVQYXRoIjtOO31pOjE7YTozOntzOjY6InByZWZpeCI7czo5OiJncmVlbndpY2giO3M6ODoiZnVsbE5hbWUiO3M6OToiZ3JlZW53aWNoIjtzOjg6ImZpbGVQYXRoIjtOO31pOjI7YTozOntzOjY6InByZWZpeCI7czoxMzoiZmluYW5jaWFsYWNscyI7czo4OiJmdWxsTmFtZSI7czoxMzoiZmluYW5jaWFsYWNscyI7czo4OiJmaWxlUGF0aCI7Tjt9aTozO2E6Mzp7czo2OiJwcmVmaXgiO3M6OToicmVjYXB0Y2hhIjtzOjg6ImZ1bGxOYW1lIjtzOjk6InJlY2FwdGNoYSI7czo4OiJmaWxlUGF0aCI7Tjt9aTo0O2E6Mzp7czo2OiJwcmVmaXgiO3M6OToiY2tlZGl0b3I0IjtzOjg6ImZ1bGxOYW1lIjtzOjk6ImNrZWRpdG9yNCI7czo4OiJmaWxlUGF0aCI7Tjt9aTo1O2E6Mzp7czo2OiJwcmVmaXgiO3M6MTA6ImZsZXhtYWlsZXIiO3M6ODoiZnVsbE5hbWUiO3M6MjI6Im9yZy5jaXZpY3JtLmZsZXhtYWlsZXIiO3M6ODoiZmlsZVBhdGgiO047fWk6NjthOjM6e3M6NjoicHJlZml4IjtzOjE1OiJjaXZpX2NvbnRyaWJ1dGUiO3M6ODoiZnVsbE5hbWUiO3M6MTU6ImNpdmlfY29udHJpYnV0ZSI7czo4OiJmaWxlUGF0aCI7Tjt9aTo3O2E6Mzp7czo2OiJwcmVmaXgiO3M6MTA6ImNpdmlfZXZlbnQiO3M6ODoiZnVsbE5hbWUiO3M6MTA6ImNpdmlfZXZlbnQiO3M6ODoiZmlsZVBhdGgiO047fWk6ODthOjM6e3M6NjoicHJlZml4IjtzOjk6ImNpdmlfbWFpbCI7czo4OiJmdWxsTmFtZSI7czo5OiJjaXZpX21haWwiO3M6ODoiZmlsZVBhdGgiO047fWk6OTthOjM6e3M6NjoicHJlZml4IjtzOjExOiJjaXZpX21lbWJlciI7czo4OiJmdWxsTmFtZSI7czoxMToiY2l2aV9tZW1iZXIiO3M6ODoiZmlsZVBhdGgiO047fWk6MTA7YTozOntzOjY6InByZWZpeCI7czoxMToiY2l2aV9yZXBvcnQiO3M6ODoiZnVsbE5hbWUiO3M6MTE6ImNpdmlfcmVwb3J0IjtzOjg6ImZpbGVQYXRoIjtOO319',NULL,'2024-02-05 12:40:33','2024-02-05 18:40:33'),(4,'44947b8307d689cc0eac0f7f4e9398b0','civicrm_tools','YToyOntzOjIxOiJvcmcuY2l2aWNybS5kZW1vcXVldWUiO3M6MzM6Ii9leHRlbnNpb25zL29yZy5jaXZpY3JtLmRlbW9xdWV1ZSI7czo4OiJwaHBzdG9ybSI7czoyMDoiL2V4dGVuc2lvbnMvcGhwc3Rvcm0iO30=',NULL,'2024-02-05 12:40:33','2024-02-05 18:40:33'),(5,'44947b8307d689cc0eac0f7f4e9398b0','civicrm_ext','YTozNTp7czo1OiJhdXRoeCI7czo2OiIvYXV0aHgiO3M6MTM6ImNpdmlfY2FtcGFpZ24iO3M6MTQ6Ii9jaXZpX2NhbXBhaWduIjtzOjk6ImNpdmlfY2FzZSI7czoxMDoiL2NpdmlfY2FzZSI7czoxNToiY2l2aV9jb250cmlidXRlIjtzOjE2OiIvY2l2aV9jb250cmlidXRlIjtzOjEwOiJjaXZpX2V2ZW50IjtzOjExOiIvY2l2aV9ldmVudCI7czo5OiJjaXZpX21haWwiO3M6MTA6Ii9jaXZpX21haWwiO3M6MTE6ImNpdmlfbWVtYmVyIjtzOjEyOiIvY2l2aV9tZW1iZXIiO3M6MTE6ImNpdmlfcGxlZGdlIjtzOjEyOiIvY2l2aV9wbGVkZ2UiO3M6MTE6ImNpdmlfcmVwb3J0IjtzOjEyOiIvY2l2aV9yZXBvcnQiO3M6MTY6ImNpdmljcm1fYWRtaW5fdWkiO3M6MTc6Ii9jaXZpY3JtX2FkbWluX3VpIjtzOjE3OiJjaXZpY3JtX3NlYXJjaF91aSI7czoxODoiL2Npdmljcm1fc2VhcmNoX3VpIjtzOjk6ImNpdmlncmFudCI7czoxMDoiL2NpdmlncmFudCI7czoxMDoiY2l2aWltcG9ydCI7czoxMToiL2NpdmlpbXBvcnQiO3M6OToiY2tlZGl0b3I0IjtzOjEwOiIvY2tlZGl0b3I0IjtzOjI1OiJjb250cmlidXRpb25jYW5jZWxhY3Rpb25zIjtzOjI2OiIvY29udHJpYnV0aW9uY2FuY2VsYWN0aW9ucyI7czo2OiJlbGF2b24iO3M6NzoiL2VsYXZvbiI7czo5OiJldmVudGNhcnQiO3M6MTA6Ii9ldmVudGNhcnQiO3M6MTA6ImV3YXlzaW5nbGUiO3M6MTE6Ii9ld2F5c2luZ2xlIjtzOjEzOiJmaW5hbmNpYWxhY2xzIjtzOjE0OiIvZmluYW5jaWFsYWNscyI7czoyMjoib3JnLmNpdmljcm0uZmxleG1haWxlciI7czoxMToiL2ZsZXhtYWlsZXIiO3M6OToiZ3JlZW53aWNoIjtzOjEwOiIvZ3JlZW53aWNoIjtzOjIwOiJsZWdhY3ljdXN0b21zZWFyY2hlcyI7czoyMToiL2xlZ2FjeWN1c3RvbXNlYXJjaGVzIjtzOjEzOiJtZXNzYWdlX2FkbWluIjtzOjE0OiIvbWVzc2FnZV9hZG1pbiI7czoxMjoib2F1dGgtY2xpZW50IjtzOjEzOiIvb2F1dGgtY2xpZW50IjtzOjEwOiJwYXlmbG93cHJvIjtzOjExOiIvcGF5Zmxvd3BybyI7czo5OiJyZWNhcHRjaGEiO3M6MTA6Ii9yZWNhcHRjaGEiO3M6MjQ6InNjaGVkdWxlZF9jb21tdW5pY2F0aW9ucyI7czoyNToiL3NjaGVkdWxlZF9jb21tdW5pY2F0aW9ucyI7czoyMjoib3JnLmNpdmljcm0uc2VhcmNoX2tpdCI7czoxMToiL3NlYXJjaF9raXQiO3M6MjE6InNlcXVlbnRpYWxjcmVkaXRub3RlcyI7czoyMjoiL3NlcXVlbnRpYWxjcmVkaXRub3RlcyI7czoxNToic3RhbmRhbG9uZXVzZXJzIjtzOjE2OiIvc3RhbmRhbG9uZXVzZXJzIjtzOjE0OiJ1c2VyX2Rhc2hib2FyZCI7czoxNToiL3VzZXJfZGFzaGJvYXJkIjtzOjI0OiJvcmcuY2l2aWNybS5hZmZvcm1fYWRtaW4iO3M6MTM6Ii9hZmZvcm0vYWRtaW4iO3M6MTg6Im9yZy5jaXZpY3JtLmFmZm9ybSI7czoxMjoiL2FmZm9ybS9jb3JlIjtzOjIzOiJvcmcuY2l2aWNybS5hZmZvcm0taHRtbCI7czoxMjoiL2FmZm9ybS9odG1sIjtzOjIzOiJvcmcuY2l2aWNybS5hZmZvcm0tbW9jayI7czoxMjoiL2FmZm9ybS9tb2NrIjt9',NULL,'2024-02-05 12:40:33','2024-02-05 18:40:33'),(6,'44947b8307d689cc0eac0f7f4e9398b0','default','YTowOnt9',NULL,'2024-02-05 12:40:33','2024-02-05 18:40:33'),(7,'44947b8307d689cc0eac0f7f4e9398b0','full','YTozNzp7czoyMToib3JnLmNpdmljcm0uZGVtb3F1ZXVlIjtzOjEzOiJjaXZpY3JtX3Rvb2xzIjtzOjg6InBocHN0b3JtIjtzOjEzOiJjaXZpY3JtX3Rvb2xzIjtzOjU6ImF1dGh4IjtzOjExOiJjaXZpY3JtX2V4dCI7czoxMzoiY2l2aV9jYW1wYWlnbiI7czoxMToiY2l2aWNybV9leHQiO3M6OToiY2l2aV9jYXNlIjtzOjExOiJjaXZpY3JtX2V4dCI7czoxNToiY2l2aV9jb250cmlidXRlIjtzOjExOiJjaXZpY3JtX2V4dCI7czoxMDoiY2l2aV9ldmVudCI7czoxMToiY2l2aWNybV9leHQiO3M6OToiY2l2aV9tYWlsIjtzOjExOiJjaXZpY3JtX2V4dCI7czoxMToiY2l2aV9tZW1iZXIiO3M6MTE6ImNpdmljcm1fZXh0IjtzOjExOiJjaXZpX3BsZWRnZSI7czoxMToiY2l2aWNybV9leHQiO3M6MTE6ImNpdmlfcmVwb3J0IjtzOjExOiJjaXZpY3JtX2V4dCI7czoxNjoiY2l2aWNybV9hZG1pbl91aSI7czoxMToiY2l2aWNybV9leHQiO3M6MTc6ImNpdmljcm1fc2VhcmNoX3VpIjtzOjExOiJjaXZpY3JtX2V4dCI7czo5OiJjaXZpZ3JhbnQiO3M6MTE6ImNpdmljcm1fZXh0IjtzOjEwOiJjaXZpaW1wb3J0IjtzOjExOiJjaXZpY3JtX2V4dCI7czo5OiJja2VkaXRvcjQiO3M6MTE6ImNpdmljcm1fZXh0IjtzOjI1OiJjb250cmlidXRpb25jYW5jZWxhY3Rpb25zIjtzOjExOiJjaXZpY3JtX2V4dCI7czo2OiJlbGF2b24iO3M6MTE6ImNpdmljcm1fZXh0IjtzOjk6ImV2ZW50Y2FydCI7czoxMToiY2l2aWNybV9leHQiO3M6MTA6ImV3YXlzaW5nbGUiO3M6MTE6ImNpdmljcm1fZXh0IjtzOjEzOiJmaW5hbmNpYWxhY2xzIjtzOjExOiJjaXZpY3JtX2V4dCI7czoyMjoib3JnLmNpdmljcm0uZmxleG1haWxlciI7czoxMToiY2l2aWNybV9leHQiO3M6OToiZ3JlZW53aWNoIjtzOjExOiJjaXZpY3JtX2V4dCI7czoyMDoibGVnYWN5Y3VzdG9tc2VhcmNoZXMiO3M6MTE6ImNpdmljcm1fZXh0IjtzOjEzOiJtZXNzYWdlX2FkbWluIjtzOjExOiJjaXZpY3JtX2V4dCI7czoxMjoib2F1dGgtY2xpZW50IjtzOjExOiJjaXZpY3JtX2V4dCI7czoxMDoicGF5Zmxvd3BybyI7czoxMToiY2l2aWNybV9leHQiO3M6OToicmVjYXB0Y2hhIjtzOjExOiJjaXZpY3JtX2V4dCI7czoyNDoic2NoZWR1bGVkX2NvbW11bmljYXRpb25zIjtzOjExOiJjaXZpY3JtX2V4dCI7czoyMjoib3JnLmNpdmljcm0uc2VhcmNoX2tpdCI7czoxMToiY2l2aWNybV9leHQiO3M6MjE6InNlcXVlbnRpYWxjcmVkaXRub3RlcyI7czoxMToiY2l2aWNybV9leHQiO3M6MTU6InN0YW5kYWxvbmV1c2VycyI7czoxMToiY2l2aWNybV9leHQiO3M6MTQ6InVzZXJfZGFzaGJvYXJkIjtzOjExOiJjaXZpY3JtX2V4dCI7czoyNDoib3JnLmNpdmljcm0uYWZmb3JtX2FkbWluIjtzOjExOiJjaXZpY3JtX2V4dCI7czoxODoib3JnLmNpdmljcm0uYWZmb3JtIjtzOjExOiJjaXZpY3JtX2V4dCI7czoyMzoib3JnLmNpdmljcm0uYWZmb3JtLWh0bWwiO3M6MTE6ImNpdmljcm1fZXh0IjtzOjIzOiJvcmcuY2l2aWNybS5hZmZvcm0tbW9jayI7czoxMToiY2l2aWNybV9leHQiO30=',NULL,'2024-02-05 12:40:33','2024-02-05 18:40:33'),(8,'44947b8307d689cc0eac0f7f4e9398b0','mixinScan','[encoded data, 4208 characters]',NULL,'2024-02-05 12:40:33','2024-02-06 12:40:33'),(9,'44947b8307d689cc0eac0f7f4e9398b0','mixinBoot','TzoyMzoiQ1JNX0V4dGVuc2lvbl9Cb290Q2FjaGUiOjI6e3M6OToiACoAbG9ja2VkIjtiOjE7czo3OiIAKgBkYXRhIjtOO30=',NULL,'2024-02-05 12:40:33','2024-02-06 12:40:33'),(10,'metadata_5_69_4','implied_permissions','YTo0OntzOjEyOiJhZGQgY29udGFjdHMiO2E6MTp7aTowO3M6MzI6ImFsbCBDaXZpQ1JNIHBlcm1pc3Npb25zIGFuZCBBQ0xzIjt9czoxMToiZWRpdCBncm91cHMiO2E6MTp7aTowO3M6MzI6ImFsbCBDaXZpQ1JNIHBlcm1pc3Npb25zIGFuZCBBQ0xzIjt9czoxNToidmlldyBldmVudCBpbmZvIjthOjE6e2k6MDtzOjMyOiJhbGwgQ2l2aUNSTSBwZXJtaXNzaW9ucyBhbmQgQUNMcyI7fXM6MTc6InZpZXcgYWxsIGNvbnRhY3RzIjthOjE6e2k6MDtzOjMyOiJhbGwgQ2l2aUNSTSBwZXJtaXNzaW9ucyBhbmQgQUNMcyI7fX0=',NULL,'2024-02-09 10:00:36','2024-02-09 16:00:37'),(11,'long','theme_list_cb706dac6ffa5db9ab83994c67f6e5bb','YTo0OntzOjc6ImRlZmF1bHQiO2E6Njp7czo0OiJuYW1lIjtzOjc6ImRlZmF1bHQiO3M6MTI6InVybF9jYWxsYmFjayI7czozNToiXENpdmlcQ29yZVxUaGVtZXNcUmVzb2x2ZXJzOjpzaW1wbGUiO3M6MTI6InNlYXJjaF9vcmRlciI7YToyOntpOjA7czo3OiJkZWZhdWx0IjtpOjE7czoxMDoiX2ZhbGxiYWNrXyI7fXM6MzoiZXh0IjtzOjc6ImNpdmljcm0iO3M6NToidGl0bGUiO3M6OToiQXV0b21hdGljIjtzOjQ6ImhlbHAiO3M6NDA6IkRldGVybWluZSBhIHN5c3RlbSBkZWZhdWx0IGF1dG9tYXRpY2FsbHkiO31zOjk6ImdyZWVud2ljaCI7YTo2OntzOjQ6Im5hbWUiO3M6OToiZ3JlZW53aWNoIjtzOjEyOiJ1cmxfY2FsbGJhY2siO3M6MzU6IlxDaXZpXENvcmVcVGhlbWVzXFJlc29sdmVyczo6c2ltcGxlIjtzOjEyOiJzZWFyY2hfb3JkZXIiO2E6Mjp7aTowO3M6OToiZ3JlZW53aWNoIjtpOjE7czoxMDoiX2ZhbGxiYWNrXyI7fXM6MzoiZXh0IjtzOjc6ImNpdmljcm0iO3M6NToidGl0bGUiO3M6OToiR3JlZW53aWNoIjtzOjQ6ImhlbHAiO3M6MjU6IkNpdmlDUk0gNC54IGxvb2stYW5kLWZlZWwiO31zOjQ6Im5vbmUiO2E6Nzp7czo0OiJuYW1lIjtzOjQ6Im5vbmUiO3M6MTI6InVybF9jYWxsYmFjayI7czozNToiXENpdmlcQ29yZVxUaGVtZXNcUmVzb2x2ZXJzOjpzaW1wbGUiO3M6MTI6InNlYXJjaF9vcmRlciI7YToyOntpOjA7czo0OiJub25lIjtpOjE7czoxMDoiX2ZhbGxiYWNrXyI7fXM6MzoiZXh0IjtzOjc6ImNpdmljcm0iO3M6NToidGl0bGUiO3M6MTU6Ik5vbmUgKFVuc3R5bGVkKSI7czo0OiJoZWxwIjtzOjM3OiJEaXNhYmxlIENpdmlDUk0ncyBidWlsdC1pbiBDU1MgZmlsZXMuIjtzOjg6ImV4Y2x1ZGVzIjthOjI6e2k6MDtzOjE1OiJjc3MvY2l2aWNybS5jc3MiO2k6MTtzOjE3OiJjc3MvYm9vdHN0cmFwLmNzcyI7fX1zOjEwOiJfZmFsbGJhY2tfIjthOjU6e3M6NDoibmFtZSI7czoxMDoiX2ZhbGxiYWNrXyI7czoxMjoidXJsX2NhbGxiYWNrIjtzOjM3OiJcQ2l2aVxDb3JlXFRoZW1lc1xSZXNvbHZlcnM6OmZhbGxiYWNrIjtzOjEyOiJzZWFyY2hfb3JkZXIiO2E6MTp7aTowO3M6MTA6Il9mYWxsYmFja18iO31zOjM6ImV4dCI7czo3OiJjaXZpY3JtIjtzOjU6InRpdGxlIjtzOjMwOiJGYWxsYmFjayAoQWJzdHJhY3QgQmFzZSBUaGVtZSkiO319',NULL,'2024-02-05 12:40:34','2024-02-05 18:40:34'),(12,'contactTypes','all_en_US','YTozOntzOjEwOiJJbmRpdmlkdWFsIjthOjExOntzOjI6ImlkIjtpOjE7czo0OiJuYW1lIjtzOjEwOiJJbmRpdmlkdWFsIjtzOjU6ImxhYmVsIjtzOjEwOiJJbmRpdmlkdWFsIjtzOjExOiJkZXNjcmlwdGlvbiI7czowOiIiO3M6OToiaW1hZ2VfVVJMIjtzOjA6IiI7czo0OiJpY29uIjtzOjc6ImZhLXVzZXIiO3M6OToicGFyZW50X2lkIjtOO3M6OToiaXNfYWN0aXZlIjtiOjE7czoxMToiaXNfcmVzZXJ2ZWQiO2I6MTtzOjY6InBhcmVudCI7TjtzOjEyOiJwYXJlbnRfbGFiZWwiO047fXM6OToiSG91c2Vob2xkIjthOjExOntzOjI6ImlkIjtpOjI7czo0OiJuYW1lIjtzOjk6IkhvdXNlaG9sZCI7czo1OiJsYWJlbCI7czo5OiJIb3VzZWhvbGQiO3M6MTE6ImRlc2NyaXB0aW9uIjtzOjA6IiI7czo5OiJpbWFnZV9VUkwiO3M6MDoiIjtzOjQ6Imljb24iO3M6NzoiZmEtaG9tZSI7czo5OiJwYXJlbnRfaWQiO047czo5OiJpc19hY3RpdmUiO2I6MTtzOjExOiJpc19yZXNlcnZlZCI7YjoxO3M6NjoicGFyZW50IjtOO3M6MTI6InBhcmVudF9sYWJlbCI7Tjt9czoxMjoiT3JnYW5pemF0aW9uIjthOjExOntzOjI6ImlkIjtpOjM7czo0OiJuYW1lIjtzOjEyOiJPcmdhbml6YXRpb24iO3M6NToibGFiZWwiO3M6MTI6Ik9yZ2FuaXphdGlvbiI7czoxMToiZGVzY3JpcHRpb24iO3M6MDoiIjtzOjk6ImltYWdlX1VSTCI7czowOiIiO3M6NDoiaWNvbiI7czoxMToiZmEtYnVpbGRpbmciO3M6OToicGFyZW50X2lkIjtOO3M6OToiaXNfYWN0aXZlIjtiOjE7czoxMToiaXNfcmVzZXJ2ZWQiO2I6MTtzOjY6InBhcmVudCI7TjtzOjEyOiJwYXJlbnRfbGFiZWwiO047fX0=',NULL,'2024-02-09 09:56:37','2024-02-09 15:56:38'),(13,'metadata_5_69_4','CRM_Core_BAO_OptionValue_OptionGroupID_56_en_US','YToyOntpOjM5NzthOjExOntzOjI6ImlkIjtzOjM6IjM5NyI7czoxNToib3B0aW9uX2dyb3VwX2lkIjtzOjI6IjU2IjtzOjU6ImxhYmVsIjtzOjY6IlN1cnZleSI7czo1OiJ2YWx1ZSI7czo2OiJTdXJ2ZXkiO3M6NDoibmFtZSI7czoxNDoiY2l2aWNybV9zdXJ2ZXkiO3M6NjoiZmlsdGVyIjtzOjE6IjAiO3M6MTA6ImlzX2RlZmF1bHQiO3M6MToiMCI7czo2OiJ3ZWlnaHQiO3M6MToiMSI7czoxMToiaXNfb3B0Z3JvdXAiO3M6MToiMCI7czoxMToiaXNfcmVzZXJ2ZWQiO3M6MToiMCI7czo5OiJpc19hY3RpdmUiO3M6MToiMSI7fWk6Mzk4O2E6MTI6e3M6MjoiaWQiO3M6MzoiMzk4IjtzOjE1OiJvcHRpb25fZ3JvdXBfaWQiO3M6MjoiNTYiO3M6NToibGFiZWwiO3M6NToiQ2FzZXMiO3M6NToidmFsdWUiO3M6NDoiQ2FzZSI7czo0OiJuYW1lIjtzOjEyOiJjaXZpY3JtX2Nhc2UiO3M6ODoiZ3JvdXBpbmciO3M6MTI6ImNhc2VfdHlwZV9pZCI7czo2OiJmaWx0ZXIiO3M6MToiMCI7czoxMDoiaXNfZGVmYXVsdCI7czoxOiIwIjtzOjY6IndlaWdodCI7czoxOiIyIjtzOjExOiJpc19vcHRncm91cCI7czoxOiIwIjtzOjExOiJpc19yZXNlcnZlZCI7czoxOiIwIjtzOjk6ImlzX2FjdGl2ZSI7czoxOiIxIjt9fQ==',NULL,'2024-02-09 09:56:37','2024-02-09 15:56:38'),(14,'metadata_5_69_4','api4.entities.info','[encoded data, 144900 characters]',NULL,'2024-02-09 09:56:38','2024-02-09 15:56:38'),(15,'metadata_5_69_4','CRM_OG_customdatatype_e3108101847538c839aa4fb9cc9fdd39','YTozOntzOjE1OiJQYXJ0aWNpcGFudFJvbGUiO3M6NDoiUm9sZSI7czoyMDoiUGFydGljaXBhbnRFdmVudE5hbWUiO3M6MTA6IkV2ZW50IE5hbWUiO3M6MjA6IlBhcnRpY2lwYW50RXZlbnRUeXBlIjtzOjEwOiJFdmVudCBUeXBlIjt9',NULL,'2024-02-09 09:56:38','2024-02-09 15:56:38'),(16,'contact-20fields','custom importableFields Activity_0_0_0_0__0__0__0_0__1_7acce319','YTowOnt9',NULL,'2024-02-09 09:56:38','2024-02-09 15:56:38'),(17,'metadata_5_69_4','CRM_OG_activitytype_b2dd40c2e1d7b2fc17b52893d6c82660','YTozMTp7aToxO3M6NzoiTWVldGluZyI7aToyO3M6MTA6IlBob25lIENhbGwiO2k6MztzOjU6IkVtYWlsIjtpOjQ7czoxMjoiT3V0Ym91bmQgU01TIjtpOjU7czoxODoiRXZlbnQgUmVnaXN0cmF0aW9uIjtpOjY7czoxMjoiQ29udHJpYnV0aW9uIjtpOjc7czoxNzoiTWVtYmVyc2hpcCBTaWdudXAiO2k6ODtzOjE4OiJNZW1iZXJzaGlwIFJlbmV3YWwiO2k6OTtzOjEzOiJUZWxsIGEgRnJpZW5kIjtpOjEyO3M6MTM6IkluYm91bmQgRW1haWwiO2k6MTc7czoyNzoiTWVtYmVyc2hpcCBSZW5ld2FsIFJlbWluZGVyIjtpOjE5O3M6MTA6IkJ1bGsgRW1haWwiO2k6MjI7czoyMDoiUHJpbnQvTWVyZ2UgRG9jdW1lbnQiO2k6MzQ7czo4OiJNYXNzIFNNUyI7aTozNTtzOjI0OiJDaGFuZ2UgTWVtYmVyc2hpcCBTdGF0dXMiO2k6MzY7czoyMjoiQ2hhbmdlIE1lbWJlcnNoaXAgVHlwZSI7aTozNztzOjI5OiJDYW5jZWwgUmVjdXJyaW5nIENvbnRyaWJ1dGlvbiI7aTozODtzOjQ1OiJVcGRhdGUgUmVjdXJyaW5nIENvbnRyaWJ1dGlvbiBCaWxsaW5nIERldGFpbHMiO2k6Mzk7czoyOToiVXBkYXRlIFJlY3VycmluZyBDb250cmlidXRpb24iO2k6NDA7czoxMzoiUmVtaW5kZXIgU2VudCI7aTo0MTtzOjIzOiJFeHBvcnQgQWNjb3VudGluZyBCYXRjaCI7aTo0NDtzOjEyOiJTTVMgZGVsaXZlcnkiO2k6NDU7czoxMToiSW5ib3VuZCBTTVMiO2k6NDY7czo3OiJQYXltZW50IjtpOjQ3O3M6NjoiUmVmdW5kIjtpOjQ4O3M6MTk6IkNoYW5nZSBSZWdpc3RyYXRpb24iO2k6NDk7czoxODoiRG93bmxvYWRlZCBJbnZvaWNlIjtpOjUwO3M6MTU6IkVtYWlsZWQgSW52b2ljZSI7aTo1MTtzOjE0OiJDb250YWN0IE1lcmdlZCI7aTo1MjtzOjI0OiJDb250YWN0IERlbGV0ZWQgYnkgTWVyZ2UiO2k6NTQ7czoxNDoiRmFpbGVkIFBheW1lbnQiO30=',NULL,'2024-02-09 09:56:50','2024-02-09 15:56:51'),(18,'contact-20fields','custom importableFields Event_0_0_0_0__0__0__0_0__1_7acce319','YTowOnt9',NULL,'2024-02-09 09:56:42','2024-02-09 15:56:42'),(19,'metadata_5_69_4','CRM_OG_eventtype_1f549a14b6b1d145e4ef1559d8cd966d','YTo2OntpOjE7czoxMDoiQ29uZmVyZW5jZSI7aToyO3M6MTA6IkV4aGliaXRpb24iO2k6MztzOjEwOiJGdW5kcmFpc2VyIjtpOjQ7czo3OiJNZWV0aW5nIjtpOjU7czoxMToiUGVyZm9ybWFuY2UiO2k6NjtzOjg6IldvcmtzaG9wIjt9',NULL,'2024-02-09 09:56:50','2024-02-09 15:56:51'),(20,'contact-20fields','custom importableFields Address_0_0_0_0__0__0__0_0__1_7acce319','YTowOnt9',NULL,'2024-02-09 09:56:38','2024-02-09 15:56:39'),(21,'contact-20fields','custom importableFields Campaign_0_0_0_0__0__0__0_0__1_7acce319','YTowOnt9',NULL,'2024-02-09 09:56:38','2024-02-09 15:56:39'),(22,'contact-20fields','custom importableFields Case_0_0_0_0__0__0__0_0__1_7acce319','YTowOnt9',NULL,'2024-02-09 09:56:39','2024-02-09 15:56:39'),(23,'contact-20fields','custom importableFields ad76727f05c63c9de1f44ef20e6a549a','YTowOnt9',NULL,'2024-02-09 09:56:39','2024-02-09 15:56:40'),(24,'contact-20fields','custom importableFields 59bd225d6f59ba8776888bdca070df20','YTowOnt9',NULL,'2024-02-09 09:56:39','2024-02-09 15:56:40'),(25,'contact-20fields','custom importableFields 5afd8a0ca7d2afc2552ee8b073e95650','YTowOnt9',NULL,'2024-02-09 09:56:40','2024-02-09 15:56:40'),(26,'contact-20fields','custom importableFields Group_0_0_0_0__0__0__0_0__1_7acce319','YTowOnt9',NULL,'2024-02-09 09:56:42','2024-02-09 15:56:42'),(27,'contact-20fields','custom importableFields 9d60dd61dcc8ce750db45a1b2180420d','YTowOnt9',NULL,'2024-02-09 09:56:43','2024-02-09 15:56:43'),(28,'contact-20fields','custom importableFields 1d7d56fe65f38eb683aa7c5171328b73','YTowOnt9',NULL,'2024-02-09 09:56:44','2024-02-09 15:56:44'),(29,'contact-20fields','custom importableFields Pledge_0_0_0_0__0__0__0_0__1_7acce319','YTowOnt9',NULL,'2024-02-09 09:56:44','2024-02-09 15:56:45'),(30,'contact-20fields','custom importableFields ce907e5d7018a23b95e86878da75fd96','YTowOnt9',NULL,'2024-02-09 09:56:45','2024-02-09 15:56:46'),(31,'contact-20fields','custom importableFields Survey_0_0_0_0__0__0__0_0__1_7acce319','YTowOnt9',NULL,'2024-02-09 09:56:46','2024-02-09 15:56:46'),(32,'metadata_5_69_4','CRM_OG_fromemailaddress_38bb94080b6c8d80cf79619f7d87e0a8','YToxOntpOjE7czoyNjoiIkZJWE1FIiA8aW5mb0BFWEFNUExFLk9SRz4iO30=',NULL,'2024-02-09 09:56:47','2024-02-09 15:56:47'),(33,'metadata_5_69_4','CRM_OG_addressee_d5bc74e49eabb20f46a8420f1c5f28e7','YToxOntpOjE7czoxOiIxIjt9',NULL,'2024-02-05 12:42:46','2024-02-05 18:42:47'),(34,'metadata_5_69_4','CRM_OG_postalgreeting_c223a76d5053969679b3db33694c3729','YToxOntpOjE7czoxOiIxIjt9',NULL,'2024-02-05 12:42:46','2024-02-05 18:42:47'),(35,'metadata_5_69_4','CRM_OG_emailgreeting_9ea9d306741b705e029012d1ba4c8ba8','YToxOntpOjE7czoxOiIxIjt9',NULL,'2024-02-05 12:42:46','2024-02-05 18:42:47'),(36,'metadata_5_69_4','CRM_OG_addressee_3e283be354d65207994d61f0d2f40802','YTo0OntpOjE7czoxMjI6Intjb250YWN0LnByZWZpeF9pZDpsYWJlbH17IH17Y29udGFjdC5maXJzdF9uYW1lfXsgfXtjb250YWN0Lm1pZGRsZV9uYW1lfXsgfXtjb250YWN0Lmxhc3RfbmFtZX17IH17Y29udGFjdC5zdWZmaXhfaWQ6bGFiZWx9IjtpOjI7czoyNDoie2NvbnRhY3QuaG91c2Vob2xkX25hbWV9IjtpOjM7czoyNzoie2NvbnRhY3Qub3JnYW5pemF0aW9uX25hbWV9IjtpOjQ7czoxMDoiQ3VzdG9taXplZCI7fQ==',NULL,'2024-02-05 12:42:46','2024-02-05 18:42:47'),(37,'metadata_5_69_4','CRM_OG_postalgreeting_491c0168abcc04929c5810318bc4f369','YTo1OntpOjE7czoyNToiRGVhciB7Y29udGFjdC5maXJzdF9uYW1lfSI7aToyO3M6NzE6IkRlYXIge2NvbnRhY3QucHJlZml4X2lkOmxhYmVsfSB7Y29udGFjdC5maXJzdF9uYW1lfSB7Y29udGFjdC5sYXN0X25hbWV9IjtpOjM7czo1MDoiRGVhciB7Y29udGFjdC5wcmVmaXhfaWQ6bGFiZWx9IHtjb250YWN0Lmxhc3RfbmFtZX0iO2k6NDtzOjEwOiJDdXN0b21pemVkIjtpOjU7czoyOToiRGVhciB7Y29udGFjdC5ob3VzZWhvbGRfbmFtZX0iO30=',NULL,'2024-02-05 12:42:46','2024-02-05 18:42:47'),(38,'metadata_5_69_4','CRM_OG_emailgreeting_bce7662de76e44d32190204d168bcdcb','YTo1OntpOjE7czoyNToiRGVhciB7Y29udGFjdC5maXJzdF9uYW1lfSI7aToyO3M6NzE6IkRlYXIge2NvbnRhY3QucHJlZml4X2lkOmxhYmVsfSB7Y29udGFjdC5maXJzdF9uYW1lfSB7Y29udGFjdC5sYXN0X25hbWV9IjtpOjM7czo1MDoiRGVhciB7Y29udGFjdC5wcmVmaXhfaWQ6bGFiZWx9IHtjb250YWN0Lmxhc3RfbmFtZX0iO2k6NDtzOjEwOiJDdXN0b21pemVkIjtpOjU7czoyOToiRGVhciB7Y29udGFjdC5ob3VzZWhvbGRfbmFtZX0iO30=',NULL,'2024-02-05 12:42:46','2024-02-05 18:42:47'),(39,'metadata_5_69_4','CRM_OG_communicationstyle_e320ab213d0a69e400d0ac68056106c2','YToxOntzOjY6IkZvcm1hbCI7czoxOiIxIjt9',NULL,'2024-02-05 12:42:46','2024-02-05 18:42:47'),(40,'metadata_5_69_4','CRM_OG_individualprefix_408dd485b84371b1214e7cc2e4b76133','YTo0OntpOjE7czo0OiJNcnMuIjtpOjI7czozOiJNcy4iO2k6MztzOjM6Ik1yLiI7aTo0O3M6MzoiRHIuIjt9',NULL,'2024-02-05 12:42:46','2024-02-05 18:42:47'),(41,'metadata_5_69_4','CRM_OG_individualsuffix_1b8da602c3b23eca89cc25759e1f452c','YTo4OntpOjE7czozOiJKci4iO2k6MjtzOjM6IlNyLiI7aTozO3M6MjoiSUkiO2k6NDtzOjM6IklJSSI7aTo1O3M6MjoiSVYiO2k6NjtzOjE6IlYiO2k6NztzOjI6IlZJIjtpOjg7czozOiJWSUkiO30=',NULL,'2024-02-05 12:42:46','2024-02-05 18:42:47'),(42,'contact-20fields','custom importableFields Address_0_0_0_0__0__0_1__1_6a657c34','YTowOnt9',NULL,'2024-02-05 12:42:47','2024-02-05 18:42:47'),(43,'contact-20fields','custom importableFields 7881696b260a8dfba0dfe51dac2f3aaf','YTowOnt9',NULL,'2024-02-08 11:10:10','2024-02-08 17:10:10'),(44,'contact-20fields','custom importableFields Household_0_0_0_0__0__0__0_0__1_7acce319','YTowOnt9',NULL,'2024-02-08 11:10:10','2024-02-08 17:10:10'),(45,'contact-20fields','custom importableFields 640bc65c6dbfe7756c72ccda60d80af9','YTowOnt9',NULL,'2024-02-08 11:10:10','2024-02-08 17:10:10'),(46,'contact-20fields','exportableFields All_1_0_1__','[encoded data, 72320 characters]',NULL,'2024-02-05 12:42:47','2024-02-05 18:42:47'),(47,'contact-20fields','custom importableFields Participant_0_0_0_0__0__0_1__1_6a657c34','YTowOnt9',NULL,'2024-02-05 12:42:47','2024-02-05 18:42:47'),(48,'contact-20fields','custom importableFields Membership_0_0_0_0__0__0_1__1_6a657c34','YTowOnt9',NULL,'2024-02-05 12:42:47','2024-02-05 18:42:47'),(49,'contact-20fields','custom importableFields Activity_0_0_0_0__0__0_1__1_6a657c34','YTowOnt9',NULL,'2024-02-05 12:42:47','2024-02-05 18:42:47'),(50,'metadata_5_69_4','CRM_OG_languages_ac759f90203fa6db0473b0d2e6f77fbe','[encoded data, 7676 characters]',NULL,'2024-02-05 12:42:47','2024-02-05 18:42:47'),(51,'metadata_5_69_4','CRM_OG_communicationstyle_bdd5b7b5d204a6c89b8763399ce4d801','YToyOntpOjE7czo2OiJGb3JtYWwiO2k6MjtzOjg6IkZhbWlsaWFyIjt9',NULL,'2024-02-05 12:42:47','2024-02-05 18:42:47'),(52,'metadata_5_69_4','CRM_OG_emailgreeting_7ccdef84ad96ca274b12c016bd42b007','YTo1OntpOjE7czoyNToiRGVhciB7Y29udGFjdC5maXJzdF9uYW1lfSI7aToyO3M6NzE6IkRlYXIge2NvbnRhY3QucHJlZml4X2lkOmxhYmVsfSB7Y29udGFjdC5maXJzdF9uYW1lfSB7Y29udGFjdC5sYXN0X25hbWV9IjtpOjM7czo1MDoiRGVhciB7Y29udGFjdC5wcmVmaXhfaWQ6bGFiZWx9IHtjb250YWN0Lmxhc3RfbmFtZX0iO2k6NDtzOjEwOiJDdXN0b21pemVkIjtpOjU7czoyOToiRGVhciB7Y29udGFjdC5ob3VzZWhvbGRfbmFtZX0iO30=',NULL,'2024-02-05 12:42:47','2024-02-05 18:42:47'),(53,'metadata_5_69_4','CRM_OG_postalgreeting_7a488218cd3fc288f367c2281110ca29','YTo1OntpOjE7czoyNToiRGVhciB7Y29udGFjdC5maXJzdF9uYW1lfSI7aToyO3M6NzE6IkRlYXIge2NvbnRhY3QucHJlZml4X2lkOmxhYmVsfSB7Y29udGFjdC5maXJzdF9uYW1lfSB7Y29udGFjdC5sYXN0X25hbWV9IjtpOjM7czo1MDoiRGVhciB7Y29udGFjdC5wcmVmaXhfaWQ6bGFiZWx9IHtjb250YWN0Lmxhc3RfbmFtZX0iO2k6NDtzOjEwOiJDdXN0b21pemVkIjtpOjU7czoyOToiRGVhciB7Y29udGFjdC5ob3VzZWhvbGRfbmFtZX0iO30=',NULL,'2024-02-05 12:42:47','2024-02-05 18:42:47'),(54,'metadata_5_69_4','CRM_OG_addressee_13c0a20755b2cc5b902bdc7d89f4af36','YTo0OntpOjE7czoxMjI6Intjb250YWN0LnByZWZpeF9pZDpsYWJlbH17IH17Y29udGFjdC5maXJzdF9uYW1lfXsgfXtjb250YWN0Lm1pZGRsZV9uYW1lfXsgfXtjb250YWN0Lmxhc3RfbmFtZX17IH17Y29udGFjdC5zdWZmaXhfaWQ6bGFiZWx9IjtpOjI7czoyNDoie2NvbnRhY3QuaG91c2Vob2xkX25hbWV9IjtpOjM7czoyNzoie2NvbnRhY3Qub3JnYW5pemF0aW9uX25hbWV9IjtpOjQ7czoxMDoiQ3VzdG9taXplZCI7fQ==',NULL,'2024-02-05 12:42:47','2024-02-05 18:42:47'),(55,'metadata_5_69_4','CRM_OG_emailgreeting_8fbc5cde5fc3a9adecca29fbd775bf3f','YTo0OntpOjE7czoyNToiRGVhciB7Y29udGFjdC5maXJzdF9uYW1lfSI7aToyO3M6NzE6IkRlYXIge2NvbnRhY3QucHJlZml4X2lkOmxhYmVsfSB7Y29udGFjdC5maXJzdF9uYW1lfSB7Y29udGFjdC5sYXN0X25hbWV9IjtpOjM7czo1MDoiRGVhciB7Y29udGFjdC5wcmVmaXhfaWQ6bGFiZWx9IHtjb250YWN0Lmxhc3RfbmFtZX0iO2k6NDtzOjEwOiJDdXN0b21pemVkIjt9',NULL,'2024-02-05 12:42:47','2024-02-05 18:42:47'),(56,'metadata_5_69_4','CRM_OG_postalgreeting_356fefce1ec51c409d262490d28deb53','YTo0OntpOjE7czoyNToiRGVhciB7Y29udGFjdC5maXJzdF9uYW1lfSI7aToyO3M6NzE6IkRlYXIge2NvbnRhY3QucHJlZml4X2lkOmxhYmVsfSB7Y29udGFjdC5maXJzdF9uYW1lfSB7Y29udGFjdC5sYXN0X25hbWV9IjtpOjM7czo1MDoiRGVhciB7Y29udGFjdC5wcmVmaXhfaWQ6bGFiZWx9IHtjb250YWN0Lmxhc3RfbmFtZX0iO2k6NDtzOjEwOiJDdXN0b21pemVkIjt9',NULL,'2024-02-05 12:42:47','2024-02-05 18:42:47'),(57,'metadata_5_69_4','CRM_OG_addressee_4d692d9f9ad52483f911f43c472061dc','YToyOntpOjE7czoxMjI6Intjb250YWN0LnByZWZpeF9pZDpsYWJlbH17IH17Y29udGFjdC5maXJzdF9uYW1lfXsgfXtjb250YWN0Lm1pZGRsZV9uYW1lfXsgfXtjb250YWN0Lmxhc3RfbmFtZX17IH17Y29udGFjdC5zdWZmaXhfaWQ6bGFiZWx9IjtpOjQ7czoxMDoiQ3VzdG9taXplZCI7fQ==',NULL,'2024-02-05 12:42:47','2024-02-05 18:42:47'),(58,'metadata_5_69_4','CRM_OG_languages_fa632e6457fca2d5a80be980bbab3eb9','YTo1MDp7czo1OiJhZl9aQSI7czo5OiJBZnJpa2FhbnMiO3M6NToic3FfQUwiO3M6ODoiQWxiYW5pYW4iO3M6NToiYXJfRUciO3M6NjoiQXJhYmljIjtzOjU6ImJnX0JHIjtzOjk6IkJ1bGdhcmlhbiI7czo1OiJjYV9FUyI7czoxODoiQ2F0YWxhbjsgVmFsZW5jaWFuIjtzOjU6InpoX0NOIjtzOjE1OiJDaGluZXNlIChDaGluYSkiO3M6NToiemhfVFciO3M6MTY6IkNoaW5lc2UgKFRhaXdhbikiO3M6NToiaHJfSFIiO3M6ODoiQ3JvYXRpYW4iO3M6NToiY3NfQ1oiO3M6NToiQ3plY2giO3M6NToiZGFfREsiO3M6NjoiRGFuaXNoIjtzOjU6Im5sX05MIjtzOjE5OiJEdXRjaCAoTmV0aGVybGFuZHMpIjtzOjU6Im5sX0JFIjtzOjE1OiJEdXRjaCAoQmVsZ2l1bSkiO3M6NToiZW5fQVUiO3M6MTk6IkVuZ2xpc2ggKEF1c3RyYWxpYSkiO3M6NToiZW5fQ0EiO3M6MTY6IkVuZ2xpc2ggKENhbmFkYSkiO3M6NToiZW5fR0IiO3M6MjQ6IkVuZ2xpc2ggKFVuaXRlZCBLaW5nZG9tKSI7czo1OiJlbl9VUyI7czoyMzoiRW5nbGlzaCAoVW5pdGVkIFN0YXRlcykiO3M6NToiZXRfRUUiO3M6ODoiRXN0b25pYW4iO3M6NToiZmlfRkkiO3M6NzoiRmlubmlzaCI7czo1OiJmcl9DQSI7czoxNToiRnJlbmNoIChDYW5hZGEpIjtzOjU6ImZyX0ZSIjtzOjE1OiJGcmVuY2ggKEZyYW5jZSkiO3M6NToiZGVfREUiO3M6NjoiR2VybWFuIjtzOjU6ImRlX0NIIjtzOjE0OiJHZXJtYW4gKFN3aXNzKSI7czo1OiJlbF9HUiI7czoxMzoiR3JlZWssIE1vZGVybiI7czo1OiJoZV9JTCI7czoxNToiSGVicmV3IChtb2Rlcm4pIjtzOjU6ImhpX0lOIjtzOjU6IkhpbmRpIjtzOjU6Imh1X0hVIjtzOjk6Ikh1bmdhcmlhbiI7czo1OiJpZF9JRCI7czoxMDoiSW5kb25lc2lhbiI7czo1OiJpdF9JVCI7czo3OiJJdGFsaWFuIjtzOjU6ImphX0pQIjtzOjg6IkphcGFuZXNlIjtzOjU6ImttX0tIIjtzOjU6IktobWVyIjtzOjU6Imx0X0xUIjtzOjEwOiJMaXRodWFuaWFuIjtzOjU6Im5iX05PIjtzOjE3OiJOb3J3ZWdpYW4gQm9rbcOlbCI7czo1OiJmYV9JUiI7czoxNDoiUGVyc2lhbiAoSXJhbikiO3M6NToicGxfUEwiO3M6NjoiUG9saXNoIjtzOjU6InB0X0JSIjtzOjE5OiJQb3J0dWd1ZXNlIChCcmF6aWwpIjtzOjU6InB0X1BUIjtzOjIxOiJQb3J0dWd1ZXNlIChQb3J0dWdhbCkiO3M6NToicm9fUk8iO3M6Mjk6IlJvbWFuaWFuLCBNb2xkYXZpYW4sIE1vbGRvdmFuIjtzOjU6InJ1X1JVIjtzOjc6IlJ1c3NpYW4iO3M6NToic3JfUlMiO3M6NzoiU2VyYmlhbiI7czo1OiJza19TSyI7czo2OiJTbG92YWsiO3M6NToic2xfU0kiO3M6NzoiU2xvdmVuZSI7czo1OiJlc19FUyI7czoyNjoiU3BhbmlzaDsgQ2FzdGlsaWFuIChTcGFpbikiO3M6NToiZXNfTVgiO3M6Mjc6IlNwYW5pc2g7IENhc3RpbGlhbiAoTWV4aWNvKSI7czo1OiJlc19QUiI7czozMjoiU3BhbmlzaDsgQ2FzdGlsaWFuIChQdWVydG8gUmljbykiO3M6NToic3ZfU0UiO3M6NzoiU3dlZGlzaCI7czo1OiJ0ZV9JTiI7czo2OiJUZWx1Z3UiO3M6NToidGhfVEgiO3M6NDoiVGhhaSI7czo1OiJ0cl9UUiI7czo3OiJUdXJraXNoIjtzOjU6InVrX1VBIjtzOjk6IlVrcmFpbmlhbiI7czo1OiJ2aV9WTiI7czoxMDoiVmlldG5hbWVzZSI7fQ==',NULL,'2024-02-07 07:43:40','2024-02-07 13:43:41'),(59,'metadata_5_69_4','CRM_Core_BAO_OptionValue_OptionGroupID_34_en_US','YTozOntpOjI2MjthOjEyOntzOjI6ImlkIjtzOjM6IjI2MiI7czoxNToib3B0aW9uX2dyb3VwX2lkIjtzOjI6IjM0IjtzOjU6ImxhYmVsIjtzOjQ6IlJvbGUiO3M6NToidmFsdWUiO3M6MToiMSI7czo0OiJuYW1lIjtzOjE1OiJQYXJ0aWNpcGFudFJvbGUiO3M6ODoiZ3JvdXBpbmciO3M6Nzoicm9sZV9pZCI7czo2OiJmaWx0ZXIiO3M6MToiMCI7czoxMDoiaXNfZGVmYXVsdCI7czoxOiIwIjtzOjY6IndlaWdodCI7czoxOiIxIjtzOjExOiJpc19vcHRncm91cCI7czoxOiIwIjtzOjExOiJpc19yZXNlcnZlZCI7czoxOiIwIjtzOjk6ImlzX2FjdGl2ZSI7czoxOiIxIjt9aToyNjM7YToxMjp7czoyOiJpZCI7czozOiIyNjMiO3M6MTU6Im9wdGlvbl9ncm91cF9pZCI7czoyOiIzNCI7czo1OiJsYWJlbCI7czoxMDoiRXZlbnQgTmFtZSI7czo1OiJ2YWx1ZSI7czoxOiIyIjtzOjQ6Im5hbWUiO3M6MjA6IlBhcnRpY2lwYW50RXZlbnROYW1lIjtzOjg6Imdyb3VwaW5nIjtzOjg6ImV2ZW50X2lkIjtzOjY6ImZpbHRlciI7czoxOiIwIjtzOjEwOiJpc19kZWZhdWx0IjtzOjE6IjAiO3M6Njoid2VpZ2h0IjtzOjE6IjIiO3M6MTE6ImlzX29wdGdyb3VwIjtzOjE6IjAiO3M6MTE6ImlzX3Jlc2VydmVkIjtzOjE6IjAiO3M6OToiaXNfYWN0aXZlIjtzOjE6IjEiO31pOjI2NDthOjEyOntzOjI6ImlkIjtzOjM6IjI2NCI7czoxNToib3B0aW9uX2dyb3VwX2lkIjtzOjI6IjM0IjtzOjU6ImxhYmVsIjtzOjEwOiJFdmVudCBUeXBlIjtzOjU6InZhbHVlIjtzOjE6IjMiO3M6NDoibmFtZSI7czoyMDoiUGFydGljaXBhbnRFdmVudFR5cGUiO3M6ODoiZ3JvdXBpbmciO3M6MjI6ImV2ZW50X2lkLmV2ZW50X3R5cGVfaWQiO3M6NjoiZmlsdGVyIjtzOjE6IjAiO3M6MTA6ImlzX2RlZmF1bHQiO3M6MToiMCI7czo2OiJ3ZWlnaHQiO3M6MToiMyI7czoxMToiaXNfb3B0Z3JvdXAiO3M6MToiMCI7czoxMToiaXNfcmVzZXJ2ZWQiO3M6MToiMCI7czo5OiJpc19hY3RpdmUiO3M6MToiMSI7fX0=',NULL,'2024-02-07 07:43:40','2024-02-07 13:43:41'),(60,'metadata_5_69_4','CRM_OG_tagusedfor_b4d9a62934175f2bdbb6408ea386f44a','YTo0OntzOjE1OiJjaXZpY3JtX2NvbnRhY3QiO3M6NzoiQ29udGFjdCI7czoxNjoiY2l2aWNybV9hY3Rpdml0eSI7czo4OiJBY3Rpdml0eSI7czoxMjoiY2l2aWNybV9jYXNlIjtzOjQ6IkNhc2UiO3M6MTI6ImNpdmljcm1fZmlsZSI7czo0OiJGaWxlIjt9',NULL,'2024-02-07 07:43:40','2024-02-07 13:43:41'),