mailimage2mysql/schema.sql
changeset 32 27a0248f5f27
equal deleted inserted replaced
31:edd04723b99a 32:27a0248f5f27
       
     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 );