CREATE DATABASE filmsremarks;
USE filmsremarks;
DROP TABLE IF EXISTS `films_base_temp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `films_base_temp` (
`ID` bigint(11) NOT NULL COMMENT 'id',
`MODELID` varchar(50) DEFAULT NULL COMMENT 'modelid',
`MODELNAME` varchar(50) DEFAULT NULL COMMENT '名称',
`URL` varchar(500) DEFAULT NULL COMMENT '路径',
`CREATE_TIME` timestamp NULL DEFAULT NULL COMMENT '创建时间',
`update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
`IMGURL` varchar(500) DEFAULT NULL COMMENT '图片路径',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
评论0