INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(24646946, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 10992 characters], 3, '', 'https://uog.edu.gy/apple-touch-icon-120x120.png', '', '168.232.145.74', 1722954985),
(24646947, 0, 'cron', 'Starting execution of @module_cron().', 0x613a313a7b733a373a22406d6f64756c65223b733a373a2263617074636861223b7d, 6, '', 'https://uog.edu.gy/apple-touch-icon-precomposed.png', '', '168.232.145.74', 1722954985),
(24646948, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a373a22636f6d6d656e74223b733a31363a22406d6f64756c655f70726576696f7573223b733a373a2263617074636861223b733a353a224074696d65223b733a363a22302e32346d73223b7d, 6, '', 'https://uog.edu.gy/apple-touch-icon-precomposed.png', '', '168.232.145.74', 1722954985),
(24646949, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a353a2264626c6f67223b733a31363a22406d6f64756c655f70726576696f7573223b733a373a22636f6d6d656e74223b733a353a224074696d65223b733a363a22312e32326d73223b7d, 6, '', 'https://uog.edu.gy/apple-touch-icon-precomposed.png', '', '168.232.145.74', 1722954985),
(24646950, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a353a226669656c64223b733a31363a22406d6f64756c655f70726576696f7573223b733a353a2264626c6f67223b733a353a224074696d65223b733a363a22302e39366d73223b7d, 6, '', 'https://uog.edu.gy/apple-touch-icon-precomposed.png', '', '168.232.145.74', 1722954985),
(24646951, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a343a2266696c65223b733a31363a22406d6f64756c655f70726576696f7573223b733a353a226669656c64223b733a353a224074696d65223b733a363a22302e34376d73223b7d, 6, '', 'https://uog.edu.gy/apple-touch-icon-precomposed.png', '', '168.232.145.74', 1722954985),
(24646952, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a31363a22676f6f676c655f616e616c7974696373223b733a31363a22406d6f64756c655f70726576696f7573223b733a343a2266696c65223b733a353a224074696d65223b733a363a22392e37396d73223b7d, 6, '', 'https://uog.edu.gy/apple-touch-icon-precomposed.png', '', '168.232.145.74', 1722954985),
(24646953, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a373a22686973746f7279223b733a31363a22406d6f64756c655f70726576696f7573223b733a31363a22676f6f676c655f616e616c7974696373223b733a353a224074696d65223b733a363a22312e36376d73223b7d, 6, '', 'https://uog.edu.gy/apple-touch-icon-precomposed.png', '', '168.232.145.74', 1722954985),
(24646954, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a343a226e6f6465223b733a31363a22406d6f64756c655f70726576696f7573223b733a373a22686973746f7279223b733a353a224074696d65223b733a363a22302e31346d73223b7d, 6, '', 'https://uog.edu.gy/apple-touch-icon-precomposed.png', '', '168.232.145.74', 1722954985),
(24646955, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a363a2270686f746f73223b733a31363a22406d6f64756c655f70726576696f7573223b733a343a226e6f6465223b733a353a224074696d65223b733a363a22352e34366d73223b7d, 6, '', 'https://uog.edu.gy/apple-touch-icon-precomposed.png', '', '168.232.145.74', 1722954985),
(24646956, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a363a22736561726368223b733a31363a22406d6f64756c655f70726576696f7573223b733a363a2270686f746f73223b733a353a224074696d65223b733a363a22392e31336d73223b7d, 6, '', 'https://uog.edu.gy/apple-touch-icon-precomposed.png', '', '168.232.145.74', 1722954985),
(24646957, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 10992 characters], 3, '', 'https://uog.edu.gy/apple-touch-icon-precomposed.png', '', '168.232.145.74', 1722954985),
(24646958, 0, 'cron', 'Starting execution of @module_cron().', 0x613a313a7b733a373a22406d6f64756c65223b733a373a2263617074636861223b7d, 6, '', 'https://uog.edu.gy/apple-touch-icon.png', '', '168.232.145.74', 1722954985),
(24646959, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a373a22636f6d6d656e74223b733a31363a22406d6f64756c655f70726576696f7573223b733a373a2263617074636861223b733a353a224074696d65223b733a363a22302e33326d73223b7d, 6, '', 'https://uog.edu.gy/apple-touch-icon.png', '', '168.232.145.74', 1722954985),
(24646960, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a353a2264626c6f67223b733a31363a22406d6f64756c655f70726576696f7573223b733a373a22636f6d6d656e74223b733a353a224074696d65223b733a363a22312e33396d73223b7d, 6, '', 'https://uog.edu.gy/apple-touch-icon.png', '', '168.232.145.74', 1722954985),
(24646961, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a353a226669656c64223b733a31363a22406d6f64756c655f70726576696f7573223b733a353a2264626c6f67223b733a353a224074696d65223b733a333a22316d73223b7d, 6, '', 'https://uog.edu.gy/apple-touch-icon.png', '', '168.232.145.74', 1722954985),
(24646962, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a343a2266696c65223b733a31363a22406d6f64756c655f70726576696f7573223b733a353a226669656c64223b733a353a224074696d65223b733a363a22302e34336d73223b7d, 6, '', 'https://uog.edu.gy/apple-touch-icon.png', '', '168.232.145.74', 1722954985),
(24646963, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a31363a22676f6f676c655f616e616c7974696373223b733a31363a22406d6f64756c655f70726576696f7573223b733a343a2266696c65223b733a353a224074696d65223b733a363a22392e35386d73223b7d, 6, '', 'https://uog.edu.gy/apple-touch-icon.png', '', '168.232.145.74', 1722954985),
(24646964, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a373a22686973746f7279223b733a31363a22406d6f64756c655f70726576696f7573223b733a31363a22676f6f676c655f616e616c7974696373223b733a353a224074696d65223b733a363a22312e39336d73223b7d, 6, '', 'https://uog.edu.gy/apple-touch-icon.png', '', '168.232.145.74', 1722954985),
(24646965, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a343a226e6f6465223b733a31363a22406d6f64756c655f70726576696f7573223b733a373a22686973746f7279223b733a353a224074696d65223b733a363a22302e31346d73223b7d, 6, '', 'https://uog.edu.gy/apple-touch-icon.png', '', '168.232.145.74', 1722954985),
(24646966, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a363a2270686f746f73223b733a31363a22406d6f64756c655f70726576696f7573223b733a343a226e6f6465223b733a353a224074696d65223b733a363a22352e37326d73223b7d, 6, '', 'https://uog.edu.gy/apple-touch-icon.png', '', '168.232.145.74', 1722954985),
(24646967, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a363a22736561726368223b733a31363a22406d6f64756c655f70726576696f7573223b733a363a2270686f746f73223b733a353a224074696d65223b733a363a22392e37396d73223b7d, 6, '', 'https://uog.edu.gy/apple-touch-icon.png', '', '168.232.145.74', 1722954985),
(24646968, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 10992 characters], 3, '', 'https://uog.edu.gy/apple-touch-icon.png', '', '168.232.145.74', 1722954986),
(24646969, 0, 'page not found', '@uri', 0x613a313a7b733a343a2240757269223b733a39393a222f73726d732f6465706172746d656e74732f33392f3839302f6465706172746d656e74732f36362f6465706172746d656e74732f3133332f6465706172746d656e74732f3235342f6465706172746d656e74732f3232342f70726f6772616d6d65732f223b7d, 4, '', 'https://uog.edu.gy/srms/departments/39/890/departments/66/departments/133/departments/254/departments/224/programmes/', '', '40.77.167.51', 1722954988),
(24646970, 0, 'cron', 'Starting execution of @module_cron().', 0x613a313a7b733a373a22406d6f64756c65223b733a373a2263617074636861223b7d, 6, '', 'https://uog.edu.gy/srms/departments/39/890/departments/66/departments/133/departments/254/departments/224/programmes/', '', '40.77.167.51', 1722954988),
(24646971, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a373a22636f6d6d656e74223b733a31363a22406d6f64756c655f70726576696f7573223b733a373a2263617074636861223b733a353a224074696d65223b733a363a22302e33356d73223b7d, 6, '', 'https://uog.edu.gy/srms/departments/39/890/departments/66/departments/133/departments/254/departments/224/programmes/', '', '40.77.167.51', 1722954988),
(24646972, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a353a2264626c6f67223b733a31363a22406d6f64756c655f70726576696f7573223b733a373a22636f6d6d656e74223b733a353a224074696d65223b733a353a22312e366d73223b7d, 6, '', 'https://uog.edu.gy/srms/departments/39/890/departments/66/departments/133/departments/254/departments/224/programmes/', '', '40.77.167.51', 1722954988),
(24646973, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a353a226669656c64223b733a31363a22406d6f64756c655f70726576696f7573223b733a353a2264626c6f67223b733a353a224074696d65223b733a363a22312e30376d73223b7d, 6, '', 'https://uog.edu.gy/srms/departments/39/890/departments/66/departments/133/departments/254/departments/224/programmes/', '', '40.77.167.51', 1722954988),
(24646974, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a343a2266696c65223b733a31363a22406d6f64756c655f70726576696f7573223b733a353a226669656c64223b733a353a224074696d65223b733a363a22302e36326d73223b7d, 6, '', 'https://uog.edu.gy/srms/departments/39/890/departments/66/departments/133/departments/254/departments/224/programmes/', '', '40.77.167.51', 1722954988),
(24646975, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a31363a22676f6f676c655f616e616c7974696373223b733a31363a22406d6f64756c655f70726576696f7573223b733a343a2266696c65223b733a353a224074696d65223b733a363a22312e35386d73223b7d, 6, '', 'https://uog.edu.gy/srms/departments/39/890/departments/66/departments/133/departments/254/departments/224/programmes/', '', '40.77.167.51', 1722954988),
(24646976, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a373a22686973746f7279223b733a31363a22406d6f64756c655f70726576696f7573223b733a31363a22676f6f676c655f616e616c7974696373223b733a353a224074696d65223b733a363a22302e31356d73223b7d, 6, '', 'https://uog.edu.gy/srms/departments/39/890/departments/66/departments/133/departments/254/departments/224/programmes/', '', '40.77.167.51', 1722954988),
(24646977, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a343a226e6f6465223b733a31363a22406d6f64756c655f70726576696f7573223b733a373a22686973746f7279223b733a353a224074696d65223b733a363a22302e31346d73223b7d, 6, '', 'https://uog.edu.gy/srms/departments/39/890/departments/66/departments/133/departments/254/departments/224/programmes/', '', '40.77.167.51', 1722954988),
(24646978, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a363a2270686f746f73223b733a31363a22406d6f64756c655f70726576696f7573223b733a343a226e6f6465223b733a353a224074696d65223b733a363a22342e32396d73223b7d, 6, '', 'https://uog.edu.gy/srms/departments/39/890/departments/66/departments/133/departments/254/departments/224/programmes/', '', '40.77.167.51', 1722954988),
(24646979, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a363a22736561726368223b733a31363a22406d6f64756c655f70726576696f7573223b733a363a2270686f746f73223b733a353a224074696d65223b733a373a2231302e30356d73223b7d, 6, '', 'https://uog.edu.gy/srms/departments/39/890/departments/66/departments/133/departments/254/departments/224/programmes/', '', '40.77.167.51', 1722954988);
INSERT INTO `watchdog` (`wid`, `uid`, `type`, `message`, `variables`, `severity`, `link`, `location`, `referer`, `hostname`, `timestamp`) VALUES
(24646980, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 10992 characters], 3, '', 'https://uog.edu.gy/srms/departments/39/890/departments/66/departments/133/departments/254/departments/224/programmes/', '', '40.77.167.51', 1722954988),
(24646981, 0, 'cron', 'Starting execution of @module_cron().', 0x613a313a7b733a373a22406d6f64756c65223b733a373a2263617074636861223b7d, 6, '', 'https://www.uog.edu.gy/university-guyana-gets-medical-skills-lab', '', '40.77.167.57', 1722955060),
(24646982, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a373a22636f6d6d656e74223b733a31363a22406d6f64756c655f70726576696f7573223b733a373a2263617074636861223b733a353a224074696d65223b733a363a22302e31356d73223b7d, 6, '', 'https://www.uog.edu.gy/university-guyana-gets-medical-skills-lab', '', '40.77.167.57', 1722955060),
(24646983, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a353a2264626c6f67223b733a31363a22406d6f64756c655f70726576696f7573223b733a373a22636f6d6d656e74223b733a353a224074696d65223b733a363a22312e30386d73223b7d, 6, '', 'https://www.uog.edu.gy/university-guyana-gets-medical-skills-lab', '', '40.77.167.57', 1722955060),
(24646984, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a353a226669656c64223b733a31363a22406d6f64756c655f70726576696f7573223b733a353a2264626c6f67223b733a353a224074696d65223b733a363a22302e39396d73223b7d, 6, '', 'https://www.uog.edu.gy/university-guyana-gets-medical-skills-lab', '', '40.77.167.57', 1722955060),
(24646985, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a343a2266696c65223b733a31363a22406d6f64756c655f70726576696f7573223b733a353a226669656c64223b733a353a224074696d65223b733a363a22302e34346d73223b7d, 6, '', 'https://www.uog.edu.gy/university-guyana-gets-medical-skills-lab', '', '40.77.167.57', 1722955060),
(24646986, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a31363a22676f6f676c655f616e616c7974696373223b733a31363a22406d6f64756c655f70726576696f7573223b733a343a2266696c65223b733a353a224074696d65223b733a363a22302e33336d73223b7d, 6, '', 'https://www.uog.edu.gy/university-guyana-gets-medical-skills-lab', '', '40.77.167.57', 1722955060),
(24646987, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a373a22686973746f7279223b733a31363a22406d6f64756c655f70726576696f7573223b733a31363a22676f6f676c655f616e616c7974696373223b733a353a224074696d65223b733a353a22302e316d73223b7d, 6, '', 'https://www.uog.edu.gy/university-guyana-gets-medical-skills-lab', '', '40.77.167.57', 1722955060),
(24646988, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a343a226e6f6465223b733a31363a22406d6f64756c655f70726576696f7573223b733a373a22686973746f7279223b733a353a224074696d65223b733a363a22302e31356d73223b7d, 6, '', 'https://www.uog.edu.gy/university-guyana-gets-medical-skills-lab', '', '40.77.167.57', 1722955060),
(24646989, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a363a2270686f746f73223b733a31363a22406d6f64756c655f70726576696f7573223b733a343a226e6f6465223b733a353a224074696d65223b733a363a22342e32356d73223b7d, 6, '', 'https://www.uog.edu.gy/university-guyana-gets-medical-skills-lab', '', '40.77.167.57', 1722955060),
(24646990, 0, 'cron', 'Starting execution of @module_cron(), execution of @module_previous_cron() took @time.', 0x613a333a7b733a373a22406d6f64756c65223b733a363a22736561726368223b733a31363a22406d6f64756c655f70726576696f7573223b733a363a2270686f746f73223b733a353a224074696d65223b733a363a22382e36396d73223b7d, 6, '', 'https://www.uog.edu.gy/university-guyana-gets-medical-skills-lab', '', '40.77.167.57', 1722955060),
(24646991, 0, 'php', '%type: @message in %function (line %line of %file) @backtrace_string.', 0x[encoded data, 10992 characters], 3, '', 'https://www.uog.edu.gy/university-guyana-gets-medical-skills-lab', '', '40.77.167.57', 1722955060);

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

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

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

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

