-- phpMyAdmin SQL Dump
-- version 4.0.10.14
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Sep 19, 2016 at 12:31 PM
-- Server version: 5.6.31
-- PHP Version: 5.6.20

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: `tmiva_wwema`
--

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

--
-- Table structure for table `action_alert`
--

CREATE TABLE IF NOT EXISTS `action_alert` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL DEFAULT '0000-00-00',
  `expiration` date NOT NULL DEFAULT '0000-00-00',
  `headline` varchar(35) NOT NULL DEFAULT '',
  `body` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `action_alert`
--

INSERT INTO `action_alert` (`id`, `date`, `expiration`, `headline`, `body`) VALUES
(1, '0000-00-00', '0000-00-00', 'Congress is about to do something', 'Apparently, congress is going to do something stupid in one week.  You should write your senator and encourage them to do so.  The more stupid things that they do, the better for us!  Yay!'),
(2, '2007-04-09', '0000-00-00', 'Congress is about to do something', 'Apparently, congress is going to do something stupid in one week.  You should write your senator and encourage them to do so.  The more stupid things that they do, the better for us!  Yay!'),
(3, '2006-04-09', '2007-07-26', 'Congress is about to do something', 'Apparently, congress is going to do something stupid in one week.  You should write your senator and encourage them to do so.  The more stupid things that they do, the better for us!  Yay!'),
(4, '2005-02-05', '0000-00-00', 'Congress is about to do something', 'Apparently, congress is going to do something stupid in one week.  You should write your senator and encourage them to do so.  The more stupid things that they do, the better for us!  Yay!');

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

--
-- Table structure for table `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `headline` varchar(35) NOT NULL DEFAULT '',
  `date` date NOT NULL DEFAULT '0000-00-00',
  `body` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `headline`, `date`, `body`) VALUES
(1, 'The first News Item', '2007-04-09', 'Lots of stuff happened today.  Some of it may even be interesting.  Read more if you would like to learn more about it!'),
(2, 'The Second News Item', '2007-04-10', 'This is so new, it hasn''t even happened yet.  Donec vel nulla. Praesent ornare sapien id felis. Donec elementum, urna ut ultrices congue, nisi justo pellentesque justo, sit amet scelerisque mi felis vel odio. Integer laoreet congue tellus. Donec fringilla'),
(3, 'Headline', '2007-04-02', 'Praesent ornare sapien id felis. Donec elementum, urna ut ultrices congue, nisi justo pellentesque justo, sit amet scelerisque mi felis vel odio. Integer laoreet congue tellus. Donec fringilla, odio vel viverra nonummy, lectus justo pulvinar ante, ut ferm'),
(4, 'Even More News!', '2007-02-28', 'Praesent ornare sapien id felis. Donec elementum, urna ut ultrices congue, nisi justo pellentesque justo, sit amet scelerisque mi felis vel odio. Integer laoreet congue tellus. Donec fringilla, odio Praesent ornare sapien id felis. Donec elementum, urna u'),
(5, 'Headline', '2003-04-02', 'Praesent ornare sapien id felis. Donec elementum, urna ut ultrices congue, nisi justo pellentesque justo, sit amet scelerisque mi felis vel odio. Integer laoreet congue tellus. Donec fringilla, odio vel viverra nonummy, lectus justo pulvinar ante, ut ferm'),
(6, 'This is the newest post ever', '2007-06-19', 'This post is so bright and shiny.');

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

--
-- Table structure for table `this_week`
--

CREATE TABLE IF NOT EXISTS `this_week` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL DEFAULT '0000-00-00',
  `headline` varchar(35) NOT NULL DEFAULT '',
  `body` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `this_week`
--

INSERT INTO `this_week` (`id`, `date`, `headline`, `body`) VALUES
(1, '2007-04-12', 'First this week in Washington', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor'),
(2, '2007-04-10', 'Second Week in Washington', ' Week #2: Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute ir'),
(3, '2007-04-10', 'Another Week in Washington', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor'),
(4, '2007-04-02', 'Another Week in Washington', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor');

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

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

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL DEFAULT '',
  `password` varchar(15) NOT NULL DEFAULT '',
  `level` varchar(15) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

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

INSERT INTO `users` (`id`, `username`, `password`, `level`) VALUES
(1, 'tmiva', 'tmiva', 'admin');

/*!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 */;