INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(6161, 1, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 18220 characters], 4, '', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us/newsletter', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us', '116.75.243.48', 1740603718),
(6162, 1, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 18216 characters], 4, '', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us/newsletter', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us', '116.75.243.48', 1740603718);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(6163, 1, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 18416 characters], 7, '', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us/newsletter', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us', '116.75.243.48', 1740603718),
(6164, 1, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 18416 characters], 7, '', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us/newsletter', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us', '116.75.243.48', 1740603718);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(6165, 1, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 18220 characters], 4, '', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us/newsletter', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us', '116.75.243.48', 1740603718),
(6166, 1, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 18216 characters], 4, '', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us/newsletter', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us', '116.75.243.48', 1740603718);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(6167, 1, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 18416 characters], 7, '', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us/newsletter', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us', '116.75.243.48', 1740603718),
(6168, 1, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 18416 characters], 7, '', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us/newsletter', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us', '116.75.243.48', 1740603718);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(6169, 1, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 18220 characters], 4, '', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us/newsletter', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us', '116.75.243.48', 1740603718),
(6170, 1, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 18216 characters], 4, '', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us/newsletter', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us', '116.75.243.48', 1740603718);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(6171, 1, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 18416 characters], 7, '', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us/newsletter', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us', '116.75.243.48', 1740603718),
(6172, 1, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 18416 characters], 7, '', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us/newsletter', 'https://tkps.yrdsb-schools-new.w3creatives.com/about-us', '116.75.243.48', 1740603718);

-- --------------------------------------------------------

--
-- Table structure for table `webform`
--