INSERT INTO `webform` (`webform_id`, `next_serial`) VALUES
('contact', 1),
('example_options_custom', 1),
('nomination_for_honorary_degree', 1),
('paying_students_registration_for', 1),
('students_registration_form_ug_ra', 1),
('teacher_s_registration_form_ug_r', 4),
('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_scheduled_email`
--

CREATE TABLE `webform_scheduled_email` (
  `eid` int NOT NULL COMMENT 'Primary Key: Scheduled email ID.',
  `webform_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'The webform id.',
  `entity_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'The entity type to which this submission was submitted from.',
  `entity_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'The ID of the entity of which this webform submission was submitted from.',
  `sid` int UNSIGNED NOT NULL COMMENT 'The webform submission id.',
  `handler_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'The webform handler id.',
  `state` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'The state of the scheduled email. (schedule, reschedule, unschedule, or send)',
  `send` int DEFAULT '0' COMMENT 'Unix timestamp of when email should be sent.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Table that contains Webform scheduled emails.';

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

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

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

--
-- Dumping data for table `webform_submission`
--

INSERT INTO `webform_submission` (`sid`, `webform_id`, `uuid`, `langcode`, `serial`, `token`, `uri`, `created`, `completed`, `changed`, `in_draft`, `current_page`, `remote_addr`, `uid`, `entity_type`, `entity_id`, `locked`, `sticky`, `notes`) VALUES
(1, 'teacher_s_registration_form_ug_r', '94fddad9-2f4c-435c-a4de-9e58b4b6b576', 'en', 1, 'dHjyUW_EIqac58iJ3tZFhclEq5ZqdT6Hj9xheQWcbwk', '/form/teacher-s-registration-form-ug-r', 1695757939, 1695757939, 1695757939, 0, NULL, '190.80.24.36', 1, NULL, NULL, 0, 0, NULL),
(2, 'teacher_s_registration_form_ug_r', '360b4175-1c67-4ce3-bb40-5335fcd3b752', 'en', 2, 'rheNyd1SQRMiPU_pJVW7sHkY2CzpjthZ5gMOPeG3LII', '/form/teacher-s-registration-form-ug-r', 1695758129, 1695758129, 1695758129, 0, NULL, '190.80.24.36', 1, NULL, NULL, 0, 0, NULL),
(3, 'teacher_s_registration_form_ug_r', '3accb548-a48b-4dc4-b414-1b247b043628', 'en', 3, 'GGRoVsfmSkE8YrI_NoQMoD9mji8sJW6YVat09Jf7a64', '/form/teacher-s-registration-form-ug-r', 1695758444, 1695758444, 1695758444, 0, NULL, '190.80.24.36', 1, NULL, NULL, 0, 0, NULL);

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

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

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

--
-- Dumping data for table `webform_submission_data`
--

INSERT INTO `webform_submission_data` (`webform_id`, `sid`, `name`, `property`, `delta`, `value`) VALUES
('teacher_s_registration_form_ug_r', 1, 'acceptance_of_stipend_totaling_50_000_for_the_entire_camp_', '', 0, 'No'),
('teacher_s_registration_form_ug_r', 1, 'address', '', 0, '10 Main Street'),
('teacher_s_registration_form_ug_r', 1, 'address2', '', 0, 'Loremipsum'),
('teacher_s_registration_form_ug_r', 1, 'age', '', 0, '100'),
('teacher_s_registration_form_ug_r', 1, 'any_other_relevant_document', '', 0, '3527'),
('teacher_s_registration_form_ug_r', 1, 'date_of_birth', '', 0, '2042-06-15'),
('teacher_s_registration_form_ug_r', 1, 'declaration_field2_name', '', 0, 'Dixisset'),
('teacher_s_registration_form_ug_r', 1, 'declaration_field4_address', '', 0, '11 Brook Alley Road. APT 1'),
('teacher_s_registration_form_ug_r', 1, 'do_you_have_any_dietary_restrictions_', '', 0, 'Yes'),
('teacher_s_registration_form_ug_r', 1, 'do_you_have_any_health_issues_even_minor_ones_', '', 0, 'Yes'),
('teacher_s_registration_form_ug_r', 1, 'email', '', 0, 'random@random.com'),
('teacher_s_registration_form_ug_r', 1, 'emergency_medical_treatment_', '', 0, 'No'),
('teacher_s_registration_form_ug_r', 1, 'essay_input', '', 0, 'Quae cum dixisset, finem ille. Quamquam non negatis nos intellegere quid sit voluptas, sed quid ille dicat. Progredientibus autem aetatibus sensim tardeve potius quasi nosmet ipsos cognoscimus. Gloriosa ostentatio in constituendo summo bono. Qui-vere falsone, quaerere mittimus-dicitur oculis se privasse; Duarum enim vitarum nobis erunt instituta capienda. Comprehensum, quod cognitum non habet? Qui enim existimabit posse se miserum esse beatus non erit. Causa autem fuit huc veniendi ut quosdam hinc libros promerem. Nunc omni virtuti vitium contrario nomine opponitur.'),
('teacher_s_registration_form_ug_r', 1, 'first_name', '', 0, 'John'),
('teacher_s_registration_form_ug_r', 1, 'if_yes_please_explain_', '', 0, 'Loremipsum'),
('teacher_s_registration_form_ug_r', 1, 'if_yes_please_state_any_health_issues_which_you_may_have_', '', 0, 'Oratione'),
('teacher_s_registration_form_ug_r', 1, 'levels', '', 0, 'Loremipsum'),
('teacher_s_registration_form_ug_r', 1, 'marital_status', '', 0, 'Married'),
('teacher_s_registration_form_ug_r', 1, 'name_in_full', '', 0, 'Loremipsum'),
('teacher_s_registration_form_ug_r', 1, 'nationality', '', 0, 'Oratione'),
('teacher_s_registration_form_ug_r', 1, 'national_id_number', '', 0, 'Loremipsum'),
('teacher_s_registration_form_ug_r', 1, 'number_of_years_as_a_teacher', '', 0, '5'),
('teacher_s_registration_form_ug_r', 1, 'other', '', 0, 'Dixisset'),
('teacher_s_registration_form_ug_r', 1, 'relationship', '', 0, 'Dixisset'),
('teacher_s_registration_form_ug_r', 1, 'school_currently_attached_to', '', 0, 'Dixisset'),
('teacher_s_registration_form_ug_r', 1, 'sex', '', 0, 'Female'),
('teacher_s_registration_form_ug_r', 1, 'subjects_taught', '', 0, 'Oratione'),
('teacher_s_registration_form_ug_r', 1, 'surname', '', 0, 'Dixisset'),
('teacher_s_registration_form_ug_r', 1, 'teacher_s_birth_certificate', '', 0, '3525'),
('teacher_s_registration_form_ug_r', 1, 'teacher_s_immunization_form', '', 0, '3526'),
('teacher_s_registration_form_ug_r', 1, 'tel_no_', '', 0, '5'),
('teacher_s_registration_form_ug_r', 1, 'tel_no_2', '', 0, '10'),
('teacher_s_registration_form_ug_r', 1, 'willing_to_participate_in_co_curricular_activities_including_off', '', 0, 'No'),
('teacher_s_registration_form_ug_r', 1, 'would_you_be_willing_to_share_sleeping_accommodation_with_anothe', '', 0, 'No'),
('teacher_s_registration_form_ug_r', 1, 'your_photograph_videos_of_you_and_or_voice_to_be_used_in_interna', '', 0, 'Yes'),
('teacher_s_registration_form_ug_r', 2, 'acceptance_of_stipend_totaling_50_000_for_the_entire_camp_', '', 0, 'Yes'),
('teacher_s_registration_form_ug_r', 2, 'address', '', 0, '11 Brook Alley Road. APT 1'),
('teacher_s_registration_form_ug_r', 2, 'address2', '', 0, 'Oratione'),
('teacher_s_registration_form_ug_r', 2, 'age', '', 0, '10'),
('teacher_s_registration_form_ug_r', 2, 'any_other_relevant_document', '', 0, '3530'),
('teacher_s_registration_form_ug_r', 2, 'date_of_birth', '', 0, '2025-07-23'),
('teacher_s_registration_form_ug_r', 2, 'declaration_field2_name', '', 0, 'Loremipsum'),
('teacher_s_registration_form_ug_r', 2, 'declaration_field4_address', '', 0, '10 Main Street'),
('teacher_s_registration_form_ug_r', 2, 'do_you_have_any_dietary_restrictions_', '', 0, 'No'),
('teacher_s_registration_form_ug_r', 2, 'do_you_have_any_health_issues_even_minor_ones_', '', 0, 'Yes'),
('teacher_s_registration_form_ug_r', 2, 'email', '', 0, 'example@example.com'),
('teacher_s_registration_form_ug_r', 2, 'emergency_medical_treatment_', '', 0, 'No'),
('teacher_s_registration_form_ug_r', 2, 'essay_input', '', 0, 'Huius, Lyco, oratione locuples, rebus ipsis ielunior. Duo Reges: constructio interrete. Sed haec in pueris; Sed utrum hortandus es nobis, Luci, inquit, an etiam tua sponte propensus es? Sapiens autem semper beatus est et est aliquando in dolore; Immo videri fortasse. Paulum, cum regem Persem captum adduceret, eodem flumine invectio? Et ille ridens: Video, inquit, quid agas;'),
('teacher_s_registration_form_ug_r', 2, 'first_name', '', 0, 'George'),
('teacher_s_registration_form_ug_r', 2, 'if_yes_please_explain_', '', 0, 'Dixisset'),
('teacher_s_registration_form_ug_r', 2, 'if_yes_please_state_any_health_issues_which_you_may_have_', '', 0, 'Loremipsum'),
('teacher_s_registration_form_ug_r', 2, 'levels', '', 0, 'Oratione'),
('teacher_s_registration_form_ug_r', 2, 'marital_status', '', 0, 'Separated'),
('teacher_s_registration_form_ug_r', 2, 'name_in_full', '', 0, 'Oratione'),
('teacher_s_registration_form_ug_r', 2, 'nationality', '', 0, 'Dixisset'),
('teacher_s_registration_form_ug_r', 2, 'national_id_number', '', 0, 'Oratione'),
('teacher_s_registration_form_ug_r', 2, 'number_of_years_as_a_teacher', '', 0, '1'),
('teacher_s_registration_form_ug_r', 2, 'other', '', 0, 'Dixisset'),
('teacher_s_registration_form_ug_r', 2, 'relationship', '', 0, 'Loremipsum'),
('teacher_s_registration_form_ug_r', 2, 'school_currently_attached_to', '', 0, 'Loremipsum'),
('teacher_s_registration_form_ug_r', 2, 'sex', '', 0, 'Female'),
('teacher_s_registration_form_ug_r', 2, 'subjects_taught', '', 0, 'Loremipsum'),
('teacher_s_registration_form_ug_r', 2, 'surname', '', 0, 'Loremipsum'),
('teacher_s_registration_form_ug_r', 2, 'teacher_s_birth_certificate', '', 0, '3528'),
('teacher_s_registration_form_ug_r', 2, 'teacher_s_immunization_form', '', 0, '3529'),
('teacher_s_registration_form_ug_r', 2, 'tel_no_', '', 0, '10'),
('teacher_s_registration_form_ug_r', 2, 'tel_no_2', '', 0, '5'),
('teacher_s_registration_form_ug_r', 2, 'willing_to_participate_in_co_curricular_activities_including_off', '', 0, 'Yes'),
('teacher_s_registration_form_ug_r', 2, 'would_you_be_willing_to_share_sleeping_accommodation_with_anothe', '', 0, 'No'),
('teacher_s_registration_form_ug_r', 2, 'your_photograph_videos_of_you_and_or_voice_to_be_used_in_interna', '', 0, 'No'),
('teacher_s_registration_form_ug_r', 3, 'acceptance_of_stipend_totaling_50_000_for_the_entire_camp_', '', 0, 'No'),
('teacher_s_registration_form_ug_r', 3, 'address', '', 0, '11 Brook Alley Road. APT 1'),
('teacher_s_registration_form_ug_r', 3, 'address2', '', 0, 'Dixisset'),
('teacher_s_registration_form_ug_r', 3, 'age', '', 0, '10'),
('teacher_s_registration_form_ug_r', 3, 'any_other_relevant_document', '', 0, '3533'),
('teacher_s_registration_form_ug_r', 3, 'date_of_birth', '', 0, '2034-06-17'),
('teacher_s_registration_form_ug_r', 3, 'declaration_field2_name', '', 0, 'Dixisset'),
('teacher_s_registration_form_ug_r', 3, 'declaration_field4_address', '', 0, '11 Brook Alley Road. APT 1'),
('teacher_s_registration_form_ug_r', 3, 'do_you_have_any_dietary_restrictions_', '', 0, 'Yes'),
('teacher_s_registration_form_ug_r', 3, 'do_you_have_any_health_issues_even_minor_ones_', '', 0, 'Yes'),
('teacher_s_registration_form_ug_r', 3, 'email', '', 0, 'example@example.com'),
('teacher_s_registration_form_ug_r', 3, 'emergency_medical_treatment_', '', 0, 'Yes'),
('teacher_s_registration_form_ug_r', 3, 'essay_input', '', 0, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Negat esse eam, inquit, propter se expetendam. Primum Theophrasti, Strato, physicum se voluit; Id mihi magnum videtur. Itaque mihi non satis videmini considerare quod iter sit naturae quaeque progressio. Quare hoc videndum est, possitne nobis hoc ratio philosophorum dare. Est enim tanti philosophi tamque nobilis audacter sua decreta defendere.'),
('teacher_s_registration_form_ug_r', 3, 'first_name', '', 0, 'George'),
('teacher_s_registration_form_ug_r', 3, 'if_yes_please_explain_', '', 0, 'Loremipsum'),
('teacher_s_registration_form_ug_r', 3, 'if_yes_please_state_any_health_issues_which_you_may_have_', '', 0, 'Oratione'),
('teacher_s_registration_form_ug_r', 3, 'levels', '', 0, 'Loremipsum'),
('teacher_s_registration_form_ug_r', 3, 'marital_status', '', 0, 'Single'),
('teacher_s_registration_form_ug_r', 3, 'name_in_full', '', 0, 'Dixisset'),
('teacher_s_registration_form_ug_r', 3, 'nationality', '', 0, 'Dixisset'),
('teacher_s_registration_form_ug_r', 3, 'national_id_number', '', 0, 'Dixisset'),
('teacher_s_registration_form_ug_r', 3, 'number_of_years_as_a_teacher', '', 0, '10'),
('teacher_s_registration_form_ug_r', 3, 'other', '', 0, 'Oratione'),
('teacher_s_registration_form_ug_r', 3, 'relationship', '', 0, 'Loremipsum'),
('teacher_s_registration_form_ug_r', 3, 'school_currently_attached_to', '', 0, 'Loremipsum'),
('teacher_s_registration_form_ug_r', 3, 'sex', '', 0, 'Female'),
('teacher_s_registration_form_ug_r', 3, 'subjects_taught', '', 0, 'Dixisset'),
('teacher_s_registration_form_ug_r', 3, 'surname', '', 0, 'Dixisset'),
('teacher_s_registration_form_ug_r', 3, 'teacher_s_birth_certificate', '', 0, '3531'),
('teacher_s_registration_form_ug_r', 3, 'teacher_s_immunization_form', '', 0, '3532'),
('teacher_s_registration_form_ug_r', 3, 'tel_no_', '', 0, '1'),
('teacher_s_registration_form_ug_r', 3, 'tel_no_2', '', 0, '5'),
('teacher_s_registration_form_ug_r', 3, 'willing_to_participate_in_co_curricular_activities_including_off', '', 0, 'Yes'),
('teacher_s_registration_form_ug_r', 3, 'would_you_be_willing_to_share_sleeping_accommodation_with_anothe', '', 0, 'No'),
('teacher_s_registration_form_ug_r', 3, 'your_photograph_videos_of_you_and_or_voice_to_be_used_in_interna', '', 0, 'No');

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

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

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

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `captcha_sessions`
--
ALTER TABLE `captcha_sessions`
  ADD PRIMARY KEY (`csid`),
  ADD KEY `csid_ip` (`csid`,`ip_address`);

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `fontyourface_font`
--
ALTER TABLE `fontyourface_font`
  ADD PRIMARY KEY (`fid`),
  ADD UNIQUE KEY `font_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `url` (`url`),
  ADD KEY `name` (`name`(191)),
  ADD KEY `pid` (`pid`);

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

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

--
-- Indexes for table `font__field_tags`
--
ALTER TABLE `font__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 `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_photos`
--
ALTER TABLE `media_revision__field_media_photos`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_media_photos_target_id` (`field_media_photos_target_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_photos`
--
ALTER TABLE `media__field_media_photos`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_media_photos_target_id` (`field_media_photos_target_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 `migrate_map_block_content_body_field`
--
ALTER TABLE `migrate_map_block_content_body_field`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191),`sourceid2`(191),`sourceid3`(191));

--
-- Indexes for table `migrate_map_block_content_entity_display`
--
ALTER TABLE `migrate_map_block_content_entity_display`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191),`sourceid2`(191),`sourceid3`(191),`sourceid4`(191));

--
-- Indexes for table `migrate_map_block_content_entity_form_display`
--
ALTER TABLE `migrate_map_block_content_entity_form_display`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191),`sourceid2`(191),`sourceid3`(191),`sourceid4`(191));

--
-- Indexes for table `migrate_map_block_content_type`
--
ALTER TABLE `migrate_map_block_content_type`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_book_settings`
--
ALTER TABLE `migrate_map_book_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d6_book_settings`
--
ALTER TABLE `migrate_map_d6_book_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d6_custom_block`
--
ALTER TABLE `migrate_map_d6_custom_block`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`);

--
-- Indexes for table `migrate_map_d7_block`
--
ALTER TABLE `migrate_map_d7_block`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191),`sourceid2`(191),`sourceid3`(191));

--
-- Indexes for table `migrate_map_d7_book`
--
ALTER TABLE `migrate_map_d7_book`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`);

--
-- Indexes for table `migrate_map_d7_captcha_points`
--
ALTER TABLE `migrate_map_d7_captcha_points`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_captcha_settings`
--
ALTER TABLE `migrate_map_d7_captcha_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_color`
--
ALTER TABLE `migrate_map_d7_color`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_comment`
--
ALTER TABLE `migrate_map_d7_comment`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`);

--
-- Indexes for table `migrate_map_d7_comment_entity_display`
--
ALTER TABLE `migrate_map_d7_comment_entity_display`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_comment_entity_form_display`
--
ALTER TABLE `migrate_map_d7_comment_entity_form_display`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_comment_entity_form_display_subject`
--
ALTER TABLE `migrate_map_d7_comment_entity_form_display_subject`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_comment_field`
--
ALTER TABLE `migrate_map_d7_comment_field`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_comment_field_instance`
--
ALTER TABLE `migrate_map_d7_comment_field_instance`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_comment_type`
--
ALTER TABLE `migrate_map_d7_comment_type`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_custom_block`
--
ALTER TABLE `migrate_map_d7_custom_block`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`);

--
-- Indexes for table `migrate_map_d7_dblog_settings`
--
ALTER TABLE `migrate_map_d7_dblog_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_field`
--
ALTER TABLE `migrate_map_d7_field`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191),`sourceid2`(191));

