hongbo-miao/hongbomiao.com

View on GitHub
api-node/postgres/init_up.sql

Summary

Maintainability
Test Coverage
create extension if not exists pgcrypto;

create table users
(
  id         uuid primary key     default gen_random_uuid(),
  email      text unique not null,
  password   text        not null,
  first_name text        not null,
  last_name  text        not null,
  bio        text,
  created_at timestamptz not null default now(),
  last_login timestamptz not null default now()
);