r02U1Pcg

1SET NAMES utf8;
2SET time_zone = '+00:00';
3SET foreign_key_checks = 0;
4SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
5
6CREATE DATABASE `iptv` /*!40100 DEFAULT CHARACTER SET utf8 */;
7USE `iptv`;
8
9DROP TABLE IF EXISTS `redirects`;
10CREATE TABLE `redirects` (
11  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
12  `userId` int(11) NOT NULL,
13  `deviceName` varchar(200) NOT NULL,
14  `devicePassword` varchar(200) NOT NULL,
15  `redirectUrl` varchar(200) NOT NULL,
16  PRIMARY KEY (`id`)
17) ENGINE=InnoDB DEFAULT CHARSET=utf8;
18
19DROP TABLE IF EXISTS `users`;
20CREATE TABLE `users` (
21  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
22  `email` varchar(100) NOT NULL,
23  `password` varchar(100) NOT NULL,
24  PRIMARY KEY (`id`)
25) ENGINE=InnoDB DEFAULT CHARSET=utf8;