--
-- Indexes for table `migrate_map_d7_field_formatter_settings`
--
ALTER TABLE `migrate_map_d7_field_formatter_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191),`sourceid2`(191),`sourceid3`(191),`sourceid4`(191));

--
-- Indexes for table `migrate_map_d7_field_instance`
--
ALTER TABLE `migrate_map_d7_field_instance`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191),`sourceid2`(191),`sourceid3`(191));

--
-- Indexes for table `migrate_map_d7_field_instance_widget_settings`
--
ALTER TABLE `migrate_map_d7_field_instance_widget_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191),`sourceid2`(191));

--
-- Indexes for table `migrate_map_d7_file`
--
ALTER TABLE `migrate_map_d7_file`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`);

--
-- Indexes for table `migrate_map_d7_file_private`
--
ALTER TABLE `migrate_map_d7_file_private`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`);

--
-- Indexes for table `migrate_map_d7_filter_format`
--
ALTER TABLE `migrate_map_d7_filter_format`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_filter_settings`
--
ALTER TABLE `migrate_map_d7_filter_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_global_theme_settings`
--
ALTER TABLE `migrate_map_d7_global_theme_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_google_analytics_settings`
--
ALTER TABLE `migrate_map_d7_google_analytics_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_google_analytics_user_settings`
--
ALTER TABLE `migrate_map_d7_google_analytics_user_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`);

--
-- Indexes for table `migrate_map_d7_image_settings`
--
ALTER TABLE `migrate_map_d7_image_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_image_styles`
--
ALTER TABLE `migrate_map_d7_image_styles`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`);

