<commit_before><commit_msg>Created sql for barkparkz https://app.asana.com/0/334403035277159/334711703625844<commit_after>DROP TABLE IF EXISTS 'profile';
DROP TABLE IF EXISTS 'dog';
DROP TABLE IF EXISTS 'friend';
DROP TABLE IF EXISTS 'park';
DROP TABLE IF EXISTS 'checkIn';
DROP TABLE IF EXISTS 'favorite';

-- The profile entity
CREATE TABLE profile (
 -- This creates the attribute for the primary key.
 -- Auto_increment tells mySQL to number them {1, 2, 3, etc}
 -- Not null means the attribute is required!
	profileId INT UNSIGNED AUTO_INCREMENT NOT NULL,
	-- ^Primary Key^
	profileActivationToken VARCHAR(32) NOT NULL,
	profileAtHandle VARCHAR(32) NOT NULL,
	profileEmail VARCHAR(64) NOT NULL,
	profileHash CHAR(128) NOT NULL,
	profileSalt CHAR(64) NOT NULL,
	profileLocationX DECIMAL(3,9) NOT NULL,
	profileLocationY DECIMAL(3,9) NOT NULL,
	UNIQUE(profileEmail),
	UNIQUE(profileAtHandle),
	PRIMARY KEY(profileId)
);

 -- The dog entity
{'fraction_non_alphanumeric': 0.09341825902335456, 'fraction_numerical': 0.05201698513800425, 'mean_word_length': 5.123376623376624, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 1, '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': '6147620', 'n_tokens_mistral': 350, 'n_tokens_neox': 308, 'n_words': 108}