basic notes support

Signed-off-by: Xe Iaso <me@christine.website>

1 files changed, 11 insertions, 0 deletions

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);