1
CREATE TABLE images (
2
id bigint NOT NULL AUTO_INCREMENT,
3
file_name varchar(40) NOT NULL,
4
orig_name varchar(255) NOT NULL,
5
mime_type varchar(20),
6
mail_from varchar(255),
7
mail_date datetime,
8
mail_message_id varchar(255),
9
ts datetime NOT NULL,
10
PRIMARY KEY(id)
11
);