<commit_before>-- CREATE DATABASE IF NOT EXISTS users;

USE users;

CREATE TABLE Login(
	email VARCHAR(120) NOT NULL UNIQUE PRIMARY KEY,
	-- Hashed password
	password VARCHAR(100) NOT NULL,
	-- Hashed passphrase
	passphrase VARCHAR(100) NOT NULL
) ENGINE=InnoDB;

-- CREATE TABLE Login_1(
-- 	email VARCHAR(120) NOT NULL UNIQUE PRIMARY KEY,
-- 	-- Hashed password
-- 	password VARCHAR(100) NOT NULL
-- ) ENGINE=InnoDB ;

-- CREATE TABLE Login_2(
-- 	email VARCHAR(120) NOT NULL UNIQUE PRIMARY KEY, 
-- 	-- Hashed passphrase
-- 	passphrase VARCHAR(100) NOT NULL,
-- 	FOREIGN KEY email(email) REFERENCES Login_1(email)
-- 	ON UPDATE CASCADE
-- 	ON DELETE CASCADE
-- )ENGINE=InnoDB;

CREATE TABLE Profile(
	email VARCHAR(120) NOT NULL UNIQUE PRIMARY KEY,
	
	-- Columns for access_tokens
	dropbox BLOB,
	gdrive BLOB,
	
	FOREIGN KEY email(email) REFERENCES Login(email)
	ON UPDATE CASCADE
	ON DELETE CASCADE
)ENGINE=InnoDB;<commit_msg>updated schema. Setting new foreign key dependency<commit_after>-- CREATE DATABASE IF NOT EXISTS users;

USE users;

CREATE TABLE Login(
	email VARCHAR(120) NOT NULL PRIMARY KEY,
	-- Hashed password
	password VARCHAR(100) NOT NULL,
	-- Hashed passphrase
	passphrase VARCHAR(100) NOT NULL
) ENGINE=InnoDB;

-- CREATE TABLE Login_1(
-- 	email VARCHAR(120) NOT NULL PRIMARY KEY,
-- 	-- Hashed password
-- 	password VARCHAR(100) NOT NULL
-- ) ENGINE=InnoDB ;

-- CREATE TABLE Login_2(
-- 	email VARCHAR(120) NOT NULL PRIMARY KEY, 
-- 	-- Hashed passphrase
-- 	passphrase VARCHAR(100) NOT NULL,
-- 	FOREIGN KEY email(email) REFERENCES Login_1(email)
-- 	ON UPDATE CASCADE
-- 	ON DELETE CASCADE
-- )ENGINE=InnoDB;

CREATE TABLE Profile(
	email VARCHAR(120) NOT NULL PRIMARY KEY,
	
	-- Columns for access_tokens
	dropbox BLOB,
	gdrive BLOB,
	
	FOREIGN KEY email(email) REFERENCES Login(email)
	ON UPDATE CASCADE
	ON DELETE CASCADE
)ENGINE=InnoDB;
{'fraction_non_alphanumeric': 0.09791332263242375, 'fraction_numerical': 0.028892455858747994, 'mean_word_length': 3.746192893401015, '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': '3178596', 'n_tokens_mistral': 760, 'n_tokens_neox': 664, 'n_words': 213}