aboutsummaryrefslogtreecommitdiff
path: root/zig-comments/src/migrations/1_capcha.sql
blob: c80a4bde0245001e4a9bce8f43c1816ce4e4ba83 (plain)
1
2
3
4
5
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');