--
-- Data model for acs-authentication
--
-- $Id: acs-authentication-create.sql,v 1.2 2026/11/21 15:49:41 gustafn Exp $
--

\i batch-job-tables-create.sql


create table auth_action_tokens (
    user_id integer constraint auth_action_tokens_user_fk
                    references users(user_id) on delete cascade,
    purpose varchar(64) not null,
    token_digest varchar(64) not null,
    expires_at numeric(12) not null,
    token_context varchar(4000),
    constraint auth_action_tokens_pk primary key (user_id, purpose),
    constraint auth_action_tokens_digest_un unique (token_digest)
);