1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
/*
Navicat Premium Data Transfer
Source Server : vsdn-192.168.200.24
Source Server Type : MySQL
Source Server Version : 100136
Source Host : 192.168.200.24:3306
Source Schema : soooner_hotel
Target Server Type : MySQL
Target Server Version : 100136
File Encoding : 65001
Date: 20/06/2019 11:13:21
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for sh_media_hotel
-- ----------------------------
DROP TABLE IF EXISTS `sh_media_hotel`;
CREATE TABLE `sh_media_hotel` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`code` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '媒资唯一标识',
`title` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '媒资名称',
`description` varchar(0) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '媒资描述',
`url_play` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '云存储地址',
`url_pic` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '海报图片地址',
`year` int(11) NOT NULL COMMENT '年份',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`type` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '类型：电影，电视剧，新闻，综艺等',
`score` decimal(2,1) NOT NULL DEFAULT '0.0' COMMENT '评分',
`region` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '国家/地区：内地，港台',
`actor` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '演员',
`director` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '导演',
`_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '上下线状态（wasu）：1上线，2下线',
`_starttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '入库时间（wasu）',
`_updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间（wasu）',
PRIMARY KEY (`id`),
KEY `idx` (`code`,`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='云端片库表';
SET FOREIGN_KEY_CHECKS = 1;