migrations/2020-06-23-134458_create_repositories/up.sql


1
2
3
4
5
6
7
8

CREATE TABLE repositories (
    id SERIAL NOT NULL PRIMARY KEY,
    name varchar(255) NOT NULL,
    description varchar(255) NOT NULL,
    owner bigint UNSIGNED NOT NULL,
    created timestamp NOT NULL DEFAULT current_timestamp(),
    CONSTRAINT fk_owner_id FOREIGN KEY (owner) REFERENCES users (id)
);