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

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

--
-- 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,
  `aboutMeHeader` varchar(200) DEFAULT NULL,
  `aboutMeDesc` varchar(2000) DEFAULT NULL,
  `channelName` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `highway` (`id`, `tabtitle`, `headerlogo`, `homemainheader`, `homeparagraph`, `homesubparagraph`, `videoLocation`, `aboutMeHeader`, `aboutMeDesc`, `channelName`) VALUES
(1, 'This is tab stuff', 'Portfolio', 'David Tarver', 'This is a short thing about my page.', 'This page is super awesome', 'test.mp4', 'Hi, I am David Tarver, nice to meet you!', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Velit sed ullamcorper morbi tincidunt ornare. Id cursus metus aliquam eleifend mi. Nibh mauris cursus mattis molestie a iaculis at erat. Lobortis feugiat vivamus at augue eget arcu dictum varius. Massa ultricies mi quis hendrerit. Facilisi morbi tempus iaculis urna id volutpat lacus laoreet. Neque egestas congue quisque egestas diam. At quis risus sed vulputate odio ut enim blandit volutpat. Netus et malesuada fames ac turpis. Quis commodo odio aenean sed. A cras semper auctor neque vitae tempus. Mauris pharetra et ultrices neque ornare aenean euismod. Fusce ut placerat orci nulla. Hac habitasse platea dictumst quisque. Cursus in hac habitasse platea dictumst quisque sagittis purus sit. Diam vulputate ut pharetra sit amet aliquam id. Erat pellentesque adipiscing commodo elit at.', 'David Tarver'),
(6, NULL, NULL, 'Change Me Here', NULL, NULL, NULL, NULL, NULL, 'Hit Snooze');

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

--
-- 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(500) 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
(1, 'TarverCoin', 'The future coin of the world is TarverCoin. Buy it now. Become an investor!', 'This coin was created as a test and a joke. The coin is the future of meme currency. I highly suggest you buy the car for no reason. Because that is funny. So don\'t be stupid be retarded.', 'mtn.jpg'),
(2, 'John', 'Doe', 'john@example.com', 'mtn.jpg'),
(3, 'John', 'Doe', 'john@example.com', 'mtn.jpg'),
(4, 'John', 'Doe', 'john@example.com', 'mtn.jpg'),
(5, 'John', 'Doe', 'john@example.com', 'mtn.jpg'),
(6, 'John', 'Doe', 'john@example.com', 'phototest3.jpg'),
(7, 'test name', 'about my test', 'even more about my test', 'phototest4.jpg'),
(8, 'jyfgjhgfjhgf', 'somethingsometyhiunilyfghrfc', 'kjhfru5yuypi[0puhkughukfmnbvkuybuiykh;lnuiyno oluiyiuy', 'phototest5.jpg');

--
-- 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=7;

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