This repository was archived by the owner on Dec 23, 2022. It is now read-only.
Repository navigation
Expand file tree
/
Copy pathrealworld-dump-data-exported.sql
More file actions
87 lines (72 loc) · 12.5 KB
/
Copy pathrealworld-dump-data-exported.sql
File metadata and controls
87 lines (72 loc) · 12.5 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
-- MySQL dump 10.13 Distrib 8.0.22, for Win64 (x86_64)
--
-- Host: 127.0.0.1 Database: realworld_db
-- ------------------------------------------------------
-- Server version 8.0.22-0ubuntu0.20.04.3
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Dumping data for table `article`
--
LOCK TABLES `article` WRITE;
/*!40000 ALTER TABLE `article` DISABLE KEYS */;
INSERT INTO `article` VALUES ('e01b1a18-cbb3-497b-b640-ebf9e0ba40f2','2021-03-31 03:53:40',NULL,NULL,'test-1-1617162820063','test 1','test 1','test 1','d9cc584d-8694-4546-883a-e11fecf1d98c','[\"test 1\"]'),('208cb516-2f47-4406-b378-529c3ca24d20','2021-03-31 03:54:17',NULL,NULL,'test-1-test-2-1617162857588','test 1 test 2','test 1 test 2','test 1 test 2','d9cc584d-8694-4546-883a-e11fecf1d98c','[\"test 1\", \"test 2\"]'),('2b233c83-58cf-4c7e-9405-203496177327','2021-03-31 03:54:38',NULL,NULL,'test-1-test-2-test-3-1617162878476','test 1 test 2 test 3','test 1 test 2 test 3','test 1 test 2 test 3','d9cc584d-8694-4546-883a-e11fecf1d98c','[\"test 1\", \"test 2\", \"test 3\"]'),('43920b5a-b9b4-40b1-86d8-ea83dcf527d3','2021-03-31 03:54:59',NULL,NULL,'test-1-test-2-test-3-test-4-1617162899890','test 1 test 2 test 3 test 4','test 1 test 2 test 3 test 4','test 1 test 2 test 3 test 4','d9cc584d-8694-4546-883a-e11fecf1d98c','[\"test 1\", \"test 2\", \"test 3\", \"test 4\"]'),('acfe8907-1f36-404b-80cc-72dee9474928','2021-03-31 03:55:23',NULL,NULL,'test-1-test-2-test-3-test-4-test-5-1617162923233','test 1 test 2 test 3 test 4 test 5','test 1 test 2 test 3 test 4 test 5','test 1 test 2 test 3 test 4 test 5','d9cc584d-8694-4546-883a-e11fecf1d98c','[\"test 1\", \"test 2\", \"test 3\", \"test 4\", \"test 5\"]'),('314b9b8f-6749-48c1-9436-0bbdacd0a5be','2021-03-31 03:55:49',NULL,NULL,'test-1-test-2-test-3-test-4-test-5-test-6-1617162949089','test 1 test 2 test 3 test 4 test 5 test 6','test 1 test 2 test 3 test 4 test 5 test 6','test 1 test 2 test 3 test 4 test 5 test 6','d9cc584d-8694-4546-883a-e11fecf1d98c','[\"test 1\", \"test 2\", \"test 3\", \"test 4\", \"test 5\", \"test 6\"]'),('5bf8cdd3-7098-4d6e-a8dc-6ecd9ac6157b','2021-03-31 03:56:13',NULL,NULL,'test-1-test-2-test-3-test-4-test-5-test-6-test-7-1617162973704','test 1 test 2 test 3 test 4 test 5 test 6 test 7','test 1 test 2 test 3 test 4 test 5 test 6 test 7','test 1 test 2 test 3 test 4 test 5 test 6 test 7','d9cc584d-8694-4546-883a-e11fecf1d98c','[\"test 1\", \"test 2\", \"test 3\", \"test 4\", \"test 5\", \"test 6\", \"test 7\"]'),('4b6f34f6-9206-42ec-8b38-e1f877f3be22','2021-03-31 03:56:43',NULL,NULL,'test-1-test-2-test-3-test-4-test-5-test-6-test-7-test-8-1617163003963','test 1 test 2 test 3 test 4 test 5 test 6 test 7 test 8','test 1 test 2 test 3 test 4 test 5 test 6 test 7 test 8','test 1 test 2 test 3 test 4 test 5 test 6 test 7 test 8','d9cc584d-8694-4546-883a-e11fecf1d98c','[\"test 1\", \"test 2\", \"test 3\", \"test 4\", \"test 5\", \"test 6\", \"test 7\", \"test 8\"]'),('c8e446f3-d183-4f53-a03e-1ea32f03e547','2021-03-31 03:57:14',NULL,NULL,'test-1-test-2-test-3-test-4-test-5-test-6-test-7-test-8-test-9-1617163034939','test 1 test 2 test 3 test 4 test 5 test 6 test 7 test 8 test 9','test 1 test 2 test 3 test 4 test 5 test 6 test 7 test 8 test 9','test 1 test 2 test 3 test 4 test 5 test 6 test 7 test 8 test 9','d9cc584d-8694-4546-883a-e11fecf1d98c','[\"test 1\", \"test 2\", \"test 3\", \"test 4\", \"test 5\", \"test 6\", \"test 7\", \"test 8\", \"test 9\"]'),('c683574a-9cb7-4217-92cb-cb4cd297d0ed','2021-03-31 03:57:49',NULL,NULL,'test-1-test-2-test-3-test-4-test-5-test-6-test-7-test-8-test-9-test-10-1617163069043','test 1 test 2 test 3 test 4 test 5 test 6 test 7 test 8 test 9 test 10','test 1 test 2 test 3 test 4 test 5 test 6 test 7 test 8 test 9 test 10','test 1 test 2 test 3 test 4 test 5 test 6 test 7 test 8 test 9 test 10','d9cc584d-8694-4546-883a-e11fecf1d98c','[\"test 1\", \"test 2\", \"test 3\", \"test 4\", \"test 5\", \"test 6\", \"test 7\", \"test 8\", \"test 9\", \"test 10\"]'),('5926ac05-b792-4657-9606-fc01b5f38976','2021-03-31 03:58:15',NULL,NULL,'test-1-test-2-test-3-test-4-test-5-test-6-test-7-test-8-test-9-test-10-test-11-1617163095256','test 1 test 2 test 3 test 4 test 5 test 6 test 7 test 8 test 9 test 10 test 11','test 1 test 2 test 3 test 4 test 5 test 6 test 7 test 8 test 9 test 10 test 11','test 1 test 2 test 3 test 4 test 5 test 6 test 7 test 8 test 9 test 10 test 11','d9cc584d-8694-4546-883a-e11fecf1d98c','[\"test 1\", \"test 2\", \"test 3\", \"test 4\", \"test 5\", \"test 6\", \"test 7\", \"test 8\", \"test 9\", \"test 10\", \"test 11\"]'),('81625f3f-a0e3-4e0a-b215-1b7eddbfe3f0','2021-03-31 03:58:49','2021-03-31 03:59:50','2021-03-31 03:59:50','test-1-test-2-test-3-test-4-test-5-test-6-test-7-test-8-test-9-test-10-test-11-test-12-1617163129910','test 1 test 2 test 3 test 4 test 5 test 6 test 7 test 8 test 9 test 10 test 11 test 12 edited','test 1 test 2 test 3 test 4 test 5 test 6 test 7 test 8 test 9 test 10 test 11 test 12 edited','test 1 test 2 test 3 test 4 test 5 test 6 test 7 test 8 test 9 test 10 test 11 test 12 edited','d9cc584d-8694-4546-883a-e11fecf1d98c','[\"test 1\", \"test 2\", \"test 3\", \"test 4\", \"test 5\", \"test 6\", \"test 7\", \"test 8\", \"test 9\", \"test 10\", \"test 11\", \"test 12\"]'),('c6549ffe-0abc-4a87-952f-d048126b57a4','2021-03-31 07:54:26',NULL,NULL,'nhan-2-post-1617177266465','nhan 2 post','fadfa','fafdadf','7b7e61ce-f5e2-49fa-ba3f-4be42dbadcba','[\"afs\"]');
/*!40000 ALTER TABLE `article` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `comment`
--
LOCK TABLES `comment` WRITE;
/*!40000 ALTER TABLE `comment` DISABLE KEYS */;
INSERT INTO `comment` VALUES ('b3285b80-a3e5-4493-aef8-696c66b44d31','2021-03-31 03:59:43','2021-03-31 03:59:46','2021-03-31 03:59:46','test-1-test-2-test-3-test-4-test-5-test-6-test-7-test-8-test-9-test-10-test-11-test-12-1617163129910','d9cc584d-8694-4546-883a-e11fecf1d98c','nhan\n'),('3ca6a465-8137-42b6-8f4c-97e07b542ae0','2021-03-31 07:53:46',NULL,NULL,'test-1-test-2-test-3-test-4-test-5-test-6-test-7-test-8-test-9-test-10-test-11-1617163095256','7b7e61ce-f5e2-49fa-ba3f-4be42dbadcba','nhan 2\n'),('7b42e39c-33b3-4743-b499-a1aba27e40f5','2021-03-31 07:54:00',NULL,NULL,'test-1-test-2-test-3-test-4-test-5-test-6-test-7-test-8-test-9-test-10-test-11-1617163095256','7b7e61ce-f5e2-49fa-ba3f-4be42dbadcba','nhan 2222'),('aa4df510-80dd-4d76-89a1-b672245a6906','2021-03-31 07:54:32',NULL,NULL,'nhan-2-post-1617177266465','7b7e61ce-f5e2-49fa-ba3f-4be42dbadcba','nhan 2'),('44c67ed9-ac83-4cd4-81cb-bf41f64b5f4a','2021-03-31 07:58:03',NULL,NULL,'nhan-2-post-1617177266465','d9cc584d-8694-4546-883a-e11fecf1d98c','nhan');
/*!40000 ALTER TABLE `comment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `favorite`
--
LOCK TABLES `favorite` WRITE;
/*!40000 ALTER TABLE `favorite` DISABLE KEYS */;
INSERT INTO `favorite` VALUES ('62361bc6-868f-4e7b-a260-f7835b0246e3','2021-03-31 04:01:25',NULL,NULL,'d9cc584d-8694-4546-883a-e11fecf1d98c','test-1-test-2-test-3-test-4-test-5-test-6-test-7-test-8-test-9-test-10-1617163069043'),('82b5dad1-abb6-4569-a1d3-568ccc39abb5','2021-03-31 04:01:27',NULL,NULL,'d9cc584d-8694-4546-883a-e11fecf1d98c','test-1-test-2-test-3-test-4-test-5-test-6-test-7-test-8-test-9-test-10-test-11-1617163095256'),('1abddc49-e08f-45b8-8d53-d4267fe4e331','2021-03-31 04:27:19',NULL,NULL,'d9cc584d-8694-4546-883a-e11fecf1d98c','test-1-test-2-test-3-test-4-test-5-test-6-test-7-test-8-test-9-1617163034939'),('b396beda-3883-4726-bfcc-64b3827dc983','2021-03-31 07:53:28','2021-03-31 07:53:53','2021-03-31 07:53:53','7b7e61ce-f5e2-49fa-ba3f-4be42dbadcba','test-1-test-2-test-3-test-4-test-5-test-6-test-7-test-8-test-9-test-10-test-11-1617163095256'),('1cf3495f-7a44-45fe-80be-51dbc20f5d68','2021-03-31 07:53:28',NULL,NULL,'7b7e61ce-f5e2-49fa-ba3f-4be42dbadcba','test-1-test-2-test-3-test-4-test-5-test-6-test-7-test-8-test-9-test-10-1617163069043'),('7a23ec0f-29fa-4d6f-be63-65e4c6c9ea69','2021-03-31 07:53:30',NULL,NULL,'7b7e61ce-f5e2-49fa-ba3f-4be42dbadcba','test-1-test-2-test-3-test-4-test-5-test-6-test-7-test-8-test-9-1617163034939'),('a490c341-c684-4a4b-9ba1-2d5e4b7ea36e','2021-03-31 07:53:31',NULL,NULL,'7b7e61ce-f5e2-49fa-ba3f-4be42dbadcba','test-1-test-2-test-3-test-4-test-5-test-6-test-7-test-8-1617163003963'),('b4b7ac72-6eca-45f9-8332-95bb03c896d0','2021-03-31 07:53:53',NULL,NULL,'7b7e61ce-f5e2-49fa-ba3f-4be42dbadcba','test-1-test-2-test-3-test-4-test-5-test-6-test-7-test-8-test-9-test-10-test-11-1617163095256'),('287b7b5d-35aa-4d02-934e-aaa744adec33','2021-03-31 07:57:49',NULL,NULL,'d9cc584d-8694-4546-883a-e11fecf1d98c','nhan-2-post-1617177266465');
/*!40000 ALTER TABLE `favorite` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `follow`
--
LOCK TABLES `follow` WRITE;
/*!40000 ALTER TABLE `follow` DISABLE KEYS */;
INSERT INTO `follow` VALUES ('2a2e2373-b328-4394-93ad-d7b07b168646','2021-03-31 07:53:23','2021-03-31 07:53:26','2021-03-31 07:53:26','7b7e61ce-f5e2-49fa-ba3f-4be42dbadcba','d9cc584d-8694-4546-883a-e11fecf1d98c'),('1fdf1af0-493b-4a46-bb14-2dcb8ff99097','2021-03-31 07:53:24','2021-03-31 07:53:26','2021-03-31 07:53:26','7b7e61ce-f5e2-49fa-ba3f-4be42dbadcba','d9cc584d-8694-4546-883a-e11fecf1d98c'),('3c07f961-5dce-42f5-8e74-67c5aec04b63','2021-03-31 07:53:26',NULL,NULL,'7b7e61ce-f5e2-49fa-ba3f-4be42dbadcba','d9cc584d-8694-4546-883a-e11fecf1d98c'),('40b04bd0-b504-46ad-b3c4-a3bd0b85ccdd','2021-03-31 07:57:55',NULL,NULL,'d9cc584d-8694-4546-883a-e11fecf1d98c','7b7e61ce-f5e2-49fa-ba3f-4be42dbadcba');
/*!40000 ALTER TABLE `follow` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `tag`
--
LOCK TABLES `tag` WRITE;
/*!40000 ALTER TABLE `tag` DISABLE KEYS */;
INSERT INTO `tag` VALUES ('df4fb8a3-24de-437a-8f62-43ef18594528','2021-03-31 03:53:40','2021-03-31 03:58:49',NULL,'test 1',12),('ffa2e5f6-0f27-45c8-ba46-1ae8ef5d6b07','2021-03-31 03:54:17','2021-03-31 03:58:49',NULL,'test 2',11),('daeb295d-c184-4e96-b59e-69236efcb0ed','2021-03-31 03:54:38','2021-03-31 03:58:49',NULL,'test 3',10),('895d18fb-f314-499a-a251-db34ed9aaeb9','2021-03-31 03:54:59','2021-03-31 03:58:49',NULL,'test 4',9),('41986cc4-8323-4346-aa1a-46a29b17679a','2021-03-31 03:55:23','2021-03-31 03:58:49',NULL,'test 5',8),('bcbe4582-28df-4448-b7a0-9e4708247d57','2021-03-31 03:55:49','2021-03-31 03:58:49',NULL,'test 6',7),('ba96903a-bae7-4442-bb11-362b23c59ea5','2021-03-31 03:56:13','2021-03-31 03:58:49',NULL,'test 7',6),('e617f2b5-3b06-45f7-a3a8-fe398a4482bd','2021-03-31 03:56:44','2021-03-31 03:58:50',NULL,'test 8',5),('9fb8a7fe-d3d1-41bd-a469-4b655949a403','2021-03-31 03:57:15','2021-03-31 03:58:50',NULL,'test 9',4),('87b2e63d-a2f9-4cf7-b7eb-108f2a902973','2021-03-31 03:57:49','2021-03-31 03:58:50',NULL,'test 10',3),('cf8fe456-38d6-4f4a-b621-cde9e0f9e018','2021-03-31 03:58:15','2021-03-31 03:58:50',NULL,'test 11',2),('61a0a7b9-a9ea-4038-bf1b-5540907b4fe9','2021-03-31 03:58:50',NULL,NULL,'test 12',1),('a6a1b622-c216-4f93-97af-22b526de73c9','2021-03-31 07:54:26',NULL,NULL,'afs',1);
/*!40000 ALTER TABLE `tag` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `user`
--
LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES ('d9cc584d-8694-4546-883a-e11fecf1d98c','2021-03-31 03:46:11','2021-03-31 07:59:01',NULL,'user1@email.com','user1','$2b$10$walLTBHYaBZP4VTbpaeJZuvpaEv4blOvlZe.LCllBmovBPRAK6Mzy','my bio','https://images2.minutemediacdn.com/image/upload/c_crop,h_1350,w_2400,x_0,y_303/f_auto,q_auto,w_1100/v1576269707/shape/mentalfloss/610356-gettyimages-1018078858.jpg'),('7b7e61ce-f5e2-49fa-ba3f-4be42dbadcba','2021-03-31 07:53:16','2021-03-31 07:59:56',NULL,'user2@email.com','user2','$2b$10$LAod26WRykEOm8NTalXFxufy71sT8K3wt23bpcGvgMpB9GPuuOYi6',NULL,NULL);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2021-03-31 15:22:43