INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(42773, 3, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 24984 characters], 3, '', 'https://www.hppcl.gcs-us.com/', '', '169.149.231.90', 1700564952);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(42774, 3, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 24984 characters], 3, '', 'https://www.hppcl.gcs-us.com/', '', '169.149.231.90', 1700564952);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(42775, 3, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 24984 characters], 3, '', 'https://www.hppcl.gcs-us.com/', '', '169.149.231.90', 1700564952),
(42776, 0, 'cron', 'Starting execution of @module_cron().', 0x613a313a7b733a373a22406d6f64756c65223b733a373a2263617074636861223b7d, 6, '', 'https://www.hppcl.gcs-us.com/', '', '169.149.231.90', 1700564953),
(42777, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a373a22636f6d6d656e74223b733a31363a22406d6f64756c655f70726576696f7573223b733a373a2263617074636861223b733a353a224074696d65223b733a363a22302e36326d73223b7d, 6, '', 'https://www.hppcl.gcs-us.com/', '', '169.149.231.90', 1700564953),
(42778, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a353a2264626c6f67223b733a31363a22406d6f64756c655f70726576696f7573223b733a373a22636f6d6d656e74223b733a353a224074696d65223b733a363a22312e39356d73223b7d, 6, '', 'https://www.hppcl.gcs-us.com/', '', '169.149.231.90', 1700564953),
(42779, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a353a226669656c64223b733a31363a22406d6f64756c655f70726576696f7573223b733a353a2264626c6f67223b733a353a224074696d65223b733a383a223138332e36326d73223b7d, 6, '', 'https://www.hppcl.gcs-us.com/', '', '169.149.231.90', 1700564953),
(42780, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a343a2266696c65223b733a31363a22406d6f64756c655f70726576696f7573223b733a353a226669656c64223b733a353a224074696d65223b733a333a22376d73223b7d, 6, '', 'https://www.hppcl.gcs-us.com/', '', '169.149.231.90', 1700564953),
(42781, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a373a22686973746f7279223b733a31363a22406d6f64756c655f70726576696f7573223b733a343a2266696c65223b733a353a224074696d65223b733a333a22316d73223b7d, 6, '', 'https://www.hppcl.gcs-us.com/', '', '169.149.231.90', 1700564953),
(42782, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a383a22686f6e6579706f74223b733a31363a22406d6f64756c655f70726576696f7573223b733a373a22686973746f7279223b733a353a224074696d65223b733a363a22302e33316d73223b7d, 6, '', 'https://www.hppcl.gcs-us.com/', '', '169.149.231.90', 1700564953),
(42783, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a363a226c6f63616c65223b733a31363a22406d6f64756c655f70726576696f7573223b733a383a22686f6e6579706f74223b733a353a224074696d65223b733a363a22302e39386d73223b7d, 6, '', 'https://www.hppcl.gcs-us.com/', '', '169.149.231.90', 1700564953),
(42784, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a343a226e6f6465223b733a31363a22406d6f64756c655f70726576696f7573223b733a363a226c6f63616c65223b733a353a224074696d65223b733a363a22302e30326d73223b7d, 6, '', 'https://www.hppcl.gcs-us.com/', '', '169.149.231.90', 1700564953),
(42785, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a393a227363686564756c6572223b733a31363a22406d6f64756c655f70726576696f7573223b733a343a226e6f6465223b733a353a224074696d65223b733a353a22322e386d73223b7d, 6, '', 'https://www.hppcl.gcs-us.com/', '', '169.149.231.90', 1700564953),
(42786, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a363a22736561726368223b733a31363a22406d6f64756c655f70726576696f7573223b733a393a227363686564756c6572223b733a353a224074696d65223b733a333a22396d73223b7d, 6, '', 'https://www.hppcl.gcs-us.com/', '', '169.149.231.90', 1700564953),
(42787, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a363a2273797374656d223b733a31363a22406d6f64756c655f70726576696f7573223b733a363a22736561726368223b733a353a224074696d65223b733a383a223138302e33386d73223b7d, 6, '', 'https://www.hppcl.gcs-us.com/', '', '169.149.231.90', 1700564953),
(42788, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a363a22757064617465223b733a31363a22406d6f64756c655f70726576696f7573223b733a363a2273797374656d223b733a353a224074696d65223b733a373a2233312e36326d73223b7d, 6, '', 'https://www.hppcl.gcs-us.com/', '', '169.149.231.90', 1700564953),
(42789, 0, 'cron', 'Attempting to re-run cron while it is already running.', 0x613a303a7b7d, 4, '', 'https://www.hppcl.gcs-us.com/themes/custom/hppcl/assets/jquery-ui-1.11.4/jquery-ui.css', 'https://www.hppcl.gcs-us.com/themes/custom/hppcl/css/style.css?s4gx9l', '169.149.231.90', 1700564954),
(42790, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a383a2276697369746f7273223b733a31363a22406d6f64756c655f70726576696f7573223b733a363a22757064617465223b733a353a224074696d65223b733a393a22323539342e39336d73223b7d, 6, '', 'https://www.hppcl.gcs-us.com/', '', '169.149.231.90', 1700564956),
(42791, 0, 'cron', 'Execution of @module_previous_cron() took @time.', 0x613a323a7b733a31363a22406d6f64756c655f70726576696f7573223b733a383a2276697369746f7273223b733a353a224074696d65223b733a363a22352e31366d73223b7d, 6, '', 'https://www.hppcl.gcs-us.com/', '', '169.149.231.90', 1700564956),
(42792, 0, 'cron', 'Cron run completed.', 0x613a303a7b7d, 6, '', 'https://www.hppcl.gcs-us.com/', '', '169.149.231.90', 1700564956);

