<commit_before>INSERT INTO genders (GenderID,GenderName) VALUES (1,"Unspecified");
INSERT INTO genders (GenderID,GenderName) VALUES (2,"Male");
INSERT INTO genders (GenderID,GenderName) VALUES (3,"Female");

INSERT INTO countries(CountryID,CountrySymbol,CountryName,FlagPath) VALUES (1,"FI","Finland",NULL);
INSERT INTO countries(CountryID,CountrySymbol,CountryName,FlagPath) VALUES (2,"JP","Japan",NULL);
INSERT INTO countries(CountryID,CountrySymbol,CountryName,FlagPath) VALUES (3,"UK","United Kingdom",NULL);
INSERT INTO countries(CountryID,CountrySymbol,CountryName,FlagPath) VALUES (4,"US","United States",NULL);
INSERT INTO countries(CountryID,CountrySymbol,CountryName,FlagPath) VALUES (5,"GER","Germany",NULL);

INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (1, 'usr', NULL, '$2a$09$28027a93d18381da00365e1Hfgl1C0GJFX79cLpBWYgv3lVj9cvNq', '28027a93d18381da00365ea0ad36cd8a', NULL, NULL, NULL, '2015-12-12 21:14:07', '2015-12-12 21:14:07', NULL, '1', '0', NULL, NULL, NULL, NULL, '37', '2', '2', 'A User', NULL, 'test user please ignore');
INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (2, 'mod', NULL, '$2a$09$28027a93d18381da00365e1Hfgl1C0GJFX79cLpBWYgv3lVj9cvNq', '2<PASSWORD>da<PASSWORD>6<PASSWORD>cd8a', NULL, NULL, NULL, '2015-12-12 21:14:07', '2015-12-12 21:14:07', NULL, '6', '0', NULL, NULL, 'Alice', NULL, '93', '3', '3', 'A Moderator', NULL, 'Moderators can\'t actually do anything.');
INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (3, 'adm', NULL, '$2a$09$28027a93d18381da00365e1Hfgl1C0GJFX79cLpBWYgv3lVj9cvNq', '28027a93d18381da00365ea0ad36cd8a', NULL, NULL, NULL, '2015-12-12 21:14:07', '2015-12-12 21:14:07', NULL, '9', '0', NULL, NULL, NULL, NULL, '45', NULL, '3', 'An Admin', NULL, 'I have the power! To do nothing at the moment.');
INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (4, 'test4', NULL, '$2a$09$28027a93d18381da00365e1Hfgl1C0GJFX79cLpBWYgv3lVj9cvNq', '28027a93d18381da00365ea0ad36cd8a', NULL, NULL, NULL, '2015-12-12 21:14:07', '2015-12-12 21:14:07', NULL, '1', '0', NULL, NULL, NULL, NULL, NULL, NULL, '5', 'Test Account 4', NULL, NULL);
INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (5, 'test5', NULL, '$2a$09$28027a93d18381da00365e1Hfgl1C0GJFX79cLpBWYgv3lVj9cvNq', '28027a93d18381da00365ea0ad36cd8a', NULL, NULL, NULL, '2015-12-12 21:14:07', '2015-12-12 21:14:07', NULL, '1', '0', NULL, NULL, 'John', 'Doe', '7', '2', '4', 'Test Account 5', NULL, NULL);
INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (6, 'test6', NULL, '$2a$09$28027a93d18381da00365e1Hfgl1C0GJFX79cLpBWYgv3lVj9cvNq', '28027a93d18381da00365ea0ad36cd8a', NULL, NULL, NULL, '2015-12-12 21:14:07', '2015-12-12 21:14:07', NULL, '1', '0', NULL, NULL, 'Jane', 'Doe', NULL, '1', '5', 'Test Account 6', NULL, NULL);
INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (7, 'test7', NULL, '$2a$09$28027a93d18381da00365e1Hfgl1C0GJFX79cLpBWYgv3lVj9cvNq', '28027a93d18381da00365ea0ad36cd8a', NULL, NULL, NULL, '2015-12-12 21:14:07', '2015-12-12 21:14:07', NULL, '1', '0', NULL, NULL, NULL, NULL, '73', NULL, NULL, 'Test Account 7', NULL, NULL);
INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (8, 'test8', NULL, '$2a$09$28027a93d18381da00365e1Hfgl1C0GJFX79cLpBWYgv3lVj9cvNq', '28027a93d18381da00365ea0ad36cd8a', NULL, NULL, NULL, '2015-12-12 21:14:07', '2015-12-12 21:14:07', NULL, '1', '0', NULL, NULL, NULL, NULL, '43', '3', '2', 'Test Account 8', NULL, NULL);
INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (9, 'test9', NULL, '$2a$09$28027a93d18381da00365e1Hfgl1C0GJFX79cLpBWYgv3lVj9cvNq', '28027a93d18381da00365ea0ad36cd8a', NULL, NULL, NULL, '2015-12-12 21:14:07', '2015-12-12 21:14:07', NULL, '1', '0', NULL, NULL, 'Bob', NULL, '43', '1', '5', 'Test Account 9', NULL, NULL);
INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (10, 'test10', NULL, '$2a$09$28027a93d18381da00365e1Hfgl1C0GJFX79cLpBWYgv3lVj9cvNq', '28027a93d18381da00365ea0ad36cd8a', NULL, NULL, NULL, '2015-12-12 21:14:07', '2015-12-12 21:14:07', NULL, '1', '0', NULL, NULL, NULL, 'Anon', NULL, NULL, NULL, 'Test Account 10', NULL, NULL);<commit_msg>Added presentation user accounts with password <PASSWORD><commit_after>INSERT INTO genders (GenderID,GenderName) VALUES (1,"Unspecified");
INSERT INTO genders (GenderID,GenderName) VALUES (2,"Male");
INSERT INTO genders (GenderID,GenderName) VALUES (3,"Female");

