(801,'contact-20fields','importableFields All_0_0_0_1_1_','[encoded data, 56668 characters]',NULL,'2024-04-10 10:26:13','2024-04-10 16:26:13'),(802,'long','theme_list_6ad754c723d54eadda0fc24f29c764c4','YTo0OntzOjc6ImRlZmF1bHQiO2E6Njp7czo0OiJuYW1lIjtzOjc6ImRlZmF1bHQiO3M6MTI6InVybF9jYWxsYmFjayI7czozNToiXENpdmlcQ29yZVxUaGVtZXNcUmVzb2x2ZXJzOjpzaW1wbGUiO3M6MTI6InNlYXJjaF9vcmRlciI7YToyOntpOjA7czo3OiJkZWZhdWx0IjtpOjE7czoxMDoiX2ZhbGxiYWNrXyI7fXM6MzoiZXh0IjtzOjc6ImNpdmljcm0iO3M6NToidGl0bGUiO3M6OToiQXV0b21hdGljIjtzOjQ6ImhlbHAiO3M6NDA6IkRldGVybWluZSBhIHN5c3RlbSBkZWZhdWx0IGF1dG9tYXRpY2FsbHkiO31zOjk6ImdyZWVud2ljaCI7YTo2OntzOjQ6Im5hbWUiO3M6OToiZ3JlZW53aWNoIjtzOjEyOiJ1cmxfY2FsbGJhY2siO3M6MzU6IlxDaXZpXENvcmVcVGhlbWVzXFJlc29sdmVyczo6c2ltcGxlIjtzOjEyOiJzZWFyY2hfb3JkZXIiO2E6Mjp7aTowO3M6OToiZ3JlZW53aWNoIjtpOjE7czoxMDoiX2ZhbGxiYWNrXyI7fXM6MzoiZXh0IjtzOjc6ImNpdmljcm0iO3M6NToidGl0bGUiO3M6OToiR3JlZW53aWNoIjtzOjQ6ImhlbHAiO3M6MjU6IkNpdmlDUk0gNC54IGxvb2stYW5kLWZlZWwiO31zOjQ6Im5vbmUiO2E6Nzp7czo0OiJuYW1lIjtzOjQ6Im5vbmUiO3M6MTI6InVybF9jYWxsYmFjayI7czozNToiXENpdmlcQ29yZVxUaGVtZXNcUmVzb2x2ZXJzOjpzaW1wbGUiO3M6MTI6InNlYXJjaF9vcmRlciI7YToyOntpOjA7czo0OiJub25lIjtpOjE7czoxMDoiX2ZhbGxiYWNrXyI7fXM6MzoiZXh0IjtzOjc6ImNpdmljcm0iO3M6NToidGl0bGUiO3M6MTU6Ik5vbmUgKFVuc3R5bGVkKSI7czo0OiJoZWxwIjtzOjM3OiJEaXNhYmxlIENpdmlDUk0ncyBidWlsdC1pbiBDU1MgZmlsZXMuIjtzOjg6ImV4Y2x1ZGVzIjthOjI6e2k6MDtzOjE1OiJjc3MvY2l2aWNybS5jc3MiO2k6MTtzOjE3OiJjc3MvYm9vdHN0cmFwLmNzcyI7fX1zOjEwOiJfZmFsbGJhY2tfIjthOjU6e3M6NDoibmFtZSI7czoxMDoiX2ZhbGxiYWNrXyI7czoxMjoidXJsX2NhbGxiYWNrIjtzOjM3OiJcQ2l2aVxDb3JlXFRoZW1lc1xSZXNvbHZlcnM6OmZhbGxiYWNrIjtzOjEyOiJzZWFyY2hfb3JkZXIiO2E6MTp7aTowO3M6MTA6Il9mYWxsYmFja18iO31zOjM6ImV4dCI7czo3OiJjaXZpY3JtIjtzOjU6InRpdGxlIjtzOjMwOiJGYWxsYmFjayAoQWJzdHJhY3QgQmFzZSBUaGVtZSkiO319',NULL,'2024-07-02 02:27:16','2024-07-02 08:27:16'),(803,'metadata_5_71_0','CRM_OG_addressoptions_6000c13a0c1154b044d714c66dc05b58','YToxNDp7aToxO3M6MTQ6InN0cmVldF9hZGRyZXNzIjtpOjI7czoyMjoic3VwcGxlbWVudGFsX2FkZHJlc3NfMSI7aTozO3M6MjI6InN1cHBsZW1lbnRhbF9hZGRyZXNzXzIiO2k6NDtzOjIyOiJzdXBwbGVtZW50YWxfYWRkcmVzc18zIjtpOjU7czo0OiJjaXR5IjtpOjY7czoxMToicG9zdGFsX2NvZGUiO2k6NztzOjE4OiJwb3N0YWxfY29kZV9zdWZmaXgiO2k6ODtzOjY6ImNvdW50eSI7aTo5O3M6MTQ6InN0YXRlX3Byb3ZpbmNlIjtpOjEwO3M6NzoiY291bnRyeSI7aToxMTtzOjEwOiJnZW9fY29kZV8xIjtpOjEyO3M6MTA6Imdlb19jb2RlXzIiO2k6MTM7czoxMjoiYWRkcmVzc19uYW1lIjtpOjE0O3M6MjI6InN0cmVldF9hZGRyZXNzX3BhcnNpbmciO30=',NULL,'2024-07-01 17:34:46','2024-07-01 23:34:47'),(804,'community_messages','dashboard_newsfeed','[encoded data, 21640 characters]',NULL,'2024-07-01 17:34:54','2024-07-02 17:34:54'),(805,'community_messages','dashboard_gettingStarted_en_US','[encoded data, 4356 characters]',NULL,'2024-07-01 17:34:54','2024-07-06 17:34:54'),(806,'metadata_5_71_0','CRM_OG_participantrole_b5f39dd2dbd35b8edba4a7bcf5d79845','YTo0OntpOjE7czo4OiJBdHRlbmRlZSI7aToyO3M6OToiVm9sdW50ZWVyIjtpOjM7czo0OiJIb3N0IjtpOjQ7czo3OiJTcGVha2VyIjt9',NULL,'2024-04-15 13:07:02','2024-04-15 19:07:02'),(807,'CiviCRM-20Session','_CRM_Event_Controller_Registration_CRMEventControllerRegistration7cpmfqebbcsgs40o44w444sk0wggw8g0ckgwwko88g8880g8c_5715_container','YTo0OntzOjg6ImRlZmF1bHRzIjthOjA6e31zOjk6ImNvbnN0YW50cyI7YTowOnt9czo2OiJ2YWx1ZXMiO2E6Mzp7czo4OiJSZWdpc3RlciI7YTowOnt9czo3OiJDb25maXJtIjthOjA6e31zOjg6IlRoYW5rWW91IjthOjA6e319czo1OiJ2YWxpZCI7YTozOntzOjg6IlJlZ2lzdGVyIjtOO3M6NzoiQ29uZmlybSI7TjtzOjg6IlRoYW5rWW91IjtOO319',NULL,'2024-04-15 13:07:02','2024-04-15 13:27:02'),(808,'CiviCRM-20Session','CiviCRM_CRM_Event_Controller_Registration_CRMEventControllerRegistration7cpmfqebbcsgs40o44w444sk0wggw8g0ckgwwko88g8880g8c_5715','[encoded data, 5596 characters]',NULL,'2024-04-15 13:07:02','2024-04-15 13:27:02'),(809,'CiviCRM-20Session','_CRM_Event_Controller_Registration_CRMEventControllerRegistration7cpmfqebbcsgs40o44w444sk0wggw8g0ckgwwko88g8880g8c_1768_container','YTo0OntzOjg6ImRlZmF1bHRzIjthOjA6e31zOjk6ImNvbnN0YW50cyI7YTowOnt9czo2OiJ2YWx1ZXMiO2E6Mzp7czo4OiJSZWdpc3RlciI7YTowOnt9czo3OiJDb25maXJtIjthOjA6e31zOjg6IlRoYW5rWW91IjthOjA6e319czo1OiJ2YWxpZCI7YTozOntzOjg6IlJlZ2lzdGVyIjtOO3M6NzoiQ29uZmlybSI7TjtzOjg6IlRoYW5rWW91IjtOO319',NULL,'2024-04-15 13:07:59','2024-04-15 13:27:59'),(810,'CiviCRM-20Session','CiviCRM_CRM_Event_Controller_Registration_CRMEventControllerRegistration7cpmfqebbcsgs40o44w444sk0wggw8g0ckgwwko88g8880g8c_1768','[encoded data, 5596 characters]',NULL,'2024-04-15 13:07:59','2024-04-15 13:27:59');

--
-- Table structure for table `civicrm_campaign`
--

