add enable_federated_downvotes site option

[lemmy.git] / migrations / 2023-06-21-153242_add_captcha / up.sql

diff --git a/migrations/2023-06-21-153242_add_captcha/up.sql b/migrations/2023-06-21-153242_add_captcha/up.sql
index 71467be6182e8e09eb5f93a09ef3b115306cd4d1..ede6f71feffe207bcd0f9544cc111e464e6ccd3e 100644 (file)
--- a/migrations/2023-06-21-153242_add_captcha/up.sql
+++ b/migrations/2023-06-21-153242_add_captcha/up.sql
@@ -1,5 +1,7 @@
-create table captcha_answer (
-    uuid text not null primary key,
-    answer text not null,
-    expires timestamp not null
+CREATE TABLE captcha_answer (
+    id serial PRIMARY KEY,
+    uuid uuid NOT NULL UNIQUE DEFAULT gen_random_uuid (),
+    answer text NOT NULL,
+    published timestamp NOT NULL DEFAULT now()
 );
+