From 55bf7e4cb403566d7172ef69b8f2f7393ac8627d Mon Sep 17 00:00:00 2001
From: Xe Iaso <me@christine.website>
Date: Sun, 10 Jul 2022 20:29:07 +0000
Subject: basic notes support

Signed-off-by: Xe Iaso <me@christine.website>
---
 src/migrate/base_schema.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 src/migrate/base_schema.sql

(limited to 'src/migrate/base_schema.sql')

diff --git a/src/migrate/base_schema.sql b/src/migrate/base_schema.sql
new file mode 100644
index 0000000..65d19d0
--- /dev/null
+++ b/src/migrate/base_schema.sql
@@ -0,0 +1,11 @@
+CREATE TABLE IF NOT EXISTS notes
+  ( id           INTEGER PRIMARY KEY
+  , content      TEXT    NOT NULL
+  , content_html TEXT    NOT NULL
+  , created_at   TEXT    NOT NULL     -- Unix epoch timestamp
+  , updated_at   TEXT                 -- Unix epoch timestamp
+  , deleted_at   TEXT                 -- Unix epoch timestamp
+  , reply_to     TEXT
+  );
+
+CREATE INDEX IF NOT EXISTS notes_reply_to ON notes(reply_to);
-- 
cgit v1.2.3

