<commit_before>/**
 * @author: KentProjects <<EMAIL>>
 * @license: Copyright KentProjects
 * @link: http://kentprojects.com
 */
INSERT INTO `Application` (`application_id`, `key`, `secret`, `name`, `created`)
VALUES
	(1, '77bf0b0815ce058841d74298394643ab', '7ede1f827d744b39666214441122764c', 'Frontend', CURRENT_TIMESTAMP),
	(2, 'ad7921ce757a74d8676c9140ec498003', 'be0855399d72ad351807f3eeecec5ade', 'PHPUnit', CURRENT_TIMESTAMP)
ON DUPLICATE KEY UPDATE `application_id` = `application_id`, `key` = VALUES(`key`), `name` = VALUES(`name`),
	`created` = VALUES(`created`);

INSERT INTO `Year` (`year`)
VALUES
	(2013), (2014)
ON DUPLICATE KEY UPDATE `year` = `year`;

INSERT INTO `User` (`user_id`, `email`, `first_name`, `last_name`, `role`, `created`, `updated`)
VALUES
	(1, '<EMAIL>ernande<EMAIL>', 'Julio', 'Hernandez-Castro', 'staff', '2014-11-21 18:38:56',
	 '2014-12-16 16:46:58'),
	(2, '<EMAIL>', 'John', 'Crawford', 'staff', '2014-11-21 21:31:46', '2014-12-16 16:47:03'),
	(3, '<EMAIL>', 'Matt', 'House', 'student', '2014-11-21 21:31:52', '2014-12-16 16:47:06'),
	(4, '<EMAIL>', 'James', 'Dryden', 'student', '2014-11-27 19:19:35', '2014-12-16 16:47:09'),
	(5, '<EMAIL>', 'Matthew', 'Weeks', 'student', '2014-11-27 20:12:15', '2014-12-16 16:47:09'),
	(6, '<EMAIL>', 'Stuart', 'Supervisor', 'staff', '2014-11-28 11:10:05', '2014-12-16 16:47:14')
ON DUPLICATE KEY UPDATE `user_id` = `user_id`, `email` = `email`, `first_name` = VALUES(`first_name`),
	`last_name` = VALUES(`last_name`), `role` = `role`, `created` = `created`, `updated` = `updated`;

INSERT INTO `User_Year_Map` (`year`, `user_id`, `role_convener`, `role_supervisor`, `role_secondmarker`)
VALUES
	(2014, 1, TRUE, FALSE, FALSE),
	(2014, 2, FALSE, TRUE, TRUE),
	(2014, 3, FALSE, FALSE, FALSE),
	(2014, 4, FALSE, FALSE, FALSE),
	(2014, 5, FALSE, FALSE, FALSE),
	(2014, 6, FALSE, TRUE, TRUE)
ON DUPLICATE KEY UPDATE `year` = `year`, `user_id` = `user_id`, `role_convener` = VALUES(`role_convener`),
	`role_supervisor` = VALUES(`role_supervisor`), `role_secondmarker` = VALUES(`role_secondmarker`);

INSERT INTO `Group` (`group_id`, `year`, `name`, `creator_id`, `created`)
VALUES
	(1, 2014, 'The Master Commanders', 3, CURRENT_TIMESTAMP)
ON DUPLICATE KEY UPDATE `group_id` = `group_id`, `year` = VALUES(`year`), `name` = VALUES(`name`),
	`creator_id` = VALUES(`creator_id`), `created` = VALUES(`created`);

INSERT INTO `Group_Student_Map` (`group_id`, `user_id`)
VALUES
	(1, 3), (1, 4), (1, 5)
ON DUPLICATE KEY UPDATE `group_id` = `group_id`, `user_id` = `user_id`;

INSERT INTO `Project` (`project_id`, `year`, `group_id`, `name`, `slug`, `creator_id`, `supervisor_id`, `created`)
VALUES
	(1, 2014, 1, 'Student Project Support System', 'student-project-support-system', 3, 2, CURRENT_TIMESTAMP),
	(2, 2014, NULL, 'Kettle Project', 'kettle-project', 1, 2, CURRENT_TIMESTAMP),
	(3, 2014, NULL, 'Flying Helicopter Drones', 'flying-helicopter-drones', 1, 6, CURRENT_TIMESTAMP),
	(4, 2014, NULL, 'Clever Dashboard', 'clever-dashboard', 1, 6, CURRENT_TIMESTAMP),
	(5, 2014, NULL, 'CS Kent Website Improvements', 'cs-kent-website-improvements', 1, 6, CURRENT_TIMESTAMP)
ON DUPLICATE KEY UPDATE `group_id` = `group_id`, `year` = VALUES(`year`), `name` = VALUES(`name`),
	`slug` = VALUES(`slug`), `creator_id` = VALUES(`creator_id`), `supervisor_id` = VALUES(`supervisor_id`),
	`created` = VALUES(`created`);

INSERT INTO `Project_Supervisor_Map` (`project_id`, `user_id`)
VALUES
	(1, 2)
ON DUPLICATE KEY UPDATE `project_id` = `project_id`, `user_id` = `user_id`;

INSERT INTO `ACL` (`user_id`, `entity`, `create`, `read`, `update`, `delete`)
VALUES
	(1, 'group', 1, 1, 1, 1),
	(1, 'project', 1, 1, 1, 1),
	(1, 'user', 1, 1, 1, 1);

INSERT INTO `Metadata` (`root`, `key`, `value`) VALUES<commit_msg>Jeez, bet House regrets not betting a coffee for these repercussions!<commit_after>/**
 * @author: KentProjects <<EMAIL>>
 * @license: Copyright KentProjects
 * @link: http://kentprojects.com
 */
