-- phpMyAdmin SQL Dump
-- version 3.0.1-rc1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 06, 2009 at 01:13 AM
-- Server version: 5.0.67
-- PHP Version: 5.2.10

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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: `adhocracy`
--

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

--
-- Table structure for table `entries`
--

CREATE TABLE IF NOT EXISTS `entries` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(128) default NULL,
  `body` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `entries`
--

INSERT INTO `entries` (`id`, `title`, `body`) VALUES
(1, 'My first entry', 'yadda yadda yadda');

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

--
-- Table structure for table `initiatives`
--

CREATE TABLE IF NOT EXISTS `initiatives` (
  `initiative_id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `title_url` varchar(255) NOT NULL,
  `description` text,
  `prompt` varchar(255) NOT NULL,
  `item_name` varchar(255) NOT NULL,
  `item_name_plural` varchar(255) NOT NULL,
  `user_votes_allocation` int(11) NOT NULL,
  PRIMARY KEY  (`initiative_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `initiatives`
--

INSERT INTO `initiatives` (`initiative_id`, `title`, `title_url`, `description`, `prompt`, `item_name`, `item_name_plural`, `user_votes_allocation`) VALUES
(1, 'Rename PubSubHubbub', 'rename-pubsubhubbub', 'I can barely pronounce it, and it''s hard to even tyup', 'A better name would be', 'name', 'names', 10),
(2, 'Suggest data for NYC Big Apps', 'suggest-data', 'you know the drill', 'what do you want open', 'data', 'data', 10),
(3, 'Help Me Finish This Project', 'finish-this-project', 'please help me!', 'How can you help me finish this?', 'help', 'help', 10);

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

--
-- Table structure for table `items`
--

CREATE TABLE IF NOT EXISTS `items` (
  `item_id` int(11) NOT NULL auto_increment,
  `initiative_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `title_url` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `votes` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `author` int(11) NOT NULL,
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`item_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `items`
--

INSERT INTO `items` (`item_id`, `initiative_id`, `title`, `title_url`, `description`, `votes`, `status`, `author`, `date`) VALUES
(1, 1, 'Submit Item', '', '', 0, 0, 0, '2009-08-23 02:58:59'),
(2, 1, 'Something useful', '', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. In pretium orci accumsan est convallis ac sodales enim ultricies. Duis aliquam enim vitae sem bibendum at vulputate metus molestie. Nullam consequat, metus id venenatis consequat, velit lorem consequat enim, eget rutrum erat turpis et lectus. Nullam vestibulum lacinia eros, nec rhoncus velit iaculis nec. In hac habitasse platea dictumst. Fusce non mi arcu, id blandit odio. Fusce f', 0, 1, 1, '2009-08-28 02:01:09'),
(3, 2, 'More Usefulness', '', 'velit lorem consequat enim, eget rutrum erat turpis et lectus. Nullam vestibulum lacinia eros, nec rhoncus velit iaculis nec. In hac habitasse platea dictumst. Fusce non mi arcu, id blandit odio. Fusce f', 0, 1, 1, '2009-08-28 02:11:47'),
(4, 2, 'More Usefulness', '', 'velit lorem consequat enim, eget rutrum erat turpis et lectus. Nullam vestibulum lacinia eros, nec rhoncus velit iaculis nec. In hac habitasse platea dictumst. Fusce non mi arcu, id blandit odio. Fusce f', 0, 1, 1, '2009-08-28 02:12:45'),
(5, 2, 'More Usefulness', '', 'velit lorem consequat enim, eget rutrum erat turpis et lectus. Nullam vestibulum lacinia eros, nec rhoncus velit iaculis nec. In hac habitasse platea dictumst. Fusce non mi arcu, id blandit odio. Fusce f', 0, 1, 1, '2009-08-28 02:14:21'),
(6, 2, 'Somethng', '', 'velit lorem consequat enim, eget rutrum erat turpis et lectus. Nullam vestibulum lacinia eros, nec rhoncus velit iaculis nec. In hac habitasse platea dictumst. Fusce non mi arcu, id blandit odio. Fusce f', 0, 1, 1, '2009-08-28 02:17:28'),
(7, 2, 'activity', '', 'velit lorem consequat enim, eget rutrum erat turpis et lectus. Nullam vestibulum lacinia eros, nec rhoncus velit iaculis nec. In hac habitasse platea dictumst. Fusce non mi arcu, id blandit odio. Fusce f', 0, 1, 1, '2009-08-28 02:17:44'),
(8, 2, 'Bamboo Bike Studio', '', 'velit lorem consequat enim, eget rutrum erat turpis et lectus. Nullam vestibulum lacinia eros, nec rhoncus velit iaculis nec. In hac habitasse platea dictumst. Fusce non mi arcu, id blandit odio. Fusce f', 0, 1, 1, '2009-08-28 02:18:47'),
(9, 2, 'The Title', '', 'Here''s my description', 0, 0, 0, '2009-11-06 00:55:59');
