-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jan 02, 2013 at 03:30 AM
-- Server version: 5.1.44
-- PHP Version: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `SO_Join_Question`
--

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

--
-- Table structure for table `emails`
--

CREATE TABLE IF NOT EXISTS `emails` (
  `user_id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `emails`
--

INSERT INTO `emails` (`user_id`, `email`) VALUES
(1, '[email protected]'),
(2, '[email protected]'),
(3, '[email protected]'),
(4, '[email protected]');

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

--
-- Table structure for table `messages`
--

CREATE TABLE IF NOT EXISTS `messages` (
  `user_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` (`user_id`, `title`, `date`) VALUES
(1, 'alice message 1', '2013-01-01 14:05:09'),
(2, 'bob message 1', '2013-01-01 14:05:28'),
(2, 'bob message 2', '2013-01-02 14:05:40'),
(2, 'bob message 3', '2013-01-02 14:05:52'),
(3, 'carol message 1', '2013-01-02 14:06:04'),
(3, 'carol message 2', '2013-01-02 14:06:14'),
(4, 'dave message 1', '2013-01-02 14:06:27'),
(4, 'dave message 2', '2013-01-02 14:06:36'),
(4, 'dave message 3', '2013-01-02 14:06:44'),
(1, 'alice message 1', '2013-01-01 14:05:09'),
(2, 'bob message 1', '2013-01-01 14:05:28'),
(2, 'bob message 2', '2013-01-02 14:05:40'),
(2, 'bob message 3', '2013-01-02 14:05:52'),
(3, 'carol message 1', '2013-01-02 14:06:04'),
(3, 'carol message 2', '2013-01-02 14:06:14'),
(4, 'dave message 1', '2013-01-02 14:06:27'),
(4, 'dave message 2', '2013-01-02 14:06:36'),
(4, 'dave message 3', '2013-01-02 14:06:44');

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`) VALUES
(1, 'Alice'),
(2, 'Bob'),
(3, 'Carol'),
(4, 'Dave');