summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--schema.sql20
1 files changed, 10 insertions, 10 deletions
diff --git a/schema.sql b/schema.sql
index 9daa7f9..ef066d7 100644
--- a/schema.sql
+++ b/schema.sql
@@ -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
);