-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdump-todo-202406111020.sql
286 lines (250 loc) · 49.7 KB
/
dump-todo-202406111020.sql
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
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
-- MySQL dump 10.13 Distrib 8.0.19, for Win64 (x86_64)
--
-- Host: 8.130.163.41 Database: todo
-- ------------------------------------------------------
-- Server version 5.7.44
/*!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 utf8mb4 */;
/*!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 */;
--
-- Table structure for table `chat_message`
--
DROP TABLE IF EXISTS `chat_message`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `chat_message` (
`message_id` bigint(20) NOT NULL AUTO_INCREMENT,
`from_user_id` bigint(20) DEFAULT NULL,
`to_user_id` bigint(20) DEFAULT NULL,
`to_room_id` bigint(20) DEFAULT NULL,
`content` text,
`type` tinyint(4) DEFAULT '0',
`send_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`deleted` tinyint(4) DEFAULT '0',
PRIMARY KEY (`message_id`)
) ENGINE=InnoDB AUTO_INCREMENT=423 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chat_message`
--
LOCK TABLES `chat_message` WRITE;
/*!40000 ALTER TABLE `chat_message` DISABLE KEYS */;
INSERT INTO `chat_message` VALUES (343,26,NULL,1797510657473064961,'大家早上好!',0,'2024-06-07 09:08:51','2024-06-07 09:08:51','2024-06-10 15:06:15',0),(344,25,NULL,1797510657473064961,'努力学习,从我做起',0,'2024-06-07 09:09:09','2024-06-07 09:09:08','2024-06-10 15:02:34',0),(345,25,NULL,1797510657473064961,'美好的一天从学习开始',0,'2024-06-07 09:09:12','2024-06-07 09:09:12','2024-06-10 15:02:34',0),(346,25,NULL,1797510657473064961,'请开始学习吧!',0,'2024-06-07 09:09:23','2024-06-07 09:09:23','2024-06-10 15:02:34',0),(373,26,NULL,1797510657473064961,'http://8.130.163.41:9000/todo-bucket/user/84e782b459484d829a87865dcd011f17.jpg',1,'2024-06-07 10:44:51','2024-06-07 10:44:51','2024-06-07 10:44:51',0),(374,2,NULL,1797510657473064961,'????',0,'2024-06-07 13:56:11','2024-06-07 13:56:10','2024-06-07 13:56:10',0),(376,25,NULL,1797510657473064961,'知识是智慧的火炬',0,'2024-06-10 22:46:01','2024-06-10 14:46:00','2024-06-10 15:03:57',0),(377,2,NULL,1797510657473064961,'每日一言',0,'2024-06-10 22:46:37','2024-06-10 14:46:37','2024-06-10 15:05:59',0),(378,2,NULL,1797510657473064961,'己所不欲,勿施于人',0,'2024-06-10 22:46:45','2024-06-10 14:46:44','2024-06-10 15:04:17',0),(379,2,NULL,1797510657473064961,'我也很喜欢,不只是烟火。',0,'2024-06-10 22:46:47','2024-06-10 14:46:46','2024-06-10 15:04:57',0),(380,2,NULL,1797510657473064961,'书籍备而不读如废纸',0,'2024-06-10 22:46:48','2024-06-10 14:46:47','2024-06-10 15:04:57',0),(381,2,NULL,1797510657473064961,'哈哈哈',0,'2024-06-10 22:46:52','2024-06-10 14:46:52','2024-06-10 14:46:52',0),(382,2,NULL,1797510657473064961,'大家晚上好!',0,'2024-06-10 22:46:55','2024-06-10 14:46:54','2024-06-10 15:06:40',0),(415,2,NULL,1797510657473064961,'这边',0,'2024-06-11 09:43:15','2024-06-11 01:43:15','2024-06-11 01:43:15',0),(416,2,NULL,1797510657473064961,'http://8.130.163.41:9000/todo-bucket/user/8ee1e051bf0045a0a028a831cb826fdc.jpg',1,'2024-06-11 09:43:22','2024-06-11 01:43:21','2024-06-11 01:43:21',0),(417,27,NULL,1797510657473064961,'哦',0,'2024-06-11 09:43:45','2024-06-11 01:43:44','2024-06-11 01:43:44',0),(418,2,NULL,1797510657473064961,'http://8.130.163.41:9000/todo-bucket/user/c89254a5c1b44526a08d42c4be51ff36.jpg',1,'2024-06-11 09:43:47','2024-06-11 01:43:46','2024-06-11 01:43:46',0),(419,27,NULL,1797510657473064961,'选中文字添加待办',0,'2024-06-11 09:44:53','2024-06-11 01:44:53','2024-06-11 01:44:53',0),(420,27,NULL,1797510657473064961,'没说',0,'2024-06-11 09:44:56','2024-06-11 01:44:56','2024-06-11 01:44:56',0),(421,2,NULL,1797510657473064961,'http://8.130.163.41:9000/todo-bucket/user/56bae370c194431f82ced0c152e31e28.jpg',1,'2024-06-11 09:45:11','2024-06-11 01:45:11','2024-06-11 01:45:11',0),(422,2,NULL,1797510657473064961,'http://8.130.163.41:9000/todo-bucket/user/741b036fc196438a9b961d64a7ff4d2b.jpg',1,'2024-06-11 09:45:21','2024-06-11 01:45:21','2024-06-11 01:45:21',0);
/*!40000 ALTER TABLE `chat_message` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `random_word`
--
DROP TABLE IF EXISTS `random_word`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `random_word` (
`word_id` int(11) NOT NULL AUTO_INCREMENT,
`word` varchar(100) DEFAULT NULL,
PRIMARY KEY (`word_id`)
) ENGINE=InnoDB AUTO_INCREMENT=311 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `random_word`
--
LOCK TABLES `random_word` WRITE;
/*!40000 ALTER TABLE `random_word` DISABLE KEYS */;
INSERT INTO `random_word` VALUES (11,'人总是会变的,不要害怕改变哦。'),(13,'我马上去,我会用跑的!'),(14,'百艺通,不如一艺精'),(15,'我不知道将去何方,但我已在路上。'),(16,'愿我等之誓言,超越姓名与身份而永存。'),(19,'我们走过风走过雨,就是没能走进彼此的内心。'),(20,'年轻人,要看清自己,看清世界,才能变得更强'),(21,'用宝珠打扮自己,不如用知识充实自己'),(22,'瞬间的犹豫可是会丧命的,所以我决不会犹豫。'),(23,'现世为梦,夜梦为真。'),(29,'无论你遇见谁,他都是在你生命中该出现的人。'),(30,'人生总有许多意,握在手里的风筝,也会突然断了线。'),(32,'不管你是天才还是秀才,如果坏掉了就只是一堆破烂而已'),(34,'有时失败的一瞬,也许是最真实的一刻。'),(35,'多用心去倾听别人怎么说,不要急着表达你自己的看法'),(37,'要逃避!先改变你自己,要不然什么也改变不了!'),(38,'有些东西,失去了就不能回来。'),(39,'不认输,不逃避,世上没有不停的雨'),(41,'最艰苦之时,便是胜利将到之日'),(48,'离景似是昨日,转眼却已经年。'),(49,'不知不觉之中,我们正是被自己所守护的东西守护着。'),(50,'人的成长,就是战胜自己不成熟的过去。'),(51,'世界也是这样,有绝望的地方,就会有希望产生。'),(52,'健全的灵魂,寄居在健全的精神和健全的肉体之上。'),(64,'怕问路,要迷路'),(65,'我也很喜欢,不只是烟火。'),(66,'为什么喜欢音乐,因为它能替我表达我的悲伤。'),(67,'讳疾忌医的人找不到良药'),(71,'已经无法回来的东西,得到和舍弃都很痛苦。'),(72,'善于发问的人,知识丰富'),(76,'书籍备而不读如废纸'),(77,'人类最大的错误,在于不敢承担圣人的心'),(78,'嫉妒就是承认己不如人'),(79,'一同离去吧,绝不会让你孤单一人。'),(83,'我只做应做之事,无须向任何人解释。'),(87,'走自己的路,让别人去说吧'),(89,'即使过了千年,世界上也有许多事情没有改变。'),(90,'心怀希望,人才能够努力拼搏。'),(91,'能够轻易就放弃的梦想,有存在的价值么?'),(94,'不要说不可能,没有什么不可能'),(96,'逆境中不自弃,顺境中不张扬'),(97,'我们每天的生活,都在重复着一张张地图。'),(102,'我们不管做任何事都不可以半途而废,要坚持到底'),(103,'最暗的夜,才能看见最美的星光,人生也是如此。'),(112,'要超越不可能。'),(113,'即使再可怕的困境,也只有冲上去才能解决。'),(121,'人因为有难忘的记忆而变得坚强,这就是所谓的成长吧。'),(134,'与其被自己的本性牵着走而痛苦,倒不如试着改变自己。'),(142,'最淡的墨水,也胜过最强的记性'),(152,'不管是多坚硬的金属,无法加工就没有利用价值。'),(166,'劳动是知识的源泉;知识是生活的指南'),(170,'认识自己,降伏自己,改变自己,才能改变别人'),(171,'井淘三遍吃好水,人从三师武艺高'),(175,'为了信仰,必须有人牺牲,无论是谁。'),(179,'花朵在绽放前无法预知自己的色彩'),(182,'路还长呢,怎么能在这里就停下。'),(187,'我们的征途是星辰大海。'),(190,'奇迹不是商店里的促销品。'),(195,'智者千虑,必有一失;愚者千虑,必有一得'),(196,'看吧,星星只有在夜里才璀璨夺目啊。'),(200,'志不立,天下无可成之事'),(203,'强者并非赢家,赢家方为强者'),(209,'什么都无法舍弃的人,什么都无法改变。'),(222,'苦到头未必是甜的,而甜到头一定是苦的 。'),(224,'己所不欲,勿施于人'),(228,'我讨厌放弃,没有任何理由!'),(242,'茂盛的禾苗需要水分;成长的少年需要学习'),(250,'人生之所以难,是因为每个人的人生都不一样.'),(253,'搓绳不能松劲,前进不能停顿'),(256,'若不想输给任何人,就得先认清自己的弱小!'),(260,'我们会跑,无论往哪里都靠自己的腿去跑!'),(268,'一个人因为遭遇失败,才会拥有从那里再站起来的强悍。'),(272,'智者把放下当前进,愚者把放下当绝望。'),(280,'世间凡人皆庸于懒,天下才子皆毁于傲。'),(282,'错误不是为了别人才改的过来的,要为了自己而改正。'),(283,'忘川之上,桑梓之下。一半是光,一半是影。'),(293,'你既然已经做出了选择,又何必去问为什么选择。'),(303,'哭泣并不能改变任何事情。'),(304,'不断奔跑才是人生。'),(310,'知识是智慧的火炬');
/*!40000 ALTER TABLE `random_word` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `room`
--
DROP TABLE IF EXISTS `room`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `room` (
`room_id` bigint(20) NOT NULL,
`user_id` bigint(20) DEFAULT NULL,
`room_name` varchar(255) DEFAULT NULL,
`room_avatar` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`deleted` tinyint(4) DEFAULT '0',
PRIMARY KEY (`room_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='自习室表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `room`
--
LOCK TABLES `room` WRITE;
/*!40000 ALTER TABLE `room` DISABLE KEYS */;
INSERT INTO `room` VALUES (1797510657473064961,2,'智慧星球','http://8.130.163.41:9000/todo-bucket/user/jiayou.jpg','2024-06-03 06:08:31','2024-06-11 00:04:39',0),(1800336084617457665,21,'快乐星球','http://8.130.163.41:9000/todo-bucket/user/xingqiu.jpg','2024-06-11 01:15:45','2024-06-11 01:23:23',0),(1800343888015192065,25,'自习室','http://8.130.163.41:9000/todo-bucket/user_default_avatar/random_avator11.png','2024-06-11 01:46:46','2024-06-11 01:46:58',1);
/*!40000 ALTER TABLE `room` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `task`
--
DROP TABLE IF EXISTS `task`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `task` (
`task_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务Id',
`parent_id` bigint(20) DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL COMMENT '用户Id',
`task_name` varchar(255) DEFAULT NULL COMMENT '任务名称',
`type` tinyint(4) DEFAULT '0',
`clock_duration` int(11) DEFAULT '0' COMMENT '番茄钟时长',
`task_status` tinyint(4) DEFAULT NULL COMMENT '任务状态',
`remark` varchar(100) DEFAULT NULL COMMENT '备注',
`estimate` varchar(255) DEFAULT '1' COMMENT '预估番茄数',
`rest_time` int(11) DEFAULT '5' COMMENT '自定义休息时间',
`again` tinyint(4) DEFAULT '0' COMMENT '完成后第二天是否再次显示',
`category_id` int(11) DEFAULT NULL COMMENT '任务分类',
`background` varchar(255) DEFAULT NULL COMMENT '任务背景',
`started_at` timestamp NULL DEFAULT NULL COMMENT '开始时间',
`completed_at` timestamp NULL DEFAULT NULL COMMENT '完成时间',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
`deleted` int(11) DEFAULT '0' COMMENT '是否删除',
PRIMARY KEY (`task_id`),
KEY `task_task_status_IDX` (`task_status`) USING BTREE,
KEY `task_parent_id_IDX` (`parent_id`) USING BTREE,
KEY `task_user_id_IDX` (`user_id`) USING BTREE,
KEY `task_created_at_IDX` (`created_at`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=934 DEFAULT CHARSET=utf8mb4 COMMENT='任务表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `task`
--
LOCK TABLES `task` WRITE;
/*!40000 ALTER TABLE `task` DISABLE KEYS */;
INSERT INTO `task` VALUES (227,1794377081413595137,2,'学习算法',0,30,2,NULL,'2',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/237.jpg','2024-05-26 06:30:31','2024-05-26 07:35:33','2024-05-26 05:43:00','2024-05-26 07:35:33',0),(230,1794377081413595137,2,'学习算法',0,20,2,NULL,'3',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/237.jpg','2024-05-27 02:46:52','2024-05-27 02:46:52','2024-05-27 01:36:49','2024-05-27 02:46:52',0),(232,1794388931987628034,2,'学习Linux',1,25,2,NULL,'1',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/73.jpg','2024-05-26 01:23:54','2024-05-26 01:48:59','2024-05-26 01:23:50','2024-05-27 15:23:13',0),(241,1794578784941846530,2,'算法测试',1,42,2,'','1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/44.jpg','2024-05-26 07:03:37','2024-05-26 07:45:46','2024-05-26 07:01:37','2024-05-27 15:23:20',0),(243,1794377081413595137,2,'学习算法',0,20,0,NULL,'3',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/237.jpg',NULL,NULL,'2024-05-27 19:30:00','2024-05-27 14:32:39',0),(245,1794578784941846530,2,'算法测试',0,35,2,'','1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/44.jpg','2024-05-27 05:37:01','2024-05-27 06:12:06','2024-05-27 05:31:01','2024-05-27 15:23:27',0),(286,1795010247025831937,2,'项目实训',0,30,2,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/415.jpg','2024-05-27 08:33:24','2024-05-27 07:03:25','2024-05-27 08:32:47','2024-05-27 07:03:25',0),(288,1795011301054427137,2,'习思想笔记',0,20,2,NULL,'3',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/373.jpg','2024-05-03 01:01:08','2024-05-03 02:11:12','2024-05-03 01:00:01','2024-05-03 02:11:12',0),(289,1795011803657875457,2,'Java学习',0,60,2,NULL,'1',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/226.jpg','2024-05-16 06:39:08','2024-05-16 07:39:12','2024-05-16 06:39:08','2024-05-16 07:39:12',0),(290,1795012038274658306,2,'Android学习',0,30,2,NULL,'1',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/120.jpg','2024-05-20 08:12:58','2024-05-20 08:42:58','2024-05-20 08:00:18','2024-05-20 08:42:58',0),(291,1795012687657775106,2,'跑步',0,15,2,NULL,'2',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/367.jpg','2024-05-01 01:15:57','2024-05-01 01:50:58','2024-05-01 01:15:57','2024-05-01 01:50:58',0),(399,1795124961563193345,2,'堆栈测试题',0,30,0,NULL,'3',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/365.jpg',NULL,NULL,'2024-05-26 16:08:37','2024-05-26 16:08:37',0),(400,1795125835706478594,2,'数据库测试题',0,30,0,NULL,'3',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/189.jpg',NULL,NULL,'2024-05-26 16:12:06','2024-05-26 16:12:06',0),(401,1795126139537666050,2,'Java测试题',0,30,0,NULL,'3',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/148.jpg',NULL,NULL,'2024-05-27 01:13:18','2024-05-27 01:13:18',0),(402,1795126139537666050,2,'Java测试题',0,30,2,NULL,'2',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/148.jpg','2024-05-28 00:41:46','2024-05-28 01:11:46','2024-05-28 00:41:46','2024-05-28 01:07:37',0),(403,1795126139537666050,2,'Java测试题',0,30,0,NULL,'3',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/148.jpg',NULL,NULL,'2024-05-26 02:11:18','2024-05-27 01:13:18',0),(404,1794578784941846530,2,'算法测试',0,35,0,'','1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/44.jpg',NULL,NULL,'2024-05-28 05:31:01','2024-05-27 16:23:39',0),(405,1795010247025831937,2,'项目实训',0,30,2,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/415.jpg','2024-05-28 00:01:17','2024-05-28 00:31:17','2024-05-28 00:01:17','2024-05-28 01:04:57',0),(406,1794377081413595137,2,'学习算法',0,20,0,NULL,'3',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/237.jpg',NULL,NULL,'2024-05-28 19:30:00','2024-05-27 14:32:39',0),(432,1795126139537666050,2,'Java测试题',0,30,0,NULL,'2',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/148.jpg',NULL,NULL,'2024-05-29 02:11:18','2024-05-28 09:45:05',0),(433,1794578784941846530,2,'算法测试',0,35,0,'','1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/44.jpg',NULL,NULL,'2024-05-29 05:31:01','2024-05-27 16:23:39',0),(434,1795010247025831937,2,'项目实训',0,30,2,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/415.jpg','2024-05-29 00:01:47','2024-05-28 16:10:36','2024-05-29 00:00:47','2024-05-28 16:13:14',0),(435,1795257028028477442,2,'Git学习',0,30,2,NULL,'2',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/172.jpg','2024-04-28 05:53:50','2024-04-28 06:58:51','2024-04-28 05:45:50','2024-04-28 06:58:51',0),(436,1795261266175537154,2,'Srping深入学习',0,25,2,NULL,'1',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/457.jpg','2024-04-18 00:25:50','2024-04-18 00:50:50','2024-04-17 23:05:50','2024-04-18 00:50:50',0),(437,1795262638996402177,2,'Gson学习',0,30,2,NULL,'1',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/325.jpg','2024-04-23 01:15:49','2024-04-23 01:15:49','2024-04-23 01:15:49','2024-04-23 01:15:49',0),(438,1795263516784537602,2,'Knife4j学习',0,30,0,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/391.jpg',NULL,NULL,'2024-04-28 00:19:11','2024-04-28 00:19:11',0),(439,1795263516784537602,2,'Knife4j学习',0,30,0,NULL,'1',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/391.jpg',NULL,NULL,'2024-04-29 00:19:11','2024-04-29 00:19:11',0),(440,1795264695337824257,2,'Minio学习',0,30,0,NULL,'1',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/250.jpg',NULL,NULL,'2024-05-01 01:23:52','2024-05-01 01:23:52',0),(455,1795430455083347970,2,'提醒贴',2,1,2,'','1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/103.jpg','2024-05-28 12:39:52','2024-05-28 12:39:52','2024-05-28 12:22:33','2024-05-28 14:49:51',0),(456,1795430455083347970,2,'提醒贴',2,1,0,'','1',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/103.jpg',NULL,NULL,'2024-05-29 12:22:33','2024-06-06 00:49:56',0),(468,1794377081413595137,2,'学习算法',0,20,0,NULL,'3',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/237.jpg',NULL,NULL,'2024-05-29 19:30:00','2024-06-06 00:51:24',0),(494,1795126139537666050,2,'Java测试题',0,30,0,NULL,'2',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/148.jpg',NULL,NULL,'2024-05-30 02:11:18','2024-06-06 00:51:24',0),(495,1794578784941846530,2,'算法测试',0,35,0,'','1',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/44.jpg',NULL,NULL,'2024-05-30 05:31:01','2024-06-06 00:51:24',0),(496,1795010247025831937,2,'项目实训',0,30,0,NULL,'1',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/415.jpg',NULL,NULL,'2024-05-30 00:00:47','2024-06-06 00:51:24',0),(841,1800184482996744193,2,'Hash索引',1,30,2,NULL,'1',5,0,63,'http://8.130.163.41:9000/todo-bucket/background/179.jpg','2024-06-10 13:52:34','2024-06-10 14:33:34','2024-06-10 13:43:34','2024-06-10 14:33:34',0),(842,1800184710562902018,2,'B-Tree索引 ',1,30,1,NULL,'1',5,0,63,'http://8.130.163.41:9000/todo-bucket/background/507.jpg',NULL,NULL,'2024-06-10 23:14:15','2024-06-10 15:27:39',0),(843,1800185203787886594,2,'Trigger触发器',0,25,2,NULL,'1',5,0,63,'http://8.130.163.41:9000/todo-bucket/background/4.jpg','2024-06-10 14:52:34','2024-06-10 15:17:34','2024-06-10 14:32:34','2024-06-10 15:17:34',0),(844,1800185335019270146,2,'DDL语言',1,25,1,NULL,'1',5,0,63,'http://8.130.163.41:9000/todo-bucket/background/532.jpg',NULL,NULL,'2024-06-10 23:16:44','2024-06-10 15:27:40',0),(845,1800185377075556354,2,'DML语言',1,25,1,NULL,'1',5,0,63,'http://8.130.163.41:9000/todo-bucket/background/147.jpg',NULL,NULL,'2024-06-10 23:16:54','2024-06-10 15:27:40',0),(846,1800185490992852993,2,'Mysql函数',0,25,1,NULL,'3',5,0,63,'http://8.130.163.41:9000/todo-bucket/background/76.jpg',NULL,NULL,'2024-06-10 23:17:22','2024-06-10 15:27:40',0),(847,1800185782383734785,2,'函数式编程',0,30,1,NULL,'1',5,0,64,'http://8.130.163.41:9000/todo-bucket/background/173.jpg',NULL,NULL,'2024-06-10 23:18:31','2024-06-10 15:27:40',0),(848,1800185841632473089,2,'流式编程',0,30,1,NULL,'1',5,0,64,'http://8.130.163.41:9000/todo-bucket/background/59.jpg',NULL,NULL,'2024-06-10 23:18:45','2024-06-10 15:27:40',0),(849,1800185891641159681,2,'Spring框架',0,30,1,NULL,'1',5,0,64,'http://8.130.163.41:9000/todo-bucket/background/351.jpg',NULL,NULL,'2024-06-10 23:18:57','2024-06-10 15:27:41',0),(850,1800185980719788034,2,'Mybatis',1,30,1,NULL,'1',5,0,64,'http://8.130.163.41:9000/todo-bucket/background/413.jpg',NULL,NULL,'2024-06-10 23:19:18','2024-06-10 15:27:41',0),(851,1800186132767502338,2,'设计模式',0,30,1,NULL,'1',5,0,64,'http://8.130.163.41:9000/todo-bucket/background/150.jpg',NULL,NULL,'2024-06-10 23:19:55','2024-06-10 15:27:41',0),(852,1800186181849247746,2,'并发编程',0,30,1,NULL,'1',5,0,64,'http://8.130.163.41:9000/todo-bucket/background/515.jpg',NULL,NULL,'2024-06-10 23:20:06','2024-06-10 15:27:41',0),(853,1800186387739242498,2,'枚举',0,30,1,NULL,'2',5,0,64,'http://8.130.163.41:9000/todo-bucket/background/14.jpg',NULL,NULL,'2024-06-10 23:20:55','2024-06-10 15:27:41',0),(854,1800186705126420481,2,'Activity学习',0,30,1,NULL,'2',5,0,65,'http://8.130.163.41:9000/todo-bucket/background/420.jpg',NULL,NULL,'2024-06-10 23:22:11','2024-06-10 15:27:41',0),(855,1800186758222114818,2,'Service学习',0,30,1,NULL,'2',5,0,65,'http://8.130.163.41:9000/todo-bucket/background/312.jpg',NULL,NULL,'2024-06-10 23:22:24','2024-06-10 15:27:42',0),(856,1800186986681659394,2,'Content Provider学习',0,30,1,NULL,'1',5,0,65,'http://8.130.163.41:9000/todo-bucket/background/439.jpg',NULL,NULL,'2024-06-10 23:23:18','2024-06-10 15:27:42',0),(857,1800187046660206593,2,'Broadcast Receiver学习',0,25,1,NULL,'1',5,0,65,'http://8.130.163.41:9000/todo-bucket/background/371.jpg',NULL,NULL,'2024-06-10 23:23:32','2024-06-10 15:27:42',0),(858,1800187174250934273,2,'SmartRefreshLayout学习',0,25,1,NULL,'1',5,0,65,'http://8.130.163.41:9000/todo-bucket/background/217.jpg',NULL,NULL,'2024-06-10 23:24:03','2024-06-10 15:27:42',0),(859,1800187353398046721,2,'二分查找',0,25,1,NULL,'2',5,0,66,'http://8.130.163.41:9000/todo-bucket/background/29.jpg',NULL,NULL,'2024-06-10 23:24:46','2024-06-10 15:27:42',0),(860,1800187402639175681,2,'有序数组的平方',0,25,1,NULL,'2',5,0,66,'http://8.130.163.41:9000/todo-bucket/background/231.jpg',NULL,NULL,'2024-06-10 23:24:57','2024-06-10 15:27:43',0),(861,1800187468095483906,2,'反转链表',1,30,1,NULL,'1',5,0,66,'http://8.130.163.41:9000/todo-bucket/background/51.jpg',NULL,NULL,'2024-06-10 23:25:13','2024-06-10 15:27:43',0),(862,1800187575280922626,2,'反转字符串',0,30,1,NULL,'2',5,0,66,'http://8.130.163.41:9000/todo-bucket/background/274.jpg',NULL,NULL,'2024-06-10 23:25:38','2024-06-10 15:27:43',0),(863,1800187725600583681,2,'有效的括号',0,30,1,NULL,'2',5,0,66,'http://8.130.163.41:9000/todo-bucket/background/137.jpg',NULL,NULL,'2024-06-10 23:26:14','2024-06-10 15:27:43',0),(864,1800187827786412034,2,'翻转二叉树',0,30,1,NULL,'1',5,0,66,'http://8.130.163.41:9000/todo-bucket/background/147.jpg',NULL,NULL,'2024-06-10 23:26:39','2024-06-10 15:27:43',0),(868,1800184482996744193,2,'Hash索引',1,30,1,NULL,'1',5,0,63,'http://8.130.163.41:9000/todo-bucket/background/179.jpg',NULL,NULL,'2024-06-11 23:13:21','2024-06-10 15:30:00',0),(869,1800184710562902018,2,'B-Tree索引 ',1,30,1,NULL,'1',5,0,63,'http://8.130.163.41:9000/todo-bucket/background/507.jpg',NULL,NULL,'2024-06-11 23:14:15','2024-06-10 15:30:00',0),(870,1800185203787886594,2,'Trigger触发器',0,25,1,NULL,'1',5,0,63,'http://8.130.163.41:9000/todo-bucket/background/4.jpg',NULL,NULL,'2024-06-11 23:16:13','2024-06-10 15:30:00',0),(871,1800185335019270146,2,'DDL语言',1,25,1,NULL,'1',5,0,63,'http://8.130.163.41:9000/todo-bucket/background/532.jpg',NULL,NULL,'2024-06-11 23:16:44','2024-06-10 15:30:00',0),(872,1800185377075556354,2,'DML语言',1,25,1,NULL,'1',5,0,63,'http://8.130.163.41:9000/todo-bucket/background/147.jpg',NULL,NULL,'2024-06-11 23:16:54','2024-06-10 15:30:00',0),(873,1800185490992852993,2,'Mysql函数',0,25,1,NULL,'3',5,0,63,'http://8.130.163.41:9000/todo-bucket/background/76.jpg',NULL,NULL,'2024-06-11 23:17:22','2024-06-10 15:30:00',0),(874,1800185782383734785,2,'函数式编程',0,30,1,NULL,'1',5,0,64,'http://8.130.163.41:9000/todo-bucket/background/173.jpg',NULL,NULL,'2024-06-11 23:18:31','2024-06-10 15:30:00',0),(875,1800185841632473089,2,'流式编程',0,30,1,NULL,'1',5,0,64,'http://8.130.163.41:9000/todo-bucket/background/59.jpg',NULL,NULL,'2024-06-11 23:18:45','2024-06-10 15:30:00',0),(876,1800185891641159681,2,'Spring框架',0,30,1,NULL,'1',5,0,64,'http://8.130.163.41:9000/todo-bucket/background/351.jpg',NULL,NULL,'2024-06-11 23:18:57','2024-06-10 15:30:00',0),(877,1800185980719788034,2,'Mybatis',1,30,1,NULL,'1',5,0,64,'http://8.130.163.41:9000/todo-bucket/background/413.jpg',NULL,NULL,'2024-06-11 23:19:18','2024-06-10 15:30:00',0),(878,1800186132767502338,2,'设计模式',0,30,1,NULL,'1',5,0,64,'http://8.130.163.41:9000/todo-bucket/background/150.jpg',NULL,NULL,'2024-06-11 23:19:55','2024-06-10 15:30:00',0),(879,1800186181849247746,2,'并发编程',0,30,1,NULL,'1',5,0,64,'http://8.130.163.41:9000/todo-bucket/background/515.jpg',NULL,NULL,'2024-06-11 23:20:06','2024-06-10 15:30:00',0),(880,1800186387739242498,2,'枚举',0,30,1,NULL,'2',5,0,64,'http://8.130.163.41:9000/todo-bucket/background/14.jpg',NULL,NULL,'2024-06-11 23:20:55','2024-06-10 15:30:00',0),(881,1800186705126420481,2,'Activity学习',0,30,1,NULL,'2',5,0,65,'http://8.130.163.41:9000/todo-bucket/background/420.jpg',NULL,NULL,'2024-06-11 23:22:11','2024-06-10 15:30:00',0),(882,1800186758222114818,2,'Service学习',0,30,1,NULL,'2',5,0,65,'http://8.130.163.41:9000/todo-bucket/background/312.jpg',NULL,NULL,'2024-06-11 23:22:24','2024-06-10 15:30:00',0),(883,1800186986681659394,2,'Content Provider学习',0,30,1,NULL,'1',5,0,65,'http://8.130.163.41:9000/todo-bucket/background/439.jpg',NULL,NULL,'2024-06-11 23:23:18','2024-06-10 15:30:00',0),(884,1800187046660206593,2,'Broadcast Receiver学习',0,25,1,NULL,'1',5,0,65,'http://8.130.163.41:9000/todo-bucket/background/371.jpg',NULL,NULL,'2024-06-11 23:23:32','2024-06-10 15:30:00',0),(885,1800187174250934273,2,'SmartRefreshLayout学习',0,25,1,NULL,'1',5,0,65,'http://8.130.163.41:9000/todo-bucket/background/217.jpg',NULL,NULL,'2024-06-11 23:24:03','2024-06-10 15:30:00',0),(886,1800187353398046721,2,'二分查找',0,25,1,NULL,'2',5,0,66,'http://8.130.163.41:9000/todo-bucket/background/29.jpg','2024-06-11 08:39:40',NULL,'2024-06-11 23:24:46','2024-06-11 00:39:39',0),(887,1800187402639175681,2,'有序数组的平方',0,25,1,NULL,'2',5,0,66,'http://8.130.163.41:9000/todo-bucket/background/231.jpg',NULL,NULL,'2024-06-11 23:24:57','2024-06-10 15:30:00',0),(888,1800187468095483906,2,'反转链表',1,30,1,NULL,'1',5,0,66,'http://8.130.163.41:9000/todo-bucket/background/51.jpg',NULL,NULL,'2024-06-11 23:25:13','2024-06-10 15:30:00',0),(889,1800187575280922626,2,'反转字符串',0,30,1,NULL,'2',5,0,66,'http://8.130.163.41:9000/todo-bucket/background/274.jpg',NULL,NULL,'2024-06-11 23:25:38','2024-06-10 15:30:00',0),(890,1800187725600583681,2,'有效的括号',0,30,1,NULL,'2',5,0,66,'http://8.130.163.41:9000/todo-bucket/background/137.jpg',NULL,NULL,'2024-06-11 23:26:14','2024-06-10 15:30:00',0),(891,1800187827786412034,2,'翻转二叉树',0,30,1,NULL,'1',5,0,66,'http://8.130.163.41:9000/todo-bucket/background/147.jpg',NULL,NULL,'2024-06-11 23:26:39','2024-06-10 15:30:00',0),(892,1800188698758803458,2,'LeetCode每日一题',0,25,2,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/420.jpg','2024-06-10 08:15:50','2024-06-10 08:40:52','2024-06-10 08:10:17','2024-06-10 16:01:16',0),(893,1800188698758803458,2,'LeetCode每日一题',0,25,2,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/420.jpg','2024-06-11 08:11:50','2024-06-11 08:36:50','2024-06-11 08:10:17','2024-06-11 08:36:50',0),(894,1800189129216028673,2,'习思想测试题',0,25,2,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/492.jpg','2024-06-10 08:51:31','2024-06-10 09:16:32','2024-06-10 08:11:31','2024-06-10 16:01:17',0),(895,1800189129216028673,2,'习思想测试题',0,25,0,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/492.jpg','2024-06-11 09:40:25',NULL,'2024-06-11 08:11:31','2024-06-11 01:40:25',0),(896,1800189194114494465,2,'项目实训',0,25,0,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/444.jpg',NULL,NULL,'2024-06-10 09:40:04','2024-06-10 16:01:17',0),(897,1800189194114494465,2,'项目实训',0,25,0,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/444.jpg',NULL,NULL,'2024-06-11 09:40:04','2024-06-10 16:01:17',0),(900,1800189525242212354,2,'算法深入学习',0,30,2,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/230.jpg','2024-06-10 10:19:31','2024-06-10 10:49:31','2024-06-10 10:01:27','2024-06-10 16:01:17',0),(901,1800189525242212354,2,'算法深入学习',0,30,0,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/230.jpg',NULL,NULL,'2024-06-11 10:01:27','2024-06-10 16:01:18',0),(902,1800189636462571522,2,'Docker深入学习',0,30,0,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/317.jpg',NULL,NULL,'2024-06-10 11:33:50','2024-06-10 16:01:18',0),(903,1800189636462571522,2,'Docker深入学习',0,30,0,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/317.jpg',NULL,NULL,'2024-06-11 11:33:50','2024-06-10 16:01:18',0),(904,1800189779173765121,2,'Docker学习检验',0,30,0,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/271.jpg',NULL,NULL,'2024-06-10 11:34:24','2024-06-10 16:01:18',0),(905,1800189779173765121,2,'Docker学习检验',0,30,2,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/271.jpg','2024-06-11 09:14:45','2024-06-11 09:44:45','2024-06-11 09:14:45','2024-06-10 16:16:52',0),(906,1800190083030118401,2,'上课提醒贴',2,0,0,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/297.jpg',NULL,NULL,'2024-06-10 11:35:36','2024-06-10 16:01:18',0),(907,1800190083030118401,2,'上课提醒贴',2,0,0,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/297.jpg',NULL,NULL,'2024-06-11 11:35:36','2024-06-10 16:01:19',0),(908,1800188698758803458,2,'LeetCode每日一题',0,25,2,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/297.jpg','2024-06-09 09:12:18','2024-06-09 09:37:19','2024-06-09 08:10:17','2024-06-10 16:01:19',0),(909,1800190083030118401,2,'上课提醒贴',2,0,0,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/297.jpg',NULL,NULL,'2024-06-09 11:35:36','2024-06-10 16:01:19',0),(910,1800189129216028673,2,'习思想测试题',0,25,2,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/297.jpg','2024-06-09 10:40:25','2024-06-10 23:58:48','2024-06-09 10:37:25','2024-06-10 16:01:19',0),(911,1800189636462571522,2,'Docker深入学习',0,30,0,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/317.jpg',NULL,NULL,'2024-06-09 11:33:50','2024-06-10 16:01:18',0),(912,1800189129216028673,2,'习思想测试题',0,25,0,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/492.jpg',NULL,NULL,'2024-06-09 08:11:31','2024-06-10 16:01:17',0),(913,1800189129216028673,2,'习思想测试题',0,25,0,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/492.jpg',NULL,NULL,'2024-06-08 08:11:31','2024-06-08 08:11:31',0),(914,1800200644845432834,2,'牛客网刷题',0,30,0,NULL,'1',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/130.jpg','2024-06-01 08:18:39',NULL,'2024-06-01 08:17:34','2024-06-10 16:28:17',0),(915,1800200725191520257,2,'代码随想录',0,30,0,NULL,'1',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/115.jpg',NULL,NULL,'2024-06-01 09:34:54','2024-06-01 09:34:54',0),(916,1800200761325449218,2,'项目实训',0,30,0,NULL,'1',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/179.jpg',NULL,NULL,'2024-06-04 11:18:02','2024-06-04 11:18:02',0),(917,1800200914035863553,2,'长跑',0,30,0,NULL,'1',5,1,NULL,'http://8.130.163.41:9000/todo-bucket/background/544.jpg',NULL,NULL,'2024-06-07 13:15:04','2024-06-07 13:15:04',0),(918,1800202283585171457,2,'Mysql优化',0,30,0,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/428.jpg','2024-06-11 07:24:15',NULL,'2024-06-11 07:23:22','2024-06-11 07:24:15',0),(919,1800209402803843074,25,'666',0,25,2,'','1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/94.jpg','2024-06-11 01:04:00','2024-06-11 01:04:08','2024-06-11 00:52:23','2024-06-10 23:07:14',1),(920,1800209464653049858,25,'365',0,25,2,'','1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/140.jpg','2024-06-11 01:04:14','2024-06-11 01:04:22','2024-06-11 00:52:37','2024-06-10 17:05:25',1),(921,1800209530709143554,25,'741',0,1,2,'','1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/71.jpg','2024-06-11 00:52:54','2024-06-11 00:53:58','2024-06-11 00:52:53','2024-06-10 16:54:06',0),(922,1800210014987677698,25,'高等数学',0,25,1,'','1',5,0,67,'http://8.130.163.41:9000/todo-bucket/background/484.jpg',NULL,NULL,'2024-06-11 00:54:49','2024-06-10 16:54:48',0),(923,1800319319682379778,2,'123',0,1,0,'','1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/491.jpg','2024-06-11 09:41:29',NULL,'2024-06-11 08:09:09','2024-06-11 01:41:29',0),(924,1800326394441428993,26,'Spring学习',0,30,2,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/459.jpg','2024-06-11 08:14:51','2024-06-11 08:44:51','2024-06-11 08:03:16','2024-06-11 08:44:51',0),(925,1800327358833553410,26,'今日一题',0,25,2,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/502.jpg','2024-06-11 08:49:20','2024-06-11 09:14:20','2024-06-11 08:49:20','2024-06-11 09:14:20',0),(926,1800328109857239041,2,'147',0,1,0,'','1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/286.jpg',NULL,NULL,'2024-06-11 08:44:05','2024-06-11 00:44:04',0),(927,1800328168325836801,2,'258',0,25,0,'','1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/99.jpg',NULL,NULL,'2024-06-11 08:44:18','2024-06-11 00:44:18',0),(928,1800328249548533761,2,'凌风龙',0,25,1,'','1',5,0,66,'http://8.130.163.41:9000/todo-bucket/background/5.jpg',NULL,NULL,'2024-06-11 08:44:38','2024-06-11 00:44:37',0),(929,1800328519049342977,25,'Java测试题',1,25,2,NULL,'1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/41.jpg','2024-06-11 08:14:25','2024-06-11 08:46:34','2024-06-11 08:10:25','2024-06-11 08:46:34',0),(930,1800329413920878594,25,'每日一题',0,25,2,NULL,'2',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/191.jpg','2024-06-11 08:49:21','2024-06-11 08:49:24','2024-06-11 08:47:15','2024-06-11 08:49:24',0),(931,1800342279264727042,2,'123',0,25,0,'','1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/215.jpg',NULL,NULL,'2024-06-11 09:40:23','2024-06-11 01:40:22',0),(932,1800343795983773697,25,'147',0,35,0,'','1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/523.jpg',NULL,NULL,'2024-06-11 09:46:24','2024-06-11 01:46:24',0),(933,1800344237287469058,2,'打游戏',0,25,0,'','1',5,0,NULL,'http://8.130.163.41:9000/todo-bucket/background/532.jpg',NULL,NULL,'2024-06-11 09:48:10','2024-06-11 01:48:09',0);
/*!40000 ALTER TABLE `task` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `task_category`
--
DROP TABLE IF EXISTS `task_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `task_category` (
`category_id` int(11) NOT NULL AUTO_INCREMENT,
`category_name` varchar(100) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`color` int(11) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`deleted` tinyint(4) DEFAULT '0',
PRIMARY KEY (`category_id`),
KEY `task_category_user_id_IDX` (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `task_category`
--
LOCK TABLES `task_category` WRITE;
/*!40000 ALTER TABLE `task_category` DISABLE KEYS */;
INSERT INTO `task_category` VALUES (63,'Mysql深入学习',2,-16776961,'2024-06-10 15:11:39','2024-06-10 15:11:39',0),(64,'Java语言学习',2,-16181,'2024-06-10 15:17:49','2024-06-10 15:17:49',0),(65,'Android学习',2,-16776961,'2024-06-10 15:21:24','2024-06-10 15:21:24',0),(66,'算法学习',2,-8388480,'2024-06-10 15:24:22','2024-06-10 15:24:22',0),(67,'考研',25,-16776961,'2024-06-10 16:54:36','2024-06-10 16:54:36',0),(68,'今日集',26,-8388480,'2024-06-11 00:12:43','2024-06-11 00:12:43',0);
/*!40000 ALTER TABLE `task_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tomato_clock`
--
DROP TABLE IF EXISTS `tomato_clock`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tomato_clock` (
`clock_id` bigint(20) NOT NULL AUTO_INCREMENT,
`task_id` bigint(20) DEFAULT NULL,
`parent_id` bigint(20) DEFAULT NULL,
`clock_duration` int(11) DEFAULT '0',
`clock_status` tinyint(4) DEFAULT '2',
`stop_reason` varchar(255) DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
`started_at` timestamp NULL DEFAULT NULL,
`completed_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`deleted` tinyint(4) DEFAULT '0',
PRIMARY KEY (`clock_id`),
KEY `tomato_clock_parent_id_IDX` (`parent_id`) USING BTREE,
KEY `tomato_clock_task_id_IDX` (`task_id`) USING BTREE,
KEY `tomato_clock_created_at_IDX` (`created_at`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1519 DEFAULT CHARSET=utf8mb4 COMMENT='番茄钟';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tomato_clock`
--
LOCK TABLES `tomato_clock` WRITE;
/*!40000 ALTER TABLE `tomato_clock` DISABLE KEYS */;
INSERT INTO `tomato_clock` VALUES (1274,227,1794377081413595137,25,0,'',2,'2024-05-26 05:43:00','2024-05-26 06:08:01','2024-05-26 05:43:00','2024-06-06 02:42:39',0),(1275,227,1794377081413595137,30,0,'',2,'2024-05-26 06:30:31','2024-05-26 07:00:32','2024-05-26 06:30:31','2024-06-06 02:42:39',0),(1276,227,1794377081413595137,30,0,'',2,'2024-05-26 07:05:33','2024-05-26 07:35:33','2024-05-26 06:30:31','2024-06-06 02:42:39',0),(1279,230,1794377081413595137,20,0,'',2,'2024-05-27 01:36:49','2024-05-27 01:56:49','2024-05-27 01:36:49','2024-06-06 02:42:39',0),(1280,230,1794377081413595137,20,3,'吃饭',2,'2024-05-27 02:01:50','2024-05-27 02:21:51','2024-05-27 01:36:49','2024-06-10 16:10:14',0),(1281,230,1794377081413595137,20,0,'',2,'2024-05-27 02:26:52','2024-05-27 02:46:52','2024-05-27 01:36:49','2024-06-06 02:42:39',0),(1283,232,1794388931987628034,25,0,'',2,'2024-05-26 01:23:54','2024-05-26 01:48:59','2024-05-26 01:23:54','2024-06-06 02:42:39',0),(1285,286,1795010247025831937,30,0,'',2,'2024-05-27 08:33:24','2024-05-27 07:03:25','2024-05-27 08:33:24','2024-06-06 02:42:39',0),(1286,288,1795011301054427137,20,0,'',2,'2024-05-03 01:01:08','2024-05-03 01:21:09','2024-05-03 01:01:08','2024-06-06 02:42:39',0),(1287,288,1795011301054427137,20,0,'',2,'2024-05-03 01:26:10','2024-05-03 01:46:10','2024-05-03 01:01:08','2024-06-06 02:42:40',0),(1288,288,1795011301054427137,20,3,'',2,'2024-05-03 01:51:11','2024-05-03 02:11:12','2024-05-03 01:01:08','2024-06-06 02:42:40',0),(1289,289,1795011803657875457,60,0,'',2,'2024-05-16 06:39:08','2024-05-16 07:39:12','2024-05-25 06:39:08','2024-06-06 02:42:40',0),(1290,290,1795012038274658306,30,0,'',2,'2024-05-20 08:12:58','2024-05-20 08:12:58','2024-05-20 08:12:58','2024-06-06 02:42:40',0),(1291,291,1795012687657775106,15,0,'',2,'2024-05-01 01:15:57','2024-05-01 01:30:57','2024-05-01 01:15:57','2024-06-06 02:42:40',0),(1292,291,1795012687657775106,15,0,'',2,'2024-05-01 01:35:58','2024-05-01 01:50:58','2024-05-01 01:15:57','2024-06-06 02:42:40',0),(1293,405,1795010247025831937,30,0,'',2,'2024-05-28 00:01:17','2024-05-28 00:31:17','2024-05-28 00:01:17','2024-06-06 02:42:40',0),(1294,402,1795126139537666050,30,0,'',2,'2024-05-28 00:41:46','2024-05-28 01:11:46','2024-05-28 00:41:46','2024-06-06 02:42:40',0),(1295,402,1795126139537666050,30,0,'',2,'2024-05-28 01:16:46','2024-05-28 01:46:47','2024-05-28 00:41:46','2024-06-06 02:42:40',0),(1297,435,1795257028028477442,30,0,'',2,'2024-04-28 05:53:50','2024-04-28 06:23:51','2024-04-28 05:53:50','2024-06-06 02:42:40',0),(1298,435,1795257028028477442,30,0,'',2,'2024-04-28 06:28:51','2024-04-28 06:58:51','2024-04-28 05:53:50','2024-06-06 02:42:40',0),(1299,436,1795261266175537154,25,0,'',2,'2024-04-18 00:25:50','2024-04-18 00:50:50','2024-04-18 00:25:50','2024-06-06 02:42:40',0),(1300,437,1795262638996402177,30,0,'',2,'2024-04-23 01:15:49','2024-04-23 01:45:49','2024-04-23 01:15:49','2024-06-06 02:42:40',0),(1301,434,1795010247025831937,30,0,'',2,'2024-05-29 00:01:47','2024-05-29 00:31:47','2024-05-29 00:01:47','2024-06-06 02:42:40',0),(1493,892,1800188698758803458,25,0,NULL,2,'2024-06-10 08:15:50','2024-06-10 08:40:50','2024-06-10 08:15:50','2024-06-10 16:01:26',0),(1494,894,1800189129216028673,25,0,NULL,2,'2024-06-10 08:51:31','2024-06-10 09:16:31','2024-06-10 08:51:31','2024-06-10 16:01:27',0),(1495,900,1800189525242212354,30,0,NULL,2,'2024-06-10 10:19:31','2024-06-10 10:49:31','2024-06-10 10:19:31','2024-06-10 16:01:27',0),(1496,908,1800188698758803458,25,0,NULL,2,'2024-06-09 09:12:18','2024-06-09 09:37:18','2024-06-09 09:12:18','2024-06-10 16:01:27',0),(1497,910,1800189129216028673,25,0,NULL,2,'2024-06-09 10:40:25','2024-06-09 11:05:25','2024-06-09 10:40:25','2024-06-10 16:01:27',0),(1498,841,1800184482996744193,41,0,NULL,2,'2024-06-10 13:52:34','2024-06-10 14:33:34','2024-06-10 13:52:34','2024-06-10 14:33:34',0),(1499,843,1800185203787886594,25,0,NULL,2,'2024-06-10 14:52:34','2024-06-10 15:17:34','2024-06-10 14:52:34','2024-06-10 15:17:34',0),(1500,893,1800188698758803458,25,0,NULL,2,'2024-06-10 08:11:50','2024-06-10 08:36:50','2024-06-10 08:11:50','2024-06-10 08:36:50',0),(1501,905,1800189779173765121,30,0,NULL,2,'2024-06-11 09:14:45','2024-06-11 09:44:45','2024-06-11 09:14:45','2024-06-11 09:44:45',0),(1502,918,1800202283585171457,30,3,'其他作业',2,'2024-06-11 07:24:15','2024-06-11 07:29:15','2024-06-11 07:24:15','2024-06-11 07:29:15',0),(1503,914,1800200644845432834,30,3,'朋友求助',2,'2024-06-01 08:18:39','2024-06-01 08:30:39','2024-06-01 08:18:39','2024-06-01 08:30:39',0),(1504,921,1800209530709143554,1,0,NULL,25,'2024-06-11 00:52:54','2024-06-11 00:53:58','2024-06-10 16:52:54','2024-06-10 16:53:58',0),(1505,919,1800209402803843074,25,3,'有事',25,'2024-06-11 01:03:01','2024-06-11 01:03:20','2024-06-10 17:03:01','2024-06-10 17:03:20',0),(1506,919,1800209402803843074,25,3,'打游戏',25,'2024-06-11 01:03:24','2024-06-11 01:03:42','2024-06-10 17:03:23','2024-06-10 17:03:41',0),(1507,919,1800209402803843074,0,0,NULL,25,'2024-06-11 01:03:44','2024-06-11 01:03:55','2024-06-10 17:03:44','2024-06-10 17:03:54',0),(1508,919,1800209402803843074,0,0,NULL,25,'2024-06-11 01:04:00','2024-06-11 01:04:08','2024-06-10 17:04:00','2024-06-10 17:04:08',0),(1509,920,1800209464653049858,0,0,NULL,25,'2024-06-11 01:04:14','2024-06-11 01:04:22','2024-06-10 17:04:14','2024-06-10 17:04:22',0),(1510,924,1800326394441428993,30,0,NULL,26,'2024-06-11 08:14:51','2024-06-11 08:44:51','2024-06-11 08:14:51','2024-06-11 08:44:51',0),(1511,886,1800187353398046721,25,1,NULL,2,'2024-06-11 08:39:40',NULL,'2024-06-11 00:39:39','2024-06-11 00:39:39',0),(1512,886,1800187353398046721,25,2,NULL,2,NULL,NULL,'2024-06-11 00:39:39','2024-06-11 00:39:39',0),(1513,925,1800327358833553410,25,0,NULL,26,'2024-06-11 08:49:20','2024-06-11 09:14:20','2024-06-11 08:47:10','2024-06-11 09:14:20',0),(1514,929,1800328519049342977,32,0,NULL,25,'2024-06-11 08:14:25','2024-06-11 08:46:34','2024-06-11 08:14:25','2024-06-11 08:46:34',0),(1515,930,1800329413920878594,25,0,NULL,25,'2024-06-11 08:49:21','2024-06-11 09:14:20','2024-06-11 08:49:21','2024-06-11 09:14:20',0),(1516,930,1800329413920878594,25,3,NULL,25,'2024-06-11 09:19:21',NULL,'2024-06-11 09:19:21','2024-06-11 00:51:20',0),(1517,895,1800189129216028673,25,1,NULL,2,'2024-06-11 09:40:25',NULL,'2024-06-11 01:40:25','2024-06-11 01:40:25',0),(1518,923,1800319319682379778,1,1,NULL,2,'2024-06-11 09:41:29',NULL,'2024-06-11 01:41:29','2024-06-11 01:41:29',0);
/*!40000 ALTER TABLE `tomato_clock` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user`
--
DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user` (
`user_id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_name` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`avatar` varchar(255) DEFAULT NULL,
`signature` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`deleted` tinyint(4) DEFAULT '0',
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user`
--
LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (2,'admin','[email protected]','$2a$10$7SN3K1Ww6oWpncixTdlkEefMcGwnmtooy/rPDrX3QoyiCxn0kNSga','http://8.130.163.41:9000/todo-bucket/user/49bb152629fe47acb5e23ff0776acf8a.jpg','不积跬步,无以至千里','2024-04-22 09:12:44','2024-06-07 06:04:20',0),(18,'海纳百川','[email protected]','$2a$10$7SN3K1Ww6oWpncixTdlkEefMcGwnmtooy/rPDrX3QoyiCxn0kNSga','http://8.130.163.41:9000/todo-bucket/user_default_avatar/random_avator11.png','莫愁前路无知己','2024-04-24 00:12:16','2024-06-10 16:35:25',0),(21,'Todo','[email protected]','$2a$10$7SN3K1Ww6oWpncixTdlkEefMcGwnmtooy/rPDrX3QoyiCxn0kNSga','http://8.130.163.41:9000/todo-bucket/user_default_avatar/random_avator11.png','千里之行,始于足下','2024-04-24 06:46:49','2024-06-03 16:08:57',0),(25,'未雨绸缪','[email protected]','$2a$10$7SN3K1Ww6oWpncixTdlkEefMcGwnmtooy/rPDrX3QoyiCxn0kNSga','http://8.130.163.41:9000/todo-bucket/user_default_avatar/random_avator11.png','人生几何时','2024-05-13 07:01:49','2024-06-10 16:35:25',0),(26,'6iu','[email protected]','$2a$10$7SN3K1Ww6oWpncixTdlkEefMcGwnmtooy/rPDrX3QoyiCxn0kNSga','http://8.130.163.41:9000/todo-bucket/user/c1f76160fe3e416d8aaa83203d831bf8.jpg','不积跬步,无以至千里','2024-05-14 03:10:47','2024-06-05 01:59:58',0),(27,'予独爱莲','[email protected]','$2a$10$HaWJhhfaH1gNUjEi5/9ItOpzf146CjEwExawqUDmHMesmJihl5gla','http://8.130.163.41:9000/todo-bucket/user_default_avatar/random_avator8.png','不积跬步,无以至千里','2024-06-06 03:12:50','2024-06-06 03:12:50',0);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_room`
--
DROP TABLE IF EXISTS `user_room`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_room` (
`user_room_id` bigint(20) NOT NULL,
`user_id` bigint(20) DEFAULT NULL,
`room_id` bigint(20) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`deleted` tinyint(4) DEFAULT '0',
PRIMARY KEY (`user_room_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户 自习室 关系表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_room`
--
LOCK TABLES `user_room` WRITE;
/*!40000 ALTER TABLE `user_room` DISABLE KEYS */;
INSERT INTO `user_room` VALUES (1797510963007139842,18,1797510657473064961,'2024-06-03 06:09:44','2024-06-03 06:09:44',0),(1798548172560740354,2,1797510657473064961,'2024-06-06 02:51:14','2024-06-06 02:51:14',0),(1799004051198259202,26,1797510657473064961,'2024-06-07 09:02:44','2024-06-07 09:02:44',0),(1800336084634234882,21,1800336084617457665,'2024-06-11 01:15:45','2024-06-11 01:23:16',0),(1800342936109510658,27,1797510657473064961,'2024-06-11 01:42:59','2024-06-11 01:42:59',0),(1800343888027774977,25,1800343888015192065,'2024-06-11 01:46:46','2024-06-11 01:46:58',1),(1800344090268725249,25,1797510657473064961,'2024-06-11 01:47:34','2024-06-11 01:47:34',0);
/*!40000 ALTER TABLE `user_room` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping routines for database 'todo'
--
/*!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 2024-06-11 10:21:30