INSERT INTO countries(CountryID,CountrySymbol,CountryName,FlagPath) VALUES (1,"FI","Finland",NULL);
INSERT INTO countries(CountryID,CountrySymbol,CountryName,FlagPath) VALUES (2,"JP","Japan",NULL);
INSERT INTO countries(CountryID,CountrySymbol,CountryName,FlagPath) VALUES (3,"UK","United Kingdom",NULL);
INSERT INTO countries(CountryID,CountrySymbol,CountryName,FlagPath) VALUES (4,"US","United States",NULL);
INSERT INTO countries(CountryID,CountrySymbol,CountryName,FlagPath) VALUES (5,"GER","Germany",NULL);

INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (1, 'usr', NULL, '$2a$09$28027a93d18381da00365e1Hfgl1C0GJFX79cLpBWYgv3lVj9cvNq', '28027a93d18381da00365ea0ad36cd8a', NULL, NULL, NULL, '2015-12-12 21:14:07', '2015-12-12 21:14:07', NULL, '1', '0', NULL, NULL, NULL, NULL, '37', '2', '2', 'A User', NULL, 'test user please ignore');
INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (2, 'mod', NULL, '$2a$09$28027a93d18381da00365e1Hfgl1C0GJFX79cLpBWYgv3lVj9cvNq', '28027a93d18381da00365ea0ad36cd8a', NULL, NULL, NULL, '2015-12-12 21:14:07', '2015-12-12 21:14:07', NULL, '6', '0', NULL, NULL, 'Alice', NULL, '93', '3', '3', 'A Moderator', NULL, 'Moderators can\'t actually do anything.');
INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (3, 'adm', NULL, '$2a$09$28027a93d18381da00365e1Hfgl1C0GJFX79cLpBWYgv3lVj9cvNq', '28027a93d18381da00365ea0ad36cd8a', NULL, NULL, NULL, '2015-12-12 21:14:07', '2015-12-12 21:14:07', NULL, '9', '0', NULL, NULL, NULL, NULL, '45', NULL, '3', 'An Admin', NULL, 'I have the power! To do nothing at the moment.');
INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (4, 'test4', NULL, '$2a$09$28027a93d18381da00365e1Hfgl1C0GJFX79cLpBWYgv3lVj9cvNq', '28027a93d18381da00365ea0ad36cd8a', NULL, NULL, NULL, '2015-12-12 21:14:07', '2015-12-12 21:14:07', NULL, '1', '0', NULL, NULL, NULL, NULL, NULL, NULL, '5', 'Test Account 4', NULL, NULL);
INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (5, 'test5', NULL, '$2a$09$28027a93d18381da00365e1Hfgl1C0GJFX79cLpBWYgv3lVj9cvNq', '28027a93d18381da00365ea0ad36cd8a', NULL, NULL, NULL, '2015-12-12 21:14:07', '2015-12-12 21:14:07', NULL, '1', '0', NULL, NULL, 'John', 'Doe', '7', '2', '4', 'Test Account 5', NULL, NULL);
INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (6, 'test6', NULL, '$2a$09$28027a93d18381da00365e1Hfgl1C0GJFX79cLpBWYgv3lVj9cvNq', '28027a93d18381da00365ea0ad36cd8a', NULL, NULL, NULL, '2015-12-12 21:14:07', '2015-12-12 21:14:07', NULL, '1', '0', NULL, NULL, 'Jane', 'Doe', NULL, '1', '5', 'Test Account 6', NULL, NULL);
INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (7, 'test7', NULL, '$2a$09$28027a93d18381da00365e1Hfgl1C0GJFX79cLpBWYgv3lVj9cvNq', '28027a93d18381da00365ea0ad36cd8a', NULL, NULL, NULL, '2015-12-12 21:14:07', '2015-12-12 21:14:07', NULL, '1', '0', NULL, NULL, NULL, NULL, '73', NULL, NULL, 'Test Account 7', NULL, NULL);
INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (8, 'test8', NULL, '$2a$09$28027a93d18381da00365e1Hfgl1C0GJFX79cLpBWYgv3lVj9cvNq', '28027a93d18381da00365ea0ad36cd8a', NULL, NULL, NULL, '2015-12-12 21:14:07', '2015-12-12 21:14:07', NULL, '1', '0', NULL, NULL, NULL, NULL, '43', '3', '2', 'Test Account 8', NULL, NULL);
INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (9, 'test9', NULL, '$2a$09$28027a93d18381da00365e1Hfgl1C0GJFX79cLpBWYgv3lVj9cvNq', '28027a93d18381da00365ea0ad36cd8a', NULL, NULL, NULL, '2015-12-12 21:14:07', '2015-12-12 21:14:07', NULL, '1', '0', NULL, NULL, 'Bob', NULL, '43', '1', '5', 'Test Account 9', NULL, NULL);
INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (10, 'test10', NULL, '$2a$09$28027a93d18381da00365e1Hfgl1C0GJFX79cLpBWYgv3lVj9cvNq', '28027a93d18381da00365ea0ad36cd8a', NULL, NULL, NULL, '2015-12-12 21:14:07', '2015-12-12 21:14:07', NULL, '1', '0', NULL, NULL, NULL, 'Anon', NULL, NULL, NULL, 'Test Account 10', NULL, NULL);
INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (100, 'public', NULL, '$2a$09$e4112dc1686b0a786d376ODeCzh8jMpM.w8SoXKjf86VvGKSSsUc6', 'e4112dc1686b0a786d376d2870de4674', NULL, NULL, NULL, '2015-12-16 10:52:29', '2015-12-16 10:52:29', NULL, '1', '0', NULL, NULL, NULL, 'Anon', NULL, NULL, NULL, 'Esitys', NULL, NULL);
INSERT INTO `users`(`user_id`, `user_name`, `user_email`, `user_pass`, `user_salt`, `user_last_login`, `user_login_time`, `user_session_id`, `user_date`, `user_modified`, `user_agent_string`, `user_level`, `user_banned`, `passwd_recovery_code`, `passwd_recovery_date`, FirstName, LastName, Age, GenderID, CountryID, ScreenName, AvatarPath, Bio) VALUES (101, 'admin', NULL, '$2a$09$e4112dc1686b0a786d376ODeCzh8jMpM.w8SoXKjf86VvGKSSsUc6', 'e4112dc1686b0a786d376d2870de4674', NULL, NULL, NULL, '2015-12-16 10:52:29', '2015-12-16 10:52:29', NULL, '9', '0', NULL, NULL, NULL, 'Anon', NULL, NULL, NULL, 'Esitys Admin', NULL, NULL);
{'fraction_non_alphanumeric': 0.1775439963634002, 'fraction_numerical': 0.11844924995129553, 'mean_word_length': 10.127167630057803, 'pattern_counts': {'":': 0, '<': 7, '<?xml version=': 0, '>': 7, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4281583', 'n_tokens_mistral': 7240, 'n_tokens_neox': 6146, 'n_words': 1284}