mirror of
https://github.com/mCaptcha/mCaptcha.git
synced 2025-09-14 12:40:11 +00:00
28 lines
661 B
SQL
28 lines
661 B
SQL
CREATE TABLE IF NOT EXISTS mcaptcha_challenge_reason (
|
|
id INT auto_increment,
|
|
PRIMARY KEY(id),
|
|
name VARCHAR(40) NOT NULL UNIQUE
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS mcaptcha_challenge (
|
|
id INT auto_increment,
|
|
PRIMARY KEY(id),
|
|
reason INT NOT NULL,
|
|
challenge_id varchar(40) NOT NULL UNIQUE,
|
|
received timestamp NOT NULL DEFAULT now(),
|
|
user_id INT NOT NULL,
|
|
|
|
CONSTRAINT `fk_mcaptcha_challenge_user`
|
|
FOREIGN KEY (user_id)
|
|
REFERENCES mcaptcha_users (ID)
|
|
ON DELETE CASCADE
|
|
ON UPDATE CASCADE,
|
|
|
|
CONSTRAINT `fk_mcaptcha_mcaptcha_challenge_reason`
|
|
FOREIGN KEY (reason)
|
|
REFERENCES mcaptcha_challenge_reason (id)
|
|
ON DELETE CASCADE
|
|
ON UPDATE CASCADE
|
|
|
|
);
|