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

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

--
-- Table structure for table `testcomments`
--

CREATE TABLE `testcomments` (
  `id` int(11) NOT NULL,
  `user` text DEFAULT NULL,
  `message` text DEFAULT NULL,
  `videoName` text NOT NULL,
  `date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `testcomments`
--

INSERT INTO `testcomments` (`id`, `user`, `message`, `videoName`, `date`) VALUES
(46, 'David Tarver', 'hello', 'Big Buck Bunny Video Test', '2022-02-26 05:02:29');

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

--
-- Table structure for table `videos`
--

CREATE TABLE `videos` (
  `id` int(11) NOT NULL,
  `videoTitle` varchar(40) DEFAULT NULL,
  `uploader` varchar(35) DEFAULT NULL,
  `thumbnailLocation` varchar(200) DEFAULT NULL,
  `videoUploadLocation` varchar(3000) NOT NULL,
  `userProfile` varchar(255) NOT NULL,
  `description` varchar(500) NOT NULL,
  `category` varchar(25) NOT NULL,
  `views` bigint(20) DEFAULT NULL,
  `appointment` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `videos`
--

INSERT INTO `videos` (`id`, `videoTitle`, `uploader`, `thumbnailLocation`, `videoUploadLocation`, `userProfile`, `description`, `category`, `views`, `appointment`) VALUES
(87, 'Big Buck Bunny Video Test', 'David Tarver', 'Big.Buck.Bunny.-.Opening.Screen.png', 'Big_Buck_Bunny_1080_10s_1MB.mp4', './assets/profile/pennywise.jpg', 'This video is a small clip to test and prove the elements of this website is fully working.', 'Art', 7, '2022-02-22'),
(88, 'The Best Montage', 'Hit Snooze', 'ezgif.com-gif-maker.jpg', 'videoplayback.mp4', './assets/profile/avatars-1izkebM3cqeF0hcO-uo8bjQ-t500x500.jpg', '1000 Subscribers. WOW. Thank you guys so much for all the support throughout the lifetime of my channel. Ever since I was a kid I had dreamed of hitting 1000 subscribes, and without you guys this would never have happened. I cant thanks you guys enough. Enjoy.', 'Sports', 265, '2022-02-23'),
(89, 'Snooze Moments #1', 'Hit Snooze', 'ezgif.com-gif-maker.jpg', 'videoplayback (1).mp4', './assets/profile/avatars-1izkebM3cqeF0hcO-uo8bjQ-t500x500.jpg', 'https://discord.gg/KntZ3vMeMt', 'Sports', 379, '2022-02-23'),
(90, 'Those Were the Days', 'Hit Snooze', 'ezgif.com-gif-maker.jpg', 'videoplayback (2).mp4', './assets/profile/avatars-1izkebM3cqeF0hcO-uo8bjQ-t500x500.jpg', 'song:\r\nAarigod - Splendour https://chll.to/4882c276\r\nLife is short. So, it\'s best to cherish the sweet moments we have together. Looking back at these amazing moments in my life it\'s ground breaking to see all these amazing people in my life.', 'Sports', 121, '2022-02-23'),
(91, 'Run Away - [edited by Larz]', 'Hit Snooze', 'ezgif.com-gif-maker.jpg', 'videoplayback (3).mp4', './assets/profile/avatars-1izkebM3cqeF0hcO-uo8bjQ-t500x500.jpg', 'discord - https://discord.gg/dJNGDHe\r\n\r\neditor - https://www.youtube.com/channel/UCobwNNcvMy8DUk9WabNjP5w', 'Sports', 383, '2022-02-23'),
(92, 'Unit 2 Review Imaginary Numbers & Factor', 'Sahaj Patel', 'mqdefault_6s (2).jpg', 'videoplayback (4).mp4', './assets/profile/unnamed.jpg', 't', 'Mathematics', 2, '2022-02-24');

--
-- Indexes for dumped tables
--

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `testcomments`
--
ALTER TABLE `testcomments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

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