nCauWFV9

1create table if not exists users
2(
3	id serial not null primary key,
4	email varchar(50) not null,
5	password varchar(100) not null,
6	first_name varchar(30),
7	last_name varchar(30),
8	active boolean default true not null
9-- 	constraint pk_users primary key (id)
10);
11
12create table if not exists roles
13(
14	id serial not null primary key,
15	name varchar(30) not null
16);
17
18create table if not exists user_roles
19(
20	user_id integer not null,
21	role_id integer not null,
22    unique (user_id, role_id),
23    foreign key (user_id) references users(id),
24    foreign key (role_id) references roles(id)
25);
26
27INSERT INTO roles (name) VALUES ('ROLE_ADMIN');
28INSERT INTO roles (name) VALUES ('ROLE_USER');
29
30INSERT INTO users (email, password, first_name, last_name, active) VALUES ('admin@i.ua', '$2a$10$.qWuKeWQRAs6nPTzlocMAeSMhpgj.BT3mDnabIT5GxaDLzpelQx.q', 'John', 'Doe', true);
31INSERT INTO users (email, password, first_name, last_name, active) VALUES ('user@i.ua', '$2a$10$gvKH/w5JOo5lM/a1QavFae97BbL97VcSIberHaPLDRB68IDDWEZPK', 'Jane', 'Doe', true);
32
33INSERT INTO user_roles (user_id, role_id) VALUES (1, 1);
34INSERT INTO user_roles (user_id, role_id) VALUES (2, 2);