 CREATE TABLE tag (
 	tagId INT UNSIGNED AUTO_INCREMENT NOT NULL,
 	tagLabel VARCHAR(64) NOT NULL,
-	INDEX (tagLabel),
 	PRIMARY KEY (tagId)
 );
 

CREATE TABLE beer (
   beerId INT UNSIGNED AUTO_INCREMENT NOT NULL,
   beerBreweryId INT UNSIGNED NOT NULL,
   beerAbv DECIMAL(6, 5),
   beerAvailability VARCHAR(100),
   beerAwards VARCHAR(1000),
   beerColor DECIMAL(6, 5),
   beerDescription VARCHAR(2000),
   beerIbu INT(3) UNSIGNED,
   beerName VARCHAR(64) NOT NULL,
	beerStyle VARCHAR (32),
	INDEX(beerBreweryId),
	INDEX(beerIbu),
	INDEX(beerColor),
	INDEX(beerStyle),
	FOREIGN KEY (beerBreweryId) REFERENCES brewery(breweryId),
	PRIMARY KEY(beerId)


CREATE TABLE review (
   reviewId INT UNSIGNED AUTO_INCREMENT NOT NULL,
   reviewBeerId INT UNSIGNED NOT NULL,
   reviewUserId INT UNSIGNED NOT NULL,
	reviewDate TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
   reviewPintRating TINYINT UNSIGNED NOT NULL,
   reviewText VARCHAR(2000),
	INDEX(reviewBeerId),
	INDEX(reviewUserId),
	INDEX(reviewPintRating),
	FOREIGN KEY (reviewBeerId) REFERENCES beer(beerId),
	FOREIGN KEY (reviewUserId) REFERENCES user(userId),
	PRIMARY KEY (reviewId)
);