--
-- 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__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_slider`
--
ALTER TABLE `block_content_revision__field_slider`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_slider_target_id` (`field_slider_target_id`),
  ADD KEY `field_slider_target_revision_id` (`field_slider_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_slider`
--
ALTER TABLE `block_content__field_slider`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_slider_target_id` (`field_slider_target_id`),
  ADD KEY `field_slider_target_revision_id` (`field_slider_target_revision_id`);

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

--
-- 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_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 `captcha_sessions`
--
ALTER TABLE `captcha_sessions`
  ADD PRIMARY KEY (`csid`),
  ADD KEY `csid_ip` (`csid`,`ip_address`);

--
-- 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_snapshot`
--
ALTER TABLE `config_snapshot`
  ADD PRIMARY KEY (`collection`,`name`);

--
-- Indexes for table `contact_message`
--
ALTER TABLE `contact_message`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `contact_message_field__uuid__value` (`uuid`),
  ADD KEY `contact_message_field__contact_form__target_id` (`contact_form`),
  ADD KEY `contact_message_field__recipient__target_id` (`recipient`),
  ADD KEY `contact_message_field__uid__target_id` (`uid`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `counter`
--
ALTER TABLE `counter`
  ADD PRIMARY KEY (`counter_id`),
  ADD KEY `uid` (`uid`),
  ADD KEY `nid` (`nid`),
  ADD KEY `ip` (`ip`),
  ADD KEY `created` (`created`);

--
-- 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 `history`
--
ALTER TABLE `history`
  ADD PRIMARY KEY (`uid`,`nid`),
  ADD KEY `nid` (`nid`);

--
-- Indexes for table `honeypot_user`
--
ALTER TABLE `honeypot_user`
  ADD KEY `uid` (`uid`),
  ADD KEY `timestamp` (`timestamp`);

--
-- 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 `locales_location`
--
ALTER TABLE `locales_location`
  ADD PRIMARY KEY (`lid`),
  ADD KEY `string_type` (`sid`,`type`);

--
-- Indexes for table `locales_source`
--
ALTER TABLE `locales_source`
  ADD PRIMARY KEY (`lid`),
  ADD KEY `source_context` (`source`(30),`context`);

--
-- Indexes for table `locales_target`
--
ALTER TABLE `locales_target`
  ADD PRIMARY KEY (`language`,`lid`),
  ADD KEY `lid` (`lid`);

--
-- Indexes for table `locale_file`
--
ALTER TABLE `locale_file`
  ADD PRIMARY KEY (`project`,`langcode`);

--
-- 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_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__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 `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`),
  ADD KEY `menu_link_content__c97403a52f` (`content_translation_uid`);

--
-- 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)),
  ADD KEY `menu_link_content__c97403a52f` (`content_translation_uid`);

