#1170 - BLOB/TEXT column 'variable' used in key specification without a key length
The column is OK, but the UNIQUE constraint requires an index that is too big.
Some other things are wrong:  Surely there can be more than one place in a state?  Yet the UNIQUE constraint says that there can be only one row for each state.
Remove UNIQUE from any column definition that is not truly unique.
Also, I strongly recommend you use InnoDB, not MyISAM.
PRIMARY KEY is a Unique Index.
UNIQUE is an index and a uniqueness constraint.
INDEX is a way to access data faster.  But until you have the SELECTs, you may not know which columns (or combination of columns) should be indexed.