-- fraud check of new orders: score, reasons, held for staff review
ALTER TABLE orders ADD fraud_score SMALLINT NULL, ADD fraud_reasons VARCHAR(1000) NOT NULL DEFAULT '', ADD fraud_hold TINYINT(1) NOT NULL DEFAULT 0, ALGORITHM=INSTANT;
INSERT IGNORE INTO settings (k, v) VALUES ('fraud_enabled', '0'), ('fraud_hold_score', '50'), ('fraud_ipqs_key_enc', '');