INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(13193, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 24020 characters], 5, '', 'http://gbmm.com/f/', 'http://gbmm.com/f/node/32', '68.6.68.16', 1552371750),
(13194, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 24020 characters], 5, '', 'http://gbmm.com/f/', 'http://gbmm.com/f/node/32', '68.6.68.16', 1552371750);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(13195, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 24020 characters], 5, '', 'http://gbmm.com/f/', 'http://gbmm.com/f/node/32', '68.6.68.16', 1552371750),
(13196, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 24020 characters], 5, '', 'http://gbmm.com/f/', 'http://gbmm.com/f/node/32', '68.6.68.16', 1552371750);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(13197, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 24020 characters], 5, '', 'http://gbmm.com/f/', 'http://gbmm.com/f/node/32', '68.6.68.16', 1552371750),
(13198, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 24020 characters], 5, '', 'http://gbmm.com/f/', 'http://gbmm.com/f/node/32', '68.6.68.16', 1552371750);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(13199, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 24020 characters], 5, '', 'http://gbmm.com/f/', 'http://gbmm.com/f/node/32', '68.6.68.16', 1552371750),
(13200, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 24020 characters], 5, '', 'http://gbmm.com/f/', 'http://gbmm.com/f/node/32', '68.6.68.16', 1552371750);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(13201, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 24020 characters], 5, '', 'http://gbmm.com/f/', 'http://gbmm.com/f/node/32', '68.6.68.16', 1552371750),
(13202, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 24020 characters], 5, '', 'http://gbmm.com/f/', 'http://gbmm.com/f/node/32', '68.6.68.16', 1552371750);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(13203, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 24020 characters], 5, '', 'http://gbmm.com/f/', 'http://gbmm.com/f/node/32', '68.6.68.16', 1552371750),
(13204, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 24020 characters], 5, '', 'http://gbmm.com/f/', 'http://gbmm.com/f/node/32', '68.6.68.16', 1552371750);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(13205, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 24020 characters], 5, '', 'http://gbmm.com/f/', 'http://gbmm.com/f/node/32', '68.6.68.16', 1552371750),
(13206, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 23978 characters], 5, '', 'http://gbmm.com/f/', 'http://gbmm.com/f/node/32', '68.6.68.16', 1552371750);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(13207, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 23982 characters], 5, '', 'http://gbmm.com/f/', 'http://gbmm.com/f/node/32', '68.6.68.16', 1552371750),
(13208, 0, 'page not found', '@uri', 0x613a313a7b733a343a2240757269223b733a3630363a222f662f696d6167652f706e673b6261736536342c6956424f5277304b47676f414141414e535568455567414141796f4141414963434159414141415a6e5672444141414544576c445131424a51304d6755484a765a6d6c735a5141414f49324e5656316f484655555072747a5a794d6b7a6c4e734e4956307144384e4a513254566a5368744c702f3364303262705a4a4e746f693647543237733659796334344d3776396f5539465548777836707355784c2b336743416f39512f62507251766c516f6c327451674b4436302b494e513649756d36356b374d356c70757248655a653538383533766e6e76757557667642656935716c69576b525142467071754c526379346e4f486a3467394b35434568364158427146585552307258616c4d416a5a504333653157393944776e7466326458642f702b74743059644653427848324b7a3571674c69493842384b64567933594265767152487a2f7157683732597569334d5544454c3371343457505877334d2b666f31705a75517334744f4942565654616f695845492f4d7866684744507378734e5a666f4531713636726f35614a696d3358646f4c46773732482b6e3233426149587a62634f6e7a356d66506f547659567a374b7a556c352b4652784575716b7039472f416a696132313974687a67323561626b52452f427044633370717670684876524679733277657176702b6b7262574b4958376e6844627a4c4f4974694d38333538705477646972717050466e4d4632784c633157764c794f775441696270626d7648486376747455353779352b58712533432f626f64792533452533432f68746d6c253345223b7d, 4, '', 'http://gbmm.com/f/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAyoAAAIcCAYAAAAZnVrDAAAEDWlDQ1BJQ0MgUHJvZmlsZQAAOI2NVV1oHFUUPrtzZyMkzlNsNIV0qD8NJQ2TVjShtLp/3d02bpZJNtoi6GT27s6Yyc44M7v9oU9FUHwx6psUxL+3gCAo9Q/bPrQvlQol2tQgKD60+INQ6Ium65k7M5lpurHeZe58853vnnvuuWfvBei5qliWkRQBFpquLRcy4nOHj4g9K5CEh6AXBqFXUR0rXalMAjZPC3e1W99Dwntf2dXd/p+tt0YdFSBxH2Kz5qgLiI8B8KdVy3YBevqRHz/qWh72Yui3MUDEL3q44WPXw3M+fo1pZuQs4tOIBVVTaoiXEI/MxfhGDPsxsNZfoE1q66ro5aJim3XdoLFw72H+n23BaIXzbcOnz5mfPoTvYVz7KzUl5+FRxEuqkp9G/Ajia219thzg25abkRE/BpDc3pqvphHvRFys2weqvp+krbWKIX7nhDbzLOItiM8358pTwdirqpPFnMF2xLc1WvLyOwTAibpbmvHHcvttU57y5+Xq%3C/body%3E%3C/html%3E', 'http://gbmm.com/f/', '68.6.68.16', 1552371752),
(13209, 0, 'page not found', '@uri', 0x613a313a7b733a343a2240757269223b733a32303a222f662f666f6e742f4c61746f2d4c69672e747466223b7d, 4, '', 'http://gbmm.com/f/font/Lato-Lig.ttf', 'http://gbmm.com/f/', '68.6.68.16', 1552371753),
(13210, 0, 'page not found', '@uri', 0x613a313a7b733a343a2240757269223b733a35313a222f662f7265736f75726365732f64796e616d69632d677269642d636f6e74656e742f666f6e742f4c61746f2d4c69672e747466223b7d, 4, '', 'https://gbmm.com/f/resources/dynamic-grid-content/font/Lato-Lig.ttf', 'http://gbmm.com/f/', '68.6.68.16', 1552371754);

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

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

