diff options
Diffstat (limited to 'migrations/2020-06-23-134458_create_repositories')
| -rw-r--r-- | migrations/2020-06-23-134458_create_repositories/down.sql | 1 | ||||
| -rw-r--r-- | migrations/2020-06-23-134458_create_repositories/up.sql | 8 |
2 files changed, 9 insertions, 0 deletions
diff --git a/migrations/2020-06-23-134458_create_repositories/down.sql b/migrations/2020-06-23-134458_create_repositories/down.sql new file mode 100644 index 0000000..2c8ff6d --- /dev/null +++ b/migrations/2020-06-23-134458_create_repositories/down.sql @@ -0,0 +1 @@ +DROP TABLE repositories; diff --git a/migrations/2020-06-23-134458_create_repositories/up.sql b/migrations/2020-06-23-134458_create_repositories/up.sql new file mode 100644 index 0000000..513d474 --- /dev/null +++ b/migrations/2020-06-23-134458_create_repositories/up.sql @@ -0,0 +1,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) +); |