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.
23 lines
1.1 KiB
SQL
23 lines
1.1 KiB
SQL
create table admin_accounts
|
|
(
|
|
id bigint unsigned auto_increment
|
|
primary key,
|
|
admin_id bigint not null,
|
|
account varchar(50) not null,
|
|
secret varchar(80) 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
|
|
)
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
create index admin_accounts_account_index
|
|
on admin_accounts (account);
|
|
|
|
create index admin_accounts_admin_id_index
|
|
on admin_accounts (admin_id);
|
|
|
|
INSERT INTO lkpe.admin_accounts (id, admin_id, account, secret, type, del, created_at, updated_at) VALUES (1, 1, 'admin', '$2y$10$RrkVbwgR7plyKBJA.82onul9Sv9iyLKqmJDN7bRmFY4b6.45C5Qsi', 1, 2, '2023-04-06 23:01:36', '2023-04-06 23:01:36');
|
|
INSERT INTO lkpe.admin_accounts (id, admin_id, account, secret, type, del, created_at, updated_at) VALUES (2, 2, 'TEST_ADMIN_01', '$2y$10$KOdF2w9ebVB2QaKVjBaTcO53kbslyoGYysOvmHNHq.30ezd1t8z6q', 1, 2, '2023-06-09 15:31:02', '2023-06-09 15:31:02');
|