CREATE TABLE account_deletion_requests (
    user_id CHAR(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
    id CHAR(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
    requested_at DATETIME(6) NOT NULL,
    PRIMARY KEY (user_id),
    UNIQUE KEY account_deletion_request_id (id),
    KEY account_deletion_request_date (requested_at),
    CONSTRAINT account_deletion_user_fk FOREIGN KEY (user_id) REFERENCES identity_users (id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;