1795 lines
73 KiB
SQL
1795 lines
73 KiB
SQL
-- MySQL dump 10.13 Distrib 5.6.47, for linux-glibc2.12 (x86_64)
|
||
--
|
||
-- Host: localhost Database: tms_db_s3
|
||
-- ------------------------------------------------------
|
||
-- Server version 5.6.47
|
||
|
||
/*!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 utf8 */;
|
||
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
||
/*!40103 SET TIME_ZONE='+00:00' */;
|
||
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
||
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
||
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
||
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
||
|
||
--
|
||
-- Table structure for table `ad_distribute_new`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `ad_distribute_new`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `ad_distribute_new` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`task_id` varchar(50) NOT NULL COMMENT '广告id,由分众系统生成',
|
||
`content_id` bigint(20) NOT NULL COMMENT '广告id',
|
||
`from_type` int(4) NOT NULL COMMENT '广告来源:1、抱抱堂；2、ETMS；3、小程序单片单场(mumu)；4、广告后台单片单场；5：抱抱大屏单片单场 6：分众',
|
||
`file_type` int(4) NOT NULL COMMENT '广告格式',
|
||
`cpl_id` varchar(50) DEFAULT NULL COMMENT 'cpluuid',
|
||
`audit_to_transfer` varchar(50) DEFAULT NULL COMMENT '需要传输的厅',
|
||
`audit_transfer_complete` varchar(500) DEFAULT NULL,
|
||
`distribute_status` tinyint(2) DEFAULT '0' COMMENT '分发至厅状态 0:默认(未分发) 1:正在分发 2:已分发 ',
|
||
`policy_status` tinyint(2) DEFAULT '0' COMMENT '0无策略 1已有策略，开始分发 ',
|
||
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT NULL COMMENT '最后修改时间',
|
||
`file_name` varchar(200) DEFAULT NULL,
|
||
`dcp_name` varchar(200) DEFAULT NULL,
|
||
`duration` int(11) DEFAULT '0' COMMENT '时长',
|
||
`policy_date_start` date DEFAULT NULL COMMENT '策略日期开始',
|
||
`policy_date_end` date DEFAULT NULL COMMENT '策略日期结束',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `unique_cplid` (`cpl_id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `ad_distribute_new`
|
||
--
|
||
|
||
LOCK TABLES `ad_distribute_new` WRITE;
|
||
/*!40000 ALTER TABLE `ad_distribute_new` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `ad_distribute_new` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `ad_download_new`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `ad_download_new`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `ad_download_new` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`dcp_name` varchar(200) DEFAULT NULL COMMENT 'dcpName',
|
||
`content_id` bigint(20) NOT NULL COMMENT '广告内容id',
|
||
`from_type` int(4) NOT NULL COMMENT '广告来源:1、抱抱堂；2、ETMS；3、小程序单片单场(mumu)；4、广告后台单片单场；5：抱抱大屏单片单场 6：分众',
|
||
`content_name` varchar(200) DEFAULT NULL COMMENT 'dcpName',
|
||
`start_date` date DEFAULT NULL COMMENT '创建时间',
|
||
`end_date` date DEFAULT NULL COMMENT '最后修改时间',
|
||
`content_plan_id` bigint(20) NOT NULL COMMENT 'plan_id',
|
||
`task_id` varchar(50) NOT NULL COMMENT '广告id,由分众系统生成',
|
||
`duration` int(11) DEFAULT NULL COMMENT '时长',
|
||
`url` varchar(500) NOT NULL COMMENT '下载地址',
|
||
`url2` varchar(500) DEFAULT NULL COMMENT '下载地址2',
|
||
`file_type` int(4) NOT NULL,
|
||
`uuid` varchar(50) NOT NULL COMMENT '广告片id',
|
||
`file_name` varchar(200) DEFAULT NULL COMMENT 'file_name',
|
||
`download_status` tinyint(2) DEFAULT '0' COMMENT '下载状态：0、未下载 ；1、正在下载 ；2、已下载 ；3、下载失败',
|
||
`distribute_status` tinyint(2) DEFAULT '0' COMMENT '0:默认（未分发） 1：正在分发 2：已分发',
|
||
`error_count` int(4) DEFAULT '0' COMMENT '错误次数 错误10次不再下载',
|
||
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT NULL COMMENT '最后修改时间',
|
||
`download_percent` int(4) DEFAULT '0' COMMENT '下载进度',
|
||
`download_begin` datetime DEFAULT NULL COMMENT '下载开始时间',
|
||
`download_over` datetime DEFAULT NULL COMMENT '下载结束时间',
|
||
`cmc_last_update` datetime DEFAULT NULL COMMENT 'cmc_last_update',
|
||
`report_status` int(4) NOT NULL DEFAULT '0' COMMENT '0 未上报 1 已上报',
|
||
`audit_to_transfer` varchar(50) DEFAULT NULL COMMENT '需要传输的厅',
|
||
`start_flag` int(4) DEFAULT '0' COMMENT '策略是否执行 1已开始',
|
||
`download_pause` int(4) DEFAULT '0' COMMENT '下载暂停计数',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `ad_download_new`
|
||
--
|
||
|
||
LOCK TABLES `ad_download_new` WRITE;
|
||
/*!40000 ALTER TABLE `ad_download_new` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `ad_download_new` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `ad_download_policy`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `ad_download_policy`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `ad_download_policy` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`content_id` int(4) NOT NULL COMMENT '广告id,由广告系统生成',
|
||
`policy_date` date NOT NULL COMMENT '下载策略日期',
|
||
`download_id` int(4) NOT NULL COMMENT '下载ID',
|
||
`subject` varchar(100) NOT NULL COMMENT '广告名',
|
||
`file_type` int(4) NOT NULL COMMENT '广告类型,11:进口宽幅 12:进口遮幅 13:国产宽幅 14:国产遮幅 15:3D宽幅 16:3D遮幅',
|
||
`url` varchar(500) NOT NULL COMMENT '下载地址',
|
||
`md5` varchar(50) DEFAULT NULL COMMENT '广告文件MD5码',
|
||
`download_status` int(4) NOT NULL DEFAULT '0' COMMENT '下载状态,0未下载 1正在下载 2已下载 3下载失败',
|
||
`distribute_audit_nums` varchar(200) DEFAULT NULL COMMENT '分发至厅信息,例如:1,2',
|
||
`is_report` int(4) DEFAULT '0' COMMENT '是否已上报,0:未上报 1:已上报',
|
||
`ad_uuid` varchar(50) NOT NULL COMMENT '广告uuid',
|
||
`image` varchar(200) DEFAULT NULL COMMENT '图片地址',
|
||
`duration` int(11) DEFAULT '0' COMMENT '时长',
|
||
`distribute_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '分发至厅状态 0:默认(未分发) 1:正在分发 2:已分发',
|
||
`file_name` varchar(200) NOT NULL COMMENT '文件名称',
|
||
`error_count` tinyint(4) DEFAULT '0' COMMENT '错误次数',
|
||
`download_percent` tinyint(4) DEFAULT '0' COMMENT '下载进度',
|
||
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
|
||
`ad_position` tinyint(2) DEFAULT '0' COMMENT '广告位置',
|
||
`update_status` tinyint(4) DEFAULT '0' COMMENT '数据更新状态：0：未更新；1：已更新',
|
||
`from_type` tinyint(4) DEFAULT '0' COMMENT '广告来源:1、抱抱堂传媒；2、ETMS；3：MUMU',
|
||
`download_begin` datetime DEFAULT NULL COMMENT '下载开始时间',
|
||
`download_over` datetime DEFAULT NULL COMMENT '下载完成时间',
|
||
`monitor_type` int(4) DEFAULT '0' COMMENT '默认0 ,1、 秒针广告监控',
|
||
`is_patch` tinyint(4) DEFAULT '0' COMMENT '广告类型：0：普通广告；1；贴片广告:2：表白广告；',
|
||
`transfer_audit_nums` varchar(200) DEFAULT NULL COMMENT '传输到哪个厅中',
|
||
`content_plan_id` bigint(20) DEFAULT NULL COMMENT '计划ID',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `ad_download_policy`
|
||
--
|
||
|
||
LOCK TABLES `ad_download_policy` WRITE;
|
||
/*!40000 ALTER TABLE `ad_download_policy` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `ad_download_policy` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `audit_attribute`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `audit_attribute`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `audit_attribute` (
|
||
`id` int(4) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(100) NOT NULL COMMENT '中文名称',
|
||
`tc_name` varchar(100) NOT NULL COMMENT '中文繁体名称',
|
||
`code` varchar(100) DEFAULT NULL COMMENT '编码',
|
||
`refer_code` varchar(50) DEFAULT NULL COMMENT '参照编码（备用）',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='厅或影片属性';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `audit_attribute`
|
||
--
|
||
|
||
LOCK TABLES `audit_attribute` WRITE;
|
||
/*!40000 ALTER TABLE `audit_attribute` DISABLE KEYS */;
|
||
INSERT INTO `audit_attribute` VALUES (1,'普通','普通','COMMON','1'),(2,'DTSX全景声','DTSX全景聲','DTSX','2'),(3,'DOLBY全景声','DOLBY全景聲','DOLBY','3'),(4,'中国巨幕','中國巨幕','DMAX','4'),(5,'IMAX','IMAX','IMAX','6'),(6,'WANOS全景声','WANOS全景声','WANOS','9'),(7,'CINITY','CINITY','CINITY','11'),(8,'4D','4D','4D','18');
|
||
/*!40000 ALTER TABLE `audit_attribute` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `audit_custom_cue`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `audit_custom_cue`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `audit_custom_cue` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`cue_label` varchar(100) NOT NULL DEFAULT '',
|
||
`cue_name` varchar(50) NOT NULL,
|
||
`cue_uuid` varchar(50) NOT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='影厅自定义cue信息表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `audit_custom_cue`
|
||
--
|
||
|
||
LOCK TABLES `audit_custom_cue` WRITE;
|
||
/*!40000 ALTER TABLE `audit_custom_cue` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `audit_custom_cue` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `audit_custom_device`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `audit_custom_device`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `audit_custom_device` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`audit_num` int(11) DEFAULT NULL COMMENT '厅号',
|
||
`name` varchar(30) DEFAULT NULL COMMENT '设备名称',
|
||
`model` varchar(30) DEFAULT NULL COMMENT '设备型号',
|
||
`ip` varchar(30) DEFAULT NULL COMMENT 'IP地址',
|
||
`protocol` int(11) DEFAULT '0' COMMENT '通讯协议 0-TCP,1-UDP',
|
||
`port` int(11) DEFAULT NULL COMMENT '端口号',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='影厅自定义设备信息表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `audit_custom_device`
|
||
--
|
||
|
||
LOCK TABLES `audit_custom_device` WRITE;
|
||
/*!40000 ALTER TABLE `audit_custom_device` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `audit_custom_device` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `audit_custom_instruct`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `audit_custom_instruct`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `audit_custom_instruct` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`device_id` int(11) DEFAULT NULL COMMENT '设备ID',
|
||
`label_id` int(11) DEFAULT NULL COMMENT '标签ID',
|
||
`format` int(11) DEFAULT NULL COMMENT '指令编码格式 0-16进制，1-明文',
|
||
`instruct` text COMMENT '指令编码',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='影厅自定义指令表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `audit_custom_instruct`
|
||
--
|
||
|
||
LOCK TABLES `audit_custom_instruct` WRITE;
|
||
/*!40000 ALTER TABLE `audit_custom_instruct` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `audit_custom_instruct` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `audit_custom_rule`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `audit_custom_rule`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `audit_custom_rule` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`audit_num` int(11) DEFAULT NULL COMMENT '厅号',
|
||
`label_id` int(11) DEFAULT NULL COMMENT '标签ID',
|
||
`logic_point` int(11) DEFAULT NULL COMMENT '逻辑点0-于，1-于当天第一场放映前，2-于当天最后一场放映后，3-于每场放映前，4-于每场放映后，5-于正片放映前，6-于广告放映后',
|
||
`block` int(11) DEFAULT '0' COMMENT '阻断规则 0-无，1-放映中，2-传输中，3-放映和传输中',
|
||
`time` varchar(50) DEFAULT NULL COMMENT '指定时间',
|
||
`offset` int(11) DEFAULT NULL COMMENT '偏移量（秒）',
|
||
`status` int(11) DEFAULT NULL COMMENT '状态0-禁用，1-启用',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='影厅自定义指令规则';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `audit_custom_rule`
|
||
--
|
||
|
||
LOCK TABLES `audit_custom_rule` WRITE;
|
||
/*!40000 ALTER TABLE `audit_custom_rule` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `audit_custom_rule` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `audit_pos`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `audit_pos`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `audit_pos` (
|
||
`audit_num` int(4) NOT NULL,
|
||
`pos_name` varchar(100) DEFAULT NULL,
|
||
`server_offset` varchar(64) DEFAULT NULL COMMENT '服务器偏移量',
|
||
`update_status` int(4) DEFAULT '0' COMMENT '更新状态：0：未更新；1：已更新',
|
||
PRIMARY KEY (`audit_num`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `audit_pos`
|
||
--
|
||
|
||
LOCK TABLES `audit_pos` WRITE;
|
||
/*!40000 ALTER TABLE `audit_pos` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `audit_pos` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `audit_schedule_policy`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `audit_schedule_policy`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `audit_schedule_policy` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`audit_num` int(11) NOT NULL COMMENT '厅号',
|
||
`content_id` bigint(20) NOT NULL COMMENT '广告id,由广告系统生成',
|
||
`rank` int(4) NOT NULL COMMENT '投放权重',
|
||
`content_plan_id` bigint(20) NOT NULL COMMENT '计划ID',
|
||
`policy_date` date NOT NULL COMMENT '策略日期',
|
||
`distribute_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '分发至厅状态,0未下发，1，下发中，2已下发',
|
||
`duration` int(11) NOT NULL DEFAULT '0' COMMENT '时长',
|
||
`is_gold` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否是黄金广告',
|
||
`subject` varchar(100) DEFAULT NULL COMMENT '广告名称',
|
||
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '下刊状态 0未下刊 1已下刊',
|
||
`ad_position` tinyint(2) DEFAULT '0' COMMENT '广告位置',
|
||
`feature_info` text COMMENT '正片信息',
|
||
`sort` tinyint(2) DEFAULT '99' COMMENT '贴片顺序：0：贴片；',
|
||
`policy_date_start` date DEFAULT NULL COMMENT '策略投放起始时间',
|
||
`update_status` tinyint(4) DEFAULT '0' COMMENT '数据更新状态：0：未更新；1：已更新',
|
||
`from_type` tinyint(4) DEFAULT '0' COMMENT '广告来源:1、抱抱堂传媒；2、ETMS；3、MUMU',
|
||
`is_patch` tinyint(4) DEFAULT '0' COMMENT '是否贴片广告：0：普通广告；1：贴片广告:2：表白广告；',
|
||
`schedule_start_time` datetime DEFAULT NULL COMMENT '售票系统排期开始时间',
|
||
`plan_createtime` datetime DEFAULT NULL COMMENT '计划创建时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `audit_schedule_policy`
|
||
--
|
||
|
||
LOCK TABLES `audit_schedule_policy` WRITE;
|
||
/*!40000 ALTER TABLE `audit_schedule_policy` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `audit_schedule_policy` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `audit_schedule_policy_new`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `audit_schedule_policy_new`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `audit_schedule_policy_new` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`contentPlanId` bigint(20) DEFAULT NULL COMMENT '计划id',
|
||
`contentId` bigint(20) DEFAULT NULL COMMENT '广告Id',
|
||
`dcpName` varchar(200) DEFAULT NULL COMMENT 'dcp名称',
|
||
`rank` tinyint(4) DEFAULT '99' COMMENT '非表白广告位序',
|
||
`contentPlanName` varchar(200) DEFAULT NULL COMMENT '计划名称',
|
||
`auditoriumName` varchar(10) DEFAULT NULL COMMENT '影厅',
|
||
`schedulesDate` datetime DEFAULT NULL COMMENT '表白广告场次时间',
|
||
`monitorType` tinyint(4) DEFAULT NULL COMMENT '秒针广告监控开启',
|
||
`duration` int(11) DEFAULT NULL COMMENT '广告时长',
|
||
`fromType` tinyint(4) DEFAULT '0' COMMENT '广告来源:1、抱抱堂；2、ETMS；3、小程序单片单场(mumu)；4、广告后台单片单场；5：抱抱大屏单片单场 6：分众',
|
||
`featureInfo` text COMMENT '正片信息',
|
||
`startTime` date DEFAULT NULL COMMENT '策略开始时间',
|
||
`endTime` date DEFAULT NULL COMMENT '策略结束时间',
|
||
`createTime` datetime DEFAULT NULL COMMENT 'ad平台策略创建时间',
|
||
`updateTime` datetime DEFAULT NULL COMMENT '数据更新时间',
|
||
`policyDataId` bigint(20) DEFAULT '0' COMMENT 'cmc策略主键id',
|
||
`sort` tinyint(4) DEFAULT '0' COMMENT '表白广告位序',
|
||
`isPatch` tinyint(4) DEFAULT '0' COMMENT '广告类型：1：表白广告；2：贴片广告；3：普通广告',
|
||
`filmName` varchar(500) DEFAULT NULL COMMENT '贴片影片名称',
|
||
`filmUuid` text COMMENT '贴片影院uuid',
|
||
`contentInfo` varchar(50) DEFAULT NULL COMMENT '每批广告contentInfo结构的编号',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `audit_schedule_policy_new`
|
||
--
|
||
|
||
LOCK TABLES `audit_schedule_policy_new` WRITE;
|
||
/*!40000 ALTER TABLE `audit_schedule_policy_new` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `audit_schedule_policy_new` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `audit_template`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `audit_template`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `audit_template` (
|
||
`audit_number` tinyint(4) NOT NULL COMMENT '厅号',
|
||
`template_id` varchar(50) NOT NULL COMMENT '模板ID',
|
||
`template_title` varchar(50) DEFAULT NULL COMMENT '模板标题',
|
||
`template_duration` int(11) DEFAULT NULL COMMENT '模板时长',
|
||
`update_status` int(4) DEFAULT '0' COMMENT '厅模板是否有更改：0：未更改；1：更改',
|
||
PRIMARY KEY (`audit_number`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `audit_template`
|
||
--
|
||
|
||
LOCK TABLES `audit_template` WRITE;
|
||
/*!40000 ALTER TABLE `audit_template` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `audit_template` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `auditorium`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `auditorium`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `auditorium` (
|
||
`audit_number` tinyint(4) NOT NULL COMMENT '影厅编号',
|
||
`audit_name` varchar(20) DEFAULT NULL COMMENT '影厅名称',
|
||
`server_type` varchar(20) DEFAULT NULL COMMENT '放映服务器类型',
|
||
`server_ip` varchar(20) DEFAULT NULL COMMENT '放映服务器IP',
|
||
`server_serial` varchar(200) DEFAULT NULL COMMENT '服务器型号',
|
||
`server_public_key` varchar(500) DEFAULT NULL COMMENT '服务器公钥',
|
||
`projector_type` varchar(20) DEFAULT NULL COMMENT '放映机类型',
|
||
`projector_ip` varchar(20) DEFAULT NULL COMMENT '放映机IP',
|
||
`second_projector_ip` varchar(20) DEFAULT NULL COMMENT '第二放映机IP',
|
||
`processor_type` varchar(20) DEFAULT NULL COMMENT '音频解码器类型',
|
||
`processor_ip` varchar(20) DEFAULT NULL COMMENT '音频解码器IP',
|
||
`automatic_type` varchar(20) DEFAULT NULL COMMENT '自动化控制箱类型',
|
||
`automatic_ip` varchar(20) DEFAULT NULL COMMENT '自动化控制箱IP',
|
||
`camera_type` varchar(20) DEFAULT NULL COMMENT '监控类型',
|
||
`camera_address` varchar(100) DEFAULT NULL COMMENT '监控IP',
|
||
`volume_gain` tinyint(4) DEFAULT NULL COMMENT 'fixme',
|
||
`server_login_user` varchar(20) DEFAULT NULL COMMENT '服务器登录用户名',
|
||
`audit_attribute` varchar(200) DEFAULT NULL COMMENT 'fixme',
|
||
`server_login_password` varchar(20) DEFAULT NULL COMMENT '服务器登录密码',
|
||
`seat_number` int(11) DEFAULT '0' COMMENT '座位数',
|
||
`is_cue` tinyint(4) DEFAULT '1',
|
||
`is_trigger` tinyint(4) DEFAULT '0',
|
||
`audit_id` bigint(20) DEFAULT NULL COMMENT '广告系统影厅号',
|
||
`screen_capability` varchar(20) DEFAULT NULL,
|
||
`is_report` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否已上报广告系统',
|
||
`editdate` varchar(50) DEFAULT NULL COMMENT '编辑日期',
|
||
`lamp_open_time` int(4) DEFAULT '0' COMMENT '放映机灯提前量',
|
||
`is_close_projector_light` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否场次结束关闭放映机灯泡',
|
||
`camera_username` varchar(50) DEFAULT NULL COMMENT '摄像头用户名',
|
||
`camera_password` varchar(50) DEFAULT NULL COMMENT '摄像头密码',
|
||
`cancel_transfer` tinyint(4) DEFAULT '0' COMMENT '放映时取消传输：0、不取消；1、取消',
|
||
`is_skipcpl_ad` tinyint(4) DEFAULT '0' COMMENT '是否跳过龙标：0：否；1：是',
|
||
`useKdmModel` tinyint(4) DEFAULT '0' COMMENT '是否开启KDM范例：0：否；1：是',
|
||
`show_initial_value` tinyint(4) DEFAULT '0' COMMENT '是否显示音频原值：0：否；1：是',
|
||
`humiture_sensor_ip` varchar(100) DEFAULT NULL COMMENT '网络传感器端口号',
|
||
`lamp_cool_time` int(5) DEFAULT '-1' COMMENT '灯泡冷却时间',
|
||
`server_support` varchar(2) DEFAULT '0' COMMENT '服务器支持类型',
|
||
`repair_password` varchar(20) DEFAULT NULL COMMENT '服务器维修员密码',
|
||
`remote_type` tinyint(4) DEFAULT '0' COMMENT '远程类型 ：1：VPN 2：web',
|
||
`auto_play_schedule` tinyint(4) DEFAULT '1' COMMENT '自动播放排期 ：0关闭 1开启',
|
||
`processor_lead_time` varchar(20) DEFAULT '0' COMMENT '音量等级提前量 单位秒',
|
||
`sync_schedule` tinyint(4) DEFAULT '0' COMMENT 'tms-服务器同步排期 0-双向通信，1-以tms为基准',
|
||
`can_transfer` tinyint(4) DEFAULT '0' COMMENT '放映时可以向外传输：0：不可以；1：可以',
|
||
`schedule_policy` tinyint(4) DEFAULT '1' COMMENT '投放策略： 0：关闭 1：打开',
|
||
`frequently_sync_schedule` tinyint(4) DEFAULT '0' COMMENT '排期同步高频开关 0-关闭(默认)，1-开启',
|
||
`feature_base` tinyint(4) DEFAULT '0' COMMENT '排期正片放映基准：0：以正片贴片广告开始放映为基准；1：以龙标开始时间为基准',
|
||
`schedule_black` tinyint(4) DEFAULT '1' COMMENT '排期自动加10秒黑帧：0：不加；1：加',
|
||
`schedule_black_count` tinyint(4) DEFAULT '1' COMMENT '排期添加黑帧数量：默认1',
|
||
`close_light_time` tinyint(4) DEFAULT '0' COMMENT '排期结束后场间自动关闭场灯时间',
|
||
`close_light_time_scope` tinyint(4) DEFAULT '0' COMMENT '排期结束后场间自动关闭场灯时间界限',
|
||
`sub_sync` tinyint(4) DEFAULT '0' COMMENT '主副机排期同步配置开关：0：否；1：是',
|
||
`parent_id` tinyint(4) DEFAULT '0' COMMENT '副厅对应的厅号',
|
||
`skip_ad_result` tinyint(4) DEFAULT '0' COMMENT '是否能跳过龙标：0：未填或不能；1：能',
|
||
`lightoff_position` tinyint(4) DEFAULT '1' COMMENT '不跳龙标情况下排期添加关场灯指令位置（1、开：龙标时间位置；0、关：正片贴片位置；默认为开）',
|
||
`is_skipcpl_ad_update_time` datetime DEFAULT NULL COMMENT '跳龙标开关更新时间',
|
||
`spl_multiplex` tinyint(4) DEFAULT '1' COMMENT '播放列表复用：0：不复用；1：复用',
|
||
`schedule_policy_update_time` datetime DEFAULT NULL COMMENT '投放策略更新时间',
|
||
`custom_rule_status` tinyint(4) DEFAULT '1' COMMENT '自定义规则状态0-禁用，1-启用',
|
||
`twin_sync_schedule` tinyint(4) DEFAULT '0' COMMENT '双机同步开关0-禁用，1-启用',
|
||
`open_lamp_cue` varchar(100) DEFAULT NULL COMMENT '打开放映机灯',
|
||
`close_lamp_cue` varchar(100) DEFAULT NULL COMMENT '关闭放映机灯',
|
||
`humiture_sensor_ip_port` varchar(20) DEFAULT NULL COMMENT '网络传感器ip',
|
||
`auto_schedule` tinyint(4) DEFAULT '0' COMMENT '自动排期开关：0：关；1：开',
|
||
`change_macro` tinyint(4) DEFAULT '0' COMMENT '场前切放映机正片通道：0：关；1：开',
|
||
`change_macro_time` tinyint(4) DEFAULT '0' COMMENT '场前自动切放映机通道时间，单位秒',
|
||
PRIMARY KEY (`audit_number`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `auditorium`
|
||
--
|
||
|
||
LOCK TABLES `auditorium` WRITE;
|
||
/*!40000 ALTER TABLE `auditorium` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `auditorium` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `autotransfer`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `autotransfer`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `autotransfer` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`cplid` varchar(50) NOT NULL COMMENT '影片ID',
|
||
`audit_number` int(4) NOT NULL COMMENT '厅号',
|
||
`create_time` datetime NOT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `autotransfer`
|
||
--
|
||
|
||
LOCK TABLES `autotransfer` WRITE;
|
||
/*!40000 ALTER TABLE `autotransfer` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `autotransfer` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `bt_task`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `bt_task`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `bt_task` (
|
||
`id` varchar(50) NOT NULL COMMENT '主键uuid',
|
||
`bt_task_id` int(11) DEFAULT NULL COMMENT 'ad系统下载任务id',
|
||
`task_name` varchar(100) DEFAULT NULL COMMENT '任务名称',
|
||
`bt_file` varchar(100) DEFAULT NULL COMMENT 'bt文件url',
|
||
`file_size` int(11) DEFAULT NULL COMMENT '文件大小',
|
||
`bt_task_cinema_id` int(11) DEFAULT NULL COMMENT 'ad系统影院下载任务主键id',
|
||
`cmember_platid` int(11) DEFAULT NULL COMMENT 'ad系统的影院id',
|
||
`download_status` tinyint(4) DEFAULT '0' COMMENT '下载状态：0、未开始下载；1、正在下载； 2、已下载； ',
|
||
`bt_file_hash` varchar(50) DEFAULT NULL COMMENT 'bt文件标识hash码',
|
||
`download_percent` varchar(50) DEFAULT '0' COMMENT '下载进度',
|
||
`save_path` varchar(50) DEFAULT NULL COMMENT '存储位置',
|
||
`file_name` varchar(200) DEFAULT NULL COMMENT '文件名称',
|
||
`createtime` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`starttime` datetime DEFAULT NULL COMMENT '下载开始时间',
|
||
`stoptime` datetime DEFAULT NULL COMMENT '任务下载结束时间',
|
||
`deletetime` datetime DEFAULT NULL COMMENT '删除时间',
|
||
`status` tinyint(4) DEFAULT '0' COMMENT '下载状态：1：开始；2：停止',
|
||
`state` tinyint(4) DEFAULT '1' COMMENT '删除标识：1：正常；127：删除',
|
||
`is_notify` tinyint(4) DEFAULT '0' COMMENT '是否消息通知：0：未通知；1：已通知',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `idx_bt_task_cinema_id` (`bt_task_cinema_id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='bt下载任务';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `bt_task`
|
||
--
|
||
|
||
LOCK TABLES `bt_task` WRITE;
|
||
/*!40000 ALTER TABLE `bt_task` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `bt_task` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `cinema_address`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `cinema_address`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `cinema_address` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`type` varchar(20) NOT NULL,
|
||
`country` varchar(40) NOT NULL,
|
||
`province` varchar(40) NOT NULL,
|
||
`city` varchar(40) NOT NULL,
|
||
`street_scene` varchar(40) NOT NULL,
|
||
`address_detail` varchar(150) DEFAULT NULL,
|
||
`postalcode` varchar(20) DEFAULT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `cinema_address`
|
||
--
|
||
|
||
LOCK TABLES `cinema_address` WRITE;
|
||
/*!40000 ALTER TABLE `cinema_address` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `cinema_address` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `contacts`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `contacts`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `contacts` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`cinema_address_type` varchar(20) NOT NULL,
|
||
`name` varchar(20) NOT NULL,
|
||
`telephone` varchar(20) NOT NULL,
|
||
`email` varchar(20) NOT NULL,
|
||
`address` varchar(150) DEFAULT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `contacts`
|
||
--
|
||
|
||
LOCK TABLES `contacts` WRITE;
|
||
/*!40000 ALTER TABLE `contacts` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `contacts` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `cpl`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `cpl`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `cpl` (
|
||
`cpl_uuid` varchar(50) NOT NULL COMMENT '主键id',
|
||
`stereoscopic` tinyint(4) NOT NULL COMMENT '影片类型：0:2D 非0： 3D',
|
||
`content_title_text` varchar(255) NOT NULL COMMENT 'CPL内容英文标题',
|
||
`content_kind` varchar(20) NOT NULL COMMENT 'CPL类型：advertisement：广告；feature：正片；policy策略；trailer：预告片；test：测试：short：小短片；transitional：过期的',
|
||
`issue_date` datetime DEFAULT NULL COMMENT 'CPL发布日期',
|
||
`cpl_duration` int(4) NOT NULL COMMENT 'CPL时长（帧数）',
|
||
`attached_title` varchar(255) DEFAULT NULL COMMENT 'CPL备注标题',
|
||
`cpl_endpoint` int(4) DEFAULT NULL COMMENT '设置的CPL结束时间(字幕时间，即影片结束开灯时间)',
|
||
`macro_id` int(4) DEFAULT NULL COMMENT '通道ID：1、进口宽幅；2、进口遮幅；3、国产宽幅；4、国产遮幅；5、3D宽幅；6、3D遮幅',
|
||
`cpl_volume` int(4) DEFAULT NULL COMMENT '设置CPL的音量',
|
||
`movie_id` varchar(100) DEFAULT NULL COMMENT '从售票系统关联到TMS的正片的ID',
|
||
`upload_time` datetime DEFAULT NULL COMMENT 'CPL上传到影厅的的日期',
|
||
`cpl_attribute` varchar(200) DEFAULT NULL COMMENT 'CPL的一些属性信息',
|
||
`is_used_by_spl` tinyint(4) DEFAULT '0' COMMENT '是否被spl使用',
|
||
`cpl_size` double DEFAULT NULL COMMENT '大小',
|
||
`is_ad_cpl` tinyint(4) DEFAULT '0' COMMENT '是否广告系统的广告',
|
||
`skipcpl_ad` varchar(4) DEFAULT NULL COMMENT '龙标位置',
|
||
`film_attribute` tinyint(4) DEFAULT '1' COMMENT '影片属性：1、普通版本；2、DTSX；3、杜比全景声；',
|
||
`egg_time` int(4) DEFAULT NULL COMMENT '彩蛋时间',
|
||
`frame_duration` int(8) DEFAULT '0' COMMENT 'cpl总帧数',
|
||
`edit_rate` tinyint(4) DEFAULT '0' COMMENT '影片帧率：默认24；有48；60等',
|
||
`skipcpl_ad_sync` int(4) DEFAULT '0' COMMENT '同步龙标时间',
|
||
`cpl_endpoint_sync` int(4) DEFAULT '0' COMMENT '同步字幕时间',
|
||
`attached_title_sync` varchar(255) DEFAULT NULL COMMENT '同步备注标题',
|
||
`assetmap` varchar(20) DEFAULT NULL COMMENT 'assetmap文件名字',
|
||
`dcpid` varchar(50) DEFAULT NULL COMMENT 'dcpid',
|
||
`film_attribute_set` tinyint(4) DEFAULT '0' COMMENT '人工设置影片属性：1、普通；2、DTSX全景声；3、DOLBY全景声；4、中国巨幕；5、IMAX；6、WANOS全景声；7、CINITY；8、4D；',
|
||
`dcp_path` varchar(200) DEFAULT NULL COMMENT 'dcp存储路径',
|
||
`cpl_path` varchar(200) DEFAULT NULL COMMENT 'cpl所在位置',
|
||
PRIMARY KEY (`cpl_uuid`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `cpl`
|
||
--
|
||
|
||
LOCK TABLES `cpl` WRITE;
|
||
/*!40000 ALTER TABLE `cpl` DISABLE KEYS */;
|
||
INSERT INTO `cpl` VALUES ('urn:uuid:406e5738-3e55-4482-bd03-072dae04bfc2',1,'10miaoheizhen_220224_3D_J_S','advertisement','2022-02-24 17:12:10',10,NULL,NULL,5,NULL,NULL,'2025-01-09 01:59:16','excuteMacro_3D_SCOPE',0,9195927,0,NULL,NULL,NULL,240,24,NULL,NULL,NULL,'ASSETMAP.xml','urn:uuid:91a16560-6566-49d4-9351-dcdd675c3af7',0,NULL,NULL),('urn:uuid:41f6f6e1-f20e-4dfc-9711-9fbe1c8f7710',0,'2miaoheizhen_220224_2D_J_F','advertisement','2022-02-24 17:18:08',2,NULL,NULL,2,NULL,NULL,'2025-01-09 01:59:16','excuteMacro_JPEG2000_FLAT',0,1911368,0,NULL,NULL,NULL,50,24,NULL,NULL,NULL,'ASSETMAP.xml','urn:uuid:4a5d0e10-aade-45b2-a53d-ab422a9405ac',0,NULL,NULL),('urn:uuid:42ae0c8f-1c60-44f3-a77a-b05c721bc162',1,'10miaoheizhen_220224_3D_J_F','advertisement','2022-02-24 17:14:15',10,NULL,NULL,6,NULL,NULL,'2025-01-09 01:59:16','excuteMacro_3D_FLAT',0,9332728,0,NULL,NULL,NULL,240,24,NULL,NULL,NULL,'ASSETMAP.xml','urn:uuid:24a2724b-e6c5-4b99-aac1-8e4e281cdb4c',0,NULL,NULL),('urn:uuid:4354e31e-79a5-490a-b3be-384194449ac3',1,'2miaoheizhen_220224_3D_J_F','advertisement','2022-02-24 17:19:09',2,NULL,NULL,6,NULL,NULL,'2025-01-09 01:59:16','excuteMacro_3D_FLAT',0,1978392,0,NULL,NULL,NULL,50,24,NULL,NULL,NULL,'ASSETMAP.xml','urn:uuid:93e5c98d-48ca-4a24-a8be-c1e760fe1caf',0,NULL,NULL),('urn:uuid:7d9429e6-3d75-4c97-b889-b0da7cf0bc95',0,'10miaoheizhen_220224_2D_J_S','advertisement','2022-02-24 17:11:09',10,NULL,NULL,1,NULL,NULL,'2025-01-09 01:59:16','excuteMacro_JPEG2000_SCOPE',0,8943083,0,NULL,NULL,NULL,240,24,NULL,NULL,NULL,'ASSETMAP.xml','urn:uuid:da61b827-a2e2-46bc-9b39-b8b78243bd3a',0,NULL,NULL),('urn:uuid:ab05de9c-0b14-4162-91a4-e40a963a8d8c',0,'2miaoheizhen_220224_2D_J_S','advertisement','2022-02-24 17:16:05',2,NULL,NULL,1,NULL,NULL,'2025-01-09 01:59:16','excuteMacro_JPEG2000_SCOPE',0,1897117,0,NULL,NULL,NULL,50,24,NULL,NULL,NULL,'ASSETMAP.xml','urn:uuid:1fd885a2-d25e-4030-9143-7162fd04d5a1',0,NULL,NULL),('urn:uuid:c76df950-88ff-4074-99b1-7fa0cc9a60f4',1,'2miaoheizhen_220224_3D_J_S','advertisement','2022-02-24 17:17:06',2,NULL,NULL,5,NULL,NULL,'2025-01-09 01:59:16','excuteMacro_3D_SCOPE',0,1949891,0,NULL,NULL,NULL,50,24,NULL,NULL,NULL,'ASSETMAP.xml','urn:uuid:1b78a54d-0b37-44e8-9910-b05ad3e4788c',0,NULL,NULL),('urn:uuid:d63f6db9-f2e7-4820-aa51-68fdd4d5f57b',0,'10miaoheizhen_220224_2D_J_F','advertisement','2022-02-24 17:13:14',10,NULL,NULL,2,NULL,NULL,'2025-01-09 01:59:16','excuteMacro_JPEG2000_FLAT',0,9011484,0,NULL,NULL,NULL,240,24,NULL,NULL,NULL,'ASSETMAP.xml','urn:uuid:e6d7f3b0-a9a8-4395-a20a-7e687f26ab15',0,NULL,NULL);
|
||
/*!40000 ALTER TABLE `cpl` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `cpl_cue`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `cpl_cue`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `cpl_cue` (
|
||
`audit_number` tinyint(4) NOT NULL,
|
||
`show_time` datetime NOT NULL,
|
||
`cpl_uuid` varchar(50) NOT NULL,
|
||
`cpl_cue` text NOT NULL,
|
||
PRIMARY KEY (`audit_number`,`show_time`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `cpl_cue`
|
||
--
|
||
|
||
LOCK TABLES `cpl_cue` WRITE;
|
||
/*!40000 ALTER TABLE `cpl_cue` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `cpl_cue` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `cpl_template_bind`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `cpl_template_bind`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `cpl_template_bind` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`cplid` varchar(50) DEFAULT NULL,
|
||
`templateid` varchar(50) DEFAULT NULL,
|
||
`type` tinyint(4) DEFAULT NULL COMMENT '关联类型：1、TMS创建； 2、广告平台推送',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `cpl_temple` (`cplid`,`templateid`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `cpl_template_bind`
|
||
--
|
||
|
||
LOCK TABLES `cpl_template_bind` WRITE;
|
||
/*!40000 ALTER TABLE `cpl_template_bind` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `cpl_template_bind` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `cue`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `cue`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `cue` (
|
||
`cue_label` varchar(200) NOT NULL DEFAULT '',
|
||
`audit_number` int(4) NOT NULL,
|
||
`cue_name` varchar(50) NOT NULL,
|
||
`cue_uuid` varchar(50) NOT NULL,
|
||
`target` varchar(50) DEFAULT NULL,
|
||
`command` varchar(200) DEFAULT NULL,
|
||
`parameter_name` varchar(50) DEFAULT NULL,
|
||
`parameter_value` varchar(100) DEFAULT NULL,
|
||
PRIMARY KEY (`cue_label`,`audit_number`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `cue`
|
||
--
|
||
|
||
LOCK TABLES `cue` WRITE;
|
||
/*!40000 ALTER TABLE `cue` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `cue` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `cue_set`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `cue_set`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `cue_set` (
|
||
`audit_number` int(4) NOT NULL,
|
||
`operation` varchar(50) NOT NULL DEFAULT '',
|
||
`cue_label` varchar(50) NOT NULL DEFAULT '',
|
||
`device_type` varchar(20) NOT NULL,
|
||
`relay_id` int(4) DEFAULT NULL,
|
||
`delay_time` int(2) DEFAULT '0' COMMENT '延时时间',
|
||
PRIMARY KEY (`audit_number`,`cue_label`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `cue_set`
|
||
--
|
||
|
||
LOCK TABLES `cue_set` WRITE;
|
||
/*!40000 ALTER TABLE `cue_set` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `cue_set` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `dcp_conversion`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `dcp_conversion`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `dcp_conversion` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`source_file_path` varchar(255) NOT NULL,
|
||
`file_name` varchar(255) NOT NULL,
|
||
`attached_title` varchar(255) DEFAULT NULL,
|
||
`content_kind` varchar(20) NOT NULL,
|
||
`macro_id` int(4) NOT NULL,
|
||
`place` varchar(255) NOT NULL,
|
||
`status` tinyint(4) DEFAULT '0',
|
||
`start_time` datetime NOT NULL,
|
||
`end_time` datetime DEFAULT NULL,
|
||
`percent` tinyint(4) DEFAULT '0',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `dcp_conversion`
|
||
--
|
||
|
||
LOCK TABLES `dcp_conversion` WRITE;
|
||
/*!40000 ALTER TABLE `dcp_conversion` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `dcp_conversion` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `downloadkdm`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `downloadkdm`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `downloadkdm` (
|
||
`uuid` varchar(50) NOT NULL COMMENT 'kdmid',
|
||
`cinema_name` varchar(50) DEFAULT NULL COMMENT '影院名称',
|
||
`issuer` varchar(20) DEFAULT NULL COMMENT '发行方',
|
||
`type` varchar(20) DEFAULT NULL,
|
||
`issue_time` varchar(20) DEFAULT NULL COMMENT '发行时间',
|
||
`audit_number` int(4) DEFAULT NULL COMMENT '厅号',
|
||
`version` varchar(4) DEFAULT NULL COMMENT '版本',
|
||
`kdm_name` varchar(200) DEFAULT NULL COMMENT 'kdm文件名字',
|
||
`validatetime` varchar(40) DEFAULT NULL COMMENT 'kdm有效期',
|
||
`zip_name` varchar(100) DEFAULT NULL COMMENT '下载压缩包名字',
|
||
`download_time` date DEFAULT '2019-06-21' COMMENT '密钥下载时间',
|
||
PRIMARY KEY (`uuid`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `downloadkdm`
|
||
--
|
||
|
||
LOCK TABLES `downloadkdm` WRITE;
|
||
/*!40000 ALTER TABLE `downloadkdm` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `downloadkdm` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `downloadkdm_info`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `downloadkdm_info`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `downloadkdm_info` (
|
||
`id` varchar(50) NOT NULL COMMENT '主键id',
|
||
`issuer` varchar(50) DEFAULT NULL COMMENT '发行方中文名称',
|
||
`issuer_en` varchar(50) NOT NULL COMMENT '发行方英文名称',
|
||
`username` varchar(50) NOT NULL COMMENT '后台登录用户名',
|
||
`password` varchar(50) NOT NULL COMMENT '后台登录密码',
|
||
`is_open` tinyint(2) DEFAULT '0' COMMENT '是否开启开关：0：关闭；1：开启',
|
||
`is_new` tinyint(2) DEFAULT '0' COMMENT '中影新旧版本标识：0：旧版；1：新版',
|
||
`createtime` datetime DEFAULT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `idx_issuer_en` (`issuer_en`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='kdm获取网站登录用户信息';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `downloadkdm_info`
|
||
--
|
||
|
||
LOCK TABLES `downloadkdm_info` WRITE;
|
||
/*!40000 ALTER TABLE `downloadkdm_info` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `downloadkdm_info` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `film_schedule_policy`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `film_schedule_policy`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `film_schedule_policy` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`film_id` int(11) NOT NULL,
|
||
`film_name` varchar(200) NOT NULL DEFAULT '',
|
||
`serial_num` varchar(50) NOT NULL DEFAULT '',
|
||
`film_uuid` varchar(50) NOT NULL,
|
||
`content_id` int(50) NOT NULL,
|
||
`policy_date` date NOT NULL,
|
||
`rank` int(4) NOT NULL,
|
||
`distribute_status` tinyint(4) NOT NULL DEFAULT '0',
|
||
`duration` int(11) NOT NULL DEFAULT '0',
|
||
`subject` varchar(100) DEFAULT NULL,
|
||
`content_plan_id` bigint(20) NOT NULL COMMENT '计划ID',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `film_schedule_policy`
|
||
--
|
||
|
||
LOCK TABLES `film_schedule_policy` WRITE;
|
||
/*!40000 ALTER TABLE `film_schedule_policy` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `film_schedule_policy` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `ftp`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `ftp`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `ftp` (
|
||
`ftp_id` int(4) NOT NULL AUTO_INCREMENT,
|
||
`ftp_port` int(4) DEFAULT NULL,
|
||
`ftp_name` varchar(50) NOT NULL,
|
||
`ftp_ip` varchar(50) NOT NULL,
|
||
`ftp_user_name` varchar(50) DEFAULT NULL,
|
||
`ftp_password` varchar(255) DEFAULT NULL,
|
||
`ftp_date` varchar(50) DEFAULT NULL,
|
||
`ftp_type` varchar(50) NOT NULL,
|
||
`remoteFtp` tinyint(4) NOT NULL DEFAULT '0' COMMENT '外接片库 0不是 1是',
|
||
PRIMARY KEY (`ftp_id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `ftp`
|
||
--
|
||
|
||
LOCK TABLES `ftp` WRITE;
|
||
/*!40000 ALTER TABLE `ftp` DISABLE KEYS */;
|
||
INSERT INTO `ftp` VALUES (64,21,'片库','127.0.0.1','tms','tms','2025-01-09','ftp',0);
|
||
/*!40000 ALTER TABLE `ftp` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `get_snmp`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `get_snmp`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `get_snmp` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`audit_number` tinyint(4) DEFAULT NULL COMMENT '影厅号',
|
||
`snmp_data` text COMMENT 'snmp数据',
|
||
`event_time` datetime DEFAULT NULL COMMENT '日期',
|
||
`server_ip` varchar(20) DEFAULT NULL COMMENT '设备ip',
|
||
`server_type` varchar(20) DEFAULT NULL COMMENT '设备类型',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='存储snmp数据';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `get_snmp`
|
||
--
|
||
|
||
LOCK TABLES `get_snmp` WRITE;
|
||
/*!40000 ALTER TABLE `get_snmp` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `get_snmp` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `ingestion`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `ingestion`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `ingestion` (
|
||
`ingest_uuid` varchar(50) NOT NULL,
|
||
`cpl_title` varchar(255) NOT NULL,
|
||
`cpl_uuid` varchar(50) NOT NULL,
|
||
`source` varchar(255) NOT NULL COMMENT '资源位置路径',
|
||
`ingest_type` varchar(10) NOT NULL COMMENT '类型：cpl,kdm(秘钥)',
|
||
`status` tinyint(4) DEFAULT NULL COMMENT '状态',
|
||
`destination` varchar(10) DEFAULT NULL,
|
||
`ingest_begintime` datetime NOT NULL COMMENT '传输开始时间',
|
||
`ingest_endtime` datetime DEFAULT NULL COMMENT '传输结束时间',
|
||
`last_message` varchar(255) DEFAULT NULL COMMENT '最后传输信息结果',
|
||
`execution_time` datetime DEFAULT NULL COMMENT '指定的执行时间',
|
||
`parameters` varchar(500) DEFAULT NULL COMMENT '传输时候相关参数',
|
||
`job_id` bigint(20) DEFAULT NULL,
|
||
`tag` varchar(20) DEFAULT '' COMMENT '自动化传输标签',
|
||
`prior_transfer` int(4) DEFAULT '0' COMMENT '优先传输 1：优先传输',
|
||
`prior_transfer_time` datetime DEFAULT NULL COMMENT '设置优先传输的时间',
|
||
`delete_flag` tinyint(4) DEFAULT '0' COMMENT '删除标记 0 未删除 1已删除',
|
||
`source_name` varchar(20) DEFAULT NULL COMMENT '传输来源名称',
|
||
PRIMARY KEY (`ingest_uuid`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `ingestion`
|
||
--
|
||
|
||
LOCK TABLES `ingestion` WRITE;
|
||
/*!40000 ALTER TABLE `ingestion` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `ingestion` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `log_detail`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `log_detail`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `log_detail` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`audit_number` tinyint(4) DEFAULT '0' COMMENT '影厅编号',
|
||
`log_date` date DEFAULT NULL COMMENT '日志日期',
|
||
`content_name` varchar(500) DEFAULT NULL COMMENT '内容名称',
|
||
`content_uuid` varchar(100) DEFAULT NULL COMMENT '内容uuid',
|
||
`start_time` varchar(50) DEFAULT NULL COMMENT '开始时间',
|
||
`end_time` varchar(50) DEFAULT NULL COMMENT '结束时间',
|
||
`content_kind` varchar(255) DEFAULT NULL COMMENT 'cpl(内容)类型',
|
||
`attached_title` varchar(300) DEFAULT NULL COMMENT 'cpl标题备注',
|
||
`createtime` datetime DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='放映服务器日志解析';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `log_detail`
|
||
--
|
||
|
||
LOCK TABLES `log_detail` WRITE;
|
||
/*!40000 ALTER TABLE `log_detail` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `log_detail` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `log_report_record`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `log_report_record`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `log_report_record` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`audit_num` int(11) NOT NULL,
|
||
`play_list_log` varchar(200) DEFAULT NULL COMMENT '上报播放日志md5 ',
|
||
`report_date` date NOT NULL,
|
||
`report_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0:默认，未上报 1已上报 2 实时上报中',
|
||
`parse_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0:默认，未解析 1:已解析',
|
||
`get_log_date` date DEFAULT NULL COMMENT '拉取日志日期',
|
||
`get_log_num` tinyint(1) DEFAULT NULL COMMENT '拉取日志失败次数',
|
||
`is_getlogsuccess` tinyint(1) DEFAULT NULL COMMENT '是否成功拉取日志 1成功 0未成功 2成功获取中',
|
||
`file_size` varchar(10) DEFAULT '' COMMENT '文件大小：单位字节KB',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `log_report_record`
|
||
--
|
||
|
||
LOCK TABLES `log_report_record` WRITE;
|
||
/*!40000 ALTER TABLE `log_report_record` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `log_report_record` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `macro`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `macro`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `macro` (
|
||
`macro_id` int(4) NOT NULL AUTO_INCREMENT,
|
||
`macro_caption` varchar(50) NOT NULL,
|
||
PRIMARY KEY (`macro_id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `macro`
|
||
--
|
||
|
||
LOCK TABLES `macro` WRITE;
|
||
/*!40000 ALTER TABLE `macro` DISABLE KEYS */;
|
||
INSERT INTO `macro` VALUES (1,'进口宽幅'),(2,'进口遮幅'),(3,'国产宽幅'),(4,'国产遮幅'),(5,'3D宽幅'),(6,'3D遮幅'),(7,'3D宽幅48'),(8,'3D遮幅48');
|
||
/*!40000 ALTER TABLE `macro` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `macro_content`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `macro_content`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `macro_content` (
|
||
`audit_number` int(4) NOT NULL,
|
||
`macro_id` int(4) NOT NULL,
|
||
`macro_content` varchar(255) DEFAULT NULL,
|
||
`macro_cue_label` varchar(50) DEFAULT NULL,
|
||
PRIMARY KEY (`audit_number`,`macro_id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `macro_content`
|
||
--
|
||
|
||
LOCK TABLES `macro_content` WRITE;
|
||
/*!40000 ALTER TABLE `macro_content` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `macro_content` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `message`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `message`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `message` (
|
||
`id` varchar(50) NOT NULL,
|
||
`type` tinyint(1) DEFAULT NULL COMMENT '消息大类型：1、故障消息；2：产品消息；3：自动排期消息提醒',
|
||
`typedetail` int(4) DEFAULT NULL,
|
||
`title` varchar(100) DEFAULT NULL COMMENT '消息标题',
|
||
`time` datetime DEFAULT NULL COMMENT '消息时间',
|
||
`content` text COMMENT '消息内容详细',
|
||
`status` tinyint(1) DEFAULT NULL COMMENT '消息状态：0：未读；1：已读',
|
||
`audit` tinyint(4) DEFAULT NULL COMMENT '消息对应的厅号',
|
||
`isalive` tinyint(1) DEFAULT NULL COMMENT '删除消息后，置状态位，1：正常；0：删除',
|
||
`is_report` tinyint(1) DEFAULT '0' COMMENT '是否上报：0：未上报；1：已上报',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='消息提醒表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `message`
|
||
--
|
||
|
||
LOCK TABLES `message` WRITE;
|
||
/*!40000 ALTER TABLE `message` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `message` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `osstask_download`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `osstask_download`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `osstask_download` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`task_id` int(11) DEFAULT NULL COMMENT '任务id',
|
||
`local_path` varchar(300) DEFAULT NULL COMMENT '文件名称',
|
||
`platform` varchar(50) DEFAULT NULL COMMENT 'oss平台名称',
|
||
`remote_path` varchar(100) DEFAULT NULL COMMENT 'oss上文件路径',
|
||
`bucket` varchar(50) DEFAULT NULL COMMENT 'oss上bucket名称',
|
||
`hash` varchar(32) DEFAULT NULL COMMENT '文件MD5的hash值',
|
||
`files` longtext COMMENT '下载文件集合列表',
|
||
`size` bigint(20) DEFAULT '0' COMMENT '总文件大小',
|
||
`num` int(4) DEFAULT NULL COMMENT '文件包含子文件个数',
|
||
`stats` tinyint(4) DEFAULT '0' COMMENT '下载状态 0：等待 1：进行中 2：完成',
|
||
`createtime` datetime DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OSS任务下载';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `osstask_download`
|
||
--
|
||
|
||
LOCK TABLES `osstask_download` WRITE;
|
||
/*!40000 ALTER TABLE `osstask_download` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `osstask_download` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `package_placeholder`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `package_placeholder`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `package_placeholder` (
|
||
`id` int(10) NOT NULL AUTO_INCREMENT,
|
||
`placeholder_name` varchar(200) NOT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `package_placeholder`
|
||
--
|
||
|
||
LOCK TABLES `package_placeholder` WRITE;
|
||
/*!40000 ALTER TABLE `package_placeholder` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `package_placeholder` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `permission_group`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `permission_group`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `permission_group` (
|
||
`group_id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`group_name` varchar(50) NOT NULL,
|
||
`permission` int(11) NOT NULL,
|
||
PRIMARY KEY (`group_id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=10015 DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `permission_group`
|
||
--
|
||
|
||
LOCK TABLES `permission_group` WRITE;
|
||
/*!40000 ALTER TABLE `permission_group` DISABLE KEYS */;
|
||
INSERT INTO `permission_group` VALUES (10010,'只读',1),(10011,'放映员',3),(10012,'内容管理员',7),(10013,'放映经理',15),(10014,'管理员',31);
|
||
/*!40000 ALTER TABLE `permission_group` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `play_log`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `play_log`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `play_log` (
|
||
`play_log_id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`audit_number` int(4) NOT NULL,
|
||
`play_time` datetime NOT NULL,
|
||
`play_content_title` varchar(255) DEFAULT NULL,
|
||
`play_attached_title` varchar(255) DEFAULT NULL,
|
||
`play_content_kind` varchar(20) DEFAULT NULL,
|
||
`play_cpl_uuid` varchar(50) DEFAULT NULL COMMENT '播放CPL UUID',
|
||
`play_spl_uuid` varchar(50) DEFAULT NULL COMMENT '播放SPL UUID',
|
||
`end_time` datetime DEFAULT NULL,
|
||
`duration` int(5) DEFAULT '0' COMMENT '时长',
|
||
`report_status` tinyint(4) DEFAULT '0' COMMENT '0:默认，未上报 1已上报 2无需上报（非广告）',
|
||
`schedule_uuid` varchar(50) DEFAULT NULL COMMENT '排期UUID',
|
||
`spl_title` varchar(255) DEFAULT NULL COMMENT 'spl标题名称',
|
||
PRIMARY KEY (`play_log_id`,`audit_number`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `play_log`
|
||
--
|
||
|
||
LOCK TABLES `play_log` WRITE;
|
||
/*!40000 ALTER TABLE `play_log` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `play_log` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `pos_schedule`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `pos_schedule`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `pos_schedule` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`pos_data` longtext COMMENT 'pos中排期数据',
|
||
`schedule_date` date DEFAULT NULL COMMENT '排期日期',
|
||
`createtime` datetime DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='售票系统排期数据';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `pos_schedule`
|
||
--
|
||
|
||
LOCK TABLES `pos_schedule` WRITE;
|
||
/*!40000 ALTER TABLE `pos_schedule` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `pos_schedule` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `relay`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `relay`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `relay` (
|
||
`audit_number` int(4) NOT NULL,
|
||
`relay_id` int(4) NOT NULL,
|
||
`relay_name` varchar(50) NOT NULL,
|
||
`relay_cue_label` varchar(50) DEFAULT NULL,
|
||
`auto_control` int(1) DEFAULT '0',
|
||
`operation_type` varchar(50) DEFAULT NULL,
|
||
PRIMARY KEY (`audit_number`,`relay_id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `relay`
|
||
--
|
||
|
||
LOCK TABLES `relay` WRITE;
|
||
/*!40000 ALTER TABLE `relay` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `relay` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `relay_reset`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `relay_reset`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `relay_reset` (
|
||
`audit_number` int(4) NOT NULL,
|
||
`stage` int(4) NOT NULL,
|
||
`relay_id` int(4) NOT NULL,
|
||
`status` tinyint(4) NOT NULL,
|
||
PRIMARY KEY (`audit_number`,`stage`,`relay_id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `relay_reset`
|
||
--
|
||
|
||
LOCK TABLES `relay_reset` WRITE;
|
||
/*!40000 ALTER TABLE `relay_reset` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `relay_reset` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `report_play_log`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `report_play_log`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `report_play_log` (
|
||
`audit_number` int(4) NOT NULL,
|
||
`schedule_time` datetime NOT NULL,
|
||
`film_plan_id` varchar(50) DEFAULT NULL,
|
||
`play_begin_time` datetime NOT NULL,
|
||
`play_ad_content_title` varchar(255) DEFAULT NULL,
|
||
`play_ad_uuid` varchar(50) NOT NULL DEFAULT '',
|
||
`play_ad_duration` int(4) NOT NULL,
|
||
`play_end_time` datetime DEFAULT NULL,
|
||
`server_serial` varchar(200) DEFAULT NULL,
|
||
`server_public_key` varchar(200) DEFAULT NULL,
|
||
`server_type` varchar(20) DEFAULT NULL,
|
||
`feature_uuid` varchar(50) NOT NULL,
|
||
`feature_channel` varchar(100) NOT NULL,
|
||
`play_status` tinyint(4) NOT NULL COMMENT '(0默认 1播放成功 2播放失败)',
|
||
`ticketnum` int(4) DEFAULT NULL,
|
||
`report_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '(0未对应 1已对应 2已上报)',
|
||
`play_order` bigint(20) NOT NULL DEFAULT '0',
|
||
`rank` int(4) NOT NULL DEFAULT '0',
|
||
`content_plan_id` bigint(20) DEFAULT '0',
|
||
`is_gold` tinyint(4) DEFAULT '0' COMMENT '(0普通广告 1黄金广告)',
|
||
`content_id` int(4) DEFAULT '0' COMMENT '广告id,由广告系统生成',
|
||
`schedule_uuid` varchar(50) NOT NULL DEFAULT '' COMMENT '排期UUID',
|
||
PRIMARY KEY (`audit_number`,`schedule_uuid`,`play_ad_uuid`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `report_play_log`
|
||
--
|
||
|
||
LOCK TABLES `report_play_log` WRITE;
|
||
/*!40000 ALTER TABLE `report_play_log` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `report_play_log` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `schedule`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `schedule`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `schedule` (
|
||
`schedule_uuid` varchar(50) NOT NULL,
|
||
`audit_number` int(4) NOT NULL,
|
||
`start_time` datetime NOT NULL,
|
||
`end_time` datetime NOT NULL,
|
||
`show_play_list` text,
|
||
`template_id` varchar(50) DEFAULT NULL,
|
||
`spl_uuid` varchar(50) NOT NULL,
|
||
`feature_cpl_uuid` varchar(50) NOT NULL,
|
||
`is_cue` tinyint(4) NOT NULL,
|
||
`show_duration` int(11) NOT NULL,
|
||
`show_title` varchar(300) DEFAULT NULL,
|
||
`operator` varchar(20) NOT NULL,
|
||
`schedule_status` varchar(20) DEFAULT NULL,
|
||
`valid_date_time` datetime DEFAULT NULL,
|
||
`ad_num` int(4) DEFAULT '0',
|
||
`ad_duration` int(4) DEFAULT '0',
|
||
`ticket_num` int(4) DEFAULT '0',
|
||
`is_report` tinyint(4) NOT NULL,
|
||
`feature_cpl_macro` varchar(50) DEFAULT NULL,
|
||
`is_tms_schedule` tinyint(4) NOT NULL,
|
||
`spl_id` int(11) DEFAULT NULL,
|
||
`feature_content_title_text` varchar(255) DEFAULT NULL,
|
||
`feature_attached_title` varchar(200) DEFAULT NULL,
|
||
`play_order` varchar(255) DEFAULT NULL,
|
||
`valid_state` tinyint(4) NOT NULL DEFAULT '0',
|
||
`is_ads_schedule` tinyint(4) NOT NULL DEFAULT '0',
|
||
`film_plan_id` varchar(300) DEFAULT NULL,
|
||
`feature_start_time` datetime DEFAULT NULL,
|
||
`error_message` varchar(500) DEFAULT NULL,
|
||
`audit_spl_id` int(11) DEFAULT NULL COMMENT '播放列表创建排期时候是使用的哪个厅的spl_id创建的',
|
||
`endpoint_time` datetime DEFAULT NULL COMMENT '字幕开始时间(即场灯开灯时间)',
|
||
`pos_param` varchar(500) DEFAULT NULL COMMENT '售票系统上座率接口参数',
|
||
`update_schedule_param` varchar(500) DEFAULT NULL COMMENT '监测是否需要自动更新排期参数',
|
||
`schedule_time` datetime DEFAULT NULL COMMENT '排期参照时间(售票系统导入则为售票系统时间)',
|
||
`audio_param` varchar(200) DEFAULT NULL COMMENT '音量等级及执行时间参数',
|
||
`audit_schedule_policy_id` varchar(50) DEFAULT NULL COMMENT '表白广告厅策略id',
|
||
`bbt_ad_duration` int(4) DEFAULT '0' COMMENT '抱抱堂广告时长',
|
||
`schedule_state` int(4) DEFAULT '0' COMMENT '排期状态：0：默认排期；1：预排期；',
|
||
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`p_uuid` varchar(50) DEFAULT NULL COMMENT '父排期uuid',
|
||
`update_state` tinyint(4) DEFAULT '0' COMMENT '强制排期标记：0：无强排期；1：强排期成功；',
|
||
`ad_plan_rank` varchar(300) DEFAULT NULL COMMENT '广告计划及排序',
|
||
PRIMARY KEY (`schedule_uuid`,`audit_number`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `schedule`
|
||
--
|
||
|
||
LOCK TABLES `schedule` WRITE;
|
||
/*!40000 ALTER TABLE `schedule` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `schedule` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `schedule_attribute`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `schedule_attribute`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `schedule_attribute` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`attribute` tinyint(4) NOT NULL DEFAULT '0' COMMENT '排期执行指令：0：默认；1：强制排期；2：下刊强制排期',
|
||
`state` tinyint(4) NOT NULL DEFAULT '0' COMMENT '自动排期检测状态：0：默认；1：已执行过强制排期',
|
||
`policyDataId` bigint(20) NOT NULL COMMENT 'cmc策略主键id',
|
||
`startTime` date NOT NULL COMMENT '投放策略日期',
|
||
`auditNums` varchar(500) DEFAULT NULL,
|
||
`createtime` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`updatetime` datetime DEFAULT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='排期指令执行';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `schedule_attribute`
|
||
--
|
||
|
||
LOCK TABLES `schedule_attribute` WRITE;
|
||
/*!40000 ALTER TABLE `schedule_attribute` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `schedule_attribute` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `schedule_msg`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `schedule_msg`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `schedule_msg` (
|
||
`id` varchar(50) NOT NULL COMMENT '主键uuid',
|
||
`audit_number` int(4) DEFAULT NULL COMMENT '影厅编号',
|
||
`film_name` varchar(200) DEFAULT NULL COMMENT '影片名称',
|
||
`cpl_uuid` varchar(50) DEFAULT NULL COMMENT 'cpl主键uuid',
|
||
`movie_id` varchar(50) DEFAULT NULL COMMENT '影片编码',
|
||
`msg` varchar(300) DEFAULT NULL COMMENT '错误信息',
|
||
`type` int(4) DEFAULT '0' COMMENT '类型：1：缺少影片；2：缺少密钥；3：创建排期出现异常;',
|
||
`start_time` datetime DEFAULT NULL COMMENT '影片开始时间',
|
||
`createtime` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`state` int(4) DEFAULT '0' COMMENT '状态：0：默认；1：完成(传输影片或密钥)',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='导入排期异常提醒';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `schedule_msg`
|
||
--
|
||
|
||
LOCK TABLES `schedule_msg` WRITE;
|
||
/*!40000 ALTER TABLE `schedule_msg` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `schedule_msg` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `setting`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `setting`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `setting` (
|
||
`name` varchar(50) NOT NULL,
|
||
`value` blob NOT NULL,
|
||
PRIMARY KEY (`name`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `setting`
|
||
--
|
||
|
||
LOCK TABLES `setting` WRITE;
|
||
/*!40000 ALTER TABLE `setting` DISABLE KEYS */;
|
||
INSERT INTO `setting` VALUES ('adSavePath','<EFBFBD><EFBFBD>\0t\0\r/media/cinema'),('autoOpenLight','<EFBFBD><EFBFBD>\0t\00'),('autoTransfer','<EFBFBD><EFBFBD>\0t\01'),('enableADPlatform','<EFBFBD><EFBFBD>\0t\0true'),('enableKDMDownload','<EFBFBD><EFBFBD>\0t\0true'),('filmInfoSwitch','<EFBFBD><EFBFBD>\0t\0true'),('filmInfoSwitchUpdateTime','<EFBFBD><EFBFBD>\0t\02024-10-17 13:22:08'),('ingestFilmAccordingPOS','<EFBFBD><EFBFBD>\0t\01'),('KDMServerIP','<EFBFBD><EFBFBD>\0t\0 127.0.0.1'),('KDMServerName','<EFBFBD><EFBFBD>\0t\0密钥'),('KDMServerPass','<EFBFBD><EFBFBD>\0t\0kdm'),('KDMServerPort','<EFBFBD><EFBFBD>\0t\021'),('KDMServerRootPath','<EFBFBD><EFBFBD>\0t\0\n/media/kdm'),('KDMServerUser','<EFBFBD><EFBFBD>\0t\0kdm'),('openLightBenchmark','<EFBFBD><EFBFBD>\0t\00'),('usbSavePath','<EFBFBD><EFBFBD>\0t\0/run/media/smart');
|
||
/*!40000 ALTER TABLE `setting` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `skip_cplad_log`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `skip_cplad_log`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `skip_cplad_log` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`cplid` varchar(50) NOT NULL COMMENT '影片ID',
|
||
`scheduleid` varchar(50) NOT NULL COMMENT '排期ID',
|
||
`ad_duration` int(11) DEFAULT '0' COMMENT '龙标位置',
|
||
`insert_time` datetime NOT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='跳龙标记录';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `skip_cplad_log`
|
||
--
|
||
|
||
LOCK TABLES `skip_cplad_log` WRITE;
|
||
/*!40000 ALTER TABLE `skip_cplad_log` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `skip_cplad_log` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `snmp_information`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `snmp_information`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `snmp_information` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`source_ip` varchar(20) NOT NULL,
|
||
`audit_number` tinyint(4) NOT NULL,
|
||
`theatre_code` varchar(20) DEFAULT NULL,
|
||
`short_name` varchar(100) DEFAULT NULL,
|
||
`trap_info_json` varchar(8192) DEFAULT NULL,
|
||
`description` varchar(400) DEFAULT NULL,
|
||
`event_level` tinyint(2) DEFAULT NULL,
|
||
`event_time` datetime DEFAULT NULL,
|
||
`report_status` tinyint(4) DEFAULT NULL COMMENT '(0未上报 1已上报)',
|
||
`error_status` tinyint(4) DEFAULT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `snmp_information`
|
||
--
|
||
|
||
LOCK TABLES `snmp_information` WRITE;
|
||
/*!40000 ALTER TABLE `snmp_information` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `snmp_information` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `spl`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `spl`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `spl` (
|
||
`spl_id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`template_id` varchar(50) DEFAULT NULL,
|
||
`spl_uuid_cue` varchar(50) DEFAULT NULL,
|
||
`audit_number` varchar(20) NOT NULL COMMENT 'TMS:模板SPL',
|
||
`show_play_list_cue` text,
|
||
`spl_uuid` varchar(50) DEFAULT NULL,
|
||
`show_play_list` text,
|
||
`feature_cpl_uuid` varchar(50) DEFAULT NULL,
|
||
`show_title` varchar(255) DEFAULT NULL,
|
||
`show_duration` int(11) NOT NULL,
|
||
`feature_cpl_macro` varchar(50) DEFAULT NULL,
|
||
`feature_content_title_text` varchar(255) NOT NULL,
|
||
`scheduling_status` tinyint(4) NOT NULL DEFAULT '0',
|
||
`feature_attached_title` varchar(200) DEFAULT NULL,
|
||
`relation_cpl` varchar(8192) DEFAULT NULL,
|
||
`play_order` varchar(255) DEFAULT NULL,
|
||
`ad_num` int(4) DEFAULT '0',
|
||
`ad_duration` int(4) DEFAULT '0',
|
||
`black_duration` int(4) DEFAULT '0',
|
||
`transfer_info` text COMMENT '记录模板SPL的传输详情',
|
||
`relation_movieid` varchar(64) DEFAULT NULL COMMENT 'spl关联POS moveid',
|
||
`state` int(4) DEFAULT '0' COMMENT '标识是否从厅同步的spl：0：默认否；1：是',
|
||
`spl_md5` varchar(500) DEFAULT NULL COMMENT 'show_play_list的md5值',
|
||
PRIMARY KEY (`spl_id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `spl`
|
||
--
|
||
|
||
LOCK TABLES `spl` WRITE;
|
||
/*!40000 ALTER TABLE `spl` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `spl` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `system_log`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `system_log`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `system_log` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`log_time` datetime NOT NULL,
|
||
`log_level` varchar(10) NOT NULL,
|
||
`thread` varchar(255) NOT NULL,
|
||
`position` varchar(255) NOT NULL,
|
||
`message` varchar(8192) NOT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `system_log`
|
||
--
|
||
|
||
LOCK TABLES `system_log` WRITE;
|
||
/*!40000 ALTER TABLE `system_log` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `system_log` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `temp_syslog`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `temp_syslog`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `temp_syslog` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`log_time` datetime NOT NULL,
|
||
`log_level` varchar(10) NOT NULL,
|
||
`thread` varchar(255) NOT NULL,
|
||
`position` varchar(255) NOT NULL,
|
||
`message` varchar(8192) NOT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `temp_syslog`
|
||
--
|
||
|
||
LOCK TABLES `temp_syslog` WRITE;
|
||
/*!40000 ALTER TABLE `temp_syslog` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `temp_syslog` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `template`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `template`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `template` (
|
||
`template_id` varchar(50) NOT NULL COMMENT '模板ID',
|
||
`template_detail` text NOT NULL COMMENT '模板详情',
|
||
`template_title` varchar(50) NOT NULL COMMENT '模板标题',
|
||
`is_cue` tinyint(4) NOT NULL COMMENT '是否包含cue',
|
||
`auditoriums` varchar(500) DEFAULT NULL,
|
||
`show_duration` int(8) NOT NULL COMMENT '时长',
|
||
`cpl_uuid` varchar(50) DEFAULT NULL,
|
||
`preset_feature_cues` varchar(8192) DEFAULT NULL,
|
||
`placeholder` varchar(50) DEFAULT NULL,
|
||
`date_range` varchar(50) DEFAULT NULL,
|
||
`last_updateTime` varchar(50) DEFAULT NULL,
|
||
`relation_cpl` varchar(8192) DEFAULT NULL,
|
||
`ad_num` int(4) DEFAULT '0',
|
||
`update_status` int(4) DEFAULT '0' COMMENT '内容是否更新：0：未更新；1：已更新',
|
||
`error_message` text COMMENT '错误信息',
|
||
PRIMARY KEY (`template_id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `template`
|
||
--
|
||
|
||
LOCK TABLES `template` WRITE;
|
||
/*!40000 ALTER TABLE `template` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `template` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `user`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `user`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `user` (
|
||
`user_id` int(4) NOT NULL AUTO_INCREMENT,
|
||
`user_name` varchar(20) NOT NULL,
|
||
`user_password` varchar(40) NOT NULL,
|
||
`phone_number` varchar(20) DEFAULT NULL,
|
||
`expired_time` datetime NOT NULL,
|
||
`group_id` int(11) NOT NULL,
|
||
PRIMARY KEY (`user_id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `user`
|
||
--
|
||
|
||
LOCK TABLES `user` WRITE;
|
||
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
|
||
INSERT INTO `user` VALUES (1,'admin','21232f297a57a5a743894a0e4a801fc3','','2024-10-17 13:21:01',10014);
|
||
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `user_log`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `user_log`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `user_log` (
|
||
`user_log_id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`operate_user` varchar(20) NOT NULL,
|
||
`operate_ip` varchar(20) NOT NULL,
|
||
`operate_time` datetime NOT NULL,
|
||
`message` varchar(8192) NOT NULL,
|
||
PRIMARY KEY (`user_log_id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `user_log`
|
||
--
|
||
|
||
LOCK TABLES `user_log` WRITE;
|
||
/*!40000 ALTER TABLE `user_log` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `user_log` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
||
|
||
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
||
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
||
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
||
/*!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 */;
|
||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||
|
||
-- Dump completed on 2025-01-09 2:00:59
|