CREATE TABLE `webform` (
  `webform_id` varchar(32) NOT NULL COMMENT 'The webform id.',
  `next_serial` int UNSIGNED NOT NULL DEFAULT '1' COMMENT 'The serial number to give to the next submission to this webform.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Stores all webform data.';

--
-- Dumping data for table `webform`
--

INSERT INTO `webform` (`webform_id`, `next_serial`) VALUES
('contact', 1),
('contact_us', 1);

-- --------------------------------------------------------

--
-- Table structure for table `webform_submission`
--

CREATE TABLE `webform_submission` (
  `sid` int NOT NULL,
  `webform_id` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The ID of the target entity.',
  `uuid` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `langcode` varchar(12) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `serial` int DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `uri` varchar(2000) DEFAULT NULL,
  `created` int DEFAULT NULL,
  `completed` int DEFAULT NULL,
  `changed` int DEFAULT NULL,
  `in_draft` tinyint DEFAULT NULL,
  `current_page` varchar(128) DEFAULT NULL,
  `remote_addr` varchar(128) DEFAULT NULL,
  `uid` int UNSIGNED DEFAULT NULL COMMENT 'The ID of the target entity.',
  `entity_type` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
  `entity_id` varchar(255) DEFAULT NULL,
  `locked` tinyint DEFAULT NULL,
  `sticky` tinyint DEFAULT NULL,
  `notes` longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='The base table for webform_submission entities.';

-- --------------------------------------------------------

--
-- Table structure for table `webform_submission_data`
--

CREATE TABLE `webform_submission_data` (
  `webform_id` varchar(32) NOT NULL COMMENT 'The webform id.',
  `sid` int UNSIGNED NOT NULL COMMENT 'The unique identifier for this submission.',
  `name` varchar(128) NOT NULL COMMENT 'The name of the element.',
  `property` varchar(128) NOT NULL DEFAULT '' COMMENT 'The property of the element''s value.',
  `delta` int UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The delta of the element''s value.',
  `value` mediumtext NOT NULL COMMENT 'The element''s value.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Stores all submitted data for webform submissions.';

--
-- Indexes for dumped tables
--

--
-- Indexes for table `batch`
--
ALTER TABLE `batch`
  ADD PRIMARY KEY (`bid`),
  ADD KEY `token` (`token`);

--
-- Indexes for table `block_content`
--
ALTER TABLE `block_content`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `block_content_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `block_content__revision_id` (`revision_id`),
  ADD KEY `block_content_field__type__target_id` (`type`);

--
-- Indexes for table `block_content_field_data`
--
ALTER TABLE `block_content_field_data`
  ADD PRIMARY KEY (`id`,`langcode`),
  ADD KEY `block_content__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
  ADD KEY `block_content__revision_id` (`revision_id`),
  ADD KEY `block_content_field__type__target_id` (`type`),
  ADD KEY `block_content_field__reusable` (`reusable`),
  ADD KEY `block_content__status_type` (`status`,`type`,`id`);

--
-- Indexes for table `block_content_field_revision`
--
ALTER TABLE `block_content_field_revision`
  ADD PRIMARY KEY (`revision_id`,`langcode`),
  ADD KEY `block_content__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`);

--
-- Indexes for table `block_content_revision`
--
ALTER TABLE `block_content_revision`
  ADD PRIMARY KEY (`revision_id`),
  ADD KEY `block_content__id` (`id`),
  ADD KEY `block_content_field__revision_user__target_id` (`revision_user`);

--
-- Indexes for table `block_content_revision__body`
--
ALTER TABLE `block_content_revision__body`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `body_format` (`body_format`);

--
-- Indexes for table `block_content_revision__field_contact_details`
--
ALTER TABLE `block_content_revision__field_contact_details`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_contact_details_target_id` (`field_contact_details_target_id`),
  ADD KEY `field_contact_details_target_revision_id` (`field_contact_details_target_revision_id`);

--
-- Indexes for table `block_content__body`
--
ALTER TABLE `block_content__body`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `body_format` (`body_format`);

--
-- Indexes for table `block_content__field_contact_details`
--
ALTER TABLE `block_content__field_contact_details`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_contact_details_target_id` (`field_contact_details_target_id`),
  ADD KEY `field_contact_details_target_revision_id` (`field_contact_details_target_revision_id`);

--
-- Indexes for table `cachetags`
--
ALTER TABLE `cachetags`
  ADD PRIMARY KEY (`tag`);

--
-- Indexes for table `cache_access_policy`
--
ALTER TABLE `cache_access_policy`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_bootstrap`
--
ALTER TABLE `cache_bootstrap`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_config`
--
ALTER TABLE `cache_config`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_container`
--
ALTER TABLE `cache_container`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_data`
--
ALTER TABLE `cache_data`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_default`
--
ALTER TABLE `cache_default`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_discovery`
--
ALTER TABLE `cache_discovery`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_dynamic_page_cache`
--
ALTER TABLE `cache_dynamic_page_cache`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_entity`
--
ALTER TABLE `cache_entity`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_jsonapi_normalizations`
--
ALTER TABLE `cache_jsonapi_normalizations`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_menu`
--
ALTER TABLE `cache_menu`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_page`
--
ALTER TABLE `cache_page`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_render`
--
ALTER TABLE `cache_render`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_rest`
--
ALTER TABLE `cache_rest`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_toolbar`
--
ALTER TABLE `cache_toolbar`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `comment`
--
ALTER TABLE `comment`
  ADD PRIMARY KEY (`cid`),
  ADD UNIQUE KEY `comment_field__uuid__value` (`uuid`),
  ADD KEY `comment_field__comment_type__target_id` (`comment_type`);

--
-- Indexes for table `comment_entity_statistics`
--
ALTER TABLE `comment_entity_statistics`
  ADD PRIMARY KEY (`entity_id`,`entity_type`,`field_name`),
  ADD KEY `last_comment_timestamp` (`last_comment_timestamp`),
  ADD KEY `comment_count` (`comment_count`),
  ADD KEY `last_comment_uid` (`last_comment_uid`);

--
-- Indexes for table `comment_field_data`
--
ALTER TABLE `comment_field_data`
  ADD PRIMARY KEY (`cid`,`langcode`),
  ADD KEY `comment__id__default_langcode__langcode` (`cid`,`default_langcode`,`langcode`),
  ADD KEY `comment_field__comment_type__target_id` (`comment_type`),
  ADD KEY `comment_field__uid__target_id` (`uid`),
  ADD KEY `comment_field__created` (`created`),
  ADD KEY `comment__status_comment_type` (`status`,`comment_type`,`cid`),
  ADD KEY `comment__status_pid` (`pid`,`status`),
  ADD KEY `comment__num_new` (`entity_id`,`entity_type`,`comment_type`,`status`,`created`,`cid`,`thread`(191)),
  ADD KEY `comment__entity_langcode` (`entity_id`,`entity_type`,`comment_type`,`default_langcode`);

--
-- Indexes for table `comment__comment_body`
--
ALTER TABLE `comment__comment_body`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `comment_body_format` (`comment_body_format`);

--
-- Indexes for table `config`
--
ALTER TABLE `config`
  ADD PRIMARY KEY (`collection`,`name`);

--
-- Indexes for table `config_import`
--
ALTER TABLE `config_import`
  ADD PRIMARY KEY (`collection`,`name`);

--
-- Indexes for table `config_snapshot`
--
ALTER TABLE `config_snapshot`
  ADD PRIMARY KEY (`collection`,`name`);

--
-- Indexes for table `content_moderation_state`
--
ALTER TABLE `content_moderation_state`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `content_moderation_state_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `content_moderation_state__revision_id` (`revision_id`);

--
-- Indexes for table `content_moderation_state_field_data`
--
ALTER TABLE `content_moderation_state_field_data`
  ADD PRIMARY KEY (`id`,`langcode`),
  ADD UNIQUE KEY `content_moderation_state__lookup` (`content_entity_type_id`,`content_entity_id`,`content_entity_revision_id`,`workflow`,`langcode`),
  ADD KEY `content_moderation_state__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
  ADD KEY `content_moderation_state__revision_id` (`revision_id`),
  ADD KEY `content_moderation_state_field__uid__target_id` (`uid`),
  ADD KEY `content_moderation_state__09628d8dbc` (`workflow`);

--
-- Indexes for table `content_moderation_state_field_revision`
--
ALTER TABLE `content_moderation_state_field_revision`
  ADD PRIMARY KEY (`revision_id`,`langcode`),
  ADD UNIQUE KEY `content_moderation_state__lookup` (`content_entity_type_id`,`content_entity_id`,`content_entity_revision_id`,`workflow`,`langcode`),
  ADD KEY `content_moderation_state__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
  ADD KEY `content_moderation_state_field__uid__target_id` (`uid`),
  ADD KEY `content_moderation_state__09628d8dbc` (`workflow`);

--
-- Indexes for table `content_moderation_state_revision`
--
ALTER TABLE `content_moderation_state_revision`
  ADD PRIMARY KEY (`revision_id`),
  ADD KEY `content_moderation_state__id` (`id`);

--
-- Indexes for table `crop`
--
ALTER TABLE `crop`
  ADD PRIMARY KEY (`cid`),
  ADD UNIQUE KEY `crop_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `crop__vid` (`vid`),
  ADD KEY `crop_field__type__target_id` (`type`);

--
-- Indexes for table `crop_field_data`
--
ALTER TABLE `crop_field_data`
  ADD PRIMARY KEY (`cid`,`langcode`),
  ADD KEY `crop__id__default_langcode__langcode` (`cid`,`default_langcode`,`langcode`),
  ADD KEY `crop__vid` (`vid`),
  ADD KEY `crop_field__type__target_id` (`type`),
  ADD KEY `crop__uri_type` (`uri`(191),`type`);

--
-- Indexes for table `crop_field_revision`
--
ALTER TABLE `crop_field_revision`
  ADD PRIMARY KEY (`vid`,`langcode`),
  ADD KEY `crop__id__default_langcode__langcode` (`cid`,`default_langcode`,`langcode`);

--
-- Indexes for table `crop_revision`
--
ALTER TABLE `crop_revision`
  ADD PRIMARY KEY (`vid`),
  ADD KEY `crop__cid` (`cid`),
  ADD KEY `crop_field__revision_uid__target_id` (`revision_uid`);

--
-- Indexes for table `datashare_list`
--
ALTER TABLE `datashare_list`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `file_managed`
--
ALTER TABLE `file_managed`
  ADD PRIMARY KEY (`fid`),
  ADD UNIQUE KEY `file_field__uuid__value` (`uuid`),
  ADD KEY `file_field__uid__target_id` (`uid`),
  ADD KEY `file_field__uri` (`uri`(191)),
  ADD KEY `file_field__status` (`status`),
  ADD KEY `file_field__changed` (`changed`);

--
-- Indexes for table `file_usage`
--
ALTER TABLE `file_usage`
  ADD PRIMARY KEY (`fid`,`type`,`id`,`module`),
  ADD KEY `type_id` (`type`,`id`),
  ADD KEY `fid_count` (`fid`,`count`),
  ADD KEY `fid_module` (`fid`,`module`);

--
-- Indexes for table `flood`
--
ALTER TABLE `flood`
  ADD PRIMARY KEY (`fid`),
  ADD KEY `allow` (`event`,`identifier`,`timestamp`),
  ADD KEY `purge` (`expiration`);

--
-- Indexes for table `help_search_items`
--
ALTER TABLE `help_search_items`
  ADD PRIMARY KEY (`sid`),
  ADD KEY `section_plugin_id` (`section_plugin_id`),
  ADD KEY `topic_id` (`topic_id`);

--
-- Indexes for table `history`
--
ALTER TABLE `history`
  ADD PRIMARY KEY (`uid`,`nid`),
  ADD KEY `nid` (`nid`);

--
-- Indexes for table `key_value`
--
ALTER TABLE `key_value`
  ADD PRIMARY KEY (`collection`,`name`);

--
-- Indexes for table `key_value_expire`
--
ALTER TABLE `key_value_expire`
  ADD PRIMARY KEY (`collection`,`name`),
  ADD KEY `expire` (`expire`);

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`mid`),
  ADD UNIQUE KEY `media_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `media__vid` (`vid`),
  ADD KEY `media_field__bundle__target_id` (`bundle`);

--
-- Indexes for table `media_field_data`
--
ALTER TABLE `media_field_data`
  ADD PRIMARY KEY (`mid`,`langcode`),
  ADD KEY `media__id__default_langcode__langcode` (`mid`,`default_langcode`,`langcode`),
  ADD KEY `media__vid` (`vid`),
  ADD KEY `media_field__bundle__target_id` (`bundle`),
  ADD KEY `media_field__uid__target_id` (`uid`),
  ADD KEY `media_field__thumbnail__target_id` (`thumbnail__target_id`),
  ADD KEY `media__status_bundle` (`status`,`bundle`,`mid`);

--
-- Indexes for table `media_field_revision`
--
ALTER TABLE `media_field_revision`
  ADD PRIMARY KEY (`vid`,`langcode`),
  ADD KEY `media__id__default_langcode__langcode` (`mid`,`default_langcode`,`langcode`),
  ADD KEY `media_field__uid__target_id` (`uid`),
  ADD KEY `media_field__thumbnail__target_id` (`thumbnail__target_id`);

--
-- Indexes for table `media_revision`
--
ALTER TABLE `media_revision`
  ADD PRIMARY KEY (`vid`),
  ADD KEY `media__mid` (`mid`),
  ADD KEY `media_field__revision_user__target_id` (`revision_user`);

--
-- Indexes for table `media_revision__field_image_category`
--
ALTER TABLE `media_revision__field_image_category`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_category_target_id` (`field_image_category_target_id`);

--
-- Indexes for table `media_revision__field_image_description`
--
ALTER TABLE `media_revision__field_image_description`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `media_revision__field_media_audio_file`
--
ALTER TABLE `media_revision__field_media_audio_file`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_media_audio_file_target_id` (`field_media_audio_file_target_id`);

--
-- Indexes for table `media_revision__field_media_document`
--
ALTER TABLE `media_revision__field_media_document`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_media_document_target_id` (`field_media_document_target_id`);

--
-- Indexes for table `media_revision__field_media_image`
--
ALTER TABLE `media_revision__field_media_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_media_image_target_id` (`field_media_image_target_id`);

--
-- Indexes for table `media_revision__field_media_oembed_video`
--
ALTER TABLE `media_revision__field_media_oembed_video`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `media_revision__field_media_video_file`
--
ALTER TABLE `media_revision__field_media_video_file`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_media_video_file_target_id` (`field_media_video_file_target_id`);

--
-- Indexes for table `media_revision__field_replace_file`
--
ALTER TABLE `media_revision__field_replace_file`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `media_revision__field_replace_image`
--
ALTER TABLE `media_revision__field_replace_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `media_revision__field_show_in_media_library`
--
ALTER TABLE `media_revision__field_show_in_media_library`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `media_revision__field_upload_file`
--
ALTER TABLE `media_revision__field_upload_file`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_upload_file_target_id` (`field_upload_file_target_id`);

--
-- Indexes for table `media_revision__field_upload_new_image`
--
ALTER TABLE `media_revision__field_upload_new_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_upload_new_image_target_id` (`field_upload_new_image_target_id`);

--
-- Indexes for table `media__field_image_category`
--
ALTER TABLE `media__field_image_category`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_category_target_id` (`field_image_category_target_id`);

--
-- Indexes for table `media__field_image_description`
--
ALTER TABLE `media__field_image_description`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `media__field_media_audio_file`
--
ALTER TABLE `media__field_media_audio_file`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_media_audio_file_target_id` (`field_media_audio_file_target_id`);

--
-- Indexes for table `media__field_media_document`
--
ALTER TABLE `media__field_media_document`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_media_document_target_id` (`field_media_document_target_id`);

--
-- Indexes for table `media__field_media_image`
--
ALTER TABLE `media__field_media_image`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_media_image_target_id` (`field_media_image_target_id`);

--
-- Indexes for table `media__field_media_oembed_video`
--
ALTER TABLE `media__field_media_oembed_video`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `media__field_media_video_file`
--
ALTER TABLE `media__field_media_video_file`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_media_video_file_target_id` (`field_media_video_file_target_id`);

--
-- Indexes for table `media__field_replace_file`
--
ALTER TABLE `media__field_replace_file`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `media__field_replace_image`
--
ALTER TABLE `media__field_replace_image`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `media__field_show_in_media_library`
--
ALTER TABLE `media__field_show_in_media_library`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `media__field_upload_file`
--
ALTER TABLE `media__field_upload_file`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_upload_file_target_id` (`field_upload_file_target_id`);

--
-- Indexes for table `media__field_upload_new_image`
--
ALTER TABLE `media__field_upload_new_image`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_upload_new_image_target_id` (`field_upload_new_image_target_id`);

--
-- Indexes for table `menu_link_content`
--
ALTER TABLE `menu_link_content`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `menu_link_content_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `menu_link_content__revision_id` (`revision_id`);

--
-- Indexes for table `menu_link_content_data`
--
ALTER TABLE `menu_link_content_data`
  ADD PRIMARY KEY (`id`,`langcode`),
  ADD KEY `menu_link_content__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
  ADD KEY `menu_link_content__revision_id` (`revision_id`),
  ADD KEY `menu_link_content_field__link__uri` (`link__uri`(30)),
  ADD KEY `menu_link_content__enabled_bundle` (`enabled`,`bundle`,`id`);

--
-- Indexes for table `menu_link_content_field_revision`
--
ALTER TABLE `menu_link_content_field_revision`
  ADD PRIMARY KEY (`revision_id`,`langcode`),
  ADD KEY `menu_link_content__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
  ADD KEY `menu_link_content_field__link__uri` (`link__uri`(30));

--
-- Indexes for table `menu_link_content_revision`
--
ALTER TABLE `menu_link_content_revision`
  ADD PRIMARY KEY (`revision_id`),
  ADD KEY `menu_link_content__id` (`id`),
  ADD KEY `menu_link_content__ef029a1897` (`revision_user`);

--
-- Indexes for table `menu_link_content_revision__menu_item_roles`
--
ALTER TABLE `menu_link_content_revision__menu_item_roles`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `menu_item_roles_target_id` (`menu_item_roles_target_id`);

--
-- Indexes for table `menu_link_content__menu_item_roles`
--
ALTER TABLE `menu_link_content__menu_item_roles`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `menu_item_roles_target_id` (`menu_item_roles_target_id`);

--
-- Indexes for table `menu_tree`
--
ALTER TABLE `menu_tree`
  ADD PRIMARY KEY (`mlid`),
  ADD UNIQUE KEY `id` (`id`),
  ADD KEY `menu_parents` (`menu_name`,`p1`,`p2`,`p3`,`p4`,`p5`,`p6`,`p7`,`p8`,`p9`),
  ADD KEY `menu_parent_expand_child` (`menu_name`,`expanded`,`has_children`,`parent`(16)),
  ADD KEY `route_values` (`route_name`(32),`route_param_key`(16));

--
-- Indexes for table `node`
--
ALTER TABLE `node`
  ADD PRIMARY KEY (`nid`),
  ADD UNIQUE KEY `node_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `node__vid` (`vid`),
  ADD KEY `node_field__type__target_id` (`type`);

--
-- Indexes for table `nodeaccess`
--
ALTER TABLE `nodeaccess`
  ADD PRIMARY KEY (`nid`,`gid`,`realm`);

--
-- Indexes for table `node_access`
--
ALTER TABLE `node_access`
  ADD PRIMARY KEY (`nid`,`gid`,`realm`,`langcode`);

--
-- Indexes for table `node_field_data`
--
ALTER TABLE `node_field_data`
  ADD PRIMARY KEY (`nid`,`langcode`),
  ADD KEY `node__id__default_langcode__langcode` (`nid`,`default_langcode`,`langcode`),
  ADD KEY `node__vid` (`vid`),
  ADD KEY `node_field__type__target_id` (`type`),
  ADD KEY `node_field__uid__target_id` (`uid`),
  ADD KEY `node_field__created` (`created`),
  ADD KEY `node_field__changed` (`changed`),
  ADD KEY `node__status_type` (`status`,`type`,`nid`),
  ADD KEY `node__frontpage` (`promote`,`status`,`sticky`,`created`),
  ADD KEY `node__title_type` (`title`(191),`type`(4));

--
-- Indexes for table `node_field_revision`
--
ALTER TABLE `node_field_revision`
  ADD PRIMARY KEY (`vid`,`langcode`),
  ADD KEY `node__id__default_langcode__langcode` (`nid`,`default_langcode`,`langcode`),
  ADD KEY `node_field__uid__target_id` (`uid`);

--
-- Indexes for table `node_revision`
--
ALTER TABLE `node_revision`
  ADD PRIMARY KEY (`vid`),
  ADD KEY `node__nid` (`nid`),
  ADD KEY `node_field__langcode` (`langcode`),
  ADD KEY `node_field__revision_uid__target_id` (`revision_uid`);

--
-- Indexes for table `node_revision__body`
--
ALTER TABLE `node_revision__body`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `body_format` (`body_format`);

--
-- Indexes for table `node_revision__field_abstract`
--
ALTER TABLE `node_revision__field_abstract`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_abstract_format` (`field_abstract_format`);

--
-- Indexes for table `node_revision__field_add_department`
--
ALTER TABLE `node_revision__field_add_department`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_add_department_target_id` (`field_add_department_target_id`),
  ADD KEY `field_add_department_target_revision_id` (`field_add_department_target_revision_id`);

--
-- Indexes for table `node_revision__field_add_row`
--
ALTER TABLE `node_revision__field_add_row`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_add_row_target_id` (`field_add_row_target_id`),
  ADD KEY `field_add_row_target_revision_id` (`field_add_row_target_revision_id`);

--
-- Indexes for table `node_revision__field_add_row_three`
--
ALTER TABLE `node_revision__field_add_row_three`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_add_row_three_target_id` (`field_add_row_three_target_id`),
  ADD KEY `field_add_row_three_target_revision_id` (`field_add_row_three_target_revision_id`);

--
-- Indexes for table `node_revision__field_background_colour`
--
ALTER TABLE `node_revision__field_background_colour`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_calendar_id`
--
ALTER TABLE `node_revision__field_calendar_id`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_contact`
--
ALTER TABLE `node_revision__field_contact`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_contact_format` (`field_contact_format`);

--
-- Indexes for table `node_revision__field_content`
--
ALTER TABLE `node_revision__field_content`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_content_target_id` (`field_content_target_id`),
  ADD KEY `field_content_target_revision_id` (`field_content_target_revision_id`);

--
-- Indexes for table `node_revision__field_datashare_slider`
--
ALTER TABLE `node_revision__field_datashare_slider`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_datashare_slider_target_id` (`field_datashare_slider_target_id`),
  ADD KEY `field_datashare_slider_target_revision_id` (`field_datashare_slider_target_revision_id`);

--
-- Indexes for table `node_revision__field_department`
--
ALTER TABLE `node_revision__field_department`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_department_target_id` (`field_department_target_id`);

--
-- Indexes for table `node_revision__field_ea_department`
--
ALTER TABLE `node_revision__field_ea_department`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_ea_department_target_id` (`field_ea_department_target_id`);

--
-- Indexes for table `node_revision__field_email`
--
ALTER TABLE `node_revision__field_email`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_event`
--
ALTER TABLE `node_revision__field_event`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_event_target_id` (`field_event_target_id`);

--
-- Indexes for table `node_revision__field_event_category`
--
ALTER TABLE `node_revision__field_event_category`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_event_category_value` (`field_event_category_value`(191));

--
-- Indexes for table `node_revision__field_excerpt_summary`
--
ALTER TABLE `node_revision__field_excerpt_summary`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_excerpt_summary_format` (`field_excerpt_summary_format`);

--
-- Indexes for table `node_revision__field_facilities_description`
--
ALTER TABLE `node_revision__field_facilities_description`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_facilities_description_format` (`field_facilities_description_format`);

--
-- Indexes for table `node_revision__field_facilities_title`
--
ALTER TABLE `node_revision__field_facilities_title`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_facts`
--
ALTER TABLE `node_revision__field_facts`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_facts_target_id` (`field_facts_target_id`),
  ADD KEY `field_facts_target_revision_id` (`field_facts_target_revision_id`);

--
-- Indexes for table `node_revision__field_full_calendar_type`
--
ALTER TABLE `node_revision__field_full_calendar_type`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_full_calendar_type_target_id` (`field_full_calendar_type_target_id`);

--
-- Indexes for table `node_revision__field_google_event_uuid`
--
ALTER TABLE `node_revision__field_google_event_uuid`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_hero_image`
--
ALTER TABLE `node_revision__field_hero_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_hero_image_target_id` (`field_hero_image_target_id`);

--
-- Indexes for table `node_revision__field_history_description`
--
ALTER TABLE `node_revision__field_history_description`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_history_description_format` (`field_history_description_format`);

--
-- Indexes for table `node_revision__field_history_title`
--
ALTER TABLE `node_revision__field_history_title`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_image_hero`
--
ALTER TABLE `node_revision__field_image_hero`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_hero_target_id` (`field_image_hero_target_id`);

--
-- Indexes for table `node_revision__field_legacy_url`
--
ALTER TABLE `node_revision__field_legacy_url`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_location`
--
ALTER TABLE `node_revision__field_location`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_meta_tags`
--
ALTER TABLE `node_revision__field_meta_tags`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_mission_description`
--
ALTER TABLE `node_revision__field_mission_description`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_mission_description_format` (`field_mission_description_format`);

--
-- Indexes for table `node_revision__field_mission_title`
--
ALTER TABLE `node_revision__field_mission_title`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_newsletter`
--
ALTER TABLE `node_revision__field_newsletter`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_newsletter_target_id` (`field_newsletter_target_id`);

--
-- Indexes for table `node_revision__field_newsletter_type`
--
ALTER TABLE `node_revision__field_newsletter_type`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_newsletter_type_value` (`field_newsletter_type_value`(191));

--
-- Indexes for table `node_revision__field_news_sticky`
--
ALTER TABLE `node_revision__field_news_sticky`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_news_type`
--
ALTER TABLE `node_revision__field_news_type`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_news_type_target_id` (`field_news_type_target_id`);

--
-- Indexes for table `node_revision__field_order_sequence_id`
--
ALTER TABLE `node_revision__field_order_sequence_id`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_page_type`
--
ALTER TABLE `node_revision__field_page_type`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_page_type_value` (`field_page_type_value`(191));

--
-- Indexes for table `node_revision__field_parent_page`
--
ALTER TABLE `node_revision__field_parent_page`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_parent_page_target_id` (`field_parent_page_target_id`);

--
-- Indexes for table `node_revision__field_post_content`
--
ALTER TABLE `node_revision__field_post_content`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_post_content_target_id` (`field_post_content_target_id`),
  ADD KEY `field_post_content_target_revision_id` (`field_post_content_target_revision_id`);

--
-- Indexes for table `node_revision__field_pre_content`
--
ALTER TABLE `node_revision__field_pre_content`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_pre_content_target_id` (`field_pre_content_target_id`),
  ADD KEY `field_pre_content_target_revision_id` (`field_pre_content_target_revision_id`);

--
-- Indexes for table `node_revision__field_price`
--
ALTER TABLE `node_revision__field_price`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_principal_image`
--
ALTER TABLE `node_revision__field_principal_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_principal_image_target_id` (`field_principal_image_target_id`);

--
-- Indexes for table `node_revision__field_programs_services`
--
ALTER TABLE `node_revision__field_programs_services`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_programs_services_target_id` (`field_programs_services_target_id`);

--
-- Indexes for table `node_revision__field_public`
--
ALTER TABLE `node_revision__field_public`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r1_column_1`
--
ALTER TABLE `node_revision__field_r1_column_1`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r1_column_2`
--
ALTER TABLE `node_revision__field_r1_column_2`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r1_column_3`
--
ALTER TABLE `node_revision__field_r1_column_3`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r1_show_as_header`
--
ALTER TABLE `node_revision__field_r1_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r2_column_1`
--
ALTER TABLE `node_revision__field_r2_column_1`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r2_column_2`
--
ALTER TABLE `node_revision__field_r2_column_2`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r2_column_3`
--
ALTER TABLE `node_revision__field_r2_column_3`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r2_show_as_header`
--
ALTER TABLE `node_revision__field_r2_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r3_column_1`
--
ALTER TABLE `node_revision__field_r3_column_1`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r3_column_2`
--
ALTER TABLE `node_revision__field_r3_column_2`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r3_column_3`
--
ALTER TABLE `node_revision__field_r3_column_3`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r3_show_as_header`
--
ALTER TABLE `node_revision__field_r3_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r4_column_1`
--
ALTER TABLE `node_revision__field_r4_column_1`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r4_column_2`
--
ALTER TABLE `node_revision__field_r4_column_2`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r4_column_3`
--
ALTER TABLE `node_revision__field_r4_column_3`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r4_show_as_header`
--
ALTER TABLE `node_revision__field_r4_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r5_column_1`
--
ALTER TABLE `node_revision__field_r5_column_1`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r5_column_2`
--
ALTER TABLE `node_revision__field_r5_column_2`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r5_column_3`
--
ALTER TABLE `node_revision__field_r5_column_3`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r5_show_as_header`
--
ALTER TABLE `node_revision__field_r5_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r6_column_1`
--
ALTER TABLE `node_revision__field_r6_column_1`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r6_column_2`
--
ALTER TABLE `node_revision__field_r6_column_2`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r6_column_3`
--
ALTER TABLE `node_revision__field_r6_column_3`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r6_show_as_header`
--
ALTER TABLE `node_revision__field_r6_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r7_column_1`
--
ALTER TABLE `node_revision__field_r7_column_1`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r7_column_2`
--
ALTER TABLE `node_revision__field_r7_column_2`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r7_column_3`
--
ALTER TABLE `node_revision__field_r7_column_3`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r7_show_as_header`
--
ALTER TABLE `node_revision__field_r7_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r8_column_1`
--
ALTER TABLE `node_revision__field_r8_column_1`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r8_column_2`
--
ALTER TABLE `node_revision__field_r8_column_2`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r8_column_3`
--
ALTER TABLE `node_revision__field_r8_column_3`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r8_show_as_header`
--
ALTER TABLE `node_revision__field_r8_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r9_column_1`
--
ALTER TABLE `node_revision__field_r9_column_1`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r9_column_2`
--
ALTER TABLE `node_revision__field_r9_column_2`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r9_column_3`
--
ALTER TABLE `node_revision__field_r9_column_3`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r9_show_as_header`
--
ALTER TABLE `node_revision__field_r9_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r10_column_1`
--
ALTER TABLE `node_revision__field_r10_column_1`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r10_column_2`
--
ALTER TABLE `node_revision__field_r10_column_2`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r10_column_3`
--
ALTER TABLE `node_revision__field_r10_column_3`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_r10_show_as_header`
--
ALTER TABLE `node_revision__field_r10_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_reference_content`
--
ALTER TABLE `node_revision__field_reference_content`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_reference_content_target_id` (`field_reference_content_target_id`);

--
-- Indexes for table `node_revision__field_related_content`
--
ALTER TABLE `node_revision__field_related_content`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_related_content_target_id` (`field_related_content_target_id`);

--
-- Indexes for table `node_revision__field_related_links`
--
ALTER TABLE `node_revision__field_related_links`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_related_links_uri` (`field_related_links_uri`(30));

--
-- Indexes for table `node_revision__field_remote_video_images`
--
ALTER TABLE `node_revision__field_remote_video_images`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_remote_video_images_target_id` (`field_remote_video_images_target_id`);

--
-- Indexes for table `node_revision__field_room`
--
ALTER TABLE `node_revision__field_room`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_scheduled`
--
ALTER TABLE `node_revision__field_scheduled`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_scheduled_value` (`field_scheduled_value`);

--
-- Indexes for table `node_revision__field_seats_available`
--
ALTER TABLE `node_revision__field_seats_available`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_side_bar_region`
--
ALTER TABLE `node_revision__field_side_bar_region`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_side_bar_region_target_id` (`field_side_bar_region_target_id`),
  ADD KEY `field_side_bar_region_target_revision_id` (`field_side_bar_region_target_revision_id`);

--
-- Indexes for table `node_revision__field_start_time_date_end_time_d`
--
ALTER TABLE `node_revision__field_start_time_date_end_time_d`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_start_time_date_end_time_d_value` (`field_start_time_date_end_time_d_value`),
  ADD KEY `field_start_time_date_end_time_d_end_value` (`field_start_time_date_end_time_d_end_value`);

--
-- Indexes for table `node_revision__field_tag`
--
ALTER TABLE `node_revision__field_tag`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_tag_target_id` (`field_tag_target_id`);

--
-- Indexes for table `node_revision__field_telephone`
--
ALTER TABLE `node_revision__field_telephone`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_values_description`
--
ALTER TABLE `node_revision__field_values_description`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_values_description_format` (`field_values_description_format`);

--
-- Indexes for table `node_revision__field_values_title`
--
ALTER TABLE `node_revision__field_values_title`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_video`
--
ALTER TABLE `node_revision__field_video`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node_revision__field_vision_description`
--
ALTER TABLE `node_revision__field_vision_description`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_vision_description_format` (`field_vision_description_format`);

--
-- Indexes for table `node_revision__field_vision_title`
--
ALTER TABLE `node_revision__field_vision_title`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__body`
--
ALTER TABLE `node__body`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `body_format` (`body_format`);

--
-- Indexes for table `node__field_abstract`
--
ALTER TABLE `node__field_abstract`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_abstract_format` (`field_abstract_format`);

--
-- Indexes for table `node__field_add_department`
--
ALTER TABLE `node__field_add_department`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_add_department_target_id` (`field_add_department_target_id`),
  ADD KEY `field_add_department_target_revision_id` (`field_add_department_target_revision_id`);

--
-- Indexes for table `node__field_add_row`
--
ALTER TABLE `node__field_add_row`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_add_row_target_id` (`field_add_row_target_id`),
  ADD KEY `field_add_row_target_revision_id` (`field_add_row_target_revision_id`);

--
-- Indexes for table `node__field_add_row_three`
--
ALTER TABLE `node__field_add_row_three`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_add_row_three_target_id` (`field_add_row_three_target_id`),
  ADD KEY `field_add_row_three_target_revision_id` (`field_add_row_three_target_revision_id`);

--
-- Indexes for table `node__field_background_colour`
--
ALTER TABLE `node__field_background_colour`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_calendar_id`
--
ALTER TABLE `node__field_calendar_id`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_contact`
--
ALTER TABLE `node__field_contact`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_contact_format` (`field_contact_format`);

--
-- Indexes for table `node__field_content`
--
ALTER TABLE `node__field_content`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_content_target_id` (`field_content_target_id`),
  ADD KEY `field_content_target_revision_id` (`field_content_target_revision_id`);

--
-- Indexes for table `node__field_datashare_slider`
--
ALTER TABLE `node__field_datashare_slider`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_datashare_slider_target_id` (`field_datashare_slider_target_id`),
  ADD KEY `field_datashare_slider_target_revision_id` (`field_datashare_slider_target_revision_id`);

--
-- Indexes for table `node__field_department`
--
ALTER TABLE `node__field_department`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_department_target_id` (`field_department_target_id`);

--
-- Indexes for table `node__field_ea_department`
--
ALTER TABLE `node__field_ea_department`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_ea_department_target_id` (`field_ea_department_target_id`);

--
-- Indexes for table `node__field_email`
--
ALTER TABLE `node__field_email`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_event`
--
ALTER TABLE `node__field_event`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_event_target_id` (`field_event_target_id`);

--
-- Indexes for table `node__field_event_category`
--
ALTER TABLE `node__field_event_category`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_event_category_value` (`field_event_category_value`(191));

--
-- Indexes for table `node__field_excerpt_summary`
--
ALTER TABLE `node__field_excerpt_summary`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_excerpt_summary_format` (`field_excerpt_summary_format`);

--
-- Indexes for table `node__field_facilities_description`
--
ALTER TABLE `node__field_facilities_description`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_facilities_description_format` (`field_facilities_description_format`);

--
-- Indexes for table `node__field_facilities_title`
--
ALTER TABLE `node__field_facilities_title`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_facts`
--
ALTER TABLE `node__field_facts`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_facts_target_id` (`field_facts_target_id`),
  ADD KEY `field_facts_target_revision_id` (`field_facts_target_revision_id`);

--
-- Indexes for table `node__field_full_calendar_type`
--
ALTER TABLE `node__field_full_calendar_type`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_full_calendar_type_target_id` (`field_full_calendar_type_target_id`);

--
-- Indexes for table `node__field_google_event_uuid`
--
ALTER TABLE `node__field_google_event_uuid`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_hero_image`
--
ALTER TABLE `node__field_hero_image`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_hero_image_target_id` (`field_hero_image_target_id`);

--
-- Indexes for table `node__field_history_description`
--
ALTER TABLE `node__field_history_description`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_history_description_format` (`field_history_description_format`);

--
-- Indexes for table `node__field_history_title`
--
ALTER TABLE `node__field_history_title`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_image_hero`
--
ALTER TABLE `node__field_image_hero`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_hero_target_id` (`field_image_hero_target_id`);

--
-- Indexes for table `node__field_legacy_url`
--
ALTER TABLE `node__field_legacy_url`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_location`
--
ALTER TABLE `node__field_location`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_meta_tags`
--
ALTER TABLE `node__field_meta_tags`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_mission_description`
--
ALTER TABLE `node__field_mission_description`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_mission_description_format` (`field_mission_description_format`);

--
-- Indexes for table `node__field_mission_title`
--
ALTER TABLE `node__field_mission_title`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_newsletter`
--
ALTER TABLE `node__field_newsletter`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_newsletter_target_id` (`field_newsletter_target_id`);

--
-- Indexes for table `node__field_newsletter_type`
--
ALTER TABLE `node__field_newsletter_type`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_newsletter_type_value` (`field_newsletter_type_value`(191));

--
-- Indexes for table `node__field_news_sticky`
--
ALTER TABLE `node__field_news_sticky`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_news_type`
--
ALTER TABLE `node__field_news_type`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_news_type_target_id` (`field_news_type_target_id`);

--
-- Indexes for table `node__field_order_sequence_id`
--
ALTER TABLE `node__field_order_sequence_id`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_page_type`
--
ALTER TABLE `node__field_page_type`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_page_type_value` (`field_page_type_value`(191));

--
-- Indexes for table `node__field_parent_page`
--
ALTER TABLE `node__field_parent_page`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_parent_page_target_id` (`field_parent_page_target_id`);

--
-- Indexes for table `node__field_post_content`
--
ALTER TABLE `node__field_post_content`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_post_content_target_id` (`field_post_content_target_id`),
  ADD KEY `field_post_content_target_revision_id` (`field_post_content_target_revision_id`);

--
-- Indexes for table `node__field_pre_content`
--
ALTER TABLE `node__field_pre_content`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_pre_content_target_id` (`field_pre_content_target_id`),
  ADD KEY `field_pre_content_target_revision_id` (`field_pre_content_target_revision_id`);

--
-- Indexes for table `node__field_price`
--
ALTER TABLE `node__field_price`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_principal_image`
--
ALTER TABLE `node__field_principal_image`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_principal_image_target_id` (`field_principal_image_target_id`);

--
-- Indexes for table `node__field_programs_services`
--
ALTER TABLE `node__field_programs_services`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_programs_services_target_id` (`field_programs_services_target_id`);

--
-- Indexes for table `node__field_public`
--
ALTER TABLE `node__field_public`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r1_column_1`
--
ALTER TABLE `node__field_r1_column_1`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r1_column_2`
--
ALTER TABLE `node__field_r1_column_2`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r1_column_3`
--
ALTER TABLE `node__field_r1_column_3`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r1_show_as_header`
--
ALTER TABLE `node__field_r1_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r2_column_1`
--
ALTER TABLE `node__field_r2_column_1`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r2_column_2`
--
ALTER TABLE `node__field_r2_column_2`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r2_column_3`
--
ALTER TABLE `node__field_r2_column_3`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r2_show_as_header`
--
ALTER TABLE `node__field_r2_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r3_column_1`
--
ALTER TABLE `node__field_r3_column_1`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r3_column_2`
--
ALTER TABLE `node__field_r3_column_2`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r3_column_3`
--
ALTER TABLE `node__field_r3_column_3`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r3_show_as_header`
--
ALTER TABLE `node__field_r3_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r4_column_1`
--
ALTER TABLE `node__field_r4_column_1`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r4_column_2`
--
ALTER TABLE `node__field_r4_column_2`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r4_column_3`
--
ALTER TABLE `node__field_r4_column_3`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r4_show_as_header`
--
ALTER TABLE `node__field_r4_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r5_column_1`
--
ALTER TABLE `node__field_r5_column_1`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r5_column_2`
--
ALTER TABLE `node__field_r5_column_2`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r5_column_3`
--
ALTER TABLE `node__field_r5_column_3`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r5_show_as_header`
--
ALTER TABLE `node__field_r5_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r6_column_1`
--
ALTER TABLE `node__field_r6_column_1`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r6_column_2`
--
ALTER TABLE `node__field_r6_column_2`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r6_column_3`
--
ALTER TABLE `node__field_r6_column_3`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r6_show_as_header`
--
ALTER TABLE `node__field_r6_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r7_column_1`
--
ALTER TABLE `node__field_r7_column_1`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r7_column_2`
--
ALTER TABLE `node__field_r7_column_2`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r7_column_3`
--
ALTER TABLE `node__field_r7_column_3`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r7_show_as_header`
--
ALTER TABLE `node__field_r7_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r8_column_1`
--
ALTER TABLE `node__field_r8_column_1`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r8_column_2`
--
ALTER TABLE `node__field_r8_column_2`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r8_column_3`
--
ALTER TABLE `node__field_r8_column_3`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r8_show_as_header`
--
ALTER TABLE `node__field_r8_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r9_column_1`
--
ALTER TABLE `node__field_r9_column_1`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r9_column_2`
--
ALTER TABLE `node__field_r9_column_2`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r9_column_3`
--
ALTER TABLE `node__field_r9_column_3`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r9_show_as_header`
--
ALTER TABLE `node__field_r9_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r10_column_1`
--
ALTER TABLE `node__field_r10_column_1`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r10_column_2`
--
ALTER TABLE `node__field_r10_column_2`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r10_column_3`
--
ALTER TABLE `node__field_r10_column_3`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_r10_show_as_header`
--
ALTER TABLE `node__field_r10_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_reference_content`
--
ALTER TABLE `node__field_reference_content`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_reference_content_target_id` (`field_reference_content_target_id`);

--
-- Indexes for table `node__field_related_content`
--
ALTER TABLE `node__field_related_content`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_related_content_target_id` (`field_related_content_target_id`);

--
-- Indexes for table `node__field_related_links`
--
ALTER TABLE `node__field_related_links`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_related_links_uri` (`field_related_links_uri`(30));

--
-- Indexes for table `node__field_remote_video_images`
--
ALTER TABLE `node__field_remote_video_images`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_remote_video_images_target_id` (`field_remote_video_images_target_id`);

--
-- Indexes for table `node__field_room`
--
ALTER TABLE `node__field_room`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_scheduled`
--
ALTER TABLE `node__field_scheduled`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_scheduled_value` (`field_scheduled_value`);

--
-- Indexes for table `node__field_seats_available`
--
ALTER TABLE `node__field_seats_available`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_side_bar_region`
--
ALTER TABLE `node__field_side_bar_region`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_side_bar_region_target_id` (`field_side_bar_region_target_id`),
  ADD KEY `field_side_bar_region_target_revision_id` (`field_side_bar_region_target_revision_id`);

--
-- Indexes for table `node__field_start_time_date_end_time_d`
--
ALTER TABLE `node__field_start_time_date_end_time_d`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_start_time_date_end_time_d_value` (`field_start_time_date_end_time_d_value`),
  ADD KEY `field_start_time_date_end_time_d_end_value` (`field_start_time_date_end_time_d_end_value`);

--
-- Indexes for table `node__field_tag`
--
ALTER TABLE `node__field_tag`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_tag_target_id` (`field_tag_target_id`);

--
-- Indexes for table `node__field_telephone`
--
ALTER TABLE `node__field_telephone`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_values_description`
--
ALTER TABLE `node__field_values_description`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_values_description_format` (`field_values_description_format`);

--
-- Indexes for table `node__field_values_title`
--
ALTER TABLE `node__field_values_title`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_video`
--
ALTER TABLE `node__field_video`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `node__field_vision_description`
--
ALTER TABLE `node__field_vision_description`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_vision_description_format` (`field_vision_description_format`);

--
-- Indexes for table `node__field_vision_title`
--
ALTER TABLE `node__field_vision_title`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraphs_item`
--
ALTER TABLE `paragraphs_item`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `paragraph_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `paragraph__revision_id` (`revision_id`),
  ADD KEY `paragraph_field__type__target_id` (`type`);

--
-- Indexes for table `paragraphs_item_field_data`
--
ALTER TABLE `paragraphs_item_field_data`
  ADD PRIMARY KEY (`id`,`langcode`),
  ADD KEY `paragraph__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
  ADD KEY `paragraph__revision_id` (`revision_id`),
  ADD KEY `paragraph_field__type__target_id` (`type`),
  ADD KEY `paragraph__status_type` (`status`,`type`,`id`),
  ADD KEY `paragraphs__parent_fields` (`parent_type`,`parent_id`,`parent_field_name`);

--
-- Indexes for table `paragraphs_item_revision`
--
ALTER TABLE `paragraphs_item_revision`
  ADD PRIMARY KEY (`revision_id`),
  ADD KEY `paragraph__id` (`id`);

--
-- Indexes for table `paragraphs_item_revision_field_data`
--
ALTER TABLE `paragraphs_item_revision_field_data`
  ADD PRIMARY KEY (`revision_id`,`langcode`),
  ADD KEY `paragraph__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
  ADD KEY `paragraphs__parent_fields` (`parent_type`,`parent_id`,`parent_field_name`);

--
-- Indexes for table `paragraph_revision__field_accordion_items`
--
ALTER TABLE `paragraph_revision__field_accordion_items`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_accordion_items_target_id` (`field_accordion_items_target_id`),
  ADD KEY `field_accordion_items_target_revision_id` (`field_accordion_items_target_revision_id`);

--
-- Indexes for table `paragraph_revision__field_address`
--
ALTER TABLE `paragraph_revision__field_address`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_address_format` (`field_address_format`);

--
-- Indexes for table `paragraph_revision__field_background_color`
--
ALTER TABLE `paragraph_revision__field_background_color`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_background_color_target_id` (`field_background_color_target_id`);

--
-- Indexes for table `paragraph_revision__field_background_color_list`
--
ALTER TABLE `paragraph_revision__field_background_color_list`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_background_color_list_value` (`field_background_color_list_value`(191));

--
-- Indexes for table `paragraph_revision__field_button`
--
ALTER TABLE `paragraph_revision__field_button`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_button_uri` (`field_button_uri`(30));

--
-- Indexes for table `paragraph_revision__field_button_text`
--
ALTER TABLE `paragraph_revision__field_button_text`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_caption_text`
--
ALTER TABLE `paragraph_revision__field_caption_text`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_carousal_item`
--
ALTER TABLE `paragraph_revision__field_carousal_item`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_carousal_item_target_id` (`field_carousal_item_target_id`),
  ADD KEY `field_carousal_item_target_revision_id` (`field_carousal_item_target_revision_id`);

--
-- Indexes for table `paragraph_revision__field_columns`
--
ALTER TABLE `paragraph_revision__field_columns`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_columns_target_id` (`field_columns_target_id`),
  ADD KEY `field_columns_target_revision_id` (`field_columns_target_revision_id`);

--
-- Indexes for table `paragraph_revision__field_column_1`
--
ALTER TABLE `paragraph_revision__field_column_1`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_column_2`
--
ALTER TABLE `paragraph_revision__field_column_2`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_column_3`
--
ALTER TABLE `paragraph_revision__field_column_3`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_conent`
--
ALTER TABLE `paragraph_revision__field_conent`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_conent_target_id` (`field_conent_target_id`),
  ADD KEY `field_conent_target_revision_id` (`field_conent_target_revision_id`);

--
-- Indexes for table `paragraph_revision__field_content`
--
ALTER TABLE `paragraph_revision__field_content`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_content_format` (`field_content_format`);

--
-- Indexes for table `paragraph_revision__field_cta_icon`
--
ALTER TABLE `paragraph_revision__field_cta_icon`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_cta_icon_target_id` (`field_cta_icon_target_id`),
  ADD KEY `field_cta_icon_target_revision_id` (`field_cta_icon_target_revision_id`);

--
-- Indexes for table `paragraph_revision__field_department_link`
--
ALTER TABLE `paragraph_revision__field_department_link`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_department_link_uri` (`field_department_link_uri`(30));

--
-- Indexes for table `paragraph_revision__field_department_name`
--
ALTER TABLE `paragraph_revision__field_department_name`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_description`
--
ALTER TABLE `paragraph_revision__field_description`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_description_130`
--
ALTER TABLE `paragraph_revision__field_description_130`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_description_cta_icon`
--
ALTER TABLE `paragraph_revision__field_description_cta_icon`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_description_cta_icon_uri` (`field_description_cta_icon_uri`(30));

--
-- Indexes for table `paragraph_revision__field_description_img_lnks`
--
ALTER TABLE `paragraph_revision__field_description_img_lnks`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_description_otar`
--
ALTER TABLE `paragraph_revision__field_description_otar`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_email`
--
ALTER TABLE `paragraph_revision__field_email`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_end_date`
--
ALTER TABLE `paragraph_revision__field_end_date`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_end_date_value` (`field_end_date_value`);

--
-- Indexes for table `paragraph_revision__field_facts`
--
ALTER TABLE `paragraph_revision__field_facts`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_facts_target_id` (`field_facts_target_id`),
  ADD KEY `field_facts_target_revision_id` (`field_facts_target_revision_id`);

--
-- Indexes for table `paragraph_revision__field_fax`
--
ALTER TABLE `paragraph_revision__field_fax`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_field_description_cob`
--
ALTER TABLE `paragraph_revision__field_field_description_cob`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_first_column_`
--
ALTER TABLE `paragraph_revision__field_first_column_`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_first_column__target_id` (`field_first_column__target_id`),
  ADD KEY `field_first_column__target_revision_id` (`field_first_column__target_revision_id`);

--
-- Indexes for table `paragraph_revision__field_font_awesome_icon_name`
--
ALTER TABLE `paragraph_revision__field_font_awesome_icon_name`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_full_name`
--
ALTER TABLE `paragraph_revision__field_full_name`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_gallery_image`
--
ALTER TABLE `paragraph_revision__field_gallery_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_gallery_image_target_id` (`field_gallery_image_target_id`);

--
-- Indexes for table `paragraph_revision__field_image`
--
ALTER TABLE `paragraph_revision__field_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_target_id` (`field_image_target_id`);

--
-- Indexes for table `paragraph_revision__field_image2`
--
ALTER TABLE `paragraph_revision__field_image2`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image2_target_id` (`field_image2_target_id`);

--
-- Indexes for table `paragraph_revision__field_images`
--
ALTER TABLE `paragraph_revision__field_images`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_images_target_id` (`field_images_target_id`),
  ADD KEY `field_images_target_revision_id` (`field_images_target_revision_id`);

--
-- Indexes for table `paragraph_revision__field_images_with_links`
--
ALTER TABLE `paragraph_revision__field_images_with_links`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_images_with_links_target_id` (`field_images_with_links_target_id`),
  ADD KEY `field_images_with_links_target_revision_id` (`field_images_with_links_target_revision_id`);

--
-- Indexes for table `paragraph_revision__field_image_carousal`
--
ALTER TABLE `paragraph_revision__field_image_carousal`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_carousal_target_id` (`field_image_carousal_target_id`);

--
-- Indexes for table `paragraph_revision__field_image_cob`
--
ALTER TABLE `paragraph_revision__field_image_cob`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_cob_target_id` (`field_image_cob_target_id`);

--
-- Indexes for table `paragraph_revision__field_image_image_slide`
--
ALTER TABLE `paragraph_revision__field_image_image_slide`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_image_slide_target_id` (`field_image_image_slide_target_id`);

--
-- Indexes for table `paragraph_revision__field_image_paragraph`
--
ALTER TABLE `paragraph_revision__field_image_paragraph`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_paragraph_target_id` (`field_image_paragraph_target_id`),
  ADD KEY `field_image_paragraph_target_revision_id` (`field_image_paragraph_target_revision_id`);

--
-- Indexes for table `paragraph_revision__field_image_placement_select`
--
ALTER TABLE `paragraph_revision__field_image_placement_select`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_placement_select_value` (`field_image_placement_select_value`(191));

--
-- Indexes for table `paragraph_revision__field_image_slide`
--
ALTER TABLE `paragraph_revision__field_image_slide`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_slide_target_id` (`field_image_slide_target_id`);

--
-- Indexes for table `paragraph_revision__field_image_with_link`
--
ALTER TABLE `paragraph_revision__field_image_with_link`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_with_link_target_id` (`field_image_with_link_target_id`);

--
-- Indexes for table `paragraph_revision__field_link`
--
ALTER TABLE `paragraph_revision__field_link`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_link_uri` (`field_link_uri`(30));

--
-- Indexes for table `paragraph_revision__field_link_single`
--
ALTER TABLE `paragraph_revision__field_link_single`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_link_single_uri` (`field_link_single_uri`(30));

--
-- Indexes for table `paragraph_revision__field_link_without_text`
--
ALTER TABLE `paragraph_revision__field_link_without_text`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_link_without_text_uri` (`field_link_without_text_uri`(30));

--
-- Indexes for table `paragraph_revision__field_media_caption`
--
ALTER TABLE `paragraph_revision__field_media_caption`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_media_reference`
--
ALTER TABLE `paragraph_revision__field_media_reference`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_media_reference_target_id` (`field_media_reference_target_id`);

--
-- Indexes for table `paragraph_revision__field_message_items`
--
ALTER TABLE `paragraph_revision__field_message_items`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_message_items_target_id` (`field_message_items_target_id`),
  ADD KEY `field_message_items_target_revision_id` (`field_message_items_target_revision_id`);

--
-- Indexes for table `paragraph_revision__field_number`
--
ALTER TABLE `paragraph_revision__field_number`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_occupation`
--
ALTER TABLE `paragraph_revision__field_occupation`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_phone`
--
ALTER TABLE `paragraph_revision__field_phone`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_profile_occupation`
--
ALTER TABLE `paragraph_revision__field_profile_occupation`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_related_content_item`
--
ALTER TABLE `paragraph_revision__field_related_content_item`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_related_content_item_target_id` (`field_related_content_item_target_id`),
  ADD KEY `field_related_content_item_target_revision_id` (`field_related_content_item_target_revision_id`);

--
-- Indexes for table `paragraph_revision__field_remote_video`
--
ALTER TABLE `paragraph_revision__field_remote_video`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_second_column_`
--
ALTER TABLE `paragraph_revision__field_second_column_`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_second_column__target_id` (`field_second_column__target_id`),
  ADD KEY `field_second_column__target_revision_id` (`field_second_column__target_revision_id`);

--
-- Indexes for table `paragraph_revision__field_select_demo`
--
ALTER TABLE `paragraph_revision__field_select_demo`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_select_demo_value` (`field_select_demo_value`);

--
-- Indexes for table `paragraph_revision__field_show_as_header`
--
ALTER TABLE `paragraph_revision__field_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_slide`
--
ALTER TABLE `paragraph_revision__field_slide`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_slide_target_id` (`field_slide_target_id`),
  ADD KEY `field_slide_target_revision_id` (`field_slide_target_revision_id`);

--
-- Indexes for table `paragraph_revision__field_slider_image`
--
ALTER TABLE `paragraph_revision__field_slider_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_slider_image_target_id` (`field_slider_image_target_id`);

--
-- Indexes for table `paragraph_revision__field_slider_image_alignment`
--
ALTER TABLE `paragraph_revision__field_slider_image_alignment`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_slider_image_alignment_value` (`field_slider_image_alignment_value`(191));

--
-- Indexes for table `paragraph_revision__field_slideshow_images`
--
ALTER TABLE `paragraph_revision__field_slideshow_images`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_slideshow_images_target_id` (`field_slideshow_images_target_id`);

--
-- Indexes for table `paragraph_revision__field_slide_description`
--
ALTER TABLE `paragraph_revision__field_slide_description`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_slide_description_format` (`field_slide_description_format`);

--
-- Indexes for table `paragraph_revision__field_slide_image`
--
ALTER TABLE `paragraph_revision__field_slide_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_slide_image_target_id` (`field_slide_image_target_id`);

--
-- Indexes for table `paragraph_revision__field_small_image`
--
ALTER TABLE `paragraph_revision__field_small_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_small_image_target_id` (`field_small_image_target_id`);

--
-- Indexes for table `paragraph_revision__field_staff_listing_item`
--
ALTER TABLE `paragraph_revision__field_staff_listing_item`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_staff_listing_item_target_id` (`field_staff_listing_item_target_id`),
  ADD KEY `field_staff_listing_item_target_revision_id` (`field_staff_listing_item_target_revision_id`);

--
-- Indexes for table `paragraph_revision__field_staff_profile`
--
ALTER TABLE `paragraph_revision__field_staff_profile`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_staff_profile_target_id` (`field_staff_profile_target_id`);

--
-- Indexes for table `paragraph_revision__field_start_date`
--
ALTER TABLE `paragraph_revision__field_start_date`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_start_date_value` (`field_start_date_value`);

--
-- Indexes for table `paragraph_revision__field_table_content`
--
ALTER TABLE `paragraph_revision__field_table_content`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_table_data`
--
ALTER TABLE `paragraph_revision__field_table_data`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_table_data_target_id` (`field_table_data_target_id`),
  ADD KEY `field_table_data_target_revision_id` (`field_table_data_target_revision_id`);

--
-- Indexes for table `paragraph_revision__field_tabs`
--
ALTER TABLE `paragraph_revision__field_tabs`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_tabs_target_id` (`field_tabs_target_id`),
  ADD KEY `field_tabs_target_revision_id` (`field_tabs_target_revision_id`);

--
-- Indexes for table `paragraph_revision__field_tab_content`
--
ALTER TABLE `paragraph_revision__field_tab_content`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_tab_content_target_id` (`field_tab_content_target_id`),
  ADD KEY `field_tab_content_target_revision_id` (`field_tab_content_target_revision_id`);

--
-- Indexes for table `paragraph_revision__field_tall_image`
--
ALTER TABLE `paragraph_revision__field_tall_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_tall_image_target_id` (`field_tall_image_target_id`);

--
-- Indexes for table `paragraph_revision__field_textarea`
--
ALTER TABLE `paragraph_revision__field_textarea`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_textarea_format` (`field_textarea_format`);

--
-- Indexes for table `paragraph_revision__field_third_column`
--
ALTER TABLE `paragraph_revision__field_third_column`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_third_column_target_id` (`field_third_column_target_id`),
  ADD KEY `field_third_column_target_revision_id` (`field_third_column_target_revision_id`);

--
-- Indexes for table `paragraph_revision__field_three_column_heading`
--
ALTER TABLE `paragraph_revision__field_three_column_heading`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_title`
--
ALTER TABLE `paragraph_revision__field_title`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_title_accordion_item`
--
ALTER TABLE `paragraph_revision__field_title_accordion_item`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_twitter`
--
ALTER TABLE `paragraph_revision__field_twitter`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_two_columns_wysiwyg`
--
ALTER TABLE `paragraph_revision__field_two_columns_wysiwyg`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_two_columns_wysiwyg_format` (`field_two_columns_wysiwyg_format`);

--
-- Indexes for table `paragraph_revision__field_two_column_heading`
--
ALTER TABLE `paragraph_revision__field_two_column_heading`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_url`
--
ALTER TABLE `paragraph_revision__field_url`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_url_uri` (`field_url_uri`(30));

--
-- Indexes for table `paragraph_revision__field_videos`
--
ALTER TABLE `paragraph_revision__field_videos`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_videos_target_id` (`field_videos_target_id`),
  ADD KEY `field_videos_target_revision_id` (`field_videos_target_revision_id`);

--
-- Indexes for table `paragraph_revision__field_video_description`
--
ALTER TABLE `paragraph_revision__field_video_description`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph_revision__field_view`
--
ALTER TABLE `paragraph_revision__field_view`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_view_target_id` (`field_view_target_id`);

--
-- Indexes for table `paragraph_revision__field_view_ref`
--
ALTER TABLE `paragraph_revision__field_view_ref`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_view_ref_target_id` (`field_view_ref_target_id`);

--
-- Indexes for table `paragraph_revision__field_view_reference`
--
ALTER TABLE `paragraph_revision__field_view_reference`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_view_reference_target_id` (`field_view_reference_target_id`);

--
-- Indexes for table `paragraph_revision__field_webform`
--
ALTER TABLE `paragraph_revision__field_webform`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_webform_target_id` (`field_webform_target_id`);

--
-- Indexes for table `paragraph_revision__field_wide_image`
--
ALTER TABLE `paragraph_revision__field_wide_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_wide_image_target_id` (`field_wide_image_target_id`);

--
-- Indexes for table `paragraph_revision__field_wysiwyg`
--
ALTER TABLE `paragraph_revision__field_wysiwyg`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_wysiwyg_format` (`field_wysiwyg_format`);

--
-- Indexes for table `paragraph_r__02cabf414c`
--
ALTER TABLE `paragraph_r__02cabf414c`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_description_tab_content_format` (`field_description_tab_content_format`);

--
-- Indexes for table `paragraph_r__3fdb9676ba`
--
ALTER TABLE `paragraph_r__3fdb9676ba`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_right_reference_portion_target_id` (`field_right_reference_portion_target_id`),
  ADD KEY `field_right_reference_portion_target_revision_id` (`field_right_reference_portion_target_revision_id`);

--
-- Indexes for table `paragraph_r__9deba02bff`
--
ALTER TABLE `paragraph_r__9deba02bff`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_background_color_contact_value` (`field_background_color_contact_value`(191));

--
-- Indexes for table `paragraph_r__d2ffb90c43`
--
ALTER TABLE `paragraph_r__d2ffb90c43`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_online_tools_and_resources_target_id` (`field_online_tools_and_resources_target_id`),
  ADD KEY `field_online_tools_and_resources_target_revision_id` (`field_online_tools_and_resources_target_revision_id`);

--
-- Indexes for table `paragraph_r__fdc6dca48a`
--
ALTER TABLE `paragraph_r__fdc6dca48a`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_description_accordion_item_format` (`field_description_accordion_item_format`);

--
-- Indexes for table `paragraph__field_accordion_items`
--
ALTER TABLE `paragraph__field_accordion_items`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_accordion_items_target_id` (`field_accordion_items_target_id`),
  ADD KEY `field_accordion_items_target_revision_id` (`field_accordion_items_target_revision_id`);

--
-- Indexes for table `paragraph__field_address`
--
ALTER TABLE `paragraph__field_address`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_address_format` (`field_address_format`);

--
-- Indexes for table `paragraph__field_background_color`
--
ALTER TABLE `paragraph__field_background_color`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_background_color_target_id` (`field_background_color_target_id`);

--
-- Indexes for table `paragraph__field_background_color_contact`
--
ALTER TABLE `paragraph__field_background_color_contact`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_background_color_contact_value` (`field_background_color_contact_value`(191));

--
-- Indexes for table `paragraph__field_background_color_list`
--
ALTER TABLE `paragraph__field_background_color_list`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_background_color_list_value` (`field_background_color_list_value`(191));

--
-- Indexes for table `paragraph__field_button`
--
ALTER TABLE `paragraph__field_button`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_button_uri` (`field_button_uri`(30));

--
-- Indexes for table `paragraph__field_button_text`
--
ALTER TABLE `paragraph__field_button_text`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_caption_text`
--
ALTER TABLE `paragraph__field_caption_text`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_carousal_item`
--
ALTER TABLE `paragraph__field_carousal_item`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_carousal_item_target_id` (`field_carousal_item_target_id`),
  ADD KEY `field_carousal_item_target_revision_id` (`field_carousal_item_target_revision_id`);

--
-- Indexes for table `paragraph__field_columns`
--
ALTER TABLE `paragraph__field_columns`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_columns_target_id` (`field_columns_target_id`),
  ADD KEY `field_columns_target_revision_id` (`field_columns_target_revision_id`);

--
-- Indexes for table `paragraph__field_column_1`
--
ALTER TABLE `paragraph__field_column_1`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_column_2`
--
ALTER TABLE `paragraph__field_column_2`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_column_3`
--
ALTER TABLE `paragraph__field_column_3`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_conent`
--
ALTER TABLE `paragraph__field_conent`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_conent_target_id` (`field_conent_target_id`),
  ADD KEY `field_conent_target_revision_id` (`field_conent_target_revision_id`);

--
-- Indexes for table `paragraph__field_content`
--
ALTER TABLE `paragraph__field_content`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_content_format` (`field_content_format`);

--
-- Indexes for table `paragraph__field_cta_icon`
--
ALTER TABLE `paragraph__field_cta_icon`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_cta_icon_target_id` (`field_cta_icon_target_id`),
  ADD KEY `field_cta_icon_target_revision_id` (`field_cta_icon_target_revision_id`);

--
-- Indexes for table `paragraph__field_department_link`
--
ALTER TABLE `paragraph__field_department_link`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_department_link_uri` (`field_department_link_uri`(30));

--
-- Indexes for table `paragraph__field_department_name`
--
ALTER TABLE `paragraph__field_department_name`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_description`
--
ALTER TABLE `paragraph__field_description`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_description_130`
--
ALTER TABLE `paragraph__field_description_130`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_description_accordion_item`
--
ALTER TABLE `paragraph__field_description_accordion_item`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_description_accordion_item_format` (`field_description_accordion_item_format`);

--
-- Indexes for table `paragraph__field_description_cta_icon`
--
ALTER TABLE `paragraph__field_description_cta_icon`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_description_cta_icon_uri` (`field_description_cta_icon_uri`(30));

--
-- Indexes for table `paragraph__field_description_img_lnks`
--
ALTER TABLE `paragraph__field_description_img_lnks`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_description_otar`
--
ALTER TABLE `paragraph__field_description_otar`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_description_tab_content`
--
ALTER TABLE `paragraph__field_description_tab_content`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_description_tab_content_format` (`field_description_tab_content_format`);

--
-- Indexes for table `paragraph__field_email`
--
ALTER TABLE `paragraph__field_email`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_end_date`
--
ALTER TABLE `paragraph__field_end_date`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_end_date_value` (`field_end_date_value`);

--
-- Indexes for table `paragraph__field_facts`
--
ALTER TABLE `paragraph__field_facts`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_facts_target_id` (`field_facts_target_id`),
  ADD KEY `field_facts_target_revision_id` (`field_facts_target_revision_id`);

--
-- Indexes for table `paragraph__field_fax`
--
ALTER TABLE `paragraph__field_fax`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_field_description_cob`
--
ALTER TABLE `paragraph__field_field_description_cob`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_first_column_`
--
ALTER TABLE `paragraph__field_first_column_`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_first_column__target_id` (`field_first_column__target_id`),
  ADD KEY `field_first_column__target_revision_id` (`field_first_column__target_revision_id`);

--
-- Indexes for table `paragraph__field_font_awesome_icon_name`
--
ALTER TABLE `paragraph__field_font_awesome_icon_name`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_full_name`
--
ALTER TABLE `paragraph__field_full_name`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_gallery_image`
--
ALTER TABLE `paragraph__field_gallery_image`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_gallery_image_target_id` (`field_gallery_image_target_id`);

--
-- Indexes for table `paragraph__field_image`
--
ALTER TABLE `paragraph__field_image`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_target_id` (`field_image_target_id`);

--
-- Indexes for table `paragraph__field_image2`
--
ALTER TABLE `paragraph__field_image2`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image2_target_id` (`field_image2_target_id`);

--
-- Indexes for table `paragraph__field_images`
--
ALTER TABLE `paragraph__field_images`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_images_target_id` (`field_images_target_id`),
  ADD KEY `field_images_target_revision_id` (`field_images_target_revision_id`);

--
-- Indexes for table `paragraph__field_images_with_links`
--
ALTER TABLE `paragraph__field_images_with_links`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_images_with_links_target_id` (`field_images_with_links_target_id`),
  ADD KEY `field_images_with_links_target_revision_id` (`field_images_with_links_target_revision_id`);

--
-- Indexes for table `paragraph__field_image_carousal`
--
ALTER TABLE `paragraph__field_image_carousal`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_carousal_target_id` (`field_image_carousal_target_id`);

--
-- Indexes for table `paragraph__field_image_cob`
--
ALTER TABLE `paragraph__field_image_cob`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_cob_target_id` (`field_image_cob_target_id`);

--
-- Indexes for table `paragraph__field_image_image_slide`
--
ALTER TABLE `paragraph__field_image_image_slide`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_image_slide_target_id` (`field_image_image_slide_target_id`);

--
-- Indexes for table `paragraph__field_image_paragraph`
--
ALTER TABLE `paragraph__field_image_paragraph`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_paragraph_target_id` (`field_image_paragraph_target_id`),
  ADD KEY `field_image_paragraph_target_revision_id` (`field_image_paragraph_target_revision_id`);

--
-- Indexes for table `paragraph__field_image_placement_select`
--
ALTER TABLE `paragraph__field_image_placement_select`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_placement_select_value` (`field_image_placement_select_value`(191));

--
-- Indexes for table `paragraph__field_image_slide`
--
ALTER TABLE `paragraph__field_image_slide`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_slide_target_id` (`field_image_slide_target_id`);

--
-- Indexes for table `paragraph__field_image_with_link`
--
ALTER TABLE `paragraph__field_image_with_link`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_image_with_link_target_id` (`field_image_with_link_target_id`);

--
-- Indexes for table `paragraph__field_link`
--
ALTER TABLE `paragraph__field_link`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_link_uri` (`field_link_uri`(30));

--
-- Indexes for table `paragraph__field_link_single`
--
ALTER TABLE `paragraph__field_link_single`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_link_single_uri` (`field_link_single_uri`(30));

--
-- Indexes for table `paragraph__field_link_without_text`
--
ALTER TABLE `paragraph__field_link_without_text`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_link_without_text_uri` (`field_link_without_text_uri`(30));

--
-- Indexes for table `paragraph__field_media_caption`
--
ALTER TABLE `paragraph__field_media_caption`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_media_reference`
--
ALTER TABLE `paragraph__field_media_reference`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_media_reference_target_id` (`field_media_reference_target_id`);

--
-- Indexes for table `paragraph__field_message_items`
--
ALTER TABLE `paragraph__field_message_items`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_message_items_target_id` (`field_message_items_target_id`),
  ADD KEY `field_message_items_target_revision_id` (`field_message_items_target_revision_id`);

--
-- Indexes for table `paragraph__field_number`
--
ALTER TABLE `paragraph__field_number`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_occupation`
--
ALTER TABLE `paragraph__field_occupation`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_online_tools_and_resources`
--
ALTER TABLE `paragraph__field_online_tools_and_resources`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_online_tools_and_resources_target_id` (`field_online_tools_and_resources_target_id`),
  ADD KEY `field_online_tools_and_resources_target_revision_id` (`field_online_tools_and_resources_target_revision_id`);

--
-- Indexes for table `paragraph__field_phone`
--
ALTER TABLE `paragraph__field_phone`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_profile_occupation`
--
ALTER TABLE `paragraph__field_profile_occupation`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_related_content_item`
--
ALTER TABLE `paragraph__field_related_content_item`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_related_content_item_target_id` (`field_related_content_item_target_id`),
  ADD KEY `field_related_content_item_target_revision_id` (`field_related_content_item_target_revision_id`);

--
-- Indexes for table `paragraph__field_remote_video`
--
ALTER TABLE `paragraph__field_remote_video`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_right_reference_portion`
--
ALTER TABLE `paragraph__field_right_reference_portion`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_right_reference_portion_target_id` (`field_right_reference_portion_target_id`),
  ADD KEY `field_right_reference_portion_target_revision_id` (`field_right_reference_portion_target_revision_id`);

--
-- Indexes for table `paragraph__field_second_column_`
--
ALTER TABLE `paragraph__field_second_column_`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_second_column__target_id` (`field_second_column__target_id`),
  ADD KEY `field_second_column__target_revision_id` (`field_second_column__target_revision_id`);

--
-- Indexes for table `paragraph__field_select_demo`
--
ALTER TABLE `paragraph__field_select_demo`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_select_demo_value` (`field_select_demo_value`);

--
-- Indexes for table `paragraph__field_show_as_header`
--
ALTER TABLE `paragraph__field_show_as_header`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_slide`
--
ALTER TABLE `paragraph__field_slide`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_slide_target_id` (`field_slide_target_id`),
  ADD KEY `field_slide_target_revision_id` (`field_slide_target_revision_id`);

--
-- Indexes for table `paragraph__field_slider_image`
--
ALTER TABLE `paragraph__field_slider_image`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_slider_image_target_id` (`field_slider_image_target_id`);

--
-- Indexes for table `paragraph__field_slider_image_alignment`
--
ALTER TABLE `paragraph__field_slider_image_alignment`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_slider_image_alignment_value` (`field_slider_image_alignment_value`(191));

--
-- Indexes for table `paragraph__field_slideshow_images`
--
ALTER TABLE `paragraph__field_slideshow_images`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_slideshow_images_target_id` (`field_slideshow_images_target_id`);

--
-- Indexes for table `paragraph__field_slide_description`
--
ALTER TABLE `paragraph__field_slide_description`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_slide_description_format` (`field_slide_description_format`);

--
-- Indexes for table `paragraph__field_slide_image`
--
ALTER TABLE `paragraph__field_slide_image`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_slide_image_target_id` (`field_slide_image_target_id`);

--
-- Indexes for table `paragraph__field_small_image`
--
ALTER TABLE `paragraph__field_small_image`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_small_image_target_id` (`field_small_image_target_id`);

--
-- Indexes for table `paragraph__field_staff_listing_item`
--
ALTER TABLE `paragraph__field_staff_listing_item`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_staff_listing_item_target_id` (`field_staff_listing_item_target_id`),
  ADD KEY `field_staff_listing_item_target_revision_id` (`field_staff_listing_item_target_revision_id`);

--
-- Indexes for table `paragraph__field_staff_profile`
--
ALTER TABLE `paragraph__field_staff_profile`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_staff_profile_target_id` (`field_staff_profile_target_id`);

--
-- Indexes for table `paragraph__field_start_date`
--
ALTER TABLE `paragraph__field_start_date`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_start_date_value` (`field_start_date_value`);

--
-- Indexes for table `paragraph__field_table_content`
--
ALTER TABLE `paragraph__field_table_content`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_table_data`
--
ALTER TABLE `paragraph__field_table_data`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_table_data_target_id` (`field_table_data_target_id`),
  ADD KEY `field_table_data_target_revision_id` (`field_table_data_target_revision_id`);

--
-- Indexes for table `paragraph__field_tabs`
--
ALTER TABLE `paragraph__field_tabs`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_tabs_target_id` (`field_tabs_target_id`),
  ADD KEY `field_tabs_target_revision_id` (`field_tabs_target_revision_id`);

--
-- Indexes for table `paragraph__field_tab_content`
--
ALTER TABLE `paragraph__field_tab_content`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_tab_content_target_id` (`field_tab_content_target_id`),
  ADD KEY `field_tab_content_target_revision_id` (`field_tab_content_target_revision_id`);

--
-- Indexes for table `paragraph__field_tall_image`
--
ALTER TABLE `paragraph__field_tall_image`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_tall_image_target_id` (`field_tall_image_target_id`);

--
-- Indexes for table `paragraph__field_textarea`
--
ALTER TABLE `paragraph__field_textarea`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_textarea_format` (`field_textarea_format`);

--
-- Indexes for table `paragraph__field_third_column`
--
ALTER TABLE `paragraph__field_third_column`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_third_column_target_id` (`field_third_column_target_id`),
  ADD KEY `field_third_column_target_revision_id` (`field_third_column_target_revision_id`);

--
-- Indexes for table `paragraph__field_three_column_heading`
--
ALTER TABLE `paragraph__field_three_column_heading`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_title`
--
ALTER TABLE `paragraph__field_title`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_title_accordion_item`
--
ALTER TABLE `paragraph__field_title_accordion_item`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_twitter`
--
ALTER TABLE `paragraph__field_twitter`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_two_columns_wysiwyg`
--
ALTER TABLE `paragraph__field_two_columns_wysiwyg`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_two_columns_wysiwyg_format` (`field_two_columns_wysiwyg_format`);

--
-- Indexes for table `paragraph__field_two_column_heading`
--
ALTER TABLE `paragraph__field_two_column_heading`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_url`
--
ALTER TABLE `paragraph__field_url`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_url_uri` (`field_url_uri`(30));

--
-- Indexes for table `paragraph__field_videos`
--
ALTER TABLE `paragraph__field_videos`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_videos_target_id` (`field_videos_target_id`),
  ADD KEY `field_videos_target_revision_id` (`field_videos_target_revision_id`);

--
-- Indexes for table `paragraph__field_video_description`
--
ALTER TABLE `paragraph__field_video_description`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `paragraph__field_view`
--
ALTER TABLE `paragraph__field_view`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_view_target_id` (`field_view_target_id`);

--
-- Indexes for table `paragraph__field_view_ref`
--
ALTER TABLE `paragraph__field_view_ref`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_view_ref_target_id` (`field_view_ref_target_id`);

--
-- Indexes for table `paragraph__field_view_reference`
--
ALTER TABLE `paragraph__field_view_reference`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_view_reference_target_id` (`field_view_reference_target_id`);

--
-- Indexes for table `paragraph__field_webform`
--
ALTER TABLE `paragraph__field_webform`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_webform_target_id` (`field_webform_target_id`);

--
-- Indexes for table `paragraph__field_wide_image`
--
ALTER TABLE `paragraph__field_wide_image`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_wide_image_target_id` (`field_wide_image_target_id`);

--
-- Indexes for table `paragraph__field_wysiwyg`
--
ALTER TABLE `paragraph__field_wysiwyg`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_wysiwyg_format` (`field_wysiwyg_format`);

--
-- Indexes for table `path_alias`
--
ALTER TABLE `path_alias`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `path_alias_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `path_alias__revision_id` (`revision_id`),
  ADD KEY `path_alias__alias_langcode_id_status` (`alias`(191),`langcode`,`id`,`status`),
  ADD KEY `path_alias__path_langcode_id_status` (`path`(191),`langcode`,`id`,`status`);

--
-- Indexes for table `path_alias_revision`
--
ALTER TABLE `path_alias_revision`
  ADD PRIMARY KEY (`revision_id`),
  ADD KEY `path_alias__id` (`id`);

--
-- Indexes for table `queue`
--
ALTER TABLE `queue`
  ADD PRIMARY KEY (`item_id`),
  ADD KEY `name_created` (`name`,`created`),
  ADD KEY `expire` (`expire`);

--
-- Indexes for table `redirect`
--
ALTER TABLE `redirect`
  ADD PRIMARY KEY (`rid`),
  ADD UNIQUE KEY `redirect_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `hash` (`hash`),
  ADD KEY `redirect_field__uid__target_id` (`uid`),
  ADD KEY `redirect_field__redirect_source__path` (`redirect_source__path`(50)),
  ADD KEY `redirect_field__redirect_redirect__uri` (`redirect_redirect__uri`(30)),
  ADD KEY `source_language` (`redirect_source__path`(191),`language`);

--
-- Indexes for table `router`
--
ALTER TABLE `router`
  ADD PRIMARY KEY (`name`),
  ADD KEY `pattern_outline_parts` (`pattern_outline`(191),`number_parts`);

--
-- Indexes for table `search_api_db_db_search`
--
ALTER TABLE `search_api_db_db_search`
  ADD PRIMARY KEY (`item_id`),
  ADD KEY `_body` (`body`(10)),
  ADD KEY `_field_content` (`field_content`),
  ADD KEY `_field_description` (`field_description`(10)),
  ADD KEY `_field_description_1` (`field_description_1`(10)),
  ADD KEY `_field_description_tab_content` (`field_description_tab_content`(10)),
  ADD KEY `_field_field_description_cob` (`field_field_description_cob`(10)),
  ADD KEY `_field_first_column_` (`field_first_column_`),
  ADD KEY `_field_second_column_` (`field_second_column_`),
  ADD KEY `_field_textarea` (`field_textarea`(10)),
  ADD KEY `_field_textarea_1` (`field_textarea_1`(10)),
  ADD KEY `_field_third_column` (`field_third_column`(10)),
  ADD KEY `_field_three_column_heading` (`field_three_column_heading`(10)),
  ADD KEY `_field_title` (`field_title`(10)),
  ADD KEY `_field_title_1` (`field_title_1`(10)),
  ADD KEY `_field_title_accordion_item` (`field_title_accordion_item`(10)),
  ADD KEY `_field_two_column_heading` (`field_two_column_heading`(10)),
  ADD KEY `_field_two_columns_wysiwyg` (`field_two_columns_wysiwyg`(10)),
  ADD KEY `_field_wysiwyg` (`field_wysiwyg`(10)),
  ADD KEY `_status` (`status`),
  ADD KEY `_title` (`title`(10)),
  ADD KEY `_type` (`type`(10)),
  ADD KEY `_search_api_datasource` (`search_api_datasource`(10)),
  ADD KEY `_search_api_language` (`search_api_language`(10));

--
-- Indexes for table `search_api_db_db_search_field_content`
--
ALTER TABLE `search_api_db_db_search_field_content`
  ADD PRIMARY KEY (`item_id`,`value`),
  ADD KEY `_value` (`value`);

--
-- Indexes for table `search_api_db_db_search_field_description_1`
--
ALTER TABLE `search_api_db_db_search_field_description_1`
  ADD PRIMARY KEY (`item_id`,`value`),
  ADD KEY `_value` (`value`(10));

--
-- Indexes for table `search_api_db_db_search_field_field_description_cob`
--
ALTER TABLE `search_api_db_db_search_field_field_description_cob`
  ADD PRIMARY KEY (`item_id`,`value`),
  ADD KEY `_value` (`value`(10));

--
-- Indexes for table `search_api_db_db_search_field_first_column_`
--
ALTER TABLE `search_api_db_db_search_field_first_column_`
  ADD PRIMARY KEY (`item_id`,`value`),
  ADD KEY `_value` (`value`);

--
-- Indexes for table `search_api_db_db_search_field_second_column_`
--
ALTER TABLE `search_api_db_db_search_field_second_column_`
  ADD PRIMARY KEY (`item_id`,`value`),
  ADD KEY `_value` (`value`);

--
-- Indexes for table `search_api_db_db_search_field_two_column_heading`
--
ALTER TABLE `search_api_db_db_search_field_two_column_heading`
  ADD PRIMARY KEY (`item_id`,`value`),
  ADD KEY `_value` (`value`(10));

--
-- Indexes for table `search_api_db_db_search_search_api_datasource`
--
ALTER TABLE `search_api_db_db_search_search_api_datasource`
  ADD PRIMARY KEY (`item_id`,`value`),
  ADD KEY `_value` (`value`(10));

--
-- Indexes for table `search_api_db_db_search_search_api_language`
--
ALTER TABLE `search_api_db_db_search_search_api_language`
  ADD PRIMARY KEY (`item_id`,`value`),
  ADD KEY `_value` (`value`(10));

--
-- Indexes for table `search_api_db_db_search_status`
--
ALTER TABLE `search_api_db_db_search_status`
  ADD PRIMARY KEY (`item_id`,`value`),
  ADD KEY `_value` (`value`);

--
-- Indexes for table `search_api_db_db_search_text`
--
ALTER TABLE `search_api_db_db_search_text`
  ADD PRIMARY KEY (`item_id`,`field_name`,`word`),
  ADD KEY `word_field` (`word`(20),`field_name`);

--
-- Indexes for table `search_api_db_db_search_type`
--
ALTER TABLE `search_api_db_db_search_type`
  ADD PRIMARY KEY (`item_id`,`value`),
  ADD KEY `_value` (`value`(10));

--
-- Indexes for table `search_api_item`
--
ALTER TABLE `search_api_item`
  ADD PRIMARY KEY (`index_id`,`item_id`),
  ADD KEY `indexing` (`index_id`,`status`,`changed`,`item_id`);

--
-- Indexes for table `search_api_task`
--
ALTER TABLE `search_api_task`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `semaphore`
--
ALTER TABLE `semaphore`
  ADD PRIMARY KEY (`name`),
  ADD KEY `value` (`value`),
  ADD KEY `expire` (`expire`);

--
-- Indexes for table `sequences`
--
ALTER TABLE `sequences`
  ADD PRIMARY KEY (`value`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`sid`),
  ADD KEY `timestamp` (`timestamp`),
  ADD KEY `uid` (`uid`);

--
-- Indexes for table `shortcut`
--
ALTER TABLE `shortcut`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `shortcut_field__uuid__value` (`uuid`),
  ADD KEY `shortcut_field__shortcut_set__target_id` (`shortcut_set`);

--
-- Indexes for table `shortcut_field_data`
--
ALTER TABLE `shortcut_field_data`
  ADD PRIMARY KEY (`id`,`langcode`),
  ADD KEY `shortcut__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
  ADD KEY `shortcut_field__shortcut_set__target_id` (`shortcut_set`),
  ADD KEY `shortcut_field__link__uri` (`link__uri`(30));

--
-- Indexes for table `shortcut_set_users`
--
ALTER TABLE `shortcut_set_users`
  ADD PRIMARY KEY (`uid`),
  ADD KEY `set_name` (`set_name`);

--
-- Indexes for table `simple_sitemap`
--
ALTER TABLE `simple_sitemap`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type_status_delta` (`type`,`status`,`delta`);

--
-- Indexes for table `simple_sitemap_entity_overrides`
--
ALTER TABLE `simple_sitemap_entity_overrides`
  ADD PRIMARY KEY (`id`),
  ADD KEY `entity_key` (`type`,`entity_type`,`entity_id`);

--
-- Indexes for table `taxonomy_index`
--
ALTER TABLE `taxonomy_index`
  ADD PRIMARY KEY (`nid`,`tid`),
  ADD KEY `term_node` (`tid`,`status`,`sticky`,`created`);

--
-- Indexes for table `taxonomy_term_data`
--
ALTER TABLE `taxonomy_term_data`
  ADD PRIMARY KEY (`tid`),
  ADD UNIQUE KEY `taxonomy_term_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `taxonomy_term__revision_id` (`revision_id`),
  ADD KEY `taxonomy_term_field__vid__target_id` (`vid`);

--
-- Indexes for table `taxonomy_term_field_data`
--
ALTER TABLE `taxonomy_term_field_data`
  ADD PRIMARY KEY (`tid`,`langcode`),
  ADD KEY `taxonomy_term__id__default_langcode__langcode` (`tid`,`default_langcode`,`langcode`),
  ADD KEY `taxonomy_term__revision_id` (`revision_id`),
  ADD KEY `taxonomy_term_field__name` (`name`(191)),
  ADD KEY `taxonomy_term__status_vid` (`status`,`vid`,`tid`),
  ADD KEY `taxonomy_term__tree` (`vid`,`weight`,`name`(191)),
  ADD KEY `taxonomy_term__vid_name` (`vid`,`name`(191));

--
-- Indexes for table `taxonomy_term_field_revision`
--
ALTER TABLE `taxonomy_term_field_revision`
  ADD PRIMARY KEY (`revision_id`,`langcode`),
  ADD KEY `taxonomy_term__id__default_langcode__langcode` (`tid`,`default_langcode`,`langcode`),
  ADD KEY `taxonomy_term_field__description__format` (`description__format`);

--
-- Indexes for table `taxonomy_term_revision`
--
ALTER TABLE `taxonomy_term_revision`
  ADD PRIMARY KEY (`revision_id`),
  ADD KEY `taxonomy_term__tid` (`tid`),
  ADD KEY `taxonomy_term_field__revision_user__target_id` (`revision_user`);

--
-- Indexes for table `taxonomy_term_revision__parent`
--
ALTER TABLE `taxonomy_term_revision__parent`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `parent_target_id` (`parent_target_id`);

--
-- Indexes for table `taxonomy_term__parent`
--
ALTER TABLE `taxonomy_term__parent`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `parent_target_id` (`parent_target_id`),
  ADD KEY `bundle_delta_target_id` (`bundle`,`delta`,`parent_target_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`uid`),
  ADD UNIQUE KEY `user_field__uuid__value` (`uuid`);

--
-- Indexes for table `users_data`
--
ALTER TABLE `users_data`
  ADD PRIMARY KEY (`uid`,`module`,`name`),
  ADD KEY `module` (`module`),
  ADD KEY `name` (`name`);

--
-- Indexes for table `user__field_user_id`
--
ALTER TABLE `user__field_user_id`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

--
-- Indexes for table `user__roles`
--
ALTER TABLE `user__roles`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `roles_target_id` (`roles_target_id`);

--
-- Indexes for table `user__user_picture`
--
ALTER TABLE `user__user_picture`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `user_picture_target_id` (`user_picture_target_id`);

--
-- Indexes for table `watchdog`
--
ALTER TABLE `watchdog`
  ADD PRIMARY KEY (`wid`),
  ADD KEY `type` (`type`),
  ADD KEY `uid` (`uid`),
  ADD KEY `severity` (`severity`);

--
-- Indexes for table `webform`
--
ALTER TABLE `webform`
  ADD PRIMARY KEY (`webform_id`,`next_serial`);

--
-- Indexes for table `webform_submission`
--
ALTER TABLE `webform_submission`
  ADD PRIMARY KEY (`sid`),
  ADD UNIQUE KEY `webform_submission_field__uuid__value` (`uuid`),
  ADD KEY `webform_submission_field__webform_id__target_id` (`webform_id`),
  ADD KEY `webform_submission_field__uid__target_id` (`uid`),
  ADD KEY `webform_submission_field__token` (`token`(191));

--
-- Indexes for table `webform_submission_data`
--
ALTER TABLE `webform_submission_data`
  ADD PRIMARY KEY (`sid`,`name`,`property`,`delta`),
  ADD KEY `webform_id` (`webform_id`),
  ADD KEY `sid_webform_id` (`sid`,`webform_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `batch`
--
ALTER TABLE `batch`
  MODIFY `bid` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique batch ID.', AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `block_content`
--
ALTER TABLE `block_content`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `block_content_revision`
--
ALTER TABLE `block_content_revision`
  MODIFY `revision_id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `comment`
--
ALTER TABLE `comment`
  MODIFY `cid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_moderation_state`
--
ALTER TABLE `content_moderation_state`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `content_moderation_state_revision`
--
ALTER TABLE `content_moderation_state_revision`
  MODIFY `revision_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `crop`
--
ALTER TABLE `crop`
  MODIFY `cid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `crop_revision`
--
ALTER TABLE `crop_revision`
  MODIFY `vid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `datashare_list`
--
ALTER TABLE `datashare_list`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Holds the id value';

--
-- AUTO_INCREMENT for table `file_managed`
--
ALTER TABLE `file_managed`
  MODIFY `fid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `flood`
--
ALTER TABLE `flood`
  MODIFY `fid` int NOT NULL AUTO_INCREMENT COMMENT 'Unique flood event ID.', AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `help_search_items`
--
ALTER TABLE `help_search_items`
  MODIFY `sid` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Numeric index of this item in the search index', AUTO_INCREMENT=86;

--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
  MODIFY `mid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `media_revision`
--
ALTER TABLE `media_revision`
  MODIFY `vid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `menu_link_content`
--
ALTER TABLE `menu_link_content`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `menu_link_content_revision`
--
ALTER TABLE `menu_link_content_revision`
  MODIFY `revision_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `menu_tree`
--
ALTER TABLE `menu_tree`
  MODIFY `mlid` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'The menu link ID (mlid) is the integer primary key.', AUTO_INCREMENT=631;

--
-- AUTO_INCREMENT for table `node`
--
ALTER TABLE `node`
  MODIFY `nid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `node_revision`
--
ALTER TABLE `node_revision`
  MODIFY `vid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `paragraphs_item`
--
ALTER TABLE `paragraphs_item`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `paragraphs_item_revision`
--
ALTER TABLE `paragraphs_item_revision`
  MODIFY `revision_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `path_alias`
--
ALTER TABLE `path_alias`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `path_alias_revision`
--
ALTER TABLE `path_alias_revision`
  MODIFY `revision_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `queue`
--
ALTER TABLE `queue`
  MODIFY `item_id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique item ID.', AUTO_INCREMENT=187;

--
-- AUTO_INCREMENT for table `redirect`
--
ALTER TABLE `redirect`
  MODIFY `rid` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `search_api_task`
--
ALTER TABLE `search_api_task`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `sequences`
--
ALTER TABLE `sequences`
  MODIFY `value` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'The value of the sequence.';

--
-- AUTO_INCREMENT for table `shortcut`
--
ALTER TABLE `shortcut`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `simple_sitemap`
--
ALTER TABLE `simple_sitemap`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Sitemap chunk unique identifier.', AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `simple_sitemap_entity_overrides`
--
ALTER TABLE `simple_sitemap_entity_overrides`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Override unique identifier.';

--
-- AUTO_INCREMENT for table `taxonomy_term_data`
--
ALTER TABLE `taxonomy_term_data`
  MODIFY `tid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `taxonomy_term_revision`
--
ALTER TABLE `taxonomy_term_revision`
  MODIFY `revision_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `uid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `watchdog`
--
ALTER TABLE `watchdog`
  MODIFY `wid` bigint NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique watchdog event ID.', AUTO_INCREMENT=6173;

--
-- AUTO_INCREMENT for table `webform_submission`
--
ALTER TABLE `webform_submission`
  MODIFY `sid` int NOT NULL AUTO_INCREMENT;
COMMIT;