--
-- 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_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 `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__comment`
--
ALTER TABLE `node_revision__comment`
  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_a`
--
ALTER TABLE `node_revision__field_a`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_a_target_id` (`field_a_target_id`),
  ADD KEY `field_a_target_revision_id` (`field_a_target_revision_id`);

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

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

--
-- Indexes for table `node_revision__field_basin`
--
ALTER TABLE `node_revision__field_basin`
  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_brand_image`
--
ALTER TABLE `node_revision__field_brand_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_brand_image_target_id` (`field_brand_image_target_id`),
  ADD KEY `field_brand_image_target_revision_id` (`field_brand_image_target_revision_id`);

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

--
-- Indexes for table `node_revision__field_cod`
--
ALTER TABLE `node_revision__field_cod`
  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_person`
--
ALTER TABLE `node_revision__field_contact_person`
  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_project_offices`
--
ALTER TABLE `node_revision__field_contact_project_offices`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_contact_project_offices_format` (`field_contact_project_offices_format`);

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

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

--
-- Indexes for table `node_revision__field_curriggendum`
--
ALTER TABLE `node_revision__field_curriggendum`
  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_designation_`
--
ALTER TABLE `node_revision__field_designation_`
  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_email_id`
--
ALTER TABLE `node_revision__field_email_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_emd`
--
ALTER TABLE `node_revision__field_emd`
  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_estimated_cost`
--
ALTER TABLE `node_revision__field_estimated_cost`
  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_expiry_date`
--
ALTER TABLE `node_revision__field_expiry_date`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_expiry_date_value` (`field_expiry_date_value`);

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

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

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

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

--
-- Indexes for table `node_revision__field_image`
--
ALTER TABLE `node_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 `node_revision__field_installed_capacity`
--
ALTER TABLE `node_revision__field_installed_capacity`
  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_layout_model`
--
ALTER TABLE `node_revision__field_layout_model`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_layout_model_target_id` (`field_layout_model_target_id`);

--
-- Indexes for table `node_revision__field_listing_location`
--
ALTER TABLE `node_revision__field_listing_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_listing_order`
--
ALTER TABLE `node_revision__field_listing_order`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_listing_order_value` (`field_listing_order_value`);

--
-- 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`),
  ADD KEY `field_location_format` (`field_location_format`);

--
-- Indexes for table `node_revision__field_mobile_no`
--
ALTER TABLE `node_revision__field_mobile_no`
  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_monthly_compliance_reports`
--
ALTER TABLE `node_revision__field_monthly_compliance_reports`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_monthly_compliance_reports_target_id` (`field_monthly_compliance_reports_target_id`),
  ADD KEY `field_monthly_compliance_reports_target_revision_id` (`field_monthly_compliance_reports_target_revision_id`);

--
-- Indexes for table `node_revision__field_news_end_date`
--
ALTER TABLE `node_revision__field_news_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_news_end_date_value` (`field_news_end_date_value`);

--
-- Indexes for table `node_revision__field_news_start_date`
--
ALTER TABLE `node_revision__field_news_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_news_start_date_value` (`field_news_start_date_value`);

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

--
-- Indexes for table `node_revision__field_phone_no`
--
ALTER TABLE `node_revision__field_phone_no`
  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_profile`
--
ALTER TABLE `node_revision__field_profile`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_profile_target_id` (`field_profile_target_id`);

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

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

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

--
-- Indexes for table `node_revision__field_river_tributary`
--
ALTER TABLE `node_revision__field_river_tributary`
  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_rti_pdf`
--
ALTER TABLE `node_revision__field_rti_pdf`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_rti_pdf_target_id` (`field_rti_pdf_target_id`);

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

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

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

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

