CREATE DATABASE signature;
CREATE USER signature IDENTIFIED BY 'xxxxxxxx';
GRANT ALL ON signature.* TO 'signature'@'xx.xxx.xx.xxx' IDENTIFIED BY 'xxxxxxxx';
USE signature;


DROP TABLE emails;
CREATE TABLE emails (
     id INT(32) NOT NULL PRIMARY KEY AUTO_INCREMENT, 
     e_to TEXT,
     e_from TEXT,
     e_date TEXT,

     e_subject TEXT
);

DROP TABLE looks;
CREATE TABLE looks (
     id INT(32) NOT NULL PRIMARY KEY AUTO_INCREMENT,
     e_id INT(32),
     ip TEXT,
     useragent TEXT,
     date TEXT
);