<commit_before>-- drop table statements go here
DROP TABLE IS EXISTS
DROP TABLE IS EXISTS
DROP TABLE IS EXISTS
DROP TABLE IS EXISTS

CREATE TABLE profile
(
	profileId INT UNSIGNED AUTO_INCREMENT NOT NULL,
	profileUserName VARCHAR(32) NOT NULL,
	profileEmail VARCHAR(128) NOT NULL,
	profileHash VARCHAR(32) NOT NULL,
	profileSalt VARCHAR(32) NOT NULL,
	profileActivation VARCHAR(32) NOT NULL,
	UNIQUE (profileUserName),
	UNIQUE (profileEmail),
	INDEX (profileUserName),
	INDEX (profileEmail),
	INDEX (profileHash),
	INDEX (profileSalt),
	INDEX (profileActivation),
	PRIMARY KEY (profileId)
);

CREATE TABLE dispensary
(
	dispensaryId INT UNSIGNED AUTO_INCREMENT NOT NULL,
	dispensaryName VARCHAR(32) NOT NULL,
	dispensaryAttention VARCHAR(32) NOT NULL,
	dispensaryStreet1 VARCHAR(32) NOT NULL,
	dispensaryStreet2 VARCHAR(32) NOT NULL,
	dispensaryCity VARCHAR(32) NOT NULL,
	dispensaryState VARCHAR(32),
	dispensaryZipCode VARCHAR(32) NOT NULL,
	dispensaryEmail VARCHAR(128) NOT NULL,
	dispensaryPhone VARCHAR(32) NOT NULL,
	dispensaryUrl VARCHAR(128)
	INDEX (dispensaryName),
	INDEX (dispensaryAttention),
	INDEX (dispensaryStreet1),
	INDEX (dispensaryStreet2),
	INDEX (dispensaryCity),
	INDEX (dispensaryState),
	INDEX (dispensaryZipCode),
	INDEX (dispensaryEmail),
	INDEX (dispensaryPhone),
	INDEX (dispensaryUrl),
	PRIMARY KEY (dispensaryId)
);

CREATE TABLE strain
(
	strainId INT UNSIGNED AUTO_INCREMENT NOT NULL,
	strainName VARCHAR(32) NOT NULL,
	strainDescription VARCHAR(128) NOT NULL,
	strainType VARCHAR(32) NOT NULL,
	strainThc VARCHAR(32) NOT NULL,
	strainCbd VARCHAR(32),
	INDEX (strainName),
	INDEX (strainDescription),
	INDEX (strainType),
	INDEX (strainThc),
	INDEX (strainCbd),
	PRIMARY KEY (strainId)
);

CREATE TABLE dispensaryreview
(
	dispensaryReviewId INT UNSIGNED NOT NULL,
	dispensaryReviewProfileId INT UNSIGNED NOT NULL,
	dispensaryReviewDispensaryId INT UNSIGNED NOT NULL,
	dispensaryReviewDateTime INT INSIGNED NOT NULL,
	dispensaryReviewTxt VARCHAR(256) NOT NULL,
	INDEX (dispensaryReviewProfileId),
	INDEX (dispensaryReviewDispensaryId),
	INDEX (dispensaryReviewDateTime),
	INDEX (dispensaryReviewTxt),
	FOREIGN KEY (dispensaryReviewProfileId) REFERENCES profile (profileId),
	FOREIGN KEY (dispensaryReviewDispensaryId) REFERENCES dispensary (dispensaryId),
	PRIMARY KEY (dispensaryReviewDispensaryId, dispensaryReviewProfileId)
);

CREATE TABLE dispensaryleafrating
(
	dispensaryLeafRatingDispensaryId INT UNSIGNED NOT NULL,
	dispensaryLeafRatingProfileId INT UNSIGNED NOT NULL,
	dispensaryLeafRatingRating INT UNSIGNED NOT NULL,
	INDEX (dispensaryLeafRatingDispensaryId),
	INDEX (dispensaryLeafRatingProfileId),
	FOREIGN KEY (dispensaryLeafRatingProfileId) REFERENCES profile (profileId),
	FOREIGN KEY (dispensaryLeafRatingRating) REFERENCES dispensary (dispensaryId),
	PRIMARY KEY (dispensaryLeafRatingProfileId, dispensaryRatingDispensaryId)
);

CREATE TABLE dispensaryfavorite
(
	dispensaryProfileId INT UNSIGNED NOT NULL,
	dispensaryFavoriteDispensaryId INT UNSIGNED NOT NULL,
	-- do we need to index anything here?
	FOREIGN KEY (dispensaryLeafRatingProfileId) REFERENCES profile (profileId),
	FOREIGN KEY (dispensaryLeafRatingRating) REFERENCES rating (r),
	PRIMARY KEY (dispensaryLeafRatingProfileId, dispensaryRatingRating)
);

CREATE TABLE strainleafrating
(

)<commit_msg>finished drop statements in data-design<commit_after>-- drop table statements go here
DROP TABLE IF EXISTS strainfavorite;
DROP TABLE IF EXISTS strainleafrating;
DROP TABLE IF EXISTS strainreview;
DROP TABLE IF EXISTS dispensaryfavorite;
DROP TABLE IF EXISTS dispensaryleafrating;
DROP TABLE IF EXISTS dispensaryreview;
DROP TABLE IF EXISTS strain;
DROP TABLE IF EXISTS dispensary;
DROP TABLE IF EXISTS profile;

