es-demo/db_live.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50729
 Source Host           : localhost:3306
 Source Schema         : db_live

 Target Server Type    : MySQL
 Target Server Version : 50729
 File Encoding         : 65001

 Date: 15/04/2022 10:14:49
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_media
-- ----------------------------
DROP TABLE IF EXISTS `tb_media`;
CREATE TABLE `tb_media` (
  `id` bigint(20) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `md5` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `rtsp` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `amr` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `thumg` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `m3u8` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `sources` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `codec` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `rate` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `audio_codec` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `type` int(4) NOT NULL,
  `base_url` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `created` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Table structure for tb_test
-- ----------------------------
DROP TABLE IF EXISTS `tb_test`;
CREATE TABLE `tb_test` (
  `id` bigint(20) NOT NULL,
  `content` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `path` varchar(512) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `id` bigint(20) NOT NULL,
  `operate` varchar(64) COLLATE utf8mb4_bin NOT NULL,
  `operate_time` bigint(20) NOT NULL,
  `operate_id` bigint(20) NOT NULL,
  `operate_ip` varchar(20) COLLATE utf8mb4_bin NOT NULL,
  `update_operate` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
  `update_operate_time` bigint(20) DEFAULT NULL,
  `update_operate_id` bigint(20) DEFAULT NULL,
  `update_operate_ip` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
  `name` varchar(64) COLLATE utf8mb4_bin NOT NULL,
  `salt` varchar(8) COLLATE utf8mb4_bin NOT NULL,
  `account` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `password` varchar(128) COLLATE utf8mb4_bin NOT NULL,
  `phone` varchar(11) COLLATE utf8mb4_bin NOT NULL,
  `avator` varchar(256) COLLATE utf8mb4_bin NOT NULL,
  `status` int(2) NOT NULL DEFAULT '0',
  `email` varchar(64) COLLATE utf8mb4_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `account-unique` (`account`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

SET FOREIGN_KEY_CHECKS = 1;