--
-- Indexes for table `block_content_revision__field_video`
--
ALTER TABLE `block_content_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 `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_block_image`
--
ALTER TABLE `block_content__field_block_image`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_block_image_target_id` (`field_block_image_target_id`);

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

--
-- Indexes for table `block_content__field_video`
--
ALTER TABLE `block_content__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 `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_content`
--
ALTER TABLE `cache_content`
  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_geocoder`
--
ALTER TABLE `cache_geocoder`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `cache_library`
--
ALTER TABLE `cache_library`
  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_toolbar`
--
ALTER TABLE `cache_toolbar`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `expire` (`expire`),
  ADD KEY `created` (`created`);

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `eu_cookie_compliance_basic_consent`
--
ALTER TABLE `eu_cookie_compliance_basic_consent`
  ADD PRIMARY KEY (`cid`),
  ADD KEY `uid` (`uid`);

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

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

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

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

--
-- 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`);

--
-- 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_field__link__uri` (`link__uri`(30)),
  ADD KEY `menu_link_content__enabled_bundle` (`enabled`,`bundle`,`id`);

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

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

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

--
-- Indexes for table `node_revision__field_address`
--
ALTER TABLE `node_revision__field_address`
  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_animation`
--
ALTER TABLE `node_revision__field_animation`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_animation_format` (`field_animation_format`);

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

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

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

--
-- Indexes for table `node_revision__field_event_gps`
--
ALTER TABLE `node_revision__field_event_gps`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_event_gps_lat` (`field_event_gps_lat`),
  ADD KEY `field_event_gps_lon` (`field_event_gps_lon`),
  ADD KEY `field_event_gps_top` (`field_event_gps_top`),
  ADD KEY `field_event_gps_bottom` (`field_event_gps_bottom`),
  ADD KEY `field_event_gps_left` (`field_event_gps_left`),
  ADD KEY `field_event_gps_right` (`field_event_gps_right`),
  ADD KEY `field_event_gps_geohash` (`field_event_gps_geohash`),
  ADD KEY `field_event_gps_centroid` (`field_event_gps_lat`,`field_event_gps_lon`),
  ADD KEY `field_event_gps_bbox` (`field_event_gps_top`,`field_event_gps_bottom`,`field_event_gps_left`,`field_event_gps_right`);

--
-- Indexes for table `node_revision__field_event_location`
--
ALTER TABLE `node_revision__field_event_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_event_start_date`
--
ALTER TABLE `node_revision__field_event_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_event_start_date_value` (`field_event_start_date_value`);

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

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

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

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

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

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

--
-- Indexes for table `node_revision__field_festival_event_end_date`
--
ALTER TABLE `node_revision__field_festival_event_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_festival_event_end_date_value` (`field_festival_event_end_date_value`);

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

--
-- Indexes for table `node_revision__field_festival_event_start_date`
--
ALTER TABLE `node_revision__field_festival_event_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_festival_event_start_date_value` (`field_festival_event_start_date_value`);

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