--
-- Indexes for table `node_revision__field_tender_reference_number`
--
ALTER TABLE `node_revision__field_tender_reference_number`
  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_unit_size`
--
ALTER TABLE `node_revision__field_unit_size`
  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_uploaded_file`
--
ALTER TABLE `node_revision__field_uploaded_file`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_uploaded_file_target_id` (`field_uploaded_file_target_id`);

--
-- Indexes for table `node_revision__field_vacancies_`
--
ALTER TABLE `node_revision__field_vacancies_`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_vacancies__target_id` (`field_vacancies__target_id`),
  ADD KEY `field_vacancies__target_revision_id` (`field_vacancies__target_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`),
  ADD KEY `field_video_target_id` (`field_video_target_id`);

--
-- Indexes for table `node_revision__field_video_url`
--
ALTER TABLE `node_revision__field_video_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_view_profile`
--
ALTER TABLE `node_revision__field_view_profile`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_view_profile_uri` (`field_view_profile_uri`(30));

--
-- 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__comment`
--
ALTER TABLE `node__comment`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `node__field_image`
--
ALTER TABLE `node__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 `node__field_installed_capacity`
--
ALTER TABLE `node__field_installed_capacity`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

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

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

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

--
-- 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`),
  ADD KEY `field_location_format` (`field_location_format`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `node__field_vacancies_`
--
ALTER TABLE `node__field_vacancies_`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_vacancies__target_id` (`field_vacancies__target_id`),
  ADD KEY `field_vacancies__target_revision_id` (`field_vacancies__target_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`),
  ADD KEY `field_video_target_id` (`field_video_target_id`);

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

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

--
-- 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_appellate_authority`
--
ALTER TABLE `paragraph_revision__field_appellate_authority`
  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_apr_file`
--
ALTER TABLE `paragraph_revision__field_apr_file`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_apr_file_target_id` (`field_apr_file_target_id`);

--
-- Indexes for table `paragraph_revision__field_apr_name`
--
ALTER TABLE `paragraph_revision__field_apr_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_brand_image`
--
ALTER TABLE `paragraph_revision__field_brand_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_brand_image_target_id` (`field_brand_image_target_id`);

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

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

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

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

--
-- 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`),
  ADD KEY `field_description_format` (`field_description_format`);

--
-- Indexes for table `paragraph_revision__field_designation`
--
ALTER TABLE `paragraph_revision__field_designation`
  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_document`
--
ALTER TABLE `paragraph_revision__field_document`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_document_target_id` (`field_document_target_id`);

--
-- Indexes for table `paragraph_revision__field_download`
--
ALTER TABLE `paragraph_revision__field_download`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_download_target_id` (`field_download_target_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_extended_date`
--
ALTER TABLE `paragraph_revision__field_extended_date`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_extended_date_value` (`field_extended_date_value`);

--
-- Indexes for table `paragraph_revision__field_fax_phone`
--
ALTER TABLE `paragraph_revision__field_fax_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_file`
--
ALTER TABLE `paragraph_revision__field_file`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_file_target_id` (`field_file_target_id`);

--
-- Indexes for table `paragraph_revision__field_free_commercial`
--
ALTER TABLE `paragraph_revision__field_free_commercial`
  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_gallery_image_category`
--
ALTER TABLE `paragraph_revision__field_gallery_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_gallery_image_category_target_id` (`field_gallery_image_category_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_iss`
--
ALTER TABLE `paragraph_revision__field_iss`
  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_link_1`
--
ALTER TABLE `paragraph_revision__field_link_1`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_link_1_uri` (`field_link_1_uri`(30));

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

--
-- Indexes for table `paragraph_revision__field_mobile_no`
--
ALTER TABLE `paragraph_revision__field_mobile_no`
  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_mon`
--
ALTER TABLE `paragraph_revision__field_mon`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_mon_target_id` (`field_mon_target_id`);

--
-- Indexes for table `paragraph_revision__field_name`
--
ALTER TABLE `paragraph_revision__field_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_name_of_wings_unit`
--
ALTER TABLE `paragraph_revision__field_name_of_wings_unit`
  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_newsletter_description`
--
ALTER TABLE `paragraph_revision__field_newsletter_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_newsletter_file`
--
ALTER TABLE `paragraph_revision__field_newsletter_file`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_newsletter_file_target_id` (`field_newsletter_file_target_id`);

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

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

--
-- Indexes for table `paragraph_revision__field_order_description`
--
ALTER TABLE `paragraph_revision__field_order_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_order_no`
--
ALTER TABLE `paragraph_revision__field_order_no`
  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_order_selection`
--
ALTER TABLE `paragraph_revision__field_order_selection`
  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_o_`
--
ALTER TABLE `paragraph_revision__field_phone_o_`
  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_r_`
--
ALTER TABLE `paragraph_revision__field_phone_r_`
  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_rfd_description`
--
ALTER TABLE `paragraph_revision__field_rfd_description`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_rfd_description_format` (`field_rfd_description_format`);

--
-- Indexes for table `paragraph_revision__field_screen_reader`
--
ALTER TABLE `paragraph_revision__field_screen_reader`
  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_seniority_list_`
--
ALTER TABLE `paragraph_revision__field_seniority_list_`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_seniority_list__target_id` (`field_seniority_list__target_id`);

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

--
-- 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_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_unit`
--
ALTER TABLE `paragraph_revision__field_unit`
  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_upload_pdf_`
--
ALTER TABLE `paragraph_revision__field_upload_pdf_`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_upload_pdf__target_id` (`field_upload_pdf__target_id`);

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

--
-- Indexes for table `paragraph_revision__field_vacancies_no`
--
ALTER TABLE `paragraph_revision__field_vacancies_no`
  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_website`
--
ALTER TABLE `paragraph_revision__field_website`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_website_uri` (`field_website_uri`(30));

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- 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`),
  ADD KEY `field_description_format` (`field_description_format`);

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

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

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

--
-- 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_extended_date`
--
ALTER TABLE `paragraph__field_extended_date`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_extended_date_value` (`field_extended_date_value`);

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

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

--
-- Indexes for table `paragraph__field_free_commercial`
--
ALTER TABLE `paragraph__field_free_commercial`
  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_gallery_image_category`
--
ALTER TABLE `paragraph__field_gallery_image_category`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_gallery_image_category_target_id` (`field_gallery_image_category_target_id`);

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

--
-- Indexes for table `paragraph__field_generation_during_the_mont`
--
ALTER TABLE `paragraph__field_generation_during_the_mont`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_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_iss`
--
ALTER TABLE `paragraph__field_iss`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- 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_tender_reference_number`
--
ALTER TABLE `paragraph__field_tender_reference_number`
  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_unit`
--
ALTER TABLE `paragraph__field_unit`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

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

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

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

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

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

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

--
-- 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__status` (`status`,`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 `router`
--
ALTER TABLE `router`
  ADD PRIMARY KEY (`name`),
  ADD KEY `pattern_outline_parts` (`pattern_outline`(191),`number_parts`);

--
-- Indexes for table `search_dataset`
--
ALTER TABLE `search_dataset`
  ADD PRIMARY KEY (`sid`,`langcode`,`type`);

--
-- Indexes for table `search_index`
--
ALTER TABLE `search_index`
  ADD PRIMARY KEY (`word`,`sid`,`langcode`,`type`),
  ADD KEY `sid_type` (`sid`,`langcode`,`type`);

--
-- Indexes for table `search_total`
--
ALTER TABLE `search_total`
  ADD PRIMARY KEY (`word`);

--
-- 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 `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)),
  ADD KEY `taxonomy_term__1a0c187e9a` (`content_translation_uid`);

