Advertisement
Guest User

DB with records

a guest
Sep 8th, 2016
190
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 6.30 KB | None | 0 0
  1. DROP TABLE IF EXISTS `tasks`;
  2.  
  3. CREATE TABLE `tasks` (
  4. `id` int(11) NOT NULL AUTO_INCREMENT,
  5. `seller_id` int(11) DEFAULT NULL,
  6. PRIMARY KEY (`id`),
  7. KEY `index_tasks_on_seller_id` (`seller_id`)
  8. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  9.  
  10. INSERT INTO `tasks` (`id`, `seller_id`)
  11. VALUES
  12.   (15788, 95157),
  13.   (15789, 95158),
  14.   (15790, 86270),
  15.   (15791, 86270),
  16.   (15792, 94260),
  17.   (15793, 14354),
  18.   (15794, 95160),
  19.   (15795, 95161),
  20.   (15796, 10786),
  21.   (15797, 95162),
  22.   (15798, 72740),
  23.   (15799, 95163),
  24.   (15800, 93159),
  25.   (15801, 95165),
  26.   (15802, 95168),
  27.   (15803, 95170),
  28.   (15804, 95173),
  29.   (15805, 6983),
  30.   (15806, 95175),
  31.   (15807, 95177),
  32.   (15808, 80037),
  33.   (15809, 45066),
  34.   (15810, 95180),
  35.   (15811, 95181),
  36.   (15812, 95182),
  37.   (15813, 84020),
  38.   (15814, 95156),
  39.   (15815, 93418),
  40.   (15816, 74020),
  41.   (15817, 74020),
  42.   (15818, 73604),
  43.   (15819, 95190),
  44.   (15820, 95188),
  45.   (15821, 39132),
  46.   (15822, 95191),
  47.   (15823, 95192),
  48.   (15824, 95196),
  49.   (15825, 32979),
  50.   (15826, 30104),
  51.   (15827, 95198),
  52.   (15828, 95200),
  53.   (15829, 93974),
  54.   (15830, 95201),
  55.   (15831, 95202),
  56.   (15832, 33487),
  57.   (15833, 60076),
  58.   (15834, 33487),
  59.   (15835, 88081),
  60.   (15836, 95204),
  61.   (15837, 95205),
  62.   (15838, 27527),
  63.   (15839, 93055),
  64.   (15840, 95209),
  65.   (15841, 2297),
  66.   (15842, 95211),
  67.   (15843, 76806),
  68.   (15844, 69400),
  69.   (15845, 34273),
  70.   (15846, 95214),
  71.   (15847, 82877);
  72.  
  73. DROP TABLE IF EXISTS `chats`;
  74.  
  75. CREATE TABLE `chats` (
  76. `id` int(11) NOT NULL AUTO_INCREMENT,
  77. `creator_id` int(11) DEFAULT NULL,
  78. `task_id` int(11) DEFAULT NULL,
  79. PRIMARY KEY (`id`)
  80. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  81. INSERT INTO `chats` (`id`, `creator_id`, `task_id`)
  82. VALUES
  83.   (10754, 53058, 15788),
  84.   (10767, 36414, 15788),
  85.   (10778, 61359, 15788),
  86.   (10759, 61359, 15789),
  87.   (10770, 36414, 15789),
  88.   (10961, 10541, 15790),
  89.   (10777, 61359, 15792),
  90.   (10819, 11835, 15793),
  91.   (10766, 4631, 15795),
  92.   (10791, 18461, 15795),
  93.   (10823, 31111, 15795),
  94.   (10874, 11649, 15795),
  95.   (10994, 85902, 15795),
  96.   (10769, 36414, 15797),
  97.   (10776, 61359, 15797),
  98.   (10919, 53058, 15797),
  99.   (10771, 12815, 15798),
  100.   (10775, 83339, 15798),
  101.   (10811, 12745, 15799),
  102.   (11211, 35416, 15799),
  103.   (10793, 4631, 15800),
  104.   (10833, 85902, 15800),
  105.   (10816, 36414, 15802),
  106.   (10806, 36414, 15803),
  107.   (10801, 80049, 15804),
  108.   (10818, 36414, 15804),
  109.   (10824, 11835, 15805),
  110.   (10802, 7240, 15806),
  111.   (10822, 39871, 15806),
  112.   (10838, 79168, 15806),
  113.   (10817, 36414, 15807),
  114.   (10918, 53058, 15807),
  115.   (10809, 33051, 15808),
  116.   (10843, 20435, 15808),
  117.   (10803, 45069, 15809),
  118.   (10804, 5093, 15809),
  119.   (10814, 84699, 15810),
  120.   (10844, 58098, 15810),
  121.   (10847, 95206, 15810),
  122.   (10849, 95105, 15810),
  123.   (10853, 94009, 15810),
  124.   (10854, 94009, 15810),
  125.   (10855, 94009, 15810),
  126.   (10856, 94009, 15810),
  127.   (10857, 94009, 15810),
  128.   (10858, 94009, 15810),
  129.   (10859, 94009, 15810),
  130.   (10860, 94009, 15810),
  131.   (10894, 65435, 15814),
  132.   (11057, 91171, 15815),
  133.   (10975, 85902, 15816),
  134.   (10812, 4631, 15817),
  135.   (10841, 85115, 15818),
  136.   (10903, 87971, 15818),
  137.   (10980, 36414, 15819),
  138.   (10886, 39393, 15821),
  139.   (10825, 11835, 15824),
  140.   (10871, 2919, 15824),
  141.   (11194, 21322, 15824),
  142.   (11137, 94553, 15825),
  143.   (10831, 84932, 15826),
  144.   (10836, 83339, 15826),
  145.   (10839, 8532, 15826),
  146.   (10840, 11967, 15826),
  147.   (10913, 35573, 15827),
  148.   (10983, 36414, 15827),
  149.   (10878, 29425, 15829),
  150.   (10952, 36414, 15831),
  151.   (10845, 10511, 15832),
  152.   (10941, 7240, 15832),
  153.   (10872, 3154, 15834),
  154.   (10897, 36414, 15835),
  155.   (10917, 53058, 15835),
  156.   (11045, 36902, 15835),
  157.   (10879, 29425, 15836),
  158.   (11114, 94682, 15836),
  159.   (10900, 36414, 15837),
  160.   (10846, 4631, 15838),
  161.   (10850, 4631, 15839),
  162.   (10848, 4631, 15841),
  163.   (10852, 4631, 15842),
  164.   (10851, 4631, 15844),
  165.   (10864, 62822, 15845),
  166.   (10889, 85115, 15847);
  167.  
  168. DROP TABLE IF EXISTS `messages`;
  169.  
  170. CREATE TABLE `messages` (
  171. `id` int(11) NOT NULL AUTO_INCREMENT,
  172. `chat_id` int(11) DEFAULT NULL,
  173. `author_id` int(11) DEFAULT NULL,
  174. PRIMARY KEY (`id`)
  175. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  176. INSERT INTO `messages` (`chat_id`, `author_id`)
  177. values
  178.   (10754, 53058),
  179.   (10767, 36414),
  180.   (10778, 61359),
  181.   (10759, 61359),
  182.   (10759, 95158),
  183.   (10770, 36414),
  184.   (10770, 95158),
  185.   (10961, 10541),
  186.   (10961, 86270),
  187.   (10777, 61359),
  188.   (10819, 11835),
  189.   (10819, 14354),
  190.   (10766, 4631),
  191.   (10766, 95161),
  192.   (10791, 95161),
  193.   (10791, 18461),
  194.   (10823, 31111),
  195.   (10874, 11649),
  196.   (10994, 85902),
  197.   (10769, 36414),
  198.   (10776, 61359),
  199.   (10919, 53058),
  200.   (10775, 83339),
  201.   (10775, 72740),
  202.   (10811, 12745),
  203.   (10811, 95163),
  204.   (11211, 35416),
  205.   (11211, 95163),
  206.   (10793, 4631),
  207.   (10793, 93159),
  208.   (10833, 85902),
  209.   (10833, 93159),
  210.   (10816, 36414),
  211.   (10806, 36414),
  212.   (10801, 80049),
  213.   (10818, 36414),
  214.   (10824, 11835),
  215.   (10824, 6983),
  216.   (10802, 7240),
  217.   (10802, 95175),
  218.   (10822, 39871),
  219.   (10838, 79168),
  220.   (10838, 95175),
  221.   (10817, 36414),
  222.   (10817, 95177),
  223.   (10918, 53058),
  224.   (10809, 33051),
  225.   (10809, 80037),
  226.   (10843, 20435),
  227.   (10843, 80037),
  228.   (10803, 45069),
  229.   (10804, 5093),
  230.   (10814, 84699),
  231.   (10814, 95180),
  232.   (10844, 58098),
  233.   (10844, 95180),
  234.   (10847, 95206),
  235.   (10847, 95180),
  236.   (10849, 95105),
  237.   (10849, 95180),
  238.   (10853, 94009),
  239.   (10853, 95180),
  240.   (10894, 65435),
  241.   (10894, 95156),
  242.   (11057, 91171),
  243.   (10975, 85902),
  244.   (10975, 74020),
  245.   (10812, 4631),
  246.   (10812, 74020),
  247.   (10841, 85115),
  248.   (10841, 73604),
  249.   (10903, 87971),
  250.   (10903, 73604),
  251.   (10980, 36414),
  252.   (10980, 95190),
  253.   (10886, 39393),
  254.   (10886, 39132),
  255.   (10825, 11835),
  256.   (10825, 95196),
  257.   (10871, 2919),
  258.   (10871, 95196),
  259.   (11194, 21322),
  260.   (11194, 95196),
  261.   (11137, 94553),
  262.   (10831, 84932),
  263.   (10836, 83339),
  264.   (10839, 8532),
  265.   (10839, 30104),
  266.   (10840, 11967),
  267.   (10913, 35573),
  268.   (10913, 95198),
  269.   (10983, 36414),
  270.   (10878, 29425),
  271.   (10878, 93974),
  272.   (10952, 36414),
  273.   (10845, 33487),
  274.   (10845, 10511),
  275.   (10941, 7240),
  276.   (10872, 3154),
  277.   (10872, 33487),
  278.   (10897, 36414),
  279.   (10897, 88081),
  280.   (10917, 53058),
  281.   (11045, 36902),
  282.   (11045, 88081),
  283.   (10879, 29425),
  284.   (10879, 95204),
  285.   (11114, 94682),
  286.   (10900, 36414),
  287.   (10900, 95205),
  288.   (10846, 4631),
  289.   (10846, 27527),
  290.   (10850, 4631),
  291.   (10850, 93055),
  292.   (10848, 4631),
  293.   (10852, 4631),
  294.   (10852, 95211),
  295.   (10851, 4631),
  296.   (10851, 69400),
  297.   (10864, 62822),
  298.   (10889, 85115);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement