mailimage2mysql/schema.sql
changeset 38 3afc2ae852e5
parent 32 27a0248f5f27
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/mailimage2mysql/schema.sql	Wed Nov 06 14:34:41 2013 +0100
@@ -0,0 +1,11 @@
+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)
+);