-- Add migration script here

CREATE TABLE IF NOT EXISTS users
(
    username        TEXT NOT NULL,
    display_name    TEXT,
    image_url       TEXT NOT NULL,
    bio             TEXT,
    email           TEXT,
    password        TEXT NOT NULL,
    public_key      TEXT NOT NULL,
    enc_private_key TEXT NOT NULL
);

CREATE UNIQUE INDEX unique_username ON users (username);