11 lines
498 B
SQL
11 lines
498 B
SQL
|
CREATE TABLE `wa_friend_circle_like` (
|
||
|
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
|
|
`circle_id` int NOT NULL COMMENT '朋友圈动态ID',
|
||
|
|
`user_id` int NOT NULL COMMENT '用户ID',
|
||
|
|
`created_at` int NOT NULL COMMENT '创建时间',
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
UNIQUE KEY `circle_user` (`circle_id`,`user_id`),
|
||
|
|
KEY `circle_id` (`circle_id`),
|
||
|
|
KEY `user_id` (`user_id`)
|
||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=156 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='朋友圈点赞表';
|