INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(12292, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 8690 characters], 4, '', 'http://weehub.uonbi.ac.ke/.well-known/acme-challenge/ZNWG14UX-OGA45YZM4NLIRLCIC-46TG4', '', '41.204.161.207', 1678375001),
(12293, 0, 'page not found', '@uri', 0x613a313a7b733a343a2240757269223b733a36303a222f2e77656c6c2d6b6e6f776e2f61636d652d6368616c6c656e67652f5a4e5747313455582d4f47413435595a4d344e4c49524c4349432d3436544734223b7d, 4, '', 'http://weehub.uonbi.ac.ke/.well-known/acme-challenge/ZNWG14UX-OGA45YZM4NLIRLCIC-46TG4', '', '41.204.161.207', 1678375002),
(12294, 0, 'security', 'Security warning: Couldn\'t write .htaccess file. Please create a .htaccess file in your %directory directory which contains the following lines: <pre><code>@htaccess</code></pre>', 0x613a323a7b733a31303a22256469726563746f7279223b733a31303a22707269766174653a2f2f223b733a393a22406874616363657373223b733a3638363a22232044656e7920616c6c2072657175657374732066726f6d2041706163686520322e342b2e0a3c49664d6f64756c65206d6f645f617574687a5f636f72652e633e0a20205265717569726520616c6c2064656e6965640a3c2f49664d6f64756c653e0a0a232044656e7920616c6c2072657175657374732066726f6d2041706163686520322e302d322e322e0a3c49664d6f64756c6520216d6f645f617574687a5f636f72652e633e0a202044656e792066726f6d20616c6c0a3c2f49664d6f64756c653e0a0a23205475726e206f666620616c6c206f7074696f6e7320776520646f6e2774206e6565642e0a4f7074696f6e73202d496e6465786573202d45786563434749202d496e636c75646573202d4d756c746956696577730a0a2320536574207468652063617463682d616c6c2068616e646c657220746f2070726576656e7420736372697074732066726f6d206265696e672065786563757465642e0a53657448616e646c65722044727570616c5f53656375726974795f446f5f4e6f745f52656d6f76655f5365655f53415f323030365f3030360a3c46696c6573202a3e0a202023204f76657272696465207468652068616e646c657220616761696e2069662077652772652072756e206c6174657220696e20746865206576616c756174696f6e206c6973742e0a202053657448616e646c65722044727570616c5f53656375726974795f446f5f4e6f745f52656d6f76655f5365655f53415f323031335f3030330a3c2f46696c65733e0a0a23204966207765206b6e6f7720686f7720746f20646f20697420736166656c792c2064697361626c65207468652050485020656e67696e6520656e746972656c792e0a3c49664d6f64756c65206d6f645f706870372e633e0a20207068705f666c616720656e67696e65206f66660a3c2f49664d6f64756c653e223b7d, 3, '', 'https://weehub.uonbi.ac.ke/assessing-policy-advocacy-strategies-work-implementation-wee-policies-and-programs-case-study', '', '52.167.144.89', 1678382000),
(12295, 0, 'cron', 'Cron run completed.', 0x613a303a7b7d, 6, '', 'https://weehub.uonbi.ac.ke/assessing-policy-advocacy-strategies-work-implementation-wee-policies-and-programs-case-study', '', '52.167.144.89', 1678382004),
(12296, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 8690 characters], 4, '', 'http://weehub.uonbi.ac.ke/.well-known/acme-challenge/8QH7VYD370NEZS-PGNNLB8__4QD4D4-5', '', '41.204.161.207', 1678385792),
(12297, 0, 'page not found', '@uri', 0x613a313a7b733a343a2240757269223b733a36303a222f2e77656c6c2d6b6e6f776e2f61636d652d6368616c6c656e67652f385148375659443337304e455a532d50474e4e4c42385f5f3451443444342d35223b7d, 4, '', 'http://weehub.uonbi.ac.ke/.well-known/acme-challenge/8QH7VYD370NEZS-PGNNLB8__4QD4D4-5', '', '41.204.161.207', 1678385792),
(12298, 0, 'security', 'Security warning: Couldn\'t write .htaccess file. Please create a .htaccess file in your %directory directory which contains the following lines: <pre><code>@htaccess</code></pre>', 0x613a323a7b733a31303a22256469726563746f7279223b733a31303a22707269766174653a2f2f223b733a393a22406874616363657373223b733a3638363a22232044656e7920616c6c2072657175657374732066726f6d2041706163686520322e342b2e0a3c49664d6f64756c65206d6f645f617574687a5f636f72652e633e0a20205265717569726520616c6c2064656e6965640a3c2f49664d6f64756c653e0a0a232044656e7920616c6c2072657175657374732066726f6d2041706163686520322e302d322e322e0a3c49664d6f64756c6520216d6f645f617574687a5f636f72652e633e0a202044656e792066726f6d20616c6c0a3c2f49664d6f64756c653e0a0a23205475726e206f666620616c6c206f7074696f6e7320776520646f6e2774206e6565642e0a4f7074696f6e73202d496e6465786573202d45786563434749202d496e636c75646573202d4d756c746956696577730a0a2320536574207468652063617463682d616c6c2068616e646c657220746f2070726576656e7420736372697074732066726f6d206265696e672065786563757465642e0a53657448616e646c65722044727570616c5f53656375726974795f446f5f4e6f745f52656d6f76655f5365655f53415f323030365f3030360a3c46696c6573202a3e0a202023204f76657272696465207468652068616e646c657220616761696e2069662077652772652072756e206c6174657220696e20746865206576616c756174696f6e206c6973742e0a202053657448616e646c65722044727570616c5f53656375726974795f446f5f4e6f745f52656d6f76655f5365655f53415f323031335f3030330a3c2f46696c65733e0a0a23204966207765206b6e6f7720686f7720746f20646f20697420736166656c792c2064697361626c65207468652050485020656e67696e6520656e746972656c792e0a3c49664d6f64756c65206d6f645f706870372e633e0a20207068705f666c616720656e67696e65206f66660a3c2f49664d6f64756c653e223b7d, 3, '', 'https://weehub.uonbi.ac.ke/kenyatta-university-wee-hub', '', '185.191.171.13', 1678392810),
(12299, 0, 'cron', 'Cron run completed.', 0x613a303a7b7d, 6, '', 'https://weehub.uonbi.ac.ke/kenyatta-university-wee-hub', '', '185.191.171.13', 1678392816),
(12300, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 8690 characters], 4, '', 'http://weehub.uonbi.ac.ke/.well-known/acme-challenge/0_KPZSYXPMP6E-9JUL5M_PH3SEWSF9_8', '', '41.204.161.207', 1678396590),
(12301, 0, 'page not found', '@uri', 0x613a313a7b733a343a2240757269223b733a36303a222f2e77656c6c2d6b6e6f776e2f61636d652d6368616c6c656e67652f305f4b505a535958504d5036452d394a554c354d5f5048335345575346395f38223b7d, 4, '', 'http://weehub.uonbi.ac.ke/.well-known/acme-challenge/0_KPZSYXPMP6E-9JUL5M_PH3SEWSF9_8', '', '41.204.161.207', 1678396590),
(12302, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 8690 characters], 4, '', 'https://weehub.uonbi.ac.ke/wp-login.php', '', '182.160.110.115', 1678406365),
(12303, 0, 'page not found', '@uri', 0x613a313a7b733a343a2240757269223b733a31333a222f77702d6c6f67696e2e706870223b7d, 4, '', 'https://weehub.uonbi.ac.ke/wp-login.php', '', '182.160.110.115', 1678406365),
(12304, 0, 'security', 'Security warning: Couldn\'t write .htaccess file. Please create a .htaccess file in your %directory directory which contains the following lines: <pre><code>@htaccess</code></pre>', 0x613a323a7b733a31303a22256469726563746f7279223b733a31303a22707269766174653a2f2f223b733a393a22406874616363657373223b733a3638363a22232044656e7920616c6c2072657175657374732066726f6d2041706163686520322e342b2e0a3c49664d6f64756c65206d6f645f617574687a5f636f72652e633e0a20205265717569726520616c6c2064656e6965640a3c2f49664d6f64756c653e0a0a232044656e7920616c6c2072657175657374732066726f6d2041706163686520322e302d322e322e0a3c49664d6f64756c6520216d6f645f617574687a5f636f72652e633e0a202044656e792066726f6d20616c6c0a3c2f49664d6f64756c653e0a0a23205475726e206f666620616c6c206f7074696f6e7320776520646f6e2774206e6565642e0a4f7074696f6e73202d496e6465786573202d45786563434749202d496e636c75646573202d4d756c746956696577730a0a2320536574207468652063617463682d616c6c2068616e646c657220746f2070726576656e7420736372697074732066726f6d206265696e672065786563757465642e0a53657448616e646c65722044727570616c5f53656375726974795f446f5f4e6f745f52656d6f76655f5365655f53415f323030365f3030360a3c46696c6573202a3e0a202023204f76657272696465207468652068616e646c657220616761696e2069662077652772652072756e206c6174657220696e20746865206576616c756174696f6e206c6973742e0a202053657448616e646c65722044727570616c5f53656375726974795f446f5f4e6f745f52656d6f76655f5365655f53415f323031335f3030330a3c2f46696c65733e0a0a23204966207765206b6e6f7720686f7720746f20646f20697420736166656c792c2064697361626c65207468652050485020656e67696e6520656e746972656c792e0a3c49664d6f64756c65206d6f645f706870372e633e0a20207068705f666c616720656e67696e65206f66660a3c2f49664d6f64756c653e223b7d, 3, '', 'https://weehub.uonbi.ac.ke/wp-login.php', '', '182.160.110.115', 1678406374),
(12305, 0, 'cron', 'Cron run completed.', 0x613a303a7b7d, 6, '', 'https://weehub.uonbi.ac.ke/wp-login.php', '', '182.160.110.115', 1678406376);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(12306, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 8690 characters], 4, '', 'https://weehub.uonbi.ac.ke/xmlrpc.php', '', '182.160.110.115', 1678406377),
(12307, 0, 'page not found', '@uri', 0x613a313a7b733a343a2240757269223b733a31313a222f786d6c7270632e706870223b7d, 4, '', 'https://weehub.uonbi.ac.ke/xmlrpc.php', '', '182.160.110.115', 1678406377),
(12308, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 8690 characters], 4, '', 'http://weehub.uonbi.ac.ke/.well-known/acme-challenge/9G3YQP_OWE5BKFCEMS2GG5FFE8-RW2RN', '', '41.204.161.207', 1678407395),
(12309, 0, 'page not found', '@uri', 0x613a313a7b733a343a2240757269223b733a36303a222f2e77656c6c2d6b6e6f776e2f61636d652d6368616c6c656e67652f3947335951505f4f574535424b4643454d5332474735464645382d525732524e223b7d, 4, '', 'http://weehub.uonbi.ac.ke/.well-known/acme-challenge/9G3YQP_OWE5BKFCEMS2GG5FFE8-RW2RN', '', '41.204.161.207', 1678407395),
(12310, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 8690 characters], 4, '', 'https://weehub.uonbi.ac.ke/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAcQAAAI1CAIAAADHGx1pAAAAAXNSR0IArs4c6QAAAAlwSFlzAAAk6AAAJOgBgmMFHAAA/7VJREFUeF6c/VespWmWpodt783xNny6SFO+ffcMxzY1niOQI0oEhRndEAJGwGAEUQJGpKABRgIkghBvCEFXuhJAQNKNDAFClARwONPq7urKqkpTmRmZEZERx5vtvdPzvuvfEVFtNIB2nTp54pxt/v/71rfMu961Vnr5e/9imclP0+VZqpBallOrfHaeySzS+Ww6lUotMqtVJr3k/6tMZpnhN8v8cr6ar9KrdGa1WK1S6WU2teKR9vfMi%3C/body%3E%3C/html%3E', 'https://weehub.uonbi.ac.ke/latest-news', '197.177.27.135', 1678412292),
(12311, 0, 'page not found', '@uri', 0x613a313a7b733a343a2240757269223b733a3338313a222f696d6167652f706e673b6261736536342c6956424f5277304b47676f414141414e535568455567414141635141414149314341494141414448477831704141414141584e5352304941727334633651414141416c7753466c7a4141416b364141414a4f6742676d4d46484141412f37564a52454655654636632f56657370576d57706f6474373833784e6e793653464f2b6666634d787a59316e694f5149306f4568526e6445414a477747414555514a47704b41425267496b676842764345465875684a41514e4b4e444146436c4152774f4e50713775724b716b70546d526d5a455a4552783576747664507a76757666455646744e4942326e547035347078742f762f373172664d75393631566e7235652f39696d636c50302b565a717042616c6c4f726648616579537a532b5777366c556f744d7174564a72336b2f36744d5a706e684e3876386372366172394b7264476131574b31533657553274654b523976664d692533432f626f64792533452533432f68746d6c253345223b7d, 4, '', 'https://weehub.uonbi.ac.ke/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAcQAAAI1CAIAAADHGx1pAAAAAXNSR0IArs4c6QAAAAlwSFlzAAAk6AAAJOgBgmMFHAAA/7VJREFUeF6c/VespWmWpodt783xNny6SFO+ffcMxzY1niOQI0oEhRndEAJGwGAEUQJGpKABRgIkghBvCEFXuhJAQNKNDAFClARwONPq7urKqkpTmRmZEZERx5vtvdPzvuvfEVFtNIB2nTp54pxt/v/71rfMu961Vnr5e/9imclP0+VZqpBallOrfHaeySzS+Ww6lUotMqtVJr3k/6tMZpnhN8v8cr6ar9KrdGa1WK1S6WU2teKR9vfMi%3C/body%3E%3C/html%3E', 'https://weehub.uonbi.ac.ke/latest-news', '197.177.27.135', 1678412292),
(12312, 0, 'security', 'Security warning: Couldn\'t write .htaccess file. Please create a .htaccess file in your %directory directory which contains the following lines: <pre><code>@htaccess</code></pre>', 0x613a323a7b733a31303a22256469726563746f7279223b733a31303a22707269766174653a2f2f223b733a393a22406874616363657373223b733a3638363a22232044656e7920616c6c2072657175657374732066726f6d2041706163686520322e342b2e0a3c49664d6f64756c65206d6f645f617574687a5f636f72652e633e0a20205265717569726520616c6c2064656e6965640a3c2f49664d6f64756c653e0a0a232044656e7920616c6c2072657175657374732066726f6d2041706163686520322e302d322e322e0a3c49664d6f64756c6520216d6f645f617574687a5f636f72652e633e0a202044656e792066726f6d20616c6c0a3c2f49664d6f64756c653e0a0a23205475726e206f666620616c6c206f7074696f6e7320776520646f6e2774206e6565642e0a4f7074696f6e73202d496e6465786573202d45786563434749202d496e636c75646573202d4d756c746956696577730a0a2320536574207468652063617463682d616c6c2068616e646c657220746f2070726576656e7420736372697074732066726f6d206265696e672065786563757465642e0a53657448616e646c65722044727570616c5f53656375726974795f446f5f4e6f745f52656d6f76655f5365655f53415f323030365f3030360a3c46696c6573202a3e0a202023204f76657272696465207468652068616e646c657220616761696e2069662077652772652072756e206c6174657220696e20746865206576616c756174696f6e206c6973742e0a202053657448616e646c65722044727570616c5f53656375726974795f446f5f4e6f745f52656d6f76655f5365655f53415f323031335f3030330a3c2f46696c65733e0a0a23204966207765206b6e6f7720686f7720746f20646f20697420736166656c792c2064697361626c65207468652050485020656e67696e6520656e746972656c792e0a3c49664d6f64756c65206d6f645f706870372e633e0a20207068705f666c616720656e67696e65206f66660a3c2f49664d6f64756c653e223b7d, 3, '', 'https://weehub.uonbi.ac.ke/node/271', '', '185.191.171.16', 1678417321),
(12313, 0, 'cron', 'Cron run completed.', 0x613a303a7b7d, 6, '', 'https://weehub.uonbi.ac.ke/node/271', '', '185.191.171.16', 1678417325),
(12314, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 8690 characters], 4, '', 'http://weehub.uonbi.ac.ke/.well-known/acme-challenge/4ZGJOJG3ES6ULOD54N-1ABOLJS1_PONX', '', '41.204.161.207', 1678418203),
(12315, 0, 'page not found', '@uri', 0x613a313a7b733a343a2240757269223b733a36303a222f2e77656c6c2d6b6e6f776e2f61636d652d6368616c6c656e67652f345a474a4f4a4733455336554c4f4435344e2d3141424f4c4a53315f504f4e58223b7d, 4, '', 'http://weehub.uonbi.ac.ke/.well-known/acme-challenge/4ZGJOJG3ES6ULOD54N-1ABOLJS1_PONX', '', '41.204.161.207', 1678418203);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(12316, 2, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 13444 characters], 4, '', 'https://weehub.uonbi.ac.ke/admin/config/development/performance', 'https://weehub.uonbi.ac.ke/admin/config/development/performance', '41.89.65.38', 1678425785),
(12317, 0, 'views', 'A non-existent config entity name returned by FieldStorageConfigInterface::getBundles(): entity type: %entity_type, bundle: %bundle, field name: %field', 0x613a333a7b733a31323a2225656e746974795f74797065223b733a343a226e6f6465223b733a373a222562756e646c65223b733a343a22626f6f6b223b733a363a22256669656c64223b733a31343a226669656c645f63617465676f7279223b7d, 3, '', 'https://weehub.uonbi.ac.ke/care-economy-and-womens-economic-empowerment', '', '185.191.171.24', 1678425791);

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

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

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

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

