hays-hutton

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

hays-hutton

CREATE EXTENSION IF NOT EXISTS pgcrypto;

CREATE TABLE IF NOT EXISTS
users (
  email    TEXT PRIMARY KEY CHECK ( email ~* '^.+@.+\..+$' ),
  pass     TEXT NOT NULL CHECK (length(pass) < 256),
  role     NAME NOT NULL CHECK (length(role) < 256)
);

CREATE TABLE IF NOT EXISTS