mirror of
https://github.com/azaion/admin.git
synced 2026-04-22 22:06:33 +00:00
Oleksandr Bezdieniezhnykh
33 lines
1.1 KiB
SQL
33 lines
1.1 KiB
SQL
-- users table
|
|
drop table users;
|
|
create table users
|
|
(
|
|
id uuid primary key,
|
|
email varchar(160) not null,
|
|
password_hash varchar(255) not null,
|
|
hardware text null,
|
|
hardware_hash varchar(120) null,
|
|
role varchar(20) not null,
|
|
user_config varchar(512) null,
|
|
created_at timestamp not null default now(),
|
|
last_login timestamp null
|
|
);
|
|
grant select, insert, update, delete on public.users to azaion_admin;
|
|
grant select on table public.users to azaion_reader;
|
|
|
|
INSERT INTO public.users (id, email, password_hash, hardware, hardware_hash, role)
|
|
VALUES ('d90a36ca-e237-4fbd-9c7c-127040ac8556',
|
|
'admin@azaion.com',
|
|
'282wqVHZU0liTxphiGkKIaJtUA1W6rILdvfEOx8Ez350x0XLbgNtrSUYCK1r/ajq',
|
|
null,
|
|
null,
|
|
'ApiAdmin');
|
|
|
|
INSERT INTO public.users (id, email, password_hash, hardware, hardware_hash, role)
|
|
VALUES ('48adb269-ecd5-4197-a9d1-cd36254cf104',
|
|
'uploader@azaion.com',
|
|
'2zHX1eSnbdCirc+KRNepcr5g4ZFQhhrII0FggYyMezQzxD+gBxwISCZ48fe1wxAk',
|
|
null,
|
|
null,
|
|
'ResourceUploader');
|