INSERT INTO `Application` (`application_id`, `key`, `secret`, `name`, `created`)
VALUES
	(1, '77bf0b0815ce058841d74298394643ab', '7ede1f827d744b39666214441122764c', 'Frontend', CURRENT_TIMESTAMP),
	(2, 'ad7921ce757a74d8676c9140ec498003', 'be0855399d72ad351807f3eeecec5ade', 'PHPUnit', CURRENT_TIMESTAMP)
ON DUPLICATE KEY UPDATE `application_id` = `application_id`, `key` = VALUES(`key`), `name` = VALUES(`name`),
	`created` = VALUES(`created`);

INSERT INTO `Year` (`year`)
VALUES
	(2013), (2014)
ON DUPLICATE KEY UPDATE `year` = `year`;

INSERT INTO `User` (`user_id`, `email`, `first_name`, `last_name`, `role`, `created`, `updated`)
VALUES
	(1, '<EMAIL>ernande<EMAIL>', 'Julio', 'Hernandez-Castro', 'staff', '2014-11-21 18:38:56',
	 '2014-12-16 16:46:58'),
	(2, '<EMAIL>', 'John', 'Crawford', 'staff', '2014-11-21 21:31:46', '2014-12-16 16:47:03'),
	(3, '<EMAIL>', 'Matt', 'House', 'student', '2014-11-21 21:31:52', '2014-12-16 16:47:06'),
	(4, '<EMAIL>', 'James', 'Dryden', 'student', '2014-11-27 19:19:35', '2014-12-16 16:47:09'),
	(5, '<EMAIL>', 'Matthew', 'Weeks', 'student', '2014-11-27 20:12:15', '2014-12-16 16:47:09'),
	(6, '<EMAIL>', 'Stuart', 'Supervisor', 'staff', '2014-11-28 11:10:05', '2014-12-16 16:47:14')
ON DUPLICATE KEY UPDATE `user_id` = `user_id`, `email` = `email`, `first_name` = VALUES(`first_name`),
	`last_name` = VALUES(`last_name`), `role` = `role`, `created` = `created`, `updated` = `updated`;

INSERT INTO `User_Year_Map` (`year`, `user_id`, `role_convener`, `role_supervisor`, `role_secondmarker`)
VALUES
	(2014, 1, TRUE, FALSE, FALSE),
	(2014, 2, FALSE, TRUE, TRUE),
	(2014, 3, FALSE, FALSE, FALSE),
	(2014, 4, FALSE, FALSE, FALSE),
	(2014, 5, FALSE, FALSE, FALSE),
	(2014, 6, FALSE, TRUE, TRUE)
ON DUPLICATE KEY UPDATE `year` = `year`, `user_id` = `user_id`, `role_convener` = VALUES(`role_convener`),
	`role_supervisor` = VALUES(`role_supervisor`), `role_secondmarker` = VALUES(`role_secondmarker`);

INSERT INTO `Group` (`group_id`, `year`, `name`, `creator_id`, `created`)
VALUES
	(1, 2014, 'The Master Commanders', 3, CURRENT_TIMESTAMP)
ON DUPLICATE KEY UPDATE `group_id` = `group_id`, `year` = VALUES(`year`), `name` = VALUES(`name`),
	`creator_id` = VALUES(`creator_id`), `created` = VALUES(`created`);

INSERT INTO `Group_Student_Map` (`group_id`, `user_id`)
VALUES
	(1, 3), (1, 4), (1, 5)
ON DUPLICATE KEY UPDATE `group_id` = `group_id`, `user_id` = `user_id`;

INSERT INTO `Project` (`project_id`, `year`, `group_id`, `name`, `creator_id`, `supervisor_id`, `created`)
VALUES
	(1, 2014, 1, 'Student Project Support System', 3, 2, CURRENT_TIMESTAMP),
	(2, 2014, NULL, 'Kettle Project', 1, 2, CURRENT_TIMESTAMP),
	(3, 2014, NULL, 'Flying Helicopter Drones', 1, 6, CURRENT_TIMESTAMP),
	(4, 2014, NULL, 'Clever Dashboard', 1, 6, CURRENT_TIMESTAMP),
	(5, 2014, NULL, 'CS Kent Website Improvements', 1, 6, CURRENT_TIMESTAMP)
ON DUPLICATE KEY UPDATE `group_id` = `group_id`, `year` = VALUES(`year`), `name` = VALUES(`name`),
	`slug` = VALUES(`slug`), `creator_id` = VALUES(`creator_id`), `supervisor_id` = VALUES(`supervisor_id`),
	`created` = VALUES(`created`);

INSERT INTO `Project_Supervisor_Map` (`project_id`, `user_id`)
VALUES
	(1, 2)
ON DUPLICATE KEY UPDATE `project_id` = `project_id`, `user_id` = `user_id`;

INSERT INTO `ACL` (`user_id`, `entity`, `create`, `read`, `update`, `delete`)
VALUES
	(1, 'group', 1, 1, 1, 1),
	(1, 'project', 1, 1, 1, 1),
	(1, 'user', 1, 1, 1, 1);

INSERT INTO `Metadata` (`root`, `key`, `value`) VALUES
{'fraction_non_alphanumeric': 0.21468926553672316, 'fraction_numerical': 0.09900457358084477, 'mean_word_length': 6.5790010193679915, 'pattern_counts': {'":': 0, '<': 21, '<?xml version=': 0, '>': 21, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 2, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4290132', 'n_tokens_mistral': 3580, 'n_tokens_neox': 2981, 'n_words': 743}