jMZnVkXh

1-- phpMyAdmin SQL Dump
2-- version 4.5.4.1deb2ubuntu2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Nov 24, 2016 at 10:54 AM
7-- Server version: 5.7.16-0ubuntu0.16.04.1
8-- PHP Version: 7.0.8-0ubuntu0.16.04.3
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: `video_player`
21--
22CREATE DATABASE IF NOT EXISTS `video_player` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
23USE `video_player`;
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `film`
29--
30
31CREATE TABLE `film` (
32  `id` int(11) NOT NULL,
33  `user_id` int(11) NOT NULL,
34  `type` enum('kaland','Akció') COLLATE utf8_unicode_ci DEFAULT NULL,
35  `url` blob NOT NULL,
36  `time` varchar(100) COLLATE utf8_unicode_ci NOT NULL
37) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
38
39-- --------------------------------------------------------
40
41--
42-- Table structure for table `users`
43--
44
45CREATE TABLE `users` (
46  `id` int(11) NOT NULL,
47  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
48  `pw` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
49  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL
50) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
51
52--
53-- Indexes for dumped tables
54--
55
56--
57-- Indexes for table `film`
58--
59ALTER TABLE `film`
60  ADD PRIMARY KEY (`id`);
61
62--
63-- Indexes for table `users`
64--
65ALTER TABLE `users`
66  ADD PRIMARY KEY (`id`);
67
68--
69-- AUTO_INCREMENT for dumped tables
70--
71
72--
73-- AUTO_INCREMENT for table `film`
74--
75ALTER TABLE `film`
76  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
77--
78-- AUTO_INCREMENT for table `users`
79--
80ALTER TABLE `users`
81  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
82/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
83/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
84/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;