--
-- 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`),
  ADD KEY `taxonomy_term__1a0c187e9a` (`content_translation_uid`);

--
-- 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__field_title_`
--
ALTER TABLE `taxonomy_term_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 `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__field_title_`
--
ALTER TABLE `taxonomy_term__field_title_`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_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 `users_field_data`
--
ALTER TABLE `users_field_data`
  ADD PRIMARY KEY (`uid`,`langcode`),
  ADD UNIQUE KEY `user__name` (`name`,`langcode`),
  ADD KEY `user__id__default_langcode__langcode` (`uid`,`default_langcode`,`langcode`),
  ADD KEY `user_field__mail` (`mail`(191)),
  ADD KEY `user_field__created` (`created`),
  ADD KEY `user_field__access` (`access`);

--
-- 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 `visitors`
--
ALTER TABLE `visitors`
  ADD PRIMARY KEY (`visitors_id`);

--
-- Indexes for table `visitors_counter`
--
ALTER TABLE `visitors_counter`
  ADD PRIMARY KEY (`entity_type`,`entity_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `block_content`
--
ALTER TABLE `block_content`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `block_content_revision`
--
ALTER TABLE `block_content_revision`
  MODIFY `revision_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `captcha_sessions`
--
ALTER TABLE `captcha_sessions`
  MODIFY `csid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'CAPTCHA session ID.', AUTO_INCREMENT=8;

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

