diff options
author | Martin Ashby <martin@ashbysoft.com> | 2023-08-22 10:49:17 +0100 |
---|---|---|
committer | Martin Ashby <martin@ashbysoft.com> | 2023-08-22 10:49:17 +0100 |
commit | 7ed589a06539fcc91ab779a1e6de0a995f8238b5 (patch) | |
tree | f23bd017d43af4714280aea2d152379370393214 /comments/migrations | |
parent | 8f7f272d68b4197f17d1e76c97546017b8ebea90 (diff) | |
download | mfashby.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/migrations')
-rw-r--r-- | comments/migrations/0_init.sql | 2 | ||||
-rw-r--r-- | comments/migrations/1_capcha.sql | 6 |
2 files changed, 0 insertions, 8 deletions
diff --git a/comments/migrations/0_init.sql b/comments/migrations/0_init.sql deleted file mode 100644 index 4280a12..0000000 --- a/comments/migrations/0_init.sql +++ /dev/null @@ -1,2 +0,0 @@ -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); diff --git a/comments/migrations/1_capcha.sql b/comments/migrations/1_capcha.sql deleted file mode 100644 index c80a4bd..0000000 --- a/comments/migrations/1_capcha.sql +++ /dev/null @@ -1,6 +0,0 @@ -create table if not exists capchas(question text not null, answer text not null, id uuid not null default gen_random_uuid()); -create unique index if not exists idx_capchas_id on capchas(id); -insert into capchas(question, answer) values ('What is 1 + 3?', '4'); -insert into capchas(question, answer) values ('If I have 3 apples and 4 pears, how many fruit do I have?', '7'); -insert into capchas(question, answer) values ('What is 3 squared?', '9'); -insert into capchas(question, answer) values ('What is the meaning of life, the universe, and everything?', '42'); |