Setup a simple database

setup.sql

DROP DATABASE IF EXISTS twitter_test;
CREATE DATABASE twitter_test;

USE twitter_test;

DROP TABLE IF EXISTS follwers;
CREATE TABLE followers (
	id varchar(16),
	screen_name VARCHAR(32),
	name VARCHAR(32),
	url VARCHAR(128),
	followers INT,
	following INT
);

DROP TABLE IF EXISTS location;
CREATE TABLE location (
	id varchar(16),
	location VARCHAR(64)
);

GRANT USAGE ON twitter_tester.* TO 'twitter_tester'@'localhost' IDENTIFIED BY 'password';
DROP USER 'twitter_tester'@'localhost';
# ^^ hacky way to support DROP USER IF EXISTS type functionality

CREATE USER 'twitter_tester'@'localhost' IDENTIFIED BY 'JURjdJErOtLEg';
# no need to get all excited about the password, it is just a random string only used for this

GRANT ALL ON twitter_test.* TO twitter_tester;

FLUSH PRIVILEGES;