<commit_before>-- AUTHORITIES
INSERT INTO authorities(id, username, authority) VALUES (1, '<EMAIL>', 'ROLE_USER');
INSERT INTO authorities(id, username, authority) VALUES (2, '<EMAIL>', 'ROLE_USER');
INSERT INTO authorities(id, username, authority) VALUES (3, '<EMAIL>', 'ROLE_USER');
INSERT INTO authorities(id, username, authority) VALUES (4, '<EMAIL>', 'ROLE_USER');
INSERT INTO authorities(id, username, authority) VALUES (5, '<EMAIL>', 'ROLE_USER');
INSERT INTO authorities(id, username, authority) VALUES (6, '<EMAIL>', 'ROLE_USER');
INSERT INTO authorities(id, username, authority) VALUES (7, '<EMAIL>', 'ROLE_USER');
INSERT INTO authorities(id, username, authority) VALUES (8, '<EMAIL>', 'ROLE_USER');
INSERT INTO authorities(id, username, authority) VALUES (9, '<EMAIL>', 'ROLE_USER');
INSERT INTO authorities(id, username, authority) VALUES (10, '<EMAIL>', 'ROLE_USER');
INSERT INTO authorities(id, username, authority) VALUES (11, '<EMAIL>', 'ROLE_USER');

