-- DBTools Manager Professional (Enterprise Edition)
-- Database Dump for: onlineprimary
-- Database Server Version: MySQL 4.1.1147

CREATE DATABASE `onlineprimary`;
-- GO
USE `onlineprimary`;
-- GO


--
-- Dumping Tables
--

--
-- Table: ages
--
CREATE TABLE `ages` 
(
	`id` integer (11) UNSIGNED  NOT NULL AUTO_INCREMENT , 
	`name` varchar (50), 
	`abbr` varchar (20), 
	`sort_order` integer (11), 
	`created_at` timestamp NOT NULL, 
	`updated_at` timestamp NOT NULL,
	PRIMARY KEY (`id`)
) TYPE=InnoDB CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Table: candidates
--
CREATE TABLE `candidates` 
(
	`id` integer (11) NOT NULL AUTO_INCREMENT , 
	`fname` varchar (50), 
	`lname` varchar (50), 
	`party_id` integer (11), 
	`write_in` integer (11) NOT NULL DEFAULT 0, 
	`site_url` text, 
	`photo_url` text, 
	`photo_path` text, 
	`created_at` timestamp NOT NULL, 
	`updated_at` timestamp NOT NULL,
	PRIMARY KEY (`id`)
) TYPE=InnoDB CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Table: d_top_5
--
CREATE TABLE `d_top_5` 
(
	`cname` varchar (100), 
	`votes` bigint (20), 
	`pct` float (13,2)
) TYPE=InnoDB CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Table: ethnicities
--
CREATE TABLE `ethnicities` 
(
	`id` integer (11) NOT NULL AUTO_INCREMENT , 
	`name` varchar (50), 
	`abbr` varchar (50), 
	`sort_order` integer (11), 
	`created_at` timestamp NOT NULL, 
	`updated_at` timestamp NOT NULL,
	PRIMARY KEY (`id`)
) TYPE=InnoDB CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Table: faiths
--
CREATE TABLE `faiths` 
(
	`id` integer (11) NOT NULL AUTO_INCREMENT , 
	`name` varchar (50), 
	`abbr` varchar (50), 
	`sort_order` integer (11), 
	`created_at` timestamp NOT NULL, 
	`updated_at` timestamp NOT NULL,
	PRIMARY KEY (`id`)
) TYPE=InnoDB CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Table: incomes
--
CREATE TABLE `incomes` 
(
	`id` integer (11) UNSIGNED  NOT NULL AUTO_INCREMENT , 
	`NAME` varchar (50), 
	`abbr` varchar (20), 
	`sort_order` integer (11), 
	`created_at` timestamp NOT NULL, 
	`updated_at` timestamp NOT NULL,
	PRIMARY KEY (`id`)
) TYPE=InnoDB CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Table: ip_addrs
--
CREATE TABLE `ip_addrs` 
(
	`id` bigint (20) UNSIGNED  NOT NULL AUTO_INCREMENT , 
	`ip_addr` char (13), 
	`access_time` timestamp NOT NULL,
	PRIMARY KEY (`id`)
) TYPE=InnoDB CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Index: ips
--
ALTER TABLE `db18852_onlineprimary`.`ip_addrs` ADD INDEX `ips` (`ip_addr` );
-- GO

--
-- Table: parties
--
CREATE TABLE `parties` 
(
	`id` integer (11) NOT NULL AUTO_INCREMENT , 
	`name` varchar (50), 
	`abbr` varchar (50), 
	`letter` varchar (50), 
	`site_url` text, 
	`symbol_path` text, 
	`created_at` timestamp NOT NULL, 
	`updated_at` timestamp NOT NULL,
	PRIMARY KEY (`id`)
) TYPE=InnoDB CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Table: regions
--
CREATE TABLE `regions` 
(
	`id` integer (11) NOT NULL AUTO_INCREMENT , 
	`name` varchar (50), 
	`abbr` varchar (50), 
	`sort_order` integer (11), 
	`created_at` timestamp NOT NULL, 
	`updated_at` timestamp NOT NULL,
	PRIMARY KEY (`id`)
) TYPE=InnoDB CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Table: states
--
CREATE TABLE `states` 
(
	`id` integer (11) UNSIGNED  NOT NULL AUTO_INCREMENT , 
	`name` varchar (50), 
	`abbr` char (2), 
	`region_id` integer (11),
	PRIMARY KEY (`id`)
) TYPE=InnoDB CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Table: test
--
CREATE TABLE `test` 
(
	`id` integer (11), 
	`totalstates` varchar (50), 
	`updated_at` timestamp NOT NULL
) TYPE=InnoDB CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Table: votecount
--
CREATE TABLE `votecount` 
(
	`rowid` integer (11) NOT NULL DEFAULT 1, 
	`results_updated_at` datetime NOT NULL, 
	`total_votes` bigint (20), 
	`last_vote_cast_at` datetime
) TYPE=InnoDB CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Table: voters
--
CREATE TABLE `voters` 
(
	`id` char (36) NOT NULL, 
	`eligible` tinyint (4), 
	`registered` tinyint (4), 
	`voted_in_last` tinyint (4), 
	`absentee` tinyint (4), 
	`overseas` tinyint (4), 
	`gender_id` integer (11), 
	`age_id` integer (11), 
	`state_id` integer (11), 
	`ethnicity_id` integer (11), 
	`faith_id` integer (11), 
	`income_id` integer (11), 
	`zip` char (10), 
	`credibility` float (13,5), 
	`created_at` timestamp NOT NULL, 
	`updated_at` timestamp NOT NULL,
	PRIMARY KEY (`id`)
) TYPE=InnoDB CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Table: votes
--
CREATE TABLE `votes` 
(
	`id` bigint (20) UNSIGNED  NOT NULL AUTO_INCREMENT , 
	`voter_id` char (36), 
	`candidate_id` integer (11), 
	`rank` tinyint (4), 
	`ballot` char (1), 
	`credibility` float (13,2) DEFAULT 100.00, 
	`created_at` timestamp NOT NULL,
	PRIMARY KEY (`id`)
) TYPE=InnoDB CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Index: vote_candidates
--
ALTER TABLE `db18852_onlineprimary`.`votes` ADD INDEX `vote_candidates` (`candidate_id` );
-- GO

--
-- Index: vote_voters
--
ALTER TABLE `db18852_onlineprimary`.`votes` ADD INDEX `vote_voters` (`voter_id` );
-- GO

--
-- Index: vote_rank
--
ALTER TABLE `db18852_onlineprimary`.`votes` ADD INDEX `vote_rank` (`rank` );
-- GO

--
-- Table: votes_history
--
CREATE TABLE `votes_history` 
(
	`id` bigint (20) UNSIGNED  NOT NULL AUTO_INCREMENT , 
	`voter_id` char (36), 
	`candidate_id` integer (11), 
	`rank` tinyint (4), 
	`created_at` timestamp NOT NULL,
	PRIMARY KEY (`id`)
) TYPE=InnoDB CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO