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.
19 lines
773 B
SQL
19 lines
773 B
SQL
create table user_accounts
|
|
(
|
|
id bigint unsigned auto_increment
|
|
primary key,
|
|
user bigint not null,
|
|
account varchar(50) not null,
|
|
secret varchar(80) not null,
|
|
type tinyint not null comment '1-微信OPENID',
|
|
del tinyint default 2 not null comment '1-删除 2-正常',
|
|
created_at timestamp null,
|
|
updated_at timestamp null
|
|
)
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
create index user_accounts_account_index
|
|
on user_accounts (account);
|
|
|
|
INSERT INTO lkpe.user_accounts (id, user, account, secret, type, del, created_at, updated_at) VALUES (1, 1, 'ourv44tbkA8yLB8X60GhmvhetVTM', '/hfvdK9AL5F6wGhwDX4TFw==', 1, 2, '2023-04-12 11:45:59', '2023-06-06 10:27:55');
|