<commit_before>//Assumes the existence of a 'Banana' Keyspace

CREATE TABLE IF NOT EXISTS Banana.Users
(
	user_id uuid,
	first_name text,
	middle_name text,
	last_name text,
	emails set<text>,
	organizations set<uuid>,
	roles set<text>,
	gender text,
	birthdate timestamp,
	profile_image_id uuid,
	github_profile text,

	PRIMARY KEY (user_id)
);

CREATE INDEX IF NOT EXISTS Banana.Users_By_Last_Name_Index ON Banana.Users (last_name);
CREATE INDEX IF NOT EXISTS Banana.Users_By_First_Name_Index ON Banana.Users (first_name);
CREATE INDEX IF NOT EXISTS Banana.Users_By_Roles_Index ON Banana.Users (roles);

CREATE TABLE IF NOT EXISTS  Banana.Users_By_Github_Profile
(
	github_profile text,
	user_id uuid,
	first_name text,
	middle_name text,
	last_name text,
	email text,

	PRIMARY KEY (github_profile)
);<commit_msg>Updating User.Github table to include only a single email<commit_after>//Assumes the existence of a 'Banana' Keyspace

CREATE TABLE IF NOT EXISTS Banana.Users
(
	user_id uuid,
	first_name text,
	middle_name text,
	last_name text,
	emails set<text>,
	organizations set<uuid>,
	roles set<text>,
	gender text,
	birthdate timestamp,
	profile_image_id uuid,
	github_profile text,

	PRIMARY KEY (user_id)
);

CREATE INDEX IF NOT EXISTS Banana.Users_By_Last_Name_Index ON Banana.Users (last_name);
CREATE INDEX IF NOT EXISTS Banana.Users_By_First_Name_Index ON Banana.Users (first_name);
CREATE INDEX IF NOT EXISTS Banana.Users_By_Roles_Index ON Banana.Users (roles);

CREATE TABLE IF NOT EXISTS  Banana.Users_By_Github_Profile
(
	github_profile text,
	user_id uuid,
	first_name text,
	middle_name text,
	last_name text,
	//This is the email associated with the GitHub account
	email text,

	PRIMARY KEY (github_profile)
);
{'fraction_non_alphanumeric': 0.06755196304849885, 'fraction_numerical': 0.0, 'mean_word_length': 5.4185185185185185, 'pattern_counts': {'":': 0, '<': 9, '<?xml version=': 0, '>': 9, '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': '4936719', 'n_tokens_mistral': 628, 'n_tokens_neox': 608, 'n_words': 189}