INSERT INTO `webform` (`webform_id`, `next_serial`) VALUES
('contact', 1),
('template_contact', 1),
('template_employee_evaluation', 1),
('template_feedback', 1),
('template_issue', 1),
('template_job_application', 1),
('template_job_seeker_profile', 1),
('template_medical_appointment', 1),
('template_registration', 1),
('template_session_evaluation', 1),
('template_subscribe', 1),
('template_user_profile', 1);

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

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

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

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

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

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

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

--
-- Table structure for table `webform_submission_log`
--

CREATE TABLE `webform_submission_log` (
  `lid` int(11) NOT NULL COMMENT 'Primary Key: Unique log event ID.',
  `webform_id` varchar(32) NOT NULL COMMENT 'The webform id.',
  `sid` int(10) UNSIGNED DEFAULT NULL COMMENT 'The webform submission id.',
  `handler_id` varchar(64) DEFAULT NULL COMMENT 'The webform handler id.',
  `uid` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The users.uid of the user who triggered the event.',
  `operation` varchar(64) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'Type of operation, for example "save", "sent", or "update."',
  `message` longtext NOT NULL COMMENT 'Text of log message.',
  `data` longblob NOT NULL COMMENT 'Serialized array of data.',
  `timestamp` int(11) NOT NULL DEFAULT '0' COMMENT 'Unix timestamp of when event occurred.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Table that contains logs of all webform submission events.';

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

--
-- Table structure for table `xmlsitemap`
--

CREATE TABLE `xmlsitemap` (
  `id` varchar(32) NOT NULL DEFAULT '' COMMENT 'Primary key with type. a unique id for the item.',
  `type` varchar(32) NOT NULL DEFAULT '' COMMENT 'Primary key with id. the type of item (e.g. node, user, etc.).',
  `subtype` varchar(128) NOT NULL DEFAULT '' COMMENT 'A sub-type identifier for the link (node type, menu name, term VID, etc.).',
  `loc` varchar(255) NOT NULL DEFAULT '' COMMENT 'The URL to the item relative to the Drupal path.',
  `language` varchar(12) NOT NULL DEFAULT '' COMMENT 'The "languages".language of this link or an empty string if it is language-neutral.',
  `access` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'A boolean that represents if the item is viewable by the anonymous user. This field is useful to store the result of node_access() so we can retain changefreq and priority_override information.',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'An integer that represents if the item is included in the sitemap.',
  `status_override` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean that if TRUE means that the status field has been overridden from its default value.',
  `lastmod` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The UNIX timestamp of last modification of the item.',
  `priority` float DEFAULT NULL COMMENT 'The priority of this URL relative to other URLs on your site. Valid values range from 0.0 to 1.0.',
  `priority_override` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean that if TRUE means that the priority field has been overridden from its default value.',
  `changefreq` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The average time in seconds between changes of this item.',
  `changecount` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The number of times this item has been changed. Used to help calculate the next changefreq value.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='The base table for xmlsitemap links.';

--
-- Dumping data for table `xmlsitemap`
--

INSERT INTO `xmlsitemap` (`id`, `type`, `subtype`, `loc`, `language`, `access`, `status`, `status_override`, `lastmod`, `priority`, `priority_override`, `changefreq`, `changecount`) VALUES
('0', 'frontpage', '', '/', 'und', 1, 1, 0, 0, 1, 0, 86400, 0),
('1', 'media', 'image', '/media/1/edit', 'en', 1, 1, 0, 1647353872, 0.5, 0, 60, 0),
('1', 'node', 'page', '/node/1', 'en', 1, 1, 0, 1647256449, 0.5, 0, 60, 0),
('10', 'taxonomy_term', 'tags', '/taxonomy/term/10', 'en', 1, 1, 0, 1482294048, 0.5, 0, 60, 0),
('11', 'taxonomy_term', 'portfolio_tags', '/taxonomy/term/11', 'en', 1, 1, 0, 1482294064, 0.5, 0, 60, 0),
('117', 'node', 'event', '/node/117', 'en', 1, 1, 0, 1656683222, 0.5, 0, 60, 0),
('118', 'node', 'event', '/node/118', 'en', 1, 1, 0, 1647179548, 0.5, 0, 60, 0),
('119', 'node', 'event', '/node/119', 'en', 1, 1, 0, 1660940011, 0.5, 0, 60, 0),
('12', 'taxonomy_term', 'portfolio_tags', '/taxonomy/term/12', 'en', 1, 1, 0, 1482294070, 0.5, 0, 60, 0),
('122', 'node', 'article', '/node/122', 'en', 1, 1, 0, 1647235304, 0.5, 0, 60, 0),
('123', 'node', 'article', '/node/123', 'en', 1, 1, 0, 1647235414, 0.5, 0, 60, 0),
('124', 'node', 'article', '/node/124', 'en', 1, 1, 0, 1647235476, 0.5, 0, 60, 0),
('125', 'node', 'article', '/node/125', 'en', 1, 1, 0, 1647239503, 0.5, 0, 60, 0),
('13', 'taxonomy_term', 'portfolio_tags', '/taxonomy/term/13', 'en', 1, 1, 0, 1482294075, 0.5, 0, 60, 0),
('14', 'taxonomy_term', 'portfolio_tags', '/taxonomy/term/14', 'en', 1, 1, 0, 1482294079, 0.5, 0, 60, 0),
('146', 'node', 'gallery', '/node/146', 'en', 1, 1, 0, 1648445738, 0.5, 0, 60, 0),
('148', 'node', 'gallery', '/node/148', 'en', 1, 1, 0, 1648449219, 0.5, 0, 60, 0),
('149', 'node', 'gallery', '/node/149', 'en', 1, 1, 0, 1648449595, 0.5, 0, 60, 0),
('15', 'taxonomy_term', 'category', '/taxonomy/term/15', 'en', 1, 1, 0, 1652950367, 0.5, 0, 60, 0),
('151', 'node', 'page', '/node/151', 'en', 1, 1, 0, 1649864455, 0.5, 0, 60, 0),
('153', 'node', 'projectsh', '/node/153', 'en', 0, 1, 0, 1651823328, 0.5, 0, 60, 0),
('154', 'node', 'projectsh', '/node/154', 'en', 0, 1, 0, 1651210463, 0.5, 0, 60, 0),
('155', 'node', 'projectsh', '/node/155', 'en', 0, 1, 0, 1651210463, 0.5, 0, 60, 0),
('156', 'node', 'projectsh', '/node/156', 'en', 0, 1, 0, 1651210463, 0.5, 0, 60, 0),
('157', 'node', 'projectsh', '/node/157', 'en', 0, 1, 0, 1651210463, 0.5, 0, 60, 0),
('158', 'node', 'projectsh', '/node/158', 'en', 0, 1, 0, 1651210463, 0.5, 0, 60, 0),
('159', 'node', 'projectsh', '/node/159', 'en', 0, 1, 0, 1651210463, 0.5, 0, 60, 0),
('16', 'taxonomy_term', 'project_documents', '/taxonomy/term/16', 'en', 1, 1, 0, 1647848393, 0.5, 0, 60, 0),
('160', 'node', 'projectsh', '/node/160', 'en', 0, 1, 0, 1651210463, 0.5, 0, 60, 0),
('161', 'node', 'projectsh', '/node/161', 'en', 0, 1, 0, 1651210463, 0.5, 0, 60, 0),
('162', 'node', 'projectsh', '/node/162', 'en', 0, 1, 0, 1651210463, 0.5, 0, 60, 0),
('163', 'node', 'projectsh', '/node/163', 'en', 0, 1, 0, 1651210463, 0.5, 0, 60, 0),
('164', 'node', 'projectsh', '/node/164', 'en', 0, 1, 0, 1651210463, 0.5, 0, 60, 0),
('165', 'node', 'projectsh', '/node/165', 'en', 0, 1, 0, 1651210463, 0.5, 0, 60, 0),
('166', 'node', 'projectsh', '/node/166', 'en', 0, 1, 0, 1651210463, 0.5, 0, 60, 0),
('167', 'node', 'projectsh', '/node/167', 'en', 0, 1, 0, 1651210463, 0.5, 0, 60, 0),
('169', 'node', 'thematic-areas', '/node/169', 'en', 1, 1, 0, 1651927372, 0.5, 0, 60, 0),
('17', 'taxonomy_term', 'project_documents', '/taxonomy/term/17', 'en', 1, 1, 0, 1647848407, 0.5, 0, 60, 0),
('170', 'node', 'thematic-areas', '/node/170', 'en', 1, 1, 0, 1651917350, 0.5, 0, 60, 0),
('171', 'node', 'thematic-areas', '/node/171', 'en', 1, 1, 0, 1651838367, 0.5, 0, 60, 0),
('172', 'node', 'thematic-areas', '/node/172', 'en', 1, 1, 0, 1651948947, 0.5, 0, 60, 0),
('173', 'node', 'thematic-areas', '/node/173', 'en', 1, 1, 0, 1651933155, 0.5, 0, 60, 0),
('174', 'node', 'thematic-areas', '/node/174', 'en', 1, 1, 0, 1651819775, 0.5, 0, 60, 0),
('18', 'taxonomy_term', 'category', '/taxonomy/term/18', 'en', 1, 1, 0, 1675173342, 0.5, 0, 60, 0),
('181', 'node', 'projectsh', '/node/181', 'en', 1, 1, 0, 1652017577, 0.5, 0, 60, 0),
('182', 'node', 'projectsh', '/node/182', 'en', 1, 1, 0, 1651917141, 0.5, 0, 60, 0),
('183', 'node', 'projectsh', '/node/183', 'en', 1, 1, 0, 1652001659, 0.5, 0, 60, 0),
('184', 'node', 'projectsh', '/node/184', 'en', 1, 1, 0, 1651917787, 0.5, 0, 60, 0),
('185', 'node', 'projectsh', '/node/185', 'en', 1, 1, 0, 1651918597, 0.5, 0, 60, 0),
('186', 'node', 'projectsh', '/node/186', 'en', 1, 1, 0, 1655890295, 0.5, 0, 60, 0),
('187', 'node', 'projectsh', '/node/187', 'en', 1, 1, 0, 1651997158, 0.5, 0, 60, 0),
('188', 'node', 'projectsh', '/node/188', 'en', 1, 1, 0, 1651995567, 0.5, 0, 60, 0),
('189', 'node', 'projectsh', '/node/189', 'en', 1, 1, 0, 1651999040, 0.5, 0, 60, 0),
('190', 'node', 'projectsh', '/node/190', 'en', 1, 1, 0, 1652013694, 0.5, 0, 60, 0),
('191', 'node', 'projectsh', '/node/191', 'en', 1, 1, 0, 1651930459, 0.5, 0, 60, 0),
('192', 'node', 'projectsh', '/node/192', 'en', 1, 1, 0, 1651992409, 0.5, 0, 60, 0),
('193', 'node', 'projectsh', '/node/193', 'en', 1, 1, 0, 1651993441, 0.5, 0, 60, 0),
('194', 'node', 'projectsh', '/node/194', 'en', 1, 1, 0, 1651950333, 0.5, 0, 60, 0),
('197', 'node', 'projectsh', '/node/197', 'en', 1, 1, 0, 1651996630, 0.5, 0, 60, 0),
('198', 'node', 'projectsh', '/node/198', 'en', 1, 1, 0, 1651996025, 0.5, 0, 60, 0),
('199', 'node', 'projectsh', '/node/199', 'en', 1, 1, 0, 1651932946, 0.5, 0, 60, 0),
('2', 'node', 'page', '/node/2', 'en', 1, 1, 0, 1654165444, 1, 0, 86400, 0),
('200', 'node', 'projectsh', '/node/200', 'en', 1, 1, 0, 1651932972, 0.5, 0, 60, 0),
('201', 'node', 'projectsh', '/node/201', 'en', 1, 1, 0, 1651996240, 0.5, 0, 60, 0),
('202', 'node', 'projectsh', '/node/202', 'en', 1, 1, 0, 1652003830, 0.5, 0, 60, 0),
('203', 'node', 'thematic-areas', '/node/203', 'en', 1, 1, 0, 1651935460, 0.5, 0, 60, 0),
('204', 'node', 'partner', '/node/204', 'en', 1, 1, 0, 1651989585, 0.5, 0, 60, 0),
('205', 'node', 'partner', '/node/205', 'en', 1, 1, 0, 1651989454, 0.5, 0, 60, 0),
('206', 'node', 'partner', '/node/206', 'en', 1, 1, 0, 1651989466, 0.5, 0, 60, 0),
('207', 'node', 'gallery', '/node/207', 'en', 1, 1, 0, 1651987630, 0.5, 0, 60, 0),
('208', 'node', 'gallery', '/node/208', 'en', 1, 1, 0, 1651988097, 0.5, 0, 60, 0),
('209', 'node', 'gallery', '/node/209', 'en', 1, 1, 0, 1651988193, 0.5, 0, 60, 0),
('210', 'node', 'gallery', '/node/210', 'en', 1, 1, 0, 1651988445, 0.5, 0, 60, 0),
('211', 'node', 'gallery', '/node/211', 'en', 1, 1, 0, 1651988651, 0.5, 0, 60, 0),
('212', 'node', 'gallery', '/node/212', 'en', 1, 1, 0, 1651988879, 0.5, 0, 60, 0),
('213', 'node', 'gallery', '/node/213', 'en', 1, 1, 0, 1651989108, 0.5, 0, 60, 0),
('215', 'node', 'partner', '/node/215', 'en', 1, 1, 0, 1651990733, 0.5, 0, 60, 0),
('216', 'node', 'partner', '/node/216', 'en', 1, 1, 0, 1651990795, 0.5, 0, 60, 0),
('217', 'node', 'gallery', '/node/217', 'en', 1, 1, 0, 1652009682, 0.5, 0, 60, 0),
('218', 'node', 'page', '/node/218', 'en', 1, 1, 0, 1652026191, 0.5, 0, 60, 0),
('219', 'node', 'wee-videos', '/node/219', 'en', 1, 1, 0, 1652081959, 0.5, 0, 60, 0),
('220', 'node', 'partner', '/node/220', 'en', 1, 1, 0, 1652083787, 0.5, 0, 60, 0),
('221', 'node', 'partner', '/node/221', 'en', 1, 1, 0, 1652083916, 0.5, 0, 60, 0),
('222', 'node', 'partner', '/node/222', 'en', 1, 1, 0, 1652084013, 0.5, 0, 60, 0),
('223', 'node', 'partner', '/node/223', 'en', 1, 1, 0, 1652084080, 0.5, 0, 60, 0),
('224', 'node', 'partner', '/node/224', 'en', 1, 1, 0, 1652084126, 0.5, 0, 60, 0),
('225', 'node', 'partner', '/node/225', 'en', 1, 1, 0, 1652084202, 0.5, 0, 60, 0),
('226', 'node', 'partner', '/node/226', 'en', 1, 1, 0, 1652084260, 0.5, 0, 60, 0),
('227', 'node', 'partner', '/node/227', 'en', 1, 1, 0, 1652084314, 0.5, 0, 60, 0),
('228', 'node', 'partner', '/node/228', 'en', 1, 1, 0, 1652084414, 0.5, 0, 60, 0),
('229', 'node', 'partner', '/node/229', 'en', 1, 1, 0, 1652966360, 0.5, 0, 60, 0),
('230', 'node', 'partner', '/node/230', 'en', 1, 1, 0, 1652966403, 0.5, 0, 60, 0),
('231', 'node', 'wee-videos', '/node/231', 'en', 1, 1, 0, 1652095307, 0.5, 0, 60, 0),
('234', 'node', 'gallery', '/node/234', 'en', 1, 1, 0, 1652247632, 0.5, 0, 60, 0),
('235', 'node', 'gallery', '/node/235', 'en', 1, 1, 0, 1652247878, 0.5, 0, 60, 0),
('236', 'node', 'article', '/node/236', 'en', 1, 1, 0, 1652292151, 0.5, 0, 60, 0),
('237', 'node', 'gallery', '/node/237', 'en', 1, 1, 0, 1652622377, 0.5, 0, 60, 0),
('238', 'node', 'gallery', '/node/238', 'en', 1, 1, 0, 1652636330, 0.5, 0, 60, 0),
('239', 'node', 'article', '/node/239', 'en', 1, 1, 0, 1653333261, 0.5, 0, 60, 0),
('240', 'node', 'page', '/node/240', 'en', 1, 1, 0, 1655890080, 0.5, 0, 60, 0),
('243', 'node', 'projectsh', '/node/243', 'en', 1, 1, 0, 1654167373, 0.5, 0, 60, 0),
('244', 'node', 'article', '/node/244', 'en', 0, 1, 0, 1658998235, 0.5, 0, 60, 0),
('245', 'node', 'article', '/node/245', 'en', 1, 1, 0, 1654167728, 0.5, 0, 60, 0),
('253', 'node', 'article', '/node/253', 'en', 1, 1, 0, 1658997913, 0.5, 0, 60, 0),
('256', 'node', 'gallery', '/node/256', 'en', 1, 1, 0, 1659339575, 0.5, 0, 60, 0),
('257', 'node', 'article', '/node/257', 'en', 1, 1, 0, 1660759005, 0.5, 0, 60, 0),
('258', 'node', 'article', '/node/258', 'en', 1, 1, 0, 1660764736, 0.5, 0, 60, 0),
('259', 'node', 'gallery', '/node/259', 'en', 1, 1, 0, 1660764575, 0.5, 0, 60, 0),
('263', 'node', 'policy-briefs', '/node/263', 'en', 1, 1, 0, 1661345288, 0.5, 0, 60, 0),
('264', 'node', 'publications', '/node/264', 'en', 1, 1, 0, 1661422048, 0.5, 0, 60, 0),
('265', 'node', 'publications', '/node/265', 'en', 1, 1, 0, 1661422277, 0.5, 0, 60, 0),
('266', 'node', 'publications', '/node/266', 'en', 1, 1, 0, 1661422364, 0.5, 0, 60, 0),
('267', 'node', 'policy-briefs', '/node/267', 'en', 1, 1, 0, 1661793546, 0.5, 0, 60, 0),
('268', 'node', 'policy-briefs', '/node/268', 'en', 1, 1, 0, 1661793825, 0.5, 0, 60, 0),
('269', 'node', 'policy-briefs', '/node/269', 'en', 1, 1, 0, 1661794044, 0.5, 0, 60, 0),
('270', 'node', 'policy-briefs', '/node/270', 'en', 1, 1, 0, 1661794204, 0.5, 0, 60, 0),
('271', 'node', 'policy-briefs', '/node/271', 'en', 1, 1, 0, 1661794330, 0.5, 0, 60, 0),
('272', 'node', 'policy-briefs', '/node/272', 'en', 1, 1, 0, 1661794612, 0.5, 0, 60, 0),
('273', 'node', 'policy-briefs', '/node/273', 'en', 1, 1, 0, 1661794665, 0.5, 0, 60, 0),
('274', 'node', 'page', '/node/274', 'en', 1, 1, 0, 1662013885, 0.5, 0, 60, 0),
('275', 'node', 'gallery', '/node/275', 'en', 1, 1, 0, 1662058132, 0.5, 0, 60, 0),
('276', 'node', 'article', '/node/276', 'en', 1, 1, 0, 1662058771, 0.5, 0, 60, 0),
('277', 'node', 'career', '/node/277', 'en', 1, 1, 0, 1662361466, 0.5, 0, 60, 0),
('278', 'node', 'article', '/node/278', 'en', 1, 1, 0, 1662611209, 0.5, 0, 60, 0),
('279', 'node', 'team', '/node/279', 'en', 1, 1, 0, 1663924607, 0.5, 0, 60, 0),
('280', 'node', 'publications', '/node/280', 'en', 1, 1, 0, 1663926115, 0.5, 0, 60, 0),
('281', 'node', 'gallery', '/node/281', 'en', 1, 1, 0, 1663945814, 0.5, 0, 60, 0),
('282', 'node', 'event', '/node/282', 'en', 1, 1, 0, 1664421642, 0.5, 0, 60, 0),
('283', 'node', 'article', '/node/283', 'en', 1, 1, 0, 1665123954, 0.5, 0, 60, 0),
('284', 'node', 'article', '/node/284', 'en', 1, 1, 0, 1669351457, 0.5, 0, 60, 0),
('285', 'node', 'article', '/node/285', 'en', 1, 1, 0, 1670474573, 0.5, 0, 60, 0),
('286', 'node', 'article', '/node/286', 'en', 1, 1, 0, 1670474708, 0.5, 0, 60, 0),
('287', 'node', 'article', '/node/287', 'en', 1, 1, 0, 1670525820, 0.5, 0, 60, 0),
('288', 'node', 'article', '/node/288', 'en', 1, 1, 0, 1670826269, 0.5, 0, 60, 0),
('289', 'node', 'article', '/node/289', 'en', 1, 1, 0, 1672641422, 0.5, 0, 60, 0),
('290', 'node', 'article', '/node/290', 'en', 1, 1, 0, 1673372988, 0.5, 0, 60, 0),
('291', 'node', 'publications', '/node/291', 'en', 1, 1, 0, 1673536008, 0.5, 0, 60, 0),
('292', 'node', 'publications', '/node/292', 'en', 1, 1, 0, 1673544425, 0.5, 0, 60, 0),
('293', 'node', 'publications', '/node/293', 'en', 1, 1, 0, 1673544583, 0.5, 0, 60, 0),
('294', 'node', 'article', '/node/294', 'en', 1, 1, 0, 1675173369, 0.5, 0, 60, 0),
('295', 'node', 'event', '/node/295', 'en', 1, 1, 0, 1677078386, 0.5, 0, 60, 0),
('296', 'node', 'gallery', '/node/296', 'en', 1, 1, 0, 1677137422, 0.5, 0, 60, 0),
('297', 'node', 'gallery', '/node/297', 'en', 1, 1, 0, 1677528453, 0.5, 0, 60, 0),
('298', 'node', 'article', '/node/298', 'en', 1, 1, 0, 1677529134, 0.5, 0, 60, 0),
('299', 'node', 'article', '/node/299', 'en', 1, 1, 0, 1677856109, 0.5, 0, 60, 0),
('301', 'node', 'gallery', '/node/301', 'en', 1, 1, 0, 1677842305, 0.5, 0, 60, 0),
('31', 'node', 'banner', '/node/31', 'en', 1, 1, 0, 1647445575, 0.5, 0, 60, 0),
('33', 'node', 'banner', '/node/33', 'en', 1, 1, 0, 1647444480, 0.5, 0, 60, 0),
('35', 'node', 'banner', '/node/35', 'en', 1, 1, 0, 1647444989, 0.5, 0, 60, 0),
('36', 'node', 'banner', '/node/36', 'en', 1, 1, 0, 1647445035, 0.5, 0, 60, 0),
('37', 'node', 'banner', '/node/37', 'en', 1, 1, 0, 1647445087, 0.5, 0, 60, 0),
('38', 'node', 'banner', '/node/38', 'en', 1, 1, 0, 1647445315, 0.5, 0, 60, 0),
('6', 'taxonomy_term', 'category', '/taxonomy/term/6', 'en', 1, 1, 0, 1652950278, 0.5, 0, 60, 0),
('7', 'taxonomy_term', 'tags', '/taxonomy/term/7', 'en', 1, 1, 0, 1482294017, 0.5, 0, 60, 0),
('70', 'node', 'page', '/node/70', 'en', 1, 1, 0, 1651137191, 0.5, 0, 60, 0),
('75', 'node', 'page', '/node/75', 'en', 1, 1, 0, 1525256309, 0.5, 0, 60, 0),
('8', 'taxonomy_term', 'tags', '/taxonomy/term/8', 'en', 1, 1, 0, 1482294035, 0.5, 0, 60, 0),
('9', 'taxonomy_term', 'tags', '/taxonomy/term/9', 'en', 1, 1, 0, 1482294040, 0.5, 0, 60, 0);

--
-- 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_field__type__target_id` (`type`),
  ADD KEY `block_content__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
  ADD KEY `block_content__revision_id` (`revision_id`),
  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_field__revision_user__target_id` (`revision_user`),
  ADD KEY `block_content__id` (`id`);

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

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

--
-- Indexes for table `book`
--
ALTER TABLE `book`
  ADD PRIMARY KEY (`nid`),
  ADD KEY `book_parents` (`bid`,`p1`,`p2`,`p3`,`p4`,`p5`,`p6`,`p7`,`p8`,`p9`);

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

--
-- 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_mailchimp`
--
ALTER TABLE `cache_mailchimp`
  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 `cache_tweets`
--
ALTER TABLE `cache_tweets`
  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__created` (`created`),
  ADD KEY `comment__status_comment_type` (`status`,`comment_type`,`cid`),
  ADD KEY `comment__status_pid` (`pid`,`status`),
  ADD KEY `comment_field__uid__target_id` (`uid`),
  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 `comment__field_comment`
--
ALTER TABLE `comment__field_comment`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

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

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

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

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

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

--
-- Indexes for table `content_kanban_log`
--
ALTER TABLE `content_kanban_log`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `content_kanban_log_field__uuid__value` (`uuid`),
  ADD KEY `content_kanban_log_field__user_id__target_id` (`user_id`),
  ADD KEY `content_kanban_log_field__workflow_id__target_id` (`workflow_id`);

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

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

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

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

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

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

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

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

--
-- Indexes for table `entity_subqueue`
--
ALTER TABLE `entity_subqueue`
  ADD PRIMARY KEY (`name`),
  ADD UNIQUE KEY `entity_subqueue_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `entity_subqueue__revision_id` (`revision_id`),
  ADD KEY `entity_subqueue_field__queue__target_id` (`queue`);

--
-- Indexes for table `entity_subqueue_field_data`
--
ALTER TABLE `entity_subqueue_field_data`
  ADD PRIMARY KEY (`name`,`langcode`),
  ADD KEY `entity_subqueue__id__default_langcode__langcode` (`name`,`default_langcode`,`langcode`),
  ADD KEY `entity_subqueue__revision_id` (`revision_id`),
  ADD KEY `entity_subqueue_field__queue__target_id` (`queue`),
  ADD KEY `entity_subqueue_field__uid__target_id` (`uid`),
  ADD KEY `entity_subqueue__status_queue` (`status`,`queue`,`name`);

--
-- Indexes for table `entity_subqueue_field_revision`
--
ALTER TABLE `entity_subqueue_field_revision`
  ADD PRIMARY KEY (`revision_id`,`langcode`),
  ADD KEY `entity_subqueue__id__default_langcode__langcode` (`name`,`default_langcode`,`langcode`),
  ADD KEY `entity_subqueue_field__uid__target_id` (`uid`);

--
-- Indexes for table `entity_subqueue_revision`
--
ALTER TABLE `entity_subqueue_revision`
  ADD PRIMARY KEY (`revision_id`),
  ADD KEY `entity_subqueue__name` (`name`),
  ADD KEY `entity_subqueue_field__revision_user__target_id` (`revision_user`);

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

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

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

--
-- 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 `flagging`
--
ALTER TABLE `flagging`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `flagging_field__uuid__value` (`uuid`),
  ADD KEY `flagging_field__flag_id__target_id` (`flag_id`),
  ADD KEY `flagging_field__uid__target_id` (`uid`),
  ADD KEY `entity_id__uid` (`entity_id`(191),`uid`);

--
-- Indexes for table `flag_counts`
--
ALTER TABLE `flag_counts`
  ADD PRIMARY KEY (`flag_id`,`entity_id`),
  ADD KEY `flag_id_entity_type` (`flag_id`,`entity_type`),
  ADD KEY `entity_type_entity_id` (`entity_type`,`entity_id`),
  ADD KEY `flag_id_count` (`flag_id`,`count`),
  ADD KEY `flag_id_last_updated` (`flag_id`,`last_updated`);

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

--
-- Indexes for table `foldershare`
--
ALTER TABLE `foldershare`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `foldershare_field__uuid__value` (`uuid`),
  ADD KEY `foldershare_field__uid__target_id` (`uid`),
  ADD KEY `foldershare_field__description__format` (`description__format`),
  ADD KEY `foldershare_field__parentid__target_id` (`parentid`),
  ADD KEY `foldershare_field__rootid__target_id` (`rootid`),
  ADD KEY `foldershare_field__file__target_id` (`file__target_id`),
  ADD KEY `foldershare_field__image__target_id` (`image__target_id`),
  ADD KEY `foldershare_field__media__target_id` (`media`);

--
-- Indexes for table `foldershare_scheduledtask`
--
ALTER TABLE `foldershare_scheduledtask`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `foldershare_scheduledtask_field__uuid__value` (`uuid`),
  ADD KEY `foldershare_scheduledtask_field__uid__target_id` (`uid`);

--
-- Indexes for table `foldershare_usage`
--
ALTER TABLE `foldershare_usage`
  ADD PRIMARY KEY (`uid`);

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

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

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

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

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

--
-- Indexes for table `gavias_sliderlayers`
--
ALTER TABLE `gavias_sliderlayers`
  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 `expire` (`expire`);

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

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

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

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

--
-- Indexes for table `media_revision__field_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`);

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

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

--
-- Indexes for table `menu_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_counter`
--
ALTER TABLE `node_counter`
  ADD PRIMARY KEY (`nid`);

--
-- 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__created` (`created`),
  ADD KEY `node_field__changed` (`changed`),
  ADD KEY `node__frontpage` (`promote`,`status`,`sticky`,`created`),
  ADD KEY `node__status_type` (`status`,`type`,`nid`),
  ADD KEY `node__title_type` (`title`(191),`type`(4)),
  ADD KEY `node_field__gva_node_layout__value` (`gva_node_layout`(191)),
  ADD KEY `node_field__gva_breadcrumb__value` (`gva_breadcrumb`(191)),
  ADD KEY `node_field__gva_header__value` (`gva_header`(191)),
  ADD KEY `node_field__gva_box_layout__value` (`gva_box_layout`(191)),
  ADD KEY `node_field__uid__target_id` (`uid`);

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

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

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

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

--
-- 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_value` (`field_category_value`(191));

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

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

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

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

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

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

--
-- Indexes for table `node_revision__field_event_address`
--
ALTER TABLE `node_revision__field_event_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_event_image`
--
ALTER TABLE `node_revision__field_event_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_event_image_target_id` (`field_event_image_target_id`);

--
-- Indexes for table `node_revision__field_event_map`
--
ALTER TABLE `node_revision__field_event_map`
  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`
--
ALTER TABLE `node_revision__field_event_start`
  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_value` (`field_event_start_value`);

--
-- Indexes for table `node_revision__field_event_time`
--
ALTER TABLE `node_revision__field_event_time`
  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_featured_image`
--
ALTER TABLE `node_revision__field_featured_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_featured_image_target_id` (`field_featured_image_target_id`);

--
-- Indexes for table `node_revision__field_gallery_image`
--
ALTER TABLE `node_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 `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_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_meta_tags`
--
ALTER TABLE `node_revision__field_meta_tags`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

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

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

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

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

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

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

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

--
-- 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_project_end_date`
--
ALTER TABLE `node_revision__field_project_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_project_end_date_value` (`field_project_end_date_value`);

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

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

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

--
-- Indexes for table `node_revision__field_project_start_date`
--
ALTER TABLE `node_revision__field_project_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_project_start_date_value` (`field_project_start_date_value`);

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

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

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

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

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

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

--
-- Indexes for table `node_revision__field_team_contact`
--
ALTER TABLE `node_revision__field_team_contact`
  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_team_description`
--
ALTER TABLE `node_revision__field_team_description`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_team_description_format` (`field_team_description_format`);

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

--
-- Indexes for table `node_revision__field_team_facebook`
--
ALTER TABLE `node_revision__field_team_facebook`
  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_team_google`
--
ALTER TABLE `node_revision__field_team_google`
  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_team_image`
--
ALTER TABLE `node_revision__field_team_image`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_team_image_target_id` (`field_team_image_target_id`);

--
-- Indexes for table `node_revision__field_team_name`
--
ALTER TABLE `node_revision__field_team_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_team_pinterest`
--
ALTER TABLE `node_revision__field_team_pinterest`
  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_team_position`
--
ALTER TABLE `node_revision__field_team_position`
  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_team_quote`
--
ALTER TABLE `node_revision__field_team_quote`
  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_team_skills`
--
ALTER TABLE `node_revision__field_team_skills`
  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_team_twitter`
--
ALTER TABLE `node_revision__field_team_twitter`
  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_testimonial_avatar`
--
ALTER TABLE `node_revision__field_testimonial_avatar`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_testimonial_avatar_target_id` (`field_testimonial_avatar_target_id`);

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

--
-- Indexes for table `node_revision__field_testimonial_job`
--
ALTER TABLE `node_revision__field_testimonial_job`
  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_testimonial_name`
--
ALTER TABLE `node_revision__field_testimonial_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_testimonial_video`
--
ALTER TABLE `node_revision__field_testimonial_video`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

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

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

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

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

--
-- Indexes for table `node_revision__field_upload_publication`
--
ALTER TABLE `node_revision__field_upload_publication`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_upload_publication_target_id` (`field_upload_publication_target_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_revision__taxonomy_catalog`
--
ALTER TABLE `node_revision__taxonomy_catalog`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `taxonomy_catalog_target_id` (`taxonomy_catalog_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_application_deadline`
--
ALTER TABLE `node__field_application_deadline`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_application_deadline_value` (`field_application_deadline_value`);

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

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

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

--
-- 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_value` (`field_category_value`(191));

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `node__field_upload_publication`
--
ALTER TABLE `node__field_upload_publication`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_upload_publication_target_id` (`field_upload_publication_target_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 `node__taxonomy_catalog`
--
ALTER TABLE `node__taxonomy_catalog`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `taxonomy_catalog_target_id` (`taxonomy_catalog_target_id`);

--
-- Indexes for table `old_5def43_url_alias`
--
ALTER TABLE `old_5def43_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 `old_411ccbmenu_link_content`
--
ALTER TABLE `old_411ccbmenu_link_content`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `menu_link_content_field__uuid__value` (`uuid`);

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

--
-- Indexes for table `old_da7c99taxonomy_term_data`
--
ALTER TABLE `old_da7c99taxonomy_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 `old_da7c99taxonomy_term_field_data`
--
ALTER TABLE `old_da7c99taxonomy_term_field_data`
  ADD PRIMARY KEY (`tid`,`langcode`),
  ADD KEY `taxonomy_term_field__name` (`name`(191)),
  ADD KEY `taxonomy_term__id__default_langcode__langcode` (`tid`,`default_langcode`,`langcode`),
  ADD KEY `taxonomy_term__tree` (`vid`,`weight`,`name`(191)),
  ADD KEY `taxonomy_term__vid_name` (`vid`,`name`(191)),
  ADD KEY `taxonomy_term__status_vid` (`status`,`vid`,`tid`);

--
-- Indexes for table `old_da7c99taxonomy_term__parent`
--
ALTER TABLE `old_da7c99taxonomy_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 `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_api_item`
--
ALTER TABLE `search_api_item`
  ADD PRIMARY KEY (`index_id`,`item_id`),
  ADD KEY `indexing` (`index_id`,`status`,`changed`,`item_id`);

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

--
-- Indexes for table `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 `simple_sitemap`
--
ALTER TABLE `simple_sitemap`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type_status_delta` (`type`,`status`,`delta`);

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

--
-- Indexes for table `simple_sitemap_views`
--
ALTER TABLE `simple_sitemap_views`
  ADD PRIMARY KEY (`id`),
  ADD KEY `arguments_ids` (`view_id`,`display_id`,`arguments_ids`(191));

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

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

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

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

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

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

--
-- Indexes for table `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_description`
--
ALTER TABLE `taxonomy_term__field_description`
  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 `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 `watchdog`
--
ALTER TABLE `watchdog`
  ADD PRIMARY KEY (`wid`),
  ADD KEY `type` (`type`),
  ADD KEY `uid` (`uid`),
  ADD KEY `severity` (`severity`);

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

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

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

--
-- Indexes for table `webform_submission_log`
--
ALTER TABLE `webform_submission_log`
  ADD PRIMARY KEY (`lid`),
  ADD KEY `webform_id` (`webform_id`),
  ADD KEY `sid` (`sid`),
  ADD KEY `uid` (`uid`),
  ADD KEY `handler_id` (`handler_id`),
  ADD KEY `handler_id_operation` (`handler_id`,`operation`);

--
-- Indexes for table `xmlsitemap`
--
ALTER TABLE `xmlsitemap`
  ADD PRIMARY KEY (`id`,`type`,`language`),
  ADD KEY `loc` (`loc`(191)),
  ADD KEY `access_status_loc` (`access`,`status`,`loc`(191)),
  ADD KEY `type_subtype` (`type`,`subtype`);

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

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

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

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

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

--
-- AUTO_INCREMENT for table `content_moderation_state_revision`
--
ALTER TABLE `content_moderation_state_revision`
  MODIFY `revision_id` 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=521;

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

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

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

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

--
-- 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 `foldershare`
--
ALTER TABLE `foldershare`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

--
-- AUTO_INCREMENT for table `gavias_content_builder`
--
ALTER TABLE `gavias_content_builder`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;

--
-- AUTO_INCREMENT for table `gavias_sliderlayergroups`
--
ALTER TABLE `gavias_sliderlayergroups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `gavias_sliderlayers`
--
ALTER TABLE `gavias_sliderlayers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `simple_sitemap_views`
--
ALTER TABLE `simple_sitemap_views`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique ID for argument values.';

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

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

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `uid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

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

--
-- AUTO_INCREMENT for table `webform_submission`
--
ALTER TABLE `webform_submission`
  MODIFY `sid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `webform_submission_log`
--
ALTER TABLE `webform_submission_log`
  MODIFY `lid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique log event ID.';
COMMIT;

