· last year · Dec 19, 2023, 10:50 PM
1-- MySQL dump 10.13 Distrib 8.0.33, for macos13 (arm64)
2--
3-- Host: localhost Database: social_network
4-- ------------------------------------------------------
5-- Server version 5.7.41
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!50503 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `comments`
20--
21
22DROP TABLE IF EXISTS `comments`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!50503 SET character_set_client = utf8mb4 */;
25CREATE TABLE `comments` (
26 `id` varchar(255) NOT NULL,
27 `content` text NOT NULL,
28 `image_url` varchar(255) DEFAULT NULL,
29 `time` datetime NOT NULL,
30 `creator_id` varchar(255) NOT NULL,
31 `post_id` varchar(255) NOT NULL,
32 `timeline_user_id` varchar(255) NOT NULL,
33 PRIMARY KEY (`id`),
34 KEY `FKt7f0j94mbyal8bamvf1friujw` (`creator_id`),
35 KEY `FKh4c7lvsc298whoyd4w9ta25cr` (`post_id`),
36 KEY `FK7rikt5k37h7euppk8eril83n8` (`timeline_user_id`),
37 CONSTRAINT `FK7rikt5k37h7euppk8eril83n8` FOREIGN KEY (`timeline_user_id`) REFERENCES `users` (`id`),
38 CONSTRAINT `FKh4c7lvsc298whoyd4w9ta25cr` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`),
39 CONSTRAINT `FKt7f0j94mbyal8bamvf1friujw` FOREIGN KEY (`creator_id`) REFERENCES `users` (`id`)
40) ENGINE=InnoDB DEFAULT CHARSET=latin1;
41/*!40101 SET character_set_client = @saved_cs_client */;
42
43--
44-- Dumping data for table `comments`
45--
46
47LOCK TABLES `comments` WRITE;
48/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
49INSERT INTO `comments` VALUES ('5321b9d0-5ea5-4e57-b9ad-bfe1e1a5af9e','Cool','','2023-12-11 18:20:03','98ae659e-daed-4ce8-b565-0925e0cbb05b','67158822-4971-4358-a591-28d8cd117581','1477bbd0-f6fe-40ff-98c6-f844f21a3f44');
50/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
51UNLOCK TABLES;
52
53--
54-- Table structure for table `likes`
55--
56
57DROP TABLE IF EXISTS `likes`;
58/*!40101 SET @saved_cs_client = @@character_set_client */;
59/*!50503 SET character_set_client = utf8mb4 */;
60CREATE TABLE `likes` (
61 `id` varchar(255) NOT NULL,
62 `count` bigint(20) DEFAULT NULL,
63 `post_id` varchar(255) DEFAULT NULL,
64 `user_id` varchar(255) DEFAULT NULL,
65 PRIMARY KEY (`id`),
66 KEY `FKry8tnr4x2vwemv2bb0h5hyl0x` (`post_id`),
67 KEY `FKnvx9seeqqyy71bij291pwiwrg` (`user_id`),
68 CONSTRAINT `FKnvx9seeqqyy71bij291pwiwrg` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
69 CONSTRAINT `FKry8tnr4x2vwemv2bb0h5hyl0x` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`)
70) ENGINE=InnoDB DEFAULT CHARSET=latin1;
71/*!40101 SET character_set_client = @saved_cs_client */;
72
73--
74-- Dumping data for table `likes`
75--
76
77LOCK TABLES `likes` WRITE;
78/*!40000 ALTER TABLE `likes` DISABLE KEYS */;
79INSERT INTO `likes` VALUES ('b93f9ba3-a511-4294-8043-83db51b0ac58',1,'67158822-4971-4358-a591-28d8cd117581','98ae659e-daed-4ce8-b565-0925e0cbb05b');
80/*!40000 ALTER TABLE `likes` ENABLE KEYS */;
81UNLOCK TABLES;
82
83--
84-- Table structure for table `logs`
85--
86
87DROP TABLE IF EXISTS `logs`;
88/*!40101 SET @saved_cs_client = @@character_set_client */;
89/*!50503 SET character_set_client = utf8mb4 */;
90CREATE TABLE `logs` (
91 `id` varchar(255) NOT NULL,
92 `action` varchar(255) DEFAULT NULL,
93 `method` varchar(255) DEFAULT NULL,
94 `table_name` varchar(255) DEFAULT NULL,
95 `time` datetime DEFAULT NULL,
96 `username` varchar(255) DEFAULT NULL,
97 PRIMARY KEY (`id`)
98) ENGINE=InnoDB DEFAULT CHARSET=latin1;
99/*!40101 SET character_set_client = @saved_cs_client */;
100
101--
102-- Dumping data for table `logs`
103--
104
105LOCK TABLES `logs` WRITE;
106/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
107INSERT INTO `logs` VALUES ('003cc828-1131-44b8-a33a-841f5ba466e4','login','POST','-','2023-12-13 11:02:19','nigg'),('0413a29b-c2b8-4c65-8e98-9337ac9fa11d','register','POST','users','2023-12-09 12:14:42','pesho 0'),('08e8b378-1294-43a5-916e-e04501a78d5e','register','POST','users','2023-11-30 17:56:06','pesho 0'),('094c3aa9-e5ff-4056-b2f0-5bbb4ff04f30','register','POST','users','2023-12-08 16:51:59','pesho 0'),('09f85625-aba3-4dfd-a690-07456e4fff8a','register','POST','users','2023-12-07 14:34:43','pesho 0'),('0c427422-f998-4f8d-ba8a-9bc5a07fef16','register','POST','users','2023-12-09 12:14:42','pesho 0'),('0c976bad-8829-49cb-86e9-b210c90a93d4','register','POST','users','2023-12-09 09:16:12','pesho 0'),('0ceb8c40-673d-47ae-b259-04192d40d75f','login','POST','-','2023-12-10 12:20:35','arbuz'),('0e3a3fe4-59cb-4357-be2a-223916a9759d','login','POST','-','2023-12-11 18:14:46','arbuz'),('10bdb5d9-32ff-4760-bdb3-ac205453b1de','register','POST','users','2023-12-13 11:01:30','nigg'),('1159092b-3400-4607-8460-c9f8c55e4fc7','register','POST','users','2023-12-09 15:39:50','pesho 0'),('15160fe8-d1d8-462a-9438-00a7222eca76','addFriend','POST','relationship','2023-12-10 08:22:19','arbuz'),('1971f7bb-71b5-4e88-b822-884f7a1e0d14','login','POST','-','2023-12-10 08:04:26','admin'),('19a5fa19-f4fc-4fae-a0a6-b396f5dff3fe','login','POST','-','2023-12-13 11:01:59','arbuz'),('1bbf9e98-7599-4a7e-b5b1-db6e3541ac6f','register','POST','users','2023-11-30 18:01:51','pesho 0'),('1cf062d8-5ced-4c69-8fc5-52b2fbcfb5e4','register','POST','users','2023-11-30 17:53:34','pesho 0'),('1fcecdbd-d33a-478f-bbbd-82a5376e009c','create','POST','comment','2023-12-11 18:20:03','arbuz'),('21c645b7-d99c-4e7a-b318-6b1865ecb4ed','login','POST','-','2023-12-10 12:15:07','arbuz'),('28fb5e7f-c09f-42e8-8142-8aa6d35ebce5','addFriend','POST','relationship','2023-12-11 18:16:20','user'),('2b1499f4-a522-4e45-b6c1-85cd3379ac0d','login','POST','-','2023-12-10 08:21:43','arbuz'),('3129b3c6-3ea1-4507-aab9-f6bfc6d212f7','login','POST','-','2023-12-11 18:17:51','user'),('3601ac70-eda9-4425-84b9-a92b976e1d82','login','POST','-','2023-12-11 18:19:27','arbuz'),('361a2288-adc9-43a9-ae78-a9cbc92c6f16','acceptFriend','POST','relationship','2023-12-11 18:17:09','arbuz'),('403725b4-11a5-485a-a3d6-df272fa388ad','register','POST','users','2023-12-08 16:39:55','pesho 0'),('42f68ea4-39c6-4a48-95ba-cb16df675958','add','POST','like','2023-12-11 18:20:13','arbuz'),('4cade951-fc04-4229-935f-3b78311d6352','register','POST','users','2023-11-26 21:08:05','admin'),('4cd8b597-fdab-48e4-8ce9-3781c2a404a5','register','POST','users','2023-12-09 12:35:35','pesho 0'),('4ec4707b-9291-4f49-a288-5b9c6166edee','register','POST','users','2023-12-09 09:12:51','pesho 0'),('5614d990-4e96-4d51-bb5e-9388203eae51','register','POST','users','2023-12-09 12:29:34','pesho 0'),('5c40f8aa-0122-4b1d-bfed-5434ba0ec9b2','register','POST','users','2023-12-10 08:21:34','arbuz'),('5e058b11-4fc4-43ed-9d41-8d082984595b','register','POST','users','2023-11-30 18:14:38','pesho 0'),('632fe63f-c2c3-45b7-924b-7a95471f1363','register','POST','users','2023-12-08 17:09:00','pesho 0'),('63ac4615-eaf9-48bf-929c-441b4be699fc','register','POST','users','2023-12-09 09:12:52','pesho 0'),('697145d1-7e8f-4a1f-9027-7a64936c3016','addFriend','POST','relationship','2023-12-13 11:01:45','nigg'),('6af4c712-752e-4850-9797-5ed6b98343d2','register','POST','users','2023-12-08 16:39:56','pesho 0'),('6de28e66-dc9f-4fe3-9d6d-c5367bd2dd21','acceptFriend','POST','relationship','2023-12-13 11:02:05','arbuz'),('71aa9fe7-0189-4ba1-9b3c-b483428eb65b','register','POST','users','2023-12-09 12:20:39','pesho 0'),('7302ff17-a86c-4ca5-950c-fc7cde49a899','register','POST','users','2023-12-08 16:51:04','pesho 0'),('736272b2-dd2b-438a-ab42-d853433d3a2c','register','POST','users','2023-11-30 18:06:57','pesho 0'),('7cd078dd-b763-41d5-ac78-6adfb0fbeeca','register','POST','users','2023-11-30 18:14:38','pesho 0'),('7d0aa871-2618-46c7-a020-fc6cf1ed403d','create','POST','post','2023-12-11 18:19:04','user'),('835c4fc0-3f22-4078-aeba-eecca6c2d661','register','POST','users','2023-12-09 15:39:49','pesho 0'),('8a9d3e51-5d21-4a58-bbb0-9c91d7243c2e','register','POST','users','2023-12-08 16:51:59','pesho 0'),('8e1e58a1-bb5f-4ee8-a46c-391a138d2a50','register','POST','users','2023-11-30 17:56:06','pesho 0'),('92b35dac-8f3a-439e-bab8-2271b6922329','register','POST','users','2023-12-09 12:20:39','pesho 0'),('94e90f00-514e-4365-a369-956f6236eeb1','register','POST','users','2023-12-11 18:16:05','user'),('a4036460-8441-4a7d-9ec8-158354ce9c96','login','POST','-','2023-12-11 18:16:12','user'),('a493dae4-875f-45fa-a7af-1fe47a18dbbc','register','POST','users','2023-11-30 17:53:34','pesho 0'),('aced71b0-5d02-479d-90f1-119fd70afa51','register','POST','users','2023-11-30 18:06:57','pesho 0'),('af0f8fe6-50ed-4ff2-90c9-06fc597b7d04','login','POST','-','2023-12-10 12:20:17','admin'),('b00524b5-fa12-4f17-a50b-bd32287c03da','login','POST','-','2023-11-26 21:42:55','admin'),('bf9b035f-4250-466e-a061-bb84362f8e3f','login','POST','-','2023-12-11 18:16:37','arbuz'),('c2eb9d19-2606-4a3f-a2cb-fa5d03e26411','login','POST','-','2023-12-13 11:01:36','nigg'),('c346c2f3-f54d-4fbd-9c29-08eef3488647','addFriend','POST','relationship','2023-12-11 18:16:23','user'),('c3944391-e482-429b-8eab-b967dfbdcccb','register','POST','users','2023-11-30 18:16:56','pesho 0'),('c4193fef-783f-470a-b6f1-74b23effc355','login','POST','-','2023-11-26 21:35:35','admin'),('c48b64f6-5858-4712-b01f-ffd19d067c0e','register','POST','users','2023-12-09 12:35:35','pesho 0'),('c69186b2-7610-4ca6-8932-4a98693a0cf1','register','POST','users','2023-11-30 18:01:51','pesho 0'),('ccf5c3eb-fde8-40ea-b4e2-651353274b20','register','POST','users','2023-12-08 17:09:00','pesho 0'),('d0410824-d0ac-4582-ad70-67691e875b98','register','POST','users','2023-12-09 12:06:33','pesho 0'),('d0a552bf-8311-4eff-a816-34e7044e5e3d','register','POST','users','2023-12-07 14:34:43','pesho 0'),('d844ea27-c85a-4a1b-821d-0d476afa1718','register','POST','users','2023-12-08 16:51:04','pesho 0'),('e2a8fae3-3113-4bb3-95e7-b5599586a5c7','register','POST','users','2023-12-09 12:06:33','pesho 0'),('e42e9fba-f10c-464a-ac5a-5e7d00896334','acceptFriend','POST','relationship','2023-12-10 12:20:24','admin'),('eb59e8d6-b3b9-4efc-874e-3774a11237cf','register','POST','users','2023-12-09 15:35:29','pesho 0'),('ed18be7a-250e-49f3-a531-9bf58be3205c','register','POST','users','2023-11-30 18:16:57','pesho 0'),('f4646ed5-8039-4bbd-a178-f4f3324dce77','register','POST','users','2023-12-09 12:29:35','pesho 0'),('f6da1415-621c-426e-87df-6fff44cbbfc4','register','POST','users','2023-12-09 09:16:13','pesho 0'),('f7250152-9afd-48cf-b345-b7258368c52c','login','POST','-','2023-12-10 12:20:06','arbuz'),('f943e2a2-2f88-4c1c-b484-fed65277483f','register','POST','users','2023-12-09 15:35:29','pesho 0'),('fdf3360c-b535-4f61-99ea-1e93d29bc294','addFriend','POST','relationship','2023-12-13 11:01:46','nigg');
108/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
109UNLOCK TABLES;
110
111--
112-- Table structure for table `messages`
113--
114
115DROP TABLE IF EXISTS `messages`;
116/*!40101 SET @saved_cs_client = @@character_set_client */;
117/*!50503 SET character_set_client = utf8mb4 */;
118CREATE TABLE `messages` (
119 `id` varchar(255) NOT NULL,
120 `content` text NOT NULL,
121 `status` tinyint(4) DEFAULT '0',
122 `subject` varchar(255) DEFAULT NULL,
123 `time` datetime NOT NULL,
124 `from_user_id` varchar(255) NOT NULL,
125 `relationship_id` varchar(255) NOT NULL,
126 `to_user_id` varchar(255) NOT NULL,
127 PRIMARY KEY (`id`),
128 KEY `FKms9o5dx3lfmikr6k8kyxi030e` (`from_user_id`),
129 KEY `FKi44ugcwnisxccf6b3vwvpafrh` (`relationship_id`),
130 KEY `FK6y0sbofpv484p7yi78nr9hii1` (`to_user_id`),
131 CONSTRAINT `FK6y0sbofpv484p7yi78nr9hii1` FOREIGN KEY (`to_user_id`) REFERENCES `users` (`id`),
132 CONSTRAINT `FKi44ugcwnisxccf6b3vwvpafrh` FOREIGN KEY (`relationship_id`) REFERENCES `relationship` (`id`),
133 CONSTRAINT `FKms9o5dx3lfmikr6k8kyxi030e` FOREIGN KEY (`from_user_id`) REFERENCES `users` (`id`)
134) ENGINE=InnoDB DEFAULT CHARSET=latin1;
135/*!40101 SET character_set_client = @saved_cs_client */;
136
137--
138-- Dumping data for table `messages`
139--
140
141LOCK TABLES `messages` WRITE;
142/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
143INSERT INTO `messages` VALUES ('03ffa713-4b74-48fe-b098-74e6665ceb2d','Hi',0,NULL,'2023-12-11 18:18:01','1477bbd0-f6fe-40ff-98c6-f844f21a3f44','a787a605-e616-48af-80b2-4f91fef7678a','98ae659e-daed-4ce8-b565-0925e0cbb05b'),('0d10cf6a-f82d-44b1-83b3-9039ac2760d2','Hello',1,NULL,'2023-12-13 11:02:14','98ae659e-daed-4ce8-b565-0925e0cbb05b','f8da8f8c-2537-4872-ae1b-2d849355fdd7','efc483af-61f7-4879-999e-eb4695a58554'),('1a45ebf8-9ba2-428a-8774-27f849d0fdcd','hi',0,NULL,'2023-12-13 11:02:28','efc483af-61f7-4879-999e-eb4695a58554','f8da8f8c-2537-4872-ae1b-2d849355fdd7','98ae659e-daed-4ce8-b565-0925e0cbb05b'),('23a47eac-765b-4042-9513-03ecbf528e21','Hi',1,NULL,'2023-12-11 18:17:35','98ae659e-daed-4ce8-b565-0925e0cbb05b','a787a605-e616-48af-80b2-4f91fef7678a','1477bbd0-f6fe-40ff-98c6-f844f21a3f44');
144/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
145UNLOCK TABLES;
146
147--
148-- Table structure for table `pictures`
149--
150
151DROP TABLE IF EXISTS `pictures`;
152/*!40101 SET @saved_cs_client = @@character_set_client */;
153/*!50503 SET character_set_client = utf8mb4 */;
154CREATE TABLE `pictures` (
155 `id` varchar(255) NOT NULL,
156 `cloudinary_public_id` varchar(255) DEFAULT NULL,
157 `description` varchar(255) DEFAULT NULL,
158 `image_url` varchar(255) NOT NULL,
159 `time` datetime NOT NULL,
160 `user_id` varchar(255) NOT NULL,
161 PRIMARY KEY (`id`),
162 KEY `FK5s53tythj7c44tr5tejj42kv` (`user_id`),
163 CONSTRAINT `FK5s53tythj7c44tr5tejj42kv` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
164) ENGINE=InnoDB DEFAULT CHARSET=latin1;
165/*!40101 SET character_set_client = @saved_cs_client */;
166
167--
168-- Dumping data for table `pictures`
169--
170
171LOCK TABLES `pictures` WRITE;
172/*!40000 ALTER TABLE `pictures` DISABLE KEYS */;
173/*!40000 ALTER TABLE `pictures` ENABLE KEYS */;
174UNLOCK TABLES;
175
176--
177-- Table structure for table `posts`
178--
179
180DROP TABLE IF EXISTS `posts`;
181/*!40101 SET @saved_cs_client = @@character_set_client */;
182/*!50503 SET character_set_client = utf8mb4 */;
183CREATE TABLE `posts` (
184 `id` varchar(255) NOT NULL,
185 `content` text NOT NULL,
186 `image_url` varchar(255) DEFAULT NULL,
187 `time` datetime NOT NULL,
188 `user_id` varchar(255) NOT NULL,
189 `timeline_user_id` varchar(255) NOT NULL,
190 PRIMARY KEY (`id`),
191 KEY `FK5lidm6cqbc7u4xhqpxm898qme` (`user_id`),
192 KEY `FKklu6thpiw3x0lhs2aqkp2kpaj` (`timeline_user_id`),
193 CONSTRAINT `FK5lidm6cqbc7u4xhqpxm898qme` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
194 CONSTRAINT `FKklu6thpiw3x0lhs2aqkp2kpaj` FOREIGN KEY (`timeline_user_id`) REFERENCES `users` (`id`)
195) ENGINE=InnoDB DEFAULT CHARSET=latin1;
196/*!40101 SET character_set_client = @saved_cs_client */;
197
198--
199-- Dumping data for table `posts`
200--
201
202LOCK TABLES `posts` WRITE;
203/*!40000 ALTER TABLE `posts` DISABLE KEYS */;
204INSERT INTO `posts` VALUES ('67158822-4971-4358-a591-28d8cd117581','I visit Rome',NULL,'2023-12-11 18:19:04','1477bbd0-f6fe-40ff-98c6-f844f21a3f44','1477bbd0-f6fe-40ff-98c6-f844f21a3f44');
205/*!40000 ALTER TABLE `posts` ENABLE KEYS */;
206UNLOCK TABLES;
207
208--
209-- Table structure for table `relationship`
210--
211
212DROP TABLE IF EXISTS `relationship`;
213/*!40101 SET @saved_cs_client = @@character_set_client */;
214/*!50503 SET character_set_client = utf8mb4 */;
215CREATE TABLE `relationship` (
216 `id` varchar(255) NOT NULL,
217 `status` tinyint(4) NOT NULL DEFAULT '0',
218 `time` datetime NOT NULL,
219 `action_user_id` varchar(255) NOT NULL,
220 `user_one_id` varchar(255) NOT NULL,
221 `user_two_id` varchar(255) NOT NULL,
222 PRIMARY KEY (`id`),
223 KEY `FKiohx951gy5ym172v8oynvssoo` (`action_user_id`),
224 KEY `FKgnhhaxwlbj57j006uke06ywfu` (`user_one_id`),
225 KEY `FKe4inve33uxp6pgcbo3d1lismg` (`user_two_id`),
226 CONSTRAINT `FKe4inve33uxp6pgcbo3d1lismg` FOREIGN KEY (`user_two_id`) REFERENCES `users` (`id`),
227 CONSTRAINT `FKgnhhaxwlbj57j006uke06ywfu` FOREIGN KEY (`user_one_id`) REFERENCES `users` (`id`),
228 CONSTRAINT `FKiohx951gy5ym172v8oynvssoo` FOREIGN KEY (`action_user_id`) REFERENCES `users` (`id`)
229) ENGINE=InnoDB DEFAULT CHARSET=latin1;
230/*!40101 SET character_set_client = @saved_cs_client */;
231
232--
233-- Dumping data for table `relationship`
234--
235
236LOCK TABLES `relationship` WRITE;
237/*!40000 ALTER TABLE `relationship` DISABLE KEYS */;
238INSERT INTO `relationship` VALUES ('6c1281a8-8a21-4af7-943e-df62f971cf2a',0,'2023-12-13 11:01:46','efc483af-61f7-4879-999e-eb4695a58554','efc483af-61f7-4879-999e-eb4695a58554','1477bbd0-f6fe-40ff-98c6-f844f21a3f44'),('80a3537e-21c2-489a-9b20-f92969b0a00c',1,'2023-12-10 12:20:24','e2ad9af1-e2c6-46b4-9e3c-f7211c77063e','98ae659e-daed-4ce8-b565-0925e0cbb05b','e2ad9af1-e2c6-46b4-9e3c-f7211c77063e'),('a787a605-e616-48af-80b2-4f91fef7678a',1,'2023-12-11 18:17:09','98ae659e-daed-4ce8-b565-0925e0cbb05b','1477bbd0-f6fe-40ff-98c6-f844f21a3f44','98ae659e-daed-4ce8-b565-0925e0cbb05b'),('e4258f15-fa30-4517-8b66-e45bce7f502b',0,'2023-12-11 18:16:23','1477bbd0-f6fe-40ff-98c6-f844f21a3f44','1477bbd0-f6fe-40ff-98c6-f844f21a3f44','e2ad9af1-e2c6-46b4-9e3c-f7211c77063e'),('f8da8f8c-2537-4872-ae1b-2d849355fdd7',1,'2023-12-13 11:02:05','98ae659e-daed-4ce8-b565-0925e0cbb05b','efc483af-61f7-4879-999e-eb4695a58554','98ae659e-daed-4ce8-b565-0925e0cbb05b');
239/*!40000 ALTER TABLE `relationship` ENABLE KEYS */;
240UNLOCK TABLES;
241
242--
243-- Table structure for table `roles`
244--
245
246DROP TABLE IF EXISTS `roles`;
247/*!40101 SET @saved_cs_client = @@character_set_client */;
248/*!50503 SET character_set_client = utf8mb4 */;
249CREATE TABLE `roles` (
250 `id` varchar(255) NOT NULL,
251 `authority` varchar(255) NOT NULL,
252 PRIMARY KEY (`id`)
253) ENGINE=InnoDB DEFAULT CHARSET=latin1;
254/*!40101 SET character_set_client = @saved_cs_client */;
255
256--
257-- Dumping data for table `roles`
258--
259
260LOCK TABLES `roles` WRITE;
261/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
262INSERT INTO `roles` VALUES ('35541136-aaa7-4976-94ab-19a768b80427','USER'),('37ecf161-9377-4d39-a16e-ac5e1b1a9983','ROOT'),('fdb614ce-eacd-449a-ad74-884fdb04b0dc','ADMIN');
263/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
264UNLOCK TABLES;
265
266--
267-- Table structure for table `users`
268--
269
270DROP TABLE IF EXISTS `users`;
271/*!40101 SET @saved_cs_client = @@character_set_client */;
272/*!50503 SET character_set_client = utf8mb4 */;
273CREATE TABLE `users` (
274 `id` varchar(255) NOT NULL,
275 `is_account_non_expired` tinyint(1) NOT NULL DEFAULT '1',
276 `is_account_non_locked` tinyint(1) NOT NULL DEFAULT '1',
277 `address` varchar(255) NOT NULL,
278 `background_image_url` text,
279 `city` varchar(255) NOT NULL,
280 `is_credentials_non_expired` tinyint(1) NOT NULL DEFAULT '1',
281 `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
282 `email` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
283 `is_enabled` tinyint(1) NOT NULL DEFAULT '1',
284 `first_name` varchar(255) NOT NULL,
285 `last_name` varchar(255) NOT NULL,
286 `is_online` tinyint(1) NOT NULL DEFAULT '0',
287 `password` varchar(255) NOT NULL,
288 `profile_pic_url` text,
289 `username` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
290 PRIMARY KEY (`id`),
291 UNIQUE KEY `UK_6dotkott2kjsp8vw4d0m25fb7` (`email`),
292 UNIQUE KEY `UK_r43af9ap4edm43mmtq01oddj6` (`username`)
293) ENGINE=InnoDB DEFAULT CHARSET=latin1;
294/*!40101 SET character_set_client = @saved_cs_client */;
295
296--
297-- Dumping data for table `users`
298--
299
300LOCK TABLES `users` WRITE;
301/*!40000 ALTER TABLE `users` DISABLE KEYS */;
302INSERT INTO `users` VALUES ('1477bbd0-f6fe-40ff-98c6-f844f21a3f44',1,1,'user','/static/media/default-background-image.c1edb894.jpg','User',1,0,'user@gmail.com',1,'User','User',0,'$2a$10$Jv54LR4zTEZVWJJH.5KX6ePOzwuPFOPam3h6JP7qNnC9eyKlCsA6a','/static/media/placeholder.91347baa.png','user'),('98ae659e-daed-4ce8-b565-0925e0cbb05b',1,1,'arbuz','/static/media/default-background-image.c1edb894.jpg','Arbuz',1,0,'arbuz@gmail.com',1,'Arbuz','Arbuz',0,'$2a$10$wq6VwtqOgpikU2EJmuKMVuHOVSReG94i3ZVRPL9JNZV2u1h/yRL5K','/static/media/placeholder.91347baa.png','arbuz'),('e2ad9af1-e2c6-46b4-9e3c-f7211c77063e',1,1,'Minsk','aiusodhfiu234','Minsk',1,0,'admin@gmail.com',1,'Admin','Admin',0,'$2a$10$zQbiLBLjA2fkAV/6G7jUJewH79Vn8shInGaq36dCQTIyrmAJQTroW','asdfihuib','admin'),('efc483af-61f7-4879-999e-eb4695a58554',1,1,'nig','/static/media/default-background-image.c1edb894.jpg','nig',1,0,'nig@gmail.com',1,'Nig','Nig',0,'$2a$10$HCRIThlxqWUfDKUZUKrqEOgd7hRrrvxcGORK2CBNYDnqTgJk8.Ceu','/static/media/placeholder.91347baa.png','nigg');
303/*!40000 ALTER TABLE `users` ENABLE KEYS */;
304UNLOCK TABLES;
305
306--
307-- Table structure for table `users_roles`
308--
309
310DROP TABLE IF EXISTS `users_roles`;
311/*!40101 SET @saved_cs_client = @@character_set_client */;
312/*!50503 SET character_set_client = utf8mb4 */;
313CREATE TABLE `users_roles` (
314 `user_id` varchar(255) NOT NULL,
315 `role_id` varchar(255) NOT NULL,
316 PRIMARY KEY (`user_id`,`role_id`),
317 KEY `FKj6m8fwv7oqv74fcehir1a9ffy` (`role_id`),
318 CONSTRAINT `FK2o0jvgh89lemvvo17cbqvdxaa` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
319 CONSTRAINT `FKj6m8fwv7oqv74fcehir1a9ffy` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`)
320) ENGINE=InnoDB DEFAULT CHARSET=latin1;
321/*!40101 SET character_set_client = @saved_cs_client */;
322
323--
324-- Dumping data for table `users_roles`
325--
326
327LOCK TABLES `users_roles` WRITE;
328/*!40000 ALTER TABLE `users_roles` DISABLE KEYS */;
329INSERT INTO `users_roles` VALUES ('1477bbd0-f6fe-40ff-98c6-f844f21a3f44','35541136-aaa7-4976-94ab-19a768b80427'),('98ae659e-daed-4ce8-b565-0925e0cbb05b','35541136-aaa7-4976-94ab-19a768b80427'),('efc483af-61f7-4879-999e-eb4695a58554','35541136-aaa7-4976-94ab-19a768b80427'),('e2ad9af1-e2c6-46b4-9e3c-f7211c77063e','37ecf161-9377-4d39-a16e-ac5e1b1a9983');
330/*!40000 ALTER TABLE `users_roles` ENABLE KEYS */;
331UNLOCK TABLES;
332/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
333
334/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
335/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
336/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
337/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
338/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
339/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
340/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
341
342-- Dump completed on 2023-12-20 1:05:38
343