CREATE TABLE pin_log (
	id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	actor INT NOT NULL,
	target INT NOT NULL,
	old_pin VARCHAR(16) NOT NULL,
	new_pin VARCHAR(16) NOT NULL,
	mobile_notified VARCHAR(16) DEFAULT NULL,
	when_executed TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB;