--
-- Indexes for table `node_revision__field_festival_gps`
--
ALTER TABLE `node_revision__field_festival_gps`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_festival_gps_lat` (`field_festival_gps_lat`),
  ADD KEY `field_festival_gps_lon` (`field_festival_gps_lon`),
  ADD KEY `field_festival_gps_top` (`field_festival_gps_top`),
  ADD KEY `field_festival_gps_bottom` (`field_festival_gps_bottom`),
  ADD KEY `field_festival_gps_left` (`field_festival_gps_left`),
  ADD KEY `field_festival_gps_right` (`field_festival_gps_right`),
  ADD KEY `field_festival_gps_geohash` (`field_festival_gps_geohash`),
  ADD KEY `field_festival_gps_centroid` (`field_festival_gps_lat`,`field_festival_gps_lon`),
  ADD KEY `field_festival_gps_bbox` (`field_festival_gps_top`,`field_festival_gps_bottom`,`field_festival_gps_left`,`field_festival_gps_right`);

--
-- Indexes for table `node_revision__field_festival_location`
--
ALTER TABLE `node_revision__field_festival_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_festival_logo`
--
ALTER TABLE `node_revision__field_festival_logo`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_festival_logo_target_id` (`field_festival_logo_target_id`);

--
-- Indexes for table `node_revision__field_festival_name`
--
ALTER TABLE `node_revision__field_festival_name`
  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_festival_tag`
--
ALTER TABLE `node_revision__field_festival_tag`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_festival_tag_target_id` (`field_festival_tag_target_id`);

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

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

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

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

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

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

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

--
-- Indexes for table `node_revision__field_film_director`
--
ALTER TABLE `node_revision__field_film_director`
  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_film_poster`
--
ALTER TABLE `node_revision__field_film_poster`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_film_poster_target_id` (`field_film_poster_target_id`);

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

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

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

