<commit_before>DROP DATABASE TutoringScheduler;

CREATE DATABASE IF NOT EXISTS TutoringScheduler;
GRANT ALL PRIVILEGES ON TutoringScheduler.* to 'tUser'@'localhost'
identified by 'tPasswd';
USE TutoringScheduler;

CREATE TABLE IF NOT EXISTS users
(
	numId INT NOT NULL auto_increment,
	primary key (numId),
	firstname varchar(50) NOT NULL,
	lastname varchar(50) NOT NULL,
	email varchar(50) NOT NULL,
	password varchar(1000) NOT NULL,
	accountStatus int(5) NOT NULL,
	subjects varchar(400),
);
CREATE INDEX subject_type ON users (subjects);

CREATE TABLE IF NOT EXISTS appointments
(
	numId INT not null auto_increment,
	primary key (numId),
	datenum DATE(20) NOT NULL,
	appointmenttime TIME(30) NOT NULL,
	subject varchar(200) NOT NULL,
	studentId int(100) NOT NULL,
	tutorId int(100) NOT NULL
);
CREATE INDEX tutor_id ON appointments (tutorId);

<commit_msg>updates the tables to appropriately match data for system<commit_after>DROP DATABASE TutoringScheduler;

CREATE DATABASE IF NOT EXISTS TutoringScheduler;
GRANT ALL PRIVILEGES ON TutoringScheduler.* to 'tUser'@'localhost'
identified by 'tPasswd';
USE TutoringScheduler;

CREATE TABLE IF NOT EXISTS users
(
	numId INT NOT NULL auto_increment,
	primary key (numId),
	firstname varchar(50) NOT NULL,
	lastname varchar(50) NOT NULL,
	email varchar(50) NOT NULL,
	password varchar(1000) NOT NULL,
	accountStatus int(5) NOT NULL,
	classes varchar(400),
);
CREATE INDEX subject_type ON users (classes);

CREATE TABLE IF NOT EXISTS appointments
(
	numId INT not null auto_increment,
	primary key (numId),
	datenum DATE(20) NOT NULL,
	appointmenttime TIME(30) NOT NULL,
	class varchar(15) NOT NULL,
	studentId int(100) NOT NULL,
	tutorId int(100) NOT NULL
);
CREATE INDEX tutor_id ON appointments (tutorId);

CREATE TABLE IF NOT EXISTS classes
(
	numId INT not null auto_increment,
	primary key (numId),
	class varchar(15),
	subject varchar(15),
);
CREATE INDEX subject_name ON classes (subject);


{'fraction_non_alphanumeric': 0.07802874743326489, 'fraction_numerical': 0.029260780287474333, 'mean_word_length': 5.629251700680272, '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': '5848292', 'n_tokens_mistral': 708, 'n_tokens_neox': 631, 'n_words': 238}