CREATE TABLE users(
id INT PRIMARY KEY AUTO_INCREMENT,
first_name VARCHAR(30) NOT NULL,
last_name VARCHAR(30) NOT NULL,
email VARCHAR(200) UNIQUE KEY NOT NULL,
password VARCHAR(100) NOT NULL,
created datetime NOT NULL DEFAULT current_timestamp(),
updated datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
);


INSERT INTO users (first_name, last_name, email, password)
VALUES ('Vinicius', 'Fasolin', 'viniciusfasolin3@gmail.com', '$2y$10$LWoxVqOIuocA6CAz5YMB.uxTdOACHcTp4uUzi3lxjQydvShSGRzRm');



CREATE TABLE images(
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(80) UNIQUE KEY NOT NULL,
entity VARCHAR(80) NOT NULL,
entity_id INT NOT NULL,
link VARCHAR(400) UNIQUE KEY NOT NULL,
created datetime NOT NULL DEFAULT current_timestamp(),
updated datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
);


CREATE TABLE posts(
id INT PRIMARY KEY AUTO_INCREMENT,
user_id INT NOT NULL,
title VARCHAR(130) UNIQUE KEY NOT NULL,
description VARCHAR(9000) NOT NULL,
created datetime NOT NULL DEFAULT current_timestamp(),
updated datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
);