aboutsummaryrefslogtreecommitdiff
path: root/comments/src/migrations/0_init.sql
diff options
context:
space:
mode:
authorMartin Ashby <martin@ashbysoft.com>2023-08-22 10:49:17 +0100
committerMartin Ashby <martin@ashbysoft.com>2023-08-22 10:49:17 +0100
commit7ed589a06539fcc91ab779a1e6de0a995f8238b5 (patch)
treef23bd017d43af4714280aea2d152379370393214 /comments/src/migrations/0_init.sql
parent8f7f272d68b4197f17d1e76c97546017b8ebea90 (diff)
downloadmfashby.net-7ed589a06539fcc91ab779a1e6de0a995f8238b5.tar.gz
mfashby.net-7ed589a06539fcc91ab779a1e6de0a995f8238b5.tar.bz2
mfashby.net-7ed589a06539fcc91ab779a1e6de0a995f8238b5.tar.xz
mfashby.net-7ed589a06539fcc91ab779a1e6de0a995f8238b5.zip
Replace comments with zig version
Diffstat (limited to 'comments/src/migrations/0_init.sql')
-rw-r--r--comments/src/migrations/0_init.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/comments/src/migrations/0_init.sql b/comments/src/migrations/0_init.sql
new file mode 100644
index 0000000..a799784
--- /dev/null
+++ b/comments/src/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); \ No newline at end of file