aboutsummaryrefslogtreecommitdiff
path: root/zig-comments/src/migrations/1_capcha.sql
diff options
context:
space:
mode:
authorMartin Ashby <martin@ashbysoft.com>2023-08-04 22:29:41 +0100
committerMartin Ashby <martin@ashbysoft.com>2023-08-11 22:48:56 +0100
commitf3302ecb76be3f42d782d73a58552775416b5052 (patch)
tree69fd40b315af876b3885769cbf4dedd83f1783b1 /zig-comments/src/migrations/1_capcha.sql
parent6ee53f319847e7535b19d2661fa501bcb423ef42 (diff)
downloadmfashby.net-zig-comments.tar.gz
mfashby.net-zig-comments.tar.bz2
mfashby.net-zig-comments.tar.xz
mfashby.net-zig-comments.zip
Convert comments to zigzig-comments
Diffstat (limited to 'zig-comments/src/migrations/1_capcha.sql')
-rw-r--r--zig-comments/src/migrations/1_capcha.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/zig-comments/src/migrations/1_capcha.sql b/zig-comments/src/migrations/1_capcha.sql
new file mode 100644
index 0000000..c80a4bd
--- /dev/null
+++ b/zig-comments/src/migrations/1_capcha.sql
@@ -0,0 +1,6 @@
+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');