DROP TABLE posts;
CREATE TABLE posts(
	postID int(11) unsigned NOT NULL AUTO_INCREMENT,
	postTitle varchar(255) DEFAULT NULL,
	arenaID int,
	userID int,
	postQst text,
	responses int,
	postDate datetime DEFAULT NULL,
	endDate datetime DEFAULT NULL,
	expired int(2),
	score_yes int,
	score_no int,
	hours int,
	days int,
	PRIMARY KEY (postID)
	);
	
	
DROP TABLE scores;
CREATE TABLE scores(
	postID int,
	userID int,
	updated int(2)	
	);
	
DROP TABLE arenas;
CREATE TABLE arenas(
	arenaID int(11) unsigned NOT NULL AUTO_INCREMENT,
	arenaName varchar(255) DEFAULT NULL,
	catagory varchar(255) DEFAULT NULL,
	tags varchar(255) DEFAULT NULL,
	modID int,
	summary text,
	posts int,
	date datetime DEFAULT NULL,	
	PRIMARY KEY (arenaID)
);

INSERT INTO arenas VALUES (1, 'General Posts', 'general', 'general, introduction, first, idea, arena', 1, 'Post introductions here or have general discussions', 0, '2017-05-11 00:00:00');

INSERT INTO arenas VALUES (2, 'News Posts', 'news', 'news, introduction, first, idea, arena', 1, 'Post introductions here or have general discussions', 0, '2017-05-11 00:00:00');

INSERT INTO arenas VALUES (3, 'Political Posts', 'politics', 'politics, introduction, first, idea, arena', 1, 'Post introductions here or have general discussions', 0, '2017-05-11 00:00:00');

INSERT INTO arenas VALUES (4, 'Entertainment Posts', 'entertainment', 'entertainment, introduction, first, idea, arena', 1, 'Post introductions here or have general discussions', 0, '2017-05-11 00:00:00');

INSERT INTO arenas VALUES (5, 'Educational Posts', 'education', 'education, introduction, first, idea, arena', 1, 'Post introductions here or have general discussions', 0, '2017-05-11 00:00:00');

INSERT INTO arenas VALUES (6, 'Cultural Posts', 'culture', 'culture, introduction, first, idea, arena', 1, 'Post introductions here or have general discussions', 0, '2017-05-11 00:00:00');

DROP TABLE tags;
CREATE TABLE tags(
	tagID int(11) unsigned NOT NULL AUTO_INCREMENT,
	tag varchar(255) DEFAULT NULL,
	arenaID int,	
	category varchar(255) DEFAULT NULL,
	PRIMARY KEY (tagID)
	);

DROP TABLE inbox;
CREATE TABLE inbox(
	userID int,
	message text,
	date datetime DEFAULT NULL
	
);

DROP TABLE responses;
CREATE TABLE responses(
	resID int(11) unsigned NOT NULL AUTO_INCREMENT,
	yesnoVal tinyint(1),
	userID int,
	postID int,
	response text,
	report int(2),
	date datetime DEFAULT NULL,
	PRIMARY KEY (resID)
	);
	
DROP TABLE ratings;
CREATE TABLE ratings (
	postID int,
 	resID int,
 	yesnoVal tinyint(1),
 	likes int(10) NOT NULL, 
 	dislikes int(10) NOT NULL,
 	total_votes int(11) NOT NULL
); 

DROP TABLE user_ratings;
CREATE TABLE user_ratings (
 	userID int,
 	resID int,
 	postID int,
 	vote int(2) NOT NULL,
 	yesnoVal int
); 

DROP TABLE temp_user;
CREATE TABLE temp_user (
	userID varchar(255) DEFAULT NULL,
	username varchar(255) DEFAULT NULL,
	fname varchar(255) DEFAULT NULL,
	lname varchar(255) DEFAULT NULL,
	bio varchar(255) DEFAULT NULL,
	password varchar(255) DEFAULT NULL,
	email varchar(255) DEFAULT NULL,
	avatar_path varchar(30), 
	avatar_name varchar(30),
	denarii int,
	timestamp datetime DEFAULT NULL,
	PRIMARY KEY (userID)
	);
	
DROP TABLE users;
CREATE TABLE users (
	userID int(11) unsigned NOT NULL AUTO_INCREMENT,
	username varchar(255) DEFAULT NULL,
	fname varchar(255) DEFAULT NULL,
	lname varchar(255) DEFAULT NULL,
	bio varchar(255) DEFAULT NULL,
	password varchar(255) DEFAULT NULL,
	email varchar(255) DEFAULT NULL,
	avatar_path varchar(30), 
	avatar_name varchar(30),
	denarii int,
	timestamp datetime DEFAULT NULL,
	PRIMARY KEY (userID)
	);
	
INSERT INTO users VALUES (1, 'admin', 'Victoria','Laughlin', 'I created this website. Am I awesome? Not really...', 'crackerJacker423', 'vnlaughlin@vwc.edu', 'avatars/', 'user.png', 1000, '2017-05-11 00:00:00');
INSERT INTO users VALUES (2, 'admin2', 'first','last', 'bio', 'psw', 'email2', 'avatars/', 'user.png', 1000, '0000-00-00 00:00:00');
INSERT INTO users VALUES (3, 'admin3', 'first','last', 'bio', 'psw', 'email3', 'avatars/', 'user.png', 1000, '0000-00-00 00:00:00');
INSERT INTO users VALUES (4, 'admin4', 'first','last', 'bio', 'psw', 'email4', 'avatars/', 'user.png', 1000, '0000-00-00 00:00:00');
INSERT INTO users VALUES (5, 'admin5', 'first','last', 'bio', 'psw', 'email5', 'avatars/', 'user.png', 1000, '0000-00-00 00:00:00');
INSERT INTO users VALUES (6, 'admin6', 'first','last', 'bio', 'psw', 'email6', 'avatars/', 'user.png', 1000, '0000-00-00 00:00:00');
INSERT INTO users VALUES (7, 'admin7', 'first','last', 'bio', 'psw', 'email7', 'avatars/', 'user.png', 1000, '0000-00-00 00:00:00');
INSERT INTO users VALUES (8, 'admin8', 'first','last', 'bio', 'psw', 'email8', 'avatars/', 'user.png', 1000, '0000-00-00 00:00:00');
INSERT INTO users VALUES (9, 'admin9', 'first','last', 'bio', 'psw', 'email9', 'avatars/', 'user.png', 1000, '0000-00-00 00:00:00');
INSERT INTO users VALUES (10, 'admin10', 'first','last', 'bio', 'psw', 'email10', 'avatars/', 'user.png', 1000, '0000-00-00 00:00:00');
INSERT INTO users VALUES (11, 'cs489', 'John','Wang', 'Professor of Computer Science', 'cs489', 'usvwccs@gmail.com', 'avatars/', 'wang.jpg', 1000, '2017-05-11 00:00:00');