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;