Create table buildings
(building_id int(2) NOT NULL AUTO_INCREMENT,
building_type_id int(2) NOT NULL,
building_name VARCHAR(50) NOT NULL,
building_lat DOUBLE NOT NULL,
building_long DOUBLE NOT NULL,
building_nickname VARCHAR(15),
building_address VARCHAR(50) NOT NULL,
building_description VARCHAR(1000) NOT NULL,
building_weblink VARCHAR(100) NOT NULL,
building_pic VARCHAR(150) NOT NULL,
PRIMARY KEY (building_id),
UNIQUE (building_name));

Create table admins
(admin_id int(2) NOT NULL AUTO_INCREMENT,
email VARCHAR(30) NOT NULL,
password VARCHAR(15) NOT NULL,
PRIMARY KEY (admin_id),
UNIQUE(email, password));