--
-- Indexes for table `migrate_map_d7_menu`
--
ALTER TABLE `migrate_map_d7_menu`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_menu_links`
--
ALTER TABLE `migrate_map_d7_menu_links`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`);

--
-- Indexes for table `migrate_map_d7_node_complete__admin_profile`
--
ALTER TABLE `migrate_map_d7_node_complete__admin_profile`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`,`sourceid2`,`sourceid3`(191));

--
-- Indexes for table `migrate_map_d7_node_complete__article`
--
ALTER TABLE `migrate_map_d7_node_complete__article`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`,`sourceid2`,`sourceid3`(191));

--
-- Indexes for table `migrate_map_d7_node_complete__book`
--
ALTER TABLE `migrate_map_d7_node_complete__book`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`,`sourceid2`,`sourceid3`(191));

--
-- Indexes for table `migrate_map_d7_node_complete__carousel_entry`
--
ALTER TABLE `migrate_map_d7_node_complete__carousel_entry`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`,`sourceid2`,`sourceid3`(191));

--
-- Indexes for table `migrate_map_d7_node_complete__document`
--
ALTER TABLE `migrate_map_d7_node_complete__document`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`,`sourceid2`,`sourceid3`(191));

--
-- Indexes for table `migrate_map_d7_node_complete__event`
--
ALTER TABLE `migrate_map_d7_node_complete__event`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`,`sourceid2`,`sourceid3`(191));

