diff options
author | Santo Cariotti <santo@dcariotti.me> | 2021-03-17 14:16:22 +0100 |
---|---|---|
committer | GitHub <noreply@github.com> | 2021-03-17 14:16:22 +0100 |
commit | 5691c3e7c44b833b4d81c0080ad8179192259652 (patch) | |
tree | 9749fbf7ff0b9c887df5439aef793bc31c7f202e /schema.sql | |
parent | 896ab2a9fb4a34d82c70792a1114ac1a0f4ad6c0 (diff) | |
parent | 904c7e40a2d092eea87ca6d9ea80edce8a2aad2a (diff) |
Merge pull request #14 from gico-net/feat/add-commits
Add "Commit"'s endpoints
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 20 |
1 files changed, 10 insertions, 10 deletions
@@ -1,9 +1,9 @@ CREATE TABLE "repository" ( id uuid PRIMARY KEY NOT NULL, url varchar(255) UNIQUE NOT NULL, - created_at timestamp NOT NULL, - updated_at timestamp NOT NULL, - uploader_ip varchar(15) NOT NULL + created_at timestamp NOT NULL DEFAULT NOW(), + updated_at timestamp NOT NULL DEFAULT NOW(), + uploader_ip varchar(21) NOT NULL ); CREATE TABLE "email"( @@ -13,19 +13,19 @@ CREATE TABLE "email"( CREATE TABLE "commit" ( hash varchar(40) PRIMARY KEY NOT NULL, - tree varchar(40) REFERENCES commit(hash) NULL, + tree varchar(40) REFERENCES commit(hash) ON DELETE CASCADE NULL, text text NOT NULL, - date timestamp NOT NULL, - author_email varchar(120) REFERENCES email(email) NOT NULL, + date timestamptz NOT NULL, + author_email varchar(120) REFERENCES email(email) ON DELETE NO ACTION NOT NULL, author_name varchar(120) NOT NULL, - committer_email varchar(120) REFERENCES email(email) NOT NULL, + committer_email varchar(120) REFERENCES email(email) ON DELETE NO ACTION NOT NULL, committer_name varchar(120) NOT NULL, - repository_url varchar(256) REFERENCES repository(url) NOT NULL + repository_url varchar(256) REFERENCES repository(url) ON DELETE CASCADE NOT NULL ); CREATE TABLE "branch" ( id uuid PRIMARY KEY NOT NULL, name varchar(120) NOT NULL, - repository_id uuid REFERENCES repository(id) NOT NULL, - head varchar(40) REFERENCES commit(hash) NULL + repository_id uuid REFERENCES repository(id) ON DELETE CASCADE NOT NULL, + head varchar(40) REFERENCES commit(hash) ON DELETE SET NULL NULL ); |