mirror of
https://github.com/mCaptcha/mCaptcha.git
synced 2025-09-13 20:20:12 +00:00
13 lines
458 B
SQL
13 lines
458 B
SQL
CREATE TABLE IF NOT EXISTS mcaptcha_challenge_reason (
|
|
id SERIAL PRIMARY KEY NOT NULL,
|
|
name VARCHAR(40) NOT NULL UNIQUE
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS mcaptcha_challenge (
|
|
id SERIAL PRIMARY KEY NOT NULL,
|
|
reason INTEGER NOT NULL references mcaptcha_challenge_reason(ID) ON DELETE CASCADE,
|
|
user_id INTEGER NOT NULL references mcaptcha_users(ID) ON DELETE CASCADE,
|
|
challenge_id varchar(40) NOT NULL UNIQUE,
|
|
received timestamptz NOT NULL DEFAULT now()
|
|
);
|