--
-- Indexes for table `migrate_map_d7_node_complete__featured_person_of_the_month`
--
ALTER TABLE `migrate_map_d7_node_complete__featured_person_of_the_month`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`,`sourceid2`,`sourceid3`(191));

--
-- Indexes for table `migrate_map_d7_node_complete__map_location`
--
ALTER TABLE `migrate_map_d7_node_complete__map_location`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`,`sourceid2`,`sourceid3`(191));

--
-- Indexes for table `migrate_map_d7_node_complete__news`
--
ALTER TABLE `migrate_map_d7_node_complete__news`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`,`sourceid2`,`sourceid3`(191));

--
-- Indexes for table `migrate_map_d7_node_complete__notice`
--
ALTER TABLE `migrate_map_d7_node_complete__notice`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`,`sourceid2`,`sourceid3`(191));

--
-- Indexes for table `migrate_map_d7_node_complete__page`
--
ALTER TABLE `migrate_map_d7_node_complete__page`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`,`sourceid2`,`sourceid3`(191));

--
-- Indexes for table `migrate_map_d7_node_complete__photo_album`
--
ALTER TABLE `migrate_map_d7_node_complete__photo_album`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`,`sourceid2`,`sourceid3`(191));

--
-- Indexes for table `migrate_map_d7_node_complete__procurement_advertisement`
--
ALTER TABLE `migrate_map_d7_node_complete__procurement_advertisement`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`,`sourceid2`,`sourceid3`(191));

--
-- Indexes for table `migrate_map_d7_node_complete__staff_profile`
--
ALTER TABLE `migrate_map_d7_node_complete__staff_profile`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`,`sourceid2`,`sourceid3`(191));

--
-- Indexes for table `migrate_map_d7_node_complete__ug_research`
--
ALTER TABLE `migrate_map_d7_node_complete__ug_research`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`,`sourceid2`,`sourceid3`(191));

--
-- Indexes for table `migrate_map_d7_node_complete__vacancy`
--
ALTER TABLE `migrate_map_d7_node_complete__vacancy`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`,`sourceid2`,`sourceid3`(191));

--
-- Indexes for table `migrate_map_d7_node_complete__video_album`
--
ALTER TABLE `migrate_map_d7_node_complete__video_album`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`,`sourceid2`,`sourceid3`(191));

--
-- Indexes for table `migrate_map_d7_node_complete__webform`
--
ALTER TABLE `migrate_map_d7_node_complete__webform`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`,`sourceid2`,`sourceid3`(191));

--
-- Indexes for table `migrate_map_d7_node_settings`
--
ALTER TABLE `migrate_map_d7_node_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_node_title_label`
--
ALTER TABLE `migrate_map_d7_node_title_label`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_node_type`
--
ALTER TABLE `migrate_map_d7_node_type`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_pathauto_patterns`
--
ALTER TABLE `migrate_map_d7_pathauto_patterns`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_pathauto_settings`
--
ALTER TABLE `migrate_map_d7_pathauto_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_photos_count`
--
ALTER TABLE `migrate_map_d7_photos_count`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`);

--
-- Indexes for table `migrate_map_d7_photos_settings`
--
ALTER TABLE `migrate_map_d7_photos_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_rdf_mapping`
--
ALTER TABLE `migrate_map_d7_rdf_mapping`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191),`sourceid2`(191));

--
-- Indexes for table `migrate_map_d7_shortcut`
--
ALTER TABLE `migrate_map_d7_shortcut`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`);

--
-- Indexes for table `migrate_map_d7_shortcut_set`
--
ALTER TABLE `migrate_map_d7_shortcut_set`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_shortcut_set_users`
--
ALTER TABLE `migrate_map_d7_shortcut_set_users`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191),`sourceid2`);

--
-- Indexes for table `migrate_map_d7_system_authorize`
--
ALTER TABLE `migrate_map_d7_system_authorize`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_system_cron`
--
ALTER TABLE `migrate_map_d7_system_cron`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_system_date`
--
ALTER TABLE `migrate_map_d7_system_date`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_system_file`
--
ALTER TABLE `migrate_map_d7_system_file`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_system_mail`
--
ALTER TABLE `migrate_map_d7_system_mail`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_system_performance`
--
ALTER TABLE `migrate_map_d7_system_performance`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_taxonomy_term__event_calendar_status`
--
ALTER TABLE `migrate_map_d7_taxonomy_term__event_calendar_status`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`);

--
-- Indexes for table `migrate_map_d7_taxonomy_term__newsletter`
--
ALTER TABLE `migrate_map_d7_taxonomy_term__newsletter`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`);

--
-- Indexes for table `migrate_map_d7_taxonomy_term__subscribe`
--
ALTER TABLE `migrate_map_d7_taxonomy_term__subscribe`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`);

--
-- Indexes for table `migrate_map_d7_taxonomy_term__tags`
--
ALTER TABLE `migrate_map_d7_taxonomy_term__tags`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`);

--
-- Indexes for table `migrate_map_d7_taxonomy_term__ug_research`
--
ALTER TABLE `migrate_map_d7_taxonomy_term__ug_research`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`);

--
-- Indexes for table `migrate_map_d7_taxonomy_vocabulary`
--
ALTER TABLE `migrate_map_d7_taxonomy_vocabulary`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`);

--
-- Indexes for table `migrate_map_d7_theme_settings`
--
ALTER TABLE `migrate_map_d7_theme_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_url_alias`
--
ALTER TABLE `migrate_map_d7_url_alias`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`);

--
-- Indexes for table `migrate_map_d7_user`
--
ALTER TABLE `migrate_map_d7_user`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`);

--
-- Indexes for table `migrate_map_d7_user_flood`
--
ALTER TABLE `migrate_map_d7_user_flood`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_user_mail`
--
ALTER TABLE `migrate_map_d7_user_mail`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_user_role`
--
ALTER TABLE `migrate_map_d7_user_role`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`);

--
-- Indexes for table `migrate_map_d7_user_settings`
--
ALTER TABLE `migrate_map_d7_user_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_d7_view_modes`
--
ALTER TABLE `migrate_map_d7_view_modes`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191),`sourceid2`(191));

--
-- Indexes for table `migrate_map_file_settings`
--
ALTER TABLE `migrate_map_file_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_menu_settings`
--
ALTER TABLE `migrate_map_menu_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_system_image`
--
ALTER TABLE `migrate_map_system_image`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_system_image_gd`
--
ALTER TABLE `migrate_map_system_image_gd`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_system_logging`
--
ALTER TABLE `migrate_map_system_logging`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_system_maintenance`
--
ALTER TABLE `migrate_map_system_maintenance`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_system_rss`
--
ALTER TABLE `migrate_map_system_rss`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_system_site`
--
ALTER TABLE `migrate_map_system_site`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_taxonomy_settings`
--
ALTER TABLE `migrate_map_taxonomy_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_text_settings`
--
ALTER TABLE `migrate_map_text_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_update_settings`
--
ALTER TABLE `migrate_map_update_settings`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_user_picture_entity_display`
--
ALTER TABLE `migrate_map_user_picture_entity_display`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_user_picture_entity_form_display`
--
ALTER TABLE `migrate_map_user_picture_entity_form_display`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_user_picture_field`
--
ALTER TABLE `migrate_map_user_picture_field`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_map_user_picture_field_instance`
--
ALTER TABLE `migrate_map_user_picture_field_instance`
  ADD PRIMARY KEY (`source_ids_hash`),
  ADD KEY `source` (`sourceid1`(191));

--
-- Indexes for table `migrate_message_block_content_body_field`
--
ALTER TABLE `migrate_message_block_content_body_field`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_block_content_entity_display`
--
ALTER TABLE `migrate_message_block_content_entity_display`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_block_content_entity_form_display`
--
ALTER TABLE `migrate_message_block_content_entity_form_display`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_block_content_type`
--
ALTER TABLE `migrate_message_block_content_type`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_book_settings`
--
ALTER TABLE `migrate_message_book_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d6_book_settings`
--
ALTER TABLE `migrate_message_d6_book_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d6_custom_block`
--
ALTER TABLE `migrate_message_d6_custom_block`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_block`
--
ALTER TABLE `migrate_message_d7_block`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_book`
--
ALTER TABLE `migrate_message_d7_book`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_captcha_points`
--
ALTER TABLE `migrate_message_d7_captcha_points`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_captcha_settings`
--
ALTER TABLE `migrate_message_d7_captcha_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_color`
--
ALTER TABLE `migrate_message_d7_color`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_comment`
--
ALTER TABLE `migrate_message_d7_comment`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_comment_entity_display`
--
ALTER TABLE `migrate_message_d7_comment_entity_display`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_comment_entity_form_display`
--
ALTER TABLE `migrate_message_d7_comment_entity_form_display`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_comment_entity_form_display_subject`
--
ALTER TABLE `migrate_message_d7_comment_entity_form_display_subject`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_comment_field`
--
ALTER TABLE `migrate_message_d7_comment_field`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_comment_field_instance`
--
ALTER TABLE `migrate_message_d7_comment_field_instance`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_comment_type`
--
ALTER TABLE `migrate_message_d7_comment_type`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_custom_block`
--
ALTER TABLE `migrate_message_d7_custom_block`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_dblog_settings`
--
ALTER TABLE `migrate_message_d7_dblog_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_field`
--
ALTER TABLE `migrate_message_d7_field`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_field_formatter_settings`
--
ALTER TABLE `migrate_message_d7_field_formatter_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_field_instance`
--
ALTER TABLE `migrate_message_d7_field_instance`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_field_instance_widget_settings`
--
ALTER TABLE `migrate_message_d7_field_instance_widget_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_file`
--
ALTER TABLE `migrate_message_d7_file`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_file_private`
--
ALTER TABLE `migrate_message_d7_file_private`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_filter_format`
--
ALTER TABLE `migrate_message_d7_filter_format`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_filter_settings`
--
ALTER TABLE `migrate_message_d7_filter_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_global_theme_settings`
--
ALTER TABLE `migrate_message_d7_global_theme_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_google_analytics_settings`
--
ALTER TABLE `migrate_message_d7_google_analytics_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_google_analytics_user_settings`
--
ALTER TABLE `migrate_message_d7_google_analytics_user_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_image_settings`
--
ALTER TABLE `migrate_message_d7_image_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_image_styles`
--
ALTER TABLE `migrate_message_d7_image_styles`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_menu`
--
ALTER TABLE `migrate_message_d7_menu`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_menu_links`
--
ALTER TABLE `migrate_message_d7_menu_links`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_complete__admin_profile`
--
ALTER TABLE `migrate_message_d7_node_complete__admin_profile`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_complete__article`
--
ALTER TABLE `migrate_message_d7_node_complete__article`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_complete__book`
--
ALTER TABLE `migrate_message_d7_node_complete__book`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_complete__carousel_entry`
--
ALTER TABLE `migrate_message_d7_node_complete__carousel_entry`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_complete__document`
--
ALTER TABLE `migrate_message_d7_node_complete__document`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_complete__event`
--
ALTER TABLE `migrate_message_d7_node_complete__event`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_complete__featured_person_of_the_month`
--
ALTER TABLE `migrate_message_d7_node_complete__featured_person_of_the_month`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_complete__map_location`
--
ALTER TABLE `migrate_message_d7_node_complete__map_location`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_complete__news`
--
ALTER TABLE `migrate_message_d7_node_complete__news`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_complete__notice`
--
ALTER TABLE `migrate_message_d7_node_complete__notice`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_complete__page`
--
ALTER TABLE `migrate_message_d7_node_complete__page`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_complete__photo_album`
--
ALTER TABLE `migrate_message_d7_node_complete__photo_album`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_complete__procurement_advertisement`
--
ALTER TABLE `migrate_message_d7_node_complete__procurement_advertisement`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_complete__staff_profile`
--
ALTER TABLE `migrate_message_d7_node_complete__staff_profile`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_complete__ug_research`
--
ALTER TABLE `migrate_message_d7_node_complete__ug_research`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_complete__vacancy`
--
ALTER TABLE `migrate_message_d7_node_complete__vacancy`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_complete__video_album`
--
ALTER TABLE `migrate_message_d7_node_complete__video_album`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_complete__webform`
--
ALTER TABLE `migrate_message_d7_node_complete__webform`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_settings`
--
ALTER TABLE `migrate_message_d7_node_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_title_label`
--
ALTER TABLE `migrate_message_d7_node_title_label`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_node_type`
--
ALTER TABLE `migrate_message_d7_node_type`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_pathauto_patterns`
--
ALTER TABLE `migrate_message_d7_pathauto_patterns`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_pathauto_settings`
--
ALTER TABLE `migrate_message_d7_pathauto_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_photos_count`
--
ALTER TABLE `migrate_message_d7_photos_count`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_photos_settings`
--
ALTER TABLE `migrate_message_d7_photos_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_rdf_mapping`
--
ALTER TABLE `migrate_message_d7_rdf_mapping`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_shortcut`
--
ALTER TABLE `migrate_message_d7_shortcut`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_shortcut_set`
--
ALTER TABLE `migrate_message_d7_shortcut_set`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_shortcut_set_users`
--
ALTER TABLE `migrate_message_d7_shortcut_set_users`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_system_authorize`
--
ALTER TABLE `migrate_message_d7_system_authorize`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_system_cron`
--
ALTER TABLE `migrate_message_d7_system_cron`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_system_date`
--
ALTER TABLE `migrate_message_d7_system_date`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_system_file`
--
ALTER TABLE `migrate_message_d7_system_file`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_system_mail`
--
ALTER TABLE `migrate_message_d7_system_mail`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_system_performance`
--
ALTER TABLE `migrate_message_d7_system_performance`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_taxonomy_term__event_calendar_status`
--
ALTER TABLE `migrate_message_d7_taxonomy_term__event_calendar_status`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_taxonomy_term__newsletter`
--
ALTER TABLE `migrate_message_d7_taxonomy_term__newsletter`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_taxonomy_term__subscribe`
--
ALTER TABLE `migrate_message_d7_taxonomy_term__subscribe`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_taxonomy_term__tags`
--
ALTER TABLE `migrate_message_d7_taxonomy_term__tags`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_taxonomy_term__ug_research`
--
ALTER TABLE `migrate_message_d7_taxonomy_term__ug_research`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_taxonomy_vocabulary`
--
ALTER TABLE `migrate_message_d7_taxonomy_vocabulary`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_theme_settings`
--
ALTER TABLE `migrate_message_d7_theme_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_url_alias`
--
ALTER TABLE `migrate_message_d7_url_alias`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_user`
--
ALTER TABLE `migrate_message_d7_user`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_user_flood`
--
ALTER TABLE `migrate_message_d7_user_flood`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_user_mail`
--
ALTER TABLE `migrate_message_d7_user_mail`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_user_role`
--
ALTER TABLE `migrate_message_d7_user_role`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_user_settings`
--
ALTER TABLE `migrate_message_d7_user_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_d7_view_modes`
--
ALTER TABLE `migrate_message_d7_view_modes`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_file_settings`
--
ALTER TABLE `migrate_message_file_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_menu_settings`
--
ALTER TABLE `migrate_message_menu_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_system_image`
--
ALTER TABLE `migrate_message_system_image`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_system_image_gd`
--
ALTER TABLE `migrate_message_system_image_gd`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_system_logging`
--
ALTER TABLE `migrate_message_system_logging`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_system_maintenance`
--
ALTER TABLE `migrate_message_system_maintenance`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_system_rss`
--
ALTER TABLE `migrate_message_system_rss`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_system_site`
--
ALTER TABLE `migrate_message_system_site`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_taxonomy_settings`
--
ALTER TABLE `migrate_message_taxonomy_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_text_settings`
--
ALTER TABLE `migrate_message_text_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_update_settings`
--
ALTER TABLE `migrate_message_update_settings`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_user_picture_entity_display`
--
ALTER TABLE `migrate_message_user_picture_entity_display`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_user_picture_entity_form_display`
--
ALTER TABLE `migrate_message_user_picture_entity_form_display`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_user_picture_field`
--
ALTER TABLE `migrate_message_user_picture_field`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

--
-- Indexes for table `migrate_message_user_picture_field_instance`
--
ALTER TABLE `migrate_message_user_picture_field_instance`
  ADD PRIMARY KEY (`msgid`),
  ADD KEY `source_ids_hash` (`source_ids_hash`);

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

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

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

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

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

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

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

--
-- Indexes for table `node_revision__comment_node_admin_profile`
--
ALTER TABLE `node_revision__comment_node_admin_profile`
  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__comment_node_article`