--
-- AUTO_INCREMENT for table `contact_message`
--
ALTER TABLE `contact_message`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `counter`
--
ALTER TABLE `counter`
  MODIFY `counter_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `file_managed`
--
ALTER TABLE `file_managed`
  MODIFY `fid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1324;

--
-- AUTO_INCREMENT for table `flood`
--
ALTER TABLE `flood`
  MODIFY `fid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique flood event ID.';

--
-- AUTO_INCREMENT for table `locales_location`
--
ALTER TABLE `locales_location`
  MODIFY `lid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier of this location.', AUTO_INCREMENT=1568;

--
-- AUTO_INCREMENT for table `locales_source`
--
ALTER TABLE `locales_source`
  MODIFY `lid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier of this string.', AUTO_INCREMENT=4123;

--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
  MODIFY `mid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `media_revision`
--
ALTER TABLE `media_revision`
  MODIFY `vid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `menu_link_content`
--
ALTER TABLE `menu_link_content`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=138;

--
-- AUTO_INCREMENT for table `menu_link_content_revision`
--
ALTER TABLE `menu_link_content_revision`
  MODIFY `revision_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=138;

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

--
-- AUTO_INCREMENT for table `node`
--
ALTER TABLE `node`
  MODIFY `nid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=369;

--
-- AUTO_INCREMENT for table `node_revision`
--
ALTER TABLE `node_revision`
  MODIFY `vid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=538;

--
-- AUTO_INCREMENT for table `paragraphs_item`
--
ALTER TABLE `paragraphs_item`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=956;

--
-- AUTO_INCREMENT for table `paragraphs_item_revision`
--
ALTER TABLE `paragraphs_item_revision`
  MODIFY `revision_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1166;

--
-- AUTO_INCREMENT for table `path_alias`
--
ALTER TABLE `path_alias`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=377;

--
-- AUTO_INCREMENT for table `path_alias_revision`
--
ALTER TABLE `path_alias_revision`
  MODIFY `revision_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=377;

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

--
-- AUTO_INCREMENT for table `sequences`
--
ALTER TABLE `sequences`
  MODIFY `value` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'The value of the sequence.', AUTO_INCREMENT=138;

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

--
-- AUTO_INCREMENT for table `taxonomy_term_data`
--
ALTER TABLE `taxonomy_term_data`
  MODIFY `tid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT for table `taxonomy_term_revision`
--
ALTER TABLE `taxonomy_term_revision`
  MODIFY `revision_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `uid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `visitors`
--
ALTER TABLE `visitors`
  MODIFY `visitors_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=986;

--
-- AUTO_INCREMENT for table `watchdog`
--
ALTER TABLE `watchdog`
  MODIFY `wid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique watchdog event ID.', AUTO_INCREMENT=42793;
COMMIT;

