1. CREATE TABLE IF NOT EXISTS `following` (
  2. `id` int(6) unsigned NOT NULL,
  3. `following_id` int(6) unsigned NOT NULL,
  4. `followed_id` int(6) unsigned NOT NULL,
  5. PRIMARY KEY (`id`)
  6. ) DEFAULT CHARSET=utf8;
  8. CREATE TABLE IF NOT EXISTS `users` (
  9. `id` int(6) unsigned NOT NULL,
  10. `name` varchar(40) NOT NULL,
  11. PRIMARY KEY (`id`)
  12. ) DEFAULT CHARSET=utf8;
  15. CREATE TABLE IF NOT EXISTS `posts` (
  16. `id` int(6) unsigned NOT NULL,
  17. `user_id` int(6) unsigned NOT NULL,
  18. `content` varchar(200) NOT NULL,
  19. PRIMARY KEY (`id`)
  20. ) DEFAULT CHARSET=utf8;
  23. INSERT INTO `users` (`id`, `name`) VALUES
  24. ('1', 'ali'),
  25. ('2', 'veli'),
  26. ('3', 'deli'),
  27. ('4', 'mahmut');
  29. INSERT INTO `posts` (`id`, `user_id`,`content`) VALUES
  30. ('1', '1', 'ali content'),
  31. ('2', '2', 'veli content'),
  32. ('3','3', 'deli content'),
  33. ('4','4', 'mahmut content');
  36. INSERT INTO `following` (`id`, `following_id`, `followed_id`) VALUES
  37. ('1', '1', '2'),
  38. ('2', '1', '3'),
  39. ('3', '2', '1'),
  40. ('4', '3', '4');