V3__add-attentions.sql 418 B

12345678910111213141516
  1. CREATE TABLE `user_attention_ids` (
  2. `user_id` bigint(20) NOT NULL,
  3. `attention_ids` bigint(20) DEFAULT NULL,
  4. KEY `FKjruoxsm5isj8qrkofpgwuhhqd` (`user_id`),
  5. CONSTRAINT `FKjruoxsm5isj8qrkofpgwuhhqd` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`)
  6. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  7. INSERT INTO `user_attention_ids` (`user_id`, `attention_ids`)
  8. VALUES
  9. (3,4),
  10. (3,5),
  11. (4,3),
  12. (5,4),
  13. (6,3),
  14. (6,4),
  15. (6,5);