From 19da6ec39be9e3caa5b9e2766139684fd7bbe0a0 Mon Sep 17 00:00:00 2001
From: Martin Ashby <martin@ashbysoft.com>
Date: Tue, 27 Dec 2022 23:24:54 +0000
Subject: Initial comments impl for my blog

---
 comments/migrations/0_init.sql | 2 ++
 1 file changed, 2 insertions(+)
 create mode 100644 comments/migrations/0_init.sql

(limited to 'comments/migrations/0_init.sql')

diff --git a/comments/migrations/0_init.sql b/comments/migrations/0_init.sql
new file mode 100644
index 0000000..4280a12
--- /dev/null
+++ b/comments/migrations/0_init.sql
@@ -0,0 +1,2 @@
+create table if not exists comments (url text not null, author text not null, comment text not null, ts timestamptz not null default now());
+create index if not exists idx_comments_url on comments(url);
-- 
cgit v1.2.3-ZIG