DROP TABLE IF EXISTS `videowatchlog_375`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `videowatchlog_375` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`clazzId` bigint(20) DEFAULT NULL,
`personId` bigint(20) DEFAULT NULL,
`createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`videoObjId` varchar(50) DEFAULT NULL,
`playTime` bigint(20) DEFAULT NULL,
`nodeId` bigint(20) DEFAULT NULL,
`vStartTime` int(11) DEFAULT NULL,
`vEndTime` int(11) DEFAULT NULL,
`isDrag` tinyint(1) DEFAULT '0',
`costoffsettime` bigint(20) NOT NULL DEFAULT '0',
`userAgent` varchar(255) DEFAULT NULL,
`_mark` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `idx_clazzid` (`clazzId`),
KEY `idx_mark` (`_mark`),
KEY `idx_clazzId_personId_nodeId` (`clazzId`,`personId`,`nodeId`)
) ENGINE=InnoDB AUTO_INCREMENT=1289705 DEFAULT CHARSET=utf8;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `videowatchlog_375` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`clazzId` bigint(20) DEFAULT NULL,
`personId` bigint(20) DEFAULT NULL,
`createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`videoObjId` varchar(50) DEFAULT NULL,
`playTime` bigint(20) DEFAULT NULL,
`nodeId` bigint(20) DEFAULT NULL,
`vStartTime` int(11) DEFAULT NULL,
`vEndTime` int(11) DEFAULT NULL,
`isDrag` tinyint(1) DEFAULT '0',
`costoffsettime` bigint(20) NOT NULL DEFAULT '0',
`userAgent` varchar(255) DEFAULT NULL,
`_mark` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `idx_clazzid` (`clazzId`),
KEY `idx_mark` (`_mark`),
KEY `idx_clazzId_personId_nodeId` (`clazzId`,`personId`,`nodeId`)
) ENGINE=InnoDB AUTO_INCREMENT=1289705 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
sed -n '/AUTO_INCREMENT=/s/AUTO_INCREMENT=[0-9]\+//p' 1.txt