-- phpMyAdmin SQL Dump
-- version 4.8.4
-- https://www.phpmyadmin.net/
--
-- 主机： 127.0.0.1:3306
-- 生成日期： 2020-07-01 08:01:24
-- 服务器版本： 5.7.24
-- PHP 版本： 7.2.14

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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 */;

--
-- 数据库： `interactive_video`
--

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

--
-- 表的结构 `active_code`
--

DROP TABLE IF EXISTS `active_code`;
CREATE TABLE IF NOT EXISTS `active_code` (
  `active_code` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `data` date DEFAULT NULL,
  `is_active` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- 表的结构 `vp_id`
--

DROP TABLE IF EXISTS `vp_id`;
CREATE TABLE IF NOT EXISTS `vp_id` (
  `video_id` int(200) UNSIGNED NOT NULL AUTO_INCREMENT,
  `video_name` text,
  `video_type` text,
  `user_name` text,
  `video_url` text,
  `video_view` int(11) UNSIGNED DEFAULT NULL,
  `video_updata` datetime DEFAULT NULL,
  `video_img` text NOT NULL,
  PRIMARY KEY (`video_id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `vp_id`
--

INSERT INTO `vp_id` (`video_id`, `video_name`, `video_type`, `user_name`, `video_url`, `video_view`, `video_updata`, `video_img`) VALUES
(13, '测试2', '测试视频', 'test', '\n                    <div class=\"branch position-relative\" src=\"../release/user/test/测试2/video/20200619040631序列01.mp4\" name=\"20200619040631序列01.mp4\" id=\"head-branch\" data-question=\"是否继续学习\" data-answer1=\"当然\" data-answer2=\"undefined\" data-answer3=\"undefined\" data-answer4=\"undefined\">\n                        <div class=\"branch-content\">\n                            <div class=\"img-wrapper\">\n                                <video class=\"video_img\" src=\"../release/user/test/测试2/video/20200619040631序列01.mp4\" id=\"video_main\" name=\"20200619040631序列01.mp4\" style=\"width:100%; height:100%; object-fit: fill\">\n                                </video>\n                                <img class=\"video_img\" src=\"\" alt=\"\">\n                                <span class=\"head-text\" style=\"        background-color: #4c68ef;\">片头</span>\n                                <span class=\"icon icon-jia\"><i class=\"iconfont icon-jia1\"></i></span>\n                                <img src=\"images/editor.svg\" alt=\"\" class=\"img-fliud icon-edit\" data-toggle=\"modal\" data-target=\"#modal-edit\">\n                                <img src=\"images/fold.svg\" alt=\"\" class=\"img-fluid position-absolute icon-fold d-block\" style=\"top: 56%;right: 0;transform: rotate(45deg);z-index: 99;\">\n                                <img src=\"images/open.svg\" alt=\"\" class=\"img-fluid position-absolute d-none icon-open\" style=\"top: 56%;right: 0;transform: rotate(45deg);z-index: 99;\">\n                            </div>\n                            <p class=\"text\">序列01</p>\n                        </div>\n                    \n                                                                \n                                                                \n                                                                <div class=\"branch position-absolute\" src=\"upload/user/video/test/测试2/20200619040631温妮.mp4\" style=\"bottom:0px;left:233px\" data-question=\"\" data-answer1=\"\" data-answer2=\"\" data-answer3=\"\" data-answer4=\"\" name=\"20200619040631温妮.mp4\" id=\"video_1\">\n                                                                        <div class=\"branch-content\">\n                                                                            <div class=\"img-wrapper\">\n                                                                                <video class=\"video_img\" id=\"video_1\" src=\"../release/user/test/测试2/video/20200619040631温妮.mp4\" name=\"20200619040631温妮.mp4\" style=\"width:100%; height:100%; object-fit: fill\">\n                                                                                </video>\n                                                                                <img class=\"video_img\" src=\"\" alt=\"\">\n                                                                                <span class=\"icon icon-jia\"><i class=\"iconfont icon-jia1\"></i></span>\n                                                                                <img src=\"images/del.svg\" alt=\"\" class=\"img-fluid position-absolute icon-del\" style=\"top: 5%;right: 5%;\">\n                                                                                <img src=\"images/editor.svg\" alt=\"\" class=\"img-fliud icon-edit d-none\" data-toggle=\"modal\" data-target=\"#modal-edit\">\n                                                            <img src=\"images/fold.svg\" alt=\"\" class=\"img-fluid position-absolute d-none icon-fold\" style=\"top: 56%;right: 0;transform: rotate(45deg);z-index: 99;\">\n                                                            <img src=\"images/open.svg\" alt=\"\" class=\"img-fluid position-absolute d-none icon-open\" style=\"top: 56%;right: 0;transform: rotate(45deg);z-index: 99;\">\n                                                                            </div>\n                                                                            <p class=\"text\">温妮</p>\n                                                                            <div class=\"line position-absolute\" style=\"transform: rotate(0deg); top: 50%;\"></div>\n                                                                        </div>\n                                                                    </div>\n                                                                </div>\n                ', 0, NULL, '../release/user/test/测试2/img.png'),
(12, '幼升小demo', '测试视频', 'test', '\n                    <div class=\"branch position-relative\" src=\"../release/user/test/幼升小demo/video/20200619120639温妮.mp4\" name=\"20200619120639温妮.mp4\" id=\"head-branch\" data-question=\"是否继续学习\" data-answer1=\"当然\" data-answer2=\"undefined\" data-answer3=\"undefined\" data-answer4=\"undefined\">\n                        <div class=\"branch-content\">\n                            <div class=\"img-wrapper\">\n                                <video class=\"video_img\" src=\"../release/user/test/幼升小demo/video/20200619120639温妮.mp4\" id=\"video_main\" name=\"20200619120639温妮.mp4\" style=\"width:100%; height:100%; object-fit: fill\">\n                                </video>\n                                <img class=\"video_img\" src=\"\" alt=\"\">\n                                <span class=\"head-text\" style=\"        background-color: #4c68ef;\">片头</span>\n                                <span class=\"icon icon-jia\"><i class=\"iconfont icon-jia1\"></i></span>\n                                <img src=\"images/editor.svg\" alt=\"\" class=\"img-fliud icon-edit\" data-toggle=\"modal\" data-target=\"#modal-edit\">\n                                <img src=\"images/fold.svg\" alt=\"\" class=\"img-fluid position-absolute icon-fold d-block\" style=\"top: 56%;right: 0;transform: rotate(45deg);z-index: 99;\">\n                                <img src=\"images/open.svg\" alt=\"\" class=\"img-fluid position-absolute d-none icon-open\" style=\"top: 56%;right: 0;transform: rotate(45deg);z-index: 99;\">\n                            </div>\n                            <p class=\"text\">温妮</p>\n                        </div>\n                    \n                                                                <div class=\"branch position-absolute\" src=\"upload/user/video/test/幼升小demo/20200619120638序列01.mp4\" style=\"bottom:0px;left:233px\" data-question=\"\" data-answer1=\"\" data-answer2=\"\" data-answer3=\"\" data-answer4=\"\" name=\"20200619120638序列01.mp4\" id=\"video_1\">\n                                                                        <div class=\"branch-content\">\n                                                                            <div class=\"img-wrapper\">\n                                                                                <video class=\"video_img\" id=\"video_1\" src=\"../release/user/test/幼升小demo/video/20200619120638序列01.mp4\" name=\"20200619120638序列01.mp4\" style=\"width:100%; height:100%; object-fit: fill\">\n                                                                                </video>\n                                                                                <img class=\"video_img\" src=\"\" alt=\"\">\n                                                                                <span class=\"icon icon-jia\"><i class=\"iconfont icon-jia1\"></i></span>\n                                                                                <img src=\"images/del.svg\" alt=\"\" class=\"img-fluid position-absolute icon-del\" style=\"top: 5%;right: 5%;\">\n                                                                                <img src=\"images/editor.svg\" alt=\"\" class=\"img-fliud icon-edit d-none\" data-toggle=\"modal\" data-target=\"#modal-edit\">\n                                                            <img src=\"images/fold.svg\" alt=\"\" class=\"img-fluid position-absolute d-none icon-fold\" style=\"top: 56%;right: 0;transform: rotate(45deg);z-index: 99;\">\n                                                            <img src=\"images/open.svg\" alt=\"\" class=\"img-fluid position-absolute d-none icon-open\" style=\"top: 56%;right: 0;transform: rotate(45deg);z-index: 99;\">\n                                                                            </div>\n                                                                            <p class=\"text\">序列01</p>\n                                                                            <div class=\"line position-absolute\" style=\"transform: rotate(0deg); top: 50%;\"></div>\n                                                                        </div>\n                                                                    </div>\n                                                                </div>\n                ', 0, NULL, '../release/user/test/幼升小demo/img.png'),
(11, '乘方教育', '测试视频', 'test', '\n                    <div class=\"branch position-relative\" src=\"../release/user/test/乘方教育/video/20200619120648温妮.mp4\" name=\"20200619120648温妮.mp4\" id=\"head-branch\" data-question=\"是否继续学习\" data-answer1=\"\" data-answer2=\"\" data-answer3=\"\" data-answer4=\"\">\n                        <div class=\"branch-content\">\n                            <div class=\"img-wrapper\">\n                                <video class=\"video_img\" src=\"../release/user/test/乘方教育/video/20200619120648温妮.mp4\" id=\"video_main\" name=\"20200619120648温妮.mp4\" style=\"width:100%; height:100%; object-fit: fill\">\n                                </video>\n                                <img class=\"video_img\" src=\"\" alt=\"\">\n                                <span class=\"head-text\" style=\"        background-color: #4c68ef;\">片头</span>\n                                <span class=\"icon icon-jia\"><i class=\"iconfont icon-jia1\"></i></span>\n                                <img src=\"images/editor.svg\" alt=\"\" class=\"img-fliud icon-edit\" data-toggle=\"modal\" data-target=\"#modal-edit\">\n                                <img src=\"images/fold.svg\" alt=\"\" class=\"img-fluid position-absolute icon-fold d-block\" style=\"top: 56%;right: 0;transform: rotate(45deg);z-index: 99;\">\n                                <img src=\"images/open.svg\" alt=\"\" class=\"img-fluid position-absolute d-none icon-open\" style=\"top: 56%;right: 0;transform: rotate(45deg);z-index: 99;\">\n                            </div>\n                            <p class=\"text\">温妮</p>\n                        </div>\n                    \n                                                                <div class=\"branch position-absolute\" src=\"upload/user/video/test/乘方教育/20200619120650序列01.mp4\" style=\"bottom:0px;left:233px\" data-question=\"\" data-answer1=\"\" data-answer2=\"\" data-answer3=\"\" data-answer4=\"\" name=\"20200619120650序列01.mp4\" id=\"video_1\">\n                                                                        <div class=\"branch-content\">\n                                                                            <div class=\"img-wrapper\">\n                                                                                <video class=\"video_img\" id=\"video_1\" src=\"../release/user/test/乘方教育/video/20200619120650序列01.mp4\" name=\"20200619120650序列01.mp4\" style=\"width:100%; height:100%; object-fit: fill\">\n                                                                                </video>\n                                                                                <img class=\"video_img\" src=\"\" alt=\"\">\n                                                                                <span class=\"icon icon-jia\"><i class=\"iconfont icon-jia1\"></i></span>\n                                                                                <img src=\"images/del.svg\" alt=\"\" class=\"img-fluid position-absolute icon-del\" style=\"top: 5%;right: 5%;\">\n                                                                                <img src=\"images/editor.svg\" alt=\"\" class=\"img-fliud icon-edit d-none\" data-toggle=\"modal\" data-target=\"#modal-edit\">\n                                                            <img src=\"images/fold.svg\" alt=\"\" class=\"img-fluid position-absolute d-none icon-fold\" style=\"top: 56%;right: 0;transform: rotate(45deg);z-index: 99;\">\n                                                            <img src=\"images/open.svg\" alt=\"\" class=\"img-fluid position-absolute d-none icon-open\" style=\"top: 56%;right: 0;transform: rotate(45deg);z-index: 99;\">\n                                                                            </div>\n                                                                            <p class=\"text\">序列01</p>\n                                                                            <div class=\"line position-absolute\" style=\"transform: rotate(0deg); top: 50%;\"></div>\n                                                                        </div>\n                                                                    </div>\n                                                                </div>\n                ', 0, NULL, '../release/user/test/乘方教育/img.png'),
(14, '吱', '测试视频', 'test', '<div class=\"branch position-relative\" src=\"upload/user/video/test/吱//20200619070647温妮.mp4\" id=\"head-branch\" data-question=\"温妮\" data-answer1=\"yes\" data-answer2=\"undefined\" data-answer3=\"undefined\" data-answer4=\"undefined\" name=\"20200619070647温妮.mp4\">   <div class=\"branch-content\">    <div class=\"img-wrapper\">                                <video class=\"video_img\" src=\"../release/user/test/吱/video/20200619070647温妮.mp4\" name=\"20200619070647温妮.mp4\" style=\"width:100%; height:100%; object-fit: fill\">    </video>   <img class=\"video_img\" src=\"\" alt=\"\">     <span class=\"head-text\" style=\"      background-color: #4c68ef;\">片头</span><span class=\"icon icon-jia\"><i class=\"iconfont icon-jia1\"></i></span>   <img src=\"images/editor.svg\" alt=\"\" class=\"img-fliud icon-edit\" data-toggle=\"modal\" data-target=\"#modal-edit\">  <img src=\"images/fold.svg\" alt=\"\" class=\"img-fluid position-absolute icon-fold d-block\" style=\"top: 56%;right: 0;transform: rotate(45deg);z-index: 99;\">    <img src=\"images/open.svg\" alt=\"\" class=\"img-fluid position-absolute d-none icon-open\" style=\"top: 56%;right: 0;transform: rotate(45deg);z-index: 99;\">   </div>  <p class=\"text\">温妮</p>   </div> \n                                                                <div class=\"branch position-absolute\" src=\"upload/user/video/test/吱//20200619070647序列01.mp4\" style=\"bottom:0px;left:233px\" data-question=\"\" data-answer1=\"\" data-answer2=\"\" data-answer3=\"\" data-answer4=\"\" name=\"20200619070647序列01.mp4\" id=\"video_1\">\n                                                                        <div class=\"branch-content\">\n                                                                            <div class=\"img-wrapper\">\n                                                                                <video class=\"video_img\" id=\"video_1\" src=\"../release/user/test/吱/video/20200619070647序列01.mp4\" name=\"20200619070647序列01.mp4\" style=\"width:100%; height:100%; object-fit: fill\">\n                                                                                </video>\n                                                                                <img class=\"video_img\" src=\"\" alt=\"\">\n                                                                                <span class=\"icon icon-jia\"><i class=\"iconfont icon-jia1\"></i></span>\n                                                                                <img src=\"images/del.svg\" alt=\"\" class=\"img-fluid position-absolute icon-del\" style=\"top: 5%;right: 5%;\">\n                                                                                <img src=\"images/editor.svg\" alt=\"\" class=\"img-fliud icon-edit d-none\" data-toggle=\"modal\" data-target=\"#modal-edit\">\n                                                            <img src=\"images/fold.svg\" alt=\"\" class=\"img-fluid position-absolute d-none icon-fold\" style=\"top: 56%;right: 0;transform: rotate(45deg);z-index: 99;\">\n                                                            <img src=\"images/open.svg\" alt=\"\" class=\"img-fluid position-absolute d-none icon-open\" style=\"top: 56%;right: 0;transform: rotate(45deg);z-index: 99;\">\n                                                                            </div>\n                                                                            <p class=\"text\">序列01</p>\n                                                                            <div class=\"line position-absolute\" style=\"transform: rotate(0deg); top: 50%;\"></div>\n                                                                        </div>\n                                                                    </div>\n                                                                </div>', 0, NULL, '../release/user/test/吱/img.png'),
(15, '测试3', '测试视频', 'test', '\n                    <div class=\"branch position-relative\" src=\"../release/user/test/测试3/video/20200619070609序列01.mp4\" name=\"20200619070609序列01.mp4\" id=\"head-branch\" data-question=\"是否继续学习\" data-answer1=\"yes\" data-answer2=\"undefined\" data-answer3=\"undefined\" data-answer4=\"undefined\">\n                        <div class=\"branch-content\">\n                            <div class=\"img-wrapper\">\n                                <video class=\"video_img\" src=\"../release/user/test/测试3/video/20200619070609序列01.mp4\" id=\"video_main\" name=\"20200619070609序列01.mp4\" style=\"width:100%; height:100%; object-fit: fill\">\n                                </video>\n                                <img class=\"video_img\" src=\"\" alt=\"\">\n                                <span class=\"head-text\" style=\"        background-color: #4c68ef;\">片头</span>\n                                <span class=\"icon icon-jia\"><i class=\"iconfont icon-jia1\"></i></span>\n                                <img src=\"images/editor.svg\" alt=\"\" class=\"img-fliud icon-edit\" data-toggle=\"modal\" data-target=\"#modal-edit\">\n                                <img src=\"images/fold.svg\" alt=\"\" class=\"img-fluid position-absolute icon-fold d-block\" style=\"top: 56%;right: 0;transform: rotate(45deg);z-index: 99;\">\n                                <img src=\"images/open.svg\" alt=\"\" class=\"img-fluid position-absolute d-none icon-open\" style=\"top: 56%;right: 0;transform: rotate(45deg);z-index: 99;\">\n                            </div>\n                            <p class=\"text\">序列01</p>\n                        </div>\n                    \n                                                                <div class=\"branch position-absolute\" src=\"../release/user/test/测试3/video/20200619070609温妮.mp4\" style=\"bottom:0px;left:233px\" data-question=\"\" data-answer1=\"\" data-answer2=\"\" data-answer3=\"\" data-answer4=\"\" name=\"20200619070609温妮.mp4\" id=\"video_1\">\n                                                                        <div class=\"branch-content\">\n                                                                            <div class=\"img-wrapper\">\n                                                                                <video class=\"video_img\" id=\"video_1\" src=\"../release/user/test/测试3/video/20200619070609温妮.mp4\" name=\"20200619070609温妮.mp4\" style=\"width:100%; height:100%; object-fit: fill\">\n                                                                                </video>\n                                                                                <img class=\"video_img\" src=\"\" alt=\"\">\n                                                                                <span class=\"icon icon-jia\"><i class=\"iconfont icon-jia1\"></i></span>\n                                                                                <img src=\"images/del.svg\" alt=\"\" class=\"img-fluid position-absolute icon-del\" style=\"top: 5%;right: 5%;\">\n                                                                                <img src=\"images/editor.svg\" alt=\"\" class=\"img-fliud icon-edit d-none\" data-toggle=\"modal\" data-target=\"#modal-edit\">\n                                                            <img src=\"images/fold.svg\" alt=\"\" class=\"img-fluid position-absolute d-none icon-fold\" style=\"top: 56%;right: 0;transform: rotate(45deg);z-index: 99;\">\n                                                            <img src=\"images/open.svg\" alt=\"\" class=\"img-fluid position-absolute d-none icon-open\" style=\"top: 56%;right: 0;transform: rotate(45deg);z-index: 99;\">\n                                                                            </div>\n                                                                            <p class=\"text\">温妮</p>\n                                                                            <div class=\"line position-absolute\" style=\"transform: rotate(0deg); top: 50%;\"></div>\n                                                                        </div>\n                                                                    </div>\n                                                                </div>\n                ', 0, NULL, '../release/user/test/测试3/img.png');

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

--
-- 表的结构 `vp_test`
--

DROP TABLE IF EXISTS `vp_test`;
CREATE TABLE IF NOT EXISTS `vp_test` (
  `UID` int(200) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_name` text CHARACTER SET utf8mb4,
  `user_password` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_email` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `user_phone` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `user_sex` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_active` int(1) DEFAULT NULL,
  PRIMARY KEY (`UID`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `vp_test`
--

INSERT INTO `vp_test` (`UID`, `user_name`, `user_password`, `user_email`, `user_phone`, `user_sex`, `is_active`) VALUES
(1, '', 'd41d8cd98f00b204e9800998ecf8427e', NULL, NULL, NULL, 1),
(7, 'Yei5', '123456', '<EMAIL>', '158110', NULL, 1),
(5, 'zhou1', '123456', '<EMAIL>', NULL, NULL, 1),
(6, 'test', '123456', '<EMAIL>', '', NULL, 1),
(8, 'Yei586719', '123456', '<EMAIL>', '45576769', NULL, 1),
(20, 'test5', '111111', '<EMAIL>', '1313131133', NULL, NULL),
(16, 'YYY111', '123456789', '<EMAIL>', '12223434031', NULL, 1),
(17, 'test2', '123456', '<EMAIL>', '13345564456', NULL, 1),
(22, 'test7', '111111', '<EMAIL>', '1313313131313', NULL, NULL),
(21, 'test6', '111111', '<EMAIL>', '1313144133', NULL, NULL),
(19, 'test4', '111111', '<EMAIL>', '123123214124', NULL, NULL),
(18, 'test3', '123456', '<EMAIL>', '13307778899', NULL, NULL);
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 */;
