-- phpMyAdmin SQL Dump
-- version 4.0.10.14
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Sep 19, 2016 at 12:28 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_kodiak`
--

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

--
-- 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(20) NOT NULL DEFAULT '',
  `registration_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `level` varchar(10) NOT NULL DEFAULT '',
  `first_name` varchar(30) NOT NULL DEFAULT '',
  `last_name` varchar(30) NOT NULL DEFAULT '',
  `email` varchar(40) NOT NULL DEFAULT '',
  `phone` varchar(15) NOT NULL DEFAULT '',
  `address` varchar(40) NOT NULL DEFAULT '',
  `city` varchar(30) NOT NULL DEFAULT '',
  `state` char(2) NOT NULL DEFAULT '',
  `zip` varchar(5) NOT NULL DEFAULT '',
  `partnership_name` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

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

INSERT INTO `users` (`id`, `username`, `password`, `registration_date`, `level`, `first_name`, `last_name`, `email`, `phone`, `address`, `city`, `state`, `zip`, `partnership_name`) VALUES
(1, 'josh', 'tmiva', '2007-04-20 11:53:10', 'employee', 'Josh', 'West', 'josh@tmiva.com', '555-555-5555', 'Address', 'City', 'VA', '22203', 'Partnership Name'),
(2, 'admin', 'ursus', '0000-00-00 00:00:00', 'admin', '-', '-', '', '', '', '', '', '', ''),
(5, 'TheDuke', 'theduke', '2007-04-24 14:22:20', 'LP', 'John', 'Wayne', '', '', '', '', '', '', ''),
(6, 'LP Investor', 'password', '2007-04-24 14:32:27', 'LP', 'Firstname', 'Lastname', '', '', '', '', '', '', ''),
(7, 'employee', 'employee', '2007-04-25 12:30:10', 'employee', 'Employee #5', '', '', '', '', '', '', '', ''),
(13, 'username', 'password', '2007-04-25 12:39:07', 'LP', 'Bob', 'Glockenspiel', '', '', '', '', '', '', ''),
(23, 'newaccount', 'password', '2007-04-25 13:54:38', 'LP', 'Amy', 'Wong', '', '', '', '', '', '', ''),
(24, 'dkennealy', 'Rachel111', '2007-04-25 15:14:58', 'employee', 'Dawn', 'Kennealy', 'dkennealy@harboram.com', '703-875-8364', '', '', '', '', ''),
(25, 'cdo', 'password', '2007-06-05 16:10:40', 'CDO', 'CDO', '', '', '', '', '', '', '', ''),
(26, 'rhurley', 'bob123', '2007-07-23 17:41:47', 'CDO', 'Robert', 'Hurley', 'rhurley@harboram.com', '703-875-7622', '', '', '', '', '');

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