create database voting;

use voting;

create table candidates (
	id int not null,  
	name varchar(100),
	email varchar(200),
	bio varchar(5000),
	primary key (id)
	);

create table voters (
	id int not null,  
	name varchar(100),
	email varchar(200),
	class varchar(200),
	notes varchar(5000),  
	primary key (id)
	);

create table vote_results (
	voter_id int not null, 
	candidate_id int not null,
	primary key (voter_id, candidate_id)
	);

create table vote_request (
	voter_id int not null, 
	request_time int,
	request_ip varchar(100),
	primary key (voter_id, request_time, request_ip)
	);

create table vote_tracking (
	voter_id int not null, 
	vote_time int,
	vote_ip varchar(100),
	primary key (voter_id, vote_time, vote_ip)
	);

insert into candidates values(1, "John Smith", 'jsmith@example.com', 'None');
insert into candidates values(2, "Adam Smith", 'asmith@example.com', 'None');
insert into candidates values(3, "Michael Smith", 'msmith@example.com', 'None');

insert into voters values(1, 'Test user', 'yuonlamp@yahoo.com', NULL, NULL);