c6DHwWzi

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