summaryrefslogtreecommitdiffstats
path: root/migrations
diff options
context:
space:
mode:
authorToby Vincent <tobyv@tobyvin.dev>2024-08-02 18:32:11 -0500
committerToby Vincent <tobyv@tobyvin.dev>2024-08-02 18:32:11 -0500
commit17ea17fc753df373ca9acee46f06d3cf31ca7084 (patch)
tree8aa646c75b2931316d417951da81e6f111c7a9ac /migrations
parent82cc3b8054f4b126b422d946ea694d282a41cd78 (diff)
Diffstat (limited to 'migrations')
-rw-r--r--migrations/20240417203222_create_task.up.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/migrations/20240417203222_create_task.up.sql b/migrations/20240417203222_create_task.up.sql
index fd8eb9c..2f4517f 100644
--- a/migrations/20240417203222_create_task.up.sql
+++ b/migrations/20240417203222_create_task.up.sql
@@ -5,8 +5,8 @@ CREATE TABLE task (
description TEXT,
remote BOOLEAN NOT NULL,
location TEXT,
- start_at TIMESTAMP WITH TIME ZONE,
- end_at TIMESTAMP WITH TIME ZONE,
+ start TIMESTAMP WITH TIME ZONE NOT NULL,
+ duration INTERVAL NOT NULL,
created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),
updated_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW()
);