-- USERS (username and password are always identical)
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (1, 'Arthur', 'Dent', '<EMAIL>', '<EMAIL>', '$2a$10$UYOseFWgR87PwL2j8VmycO.IjuH2uGht3lGFGBn2ShUUS9B4zclIe', '2010-05-05 10:45:33', 'ROOKIE', TRUE);
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (2, 'Ford', 'Prefect', '<EMAIL>', '<EMAIL>', '$2a$10$8yg/hBDXP0bpQuuKJneYbucl0/NsjfT1zQjMsEcnFrjt.6tVnrAEW', '2012-10-01 11:02:29', 'PRO', TRUE);
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (3, 'Zaphod', 'Beeblebrox', '<EMAIL>', '<EMAIL>', '$2a$10$fBUuTN5MQafWRqWULmC8DuN30CTWOphJZlUOJnO/woK2uPM.5e4vC', '2015-09-23 08:52:11', 'NEWBIE', TRUE);
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (4, 'Marvin', '', '<EMAIL>', '<EMAIL>', <PASSWORD>$10$PL7R5GjZX2xJJDaGK9PSsuq4nUWM4v9XaBC0lsIRYhv8OpHFEMl8u', '2010-01-01 08:52:11', 'NEWBIE', TRUE);
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (5, 'Humma', 'Kavula', '<EMAIL>', '<EMAIL>', <PASSWORD>U<PASSWORD>', '2011-02-02 08:52:11', 'PRO', TRUE);
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (6, 'Questular', 'Rontok', '<EMAIL>', '<EMAIL>', '$2a$10$OcYDMMBCzkOTLEn5AilcYupDNhHyZA2yowCjo9gXOtL1b0Fr0EGF2', '2012-03-03 08:52:11', 'NEWBIE', TRUE);
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (7, 'Deep', 'Thought', '<EMAIL>', '<EMAIL>', '$2a$10$8q2YjsU1axyOwC6Vjsr8VOvwpjqh84ZlAzTgUO/NV38BjsuuVoBTe', '2013-04-04 08:52:11', 'NEWBIE', TRUE);
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (8, 'Tricia', 'McMillan', '<EMAIL>', '<EMAIL>', '$2a$10$ubWNmc1TD8gDpBTR2Tfl9eE0lvYEZmB4dyvd47KLCLnTAnjNCA0e2', '2014-05-05 08:52:11', 'PRO', TRUE);
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (9, 'Slartibartfast', '', '<EMAIL>', '<EMAIL>', <PASSWORD>ER<PASSWORD>.Z<PASSWORD>oh<PASSWORD>', '2015-06-06 08:52:11', 'NEWBIE', TRUE);
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (10, 'Jin', 'Jenz', '<EMAIL>', '<EMAIL>', '$2a$10$EaOdJoUZKay5RXLwR552h.QdTjYroGIU0WKT5BAWetOPSDBEA2BY2', '2010-07-07 08:52:11', 'NEWBIE', TRUE);
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (11, 'Gag', 'Halfrunt', '<EMAIL>', '<EMAIL>', '$2a$10$W7Ik5kkje5NGJQpKBV10TuKXGjZ2So2Oq8w9UMDuFj88ziwrONwQ6', '2011-08-08 08:52:11', 'NEWBIE', TRUE);

-- ENCOUNTERS
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (1, 'JavaOne 1996', 'San Francisco', 'USA', '', '1996-10-01', 5);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (2, 'JavaOne 1997', 'San Francisco', 'USA', '', '1997-10-01', 5);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (3, 'JavaOne 1998', 'San Francisco', 'USA', '', '1998-10-01', 5);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (4, 'JavaOne 1999', 'San Francisco', 'USA', '', '1999-10-01', 5);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (5, 'JavaOne 2000', 'San Francisco', 'USA', '', '2000-10-01', 5);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (6, 'JavaOne 2001', 'San Francisco', 'USA', '', '2001-10-01', 5);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (7, 'JavaOne 2002', 'San Francisco', 'USA', '', '2002-10-01', 5);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (8, 'JavaOne 2003', 'San Francisco', 'USA', '', '2003-10-01', 8);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (9, 'JavaOne 2004', 'San Francisco', 'USA', '', '2004-10-01', 8);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (10, 'JavaOne 2005', 'San Francisco', 'USA', '', '2005-10-01', 8);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (11, 'JavaOne 2006', 'San Francisco', 'USA', '', '2006-10-01', 5);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (12, 'JavaOne 2007', 'San Francisco', 'USA', '', '2007-10-01', 5);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (13, 'JavaOne 2008', 'San Francisco', 'USA', '', '2008-10-01', 5);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (14, 'JavaOne 2009', 'San Francisco', 'USA', '', '2009-10-01', 5);<commit_msg>Updated SQL<commit_after>-- AUTHORITIES
INSERT INTO authorities(id, username, authority) VALUES (1, '<EMAIL>', 'ROLE_USER');
INSERT INTO authorities(id, username, authority) VALUES (2, '<EMAIL>', 'ROLE_USER');
INSERT INTO authorities(id, username, authority) VALUES (3, '<EMAIL>', 'ROLE_USER');
INSERT INTO authorities(id, username, authority) VALUES (4, '<EMAIL>', 'ROLE_USER');
INSERT INTO authorities(id, username, authority) VALUES (5, '<EMAIL>', 'ROLE_USER');
INSERT INTO authorities(id, username, authority) VALUES (6, '<EMAIL>', 'ROLE_USER');
INSERT INTO authorities(id, username, authority) VALUES (7, '<EMAIL>', 'ROLE_USER');
INSERT INTO authorities(id, username, authority) VALUES (8, '<EMAIL>', 'ROLE_USER');
INSERT INTO authorities(id, username, authority) VALUES (9, '<EMAIL>', 'ROLE_USER');
INSERT INTO authorities(id, username, authority) VALUES (10, '<EMAIL>', 'ROLE_USER');
INSERT INTO authorities(id, username, authority) VALUES (11, '<EMAIL>', 'ROLE_USER');

-- USERS (username and password are always identical)
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (1, 'Arthur', 'Dent', '<EMAIL>', '<EMAIL>', '$2a$10$UYOseFWgR87PwL2j8VmycO.IjuH2uGht3lGFGBn2ShUUS9B4zclIe', '2010-05-05 10:45:33', 'ROOKIE', TRUE);
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (2, 'Ford', 'Prefect', '<EMAIL>', '<EMAIL>', '$2a$10$8yg/hBDXP0bpQuuKJneYbucl0/NsjfT1zQjMsEcnFrjt.6tVnrAEW', '2012-10-01 11:02:29', 'PRO', TRUE);
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (3, 'Zaphod', 'Beeblebrox', '<EMAIL>', '<EMAIL>', '$2a$10$fBUuTN5MQafWRqWULmC8DuN30CTWOphJZlUOJnO/woK2uPM.5e4vC', '2015-09-23 08:52:11', 'NEWBIE', TRUE);
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (4, 'Marvin', '', '<EMAIL>', '<EMAIL>', '$2a$10$PL7R5GjZX2xJJDaGK9PSsuq4nUWM4v9XaBC0lsIRYhv8OpHFEMl8u', '2010-01-01 08:52:11', 'NEWBIE', TRUE);
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (5, 'Humma', 'Kavula', '<EMAIL>', '<EMAIL>', '$2a$10$wRQ2YUJI8TTK0jWLRidwbu0HJxAdOGWUdLV8gHjT9KkUtc/w7TdcW', '2011-02-02 08:52:11', 'PRO', TRUE);
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (6, 'Questular', 'Rontok', '<EMAIL>', '<EMAIL>', <PASSWORD>', '2012-03-03 08:52:11', 'NEWBIE', TRUE);
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (7, 'Deep', 'Thought', '<EMAIL>', '<EMAIL>', <PASSWORD>', '2013-04-04 08:52:11', 'NEWBIE', TRUE);
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (8, 'Tricia', 'McMillan', '<EMAIL>', '<EMAIL>', <PASSWORD>', '2014-05-05 08:52:11', 'PRO', TRUE);
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (9, 'Slartibartfast', '', '<EMAIL>', '<EMAIL>', '$2a$10$8lFXL0sPVQERcfJIG.UaIuPjoo9xeSRRdk8.Z20FdujLqohdvy8WO', '2015-06-06 08:52:11', 'NEWBIE', TRUE);
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (10, 'Jin', 'Jenz', '<EMAIL>', '<EMAIL>', '$2a$10$EaOdJoUZKay5RXLwR552h.QdTjYroGIU0WKT5BAWetOPSDBEA2BY2', '2010-07-07 08:52:11', 'NEWBIE', TRUE);
INSERT INTO users (id, firstname, lastname, email, username, password, registration_date, level, enabled) VALUES (11, 'Gag', 'Halfrunt', '<EMAIL>', '<EMAIL>', '$2a$10$W7Ik5kkje5NGJQpKBV10TuKXGjZ2So2Oq8w9UMDuFj88ziwrONwQ6', '2011-08-08 08:52:11', 'NEWBIE', TRUE);

-- ENCOUNTERS
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (1, 'JavaOne 1996', 'San Francisco', 'USA', '', '1996-05-31', 5);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (2, 'JavaOne 1997', 'San Francisco', 'USA', '', '1997-04-04', 5);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (3, 'JavaOne 1998', 'San Francisco', 'USA', '', '1998-03-01', 5);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (4, 'JavaOne 1999', 'San Francisco', 'USA', '', '1999-10-01', 5);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (5, 'JavaOne 2000', 'San Francisco', 'USA', '', '2000-10-01', 5);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (6, 'JavaOne 2001', 'San Francisco', 'USA', '', '2001-10-01', 5);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (7, 'JavaOne 2002', 'San Francisco', 'USA', '', '2002-10-01', 5);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (8, 'JavaOne 2003', 'San Francisco', 'USA', '', '2003-10-01', 8);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (9, 'JavaOne 2004', 'San Francisco', 'USA', '', '2004-10-01', 8);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (10, 'JavaOne 2005', 'San Francisco', 'USA', '', '2005-10-01', 8);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (11, 'JavaOne 2006', 'San Francisco', 'USA', '', '2006-10-01', 5);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (12, 'JavaOne 2007', 'San Francisco', 'USA', '', '2007-10-01', 5);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (13, 'JavaOne 2008', 'San Francisco', 'USA', '', '2008-10-01', 5);
INSERT INTO encounters (id, event, location, country, comment, date, user_id) VALUES (14, 'JavaOne 2009', 'San Francisco', 'USA', '', '2009-10-01', 5);
{'fraction_non_alphanumeric': 0.18444070647603028, 'fraction_numerical': 0.08023549201009252, 'mean_word_length': 7.356289529163739, 'pattern_counts': {'":': 0, '<': 79, '<?xml version=': 0, '>': 79, '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': '4814361', 'n_tokens_mistral': 4949, 'n_tokens_neox': 4275, 'n_words': 1252}