
-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 30, 2012 at 09:42 AM
-- Server version: 5.1.57
-- PHP Version: 5.2.17

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `a2549577_poll`
--

-- --------------------------------------------------------

--
-- Table structure for table `poll_options`
--

CREATE TABLE `poll_options` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ques_id` int(11) NOT NULL,
  `value` varchar(300) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `poll_options`
--

INSERT INTO `poll_options` VALUES(1, 1, 'Bit.ly');
INSERT INTO `poll_options` VALUES(2, 1, 'TinyURL');
INSERT INTO `poll_options` VALUES(3, 1, 'is.gd');
INSERT INTO `poll_options` VALUES(4, 1, 'tr.im');
INSERT INTO `poll_options` VALUES(5, 1, 'Other');
INSERT INTO `poll_options` VALUES(6, 2, 'Finding leaders to manage teams, activities, events or ministry partners');
INSERT INTO `poll_options` VALUES(7, 2, 'Determining what all the volunteer needs are on an ongoing basis');
INSERT INTO `poll_options` VALUES(8, 2, 'Communicating those opportunities to your members');
INSERT INTO `poll_options` VALUES(9, 2, 'Recruiting and taking registrations');
INSERT INTO `poll_options` VALUES(10, 2, 'Making sure those who registered come (e.g. cancellations and replacements)');
INSERT INTO `poll_options` VALUES(11, 3, 'You communicating your needs to church staff');
INSERT INTO `poll_options` VALUES(12, 3, 'Church staff communicating your needs to their members');

-- --------------------------------------------------------

--
-- Table structure for table `poll_questions`
--

CREATE TABLE `poll_questions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ques` text NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `poll_questions`
--

INSERT INTO `poll_questions` VALUES(1, 'Which URL Shortening service you use most?', '2009-10-13 07:42:18');
INSERT INTO `poll_questions` VALUES(2, 'Which is the most challenging aspect of managing and mobilizing volunteers to serve?', '2012-03-09 19:37:53');
INSERT INTO `poll_questions` VALUES(3, 'Which is the bigger impediment to getting local church members involved in serving at your ministry?', '2012-03-09 20:25:30');

-- --------------------------------------------------------

--
-- Table structure for table `poll_votes`
--

CREATE TABLE `poll_votes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `option_id` int(11) NOT NULL,
  `voted_on` datetime NOT NULL,
  `ip` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;

--
-- Dumping data for table `poll_votes`
--

INSERT INTO `poll_votes` VALUES(1, 2, '2009-10-14 14:00:55', '');
INSERT INTO `poll_votes` VALUES(2, 1, '2009-10-14 14:01:27', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(3, 1, '2009-10-14 14:02:04', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(4, 1, '2009-10-14 14:02:13', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(5, 3, '2009-10-14 14:02:16', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(6, 4, '2009-10-14 14:02:21', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(7, 3, '2009-10-14 14:02:24', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(8, 1, '2009-10-14 14:02:27', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(9, 2, '2009-10-14 14:02:31', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(10, 5, '2009-10-14 14:02:35', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(11, 1, '2009-10-14 14:02:38', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(12, 2, '2009-10-14 14:02:43', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(13, 1, '2009-10-14 14:02:46', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(14, 1, '2009-10-14 14:02:50', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(15, 1, '2009-10-14 14:05:26', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(16, 1, '2009-10-14 14:05:29', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(17, 4, '2009-10-14 14:05:33', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(18, 2, '2009-10-14 14:05:36', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(19, 1, '2009-10-14 14:05:40', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(20, 3, '2009-10-14 14:05:46', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(21, 2, '2009-10-14 14:05:49', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(22, 2, '2009-10-14 14:21:37', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(23, 1, '2009-10-14 14:21:53', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(24, 5, '2009-10-14 14:21:59', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(25, 1, '2009-10-14 14:35:27', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(26, 1, '2009-10-15 00:42:05', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(27, 3, '2009-10-15 00:49:42', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(28, 2, '2009-10-15 01:22:00', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(29, 2, '2009-10-15 01:24:51', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(30, 1, '2009-10-15 01:37:21', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(31, 1, '2009-10-15 01:38:48', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(32, 1, '2009-10-15 01:41:30', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(33, 1, '2009-10-15 01:42:21', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(34, 1, '2009-10-15 04:53:42', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(35, 3, '2009-10-15 05:09:14', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(36, 2, '2009-10-15 05:10:01', '127.0.0.1');
INSERT INTO `poll_votes` VALUES(37, 1, '2012-03-10 11:20:06', '98.247.118.177');
INSERT INTO `poll_votes` VALUES(38, 11, '2012-03-12 12:31:51', '97.96.146.24');
INSERT INTO `poll_votes` VALUES(39, 6, '2012-03-13 10:00:57', '98.247.118.177');
INSERT INTO `poll_votes` VALUES(40, 12, '2012-03-13 10:01:20', '98.247.118.177');