--
ALTER TABLE `node_revision__comment_node_article`
  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__comment_node_book`
--
ALTER TABLE `node_revision__comment_node_book`
  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__comment_node_carousel_entry`
--
ALTER TABLE `node_revision__comment_node_carousel_entry`
  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__comment_node_document`
--
ALTER TABLE `node_revision__comment_node_document`
  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__comment_node_event`
--
ALTER TABLE `node_revision__comment_node_event`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

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

--
-- Indexes for table `node_revision__comment_node_news`
--
ALTER TABLE `node_revision__comment_node_news`
  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__comment_node_notice`
--
ALTER TABLE `node_revision__comment_node_notice`
  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__comment_node_page`
--
ALTER TABLE `node_revision__comment_node_page`
  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__comment_node_photo_album`
--
ALTER TABLE `node_revision__comment_node_photo_album`
  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__comment_node_procurement_adver`
--
ALTER TABLE `node_revision__comment_node_procurement_adver`
  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__comment_node_staff_profile`
--
ALTER TABLE `node_revision__comment_node_staff_profile`
  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__comment_node_ug_research`
--
ALTER TABLE `node_revision__comment_node_ug_research`
  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__comment_node_vacancy`
--
ALTER TABLE `node_revision__comment_node_vacancy`
  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__comment_node_video_album`
--
ALTER TABLE `node_revision__comment_node_video_album`
  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__comment_node_webform`
--
ALTER TABLE `node_revision__comment_node_webform`
  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_abbreviations`
--
ALTER TABLE `node_revision__field_abbreviations`
  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_album_cover`
--
ALTER TABLE `node_revision__field_album_cover`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_album_cover_target_id` (`field_album_cover_target_id`);

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

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

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

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

--
-- Indexes for table `node_revision__field_call_to_action_link`
--
ALTER TABLE `node_revision__field_call_to_action_link`
  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_call_to_action_text`
--
ALTER TABLE `node_revision__field_call_to_action_text`
  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_caption`
