Revert "Move objects to src"

[friendica-addons.git] / mailstream / database.sql

diff --git a/mailstream/database.sql b/mailstream/database.sql
index 438af3d3b44c53ebcd9387c6ed8b01a27fe4d8e9..7ce7b64e58030fe1d06bacc1882b514f52f63b39 100644 (file)
--- a/mailstream/database.sql
+++ b/mailstream/database.sql
@@ -4,10 +4,10 @@ CREATE TABLE IF NOT EXISTS `mailstream_item` (
        `contact-id` int(11) NOT NULL,
        `uri` char(255) NOT NULL,
        `message-id` char(255) NOT NULL,
-       `created` timestamp NOT NULL DEFAULT now()',
+       `created` timestamp NOT NULL DEFAULT now(),
        `completed` timestamp NULL DEFAULT NULL,
        PRIMARY KEY (`id`),
        KEY `message-id` (`message-id`),
        KEY `created` (`created`),
        KEY `completed` (`completed`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;