-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 13, 2012 at 03:19 AM
-- Server version: 5.1.52
-- PHP Version: 5.3.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `poll`
--

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

--
-- Table structure for table `options`
--

CREATE TABLE IF NOT EXISTS `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=28 ;

--
-- Dumping data for table `options`
--

INSERT INTO `options` (`id`, `ques_id`, `value`) VALUES
(1, 1, 'Bit.ly'),
(2, 1, 'TinyURL'),
(3, 1, 'is.gd'),
(4, 1, 'tr.im'),
(5, 1, 'Other'),
(6, 2, 'Finding leaders to manage teams, activities, events or ministry partners'),
(7, 2, 'Determining what all the volunteer needs are on an ongoing basis'),
(8, 2, 'Communicating those opportunities to your members'),
(9, 2, 'Recruiting and taking registrations'),
(10, 2, 'Making sure those who registered come (e.g. cancellations and replacements)'),
(11, 3, 'You communicating your needs to church staff'),
(12, 3, 'Church staff communicating your needs to their members'),
(13, 4, 'Rallying involvement by churches and ministries'),
(14, 4, 'Identifying leaders to manage various aspects of the event'),
(15, 4, 'Recruiting and managing volunteers'),
(16, 4, 'Garnering city and media support'),
(17, 4, 'Fostering a spirit of cooperation and unity'),
(18, 5, 'Coordinating with leaders of participating organizations'),
(19, 5, 'Preventing duplication'),
(20, 5, 'Recruiting volunteers'),
(21, 5, 'Managing distribution'),
(22, 5, 'Tracking and measuring success'),
(23, 6, 'Spreadsheets '),
(24, 6, 'Custom database we built'),
(25, 6, 'A government-mandated system'),
(26, 6, 'A system we purchased, but not many others use it'),
(27, 6, 'A system we bought, and many other local charities use it');

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

--
-- Table structure for table `questions`
--

CREATE TABLE IF NOT EXISTS `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=7 ;

--
-- Dumping data for table `questions`
--

INSERT INTO `questions` (`id`, `ques`, `created_on`) VALUES
(1, 'Which URL Shortening service you use most?', '2009-10-13 07:42:18'),
(2, 'Which is the most challenging aspect of managing and mobilizing volunteers to serve?', '2012-03-09 19:37:53'),
(3, 'Which is the bigger impediment to getting local church members involved in serving at your ministry?', '2012-03-09 20:25:30'),
(4, 'Which is the most challenging aspect of organizing an event with multiple churches or\nministries?', '2012-07-13 00:00:00'),
(5, 'Which is the most challenging aspect of running a charity drive?', '2012-07-13 02:07:38'),
(6, 'How are you handling case management today?', '2012-07-13 02:53:51');

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

--
-- Table structure for table `votes`
--

CREATE TABLE IF NOT EXISTS `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 `votes`
--

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
