From 2d80413609130f1c121dcae39a150a27dd9f02ea Mon Sep 17 00:00:00 2001
From: Joris
Date: Sat, 26 Feb 2022 18:35:24 +0100
Subject: Show repeated events

---
 src/db/migrations/1-init.sql | 16 ++++++++--------
 1 file changed, 8 insertions(+), 8 deletions(-)

(limited to 'src/db/migrations/1-init.sql')

diff --git a/src/db/migrations/1-init.sql b/src/db/migrations/1-init.sql
index a7db8b8..7e49764 100644
--- a/src/db/migrations/1-init.sql
+++ b/src/db/migrations/1-init.sql
@@ -1,10 +1,10 @@
 CREATE TABLE IF NOT EXISTS "events" (
-  "id" VARCHAR PRIMARY KEY,
-  "date" VARCHAR NOT NULL,
-  "start" VARCHAR NULL,
-  "end" VARCHAR NULL,
-  "name" VARCHAR NOT NULL,
-  "repetition" VARCHAR NULL,
-  "created" TIMESTAMP NOT NULL,
-  "updated" TIMESTAMP NOT NULL
+  "id" TEXT PRIMARY KEY, /* UUID */
+  "date" TEXT NOT NULL, /* DATE */
+  "start" TEXT NULL, /* TIME */
+  "end" TEXT NULL, /* TIME */
+  "name" TEXT NOT NULL,
+  "repetition" TEXT NULL, /* JSON */
+  "created" TEXT NOT NULL, /* DATETIME */
+  "updated" TEXT NOT NULL /* DATETIME */
 );
-- 
cgit v1.2.3

