-- migrate:up
CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    firstname TEXT NOT NULL,
    "name" TEXT NOT NULL,
    email TEXT NOT NULL UNIQUE,
    units INTEGER[] NOT NULL DEFAULT '{}',
    admin BOOLEAN NOT NULL DEFAULT false
);

-- migrate:down
DROP TABLE IF EXISTS users;