avalonia_practic_9/database_scheme/43P_Chernov_2.sql

drop table roles;
drop table lesson;

--Таблица ролей
create table roles
(
	id serial primary key,
	role text not null
);

insert into roles (role) values 
('Администратор'),
('Пользователь');

--select * from roles;

create table users
(
	id serial primary key,
	surname text not null,
	name text not null,
	patronymic text,
	login text not null,
	password byteA not null,
	image byteA,
	role int not null constraint fk_role_to_user references roles(id) on delete cascade
)