postgresql init example file

sample.sql

CREATE USER username WITH PASSWORD 'password';

CREATE DATABASE database;

CREATE EXTENSION IF NOT EXIST "uuid-ossp";

GRANT ALL PRIVILEGES ON DATABASE database to username;

CREATE TABLE IF NOT EXISTS users (
  id          SERIAL    PRIMARY KEY,
  user_id     uuid      DEFAULT uuid_generate_v4(),
  email       VARCHAR   NOT NULL,
  name        TEXT      NOT NULL,
  created_at  DATE      NOT NULL,
  updated_at  DATE      NOT NULL
);
  
CREATE TABLE IF NOT EXISTS posts (
  id          SERIAL    PRIMARY KEY,
  created_at  DATE      NOT NULL,
  updated_at  DATE      NOT NULL,
  users_id    INT       references USERS(id)
);