<commit_before>SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE enumeration;
TRUNCATE enumeration_item;
TRUNCATE private_message;
TRUNCATE contact;
TRUNCATE post;
TRUNCATE user_community;
TRUNCATE userprofile;
TRUNCATE users;
TRUNCATE community;
SET FOREIGN_KEY_CHECKS = 1;

ALTER TABLE community AUTO_INCREMENT = 1; 
ALTER TABLE contact AUTO_INCREMENT = 1;  
ALTER TABLE enumeration AUTO_INCREMENT = 1; 
ALTER TABLE enumeration_item AUTO_INCREMENT = 1; 
ALTER TABLE post AUTO_INCREMENT = 1; 
ALTER TABLE private_message AUTO_INCREMENT = 1; 
ALTER TABLE user_community AUTO_INCREMENT = 1; 
ALTER TABLE userprofile AUTO_INCREMENT = 1; 
ALTER TABLE users AUTO_INCREMENT = 1; 

-- add status to enumeration
INSERT INTO enumeration (name) VALUES ('PENDING');		-- 1
INSERT INTO enumeration (name) VALUES ('APPROVED');		-- 2
INSERT INTO enumeration (name) VALUES ('REFUSED'); 		-- 3
INSERT INTO enumeration (name) VALUES ('ADMIN'); 		-- 4
INSERT INTO enumeration (name) VALUES ('PORTALADMIN'); 	-- 5
INSERT INTO enumeration (name) VALUES ('USER'); 		-- 6
INSERT INTO enumeration (name) VALUES ('LIKE'); 		-- 7

