-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 21, 2022 at 07:39 PM
-- Server version: 10.4.22-MariaDB
-- PHP Version: 8.0.13

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `highway`
--

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

--
-- Table structure for table `highway`
--

CREATE TABLE `highway` (
  `id` int(50) NOT NULL,
  `tabtitle` varchar(200) DEFAULT NULL,
  `headerlogo` varchar(200) DEFAULT NULL,
  `homemainheader` varchar(200) DEFAULT NULL,
  `homeparagraph` varchar(200) DEFAULT NULL,
  `homesubparagraph` varchar(200) DEFAULT NULL,
  `videoLocation` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `highway`
--

INSERT INTO `highway` (`id`, `tabtitle`, `headerlogo`, `homemainheader`, `homeparagraph`, `homesubparagraph`, `videoLocation`) VALUES
(1, 'Impact Today', 'Make Your Impact', 'Change the World', '“You must be the change', 'you wish to see in the world.\" - Gandhi', 'Deloitte_ Make an impact that matters.mp4');

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(50) NOT NULL,
  `productname` varchar(200) NOT NULL,
  `productdesc` varchar(200) NOT NULL,
  `largeproductdesc` varchar(2000) NOT NULL,
  `picturelocation` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `productname`, `productdesc`, `largeproductdesc`, `picturelocation`) VALUES
(13, 'Carlee Turner Impact Interview with Johnny Waters', 'Listen Now to our Young Leader Interview Johnny Waters', 'By: Carlee Turner\r\nJohnny Waters, a small town business owner operates sixteen production and mining sites in the United States, China, Mexico, and Pakistan. With $12.87 in his checking account, hard work and dedication put into this business he has successfully built CIMBAR. Johnny mentions all through the video about Hardwork being a major part of his company, he quotes “those who work the hardest have the best luck.” His wife and family have supported him through the good and the bad times, with them he has managed to stay up and continue since 1975.', 'Video.MOV'),
(14, 'Sahaj Patel Impact Interview With Phillip Hardy', 'Listen Now to our Young Leader Interview Phillip Hardy', 'as a high school student. Coach Hardy was impacted by athletic trainer to help others. In the classroom not only dors he teacher education he also teaches us critical life skills. ', 'IMG_6670.mov'),
(16, 'Alissa Winters Impact Interview with Beth Payton', 'Listen Now to our Young Leader Interview Beth Payton', 'Beth Payton has truly impacted many lives. Every magnet student at Adairsville has been impacted by her. She is always there for students and she holds them as family. To be honest as one of her students I truly don’t know what I would do without her.', 'payton.mov'),
(17, 'Audrey Roth Impact Interview with Cary Roth', 'Listen Now to our Young Leader Interview Cary Roth', 'By: Audrey Roth\r\nIn this video I am interviewing Cary Roth. Cary is not only a city councilman here in our hometown but he is also my father. Cary is someone who has really impacted my life. Over the years he has taught me to be a better leader in the community and a better person in general.', 'IMG_6669.mov');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `highway`
--
ALTER TABLE `highway`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `highway`
--
ALTER TABLE `highway`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
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 */;
