diff options
author | Toby Vincent <tobyv@tobyvin.dev> | 2024-08-02 18:32:11 -0500 |
---|---|---|
committer | Toby Vincent <tobyv@tobyvin.dev> | 2024-08-02 18:32:11 -0500 |
commit | 17ea17fc753df373ca9acee46f06d3cf31ca7084 (patch) | |
tree | 8aa646c75b2931316d417951da81e6f111c7a9ac /migrations | |
parent | 82cc3b8054f4b126b422d946ea694d282a41cd78 (diff) |
wiptasks
Diffstat (limited to 'migrations')
-rw-r--r-- | migrations/20240417203222_create_task.up.sql | 4 |
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() ); |