From ff092976a9fdeeba96a0de13d013b9d838640c40 Mon Sep 17 00:00:00 2001 From: Martin Ashby Date: Fri, 4 Aug 2023 22:29:41 +0100 Subject: Convert comments to zig --- zig-comments/src/migrations/0_init.sql | 2 ++ zig-comments/src/migrations/1_capcha.sql | 6 ++++++ 2 files changed, 8 insertions(+) create mode 100644 zig-comments/src/migrations/0_init.sql create mode 100644 zig-comments/src/migrations/1_capcha.sql (limited to 'zig-comments/src/migrations') diff --git a/zig-comments/src/migrations/0_init.sql b/zig-comments/src/migrations/0_init.sql new file mode 100644 index 0000000..a799784 --- /dev/null +++ b/zig-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 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'); -- cgit v1.2.3-ZIG