From 55bf7e4cb403566d7172ef69b8f2f7393ac8627d Mon Sep 17 00:00:00 2001 From: Xe Iaso Date: Sun, 10 Jul 2022 20:29:07 +0000 Subject: basic notes support Signed-off-by: Xe Iaso --- 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