<commit_before>create table project (
	id integer not null auto_increment primary key,
	title varchar(1000), 
	description longtext character set utf8,
	votes integer,
	create_dt datetime not null,
	fk_created_by integer not null,
	fk_parent_id integer 
	-- fk_userid integer not null, 
	-- foreign key (fk_userid) references user(id)
);

create table user (
	id integer not null auto_increment primary key, 
	username varchar(25), 
	password varchar(25),
	unique( username )
);

create table vote (
	id integer not null auto_increment primary key, 
	fk_user_id int not null, 
	fk_project_id int not null
);

-- create table tag (
--	id integer not null auto_increment primary key,
--	name varchar(1000) not null,
--	fk_postid integer not null,
--	foreign key (fk_postid) references post(id)
-- );

-- create table ref (
--	id integer not null auto_increment primary key,
--	fk_fromid integer not null,
--	fk_toid integer not null,
--	foreign key (fk_fromid) references atom(id),
--	foreign key (fk_toid) references atom(id)
-- );<commit_msg>cleaning up database schema<commit_after>create table project (
	id integer not null auto_increment primary key,
	title varchar(1000), 
	description longtext character set utf8,
	votes integer,
	create_dt datetime not null,
	fk_created_by integer not null,
	fk_parent_id integer,
	foreign key (fk_created_by) references user(id)
);

create table user (
	id integer not null auto_increment primary key, 
	username varchar(25), 
	password varchar(25),
	unique( username )
);

create table vote (
	id integer not null auto_increment primary key, 
	fk_user_id int not null, 
	fk_project_id int not null
);

{'fraction_non_alphanumeric': 0.07846715328467153, 'fraction_numerical': 0.01338199513381995, 'mean_word_length': 4.375816993464053, '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': '282619', 'n_tokens_mistral': 565, 'n_tokens_neox': 528, 'n_words': 194}