 DROP TABLE IF EXISTS state;
 CREATE TABLE state (
 	id         INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT ,
+	-- We'll just use the abbreviations
 	state       VARCHAR(12) NOT NULL
 	-- 12 because RI has the longest name of any state with 12 characters
 	-- we could just as easily make this 2 characters using abbreviation

	city     VARCHAR(50),
	state_id INT REFERENCES state (id),
	zip      INT(7)
);
CREATE TABLE status (
	id    INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT ,
	type  VARCHAR(50)
	-- Krishan suggested adding a count value to have immediate access to how many there are
	-- I'm thinking we might also need time stamps
);

DROP TABLE IF EXISTS transactions;