CREATE TABLE `civicrm_campaign` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Campaign ID.',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name of the Campaign.',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Title of the Campaign.',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Full description of Campaign.',
  `start_date` datetime DEFAULT NULL COMMENT 'Date and time that Campaign starts.',
  `end_date` datetime DEFAULT NULL COMMENT 'Date and time that Campaign ends.',
  `campaign_type_id` int unsigned DEFAULT NULL COMMENT 'Campaign Type ID.Implicit FK to civicrm_option_value where option_group = campaign_type',
  `status_id` int unsigned DEFAULT NULL COMMENT 'Campaign status ID.Implicit FK to civicrm_option_value where option_group = campaign_status',
  `external_identifier` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Unique trusted external ID (generally from a legacy app/datasource). Particularly useful for deduping operations.',
  `parent_id` int unsigned DEFAULT NULL COMMENT 'Optional parent id for this Campaign.',
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT 'Is this Campaign enabled or disabled/cancelled?',
  `created_id` int unsigned DEFAULT NULL COMMENT 'FK to civicrm_contact, who created this Campaign.',
  `created_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'Date and time that Campaign was created.',
  `last_modified_id` int unsigned DEFAULT NULL COMMENT 'FK to civicrm_contact, who recently edited this Campaign.',
  `last_modified_date` datetime DEFAULT NULL COMMENT 'Date and time that Campaign was edited last time.',
  `goal_general` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'General goals for Campaign.',
  `goal_revenue` decimal(20,2) DEFAULT NULL COMMENT 'The target revenue for this campaign.',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_name` (`name`),
  UNIQUE KEY `UI_external_identifier` (`external_identifier`),
  KEY `index_campaign_type_id` (`campaign_type_id`),
  KEY `index_status_id` (`status_id`),
  KEY `FK_civicrm_campaign_parent_id` (`parent_id`),
  KEY `FK_civicrm_campaign_created_id` (`created_id`),
  KEY `FK_civicrm_campaign_last_modified_id` (`last_modified_id`),
  CONSTRAINT `FK_civicrm_campaign_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_campaign_last_modified_id` FOREIGN KEY (`last_modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_campaign_parent_id` FOREIGN KEY (`parent_id`) REFERENCES `civicrm_campaign` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_campaign`
--


--
-- Table structure for table `civicrm_campaign_group`
--

CREATE TABLE `civicrm_campaign_group` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Campaign Group id.',
  `campaign_id` int unsigned NOT NULL COMMENT 'Foreign key to the activity Campaign.',
  `group_type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Type of Group.',
  `entity_table` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Name of table where item being referenced is stored.',
  `entity_id` int unsigned DEFAULT NULL COMMENT 'Entity id of referenced table.',
  PRIMARY KEY (`id`),
  KEY `FK_civicrm_campaign_group_campaign_id` (`campaign_id`),
  CONSTRAINT `FK_civicrm_campaign_group_campaign_id` FOREIGN KEY (`campaign_id`) REFERENCES `civicrm_campaign` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_campaign_group`
--


--
-- Table structure for table `civicrm_case`
--

CREATE TABLE `civicrm_case` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Case ID',
  `case_type_id` int unsigned NOT NULL COMMENT 'FK to civicrm_case_type.id',
  `subject` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Short name of the case.',
  `start_date` date DEFAULT NULL COMMENT 'Date on which given case starts.',
  `end_date` date DEFAULT NULL COMMENT 'Date on which given case ends.',
  `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Details populated from Open Case. Only used in the CiviCase extension.',
  `status_id` int unsigned NOT NULL COMMENT 'ID of case status.',
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `created_date` timestamp NULL DEFAULT NULL COMMENT 'When was the case was created.',
  `modified_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'When was the case (or closely related entity) was created or modified or deleted.',
  PRIMARY KEY (`id`),
  KEY `index_case_type_id` (`case_type_id`),
  KEY `index_is_deleted` (`is_deleted`),
  CONSTRAINT `FK_civicrm_case_case_type_id` FOREIGN KEY (`case_type_id`) REFERENCES `civicrm_case_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_case`
--


--
-- Table structure for table `civicrm_case_activity`
--

CREATE TABLE `civicrm_case_activity` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique case-activity association id',
  `case_id` int unsigned NOT NULL COMMENT 'Case ID of case-activity association.',
  `activity_id` int unsigned NOT NULL COMMENT 'Activity ID of case-activity association.',
  PRIMARY KEY (`id`),
  KEY `UI_case_activity_id` (`case_id`,`activity_id`),
  KEY `FK_civicrm_case_activity_activity_id` (`activity_id`),
  CONSTRAINT `FK_civicrm_case_activity_activity_id` FOREIGN KEY (`activity_id`) REFERENCES `civicrm_activity` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_case_activity_case_id` FOREIGN KEY (`case_id`) REFERENCES `civicrm_case` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_case_activity`
--


--
-- Table structure for table `civicrm_case_contact`
--

CREATE TABLE `civicrm_case_contact` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique case-contact association id',
  `case_id` int unsigned NOT NULL COMMENT 'Case ID of case-contact association.',
  `contact_id` int unsigned NOT NULL COMMENT 'Contact ID of contact record given case belongs to.',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_case_contact_id` (`case_id`,`contact_id`),
  KEY `FK_civicrm_case_contact_contact_id` (`contact_id`),
  CONSTRAINT `FK_civicrm_case_contact_case_id` FOREIGN KEY (`case_id`) REFERENCES `civicrm_case` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_case_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_case_contact`
--


--
-- Table structure for table `civicrm_case_type`
--

CREATE TABLE `civicrm_case_type` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Autoincremented type id',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Machine name for Case Type',
  `title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Natural language name for Case Type',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Description of the Case Type',
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT 'Is this case type enabled?',
  `is_reserved` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this case type a predefined system type?',
  `weight` int NOT NULL DEFAULT '1' COMMENT 'Ordering of the case types',
  `definition` blob COMMENT 'xml definition of case type',
  PRIMARY KEY (`id`),
  UNIQUE KEY `case_type_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_case_type`
--


--
-- Table structure for table `civicrm_component`
--

CREATE TABLE `civicrm_component` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Component ID',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name of the component.',
  `namespace` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Path to components main directory in a form of a class namespace.',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_component`
--

INSERT INTO `civicrm_component` VALUES (1,'CiviEvent','CRM_Event'),(2,'CiviContribute','CRM_Contribute'),(3,'CiviMember','CRM_Member'),(4,'CiviMail','CRM_Mailing'),(6,'CiviPledge','CRM_Pledge'),(7,'CiviCase','CRM_Case'),(8,'CiviReport','CRM_Report'),(9,'CiviCampaign','CRM_Campaign');

--
-- Table structure for table `civicrm_contact`
--

CREATE TABLE `civicrm_contact` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Contact ID',
  `contact_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Type of Contact.',
  `external_identifier` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Unique trusted external ID (generally from a legacy app/datasource). Particularly useful for deduping operations.',
  `display_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Formatted name representing preferred format for display/print/other output.',
  `organization_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Organization Name.',
  `contact_sub_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'May be used to over-ride contact view and edit templates.',
  `first_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'First Name.',
  `middle_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Middle Name.',
  `last_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Last Name.',
  `do_not_email` tinyint NOT NULL DEFAULT '0',
  `do_not_phone` tinyint NOT NULL DEFAULT '0',
  `do_not_mail` tinyint NOT NULL DEFAULT '0',
  `do_not_sms` tinyint NOT NULL DEFAULT '0',
  `do_not_trade` tinyint NOT NULL DEFAULT '0',
  `is_opt_out` tinyint NOT NULL DEFAULT '0' COMMENT 'Has the contact opted out from receiving all bulk email from the organization or site domain?',
  `legal_identifier` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'May be used for SSN, EIN/TIN, Household ID (census) or other applicable unique legal/government ID.',
  `sort_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Name used for sorting different contact types',
  `nick_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Nickname.',
  `legal_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Legal Name.',
  `image_URL` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'optional URL for preferred image (photo, logo, etc.) to display for this contact.',
  `preferred_communication_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'What is the preferred mode of communication.',
  `preferred_language` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Which language is preferred for communication. FK to languages in civicrm_option_value.',
  `hash` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Key for validating requests related to this contact.',
  `api_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'API Key for validating requests related to this contact.',
  `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'where contact come from, e.g. import, donate module insert...',
  `prefix_id` int unsigned DEFAULT NULL COMMENT 'Prefix or Title for name (Ms, Mr...). FK to prefix ID',
  `suffix_id` int unsigned DEFAULT NULL COMMENT 'Suffix for name (Jr, Sr...). FK to suffix ID',
  `formal_title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Formal (academic or similar) title in front of name. (Prof., Dr. etc.)',
  `communication_style_id` int unsigned DEFAULT NULL COMMENT 'Communication style (e.g. formal vs. familiar) to use with this contact. FK to communication styles in civicrm_option_value.',
  `email_greeting_id` int unsigned DEFAULT NULL COMMENT 'FK to civicrm_option_value.id, that has to be valid registered Email Greeting.',
  `email_greeting_custom` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Custom Email Greeting.',
  `email_greeting_display` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Cache Email Greeting.',
  `postal_greeting_id` int unsigned DEFAULT NULL COMMENT 'FK to civicrm_option_value.id, that has to be valid registered Postal Greeting.',
  `postal_greeting_custom` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Custom Postal greeting.',
  `postal_greeting_display` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Cache Postal greeting.',
  `addressee_id` int unsigned DEFAULT NULL COMMENT 'FK to civicrm_option_value.id, that has to be valid registered Addressee.',
  `addressee_custom` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Custom Addressee.',
  `addressee_display` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Cache Addressee.',
  `job_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Job Title',
  `gender_id` int unsigned DEFAULT NULL COMMENT 'FK to gender ID',
  `birth_date` date DEFAULT NULL COMMENT 'Date of birth',
  `is_deceased` tinyint NOT NULL DEFAULT '0',
  `deceased_date` date DEFAULT NULL COMMENT 'Date of deceased',
  `household_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Household Name.',
  `primary_contact_id` int unsigned DEFAULT NULL COMMENT 'Optional FK to Primary Contact for this household.',
  `sic_code` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Standard Industry Classification Code.',
  `user_unique_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the OpenID (or OpenID-style http://username.domain/) unique identifier for this contact mainly used for logging in to CiviCRM',
  `employer_id` int unsigned DEFAULT NULL COMMENT 'OPTIONAL FK to civicrm_contact record.',
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `created_date` timestamp NULL DEFAULT NULL COMMENT 'When was the contact was created.',
  `modified_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'When was the contact (or closely related entity) was created or modified or deleted.',
  `preferred_mail_format` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Both' COMMENT 'Deprecated setting for text vs html mailings',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_external_identifier` (`external_identifier`),
  KEY `index_contact_type` (`contact_type`),
  KEY `index_organization_name` (`organization_name`),
  KEY `index_contact_sub_type` (`contact_sub_type`),
  KEY `index_first_name` (`first_name`),
  KEY `index_last_name` (`last_name`),
  KEY `index_sort_name` (`sort_name`),
  KEY `index_preferred_communication_method` (`preferred_communication_method`),
  KEY `index_hash` (`hash`),
  KEY `index_api_key` (`api_key`),
  KEY `UI_prefix` (`prefix_id`),
  KEY `UI_suffix` (`suffix_id`),
  KEY `index_communication_style_id` (`communication_style_id`),
  KEY `UI_gender` (`gender_id`),
  KEY `index_is_deceased` (`is_deceased`),
  KEY `index_household_name` (`household_name`),
  KEY `index_is_deleted_sort_name` (`is_deleted`,`sort_name`,`id`),
  KEY `index_created_date` (`created_date`),
  KEY `index_modified_date` (`modified_date`),
  KEY `FK_civicrm_contact_primary_contact_id` (`primary_contact_id`),
  KEY `FK_civicrm_contact_employer_id` (`employer_id`),
  CONSTRAINT `FK_civicrm_contact_employer_id` FOREIGN KEY (`employer_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_contact_primary_contact_id` FOREIGN KEY (`primary_contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_contact`
--

INSERT INTO `civicrm_contact` VALUES (1,'Organization',NULL,'Default Organization','Default Organization',NULL,NULL,NULL,NULL,0,0,0,0,0,0,NULL,'Default Organization',NULL,'Default Organization',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'2024-02-05 12:39:48','Both'),(2,'Individual',NULL,'dd dd',NULL,NULL,'dd',NULL,'dd',0,0,0,0,0,0,NULL,'dd, dd',NULL,NULL,NULL,NULL,'en_US','5afed36ec8c3b6e658f1064cce9b0b0f',NULL,NULL,NULL,NULL,NULL,1,1,NULL,'Dear dd',1,NULL,'Dear dd',1,NULL,'dd dd',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'2024-03-13 13:53:43','Both');

--
-- Table structure for table `civicrm_contact_type`
--

CREATE TABLE `civicrm_contact_type` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Contact Type ID',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Internal name of Contact Type (or Subtype).',
  `label` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'localized Name of Contact Type.',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'localized Optional verbose description of the type.',
  `image_URL` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'URL of image if any.',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'crm-i icon class representing this contact type',
  `parent_id` int unsigned DEFAULT NULL COMMENT 'Optional FK to parent contact type.',
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT 'Is this entry active?',
  `is_reserved` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this contact type a predefined system type',
  PRIMARY KEY (`id`),
  UNIQUE KEY `contact_type` (`name`),
  KEY `FK_civicrm_contact_type_parent_id` (`parent_id`),
  CONSTRAINT `FK_civicrm_contact_type_parent_id` FOREIGN KEY (`parent_id`) REFERENCES `civicrm_contact_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_contact_type`
--

INSERT INTO `civicrm_contact_type` VALUES (1,'Individual','Individual',NULL,NULL,'fa-user',NULL,1,1),(2,'Household','Household',NULL,NULL,'fa-home',NULL,1,1),(3,'Organization','Organization',NULL,NULL,'fa-building',NULL,1,1);

--
-- Table structure for table `civicrm_contribution`
--

CREATE TABLE `civicrm_contribution` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Contribution ID',
  `contact_id` int unsigned NOT NULL COMMENT 'FK to Contact ID',
  `financial_type_id` int unsigned DEFAULT NULL COMMENT 'FK to Financial Type for (total_amount - non_deductible_amount).',
  `contribution_page_id` int unsigned DEFAULT NULL COMMENT 'The Contribution Page which triggered this contribution',
  `payment_instrument_id` int unsigned DEFAULT NULL COMMENT 'FK to Payment Instrument',
  `receive_date` datetime DEFAULT NULL,
  `non_deductible_amount` decimal(20,2) DEFAULT '0.00' COMMENT 'Portion of total amount which is NOT tax deductible. Equal to total_amount for non-deductible financial types.',
  `total_amount` decimal(20,2) NOT NULL COMMENT 'Total amount of this contribution. Use market value for non-monetary gifts.',
  `fee_amount` decimal(20,2) DEFAULT NULL COMMENT 'actual processor fee if known - may be 0.',
  `net_amount` decimal(20,2) DEFAULT NULL COMMENT 'actual funds transfer amount. total less fees. if processor does not report actual fee during transaction, this is set to total_amount.',
  `trxn_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique transaction id. may be processor id, bank id + trans id, or account number + check number... depending on payment_method',
  `invoice_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique invoice id, system generated or passed in',
  `invoice_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Human readable invoice number',
  `currency` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '3 character string, value from config setting or input via user.',
  `cancel_date` datetime DEFAULT NULL COMMENT 'when was gift cancelled',
  `cancel_reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `receipt_date` datetime DEFAULT NULL COMMENT 'when (if) receipt was sent. populated automatically for online donations w/ automatic receipting',
  `thankyou_date` datetime DEFAULT NULL COMMENT 'when (if) was donor thanked',
  `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Origin of this Contribution.',
  `amount_level` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `contribution_recur_id` int unsigned DEFAULT NULL COMMENT 'Conditional foreign key to civicrm_contribution_recur id. Each contribution made in connection with a recurring contribution carries a foreign key to the recurring contribution record. This assumes we can track these processor initiated events.',
  `is_test` tinyint NOT NULL DEFAULT '0',
  `is_pay_later` tinyint NOT NULL DEFAULT '0',
  `contribution_status_id` int unsigned DEFAULT '1',
  `address_id` int unsigned DEFAULT NULL COMMENT 'Conditional foreign key to civicrm_address.id. We insert an address record for each contribution when we have associated billing name and address data.',
  `check_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `campaign_id` int unsigned DEFAULT NULL COMMENT 'The campaign for which this contribution has been triggered.',
  `creditnote_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique credit note id, system generated or passed in',
  `tax_amount` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Total tax amount of this contribution.',
  `revenue_recognition_date` datetime DEFAULT NULL COMMENT 'Stores the date when revenue should be recognized.',
  `is_template` tinyint NOT NULL DEFAULT '0' COMMENT 'Shows this is a template for recurring contributions.',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_contrib_trxn_id` (`trxn_id`),
  UNIQUE KEY `UI_contrib_invoice_id` (`invoice_id`),
  KEY `UI_contrib_payment_instrument_id` (`payment_instrument_id`),
  KEY `index_total_amount_receive_date` (`total_amount`,`receive_date`),
  KEY `index_source` (`source`),
  KEY `index_contribution_status` (`contribution_status_id`),
  KEY `received_date` (`receive_date`),
  KEY `check_number` (`check_number`),
  KEY `index_creditnote_id` (`creditnote_id`),
  KEY `FK_civicrm_contribution_contact_id` (`contact_id`),
  KEY `FK_civicrm_contribution_financial_type_id` (`financial_type_id`),
  KEY `FK_civicrm_contribution_contribution_page_id` (`contribution_page_id`),
  KEY `FK_civicrm_contribution_contribution_recur_id` (`contribution_recur_id`),
  KEY `FK_civicrm_contribution_address_id` (`address_id`),
  KEY `FK_civicrm_contribution_campaign_id` (`campaign_id`),
  CONSTRAINT `FK_civicrm_contribution_address_id` FOREIGN KEY (`address_id`) REFERENCES `civicrm_address` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_contribution_campaign_id` FOREIGN KEY (`campaign_id`) REFERENCES `civicrm_campaign` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_contribution_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_contribution_contribution_page_id` FOREIGN KEY (`contribution_page_id`) REFERENCES `civicrm_contribution_page` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_contribution_contribution_recur_id` FOREIGN KEY (`contribution_recur_id`) REFERENCES `civicrm_contribution_recur` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_contribution_financial_type_id` FOREIGN KEY (`financial_type_id`) REFERENCES `civicrm_financial_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_contribution`
--


--
-- Table structure for table `civicrm_contribution_page`
--

CREATE TABLE `civicrm_contribution_page` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Contribution ID',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Contribution Page title. For top of page display',
  `frontend_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Contribution Page Public title',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Unique name for identifying contribution page',
  `intro_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Text and html allowed. Displayed below title.',
  `financial_type_id` int unsigned DEFAULT NULL COMMENT 'default financial type assigned to contributions submitted via this page, e.g. Contribution, Campaign Contribution',
  `payment_processor` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Payment Processors configured for this contribution Page',
  `is_credit_card_only` tinyint NOT NULL DEFAULT '0' COMMENT 'if true - processing logic must reject transaction at confirmation stage if pay method != credit card',
  `is_monetary` tinyint NOT NULL DEFAULT '1' COMMENT 'if true - allows real-time monetary transactions otherwise non-monetary transactions',
  `is_recur` tinyint NOT NULL DEFAULT '0' COMMENT 'if true - allows recurring contributions, valid only for PayPal_Standard',
  `is_confirm_enabled` tinyint NOT NULL DEFAULT '1' COMMENT 'if false, the confirm page in contribution pages gets skipped',
  `recur_frequency_unit` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Supported recurring frequency units.',
  `is_recur_interval` tinyint NOT NULL DEFAULT '0' COMMENT 'if true - supports recurring intervals',
  `is_recur_installments` tinyint NOT NULL DEFAULT '0' COMMENT 'if true - asks user for recurring installments',
  `adjust_recur_start_date` tinyint NOT NULL DEFAULT '0' COMMENT 'if true - user is able to adjust payment start date',
  `is_pay_later` tinyint NOT NULL DEFAULT '0' COMMENT 'if true - allows the user to send payment directly to the org later',
  `pay_later_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'The text displayed to the user in the main form',
  `pay_later_receipt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'The receipt sent to the user instead of the normal receipt text',
  `is_partial_payment` tinyint DEFAULT '0' COMMENT 'is partial payment enabled for this online contribution page',
  `initial_amount_label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Initial amount label for partial payment',
  `initial_amount_help_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Initial amount help text for partial payment',
  `min_initial_amount` decimal(20,2) DEFAULT NULL COMMENT 'Minimum initial amount for partial payment',
  `is_allow_other_amount` tinyint NOT NULL DEFAULT '0' COMMENT 'if true, page will include an input text field where user can enter their own amount',
  `default_amount_id` int unsigned DEFAULT NULL COMMENT 'FK to civicrm_option_value.',
  `min_amount` decimal(20,2) DEFAULT NULL COMMENT 'if other amounts allowed, user can configure minimum allowed.',
  `max_amount` decimal(20,2) DEFAULT NULL COMMENT 'if other amounts allowed, user can configure maximum allowed.',
  `goal_amount` decimal(20,2) DEFAULT NULL COMMENT 'The target goal for this page, allows people to build a goal meter',
  `thankyou_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Title for Thank-you page (header title tag, and display at the top of the page).',
  `thankyou_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'text and html allowed. displayed above result on success page',
  `thankyou_footer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Text and html allowed. displayed at the bottom of the success page. Common usage is to include link(s) to other pages such as tell-a-friend, etc.',
  `is_email_receipt` tinyint NOT NULL DEFAULT '0' COMMENT 'if true, receipt is automatically emailed to contact on success',
  `receipt_from_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'FROM email name used for receipts generated by contributions to this contribution page.',
  `receipt_from_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'FROM email address used for receipts generated by contributions to this contribution page.',
  `cc_receipt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'comma-separated list of email addresses to cc each time a receipt is sent',
  `bcc_receipt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'comma-separated list of email addresses to bcc each time a receipt is sent',
  `receipt_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'text to include above standard receipt info on receipt email. emails are text-only, so do not allow html for now',
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT 'Is this page active?',
  `footer_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Text and html allowed. Displayed at the bottom of the first page of the contribution wizard.',
  `amount_block_is_active` tinyint NOT NULL DEFAULT '1' COMMENT 'Is this property active?',
  `start_date` datetime DEFAULT NULL COMMENT 'Date and time that this page starts.',
  `end_date` datetime DEFAULT NULL COMMENT 'Date and time that this page ends. May be NULL if no defined end date/time',
  `created_id` int unsigned DEFAULT NULL COMMENT 'FK to civicrm_contact, who created this contribution page',
  `created_date` datetime DEFAULT NULL COMMENT 'Date and time that contribution page was created.',
  `currency` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '3 character string, value from config setting or input via user.',
  `campaign_id` int unsigned DEFAULT NULL COMMENT 'The campaign for which we are collecting contributions with this page.',
  `is_share` tinyint NOT NULL DEFAULT '1' COMMENT 'Can people share the contribution page through social media?',
  `is_billing_required` tinyint NOT NULL DEFAULT '0' COMMENT 'if true - billing block is required for online contribution page',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_name` (`name`),
  KEY `FK_civicrm_contribution_page_financial_type_id` (`financial_type_id`),
  KEY `FK_civicrm_contribution_page_created_id` (`created_id`),
  KEY `FK_civicrm_contribution_page_campaign_id` (`campaign_id`),
  CONSTRAINT `FK_civicrm_contribution_page_campaign_id` FOREIGN KEY (`campaign_id`) REFERENCES `civicrm_campaign` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_contribution_page_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_contribution_page_financial_type_id` FOREIGN KEY (`financial_type_id`) REFERENCES `civicrm_financial_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_contribution_page`
--

INSERT INTO `civicrm_contribution_page` VALUES (1,'test','test','test','<p>fdsfdsfs</p>',1,NULL,0,1,0,1,NULL,0,0,0,0,NULL,NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,1,NULL,1,'2024-03-21 21:03:00',NULL,2,'2024-03-21 21:04:06','USD',NULL,0,0);

--
-- Table structure for table `civicrm_contribution_product`
--

CREATE TABLE `civicrm_contribution_product` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int unsigned NOT NULL,
  `contribution_id` int unsigned NOT NULL,
  `product_option` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Option value selected if applicable - e.g. color, size etc.',
  `quantity` int DEFAULT NULL,
  `fulfilled_date` date DEFAULT NULL COMMENT 'Optional. Can be used to record the date this product was fulfilled or shipped.',
  `start_date` date DEFAULT NULL COMMENT 'Actual start date for a time-delimited premium (subscription, service or membership)',
  `end_date` date DEFAULT NULL COMMENT 'Actual end date for a time-delimited premium (subscription, service or membership)',
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `financial_type_id` int unsigned DEFAULT NULL COMMENT 'FK to Financial Type(for membership price sets only).',
  PRIMARY KEY (`id`),
  KEY `FK_civicrm_contribution_product_product_id` (`product_id`),
  KEY `FK_civicrm_contribution_product_contribution_id` (`contribution_id`),
  KEY `FK_civicrm_contribution_product_financial_type_id` (`financial_type_id`),
  CONSTRAINT `FK_civicrm_contribution_product_contribution_id` FOREIGN KEY (`contribution_id`) REFERENCES `civicrm_contribution` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_contribution_product_financial_type_id` FOREIGN KEY (`financial_type_id`) REFERENCES `civicrm_financial_type` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_contribution_product_product_id` FOREIGN KEY (`product_id`) REFERENCES `civicrm_product` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_contribution_product`
--


--
-- Table structure for table `civicrm_contribution_recur`
--

CREATE TABLE `civicrm_contribution_recur` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Contribution Recur ID',
  `contact_id` int unsigned NOT NULL COMMENT 'Foreign key to civicrm_contact.id.',
  `amount` decimal(20,2) NOT NULL COMMENT 'Amount to be collected (including any sales tax) by payment processor each recurrence.',
  `currency` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '3 character string, value from config setting or input via user.',
  `frequency_unit` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'month' COMMENT 'Time units for recurrence of payment.',
  `frequency_interval` int unsigned NOT NULL DEFAULT '1' COMMENT 'Number of time units for recurrence of payment.',
  `installments` int unsigned DEFAULT NULL COMMENT 'Total number of payments to be made. Set this to 0 if this is an open-ended commitment i.e. no set end date.',
  `start_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'The date the first scheduled recurring contribution occurs.',
  `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'When this recurring contribution record was created.',
  `modified_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Last updated date for this record. mostly the last time a payment was received',
  `cancel_date` datetime DEFAULT NULL COMMENT 'Date this recurring contribution was cancelled by contributor- if we can get access to it',
  `cancel_reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Free text field for a reason for cancelling',
  `end_date` datetime DEFAULT NULL COMMENT 'Date this recurring contribution finished successfully',
  `processor_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Possibly needed to store a unique identifier for this recurring payment order - if this is available from the processor??',
  `payment_token_id` int unsigned DEFAULT NULL COMMENT 'Optionally used to store a link to a payment token used for this recurring contribution.',
  `trxn_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique transaction id (deprecated - use processor_id)',
  `invoice_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique invoice id, system generated or passed in',
  `contribution_status_id` int unsigned DEFAULT '2',
  `is_test` tinyint NOT NULL DEFAULT '0',
  `cycle_day` int unsigned NOT NULL DEFAULT '1' COMMENT 'Day in the period when the payment should be charged e.g. 1st of month, 15th etc.',
  `next_sched_contribution_date` datetime DEFAULT NULL COMMENT 'Next scheduled date',
  `failure_count` int unsigned DEFAULT '0' COMMENT 'Number of failed charge attempts since last success. Business rule could be set to deactivate on more than x failures.',
  `failure_retry_date` datetime DEFAULT NULL COMMENT 'Date to retry failed attempt',
  `auto_renew` tinyint NOT NULL DEFAULT '0' COMMENT 'Some systems allow contributor to set a number of installments - but then auto-renew the subscription or commitment if they do not cancel.',
  `payment_processor_id` int unsigned DEFAULT NULL COMMENT 'Foreign key to civicrm_payment_processor.id',
  `financial_type_id` int unsigned DEFAULT NULL COMMENT 'FK to Financial Type',
  `payment_instrument_id` int unsigned DEFAULT NULL COMMENT 'FK to Payment Instrument',
  `campaign_id` int unsigned DEFAULT NULL COMMENT 'The campaign for which this contribution has been triggered.',
  `is_email_receipt` tinyint NOT NULL DEFAULT '1' COMMENT 'if true, receipt is automatically emailed to contact on each successful payment',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_contrib_trxn_id` (`trxn_id`),
  UNIQUE KEY `UI_contrib_invoice_id` (`invoice_id`),
  KEY `index_contribution_status` (`contribution_status_id`),
  KEY `UI_contribution_recur_payment_instrument_id` (`payment_instrument_id`),
  KEY `FK_civicrm_contribution_recur_contact_id` (`contact_id`),
  KEY `FK_civicrm_contribution_recur_payment_token_id` (`payment_token_id`),
  KEY `FK_civicrm_contribution_recur_payment_processor_id` (`payment_processor_id`),
  KEY `FK_civicrm_contribution_recur_financial_type_id` (`financial_type_id`),
  KEY `FK_civicrm_contribution_recur_campaign_id` (`campaign_id`),
  CONSTRAINT `FK_civicrm_contribution_recur_campaign_id` FOREIGN KEY (`campaign_id`) REFERENCES `civicrm_campaign` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_contribution_recur_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_contribution_recur_financial_type_id` FOREIGN KEY (`financial_type_id`) REFERENCES `civicrm_financial_type` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_contribution_recur_payment_processor_id` FOREIGN KEY (`payment_processor_id`) REFERENCES `civicrm_payment_processor` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_contribution_recur_payment_token_id` FOREIGN KEY (`payment_token_id`) REFERENCES `civicrm_payment_token` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_contribution_recur`
--


--
-- Table structure for table `civicrm_contribution_soft`
--

CREATE TABLE `civicrm_contribution_soft` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Soft Credit ID',
  `contribution_id` int unsigned NOT NULL COMMENT 'FK to contribution table.',
  `contact_id` int unsigned NOT NULL COMMENT 'FK to Contact ID',
  `amount` decimal(20,2) NOT NULL COMMENT 'Amount of this soft credit.',
  `currency` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '3 character string, value from config setting or input via user.',
  `pcp_id` int unsigned DEFAULT NULL COMMENT 'FK to civicrm_pcp.id',
  `pcp_display_in_roll` tinyint NOT NULL DEFAULT '0',
  `pcp_roll_nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pcp_personal_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `soft_credit_type_id` int unsigned DEFAULT NULL COMMENT 'Soft Credit Type ID.Implicit FK to civicrm_option_value where option_group = soft_credit_type.',
  PRIMARY KEY (`id`),
  KEY `index_id` (`pcp_id`),
  KEY `FK_civicrm_contribution_soft_contribution_id` (`contribution_id`),
  KEY `FK_civicrm_contribution_soft_contact_id` (`contact_id`),
  CONSTRAINT `FK_civicrm_contribution_soft_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_contribution_soft_contribution_id` FOREIGN KEY (`contribution_id`) REFERENCES `civicrm_contribution` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_contribution_soft_pcp_id` FOREIGN KEY (`pcp_id`) REFERENCES `civicrm_pcp` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_contribution_soft`
--


--
-- Table structure for table `civicrm_contribution_widget`
--

CREATE TABLE `civicrm_contribution_widget` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Contribution ID',
  `contribution_page_id` int unsigned DEFAULT NULL COMMENT 'The Contribution Page which triggered this contribution',
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT 'Is this property active?',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Widget title.',
  `url_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'URL to Widget logo',
  `button_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Button title.',
  `about` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'About description.',
  `url_homepage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'URL to Homepage.',
  `color_title` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_button` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_bar` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_main_text` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_main` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_main_bg` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_bg` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_about_link` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_homepage_link` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_civicrm_contribution_widget_contribution_page_id` (`contribution_page_id`),
  CONSTRAINT `FK_civicrm_contribution_widget_contribution_page_id` FOREIGN KEY (`contribution_page_id`) REFERENCES `civicrm_contribution_page` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_contribution_widget`
--


--
-- Table structure for table `civicrm_country`
--

CREATE TABLE `civicrm_country` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Country ID',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Country Name',
  `iso_code` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'ISO Code',
  `country_code` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'National prefix to be used when dialing TO this country.',
  `address_format_id` int unsigned DEFAULT NULL COMMENT 'Foreign key to civicrm_address_format.id.',
  `idd_prefix` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'International direct dialing prefix from within the country TO another country',
  `ndd_prefix` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Access prefix to call within a country to a different area',
  `region_id` int unsigned NOT NULL COMMENT 'Foreign key to civicrm_worldregion.id.',
  `is_province_abbreviated` tinyint NOT NULL DEFAULT '0' COMMENT 'Should state/province be displayed as abbreviation for contacts from this country?',
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT 'Is this Country active?',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_name_iso_code` (`name`,`iso_code`),
  KEY `FK_civicrm_country_address_format_id` (`address_format_id`),
  KEY `FK_civicrm_country_region_id` (`region_id`),
  CONSTRAINT `FK_civicrm_country_address_format_id` FOREIGN KEY (`address_format_id`) REFERENCES `civicrm_address_format` (`id`),
  CONSTRAINT `FK_civicrm_country_region_id` FOREIGN KEY (`region_id`) REFERENCES `civicrm_worldregion` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1254 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_country`
--

INSERT INTO `civicrm_country` VALUES (1001,'Afghanistan','AF',NULL,NULL,NULL,NULL,4,0,1),(1002,'Albania','AL',NULL,NULL,NULL,NULL,1,0,1),(1003,'Algeria','DZ',NULL,NULL,NULL,NULL,3,0,1),(1004,'American Samoa','AS',NULL,NULL,NULL,NULL,2,0,1),(1005,'Andorra','AD',NULL,NULL,NULL,NULL,1,0,1),(1006,'Angola','AO',NULL,NULL,NULL,NULL,5,0,1),(1007,'Anguilla','AI',NULL,NULL,NULL,NULL,2,0,1),(1008,'Antarctica','AQ',NULL,NULL,NULL,NULL,1,0,1),(1009,'Antigua and Barbuda','AG',NULL,NULL,NULL,NULL,2,0,1),(1010,'Argentina','AR',NULL,NULL,NULL,NULL,2,0,1),(1011,'Armenia','AM',NULL,NULL,NULL,NULL,1,0,1),(1012,'Aruba','AW',NULL,NULL,NULL,NULL,2,0,1),(1013,'Australia','AU',NULL,NULL,NULL,NULL,4,0,1),(1014,'Austria','AT',NULL,NULL,NULL,NULL,1,0,1),(1015,'Azerbaijan','AZ',NULL,NULL,NULL,NULL,1,0,1),(1016,'Bahrain','BH',NULL,NULL,NULL,NULL,3,0,1),(1017,'Bangladesh','BD',NULL,NULL,NULL,NULL,4,0,1),(1018,'Barbados','BB',NULL,NULL,NULL,NULL,4,0,1),(1019,'Belarus','BY',NULL,NULL,NULL,NULL,1,0,1),(1020,'Belgium','BE',NULL,NULL,NULL,NULL,1,0,1),(1021,'Belize','BZ',NULL,NULL,NULL,NULL,2,0,1),(1022,'Benin','BJ',NULL,NULL,NULL,NULL,5,0,1),(1023,'Bermuda','BM',NULL,NULL,NULL,NULL,2,0,1),(1024,'Bhutan','BT',NULL,NULL,NULL,NULL,4,0,1),(1025,'Bolivia','BO',NULL,NULL,NULL,NULL,2,0,1),(1026,'Bosnia and Herzegovina','BA',NULL,NULL,NULL,NULL,1,0,1),(1027,'Botswana','BW',NULL,NULL,NULL,NULL,5,0,1),(1028,'Bouvet Island','BV',NULL,NULL,NULL,NULL,1,0,1),(1029,'Brazil','BR',NULL,NULL,NULL,NULL,2,0,1),(1030,'British Indian Ocean Territory','IO',NULL,NULL,NULL,NULL,4,0,1),(1031,'Virgin Islands, British','VG',NULL,NULL,NULL,NULL,2,0,1),(1032,'Brunei Darussalam','BN',NULL,NULL,NULL,NULL,4,0,1),(1033,'Bulgaria','BG',NULL,NULL,NULL,NULL,1,0,1),(1034,'Burkina Faso','BF',NULL,NULL,NULL,NULL,5,0,1),(1035,'Myanmar','MM',NULL,NULL,NULL,NULL,4,0,1),(1036,'Burundi','BI',NULL,NULL,NULL,NULL,5,0,1),(1037,'Cambodia','KH',NULL,NULL,NULL,NULL,4,0,1),(1038,'Cameroon','CM',NULL,NULL,NULL,NULL,5,0,1),(1039,'Canada','CA',NULL,NULL,NULL,NULL,2,1,1),(1040,'Cape Verde','CV',NULL,NULL,NULL,NULL,5,0,1),(1041,'Cayman Islands','KY',NULL,NULL,NULL,NULL,5,0,1),(1042,'Central African Republic','CF',NULL,NULL,NULL,NULL,5,0,1),(1043,'Chad','TD',NULL,NULL,NULL,NULL,5,0,1),(1044,'Chile','CL',NULL,NULL,NULL,NULL,2,0,1),(1045,'China','CN',NULL,NULL,NULL,NULL,4,0,1),(1046,'Christmas Island','CX',NULL,NULL,NULL,NULL,4,0,1),(1047,'Cocos (Keeling) Islands','CC',NULL,NULL,NULL,NULL,4,0,1),(1048,'Colombia','CO',NULL,NULL,NULL,NULL,2,0,1),(1049,'Comoros','KM',NULL,NULL,NULL,NULL,5,0,1),(1050,'Congo, The Democratic Republic of the','CD',NULL,NULL,NULL,NULL,5,0,1),(1051,'Congo, Republic of the','CG',NULL,NULL,NULL,NULL,5,0,1),(1052,'Cook Islands','CK',NULL,NULL,NULL,NULL,4,0,1),(1053,'Costa Rica','CR',NULL,NULL,NULL,NULL,2,0,1),(1054,'Côte d’Ivoire','CI',NULL,NULL,NULL,NULL,5,0,1),(1055,'Croatia','HR',NULL,NULL,NULL,NULL,1,0,1),(1056,'Cuba','CU',NULL,NULL,NULL,NULL,2,0,1),(1057,'Cyprus','CY',NULL,NULL,NULL,NULL,1,0,1),(1058,'Czech Republic','CZ',NULL,NULL,NULL,NULL,1,0,1),(1059,'Denmark','DK',NULL,NULL,NULL,NULL,1,0,1),(1060,'Djibouti','DJ',NULL,NULL,NULL,NULL,5,0,1),(1061,'Dominica','DM',NULL,NULL,NULL,NULL,2,0,1),(1062,'Dominican Republic','DO',NULL,NULL,NULL,NULL,2,0,1),(1063,'Timor-Leste','TL',NULL,NULL,NULL,NULL,4,0,1),(1064,'Ecuador','EC',NULL,NULL,NULL,NULL,2,0,1),(1065,'Egypt','EG',NULL,NULL,NULL,NULL,3,0,1),(1066,'El Salvador','SV',NULL,NULL,NULL,NULL,2,0,1),(1067,'Equatorial Guinea','GQ',NULL,NULL,NULL,NULL,5,0,1),(1068,'Eritrea','ER',NULL,NULL,NULL,NULL,5,0,1),(1069,'Estonia','EE',NULL,NULL,NULL,NULL,1,0,1),(1070,'Ethiopia','ET',NULL,NULL,NULL,NULL,5,0,1),(1072,'Falkland Islands (Malvinas)','FK',NULL,NULL,NULL,NULL,2,0,1),(1073,'Faroe Islands','FO',NULL,NULL,NULL,NULL,1,0,1),(1074,'Fiji','FJ',NULL,NULL,NULL,NULL,4,0,1),(1075,'Finland','FI',NULL,NULL,NULL,NULL,1,0,1),(1076,'France','FR',NULL,NULL,NULL,NULL,1,0,1),(1077,'French Guiana','GF',NULL,NULL,NULL,NULL,2,0,1),(1078,'French Polynesia','PF',NULL,NULL,NULL,NULL,4,0,1),(1079,'French Southern Territories','TF',NULL,NULL,NULL,NULL,1,0,1),(1080,'Gabon','GA',NULL,NULL,NULL,NULL,5,0,1),(1081,'Georgia','GE',NULL,NULL,NULL,NULL,3,0,1),(1082,'Germany','DE',NULL,NULL,NULL,NULL,1,0,1),(1083,'Ghana','GH',NULL,NULL,NULL,NULL,5,0,1),(1084,'Gibraltar','GI',NULL,NULL,NULL,NULL,1,0,1),(1085,'Greece','GR',NULL,NULL,NULL,NULL,1,0,1),(1086,'Greenland','GL',NULL,NULL,NULL,NULL,2,0,1),(1087,'Grenada','GD',NULL,NULL,NULL,NULL,2,0,1),(1088,'Guadeloupe','GP',NULL,NULL,NULL,NULL,2,0,1),(1089,'Guam','GU',NULL,NULL,NULL,NULL,4,0,1),(1090,'Guatemala','GT',NULL,NULL,NULL,NULL,2,0,1),(1091,'Guinea','GN',NULL,NULL,NULL,NULL,5,0,1),(1092,'Guinea-Bissau','GW',NULL,NULL,NULL,NULL,5,0,1),(1093,'Guyana','GY',NULL,NULL,NULL,NULL,2,0,1),(1094,'Haiti','HT',NULL,NULL,NULL,NULL,2,0,1),(1095,'Heard Island and McDonald Islands','HM',NULL,NULL,NULL,NULL,4,0,1),(1096,'Holy See (Vatican City State)','VA',NULL,NULL,NULL,NULL,1,0,1),(1097,'Honduras','HN',NULL,NULL,NULL,NULL,2,0,1),(1098,'Hong Kong','HK',NULL,NULL,NULL,NULL,4,0,1),(1099,'Hungary','HU',NULL,NULL,NULL,NULL,1,0,1),(1100,'Iceland','IS',NULL,NULL,NULL,NULL,1,0,1),(1101,'India','IN',NULL,NULL,NULL,NULL,4,0,1),(1102,'Indonesia','ID',NULL,NULL,NULL,NULL,4,0,1),(1103,'Iran, Islamic Republic of','IR',NULL,NULL,NULL,NULL,3,0,1),(1104,'Iraq','IQ',NULL,NULL,NULL,NULL,3,0,1),(1105,'Ireland','IE',NULL,NULL,NULL,NULL,1,0,1),(1106,'Israel','IL',NULL,NULL,NULL,NULL,3,0,1),(1107,'Italy','IT',NULL,NULL,NULL,NULL,1,0,1),(1108,'Jamaica','JM',NULL,NULL,NULL,NULL,2,0,1),(1109,'Japan','JP',NULL,NULL,NULL,NULL,4,0,1),(1110,'Jordan','JO',NULL,NULL,NULL,NULL,3,0,1),(1111,'Kazakhstan','KZ',NULL,NULL,NULL,NULL,1,0,1),(1112,'Kenya','KE',NULL,NULL,NULL,NULL,5,0,1),(1113,'Kiribati','KI',NULL,NULL,NULL,NULL,4,0,1),(1114,'Korea, Democratic People\'s Republic of','KP',NULL,NULL,NULL,NULL,4,0,1),(1115,'Korea, Republic of','KR',NULL,NULL,NULL,NULL,4,0,1),(1116,'Kuwait','KW',NULL,NULL,NULL,NULL,3,0,1),(1117,'Kyrgyzstan','KG',NULL,NULL,NULL,NULL,1,0,1),(1118,'Lao People\'s Democratic Republic','LA',NULL,NULL,NULL,NULL,4,0,1),(1119,'Latvia','LV',NULL,NULL,NULL,NULL,1,0,1),(1120,'Lebanon','LB',NULL,NULL,NULL,NULL,3,0,1),(1121,'Lesotho','LS',NULL,NULL,NULL,NULL,5,0,1),(1122,'Liberia','LR',NULL,NULL,NULL,NULL,5,0,1),(1123,'Libya','LY',NULL,NULL,NULL,NULL,3,0,1),(1124,'Liechtenstein','LI',NULL,NULL,NULL,NULL,1,0,1),(1125,'Lithuania','LT',NULL,NULL,NULL,NULL,1,0,1),(1126,'Luxembourg','LU',NULL,NULL,NULL,NULL,1,0,1),(1127,'Macao','MO',NULL,NULL,NULL,NULL,4,0,1),(1128,'North Macedonia','MK',NULL,NULL,NULL,NULL,1,0,1),(1129,'Madagascar','MG',NULL,NULL,NULL,NULL,5,0,1),(1130,'Malawi','MW',NULL,NULL,NULL,NULL,5,0,1),(1131,'Malaysia','MY',NULL,NULL,NULL,NULL,4,0,1),(1132,'Maldives','MV',NULL,NULL,NULL,NULL,4,0,1),(1133,'Mali','ML',NULL,NULL,NULL,NULL,5,0,1),(1134,'Malta','MT',NULL,NULL,NULL,NULL,1,0,1),(1135,'Marshall Islands','MH',NULL,NULL,NULL,NULL,4,0,1),(1136,'Martinique','MQ',NULL,NULL,NULL,NULL,2,0,1),(1137,'Mauritania','MR',NULL,NULL,NULL,NULL,5,0,1),(1138,'Mauritius','MU',NULL,NULL,NULL,NULL,5,0,1),(1139,'Mayotte','YT',NULL,NULL,NULL,NULL,5,0,1),(1140,'Mexico','MX',NULL,NULL,NULL,NULL,2,0,1),(1141,'Micronesia, Federated States of','FM',NULL,NULL,NULL,NULL,4,0,1),(1142,'Moldova','MD',NULL,NULL,NULL,NULL,1,0,1),(1143,'Monaco','MC',NULL,NULL,NULL,NULL,1,0,1),(1144,'Mongolia','MN',NULL,NULL,NULL,NULL,4,0,1),(1145,'Montserrat','MS',NULL,NULL,NULL,NULL,2,0,1),(1146,'Morocco','MA',NULL,NULL,NULL,NULL,3,0,1),(1147,'Mozambique','MZ',NULL,NULL,NULL,NULL,5,0,1),(1148,'Namibia','NA',NULL,NULL,NULL,NULL,5,0,1),(1149,'Nauru','NR',NULL,NULL,NULL,NULL,4,0,1),(1150,'Nepal','NP',NULL,NULL,NULL,NULL,4,0,1),(1152,'Netherlands','NL',NULL,NULL,NULL,NULL,1,0,1),(1153,'New Caledonia','NC',NULL,NULL,NULL,NULL,4,0,1),(1154,'New Zealand','NZ',NULL,NULL,NULL,NULL,4,0,1),(1155,'Nicaragua','NI',NULL,NULL,NULL,NULL,2,0,1),(1156,'Niger','NE',NULL,NULL,NULL,NULL,5,0,1),(1157,'Nigeria','NG',NULL,NULL,NULL,NULL,5,0,1),(1158,'Niue','NU',NULL,NULL,NULL,NULL,4,0,1),(1159,'Norfolk Island','NF',NULL,NULL,NULL,NULL,4,0,1),(1160,'Northern Mariana Islands','MP',NULL,NULL,NULL,NULL,2,0,1),(1161,'Norway','NO',NULL,NULL,NULL,NULL,1,0,1),(1162,'Oman','OM',NULL,NULL,NULL,NULL,3,0,1),(1163,'Pakistan','PK',NULL,NULL,NULL,NULL,4,0,1),(1164,'Palau','PW',NULL,NULL,NULL,NULL,4,0,1),(1165,'Palestine, State of','PS',NULL,NULL,NULL,NULL,3,0,1),(1166,'Panama','PA',NULL,NULL,NULL,NULL,2,0,1),(1167,'Papua New Guinea','PG',NULL,NULL,NULL,NULL,4,0,1),(1168,'Paraguay','PY',NULL,NULL,NULL,NULL,2,0,1),(1169,'Peru','PE',NULL,NULL,NULL,NULL,2,0,1),(1170,'Philippines','PH',NULL,NULL,NULL,NULL,4,0,1),(1171,'Pitcairn','PN',NULL,NULL,NULL,NULL,4,0,1),(1172,'Poland','PL',NULL,NULL,NULL,NULL,1,0,1),(1173,'Portugal','PT',NULL,NULL,NULL,NULL,1,0,1),(1174,'Puerto Rico','PR',NULL,NULL,NULL,NULL,2,0,1),(1175,'Qatar','QA',NULL,NULL,NULL,NULL,3,0,1),(1176,'Romania','RO',NULL,NULL,NULL,NULL,1,0,1),(1177,'Russian Federation','RU',NULL,NULL,NULL,NULL,1,0,1),(1178,'Rwanda','RW',NULL,NULL,NULL,NULL,5,0,1),(1179,'Reunion','RE',NULL,NULL,NULL,NULL,5,0,1),(1180,'Saint Helena','SH',NULL,NULL,NULL,NULL,5,0,1),(1181,'Saint Kitts and Nevis','KN',NULL,NULL,NULL,NULL,2,0,1),(1182,'Saint Lucia','LC',NULL,NULL,NULL,NULL,2,0,1),(1183,'Saint Pierre and Miquelon','PM',NULL,NULL,NULL,NULL,2,0,1),(1184,'Saint Vincent and the Grenadines','VC',NULL,NULL,NULL,NULL,2,0,1),(1185,'Samoa','WS',NULL,NULL,NULL,NULL,4,0,1),(1186,'San Marino','SM',NULL,NULL,NULL,NULL,1,0,1),(1187,'Saudi Arabia','SA',NULL,NULL,NULL,NULL,3,0,1),(1188,'Senegal','SN',NULL,NULL,NULL,NULL,5,0,1),(1189,'Seychelles','SC',NULL,NULL,NULL,NULL,5,0,1),(1190,'Sierra Leone','SL',NULL,NULL,NULL,NULL,5,0,1),(1191,'Singapore','SG',NULL,NULL,NULL,NULL,4,0,1),(1192,'Slovakia','SK',NULL,NULL,NULL,NULL,1,0,1),(1193,'Slovenia','SI',NULL,NULL,NULL,NULL,1,0,1),(1194,'Solomon Islands','SB',NULL,NULL,NULL,NULL,4,0,1),(1195,'Somalia','SO',NULL,NULL,NULL,NULL,5,0,1),(1196,'South Africa','ZA',NULL,NULL,NULL,NULL,5,0,1),(1197,'South Georgia and the South Sandwich Islands','GS',NULL,NULL,NULL,NULL,2,0,1),(1198,'Spain','ES',NULL,NULL,NULL,NULL,1,0,1),(1199,'Sri Lanka','LK',NULL,NULL,NULL,NULL,4,0,1),(1200,'Sudan','SD',NULL,NULL,NULL,NULL,3,0,1),(1201,'Suriname','SR',NULL,NULL,NULL,NULL,2,0,1),(1202,'Svalbard and Jan Mayen','SJ',NULL,NULL,NULL,NULL,1,0,1),(1203,'Eswatini','SZ',NULL,NULL,NULL,NULL,5,0,1),(1204,'Sweden','SE',NULL,NULL,NULL,NULL,1,0,1),(1205,'Switzerland','CH',NULL,NULL,NULL,NULL,1,0,1),(1206,'Syrian Arab Republic','SY',NULL,NULL,NULL,NULL,3,0,1),(1207,'Sao Tome and Principe','ST',NULL,NULL,NULL,NULL,5,0,1),(1208,'Taiwan','TW',NULL,NULL,NULL,NULL,4,0,1),(1209,'Tajikistan','TJ',NULL,NULL,NULL,NULL,3,0,1),(1210,'Tanzania, United Republic of','TZ',NULL,NULL,NULL,NULL,5,0,1),(1211,'Thailand','TH',NULL,NULL,NULL,NULL,4,0,1),(1212,'Bahamas','BS',NULL,NULL,NULL,NULL,2,0,1),(1213,'Gambia','GM',NULL,NULL,NULL,NULL,5,0,1),(1214,'Togo','TG',NULL,NULL,NULL,NULL,5,0,1),(1215,'Tokelau','TK',NULL,NULL,NULL,NULL,4,0,1),(1216,'Tonga','TO',NULL,NULL,NULL,NULL,4,0,1),(1217,'Trinidad and Tobago','TT',NULL,NULL,NULL,NULL,2,0,1),(1218,'Tunisia','TN',NULL,NULL,NULL,NULL,3,0,1),(1219,'Turkey','TR',NULL,NULL,NULL,NULL,1,0,1),(1220,'Turkmenistan','TM',NULL,NULL,NULL,NULL,1,0,1),(1221,'Turks and Caicos Islands','TC',NULL,NULL,NULL,NULL,2,0,1),(1222,'Tuvalu','TV',NULL,NULL,NULL,NULL,4,0,1),(1223,'Uganda','UG',NULL,NULL,NULL,NULL,5,0,1),(1224,'Ukraine','UA',NULL,NULL,NULL,NULL,1,0,1),(1225,'United Arab Emirates','AE',NULL,NULL,NULL,NULL,3,0,1),(1226,'United Kingdom','GB',NULL,NULL,NULL,NULL,1,0,1),(1227,'United States Minor Outlying Islands','UM',NULL,NULL,NULL,NULL,2,0,1),(1228,'United States','US',NULL,NULL,NULL,NULL,2,1,1),(1229,'Uruguay','UY',NULL,NULL,NULL,NULL,2,0,1),(1230,'Uzbekistan','UZ',NULL,NULL,NULL,NULL,1,0,1),(1231,'Vanuatu','VU',NULL,NULL,NULL,NULL,4,0,1),(1232,'Venezuela','VE',NULL,NULL,NULL,NULL,2,0,1),(1233,'Viet Nam','VN',NULL,NULL,NULL,NULL,4,0,1),(1234,'Virgin Islands, U.S.','VI',NULL,NULL,NULL,NULL,2,0,1),(1235,'Wallis and Futuna','WF',NULL,NULL,NULL,NULL,4,0,1),(1236,'Western Sahara','EH',NULL,NULL,NULL,NULL,3,0,1),(1237,'Yemen','YE',NULL,NULL,NULL,NULL,3,0,1),(1239,'Zambia','ZM',NULL,NULL,NULL,NULL,5,0,1),(1240,'Zimbabwe','ZW',NULL,NULL,NULL,NULL,5,0,1),(1241,'Åland Islands','AX',NULL,NULL,NULL,NULL,1,0,1),(1242,'Serbia','RS',NULL,NULL,NULL,NULL,1,0,1),(1243,'Montenegro','ME',NULL,NULL,NULL,NULL,1,0,1),(1244,'Jersey','JE',NULL,NULL,NULL,NULL,99,0,1),(1245,'Guernsey','GG',NULL,NULL,NULL,NULL,99,0,1),(1246,'Isle of Man','IM',NULL,NULL,NULL,NULL,99,0,1),(1247,'South Sudan','SS',NULL,NULL,NULL,NULL,5,0,1),(1248,'Curaçao','CW',NULL,NULL,NULL,NULL,2,0,1),(1249,'Sint Maarten (Dutch Part)','SX',NULL,NULL,NULL,NULL,2,0,1),(1250,'Bonaire, Saint Eustatius and Saba','BQ',NULL,NULL,NULL,NULL,2,0,1),(1251,'Kosovo','XK',NULL,NULL,NULL,NULL,1,0,1),(1252,'Saint Barthélemy','BL',NULL,NULL,NULL,NULL,2,0,1),(1253,'Saint Martin (French part)','MF',NULL,NULL,NULL,NULL,2,0,1);

--
-- Table structure for table `civicrm_county`
--

CREATE TABLE `civicrm_county` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'County ID',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Name of County',
  `abbreviation` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '2-4 Character Abbreviation of County',
  `state_province_id` int unsigned NOT NULL COMMENT 'ID of State/Province that County belongs',
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT 'Is this County active?',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_name_state_id` (`name`,`state_province_id`),
  KEY `FK_civicrm_county_state_province_id` (`state_province_id`),
  CONSTRAINT `FK_civicrm_county_state_province_id` FOREIGN KEY (`state_province_id`) REFERENCES `civicrm_state_province` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_county`
--

INSERT INTO `civicrm_county` VALUES (1,'Alameda',NULL,1004,1),(2,'Contra Costa',NULL,1004,1),(3,'Marin',NULL,1004,1),(4,'San Francisco',NULL,1004,1),(5,'San Mateo',NULL,1004,1),(6,'Santa Clara',NULL,1004,1);

--
-- Table structure for table `civicrm_currency`
--

CREATE TABLE `civicrm_currency` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Currency ID',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Currency Name',
  `symbol` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Currency Symbol',
  `numeric_code` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Numeric currency code',
  `full_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Full currency name',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=186 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_currency`
--

INSERT INTO `civicrm_currency` VALUES (1,'AUD','$','036','Australian Dollar'),(2,'CAD','$','124','Canadian Dollar'),(3,'EUR','€','978','Euro'),(4,'GBP','£','826','Pound Sterling'),(5,'ILS','₪','826','New Israeli Shekel'),(6,'INR','₨','356','Indian Rupee'),(7,'JPY','¥','392','Japanese Yen'),(8,'KRW','₩','410','South Korean Won'),(9,'LAK','₭','418','Lao Kip'),(10,'MNT','₮','496','Mongolian Tugrik'),(11,'NGN','₦','566','Nigerian Naira'),(12,'PLN','zł','985','Polish Złoty'),(13,'THB','฿','764','Thai Baht'),(14,'USD','$','840','US Dollar'),(15,'VND','₫','704','Viet Nam Dong'),(16,'ZAR','R','710','South African Rand'),(17,'AED',NULL,'784','UAE Dirham'),(18,'AFN','؋','971','Afghani'),(19,'ALL','Lek','008','Albanian Lek'),(20,'AMD',NULL,'051','Armenian Dram'),(21,'ANG','ƒ','532','Netherlands Antillian Guilder'),(22,'AOA',NULL,'973','Angola Kwanza'),(23,'ARS','$','032','Argentine Peso'),(24,'AWG','ƒ','533','Aruban Guilder'),(25,'AZN','ман','944','Azerbaijanian Manat'),(26,'BAM','KM','977','Convertible Marks'),(27,'BBD','$','052','Barbados Dollar'),(28,'BDT',NULL,'050','Bangladeshi Taka'),(29,'BGN','лв','975','Bulgarian Lev'),(30,'BHD',NULL,'048','Bahraini Dinar'),(31,'BIF',NULL,'108','Burundi Franc'),(32,'BMD','$','060','Bermudian Dollar'),(33,'BND','$','096','Brunei Dollar'),(34,'BOB','$b','068','Boliviano'),(35,'BOV',NULL,'984','Bolivian Mvdol'),(36,'BRL','R$','986','Brazilian Real'),(37,'BSD','$','044','Bahamian Dollar'),(38,'BTN',NULL,'064','Bhutan Ngultrum'),(39,'BWP','P','072','Botswana Pula'),(40,'BYN','p.','974','Belarussian Rouble'),(41,'BZD','BZ$','084','Belize Dollar'),(42,'CDF',NULL,'976','Franc Congolais'),(43,'CHE',NULL,'947','WIR Euro'),(44,'CHF','CHF','756','Swiss Franc'),(45,'CHW',NULL,'948','WIR Franc'),(46,'CLF',NULL,'990','Unidades de fomento'),(47,'CLP','$','152','Chilean Peso'),(48,'CNY','元','156','Chinese Yuan Renminbi'),(49,'COP','$','170','Colombian Peso'),(50,'COU',NULL,'970','Unidad de Valor Real'),(51,'CRC','₡','188','Costa Rican Colon'),(52,'RSD','Дин.','941','Serbian Dinar'),(53,'CUP','₱','192','Cuban Peso'),(54,'CVE',NULL,'132','Cape Verde Escudo'),(56,'CZK','Kč','203','Czech Koruna'),(57,'DJF',NULL,'262','Djibouti Franc'),(58,'DKK','kr','208','Danish Krone'),(59,'DOP','RD$','214','Dominican Peso'),(60,'DZD',NULL,'012','Algerian Dinar'),(62,'EGP','£','818','Egyptian Pound'),(63,'ERN',NULL,'232','Eritrean Nakfa'),(64,'ETB',NULL,'230','Ethiopian Birr'),(65,'FJD','$','242','Fiji Dollar'),(66,'FKP','£','238','Falkland Islands Pound'),(67,'GEL',NULL,'981','Georgian Lari'),(68,'GHS','¢','288','Ghanaian Cedi'),(69,'GIP','£','292','Gibraltar Pound'),(70,'GMD',NULL,'270','Gambian Dalasi'),(71,'GNF',NULL,'324','Guinea Franc'),(72,'GTQ','Q','320','Guatemalan Quetzal'),(74,'GYD','$','328','Guyana Dollar'),(75,'HKD','HK$','344','Hong Kong Dollar'),(76,'HNL','L','340','Honduran Lempira'),(77,'HRK','kn','191','Croatian Kuna'),(78,'HTG',NULL,'332','Haitian Gourde'),(79,'HUF','Ft','348','Hungarian Forint'),(80,'IDR','Rp','360','Indonesian Rupiah'),(81,'IQD',NULL,'368','Iraqi Dinar'),(82,'IRR','﷼','364','Iranian Rial'),(83,'ISK','kr','352','Iceland Krona'),(84,'JMD','J$','388','Jamaican Dollar'),(85,'JOD',NULL,'400','Jordanian Dinar'),(86,'KES',NULL,'404','Kenyan Shilling'),(87,'KGS','лв','417','Kyrgyzstan Som'),(88,'KHR','៛','116','Cambodian Riel'),(89,'KMF',NULL,'174','Comoro Franc'),(90,'KPW','₩','408','North Korean Won'),(91,'KWD',NULL,'414','Kuwaiti Dinar'),(92,'KYD','$','136','Cayman Islands Dollar'),(93,'KZT','лв','398','Kazakhstan Tenge'),(94,'LBP','£','422','Lebanese Pound'),(95,'LKR','₨','144','Sri Lanka Rupee'),(96,'LRD','$','430','Liberian Dollar'),(97,'LSL',NULL,'426','Lesotho Loti'),(100,'LYD',NULL,'434','Libyan Dinar'),(101,'MAD',NULL,'504','Moroccan Dirham'),(102,'MDL',NULL,'498','Moldovan Leu'),(103,'MGA',NULL,'969','Malagascy Ariary'),(104,'MKD','ден','807','Macedonian Denar'),(105,'MMK',NULL,'104','Myanmar Kyat'),(106,'MOP',NULL,'446','Macao Pataca'),(107,'MRO',NULL,'478','Mauritanian Ouguiya'),(109,'MUR','₨','480','Mauritius Rupee'),(110,'MVR',NULL,'462','Maldive Rufiyaa'),(111,'MWK',NULL,'454','Malawi Kwacha'),(112,'MXN','$','484','Mexican Peso'),(113,'MXV',NULL,'979','Mexican Unidad de Inversion (UID)'),(114,'MYR','RM','458','Malaysian Ringgit'),(115,'MZN','MT','943','Mozambique Metical'),(116,'NAD','N$','516','Namibian Dollar'),(117,'NIO','C$','558','Nicaraguan Cordoba Oro'),(118,'NOK','kr','578','Norwegian Krone'),(119,'NPR','₨','524','Nepalese Rupee'),(120,'NZD','$','554','New Zealand Dollar'),(121,'OMR','﷼','512','Rial Omani'),(122,'PAB','B/.','590','Panamanian Balboa'),(123,'PEN','S/.','604','Peruvian Nuevo Sol'),(124,'PGK',NULL,'598','Papua New Guinea Kina'),(125,'PHP','Php','608','Philippine Peso'),(126,'PKR','₨','586','Pakistan Rupee'),(127,'PYG','Gs','600','Paraguay Guarani'),(128,'QAR','﷼','634','Qatari Rial'),(130,'RON','lei','946','Romanian New Leu'),(131,'RUB','руб','643','Russian Rouble'),(132,'RWF',NULL,'646','Rwanda Franc'),(133,'SAR','﷼','682','Saudi Riyal'),(134,'SBD','$','090','Solomon Islands Dollar'),(135,'SCR','₨','690','Seychelles Rupee'),(137,'SEK','kr','752','Swedish Krona'),(138,'SGD','$','702','Singapore Dollar'),(139,'SHP','£','654','Saint Helena Pound'),(142,'SLL',NULL,'694','Leone'),(143,'SOS','S','706','Somali Shilling'),(144,'SRD','$','968','Surinam Dollar'),(145,'STD',NULL,'678','São Tome and Principe Dobra'),(146,'SVC','$','222','El Salvador Colon'),(147,'SYP','£','760','Syrian Pound'),(148,'SZL',NULL,'748','Eswatini Lilangeni'),(149,'TJS',NULL,'972','Tajik Somoni'),(151,'TND',NULL,'788','Tunisian Dinar'),(152,'TOP',NULL,'776','Tongan Pa\'anga'),(153,'TRY','YTL','949','New Turkish Lira'),(154,'TTD','TT$','780','Trinidad and Tobago Dollar'),(155,'TWD','NT$','901','New Taiwan Dollar'),(156,'TZS',NULL,'834','Tanzanian Shilling'),(157,'UAH','₴','980','Ukrainian Hryvnia'),(158,'UGX',NULL,'800','Ugandan Shilling'),(159,'USN',NULL,'997','US Dollar (Next day)'),(160,'USS',NULL,'998','US Dollar (Same day)'),(161,'UYU','$U','858','Peso Uruguayo'),(162,'UZS','лв','860','Uzbekistan Sum'),(163,'VEF','Bs','937','Venezuela Bolivar'),(164,'VUV',NULL,'548','Vanuatu Vatu'),(165,'WST',NULL,'882','Samoan Tala'),(166,'XAF',NULL,'950','CFA Franc BEAC'),(167,'XAG',NULL,'961','Silver'),(168,'XAU',NULL,'959','Gold'),(169,'XBA',NULL,'955','Bond Markets Units European Composite Unit (EURCO)'),(170,'XBB',NULL,'956','European Monetary Unit (E.M.U.-6)'),(171,'XBC',NULL,'957','European Unit of Account 9 (E.U.A.-9)'),(172,'XBD',NULL,'958','European Unit of Account 17 (E.U.A.-17)'),(173,'XCD','$','951','East Caribbean Dollar'),(174,'XDR',NULL,'960','Special Drawing Right'),(175,'XFO',NULL,NULL,'Gold-Franc'),(176,'XFU',NULL,NULL,'UIC-Franc'),(177,'XOF',NULL,'952','CFA Franc BCEAO'),(178,'XPD',NULL,'964','Palladium'),(179,'XPF',NULL,'953','CFP Franc'),(180,'XPT',NULL,'962','Platinum'),(181,'XTS',NULL,'963','Code for testing purposes'),(182,'XXX',NULL,'999','No currency involved'),(183,'YER','﷼','886','Yemeni Rial'),(184,'ZMK',NULL,'894','Zambian Kwacha'),(185,'ZWD','Z$','716','Zimbabwe Dollar');

--
-- Table structure for table `civicrm_custom_field`
--

CREATE TABLE `civicrm_custom_field` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Custom Field ID',
  `custom_group_id` int unsigned NOT NULL COMMENT 'FK to civicrm_custom_group.',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Variable name/programmatic handle for this field.',
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Text for form field label (also friendly name for administering this custom property).',
  `data_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Controls location of data storage in extended_data table.',
  `html_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'HTML types plus several built-in extended types.',
  `default_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Use form_options.is_default for field_types which use options.',
  `is_required` tinyint NOT NULL DEFAULT '0' COMMENT 'Is a value required for this property.',
  `is_searchable` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this property searchable.',
  `is_search_range` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this property range searchable.',
  `weight` int NOT NULL DEFAULT '1' COMMENT 'Controls field display order within an extended property group.',
  `help_pre` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Description and/or help text to display before this field.',
  `help_post` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Description and/or help text to display after this field.',
  `attributes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Store collection of type-appropriate attributes, e.g. textarea  needs rows/cols attributes',
  `is_active` tinyint DEFAULT '1' COMMENT 'Is this property active?',
  `is_view` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this property set by PHP Code? A code field is viewable but not editable',
  `options_per_line` int unsigned DEFAULT NULL COMMENT 'number of options per line for checkbox and radio',
  `text_length` int unsigned DEFAULT NULL COMMENT 'field length if alphanumeric',
  `start_date_years` int DEFAULT NULL COMMENT 'Date may be up to start_date_years years prior to the current date.',
  `end_date_years` int DEFAULT NULL COMMENT 'Date may be up to end_date_years years after the current date.',
  `date_format` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'date format for custom date',
  `time_format` int unsigned DEFAULT NULL COMMENT 'time format for custom date',
  `note_columns` int unsigned DEFAULT NULL COMMENT 'Number of columns in Note Field',
  `note_rows` int unsigned DEFAULT NULL COMMENT 'Number of rows in Note Field',
  `column_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Name of the column that holds the values for this field.',
  `option_group_id` int unsigned DEFAULT NULL COMMENT 'For elements with options, the option group id that is used',
  `serialize` int unsigned NOT NULL DEFAULT '0' COMMENT 'Serialization method - a non-zero value indicates a multi-valued field.',
  `filter` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Stores Contact Get API params contact reference custom fields. May be used for other filters in the future.',
  `in_selector` tinyint NOT NULL DEFAULT '0' COMMENT 'Should the multi-record custom field values be displayed in tab table listing',
  `fk_entity` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Name of entity being referenced.',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_label_custom_group_id` (`label`,`custom_group_id`),
  UNIQUE KEY `UI_name_custom_group_id` (`name`,`custom_group_id`),
  KEY `FK_civicrm_custom_field_custom_group_id` (`custom_group_id`),
  KEY `FK_civicrm_custom_field_option_group_id` (`option_group_id`),
  CONSTRAINT `FK_civicrm_custom_field_custom_group_id` FOREIGN KEY (`custom_group_id`) REFERENCES `civicrm_custom_group` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_custom_field_option_group_id` FOREIGN KEY (`option_group_id`) REFERENCES `civicrm_option_group` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_custom_field`
--


--
-- Table structure for table `civicrm_custom_group`
--

CREATE TABLE `civicrm_custom_group` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Custom Group ID',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Variable name/programmatic handle for this group.',
  `title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Friendly Name.',
  `extends` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Contact' COMMENT 'Type of object this group extends (can add other options later e.g. contact_address, etc.).',
  `extends_entity_column_id` int unsigned DEFAULT NULL COMMENT 'FK to civicrm_option_value.value (for option group custom_data_type)',
  `extends_entity_column_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'linking custom group for dynamic object',
  `style` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Visual relationship between this form and its parent.',
  `collapse_display` tinyint NOT NULL DEFAULT '0' COMMENT 'Will this group be in collapsed or expanded mode on initial display ?',
  `help_pre` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Description and/or help text to display before fields in form.',
  `help_post` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Description and/or help text to display after fields in form.',
  `weight` int NOT NULL DEFAULT '1' COMMENT 'Controls display order when multiple extended property groups are setup for the same class.',
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT 'Is this property active?',
  `table_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Name of the table that holds the values for this group.',
  `is_multiple` tinyint NOT NULL DEFAULT '0' COMMENT 'Does this group hold multiple values?',
  `min_multiple` int unsigned DEFAULT NULL COMMENT 'minimum number of multiple records (typically 0?)',
  `max_multiple` int unsigned DEFAULT NULL COMMENT 'maximum number of multiple records, if 0 - no max',
  `collapse_adv_display` tinyint NOT NULL DEFAULT '0' COMMENT 'Will this group be in collapsed or expanded mode on advanced search display ?',
  `created_id` int unsigned DEFAULT NULL COMMENT 'FK to civicrm_contact, who created this custom group',
  `created_date` datetime DEFAULT NULL COMMENT 'Date and time this custom group was created.',
  `is_reserved` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this a reserved Custom Group?',
  `is_public` tinyint NOT NULL DEFAULT '1' COMMENT 'Is this property public?',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'crm-i icon class',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_title_extends` (`title`,`extends`),
  UNIQUE KEY `UI_name` (`name`),
  KEY `FK_civicrm_custom_group_created_id` (`created_id`),
  CONSTRAINT `FK_civicrm_custom_group_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_custom_group`
--


--
-- Table structure for table `civicrm_cxn`
--

CREATE TABLE `civicrm_cxn` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Connection ID',
  `app_guid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Application GUID',
  `app_meta` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Application Metadata (JSON)',
  `cxn_guid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Connection GUID',
  `secret` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Shared secret',
  `perm` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Permissions approved for the service (JSON)',
  `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Options for the service (JSON)',
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT 'Is connection currently enabled?',
  `created_date` timestamp NULL DEFAULT NULL COMMENT 'When was the connection was created.',
  `modified_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'When the connection was created or modified.',
  `fetched_date` timestamp NULL DEFAULT NULL COMMENT 'The last time the application metadata was fetched.',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_appid` (`app_guid`),
  UNIQUE KEY `UI_keypair_cxnid` (`cxn_guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_cxn`
--


--
-- Table structure for table `civicrm_dashboard`
--

CREATE TABLE `civicrm_dashboard` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `domain_id` int unsigned NOT NULL COMMENT 'Domain for dashboard',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Internal name of dashlet.',
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'dashlet title',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'url in case of external dashlet',
  `permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Permission for the dashlet',
  `permission_operator` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Permission Operator',
  `fullscreen_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'fullscreen url for dashlet',
  `is_active` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this dashlet active?',
  `is_reserved` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this dashlet reserved?',
  `cache_minutes` int unsigned NOT NULL DEFAULT '60' COMMENT 'Number of minutes to cache dashlet content in browser localStorage.',
  `directive` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Element name of angular directive to invoke (lowercase hyphenated format)',
  PRIMARY KEY (`id`),
  KEY `FK_civicrm_dashboard_domain_id` (`domain_id`),
  CONSTRAINT `FK_civicrm_dashboard_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_dashboard`
--

INSERT INTO `civicrm_dashboard` VALUES (1,1,'blog','CiviCRM News','civicrm/dashlet/blog?reset=1','access CiviCRM',NULL,'civicrm/dashlet/blog?reset=1&context=dashletFullscreen',1,1,1440,NULL),(2,1,'getting-started','CiviCRM Resources','civicrm/dashlet/getting-started?reset=1','access CiviCRM',NULL,'civicrm/dashlet/getting-started?reset=1&context=dashletFullscreen',1,1,7200,NULL),(3,1,'activity','Activities','civicrm/dashlet/activity?reset=1','access CiviCRM',NULL,'civicrm/dashlet/activity?reset=1&context=dashletFullscreen',1,1,7200,NULL),(4,1,'myCases','My Cases','civicrm/dashlet/myCases?reset=1','access my cases and activities',NULL,'civicrm/dashlet/myCases?reset=1&context=dashletFullscreen',1,1,60,NULL),(5,1,'allCases','All Cases','civicrm/dashlet/allCases?reset=1','access all cases and activities',NULL,'civicrm/dashlet/allCases?reset=1&context=dashletFullscreen',1,1,60,NULL),(6,1,'casedashboard','Case Dashboard Dashlet','civicrm/dashlet/casedashboard?reset=1','access my cases and activities,access all cases and activities','OR','civicrm/dashlet/casedashboard?reset=1&context=dashletFullscreen',1,1,60,NULL);

--
-- Table structure for table `civicrm_dashboard_contact`
--

CREATE TABLE `civicrm_dashboard_contact` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `dashboard_id` int unsigned NOT NULL COMMENT 'Dashboard ID',
  `contact_id` int unsigned NOT NULL COMMENT 'Contact ID',
  `column_no` int DEFAULT '0' COMMENT 'column no for this widget',
  `is_active` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this widget active?',
  `weight` int DEFAULT '0' COMMENT 'Ordering of the widgets.',
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_dashboard_id_contact_id` (`dashboard_id`,`contact_id`),
  KEY `FK_civicrm_dashboard_contact_contact_id` (`contact_id`),
  CONSTRAINT `FK_civicrm_dashboard_contact_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_dashboard_contact_dashboard_id` FOREIGN KEY (`dashboard_id`) REFERENCES `civicrm_dashboard` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_dashboard_contact`
--

INSERT INTO `civicrm_dashboard_contact` VALUES (1,1,2,1,1,0),(2,2,2,0,1,0);

--
-- Table structure for table `civicrm_dedupe_exception`
--

CREATE TABLE `civicrm_dedupe_exception` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique dedupe exception id',
  `contact_id1` int unsigned NOT NULL COMMENT 'FK to Contact ID',
  `contact_id2` int unsigned NOT NULL COMMENT 'FK to Contact ID',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_contact_id1_contact_id2` (`contact_id1`,`contact_id2`),
  KEY `FK_civicrm_dedupe_exception_contact_id2` (`contact_id2`),
  CONSTRAINT `FK_civicrm_dedupe_exception_contact_id1` FOREIGN KEY (`contact_id1`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_dedupe_exception_contact_id2` FOREIGN KEY (`contact_id2`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_dedupe_exception`
--


--
-- Table structure for table `civicrm_dedupe_rule`
--

CREATE TABLE `civicrm_dedupe_rule` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique dedupe rule id',
  `dedupe_rule_group_id` int unsigned NOT NULL COMMENT 'The id of the rule group this rule belongs to',
  `rule_table` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The name of the table this rule is about',
  `rule_field` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The name of the field of the table referenced in rule_table',
  `rule_length` int unsigned DEFAULT NULL COMMENT 'The length of the matching substring',
  `rule_weight` int NOT NULL COMMENT 'The weight of the rule',
  PRIMARY KEY (`id`),
  KEY `FK_civicrm_dedupe_rule_dedupe_rule_group_id` (`dedupe_rule_group_id`),
  CONSTRAINT `FK_civicrm_dedupe_rule_dedupe_rule_group_id` FOREIGN KEY (`dedupe_rule_group_id`) REFERENCES `civicrm_dedupe_rule_group` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_dedupe_rule`
--

INSERT INTO `civicrm_dedupe_rule` VALUES (1,1,'civicrm_contact','first_name',NULL,5),(2,1,'civicrm_contact','last_name',NULL,7),(3,1,'civicrm_email','email',NULL,10),(4,2,'civicrm_contact','organization_name',NULL,10),(5,2,'civicrm_email','email',NULL,10),(6,3,'civicrm_contact','household_name',NULL,10),(7,3,'civicrm_email','email',NULL,10),(8,4,'civicrm_email','email',NULL,10),(9,5,'civicrm_contact','organization_name',NULL,10),(10,5,'civicrm_email','email',NULL,10),(11,6,'civicrm_contact','household_name',NULL,10),(12,6,'civicrm_email','email',NULL,10),(13,7,'civicrm_contact','first_name',NULL,5),(14,7,'civicrm_contact','last_name',NULL,5),(15,7,'civicrm_address','street_address',NULL,5),(16,7,'civicrm_contact','middle_name',NULL,1),(17,7,'civicrm_contact','suffix_id',NULL,1);

--
-- Table structure for table `civicrm_dedupe_rule_group`
--

CREATE TABLE `civicrm_dedupe_rule_group` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique dedupe rule group id',
  `contact_type` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'The type of contacts this group applies to',
  `threshold` int NOT NULL COMMENT 'The weight threshold the sum of the rule weights has to cross to consider two contacts the same',
  `used` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Whether the rule should be used for cases where usage is Unsupervised, Supervised OR General(programatically)',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Unique name of rule group',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Label of the rule group',
  `is_reserved` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this a reserved rule - a rule group that has been optimized and cannot be changed by the admin',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_dedupe_rule_group`
--

INSERT INTO `civicrm_dedupe_rule_group` VALUES (1,'Individual',20,'Supervised','IndividualSupervised','Name and Email (reserved)',1),(2,'Organization',10,'Supervised','OrganizationSupervised','Name or Email',0),(3,'Household',10,'Supervised','HouseholdSupervised','Name or Email',0),(4,'Individual',10,'Unsupervised','IndividualUnsupervised','Email (reserved)',1),(5,'Organization',10,'Unsupervised','OrganizationUnsupervised','Name or Email',0),(6,'Household',10,'Unsupervised','HouseholdUnsupervised','Name or Email',0),(7,'Individual',15,'General','IndividualGeneral','Name and Address (reserved)',1);

--
-- Table structure for table `civicrm_discount`
--

CREATE TABLE `civicrm_discount` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key',
  `entity_table` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'physical tablename for entity being joined to discount, e.g. civicrm_event',
  `entity_id` int unsigned NOT NULL COMMENT 'FK to entity table specified in entity_table column.',
  `price_set_id` int unsigned NOT NULL COMMENT 'FK to civicrm_price_set',
  `start_date` date DEFAULT NULL COMMENT 'Date when discount starts.',
  `end_date` date DEFAULT NULL COMMENT 'Date when discount ends.',
  PRIMARY KEY (`id`),
  KEY `index_entity` (`entity_table`,`entity_id`),
  KEY `index_entity_option_id` (`entity_table`,`entity_id`,`price_set_id`),
  KEY `FK_civicrm_discount_price_set_id` (`price_set_id`),
  CONSTRAINT `FK_civicrm_discount_price_set_id` FOREIGN KEY (`price_set_id`) REFERENCES `civicrm_price_set` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_discount`
--


--
-- Table structure for table `civicrm_domain`
--

CREATE TABLE `civicrm_domain` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Domain ID',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Name of Domain / Organization',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Description of Domain.',
  `version` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'The civicrm version this instance is running',
  `contact_id` int unsigned DEFAULT NULL COMMENT 'FK to Contact ID. This is specifically not an FK to avoid circular constraints',
  `locales` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'list of locales supported by the current db state (NULL for single-lang install)',
  `locale_custom_strings` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Locale specific string overrides',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_name` (`name`),
  KEY `FK_civicrm_domain_contact_id` (`contact_id`),
  CONSTRAINT `FK_civicrm_domain_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_domain`
--

INSERT INTO `civicrm_domain` VALUES (1,'Default Domain Name',NULL,'5.69.4',1,NULL,'a:1:{s:5:\"en_US\";a:0:{}}');

--
-- Table structure for table `civicrm_email`
--

CREATE TABLE `civicrm_email` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Email ID',
  `contact_id` int unsigned DEFAULT NULL COMMENT 'FK to Contact ID',
  `location_type_id` int unsigned DEFAULT NULL COMMENT 'Which Location does this email belong to.',
  `email` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Email address',
  `is_primary` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this the primary email address',
  `is_billing` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this the billing?',
  `on_hold` int unsigned NOT NULL DEFAULT '0' COMMENT 'Implicit FK to civicrm_option_value where option_group = email_on_hold.',
  `is_bulkmail` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this address for bulk mail ?',
  `hold_date` datetime DEFAULT NULL COMMENT 'When the address went on bounce hold',
  `reset_date` datetime DEFAULT NULL COMMENT 'When the address bounce status was last reset',
  `signature_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Text formatted signature for the email.',
  `signature_html` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'HTML formatted signature for the email.',
  PRIMARY KEY (`id`),
  KEY `index_location_type` (`location_type_id`),
  KEY `UI_email` (`email`),
  KEY `index_is_primary` (`is_primary`),
  KEY `index_is_billing` (`is_billing`),
  KEY `FK_civicrm_email_contact_id` (`contact_id`),
  CONSTRAINT `FK_civicrm_email_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_email`
--

INSERT INTO `civicrm_email` VALUES (1,1,1,'fixme.domainemail@example.org',1,0,0,0,NULL,NULL,NULL,NULL),(2,2,1,'admin@test.com',1,0,0,0,NULL,NULL,NULL,NULL);

--
-- Table structure for table `civicrm_entity_batch`
--

CREATE TABLE `civicrm_entity_batch` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key',
  `entity_table` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'physical tablename for entity being joined to file, e.g. civicrm_contact',
  `entity_id` int unsigned NOT NULL COMMENT 'FK to entity table specified in entity_table column.',
  `batch_id` int unsigned NOT NULL COMMENT 'FK to civicrm_batch',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_batch_entity` (`batch_id`,`entity_id`,`entity_table`),
  KEY `index_entity` (`entity_table`,`entity_id`),
  CONSTRAINT `FK_civicrm_entity_batch_batch_id` FOREIGN KEY (`batch_id`) REFERENCES `civicrm_batch` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_entity_batch`
--


--
-- Table structure for table `civicrm_entity_file`
--

CREATE TABLE `civicrm_entity_file` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key',
  `entity_table` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'physical tablename for entity being joined to file, e.g. civicrm_contact',
  `entity_id` int unsigned NOT NULL COMMENT 'FK to entity table specified in entity_table column.',
  `file_id` int unsigned NOT NULL COMMENT 'FK to civicrm_file',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_entity_id_entity_table_file_id` (`entity_id`,`entity_table`,`file_id`),
  KEY `FK_civicrm_entity_file_file_id` (`file_id`),
  CONSTRAINT `FK_civicrm_entity_file_file_id` FOREIGN KEY (`file_id`) REFERENCES `civicrm_file` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_entity_file`
--


--
-- Table structure for table `civicrm_entity_financial_account`
--

CREATE TABLE `civicrm_entity_financial_account` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `entity_table` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Links to an entity_table like civicrm_financial_type',
  `entity_id` int unsigned NOT NULL COMMENT 'Links to an id in the entity_table, such as vid in civicrm_financial_type',
  `account_relationship` int unsigned NOT NULL COMMENT 'FK to a new civicrm_option_value (account_relationship)',
  `financial_account_id` int unsigned NOT NULL COMMENT 'FK to the financial_account_id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_entity_id_entity_table_account_relationship` (`entity_id`,`entity_table`,`account_relationship`),
  KEY `FK_civicrm_entity_financial_account_financial_account_id` (`financial_account_id`),
  CONSTRAINT `FK_civicrm_entity_financial_account_financial_account_id` FOREIGN KEY (`financial_account_id`) REFERENCES `civicrm_financial_account` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_entity_financial_account`
--

INSERT INTO `civicrm_entity_financial_account` VALUES (1,'civicrm_financial_type',1,1,1),(2,'civicrm_financial_type',1,5,5),(3,'civicrm_financial_type',1,3,7),(4,'civicrm_financial_type',1,7,9),(5,'civicrm_financial_type',2,1,2),(6,'civicrm_financial_type',2,5,5),(7,'civicrm_financial_type',2,3,7),(8,'civicrm_financial_type',2,7,9),(9,'civicrm_financial_type',2,12,14),(10,'civicrm_financial_type',3,1,3),(11,'civicrm_financial_type',3,5,5),(12,'civicrm_financial_type',3,3,7),(13,'civicrm_financial_type',3,7,9),(14,'civicrm_financial_type',4,5,5),(15,'civicrm_financial_type',4,3,7),(16,'civicrm_financial_type',4,1,4),(17,'civicrm_financial_type',4,12,13),(18,'civicrm_financial_type',4,7,9),(19,'civicrm_option_value',92,6,6),(20,'civicrm_option_value',93,6,6),(21,'civicrm_option_value',94,6,6),(22,'civicrm_option_value',90,6,12),(23,'civicrm_option_value',91,6,12);

--
-- Table structure for table `civicrm_entity_financial_trxn`
--

CREATE TABLE `civicrm_entity_financial_trxn` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `entity_table` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'May contain civicrm_financial_item, civicrm_contribution, civicrm_financial_trxn, civicrm_grant, etc',
  `entity_id` int unsigned NOT NULL,
  `financial_trxn_id` int unsigned DEFAULT NULL,
  `amount` decimal(20,2) NOT NULL COMMENT 'allocated amount of transaction to this entity',
  PRIMARY KEY (`id`),
  KEY `UI_entity_financial_trxn_entity_table` (`entity_table`),
  KEY `UI_entity_financial_trxn_entity_id` (`entity_id`),
  KEY `FK_civicrm_entity_financial_trxn_financial_trxn_id` (`financial_trxn_id`),
  CONSTRAINT `FK_civicrm_entity_financial_trxn_financial_trxn_id` FOREIGN KEY (`financial_trxn_id`) REFERENCES `civicrm_financial_trxn` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_entity_financial_trxn`
--


--
-- Table structure for table `civicrm_entity_tag`
--

CREATE TABLE `civicrm_entity_tag` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key',
  `entity_table` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'physical tablename for entity being joined to file, e.g. civicrm_contact',
  `entity_id` int unsigned NOT NULL COMMENT 'FK to entity table specified in entity_table column.',
  `tag_id` int unsigned NOT NULL COMMENT 'FK to civicrm_tag',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_entity_id_entity_table_tag_id` (`entity_id`,`entity_table`,`tag_id`),
  KEY `FK_civicrm_entity_tag_tag_id` (`tag_id`),
  CONSTRAINT `FK_civicrm_entity_tag_tag_id` FOREIGN KEY (`tag_id`) REFERENCES `civicrm_tag` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_entity_tag`
--


--
-- Table structure for table `civicrm_event`
--

CREATE TABLE `civicrm_event` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Event',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Event Title (e.g. Fall Fundraiser Dinner)',
  `summary` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Brief summary of event. Text and html allowed. Displayed on Event Registration form and can be used on other CMS pages which need an event summary.',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Full description of event. Text and html allowed. Displayed on built-in Event Information screens.',
  `event_type_id` int unsigned DEFAULT '0' COMMENT 'Event Type ID.Implicit FK to civicrm_option_value where option_group = event_type.',
  `participant_listing_id` int unsigned DEFAULT NULL COMMENT 'Should we expose the participant list? Implicit FK to civicrm_option_value where option_group = participant_listing.',
  `is_public` tinyint NOT NULL DEFAULT '1' COMMENT 'Public events will be included in the iCal feeds. Access to private event information may be limited using ACLs.',
  `start_date` datetime DEFAULT NULL COMMENT 'Date and time that event starts.',
  `end_date` datetime DEFAULT NULL COMMENT 'Date and time that event ends. May be NULL if no defined end date/time',
  `is_online_registration` tinyint NOT NULL DEFAULT '0' COMMENT 'If true, include registration link on Event Info page.',
  `registration_link_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Text for link to Event Registration form which is displayed on Event Information screen when is_online_registration is true.',
  `registration_start_date` datetime DEFAULT NULL COMMENT 'Date and time that online registration starts.',
  `registration_end_date` datetime DEFAULT NULL COMMENT 'Date and time that online registration ends.',
  `max_participants` int unsigned DEFAULT NULL COMMENT 'Maximum number of registered participants to allow. After max is reached, a custom Event Full message is displayed. If NULL, allow unlimited number of participants.',
  `event_full_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Message to display on Event Information page and INSTEAD OF Event Registration form if maximum participants are signed up. Can include email address/info about getting on a waiting list, etc. Text and html allowed.',
  `is_monetary` tinyint NOT NULL DEFAULT '0' COMMENT 'If true, one or more fee amounts must be set and a Payment Processor must be configured for Online Event Registration.',
  `financial_type_id` int unsigned DEFAULT NULL COMMENT 'Financial type assigned to paid event registrations for this event. Required if is_monetary is true.',
  `payment_processor` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Payment Processors configured for this Event (if is_monetary is true)',
  `is_map` tinyint NOT NULL DEFAULT '0' COMMENT 'Include a map block on the Event Information page when geocode info is available and a mapping provider has been specified?',
  `is_active` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this Event enabled or disabled/cancelled?',
  `fee_label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_show_location` tinyint NOT NULL DEFAULT '1' COMMENT 'If true, show event location.',
  `loc_block_id` int unsigned DEFAULT NULL COMMENT 'FK to Location Block ID',
  `default_role_id` int unsigned DEFAULT '1' COMMENT 'Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.',
  `intro_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.',
  `footer_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.',
  `confirm_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Title for Confirmation page.',
  `confirm_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.',
  `confirm_footer_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.',
  `is_email_confirm` tinyint NOT NULL DEFAULT '0' COMMENT 'If true, confirmation is automatically emailed to contact on successful registration.',
  `confirm_email_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'text to include above standard event info on confirmation email. emails are text-only, so do not allow html for now',
  `confirm_from_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'FROM email name used for confirmation emails.',
  `confirm_from_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'FROM email address used for confirmation emails.',
  `cc_confirm` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'comma-separated list of email addresses to cc each time a confirmation is sent',
  `bcc_confirm` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'comma-separated list of email addresses to bcc each time a confirmation is sent',
  `default_fee_id` int unsigned DEFAULT NULL COMMENT 'FK to civicrm_option_value.',
  `default_discount_fee_id` int unsigned DEFAULT NULL COMMENT 'FK to civicrm_option_value.',
  `thankyou_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Title for ThankYou page.',
  `thankyou_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'ThankYou Text.',
  `thankyou_footer_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Footer message.',
  `is_pay_later` tinyint NOT NULL DEFAULT '0' COMMENT 'if true - allows the user to send payment directly to the org later',
  `pay_later_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'The text displayed to the user in the main form',
  `pay_later_receipt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'The receipt sent to the user instead of the normal receipt text',
  `is_partial_payment` tinyint NOT NULL DEFAULT '0' COMMENT 'is partial payment enabled for this event',
  `initial_amount_label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Initial amount label for partial payment',
  `initial_amount_help_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Initial amount help text for partial payment',
  `min_initial_amount` decimal(20,2) DEFAULT NULL COMMENT 'Minimum initial amount for partial payment',
  `is_multiple_registrations` tinyint NOT NULL DEFAULT '0' COMMENT 'if true - allows the user to register multiple participants for event',
  `max_additional_participants` int unsigned DEFAULT '0' COMMENT 'Maximum number of additional participants that can be registered on a single booking',
  `allow_same_participant_emails` tinyint NOT NULL DEFAULT '0' COMMENT 'if true - allows the user to register multiple registrations from same email address.',
  `has_waitlist` tinyint NOT NULL DEFAULT '0' COMMENT 'Whether the event has waitlist support.',
  `requires_approval` tinyint NOT NULL DEFAULT '0' COMMENT 'Whether participants require approval before they can finish registering.',
  `expiration_time` int unsigned DEFAULT NULL COMMENT 'Expire pending but unconfirmed registrations after this many hours.',
  `allow_selfcancelxfer` tinyint NOT NULL DEFAULT '0' COMMENT 'Allow self service cancellation or transfer for event?',
  `selfcancelxfer_time` int DEFAULT '0' COMMENT 'Number of hours prior to event start date to allow self-service cancellation or transfer.',
  `waitlist_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Text to display when the event is full, but participants can signup for a waitlist.',
  `approval_req_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Text to display when the approval is required to complete registration for an event.',
  `is_template` tinyint NOT NULL DEFAULT '0' COMMENT 'whether the event has template',
  `template_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Event Template Title',
  `created_id` int unsigned DEFAULT NULL COMMENT 'FK to civicrm_contact, who created this event',
  `created_date` datetime DEFAULT NULL COMMENT 'Date and time that event was created.',
  `currency` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '3 character string, value from config setting or input via user.',
  `campaign_id` int unsigned DEFAULT NULL COMMENT 'The campaign for which this event has been created.',
  `is_share` tinyint NOT NULL DEFAULT '1' COMMENT 'Can people share the event through social media?',
  `is_confirm_enabled` tinyint NOT NULL DEFAULT '1' COMMENT 'If false, the event booking confirmation screen gets skipped',
  `parent_event_id` int unsigned DEFAULT NULL COMMENT 'Implicit FK to civicrm_event: parent event',
  `slot_label_id` int unsigned DEFAULT NULL COMMENT 'Needs to be moved to Event cart extension. Subevent slot label. Implicit FK to civicrm_option_value where option_group = conference_slot.',
  `dedupe_rule_group_id` int unsigned DEFAULT NULL COMMENT 'Rule to use when matching registrations for this event',
  `is_billing_required` tinyint NOT NULL DEFAULT '0' COMMENT 'if true than billing block is required this event',
  `is_show_calendar_links` tinyint NOT NULL DEFAULT '1' COMMENT 'If true then calendar links are shown for this event.',
  PRIMARY KEY (`id`),
  KEY `index_event_type_id` (`event_type_id`),
  KEY `index_participant_listing_id` (`participant_listing_id`),
  KEY `index_parent_event_id` (`parent_event_id`),
  KEY `FK_civicrm_event_loc_block_id` (`loc_block_id`),
  KEY `FK_civicrm_event_created_id` (`created_id`),
  KEY `FK_civicrm_event_campaign_id` (`campaign_id`),
  KEY `FK_civicrm_event_dedupe_rule_group_id` (`dedupe_rule_group_id`),
  CONSTRAINT `FK_civicrm_event_campaign_id` FOREIGN KEY (`campaign_id`) REFERENCES `civicrm_campaign` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_event_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_event_dedupe_rule_group_id` FOREIGN KEY (`dedupe_rule_group_id`) REFERENCES `civicrm_dedupe_rule_group` (`id`),
  CONSTRAINT `FK_civicrm_event_loc_block_id` FOREIGN KEY (`loc_block_id`) REFERENCES `civicrm_loc_block` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_event`
--

INSERT INTO `civicrm_event` VALUES (1,'Fance Build - Fance build for blue','Lorem Ipsum is simply dummy text of the printing and typesetting industry.','<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum</p>',3,NULL,1,'2024-03-31 23:24:00',NULL,1,'Register Now',NULL,NULL,NULL,'This event is currently full.',0,NULL,NULL,0,1,NULL,1,1,1,NULL,NULL,'Confirm Your Registration Information',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Thank You for Registering',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,0,9,0,0,0,NULL,0,0,NULL,NULL,0,NULL,2,'2024-03-13 11:25:12',NULL,NULL,0,1,NULL,NULL,NULL,0,0),(2,'Fance Build - Christmas Valley Build','Lorem Ipsum is simply dummy text of the printing and typesetting industry.','<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum</p>',6,NULL,1,'2024-06-11 23:30:00',NULL,1,'Register Now',NULL,NULL,NULL,'This event is currently full.',0,NULL,NULL,0,1,NULL,1,2,1,NULL,NULL,'Confirm Your Registration Information',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Thank You for Registering',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,0,9,0,0,0,NULL,0,0,NULL,NULL,0,NULL,2,'2024-03-13 11:30:43',NULL,NULL,0,1,NULL,NULL,NULL,0,0);

--
-- Table structure for table `civicrm_event_carts`
--

CREATE TABLE `civicrm_event_carts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Cart ID',
  `user_id` int unsigned DEFAULT NULL COMMENT 'FK to civicrm_contact who created this cart',
  `completed` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `FK_civicrm_event_carts_user_id` (`user_id`),
  CONSTRAINT `FK_civicrm_event_carts_user_id` FOREIGN KEY (`user_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_event_carts`
--


--
-- Table structure for table `civicrm_events_in_carts`
--

CREATE TABLE `civicrm_events_in_carts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Event In Cart ID',
  `event_id` int unsigned DEFAULT NULL COMMENT 'FK to Event ID',
  `event_cart_id` int unsigned DEFAULT NULL COMMENT 'FK to Event Cart ID',
  PRIMARY KEY (`id`),
  KEY `FK_civicrm_events_in_carts_event_id` (`event_id`),
  KEY `FK_civicrm_events_in_carts_event_cart_id` (`event_cart_id`),
  CONSTRAINT `FK_civicrm_events_in_carts_event_cart_id` FOREIGN KEY (`event_cart_id`) REFERENCES `civicrm_event_carts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_events_in_carts_event_id` FOREIGN KEY (`event_id`) REFERENCES `civicrm_event` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_events_in_carts`
--


--
-- Table structure for table `civicrm_extension`
--

CREATE TABLE `civicrm_extension` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Local Extension ID',
  `type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `full_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Fully qualified extension name',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Short name',
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Short, printable name',
  `file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Primary PHP file',
  `schema_version` varchar(63) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Revision code of the database schema; the format is module-defined',
  `is_active` tinyint DEFAULT '1' COMMENT 'Is this extension active?',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_extension_full_name` (`full_name`),
  KEY `UI_extension_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_extension`
--

INSERT INTO `civicrm_extension` VALUES (1,'module','sequentialcreditnotes','Sequential credit notes','Sequential credit notes','sequentialcreditnotes',NULL,1),(2,'module','greenwich','Theme: Greenwich','Theme: Greenwich','greenwich',NULL,1),(3,'module','financialacls','Financial ACLs','Financial ACLs','financialacls',NULL,1),(4,'module','recaptcha','reCAPTCHA','reCAPTCHA','recaptcha',NULL,1),(5,'module','ckeditor4','CKEditor4','CKEditor4','ckeditor4',NULL,1),(6,'module','org.civicrm.flexmailer','FlexMailer','FlexMailer','flexmailer',NULL,1),(7,'module','civi_campaign','CiviCampaign','CiviCampaign','civi_campaign',NULL,0),(8,'module','civi_case','CiviCase','CiviCase','civi_case',NULL,0),(9,'module','civi_contribute','CiviContribute','CiviContribute','civi_contribute',NULL,1),(10,'module','civi_event','CiviEvent','CiviEvent','civi_event',NULL,1),(11,'module','civi_mail','CiviMail','CiviMail','civi_mail',NULL,1),(12,'module','civi_member','CiviMember','CiviMember','civi_member',NULL,1),(13,'module','civi_pledge','CiviPledge','CiviPledge','civi_pledge',NULL,0),(14,'module','civi_report','CiviReport','CiviReport','civi_report',NULL,1);

--
-- Table structure for table `civicrm_file`
--

CREATE TABLE `civicrm_file` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique ID',
  `file_type_id` int unsigned DEFAULT NULL COMMENT 'Type of file (e.g. Transcript, Income Tax Return, etc). FK to civicrm_option_value.',
  `mime_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'mime type of the document',
  `uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'uri of the file on disk',
  `document` mediumblob COMMENT 'contents of the document',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Additional descriptive text regarding this attachment (optional).',
  `upload_date` datetime DEFAULT NULL COMMENT 'Date and time that this attachment was uploaded or written to server.',
  `created_id` int unsigned DEFAULT NULL COMMENT 'FK to civicrm_contact, who uploaded this file',
  PRIMARY KEY (`id`),
  KEY `FK_civicrm_file_created_id` (`created_id`),
  CONSTRAINT `FK_civicrm_file_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_file`
--


--
-- Table structure for table `civicrm_financial_account`
--

CREATE TABLE `civicrm_financial_account` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Financial Account Name.',
  `contact_id` int unsigned DEFAULT NULL COMMENT 'FK to Contact ID that is responsible for the funds in this account',
  `financial_account_type_id` int unsigned NOT NULL DEFAULT '3' COMMENT 'pseudo FK into civicrm_option_value.',
  `accounting_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Optional value for mapping monies owed and received to accounting system codes.',
  `account_type_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Optional value for mapping account types to accounting system account categories (QuickBooks Account Type Codes for example).',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Financial Type Description.',
  `parent_id` int unsigned DEFAULT NULL COMMENT 'Parent ID in account hierarchy',
  `is_header_account` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this a header account which does not allow transactions to be posted against it directly, but only to its sub-accounts?',
  `is_deductible` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this account tax-deductible?',
  `is_tax` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this account for taxes?',
  `tax_rate` decimal(10,8) DEFAULT NULL COMMENT 'The percentage of the total_amount that is due for this tax.',
  `is_reserved` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this a predefined system object?',
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT 'Is this property active?',
  `is_default` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this account the default one (or default tax one) for its financial_account_type?',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_name` (`name`),
  KEY `FK_civicrm_financial_account_contact_id` (`contact_id`),
  KEY `FK_civicrm_financial_account_parent_id` (`parent_id`),
  CONSTRAINT `FK_civicrm_financial_account_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_financial_account_parent_id` FOREIGN KEY (`parent_id`) REFERENCES `civicrm_financial_account` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_financial_account`
--

INSERT INTO `civicrm_financial_account` VALUES (1,'Donation',1,3,'4200','INC','Default account for donations',NULL,0,1,0,NULL,0,1,1),(2,'Member Dues',1,3,'4400','INC','Default account for membership sales',NULL,0,1,0,NULL,0,1,0),(3,'Campaign Contribution',1,3,'4100','INC','Sample account for recording payments to a campaign',NULL,0,0,0,NULL,0,1,0),(4,'Event Fee',1,3,'4300','INC','Default account for event ticket sales',NULL,0,0,0,NULL,0,1,0),(5,'Banking Fees',1,5,'5200','EXP','Payment processor fees and manually recorded banking fees',NULL,0,0,0,NULL,0,1,1),(6,'Deposit Bank Account',1,1,'1100','BANK','All manually recorded cash and cheques go to this account',NULL,0,0,0,NULL,0,1,1),(7,'Accounts Receivable',1,1,'1200','AR','Amounts to be received later (eg pay later event revenues)',NULL,0,0,0,NULL,0,1,0),(8,'Accounts Payable',1,2,'2200','AP','Amounts to be paid out such as grants and refunds',NULL,0,0,0,NULL,0,1,1),(9,'Premiums',1,4,'5100','COGS','Account to record cost of premiums provided to payors',NULL,0,0,0,NULL,0,1,1),(10,'Premiums inventory',1,1,'1375','OCASSET','Account representing value of premiums inventory',NULL,0,0,0,NULL,0,1,0),(11,'Discounts',1,3,'4900','INC','Contra-revenue account for amounts discounted from sales',NULL,0,0,0,NULL,0,1,0),(12,'Payment Processor Account',1,1,'1150','BANK','Account to record payments into a payment processor merchant account',NULL,0,0,0,NULL,0,1,0),(13,'Deferred Revenue - Event Fee',1,2,'2730','OCLIAB','Event revenue to be recognized in future months when the events occur',NULL,0,0,0,NULL,0,1,0),(14,'Deferred Revenue - Member Dues',1,2,'2740','OCLIAB','Membership revenue to be recognized in future months',NULL,0,0,0,NULL,0,1,0);

--
-- Table structure for table `civicrm_financial_item`
--

CREATE TABLE `civicrm_financial_item` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Date and time the item was created',
  `transaction_date` datetime NOT NULL COMMENT 'Date and time of the source transaction',
  `contact_id` int unsigned NOT NULL COMMENT 'FK to Contact ID of contact the item is from',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Human readable description of this item, to ease display without lookup of source item.',
  `amount` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Total amount of this item',
  `currency` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Currency for the amount',
  `financial_account_id` int unsigned DEFAULT NULL COMMENT 'FK to civicrm_financial_account',
  `status_id` int unsigned DEFAULT NULL COMMENT 'Payment status: test, paid, part_paid, unpaid (if empty assume unpaid)',
  `entity_table` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'May contain civicrm_line_item, civicrm_financial_trxn etc',
  `entity_id` int unsigned DEFAULT NULL COMMENT 'The specific source item that is responsible for the creation of this financial_item',
  PRIMARY KEY (`id`),
  KEY `IX_created_date` (`created_date`),
  KEY `IX_transaction_date` (`transaction_date`),
  KEY `index_entity_id_entity_table` (`entity_id`,`entity_table`),
  KEY `FK_civicrm_financial_item_contact_id` (`contact_id`),
  KEY `FK_civicrm_financial_item_financial_account_id` (`financial_account_id`),
  CONSTRAINT `FK_civicrm_financial_item_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_financial_item_financial_account_id` FOREIGN KEY (`financial_account_id`) REFERENCES `civicrm_financial_account` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_financial_item`
--


--
-- Table structure for table `civicrm_financial_trxn`
--

CREATE TABLE `civicrm_financial_trxn` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `from_financial_account_id` int unsigned DEFAULT NULL COMMENT 'FK to financial_account table.',
  `to_financial_account_id` int unsigned DEFAULT NULL COMMENT 'FK to financial_financial_account table.',
  `trxn_date` datetime DEFAULT NULL COMMENT 'date transaction occurred',
  `total_amount` decimal(20,2) NOT NULL COMMENT 'amount of transaction',
  `fee_amount` decimal(20,2) DEFAULT NULL COMMENT 'actual processor fee if known - may be 0.',
  `net_amount` decimal(20,2) DEFAULT NULL COMMENT 'actual funds transfer amount. total less fees. if processor does not report actual fee during transaction, this is set to total_amount.',
  `currency` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '3 character string, value from config setting or input via user.',
  `is_payment` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this entry either a payment or a reversal of a payment?',
  `trxn_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Transaction id supplied by external processor. This may not be unique.',
  `trxn_result_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'processor result code',
  `status_id` int unsigned DEFAULT NULL COMMENT 'pseudo FK to civicrm_option_value of contribution_status_id option_group',
  `payment_processor_id` int unsigned DEFAULT NULL COMMENT 'Payment Processor for this financial transaction',
  `payment_instrument_id` int unsigned DEFAULT NULL COMMENT 'FK to payment_instrument option group values',
  `card_type_id` int unsigned DEFAULT NULL COMMENT 'FK to accept_creditcard option group values',
  `check_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Check number',
  `pan_truncation` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Last 4 digits of credit card',
  `order_reference` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Payment Processor external order reference',
  PRIMARY KEY (`id`),
  KEY `UI_ftrxn_trxn_id` (`trxn_id`),
  KEY `UI_ftrxn_payment_instrument_id` (`payment_instrument_id`),
  KEY `UI_ftrxn_check_number` (`check_number`),
  KEY `FK_civicrm_financial_trxn_from_financial_account_id` (`from_financial_account_id`),
  KEY `FK_civicrm_financial_trxn_to_financial_account_id` (`to_financial_account_id`),
  KEY `FK_civicrm_financial_trxn_payment_processor_id` (`payment_processor_id`),
  CONSTRAINT `FK_civicrm_financial_trxn_from_financial_account_id` FOREIGN KEY (`from_financial_account_id`) REFERENCES `civicrm_financial_account` (`id`),
  CONSTRAINT `FK_civicrm_financial_trxn_payment_processor_id` FOREIGN KEY (`payment_processor_id`) REFERENCES `civicrm_payment_processor` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_financial_trxn_to_financial_account_id` FOREIGN KEY (`to_financial_account_id`) REFERENCES `civicrm_financial_account` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_financial_trxn`
--


--
-- Table structure for table `civicrm_financial_type`
--

CREATE TABLE `civicrm_financial_type` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID of original financial_type so you can search this table by the financial_type.id and then select the relevant version based on the timestamp',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Financial Type Name.',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Financial Type Description.',
  `is_deductible` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this financial type tax-deductible? If true, contributions of this type may be fully OR partially deductible - non-deductible amount is stored in the Contribution record.',
  `is_reserved` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this a predefined system object?',
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT 'Is this property active?',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_financial_type`
--

INSERT INTO `civicrm_financial_type` VALUES (1,'Donation',NULL,1,0,1),(2,'Member Dues',NULL,1,0,1),(3,'Campaign Contribution',NULL,0,0,1),(4,'Event Fee',NULL,0,0,1);

--
-- Table structure for table `civicrm_group`
--

CREATE TABLE `civicrm_group` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Group ID',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Internal name of Group.',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name of Group.',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Optional verbose description of the group.',
  `source` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Module or process which created this group.',
  `saved_search_id` int unsigned DEFAULT NULL COMMENT 'FK to saved search table.',
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT 'Is this group active?',
  `visibility` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'User and User Admin Only' COMMENT 'In what context(s) is this field visible.',
  `where_clause` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'the sql where clause if a saved search acl',
  `select_tables` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'the tables to be included in a select data',
  `where_tables` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'the tables to be included in the count statement',
  `group_type` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'FK to group type',
  `cache_date` timestamp NULL DEFAULT NULL COMMENT 'Date when we created the cache for a smart group',
  `cache_fill_took` double DEFAULT NULL COMMENT 'Seconds taken to fill smart group cache',
  `refresh_date` timestamp NULL DEFAULT NULL COMMENT 'Unused deprecated column.',
  `parents` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'List of parent groups',
  `children` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'List of child groups (calculated)',
  `is_hidden` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this group hidden?',
  `is_reserved` tinyint NOT NULL DEFAULT '0',
  `created_id` int unsigned DEFAULT NULL COMMENT 'FK to contact table.',
  `modified_id` int unsigned DEFAULT NULL COMMENT 'FK to contact table.',
  `frontend_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Alternative public title for this Group.',
  `frontend_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Alternative public description of the group.',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_title` (`title`),
  UNIQUE KEY `UI_name` (`name`),
  KEY `UI_cache_date` (`cache_date`),
  KEY `index_group_type` (`group_type`),
  KEY `FK_civicrm_group_saved_search_id` (`saved_search_id`),
  KEY `FK_civicrm_group_created_id` (`created_id`),
  KEY `FK_civicrm_group_modified_id` (`modified_id`),
  CONSTRAINT `FK_civicrm_group_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_group_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_group_saved_search_id` FOREIGN KEY (`saved_search_id`) REFERENCES `civicrm_saved_search` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_group`
--

INSERT INTO `civicrm_group` VALUES (1,'Administrators','Administrators','Contacts in this group are assigned Administrator role permissions.',NULL,NULL,1,'User and User Admin Only',NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,'Administrators','');

--
-- Table structure for table `civicrm_group_contact`
--

CREATE TABLE `civicrm_group_contact` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key',
  `group_id` int unsigned NOT NULL COMMENT 'FK to civicrm_group',
  `contact_id` int unsigned NOT NULL COMMENT 'FK to civicrm_contact',
  `status` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'status of contact relative to membership in group',
  `location_id` int unsigned DEFAULT NULL COMMENT 'Optional location to associate with this membership',
  `email_id` int unsigned DEFAULT NULL COMMENT 'Optional email to associate with this membership',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_contact_group` (`contact_id`,`group_id`),
  KEY `FK_civicrm_group_contact_group_id` (`group_id`),
  KEY `FK_civicrm_group_contact_location_id` (`location_id`),
  KEY `FK_civicrm_group_contact_email_id` (`email_id`),
  CONSTRAINT `FK_civicrm_group_contact_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_group_contact_email_id` FOREIGN KEY (`email_id`) REFERENCES `civicrm_email` (`id`),
  CONSTRAINT `FK_civicrm_group_contact_group_id` FOREIGN KEY (`group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_group_contact_location_id` FOREIGN KEY (`location_id`) REFERENCES `civicrm_loc_block` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_group_contact`
--


--
-- Table structure for table `civicrm_group_contact_cache`
--

CREATE TABLE `civicrm_group_contact_cache` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key',
  `group_id` int unsigned NOT NULL COMMENT 'FK to civicrm_group',
  `contact_id` int unsigned NOT NULL COMMENT 'FK to civicrm_contact',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_contact_group` (`contact_id`,`group_id`),
  KEY `FK_civicrm_group_contact_cache_group_id` (`group_id`),
  CONSTRAINT `FK_civicrm_group_contact_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_group_contact_cache_group_id` FOREIGN KEY (`group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_group_contact_cache`
--


--
-- Table structure for table `civicrm_group_nesting`
--

CREATE TABLE `civicrm_group_nesting` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Relationship ID',
  `child_group_id` int unsigned NOT NULL COMMENT 'ID of the child group',
  `parent_group_id` int unsigned NOT NULL COMMENT 'ID of the parent group',
  PRIMARY KEY (`id`),
  KEY `FK_civicrm_group_nesting_child_group_id` (`child_group_id`),
  KEY `FK_civicrm_group_nesting_parent_group_id` (`parent_group_id`),
  CONSTRAINT `FK_civicrm_group_nesting_child_group_id` FOREIGN KEY (`child_group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_group_nesting_parent_group_id` FOREIGN KEY (`parent_group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_group_nesting`
--


--
-- Table structure for table `civicrm_group_organization`
--

CREATE TABLE `civicrm_group_organization` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Relationship ID',
  `group_id` int unsigned NOT NULL COMMENT 'ID of the group',
  `organization_id` int unsigned NOT NULL COMMENT 'ID of the Organization Contact',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_group_organization` (`group_id`,`organization_id`),
  KEY `FK_civicrm_group_organization_organization_id` (`organization_id`),
  CONSTRAINT `FK_civicrm_group_organization_group_id` FOREIGN KEY (`group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_group_organization_organization_id` FOREIGN KEY (`organization_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_group_organization`
--


--
-- Table structure for table `civicrm_im`
--

CREATE TABLE `civicrm_im` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique IM ID',
  `contact_id` int unsigned DEFAULT NULL COMMENT 'FK to Contact ID',
  `location_type_id` int unsigned DEFAULT NULL COMMENT 'Which Location does this email belong to.',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'IM screen name',
  `provider_id` int unsigned DEFAULT NULL COMMENT 'Which IM Provider does this screen name belong to.',
  `is_primary` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this the primary IM for this contact and location.',
  `is_billing` tinyint NOT NULL DEFAULT '0' COMMENT 'Is this the billing?',
  PRIMARY KEY (`id`),
  KEY `index_location_type` (`location_type_id`),
  KEY `UI_provider_id` (`provider_id`),
  KEY `index_is_primary` (`is_primary`),
  KEY `index_is_billing` (`is_billing`),
  KEY `FK_civicrm_im_contact_id` (`contact_id`),
  CONSTRAINT `FK_civicrm_im_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_im`
--


--
-- Table structure for table `civicrm_install_canary`
--

CREATE TABLE `civicrm_install_canary` (
  `id` int unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `civicrm_install_canary`
--


--
-- Table structure for table `civicrm_job`
--

CREATE TABLE `civicrm_job` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Job ID',
  `domain_id` int unsigned NOT NULL COMMENT 'Which Domain is this scheduled job for',
  `run_frequency` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Daily' COMMENT 'Scheduled job run frequency.',
  `last_run` timestamp NULL DEFAULT NULL COMMENT 'When was this cron entry last run',
  `scheduled_run_date` timestamp NULL DEFAULT NULL COMMENT 'When is this cron entry scheduled to run',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Title of the job',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Description of the job',
  `api_entity` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Entity of the job api call',
  `api_action` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Action of the job api call',
  `parameters` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'List of parameters to the command.',
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT 'Is this job active?',
  PRIMARY KEY (`id`),
  KEY `FK_civicrm_job_domain_id` (`domain_id`),
  CONSTRAINT `FK_civicrm_job_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_job`
--

INSERT INTO `civicrm_job` VALUES (1,1,'Daily',NULL,NULL,'CiviCRM Update Check','Checks for version updates. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_version_check','Job','version_check',NULL,1),(2,1,'Always',NULL,NULL,'Send Scheduled Mailings','Sends out scheduled mailings. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_process_mailing','Job','process_mailing',NULL,0),(3,1,'Hourly',NULL,NULL,'Fetch Bounces','Fetches bounces from mailings. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_fetch_bounces','Job','fetch_bounces','is_create_activities=0',0),(4,1,'Hourly',NULL,NULL,'Process Inbound Emails','Inserts activity for a contact or a case by retrieving inbound emails. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_fetch_activities','Job','fetch_activities',NULL,0),(5,1,'Daily',NULL,NULL,'Process Pledges','Updates pledge records and sends out reminders. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_process_pledge','Job','process_pledge','send_reminders=0',0),(6,1,'Daily',NULL,NULL,'Geocode and Parse Addresses','Geocodes and/or parses street addresses. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_geocode','Job','geocode','geocoding=1\n      parse=0\n      throttle=0',0),(7,1,'Daily',NULL,NULL,'Update Individual Email Greeting','Update Individual Email Greeting. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_update_greeting','Job','update_greeting','ct=Individual\ngt=email_greeting',0),(8,1,'Daily',NULL,NULL,'Update Individual Postal Greeting','Update Individual Postal Greeting. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_update_greeting','Job','update_greeting','ct=Individual\ngt=postal_greeting',0),(9,1,'Daily',NULL,NULL,'Update Individual Addressee','Update Individual Addressee. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_update_greeting','Job','update_greeting','ct=Individual\ngt=addressee',0),(10,1,'Daily',NULL,NULL,'Mail Reports','Generates and sends out reports via email. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_mail_report','Job','mail_report','',0),(11,1,'Hourly',NULL,NULL,'Send Scheduled Reminders','Sends out scheduled reminders via email. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_send_reminder','Job','send_reminder',NULL,0),(12,1,'Always',NULL,NULL,'Update Participant Statuses','Updates pending event participant statuses based on time. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_process_participant','Job','process_participant',NULL,0),(13,1,'Daily',NULL,NULL,'Update Membership Statuses','Updates membership statuses. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_process_membership','Job','process_membership',NULL,0),(14,1,'Always',NULL,NULL,'Process Survey Respondents','Releases reserved survey respondents. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_process_respondent','Job','process_respondent',NULL,0),(15,1,'Monthly',NULL,NULL,'Clean-up Temporary Data and Files','Removes temporary data and files. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_cleanup','Job','cleanup','session=0',0),(16,1,'Always',NULL,NULL,'Send Scheduled SMS','Sends out scheduled SMS. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_process_sms','Job','process_sms',NULL,0),(17,1,'Hourly',NULL,NULL,'Rebuild Smart Group Cache','Rebuilds the smart group cache. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_group_rebuild','Job','group_rebuild','limit=0',0),(18,1,'Hourly',NULL,NULL,'Group Cache Flush','Purges aged smart group cache data. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_group_cache_flush','Job','group_cache_flush','',0),(19,1,'Daily',NULL,NULL,'Disable expired relationships','Disables relationships that have expired. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_disable_expired_relationships','Job','disable_expired_relationships',NULL,0),(20,1,'Daily',NULL,NULL,'Validate Email Address from Mailings.','Updates the reset_date on an email address. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#mailing_update_email_resetdate','Mailing','update_email_resetdate','minDays=5\n      maxDays=60',0),(21,1,'Daily',NULL,NULL,'Dedupe Contacts','Executes the Individual, Unsupervised redupe rule. https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_process_batch_merge','Job','process_batch_merge',NULL,0);

--
-- Table structure for table `civicrm_job_log`
--

CREATE TABLE `civicrm_job_log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Job log entry ID',
  `domain_id` int unsigned NOT NULL COMMENT 'Which Domain is this scheduled job for',
  `run_time` timestamp NULL DEFAULT NULL COMMENT 'Log entry date',
  `job_id` int unsigned DEFAULT NULL COMMENT 'Pointer to job id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Title of the job',
  `command` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Full path to file containing job script',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Title line of log entry',
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Potential extended data for specific job run (e.g. tracebacks).',
  PRIMARY KEY (`id`),
  KEY `FK_civicrm_job_log_domain_id` (`domain_id`),
  KEY `FK_civicrm_job_log_job_id` (`job_id`),
  CONSTRAINT `FK_civicrm_job_log_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`),
  CONSTRAINT `FK_civicrm_job_log_job_id` FOREIGN KEY (`job_id`) REFERENCES `civicrm_job` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `civicrm_job_log`
--


--
-- Table structure for table `civicrm_line_item`
--

CREATE TABLE `civicrm_line_item` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Line Item',
  `entity_table` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'May contain civicrm_contribution, civicrm_participant or civicrm_membership',
  `entity_id` int unsigned NOT NULL COMMENT 'entry in table',
  `contribution_id` int unsigned DEFAULT NULL COMMENT 'FK to civicrm_contribution',
  `price_field_id` int unsigned DEFAULT NULL COMMENT 'FK to civicrm_price_field',
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'descriptive label for item - from price_field_value.label',
  `qty` decimal(20,2) NOT NULL COMMENT 'How many items ordered',
  `unit_price` decimal(20,2) NOT NULL COMMENT 'price of each item',
  `line_total` decimal(20,2) NOT NULL COMMENT 'qty * unit_price',
  `participant_count` int unsigned DEFAULT NULL COMMENT 'Participant count for field',
  `price_field_value_id` int unsigned DEFAULT NULL COMMENT 'FK to civicrm_price_field_value',
  `financial_type_id` int unsigned DEFAULT NULL COMMENT 'FK to Financial Type.',
  `non_deductible_amount` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'Portion of total amount which is NOT tax deductible.',
  `tax_amount` decimal(20,2) NOT NULL DEFAULT '0.00' COMMENT 'tax of each item',
  `membership_num_terms` int unsigned DEFAULT NULL COMMENT 'Number of terms for this membership (only supported in Order->Payment flow). If the field is NULL it means unknown and it will be assumed to be 1 during payment.create if entity_table is civicrm_membership',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_line_item_value` (`entity_id`,`entity_table`,`contribution_id`,`price_field_value_id`,`price_field_id`),
  KEY `FK_civicrm_line_item_contribution_id` (`contribution_id`),
  KEY `FK_civicrm_line_item_price_field_id` (`price_field_id`),
  KEY `FK_civicrm_line_item_price_field_value_id` (`price_field_value_id`),
  KEY `FK_civicrm_line_item_financial_type_id` (`financial_type_id`),
  CONSTRAINT `FK_civicrm_line_item_contribution_id` FOREIGN KEY (`contribution_id`) REFERENCES `civicrm_contribution` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_line_item_financial_type_id` FOREIGN KEY (`financial_type_id`) REFERENCES `civicrm_financial_type` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_line_item_price_field_id` FOREIGN KEY (`price_field_id`) REFERENCES `civicrm_price_field` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_line_item_price_field_value_id` FOREIGN KEY (`price_field_value_id`) REFERENCES `civicrm_price_field_value` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