-- create user profiles
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('54 Brown Place','Tacoma','Washington','innovate B2C functionalities','<EMAIL>','Alexander','Baar','253-883-9229','801-140-3618','NULL',98447,47,'Backend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('455 Carberry Street','New York City','New York','enhance frictionless e-services','<EMAIL>.at','Sandjar','Berdiev','646-423-7060','505-219-4934','NULL',10170,66,'Frontend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('4251 Fremont Point','Oklahoma City','Oklahoma','morph customized networks','<EMAIL>','Reimer','Bogdan','405-945-2897','650-287-1783','NULL',73190,404,'Backend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('96224 Esker Junction','Detroit','Michigan','generate dot-com communities','<EMAIL>','Irfan','Dogic','313-360-4942','415-570-0683','NULL',48232,373,'Frontend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('5756 Fairview Pass','Homestead','Florida','synergize dot-com e-commerce','<EMAIL>','Florian','Gumhold','305-707-8564','304-844-6163','NULL',33034,942,'Frontend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('24792 Upham Hill','Port Charlotte','Florida','reintermediate best-of-breed communities','<EMAIL>','Bernhard','Haring','941-219-3640','251-975-5774','NULL',33954,702,'Backend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('6 Fremont Court','New York City','New York','transform user-centric portals','<EMAIL>','Christian','Hofer','212-362-5391','305-287-2449','NULL',10125,2,'Database');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('04168 Heffernan Lane','Athens','Georgia','recontextualize cutting-edge systems','<EMAIL>','Robert','Ionescu','706-105-0028','210-821-1608','NULL',30605,57700,'Frontend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('4968 Gale Plaza','Portland','Oregon','facilitate visionary applications','<EMAIL>','Roitinger','Michael','971-101-9581','571-673-1192','NULL',97255,16510,'Frontend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('277 Schiller Point','Springfield','Massachusetts','envisioneer B2C eyeballs','<EMAIL>','Stefan','Moder','413-258-7335','404-327-0613','NULL',1129,55,'Database');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('62 3rd Point','Springfield','Illinois','exploit e-business users','<EMAIL>','Nevzad','Mujic','217-473-3977','626-319-8097','NULL',62764,402,'Database');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('67342 Jenifer Junction','<NAME>','Minnesota','grow customized e-services','<EMAIL>','Matthias','Pointinger','612-562-1953','260-478-7944','NULL',55108,85,'Backend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('40 Muir Place','Washington','District of Columbia','brand back-end initiatives','<EMAIL>','Kerstin','Rampler','202-932-5620','419-996-7799','NULL',20260,0,'Backend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('66 Union Avenue','Sacramento','California','empower granular deliverables','<EMAIL>','Björn','Sattler','916-564-0938','508-114-0343','NULL',94230,4,'Frontend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('<NAME>','Fresno','California','engineer web-enabled e-business','<EMAIL>','Alexander','Schug','559-424-6981','713-475-7731','NULL',93704,28102,'Backend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('84 <NAME>','New York City','New York','exploit dot-com infrastructures','<EMAIL>','Josef','Steppan','917-471-8907','312-103-7161','NULL',10034,684,'Database');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('08379 Lien Court','Mobile','Alabama','grow efficient markets','<EMAIL>','Philipp ','Trummer','251-836-5478','571-407-2356','NULL',36616,4498,'Database');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('48260 Dapin Place','Round Rock','Texas','harness proactive supply-chains','<EMAIL>','Philip','Fuchsbichler','512-383-9062','218-153-0582','NULL',78682,9569,'Database');<commit_msg>Removed comments after Enum Insert<commit_after>SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE enumeration;
TRUNCATE enumeration_item;
TRUNCATE private_message;
TRUNCATE contact;
TRUNCATE post;
TRUNCATE user_community;
TRUNCATE userprofile;
TRUNCATE users;
TRUNCATE community;
SET FOREIGN_KEY_CHECKS = 1;

ALTER TABLE community AUTO_INCREMENT = 1; 
ALTER TABLE contact AUTO_INCREMENT = 1;  
ALTER TABLE enumeration AUTO_INCREMENT = 1; 
ALTER TABLE enumeration_item AUTO_INCREMENT = 1; 
ALTER TABLE post AUTO_INCREMENT = 1; 
ALTER TABLE private_message AUTO_INCREMENT = 1; 
ALTER TABLE user_community AUTO_INCREMENT = 1; 
ALTER TABLE userprofile AUTO_INCREMENT = 1; 
ALTER TABLE users AUTO_INCREMENT = 1; 

-- add status to enumeration
INSERT INTO enumeration (name) VALUES ('PENDING');
INSERT INTO enumeration (name) VALUES ('APPROVED');
INSERT INTO enumeration (name) VALUES ('REFUSED');
INSERT INTO enumeration (name) VALUES ('ADMIN');
INSERT INTO enumeration (name) VALUES ('PORTALADMIN');
INSERT INTO enumeration (name) VALUES ('USER');
INSERT INTO enumeration (name) VALUES ('LIKE');

-- create user profiles
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('54 Brown Place','Tacoma','Washington','innovate B2C functionalities','<EMAIL>','Alexander','Baar','253-883-9229','801-140-3618','NULL',98447,47,'Backend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('455 Carberry Street','New York City','New York','enhance frictionless e-services','<EMAIL>','Sandjar','Berdiev','646-423-7060','505-219-4934','NULL',10170,66,'Frontend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('4251 Fremont Point','Oklahoma City','Oklahoma','morph customized networks','<EMAIL>','Reimer','Bogdan','405-945-2897','650-287-1783','NULL',73190,404,'Backend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('96224 Esker Junction','Detroit','Michigan','generate dot-com communities','<EMAIL>','Irfan','Dogic','313-360-4942','415-570-0683','NULL',48232,373,'Frontend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('5756 Fairview Pass','Homestead','Florida','synergize dot-com e-commerce','<EMAIL>','Florian','Gumhold','305-707-8564','304-844-6163','NULL',33034,942,'Frontend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('24792 Upham Hill','Port Charlotte','Florida','reintermediate best-of-breed communities','<EMAIL>','Bernhard','Haring','941-219-3640','251-975-5774','NULL',33954,702,'Backend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('6 Fremont Court','New York City','New York','transform user-centric portals','<EMAIL>','Christian','Hofer','212-362-5391','305-287-2449','NULL',10125,2,'Database');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('04168 <NAME>','Athens','Georgia','recontextualize cutting-edge systems','<EMAIL>','Robert','Ionescu','706-105-0028','210-821-1608','NULL',30605,57700,'Frontend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('4968 Gale Plaza','Portland','Oregon','facilitate visionary applications','<EMAIL>','Roitinger','Michael','971-101-9581','571-673-1192','NULL',97255,16510,'Frontend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('277 Schiller Point','Springfield','Massachusetts','envisioneer B2C eyeballs','<EMAIL>','Stefan','Moder','413-258-7335','404-327-0613','NULL',1129,55,'Database');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('62 3rd Point','Springfield','Illinois','exploit e-business users','<EMAIL>','Nevzad','Mujic','217-473-3977','626-319-8097','NULL',62764,402,'Database');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('67342 Jenifer Junction','<NAME>','Minnesota','grow customized e-services','<EMAIL>','Matthias','Pointinger','612-562-1953','260-478-7944','NULL',55108,85,'Backend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('40 Muir Place','Washington','District of Columbia','brand back-end initiatives','<EMAIL>','Kerstin','Rampler','202-932-5620','419-996-7799','NULL',20260,0,'Backend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('66 Union Avenue','Sacramento','California','empower granular deliverables','<EMAIL>','Björn','Sattler','916-564-0938','508-114-0343','NULL',94230,4,'Frontend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('<NAME>','Fresno','California','engineer web-enabled e-business','<EMAIL>','Alexander','Schug','559-424-6981','713-475-7731','NULL',93704,28102,'Backend');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('84 <NAME>','New York City','New York','exploit dot-com infrastructures','<EMAIL>','Josef','Steppan','917-471-8907','312-103-7161','NULL',10034,684,'Database');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('08379 Lien Court','Mobile','Alabama','grow efficient markets','<EMAIL>','Philipp ','Trummer','251-836-5478','571-407-2356','NULL',36616,4498,'Database');
insert into userprofile (address, city, country, description, email, firstname, lastname, mobile, phone, picture, plz, room, team) values ('48260 Dapin Place','Round Rock','Texas','harness proactive supply-chains','<EMAIL>','Philip','Fuchsbichler','512-383-9062','218-153-0582','NULL',78682,9569,'Database');
{'fraction_non_alphanumeric': 0.1738435788192331, 'fraction_numerical': 0.08787279367011565, 'mean_word_length': 8.898343373493976, 'pattern_counts': {'":': 0, '<': 46, '<?xml version=': 0, '>': 46, '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': '2981922', 'n_tokens_mistral': 4862, 'n_tokens_neox': 4046, 'n_words': 1061}