You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
58 lines
7.8 KiB
SQL
58 lines
7.8 KiB
SQL
create table admin_tokens
|
|
(
|
|
id bigint unsigned auto_increment
|
|
primary key,
|
|
admin_id bigint not null comment '账号ID',
|
|
token varchar(50) not null comment 'TOKEN',
|
|
type tinyint not null comment '1-后台',
|
|
del tinyint default 2 not null comment '1-删除 2-正常',
|
|
created_at timestamp null,
|
|
updated_at timestamp null
|
|
)
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
create index admin_tokens_admin_id_index
|
|
on admin_tokens (admin_id);
|
|
|
|
create index admin_tokens_token_index
|
|
on admin_tokens (token);
|
|
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (1, 1, '98df5399-19dd-4ce8-8d54-00aa18b8f2fc', 1, 2, '2023-04-07 14:37:56', '2023-04-09 00:59:27');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (2, 1, '98e149db-1544-4f22-a447-2a021d0908b8', 1, 2, '2023-04-08 14:02:21', '2023-04-08 14:08:15');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (3, 1, '98e50b68-4b02-4b5b-a2ad-524decbf5f89', 1, 2, '2023-04-10 10:51:03', '2023-04-12 10:57:58');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (4, 1, '98e913e1-9670-4540-b437-da221f6592e3', 1, 2, '2023-04-12 10:58:03', '2023-04-13 09:20:02');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (5, 1, '98eaf3d4-d770-45fd-938c-e431e3e52596', 1, 2, '2023-04-13 09:20:05', '2023-04-13 13:08:09');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (6, 1, '993d7322-2347-4eb8-acd7-582d9cc16f7d', 1, 2, '2023-05-24 09:33:56', '2023-05-26 11:11:38');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (7, 1, '99419c0f-31e5-440c-84cf-728dfc209e69', 1, 2, '2023-05-26 11:11:41', '2023-05-28 10:52:35');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (8, 1, '9949f7b4-fa54-48d6-8cb1-4ecf7d21df26', 1, 2, '2023-05-30 14:54:34', '2023-05-30 14:54:56');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (9, 1, '994e3be7-0ec9-4eaf-9c68-6736b2c42be2', 1, 2, '2023-06-01 17:48:34', '2023-06-01 17:55:56');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (10, 1, '9950cb48-d279-4d81-b027-f0232c62d79f', 1, 2, '2023-06-03 00:21:09', '2023-06-03 01:16:05');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (11, 1, '9956027f-7b16-4f78-a2bb-dfc07cb93f02', 1, 2, '2023-06-05 14:34:41', '2023-06-05 14:39:39');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (12, 1, '99566836-23ac-4979-b3ff-c22fe1ff3e13', 1, 2, '2023-06-05 19:19:06', '2023-06-06 10:51:15');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (13, 1, '9957db7f-9b0a-4375-a2ad-aa589a17bef9', 1, 2, '2023-06-06 12:37:17', '2023-06-06 17:20:54');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (14, 1, '995b9997-f43b-43d0-9ac1-06da5a99f78b', 1, 2, '2023-06-08 09:16:19', '2023-06-08 09:26:59');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (15, 1, '995c1b8b-c09b-46d8-9269-a302757013eb', 1, 2, '2023-06-08 15:19:41', '2023-06-08 21:32:39');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (16, 1, '995d0192-3448-459c-8b7e-54c79cce1d70', 1, 2, '2023-06-09 02:02:53', '2023-06-09 22:15:47');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (17, 1, '995eabd1-23b0-472a-b584-5826ca92c6d4', 1, 2, '2023-06-09 21:54:45', '2023-06-09 23:51:23');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (18, 2, '995eb3f5-4e35-4923-a122-4ded017ecfbf', 1, 2, '2023-06-09 22:17:31', '2023-06-09 22:22:49');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (19, 1, '995eb618-9b2a-4eed-861e-0ad94c061e73', 1, 2, '2023-06-09 22:23:30', '2023-06-09 22:44:28');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (20, 2, '995ebda5-6f6e-436a-b5ad-16c506cc8830', 1, 2, '2023-06-09 22:44:37', '2023-06-10 00:23:41');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (21, 1, '995ecf66-f020-4605-803e-577d471b4a86', 1, 2, '2023-06-09 23:34:16', '2023-06-09 23:34:16');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (22, 2, '995ee11a-1af6-44f8-9d25-34212fbc27c1', 1, 2, '2023-06-10 00:23:45', '2023-06-10 00:23:47');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (23, 2, '995ee21b-775a-4661-b2e0-b3ef898c38a8', 1, 2, '2023-06-10 00:26:34', '2023-06-10 00:35:42');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (24, 2, '995ee5b4-8b95-4502-a97c-3a757cf47436', 1, 2, '2023-06-10 00:36:37', '2023-06-10 00:36:39');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (25, 2, '995ee68b-0110-435b-8a29-c67d5e92cdca', 1, 2, '2023-06-10 00:38:58', '2023-06-10 00:39:01');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (26, 2, '995ee6be-bc69-47dd-9aba-3a0a547f82eb', 1, 2, '2023-06-10 00:39:32', '2023-06-10 00:39:34');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (27, 2, '995ee713-8ec4-4674-8fb3-248d6e1fe585', 1, 2, '2023-06-10 00:40:27', '2023-06-10 00:40:50');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (28, 2, '995ee7d8-e871-42f7-b1de-ed938685f4a3', 1, 2, '2023-06-10 00:42:37', '2023-06-10 00:45:34');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (29, 2, '995ee99a-14b3-4d67-bf46-3da7e044d4f2', 1, 2, '2023-06-10 00:47:31', '2023-06-10 10:20:40');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (30, 1, '995fb71a-acf1-4964-bcc5-79eb7ddc950d', 1, 2, '2023-06-10 10:22:09', '2023-06-10 12:18:18');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (31, 2, '995fe0c6-2fde-42f7-8a47-7b09c1a7d912', 1, 2, '2023-06-10 12:18:40', '2023-06-10 12:20:12');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (32, 2, '995fe1bf-5cb2-4f4e-b114-023b243b55a5', 1, 2, '2023-06-10 12:21:23', '2023-06-10 12:21:34');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (33, 2, '995fe228-8006-4977-a2ee-a9f114fe76ae', 1, 2, '2023-06-10 12:22:32', '2023-06-10 12:28:46');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (34, 1, '99600d74-4b58-4cd7-8ee2-0f84130f319d', 1, 2, '2023-06-10 14:23:36', '2023-06-10 14:27:55');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (35, 1, '99600f08-a80e-483a-9e8a-9a68cf578056', 1, 2, '2023-06-10 14:28:01', '2023-06-10 14:29:02');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (36, 2, '99600f7d-85c5-4cee-9b23-27f2f74872e2', 1, 2, '2023-06-10 14:29:17', '2023-06-10 14:37:47');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (37, 1, '9960130e-f5fd-44a9-8885-3a4569af3b10', 1, 2, '2023-06-10 14:39:16', '2023-06-10 23:11:37');
|
|
INSERT INTO lkpe.admin_tokens (id, admin_id, token, type, del, created_at, updated_at) VALUES (38, 2, '9960ca5c-8307-4cba-a12e-2b650bdc2068', 1, 2, '2023-06-10 23:11:49', '2023-06-10 23:48:30');
|