-- -- PostgreSQL database dump -- -- Dumped from database version 10.9 -- Dumped by pg_dump version 12.5 \c tj_project SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; -- -- Data for Name: user_permission; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.user_permission (id, description, create_time, update_time) FROM stdin; 1 task:assign 2019-08-31 14:19:35.575579 2019-10-02 10:31:40.271308 5 task:changeCellToUser 2019-09-03 20:30:46.841232 2019-10-02 10:37:04.694562 8 task:changeDataToUser 2019-09-06 17:07:08.275077 2019-10-02 10:38:06.45885 9 image:readById 2019-09-17 13:56:53.821037 2019-10-02 10:38:21.167537 10 image:readAll 2019-09-21 11:22:57.499138 2019-10-02 10:38:24.540783 11 route:insert 2019-09-21 11:23:07.825939 2019-10-02 10:39:23.960188 12 draft:insert 2019-09-22 17:32:04.898064 2019-10-02 10:40:00.7865 13 draft:readField 2019-09-22 17:32:11.280443 2019-10-02 10:40:37.917048 4 taskCell:readByUser 2019-09-03 18:15:23.726681 2019-10-02 10:41:50.32412 3 taskCell:readAll 2019-08-31 14:19:35.575579 2019-10-02 10:42:16.975154 2 task:read 2019-08-31 14:19:35.575579 2019-10-02 10:42:38.926339 14 user:read 2019-09-22 17:32:15.992382 2019-10-02 10:44:23.348406 15 user:readWorker 2019-09-22 17:32:35.548298 2019-10-02 10:44:33.080585 16 user:changeRole 2019-09-26 12:47:46.917506 2019-10-02 10:45:25.811784 17 image:upload 2019-10-05 14:36:39.893348 2019-10-05 14:36:39.893348 20 task:readWorker 2019-10-28 10:19:27.442628 2019-10-28 10:19:27.442628 21 task:checkWorkerStatus 2019-10-28 22:14:59.969087 2019-10-28 22:14:59.969087 19 task:deleteWorker 2019-10-24 22:06:08.085745 2019-10-28 22:15:57.361321 18 task:appendWorkersToTask 2019-10-24 22:05:51.995991 2019-10-28 22:16:25.889528 23 task:deleteWorkerFromCell 2019-10-28 22:17:57.761998 2019-10-28 22:17:57.761998 22 task:appendWorkersToCell 2019-10-28 22:16:28.807395 2019-12-02 15:40:56.904664 24 user:new 2019-12-02 15:41:23.812324 2019-12-02 15:44:31.483289 \. -- -- Data for Name: user_role; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.user_role (id, name, create_time, update_time, code) FROM stdin; 1 SuperAdmin 2019-08-31 14:18:26.330858 2019-10-28 16:26:56.834742 1234 2 Leader 2019-08-31 14:18:26.330858 2019-10-28 16:26:58.388278 1235 3 Admin 2019-08-31 14:18:26.330858 2019-10-28 16:27:03.116832 1236 4 Worker 2019-08-31 14:18:26.330858 2019-10-28 16:27:16.036296 1237 5 Operator 2019-12-13 10:40:31.519547 2019-12-13 10:40:31.519547 1238 \. -- -- Data for Name: user_role_code; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.user_role_code (id, code, role) FROM stdin; 1 1234 1 2 1235 2 3 1236 3 4 1237 4 \. -- -- Data for Name: user_role_permission; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.user_role_permission (id, role, permission, create_time, update_time) FROM stdin; 4 3 4 2019-09-03 18:16:08.794205 2019-09-03 18:16:08.794205 2 3 2 2019-08-31 14:15:36.318695 2019-09-03 19:52:45.774985 1 3 1 2019-08-31 14:15:36.318695 2019-09-03 19:52:56.065802 9 3 16 2019-09-03 20:31:19.021642 2019-10-02 10:52:25.439733 3 3 3 2019-08-31 14:15:36.318695 2019-10-02 10:52:28.279986 5 3 5 2019-09-03 19:53:59.515434 2019-10-02 10:52:29.78855 6 3 8 2019-09-03 19:54:05.128648 2019-10-02 10:52:31.211962 7 3 14 2019-09-03 19:54:10.39031 2019-10-02 10:52:32.402753 8 3 15 2019-09-03 19:54:15.313807 2019-10-02 10:52:38.751726 10 4 9 2019-09-06 17:07:41.129591 2019-10-02 10:52:57.190981 11 4 10 2019-09-17 13:57:19.906336 2019-10-02 10:53:00.996116 12 4 11 2019-09-21 11:23:56.517606 2019-10-02 10:53:12.855955 13 4 12 2019-09-21 11:24:01.694544 2019-10-02 10:53:14.285944 14 4 13 2019-09-22 17:32:59.032636 2019-10-02 10:53:16.372835 15 3 9 2019-10-05 10:34:09.764426 2019-10-05 10:34:09.764426 16 3 10 2019-10-05 10:34:17.086963 2019-10-05 10:34:26.680047 17 3 17 2019-10-05 14:36:55.519405 2019-10-05 14:36:55.519405 18 3 18 2019-10-24 22:06:39.062327 2019-10-24 22:06:39.062327 19 3 19 2019-10-24 22:06:47.173313 2019-10-24 22:06:47.173313 20 3 20 2019-10-28 10:19:40.53637 2019-10-28 10:19:40.53637 22 3 22 2019-10-28 22:16:35.837969 2019-10-28 22:16:35.837969 21 3 21 2019-10-28 22:15:10.604473 2019-10-28 22:16:37.872189 23 3 23 2019-10-28 22:18:03.235823 2019-10-28 22:18:03.235823 24 3 24 2019-12-02 15:41:37.668403 2019-12-02 15:41:47.024277 25 5 1 2019-12-13 11:36:43.022671 2019-12-13 11:36:43.022671 26 5 2 2019-12-13 11:36:51.911982 2019-12-13 11:36:51.911982 27 5 3 2019-12-13 11:37:00.407219 2019-12-13 11:37:00.407219 28 5 4 2019-12-13 11:37:08.260826 2019-12-13 11:37:08.260826 29 5 5 2019-12-13 11:37:13.422231 2019-12-13 11:37:13.422231 30 5 8 2019-12-13 11:37:21.09809 2019-12-13 11:37:21.09809 31 5 18 2019-12-13 11:37:39.726519 2019-12-13 11:37:39.726519 32 5 19 2019-12-13 11:37:44.602842 2019-12-13 11:37:44.602842 33 5 20 2019-12-13 11:37:51.401845 2019-12-13 11:37:51.401845 34 5 21 2019-12-13 11:37:56.59423 2019-12-13 11:37:56.59423 35 5 22 2019-12-13 11:38:10.321722 2019-12-13 11:38:10.321722 36 5 23 2019-12-13 11:38:17.356067 2019-12-13 11:38:17.356067 \. -- -- Name: user_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.user_permission_id_seq', 25, true); -- -- Name: user_role_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.user_role_id_seq', 6, false); -- -- Name: user_role_premission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.user_role_premission_id_seq', 37, true); -- -- PostgreSQL database dump complete --