X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mailstream%2Fdatabase.sql;h=7ce7b64e58030fe1d06bacc1882b514f52f63b39;hb=dd08a0164894ef192111a3fc20124797ab8eee15;hp=be969ac738b03147deceb366f3d4473ce1791721;hpb=3ba1f2f9ced2e55c63266a601cd755124c91fb30;p=friendica-addons.git diff --git a/mailstream/database.sql b/mailstream/database.sql index be969ac7..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 COLLATION=utf8_bin; +) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;