text: -- phpMyAdmin SQL Dump
  -- version 4.8.5
  -- https://www.phpmyadmin.net/
  --
  -- Host: localhost:3306
  -- Generation Time: Jul 18, 2019 at 11:06 AM
  -- Server version: 10.3.16-MariaDB
  -- PHP Version: 7.2.7
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  START TRANSACTION;
  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 utf8mb4 */;
  
  --
  -- Database: `dbart_capstone`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `contact`
  --
  
  CREATE TABLE `contact` (
    `id` int(11) NOT NULL,
    `servicesPageCalculatorQuote` varchar(3000) DEFAULT NULL,
    `companyName` varchar(255) DEFAULT NULL,
    `firstName` varchar(255) NOT NULL,
    `lastName` varchar(255) NOT NULL,
    `email` varchar(255) NOT NULL,
    `phoneNumber` bigint(10) NOT NULL,
    `currentWebsite` varchar(255) DEFAULT NULL,
    `questionsComments` varchar(3000) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `contact`
  --
  
  INSERT INTO `contact` (`id`, `servicesPageCalculatorQuote`, `companyName`, `firstName`, `lastName`, `email`, `phoneNumber`, `currentWebsite`, `questionsComments`) VALUES
  (12, NULL, 'ABC Index', 'Dan Index', 'Bart Index', 'test@email.com', 5556546543, 'www.abc.com', 'haha Index'),
  (13, NULL, 'ABC Co Web Dev Svcs', 'Dan Web Dev Svcs', 'Bart Web Dev Svcs', 'test@email.com', 5556546543, 'www.abc.com', 'haha Web Dev Svcs'),
  (14, NULL, 'ABC Co Login', 'Dan Login', 'Bart Login', 'test@email.com', 5556546543, 'www.abc.com', 'haha Login'),
  (15, 'Number of Pages: 50+ Pages\r\nCopywriting Number of Pages: 16-25 Pages\r\nSEO: 40+ Keywords\r\nResponsive Design: Yes\r\nDatabase Integration: Intermediate\r\nEcommerce Functionality: Intermediate', 'test', 'test', 'tes', 'ttest', 5555555555, 'set', 'test');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `loggedIn`
  --
  
  CREATE TABLE `loggedIn` (
    `id` int(11) NOT NULL,
    `userName` varchar(255) NOT NULL,
    `userPassWord` varchar(1024) NOT NULL,
    `companyName` varchar(255) DEFAULT NULL,
    `firstName` varchar(255) NOT NULL,
    `lastName` varchar(255) NOT NULL,
    `email` varchar(255) NOT NULL,
    `phoneNumber` bigint(10) NOT NULL,
    `currentWebsite` varchar(255) DEFAULT NULL,
    `workProgress` int(1) DEFAULT NULL,
    `mileStone1` varchar(255) NOT NULL,
    `mileStone2` varchar(255) NOT NULL,
    `mileStone3` varchar(255) NOT NULL,
    `mileStone4` varchar(255) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `loggedIn`
  --
  
  -- default password is 12345 for all entries below
  
  INSERT INTO `loggedIn` (`id`, `userName`, `userPassWord`, `companyName`, `firstName`, `lastName`, `email`, `phoneNumber`, `currentWebsite`, `workProgress`, `mileStone1`, `mileStone2`, `mileStone3`, `mileStone4`) VALUES
  (1, 'sample-username1', '$2y$10$yGoClHIrdObKOo/JpJrNMO19InHmY84xw2USsUjJ1CK7pRBxN0yP6', 'The Company', 'Matt', 'Red', 'matt@red.com', 5555555555, ',mattred.com', 2, 'Wireframe Phase', 'Sitemap Phase', 'Build Phase', 'Client Review Phase'),
  (2, 'sample-username2', '$2y$10$yGoClHIrdObKOo/JpJrNMO19InHmY84xw2USsUjJ1CK7pRBxN0yP6', 'McDonalds', 'Ronald', 'McDonald', 'ronald@testtesttest.net', 5556667777, 'mcdonalds.com', 3, 'Eat 100 Burgers', 'Eat 200 Burgers', 'Eat 300 Burgers', 'Eat 400 Burgers'),
  (3, 'sample-username3', '$2y$10$yGoClHIrdObKOo/JpJrNMO19InHmY84xw2USsUjJ1CK7pRBxN0yP6', 'Billy Bob Inc.', 'Billy', 'Bob', 'billybob@billy.net', 1234567890, 'billybob.com', 2, 'Get Client Details', 'Create Logo', 'Review', 'Approve');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `contact`
  --
  ALTER TABLE `contact`
    ADD UNIQUE KEY `id` (`id`);
  
  --
  -- Indexes for table `loggedIn`
  --
  ALTER TABLE `loggedIn`
    ADD UNIQUE KEY `id` (`id`),
    ADD UNIQUE KEY `userName` (`userName`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `contact`
  --
  ALTER TABLE `contact`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
  
  --
  -- AUTO_INCREMENT for table `loggedIn`
  --
  ALTER TABLE `loggedIn`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  COMMIT;
  
  /*!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 */;
  