<commit_before><commit_msg>database init queries<commit_after>drop table Users;
drop table Group;
drop table User_In_Group;
drop table Rules;

create table Users
(
	uId int NOT NULL AUTO_INCREMENT,
	Username varchar(32) NOT NULL,
	Phone varchar(32) NOT NULL,
	CONSTRAINT pk_uId PRIMARY KEY (uId)
);

create table Groups
(
	gId int NOT NULL AUTO_INCREMENT,
	pId int,
	rId int,
	Groupname varchar(64) NOT NULL,
	Description varchar(256),
	Password varchar(32) NOT NULL,
	CONSTRAINT pk_gId PRIMARY KEY (gId)
);

create table User_In_Group
(
	gId int NOT NULL,
	uId int NOT NULL,
	isAdmin bit NOT NULL,
	CONSTRAINT pk_uId_gId PRIMARY KEY (uId, gId)
);

create table Rules
(
	rId int NOT NULL AUTO_INCREMENT,
	Filename varchar(64) NOT NULL,
	CONSTRAINT pk_rId PRIMARY KEY (rId)
);
{'fraction_non_alphanumeric': 0.07354838709677419, 'fraction_numerical': 0.016774193548387096, 'mean_word_length': 4.969230769230769, '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': '6152942', 'n_tokens_mistral': 313, 'n_tokens_neox': 290, 'n_words': 100}