X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mailstream%2Fdatabase.sql;h=7ce7b64e58030fe1d06bacc1882b514f52f63b39;hb=86b2d830a5da62f90c22b5d3f15921a60de25f37;hp=438af3d3b44c53ebcd9387c6ed8b01a27fe4d8e9;hpb=d32b43feb8cf8c11289ba4dbc6c9486465f61543;p=friendica-addons.git

diff --git a/mailstream/database.sql b/mailstream/database.sql
index 438af3d3..7ce7b64e 100644
--- 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;