Warning, file /webapps/ocs-webserver/sql_code/20190104_add_suspicious_table.sql was not indexed or was modified since last indexation (in which case cross-reference links may be missing, inaccurate or erroneous).

0001 CREATE TABLE IF NOT EXISTS `suspicion_log`
0002 (
0003     `suspicion_id` INT          NOT NULL AUTO_INCREMENT,
0004     `project_id`   INT(11)      NOT NULL,
0005     `member_id`    INT(11)      NOT NULL,
0006     `http_referer` VARCHAR(255) NULL,
0007     `http_origin`  VARCHAR(255) NULL,
0008     `client_ip`    VARCHAR(45)  NULL,
0009     `user_agent`   VARCHAR(255) NULL,
0010     `suspicious`   INT(1)       NULL DEFAULT 0,
0011     PRIMARY KEY (`suspicion_id`),
0012     INDEX `idxProject` (`project_id` ASC),
0013     INDEX `idxMember` (`member_id` ASC)
0014 )
0015     ENGINE = MyISAM;