--
ALTER TABLE `node_revision__field_caption`
  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_carousel_type`
--
ALTER TABLE `node_revision__field_carousel_type`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_carousel_type_value` (`field_carousel_type_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_target_id` (`field_category_target_id`);

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `node_revision__field_event_topics`
--
ALTER TABLE `node_revision__field_event_topics`
  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_video`
--
ALTER TABLE `node_revision__field_event_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_faqs`
--
ALTER TABLE `node_revision__field_faqs`
  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_quote`
--
ALTER TABLE `node_revision__field_featured_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_featured_type`
--
ALTER TABLE `node_revision__field_featured_type`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_featured_type_value` (`field_featured_type_value`(191));

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `node_revision__field_slider_heading`
--
ALTER TABLE `node_revision__field_slider_heading`
  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_speakers`
--
ALTER TABLE `node_revision__field_speakers`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_speakers_target_id` (`field_speakers_target_id`),
  ADD KEY `field_speakers_target_revision_id` (`field_speakers_target_revision_id`);

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

--
-- Indexes for table `node_revision__field_staff_abbreviations`
--
ALTER TABLE `node_revision__field_staff_abbreviations`
  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_staff_quick_links`
--
ALTER TABLE `node_revision__field_staff_quick_links`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_staff_quick_links_target_id` (`field_staff_quick_links_target_id`),
  ADD KEY `field_staff_quick_links_target_revision_id` (`field_staff_quick_links_target_revision_id`);

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

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

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

--
-- Indexes for table `node_revision__field_topics`
--
ALTER TABLE `node_revision__field_topics`
  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_tribute`
--
ALTER TABLE `node_revision__field_tribute`
  ADD PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_tribute_target_id` (`field_tribute_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__comment_node_admin_profile`
--
ALTER TABLE `node__comment_node_admin_profile`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `node__field_carousel_type`
--
ALTER TABLE `node__field_carousel_type`
  ADD PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  ADD KEY `bundle` (`bundle`),
  ADD KEY `revision_id` (`revision_id`),
  ADD KEY `field_carousel_type_value` (`field_carousel_type_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_target_id` (`field_category_target_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `par`
--
ALTER TABLE `par`
  ADD PRIMARY KEY (`parid`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- 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 `photos_album`
--
ALTER TABLE `photos_album`
  ADD PRIMARY KEY (`album_id`),
  ADD KEY `cover_id` (`cover_id`),
  ADD KEY `weight` (`weight`);

--
-- Indexes for table `photos_count`
--
ALTER TABLE `photos_count`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cid` (`cid`),
  ADD KEY `type` (`type`),
  ADD KEY `value` (`value`);

--
-- Indexes for table `photos_image`
--
ALTER TABLE `photos_image`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `photos_image_field__uuid__value` (`uuid`),
  ADD UNIQUE KEY `photos_image__revision_id` (`revision_id`);

--
-- Indexes for table `photos_image_field_data`
--
ALTER TABLE `photos_image_field_data`
  ADD PRIMARY KEY (`id`,`langcode`),
  ADD KEY `photos_image__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
  ADD KEY `photos_image__revision_id` (`revision_id`),
  ADD KEY `photos_image_field__uid__target_id` (`uid`),
  ADD KEY `photos_image_field__description__format` (`description__format`),
  ADD KEY `photos_image_field__created` (`created`),
  ADD KEY `photos_image_field__album_id__target_id` (`album_id`),
  ADD KEY `photos_image_field__changed` (`changed`),
  ADD KEY `photos_image__status` (`status`,`id`);

--
-- Indexes for table `photos_image_field_revision`
--
ALTER TABLE `photos_image_field_revision`
  ADD PRIMARY KEY (`revision_id`,`langcode`),
  ADD KEY `photos_image__id__default_langcode__langcode` (`id`,`default_langcode`,`langcode`),
  ADD KEY `photos_image_field__uid__target_id` (`uid`),
  ADD KEY `photos_image_field__description__format` (`description__format`),
  ADD KEY `photos_image_field__album_id__target_id` (`album_id`);

--
-- Indexes for table `photos_image_revision`
--
ALTER TABLE `photos_image_revision`
  ADD PRIMARY KEY (`revision_id`),
  ADD KEY `photos_image__id` (`id`),
  ADD KEY `photos_image_field__langcode` (`langcode`),
  ADD KEY `photos_image_field__revision_user__target_id` (`revision_user`);

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

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

--
-- Indexes for table `photos_image__field_image`
--
ALTER TABLE `photos_image__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 `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_db_default_index`
--
ALTER TABLE `search_api_db_default_index`
  ADD PRIMARY KEY (`item_id`),
  ADD KEY `_author` (`author`(10)),
  ADD KEY `_changed` (`changed`),
  ADD KEY `_created` (`created`),
  ADD KEY `_field_tags` (`field_tags`),
  ADD KEY `_node_grants` (`node_grants`(10)),
  ADD KEY `_rendered_item` (`rendered_item`(10)),
  ADD KEY `_status` (`status`),
  ADD KEY `_sticky` (`sticky`),
  ADD KEY `_title` (`title`(10)),
  ADD KEY `_type` (`type`(10)),
  ADD KEY `_uid` (`uid`),
  ADD KEY `_search_api_datasource` (`search_api_datasource`(10)),
  ADD KEY `_search_api_language` (`search_api_language`(10));

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

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

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

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

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

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

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

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

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

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

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

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

--
-- 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 `simple_popup_blocks`
--
ALTER TABLE `simple_popup_blocks`
  ADD PRIMARY KEY (`pid`),
  ADD UNIQUE KEY `identifier` (`identifier`);

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `users_field_data`
--
ALTER TABLE `users_field_data`
  ADD PRIMARY KEY (`uid`,`langcode`),
  ADD UNIQUE KEY `user__name` (`name`,`langcode`),
  ADD KEY `user__id__default_langcode__langcode` (`uid`,`default_langcode`,`langcode`),
  ADD KEY `user_field__mail` (`mail`(191)),
  ADD KEY `user_field__created` (`created`),
  ADD KEY `user_field__access` (`access`);

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

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

--
-- Indexes for table `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_scheduled_email`
--
ALTER TABLE `webform_scheduled_email`
  ADD PRIMARY KEY (`eid`),
  ADD KEY `webform_id` (`webform_id`),
  ADD KEY `sid` (`sid`),
  ADD KEY `scheduled` (`webform_id`,`handler_id`,`send`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

--
-- AUTO_INCREMENT for table `captcha_sessions`
--
ALTER TABLE `captcha_sessions`
  MODIFY `csid` int NOT NULL AUTO_INCREMENT COMMENT 'CAPTCHA session ID.';

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

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

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

--
-- AUTO_INCREMENT for table `fontyourface_font`
--
ALTER TABLE `fontyourface_font`
  MODIFY `fid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20683;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `migrate_message_block_content_body_field`
--
ALTER TABLE `migrate_message_block_content_body_field`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_block_content_entity_display`
--
ALTER TABLE `migrate_message_block_content_entity_display`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_block_content_entity_form_display`
--
ALTER TABLE `migrate_message_block_content_entity_form_display`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_block_content_type`
--
ALTER TABLE `migrate_message_block_content_type`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_book_settings`
--
ALTER TABLE `migrate_message_book_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d6_book_settings`
--
ALTER TABLE `migrate_message_d6_book_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d6_custom_block`
--
ALTER TABLE `migrate_message_d6_custom_block`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_block`
--
ALTER TABLE `migrate_message_d7_block`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_book`
--
ALTER TABLE `migrate_message_d7_book`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_captcha_points`
--
ALTER TABLE `migrate_message_d7_captcha_points`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_captcha_settings`
--
ALTER TABLE `migrate_message_d7_captcha_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_color`
--
ALTER TABLE `migrate_message_d7_color`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_comment`
--
ALTER TABLE `migrate_message_d7_comment`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_comment_entity_display`
--
ALTER TABLE `migrate_message_d7_comment_entity_display`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_comment_entity_form_display`
--
ALTER TABLE `migrate_message_d7_comment_entity_form_display`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_comment_entity_form_display_subject`
--
ALTER TABLE `migrate_message_d7_comment_entity_form_display_subject`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_comment_field`
--
ALTER TABLE `migrate_message_d7_comment_field`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_comment_field_instance`
--
ALTER TABLE `migrate_message_d7_comment_field_instance`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_comment_type`
--
ALTER TABLE `migrate_message_d7_comment_type`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_custom_block`
--
ALTER TABLE `migrate_message_d7_custom_block`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_dblog_settings`
--
ALTER TABLE `migrate_message_d7_dblog_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_field`
--
ALTER TABLE `migrate_message_d7_field`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `migrate_message_d7_field_formatter_settings`
--
ALTER TABLE `migrate_message_d7_field_formatter_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

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

--
-- AUTO_INCREMENT for table `migrate_message_d7_field_instance_widget_settings`
--
ALTER TABLE `migrate_message_d7_field_instance_widget_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_file`
--
ALTER TABLE `migrate_message_d7_file`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `migrate_message_d7_file_private`
--
ALTER TABLE `migrate_message_d7_file_private`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_filter_format`
--
ALTER TABLE `migrate_message_d7_filter_format`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `migrate_message_d7_filter_settings`
--
ALTER TABLE `migrate_message_d7_filter_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_global_theme_settings`
--
ALTER TABLE `migrate_message_d7_global_theme_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_google_analytics_settings`
--
ALTER TABLE `migrate_message_d7_google_analytics_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_google_analytics_user_settings`
--
ALTER TABLE `migrate_message_d7_google_analytics_user_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_image_settings`
--
ALTER TABLE `migrate_message_d7_image_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_image_styles`
--
ALTER TABLE `migrate_message_d7_image_styles`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `migrate_message_d7_menu_links`
--
ALTER TABLE `migrate_message_d7_menu_links`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `migrate_message_d7_node_complete__admin_profile`
--
ALTER TABLE `migrate_message_d7_node_complete__admin_profile`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_node_complete__article`
--
ALTER TABLE `migrate_message_d7_node_complete__article`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_node_complete__book`
--
ALTER TABLE `migrate_message_d7_node_complete__book`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `migrate_message_d7_node_complete__document`
--
ALTER TABLE `migrate_message_d7_node_complete__document`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_node_complete__event`
--
ALTER TABLE `migrate_message_d7_node_complete__event`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_node_complete__featured_person_of_the_month`
--
ALTER TABLE `migrate_message_d7_node_complete__featured_person_of_the_month`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_node_complete__map_location`
--
ALTER TABLE `migrate_message_d7_node_complete__map_location`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `migrate_message_d7_node_complete__notice`
--
ALTER TABLE `migrate_message_d7_node_complete__notice`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `migrate_message_d7_node_complete__photo_album`
--
ALTER TABLE `migrate_message_d7_node_complete__photo_album`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_node_complete__procurement_advertisement`
--
ALTER TABLE `migrate_message_d7_node_complete__procurement_advertisement`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_node_complete__staff_profile`
--
ALTER TABLE `migrate_message_d7_node_complete__staff_profile`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `migrate_message_d7_node_complete__ug_research`
--
ALTER TABLE `migrate_message_d7_node_complete__ug_research`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_node_complete__vacancy`
--
ALTER TABLE `migrate_message_d7_node_complete__vacancy`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_node_complete__video_album`
--
ALTER TABLE `migrate_message_d7_node_complete__video_album`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_node_complete__webform`
--
ALTER TABLE `migrate_message_d7_node_complete__webform`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_node_settings`
--
ALTER TABLE `migrate_message_d7_node_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_node_title_label`
--
ALTER TABLE `migrate_message_d7_node_title_label`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_node_type`
--
ALTER TABLE `migrate_message_d7_node_type`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_pathauto_patterns`
--
ALTER TABLE `migrate_message_d7_pathauto_patterns`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_pathauto_settings`
--
ALTER TABLE `migrate_message_d7_pathauto_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_photos_count`
--
ALTER TABLE `migrate_message_d7_photos_count`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_photos_settings`
--
ALTER TABLE `migrate_message_d7_photos_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_rdf_mapping`
--
ALTER TABLE `migrate_message_d7_rdf_mapping`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_shortcut`
--
ALTER TABLE `migrate_message_d7_shortcut`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_shortcut_set`
--
ALTER TABLE `migrate_message_d7_shortcut_set`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_shortcut_set_users`
--
ALTER TABLE `migrate_message_d7_shortcut_set_users`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_system_authorize`
--
ALTER TABLE `migrate_message_d7_system_authorize`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_system_cron`
--
ALTER TABLE `migrate_message_d7_system_cron`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_system_date`
--
ALTER TABLE `migrate_message_d7_system_date`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `migrate_message_d7_system_mail`
--
ALTER TABLE `migrate_message_d7_system_mail`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_system_performance`
--
ALTER TABLE `migrate_message_d7_system_performance`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_taxonomy_term__event_calendar_status`
--
ALTER TABLE `migrate_message_d7_taxonomy_term__event_calendar_status`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_taxonomy_term__newsletter`
--
ALTER TABLE `migrate_message_d7_taxonomy_term__newsletter`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_taxonomy_term__subscribe`
--
ALTER TABLE `migrate_message_d7_taxonomy_term__subscribe`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_taxonomy_term__tags`
--
ALTER TABLE `migrate_message_d7_taxonomy_term__tags`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_taxonomy_term__ug_research`
--
ALTER TABLE `migrate_message_d7_taxonomy_term__ug_research`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_taxonomy_vocabulary`
--
ALTER TABLE `migrate_message_d7_taxonomy_vocabulary`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_theme_settings`
--
ALTER TABLE `migrate_message_d7_theme_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_url_alias`
--
ALTER TABLE `migrate_message_d7_url_alias`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_user`
--
ALTER TABLE `migrate_message_d7_user`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_user_flood`
--
ALTER TABLE `migrate_message_d7_user_flood`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_user_mail`
--
ALTER TABLE `migrate_message_d7_user_mail`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_user_role`
--
ALTER TABLE `migrate_message_d7_user_role`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_d7_user_settings`
--
ALTER TABLE `migrate_message_d7_user_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `migrate_message_file_settings`
--
ALTER TABLE `migrate_message_file_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_menu_settings`
--
ALTER TABLE `migrate_message_menu_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_system_image`
--
ALTER TABLE `migrate_message_system_image`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_system_image_gd`
--
ALTER TABLE `migrate_message_system_image_gd`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_system_logging`
--
ALTER TABLE `migrate_message_system_logging`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_system_maintenance`
--
ALTER TABLE `migrate_message_system_maintenance`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_system_rss`
--
ALTER TABLE `migrate_message_system_rss`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_system_site`
--
ALTER TABLE `migrate_message_system_site`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_taxonomy_settings`
--
ALTER TABLE `migrate_message_taxonomy_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_text_settings`
--
ALTER TABLE `migrate_message_text_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_update_settings`
--
ALTER TABLE `migrate_message_update_settings`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_user_picture_entity_display`
--
ALTER TABLE `migrate_message_user_picture_entity_display`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_user_picture_entity_form_display`
--
ALTER TABLE `migrate_message_user_picture_entity_form_display`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_user_picture_field`
--
ALTER TABLE `migrate_message_user_picture_field`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrate_message_user_picture_field_instance`
--
ALTER TABLE `migrate_message_user_picture_field_instance`
  MODIFY `msgid` int UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `par`
--
ALTER TABLE `par`
  MODIFY `parid` int NOT NULL AUTO_INCREMENT COMMENT 'Primary key: Permission ID';

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `simple_popup_blocks`
--
ALTER TABLE `simple_popup_blocks`
  MODIFY `pid` int NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique simple_popup_blocks ID.';

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

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

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

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

--
-- AUTO_INCREMENT for table `webform_scheduled_email`
--
ALTER TABLE `webform_scheduled_email`
  MODIFY `eid` int NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Scheduled email ID.';

--
-- AUTO_INCREMENT for table `webform_submission`
--
ALTER TABLE `webform_submission`
  MODIFY `sid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

