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

CREATE TABLE brewery (
	breweryId INT UNSIGNED AUTO_INCREMENT NOT NULL,
	breweryDescription VARCHAR(1000),
	breweryEstDate VARCHAR(150),
	breweryHours VARCHAR(250),
	breweryName VARCHAR(100) NOT NULL,
	breweryLocation VARCHAR (250),
	breweryPhone VARCHAR(14),
	breweryUrl VARCHAR(100),
	INDEX(breweryName),
	PRIMARY KEY(breweryId)
);

CREATE TABLE user (
	userId  INT UNSIGNED AUTO_INCREMENT NOT NULL,
	userBreweryId  INT UNSIGNED NOT NULL,
	userAccessLevel  TINYINT UNSIGNED NOT NULL, -- or could be char with a letter
	userActivationToken  CHAR(32), -- because this is a hash it is char not int
	userDateOfBirth  DATE NOT NULL,

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

