12 lines
281 B
SQL
12 lines
281 B
SQL
-- 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;
|