aboutsummaryrefslogtreecommitdiff
path: root/zig-comments/src/migrations/1_capcha.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 /zig-comments/src/migrations/1_capcha.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 'zig-comments/src/migrations/1_capcha.sql')
-rw-r--r--zig-comments/src/migrations/1_capcha.sql6
1 files changed, 0 insertions, 6 deletions
diff --git a/zig-comments/src/migrations/1_capcha.sql b/zig-comments/src/migrations/1_capcha.sql
deleted file mode 100644
index bf43331..0000000
--- a/zig-comments/src/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, id) values ('What is 1 + 3?', '4', 'de850c99-906b-4ff8-b8e7-fce3bccd89bc') on conflict do nothing;
-insert into capchas(question, answer, id) values ('If I have 3 apples and 4 pears, how many fruit do I have?', '7', 'c83e23a8-ec53-48d4-a468-a530dfa634b7') on conflict do nothing;
-insert into capchas(question, answer, id) values ('What is 3 squared?', '9', '798bf299-4e3b-4f98-acac-f0c41201b613') on conflict do nothing;
-insert into capchas(question, answer, id) values ('What is the meaning of life, the universe, and everything?', '42', '7025fcbf-ebe8-4679-809f-08d632591b03') on conflict do nothing;