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.
32 lines
3.4 KiB
SQL
32 lines
3.4 KiB
SQL
create table user_tokens
|
|
(
|
|
id bigint unsigned auto_increment
|
|
primary key,
|
|
user bigint not null,
|
|
token varchar(50) not null,
|
|
type tinyint not null comment '1-微信',
|
|
del tinyint default 2 not null comment '1-删除 2-正常',
|
|
created_at timestamp null,
|
|
updated_at timestamp null,
|
|
constraint user_tokens_token_unique
|
|
unique (token)
|
|
)
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
INSERT INTO lkpe.user_tokens (id, user, token, type, del, created_at, updated_at) VALUES (1, 1, '98e92506-4c18-4f7d-b477-52e3358f9f63', 1, 2, '2023-04-12 11:45:59', '2023-04-12 12:54:53');
|
|
INSERT INTO lkpe.user_tokens (id, user, token, type, del, created_at, updated_at) VALUES (2, 1, '98e93efe-70bb-4490-b6e6-d3bae7412e14', 1, 2, '2023-04-12 12:58:36', '2023-04-12 18:51:35');
|
|
INSERT INTO lkpe.user_tokens (id, user, token, type, del, created_at, updated_at) VALUES (3, 1, '98e9bed5-0c46-47c9-a651-69fac6f67c61', 1, 2, '2023-04-12 18:56:04', '2023-04-12 18:56:04');
|
|
INSERT INTO lkpe.user_tokens (id, user, token, type, del, created_at, updated_at) VALUES (4, 1, '98e9bf2b-4d5b-46a6-a2af-01d8c0c0670b', 1, 2, '2023-04-12 18:57:00', '2023-04-12 18:57:21');
|
|
INSERT INTO lkpe.user_tokens (id, user, token, type, del, created_at, updated_at) VALUES (5, 1, '98e9bf54-7502-44c8-aa6a-896bfc2614c7', 1, 2, '2023-04-12 18:57:27', '2023-04-12 18:57:27');
|
|
INSERT INTO lkpe.user_tokens (id, user, token, type, del, created_at, updated_at) VALUES (6, 1, '98e9bf5a-afb2-447d-a094-41ab5b7a0856', 1, 2, '2023-04-12 18:57:31', '2023-04-12 18:57:31');
|
|
INSERT INTO lkpe.user_tokens (id, user, token, type, del, created_at, updated_at) VALUES (7, 1, '98e9bf62-cc9a-4843-bf0c-99a6035d357c', 1, 2, '2023-04-12 18:57:37', '2023-04-12 23:25:03');
|
|
INSERT INTO lkpe.user_tokens (id, user, token, type, del, created_at, updated_at) VALUES (8, 1, '98ea1f42-fb6a-4ba5-9b20-2c7176c41649', 1, 2, '2023-04-12 23:25:42', '2023-04-13 11:33:36');
|
|
INSERT INTO lkpe.user_tokens (id, user, token, type, del, created_at, updated_at) VALUES (9, 1, '98eb26e8-792f-4247-8574-bcc3c0c44623', 1, 2, '2023-04-13 11:42:55', '2023-04-13 11:43:11');
|
|
INSERT INTO lkpe.user_tokens (id, user, token, type, del, created_at, updated_at) VALUES (10, 1, '98eb2710-b131-4da2-893b-af12eceb215a', 1, 2, '2023-04-13 11:43:21', '2023-04-13 13:12:37');
|
|
INSERT INTO lkpe.user_tokens (id, user, token, type, del, created_at, updated_at) VALUES (11, 1, '993d956d-6d13-48a1-8cba-b889dc928394', 1, 2, '2023-05-24 11:09:50', '2023-05-26 15:02:31');
|
|
INSERT INTO lkpe.user_tokens (id, user, token, type, del, created_at, updated_at) VALUES (12, 1, '9941f2ac-c400-42fe-8800-fd9afbc208aa', 1, 2, '2023-05-26 15:13:53', '2023-05-26 15:14:47');
|
|
INSERT INTO lkpe.user_tokens (id, user, token, type, del, created_at, updated_at) VALUES (13, 1, '9941f318-38c6-45f3-8033-acbcbf544238', 1, 2, '2023-05-26 15:15:03', '2023-05-26 16:42:45');
|
|
INSERT INTO lkpe.user_tokens (id, user, token, type, del, created_at, updated_at) VALUES (14, 1, '99421300-8fcc-4c91-b257-9c852787b56e', 1, 2, '2023-05-26 16:44:16', '2023-05-30 19:05:47');
|
|
INSERT INTO lkpe.user_tokens (id, user, token, type, del, created_at, updated_at) VALUES (15, 1, '994e13e3-b165-4cef-8dac-41f32f24aca9', 1, 2, '2023-06-01 15:56:41', '2023-06-03 01:50:13');
|
|
INSERT INTO lkpe.user_tokens (id, user, token, type, del, created_at, updated_at) VALUES (16, 1, '9957ad3b-48d6-4080-819d-26b517e8637c', 1, 2, '2023-06-06 10:27:55', '2023-06-11 00:08:13');
|