user_report

CREATE TABLE `sitedb`.`user_report` ( reporter_id BIGINT(20) NOT NULL, reported_id BIGINT(20) NOT NULL, description TEXT, create_date DATETIME DEFAULT NOW(), PRIMARY KEY (reporter_id, reported_id), FOREIGN KEY (reporter_id) REFERENCES user(id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (reported_id) REFERENCES user(id) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;