<commit_before>CREATE TABLE profile (
	profileId BINARY(16) NOT NULL
	profileHandle VARCHAR (32) NOT NULL
	profielEmail VARCHAR (128) NOT NULL
	profilePhone VARCHAR (32)
	profileHash CHAR (128) NOT NULL
	profileSalt CHAR (64) NOT NULL
);
CREATE TABLE post (
	postId BINARY(16) NOT NULL
	postProfileId BINARY (16) NOT NULL
	postTitle VARCHAR (140) NOT NULL
	postContent VARCHAR (60000) NOT NULL
	postDate DATETIME (6) NOT NULL
);

create table comment (
	commentid binary (16) NOT NULL
	commentpostid binary (16) NOT NULL
	commentprofileid binary (16) NOT NULL
	commenttitle varchar (128) NOT NULL
	commentcontent varchar (60000) NOT NULL
	commentdate datetime (6) NOT NULL
	commentcommentid (16)
)


	statement

	insert into profile (profileid)
	values(
	unhel(replace("dc12ace9-3796-4902-931c-722e4f19bfd2"))

	delete from profile where profilehandle;
	where profilehandle like%dolphins%;

	update profilephone
	set profilephone = "+5058883323"
	where profileid = "dc12ace9-3796-4902-931c-722e4f19bfd2"

	select profileemail
	from profile
	where profileemail like "%@cnm%"


	insert into post (posttitle)
	values("the great bambino")

	delete from post where postcontent like "%mastermind%"

	update postdate
	set postdate = "today"

	select posttitle
	from post
	where profilehandle like "superheron"
<commit_msg>add to table statements<commit_after>CREATE TABLE profile (
	profileId BINARY(16) NOT NULL
	profileHandle VARCHAR (32) NOT NULL
	profielEmail VARCHAR (128) NOT NULL
	profilePhone VARCHAR (32)
	profileHash CHAR (128) NOT NULL
	profileSalt CHAR (64) NOT NULL
);
CREATE TABLE post (
	postId BINARY(16) NOT NULL
	postProfileId BINARY (16) NOT NULL
	postTitle VARCHAR (140) NOT NULL
	postContent VARCHAR (60000) NOT NULL
	postDate DATETIME (6) NOT NULL
);

create table comment (
	commentsId binary (16) NOT NULL
	commentsPostid binary (16) NOT NULL
	commentsProfileId binary (16) NOT NULL
	commentsTitle varchar (128) NOT NULL
	commentsContent varchar (60000) NOT NULL
	commentsDate datetime (6) NOT NULL
	commentCommentId (16)
)


	INSERT INTO profile (profileId, profileHandle, profileEmail, profilePhone, profileHash, profileSalt)
	VALUES(
	UNHEX(REPLACE("dc12ace9-3796-4902-931c-722e4f19bfd2","-", "")),
	"@

	delete from profile where profileHandle;
	where profileHandle like%dolphins%;

	update profilephone
	set profilephone = "+5058883323"
	where profileid = "dc12ace9-3796-4902-931c-722e4f19bfd2"

	select profileemail
	from profile
	where profileemail like "%@cnm%"


	insert into post (posttitle)
	values("the great bambino")

	delete from post where postcontent like "%mastermind%"

	update postdate
	set postdate = "today"

	select posttitle
	from post
	where profilehandle like "superheron"

{'fraction_non_alphanumeric': 0.07547864506627393, 'fraction_numerical': 0.07069219440353461, 'mean_word_length': 5.11936936936937, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, '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': '55931', 'n_tokens_mistral': 1015, 'n_tokens_neox': 867, 'n_words': 307}