-- Add up migration script here
CREATE TABLE IF NOT EXISTS projects (
	id SERIAL PRIMARY KEY,
	owner_id integer REFERENCES users NOT NULL,
	name VARCHAR(64) NOT NULL UNIQUE
);

CREATE UNIQUE INDEX unique_project_name ON projects(name);