mailimage2mysql/schema.sql
author Tomas Zeman <tzeman@volny.cz>
Thu, 03 May 2018 11:54:46 +0200
changeset 53 09b1d3c0aa20
parent 32 27a0248f5f27
permissions -rw-r--r--
scala/mail-parser/mail-parser.sc: email parser (based on java mail api); ammonite.io script

CREATE TABLE images (
  id bigint NOT NULL AUTO_INCREMENT,
  file_name varchar(40) NOT NULL,
  orig_name varchar(255) NOT NULL,
  mime_type varchar(20),
  mail_from varchar(255),
  mail_date datetime,
  mail_message_id varchar(255),
  ts datetime NOT NULL,
  PRIMARY KEY(id)
);