mailimage2mysql/schema.sql
author Tomas Zeman <tomas@functionals.cz>
Tue, 15 Dec 2020 09:22:21 +0100
changeset 60 4267602e8494
parent 32 27a0248f5f27
permissions -rw-r--r--
fs2json: directory structure -> json object converter. E.g. to be used instead of erica / py-Couchapp (interaction with couchdb is left to the user).
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
32
27a0248f5f27 mailimage2mysql
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     1
CREATE TABLE images (
27a0248f5f27 mailimage2mysql
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     2
  id bigint NOT NULL AUTO_INCREMENT,
27a0248f5f27 mailimage2mysql
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     3
  file_name varchar(40) NOT NULL,
27a0248f5f27 mailimage2mysql
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     4
  orig_name varchar(255) NOT NULL,
27a0248f5f27 mailimage2mysql
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     5
  mime_type varchar(20),
27a0248f5f27 mailimage2mysql
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     6
  mail_from varchar(255),
27a0248f5f27 mailimage2mysql
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     7
  mail_date datetime,
27a0248f5f27 mailimage2mysql
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     8
  mail_message_id varchar(255),
27a0248f5f27 mailimage2mysql
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     9
  ts datetime NOT NULL,
27a0248f5f27 mailimage2mysql
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    10
  PRIMARY KEY(id)
27a0248f5f27 mailimage2mysql
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    11
);