spider-community.sql 586 Bytes
CREATE TABLE `trend_log` (
  `id` int(11) PRIMARY KEY AUTO_INCREMENT,
  `trendId` int(11) DEFAULT 0,
  `userId` int(11) DEFAULT 0,
  `createAt` int(11) DEFAULT 0,
  `userName` varchar(200) DEFAULT '',
  `icon` varchar(500) DEFAULT '',
  `sex` tinyint DEFAULT 1,
  `readCount` int(11) DEFAULT 0,
  `reply` int(11) DEFAULT 0,
  `fav` int(11) DEFAULT 0,
  `city` varchar(50) DEFAULT '',
  `images` int(11) DEFAULT 0,
  `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  KEY `index_createAt` (`createAt`),
  KEY `index_userId` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;