mailimage2mysql/schema.sql
changeset 32 27a0248f5f27
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/mailimage2mysql/schema.sql	Thu Sep 19 13:23:11 2013 +0200
@@ -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)
+);