-
Notifications
You must be signed in to change notification settings - Fork 5
/
db_query.sql
33 lines (30 loc) · 982 Bytes
/
db_query.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
DROP DATABASE angular_crud;
CREATE DATABASE angular_crud;
CREATE TABLE user_app(
id SERIAL PRIMARY KEY,
user_name VARCHAR(250) NOT NULL UNIQUE,
email VARCHAR(500) NOT NULL UNIQUE,
password VARCHAR(500) NOT NULL,
password_token VARCHAR(500) NULL,
created_at TIMESTAMP(6) NULL,
updated_at TIMESTAMP(6) NULL,
deleted_at TIMESTAMP(6) NULL
);
/*
Insert generic user for your first login, note that the password is encrypted
After insert login with this credentials:
- User: admin@email.com
- Password: 123123123
*/
INSERT INTO user_app(user_name, email, password)
VALUES ('admin', 'admin@email.com', '$2b$10$P6wWJsfsvRafgixqzwSbtu1TgkcJ4m3P3dL.TA8dtcwI9ZGi/ahQy');
CREATE TABLE client(
id SERIAL PRIMARY KEY,
first_name VARCHAR(250) NOT NULL,
last_name VARCHAR(250) NOT NULL,
age INTEGER NOT NULL ,
gender VARCHAR(20) NOT NULL ,
created_at TIMESTAMP(6) NULL,
updated_at TIMESTAMP(6) NULL,
deleted_at TIMESTAMP(6) NULL
);