--
-- Indexes for table `node_revision__field_gallery_thumbnail`
--
ALTER TABLE `node_revision__field_gallery_thumbnail`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_gallery_thumbnail_target_id` (`field_gallery_thumbnail_target_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_link`
--
ALTER TABLE `node_revision__field_link`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_link_uri` (`field_link_uri`(30));

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `node_revision__field_post_embed`
--
ALTER TABLE `node_revision__field_post_embed`
  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_post_format`
--
ALTER TABLE `node_revision__field_post_format`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_post_format_value` (`field_post_format_value`(191));

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `node_revision__field_source`
--
ALTER TABLE `node_revision__field_source`
  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_story_teaser_image`
--
ALTER TABLE `node_revision__field_story_teaser_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_story_teaser_image_target_id` (`field_story_teaser_image_target_id`);

--
-- Indexes for table `node_revision__field_story_type`
--
ALTER TABLE `node_revision__field_story_type`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_story_type_target_id` (`field_story_type_target_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_venue`
--
ALTER TABLE `node_revision__field_venue`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_venue_target_id` (`field_venue_target_id`);

--
-- Indexes for table `node_revision__field_video_embed`
--
ALTER TABLE `node_revision__field_video_embed`
  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_website`
--
ALTER TABLE `node_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 `node_revision__simplenews_issue`
--
ALTER TABLE `node_revision__simplenews_issue`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `simplenews_issue_target_id` (`simplenews_issue_target_id`);

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

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

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

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

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

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

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

--
-- Indexes for table `node__field_event_gps`
--
ALTER TABLE `node__field_event_gps`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_event_gps_lat` (`field_event_gps_lat`),
  ADD KEY `field_event_gps_lon` (`field_event_gps_lon`),
  ADD KEY `field_event_gps_top` (`field_event_gps_top`),
  ADD KEY `field_event_gps_bottom` (`field_event_gps_bottom`),
  ADD KEY `field_event_gps_left` (`field_event_gps_left`),
  ADD KEY `field_event_gps_right` (`field_event_gps_right`),
  ADD KEY `field_event_gps_geohash` (`field_event_gps_geohash`),
  ADD KEY `field_event_gps_centroid` (`field_event_gps_lat`,`field_event_gps_lon`),
  ADD KEY `field_event_gps_bbox` (`field_event_gps_top`,`field_event_gps_bottom`,`field_event_gps_left`,`field_event_gps_right`);

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `node__field_festival_gps`
--
ALTER TABLE `node__field_festival_gps`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_festival_gps_lat` (`field_festival_gps_lat`),
  ADD KEY `field_festival_gps_lon` (`field_festival_gps_lon`),
  ADD KEY `field_festival_gps_top` (`field_festival_gps_top`),
  ADD KEY `field_festival_gps_bottom` (`field_festival_gps_bottom`),
  ADD KEY `field_festival_gps_left` (`field_festival_gps_left`),
  ADD KEY `field_festival_gps_right` (`field_festival_gps_right`),
  ADD KEY `field_festival_gps_geohash` (`field_festival_gps_geohash`),
  ADD KEY `field_festival_gps_centroid` (`field_festival_gps_lat`,`field_festival_gps_lon`),
  ADD KEY `field_festival_gps_bbox` (`field_festival_gps_top`,`field_festival_gps_bottom`,`field_festival_gps_left`,`field_festival_gps_right`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `node__field_gallery_thumbnail`
--
ALTER TABLE `node__field_gallery_thumbnail`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_gallery_thumbnail_target_id` (`field_gallery_thumbnail_target_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_link`
--
ALTER TABLE `node__field_link`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_link_uri` (`field_link_uri`(30));

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `node__field_story_type`
--
ALTER TABLE `node__field_story_type`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_story_type_target_id` (`field_story_type_target_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_venue`
--
ALTER TABLE `node__field_venue`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_venue_target_id` (`field_venue_target_id`);

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

--
-- Indexes for table `node__field_website`
--
ALTER TABLE `node__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 `node__simplenews_issue`
--
ALTER TABLE `node__simplenews_issue`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `simplenews_issue_target_id` (`simplenews_issue_target_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 `simplenews_mail_spool`
--
ALTER TABLE `simplenews_mail_spool`
  ADD PRIMARY KEY (`msid`),
  ADD KEY `newsletter_id` (`newsletter_id`(191)),
  ADD KEY `status` (`status`),
  ADD KEY `snid_newsletter_id` (`snid`,`newsletter_id`(191));

--
-- Indexes for table `simplenews_subscriber`
--
ALTER TABLE `simplenews_subscriber`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `simplenews_subscriber_field__uuid__value` (`uuid`),
  ADD KEY `simplenews_subscriber_field__uid__target_id` (`uid`);

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

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

--
-- Indexes for table `taxonomy_term_data`
--
ALTER TABLE `taxonomy_term_data`
  ADD PRIMARY KEY (`tid`),
  ADD UNIQUE KEY `taxonomy_term_field__uuid__value` (`uuid`),
  ADD 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_field__name` (`name`(191)),
  ADD KEY `taxonomy_term__status_vid` (`status`,`vid`,`tid`),
  ADD KEY `taxonomy_term__tree` (`vid`,`weight`,`name`(191)),
  ADD KEY `taxonomy_term__vid_name` (`vid`,`name`(191));

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

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

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

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

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

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

--
-- Indexes for table `taxonomy_term__parent`
--
ALTER TABLE `taxonomy_term__parent`
  ADD PRIMARY KEY (`entity_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 `url_alias`
--
ALTER TABLE `url_alias`
  ADD PRIMARY KEY (`pid`),
  ADD KEY `alias_langcode_pid` (`alias`(191),`langcode`,`pid`),
  ADD KEY `source_langcode_pid` (`source`(191),`langcode`,`pid`);

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

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

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

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

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

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

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

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

--
-- 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=14;

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

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

--
-- AUTO_INCREMENT for table `crop`
--
ALTER TABLE `crop`
  MODIFY `cid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=107;

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

--
-- AUTO_INCREMENT for table `cs_logs`
--
ALTER TABLE `cs_logs`
  MODIFY `csid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique content_sync event ID.';

--
-- AUTO_INCREMENT for table `eu_cookie_compliance_basic_consent`
--
ALTER TABLE `eu_cookie_compliance_basic_consent`
  MODIFY `cid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique consent storage ID.';

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

--
-- 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 `gavias_blockbuilder`
--
ALTER TABLE `gavias_blockbuilder`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

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

--
-- 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=378;

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

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

--
-- 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 for table `sequences`
--
ALTER TABLE `sequences`
  MODIFY `value` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'The value of the sequence.', AUTO_INCREMENT=10;

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

--
-- AUTO_INCREMENT for table `simplenews_mail_spool`
--
ALTER TABLE `simplenews_mail_spool`
  MODIFY `msid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'The primary identifier for a mail spool record.';

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

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

--
-- AUTO_INCREMENT for table `url_alias`
--
ALTER TABLE `url_alias`
  MODIFY `pid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'A unique path alias identifier.', AUTO_INCREMENT=3;

--
-- 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=13211;
COMMIT;