CREATE TABLE profile
(
	profileId INT UNSIGNED AUTO_INCREMENT NOT NULL,
	profileUserName VARCHAR(32) NOT NULL,
	profileEmail VARCHAR(128) NOT NULL,
	profileHash VARCHAR(32) NOT NULL,
	profileSalt VARCHAR(32) NOT NULL,
	profileActivation VARCHAR(32) NOT NULL,
	UNIQUE (profileUserName),
	UNIQUE (profileEmail),
	INDEX (profileUserName),
	INDEX (profileEmail),
	INDEX (profileHash),
	INDEX (profileSalt),
	INDEX (profileActivation),
	PRIMARY KEY (profileId)
);

CREATE TABLE dispensary
(
	dispensaryId INT UNSIGNED AUTO_INCREMENT NOT NULL,
	dispensaryName VARCHAR(32) NOT NULL,
	dispensaryAttention VARCHAR(32) NOT NULL,
	dispensaryStreet1 VARCHAR(32) NOT NULL,
	dispensaryStreet2 VARCHAR(32) NOT NULL,
	dispensaryCity VARCHAR(32) NOT NULL,
	dispensaryState VARCHAR(32),
	dispensaryZipCode VARCHAR(32) NOT NULL,
	dispensaryEmail VARCHAR(128) NOT NULL,
	dispensaryPhone VARCHAR(32) NOT NULL,
	dispensaryUrl VARCHAR(128)
	INDEX (dispensaryName),
	INDEX (dispensaryAttention),
	INDEX (dispensaryStreet1),
	INDEX (dispensaryStreet2),
	INDEX (dispensaryCity),
	INDEX (dispensaryState),
	INDEX (dispensaryZipCode),
	INDEX (dispensaryEmail),
	INDEX (dispensaryPhone),
	INDEX (dispensaryUrl),
	PRIMARY KEY (dispensaryId)
);

CREATE TABLE strain
(
	strainId INT UNSIGNED AUTO_INCREMENT NOT NULL,
	strainName VARCHAR(32) NOT NULL,
	strainDescription VARCHAR(128) NOT NULL,
	strainType VARCHAR(32) NOT NULL,
	strainThc VARCHAR(32) NOT NULL,
	strainCbd VARCHAR(32),
	INDEX (strainName),
	INDEX (strainDescription),
	INDEX (strainType),
	INDEX (strainThc),
	INDEX (strainCbd),
	PRIMARY KEY (strainId)
);

CREATE TABLE dispensaryreview
(
	dispensaryReviewId INT UNSIGNED NOT NULL,
	dispensaryReviewProfileId INT UNSIGNED NOT NULL,
	dispensaryReviewDispensaryId INT UNSIGNED NOT NULL,
	dispensaryReviewDateTime INT INSIGNED NOT NULL,
	dispensaryReviewTxt VARCHAR(256) NOT NULL,
	INDEX (dispensaryReviewProfileId),
	INDEX (dispensaryReviewDispensaryId),
	INDEX (dispensaryReviewDateTime),
	INDEX (dispensaryReviewTxt),
	FOREIGN KEY (dispensaryReviewProfileId) REFERENCES profile (profileId),
	FOREIGN KEY (dispensaryReviewDispensaryId) REFERENCES dispensary (dispensaryId),
	PRIMARY KEY (dispensaryReviewDispensaryId, dispensaryReviewProfileId)
);

CREATE TABLE dispensaryleafrating
(
	dispensaryLeafRatingDispensaryId INT UNSIGNED NOT NULL,
	dispensaryLeafRatingProfileId INT UNSIGNED NOT NULL,
	dispensaryLeafRatingRating INT UNSIGNED NOT NULL,
	INDEX (dispensaryLeafRatingDispensaryId),
	INDEX (dispensaryLeafRatingProfileId),
	FOREIGN KEY (dispensaryLeafRatingProfileId) REFERENCES profile (profileId),
	FOREIGN KEY (dispensaryLeafRatingRating) REFERENCES dispensary (dispensaryId),
	PRIMARY KEY (dispensaryLeafRatingProfileId, dispensaryRatingDispensaryId)
);

CREATE TABLE dispensaryfavorite
(
	dispensaryProfileId INT UNSIGNED NOT NULL,
	dispensaryFavoriteDispensaryId INT UNSIGNED NOT NULL,
	-- do we need to index anything here?
	FOREIGN KEY (dispensaryLeafRatingProfileId) REFERENCES profile (profileId),
	FOREIGN KEY (dispensaryLeafRatingRating) REFERENCES rating (ratingId),
	PRIMARY KEY (dispensaryLeafRatingProfileId, dispensaryRatingRating)
);

CREATE TABLE strainreview
(
	strainReviewId INT UNSIGNED NOT NULL,
	strainReviewProfileId INT UNSIGNED NOT NULL,
);

CREATE TABLE strainleafrating
(

);

	CREATE TABLE strainfavorite
{'fraction_non_alphanumeric': 0.06779180258119416, 'fraction_numerical': 0.014466033186782017, 'mean_word_length': 7.143187066974596, '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': '3994989', 'n_tokens_mistral': 2549, 'n_tokens_neox': 2295, 'n_words': 657}