GGAFhBjA

1-- phpMyAdmin SQL Dump
2-- version 4.6.4
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost
6-- Generation Time: Jan 03, 2017 at 06:08 PM
7-- Server version: 5.7.17-log
8-- PHP Version: 7.0.9
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- Database: `suss_utube`
21--
22CREATE DATABASE IF NOT EXISTS `suss_utube` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
23USE `suss_utube`;
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `youtubevideos`
29--
30
31CREATE TABLE `youtubevideos` (
32  `UniqueID` int(11) NOT NULL,
33  `VideoID` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
34  `Title` varchar(128) NOT NULL,
35  `Length` int(10) UNSIGNED NOT NULL
36) ENGINE=MyISAM DEFAULT CHARSET=utf8;
37
38--
39-- Indexes for dumped tables
40--
41
42--
43-- Indexes for table `youtubevideos`
44--
45ALTER TABLE `youtubevideos`
46  ADD PRIMARY KEY (`UniqueID`);
47
48--
49-- AUTO_INCREMENT for dumped tables
50--
51
52--
53-- AUTO_INCREMENT for table `youtubevideos`
54--
55ALTER TABLE `youtubevideos`
56  MODIFY `UniqueID` int(11) NOT NULL AUTO_INCREMENT;
57/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
58/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
59/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;