Index: openacs-4/packages/acs-templating/sql/oracle/captcha-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/sql/oracle/Attic/captcha-create.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/acs-templating/sql/oracle/captcha-create.sql	26 Jan 2022 16:06:08 -0000	1.1.2.1
+++ openacs-4/packages/acs-templating/sql/oracle/captcha-create.sql	17 Feb 2022 14:17:13 -0000	1.1.2.2
@@ -1,9 +1,14 @@
--- Captcha data-model (untested)
+-- Captcha data-model
+-- Note: in Postgres we can define the default for expiration as "one
+-- hour from now". This is apparently trickier in Oracle, so the
+-- default as defined by the datamodel is equal to automatic failure
+-- for the captcha check. In practice, this is fine, because the
+-- actual expiration we set in the widget code.
 
 create table template_widget_captchas (
    image_checksum text primary key,
    text text not null,
-   expiration timestamp not null default current_timestamp + cast('1 hour' as interval)
+   expiration timestamp not null default current_timestamp
 );
 
 create index template_widget_captchas_expiration_idx on template_widget_captchas(expiration);
