Untitled

-- phpMyAdmin SQL Dump
-- version 3.2.2.1deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 15, 2010 at 06:29 PM
-- Server version: 5.1.37
-- PHP Version: 5.2.10-2ubuntu6.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `myusavote`
--

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

--
-- Table structure for table `CMS`
--

CREATE TABLE IF NOT EXISTS `CMS` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `handle` varchar(25) NOT NULL,
  `title` text NOT NULL,
  `content` text NOT NULL,
  `PHP` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

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

--
-- Table structure for table `discussion`
--

CREATE TABLE IF NOT EXISTS `discussion` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL,
  `rid` int(11) NOT NULL,
  `name` varchar(25) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `comment` text NOT NULL,
  `time_posted` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

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

CREATE TABLE IF NOT EXISTS `questions` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `title` varchar(25) NOT NULL,
  `question` text NOT NULL,
  `yes` int(255) NOT NULL,
  `no` int(255) NOT NULL,
  `enabled` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

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

--
-- Table structure for table `vote_ips`
--

CREATE TABLE IF NOT EXISTS `vote_ips` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `ip` text NOT NULL,
  `questions` text NOT NULL,
  `banned` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;