15 lines
506 B
MySQL
15 lines
506 B
MySQL
|
DROP TABLE IF EXISTS `comment`;
|
||
|
|
SET character_set_client = utf8mb4 ;
|
||
|
|
CREATE TABLE `comment` (
|
||
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
|
|
`user_id` int(11) DEFAULT NULL,
|
||
|
|
`entity_type` int(11) DEFAULT NULL,
|
||
|
|
`entity_id` int(11) DEFAULT NULL,
|
||
|
|
`target_id` int(11) DEFAULT NULL,
|
||
|
|
`content` text,
|
||
|
|
`status` int(11) DEFAULT NULL,
|
||
|
|
`create_time` timestamp NULL DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
KEY `index_user_id` (`user_id`),
|
||
|
|
KEY `index_entity_id` (`entity_id`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|