feat(api,wip): impl tasks CRUD endpoint

2 files changed, 13 insertions, 0 deletions

diff --git a/migrations/20240417203222_create_task.down.sql b/migrations/20240417203222_create_task.down.sql
new file mode 100644
index 0000000..36cf80d
--- /dev/null
+++ b/migrations/20240417203222_create_task.down.sql
@@ -0,0 +1 @@
+DROP TABLE task;
diff --git a/migrations/20240417203222_create_task.up.sql b/migrations/20240417203222_create_task.up.sql
new file mode 100644
index 0000000..fd8eb9c
--- /dev/null
+++ b/migrations/20240417203222_create_task.up.sql
@@ -0,0 +1,12 @@
+CREATE TABLE task (
+	id UUID NOT NULL PRIMARY KEY DEFAULT uuid_generate_v4(),
+	user_id UUID REFERENCES user_(id) ON DELETE SET NULL,
+	title TEXT NOT NULL,
+	description TEXT,
+	remote BOOLEAN NOT NULL,
+	location TEXT,
+	start_at TIMESTAMP WITH TIME ZONE,
+	end_at TIMESTAMP WITH TIME ZONE,
+	created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),
+	updated_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW()
+);