X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=retriever%2Fdatabase.sql;h=23cac120748482fd99e57edc9f05f35497b8f262;hb=18784a484b04b5f74e6d4dca516b2dc20cffe953;hp=1661c1696ec6cda341c9a31a62168c4545dde360;hpb=022c0fdebd1cb7abbffc55b713e90e41568586d1;p=friendica-addons.git diff --git a/retriever/database.sql b/retriever/database.sql index 1661c169..23cac120 100644 --- a/retriever/database.sql +++ b/retriever/database.sql @@ -6,7 +6,7 @@ CREATE TABLE IF NOT EXISTS `retriever_rule` ( PRIMARY KEY (`id`), KEY `uid` (`uid`), KEY `contact-id` (`contact-id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +) DEFAULT CHARSET=utf8 COLLATE=utf8_bin; CREATE TABLE IF NOT EXISTS `retriever_item` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, @@ -18,7 +18,7 @@ CREATE TABLE IF NOT EXISTS `retriever_item` ( KEY `resource` (`resource`), KEY `all` (`item-uri`, `item-uid`, `contact-id`), PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +) DEFAULT CHARSET=utf8 COLLATE=utf8_bin; CREATE TABLE IF NOT EXISTS `retriever_resource` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, @@ -33,4 +33,4 @@ CREATE TABLE IF NOT EXISTS `retriever_resource` ( `http-code` smallint(1) unsigned NULL DEFAULT NULL, `redirect-url` varchar(800) CHARACTER SET ascii COLLATE ascii_bin NULL DEFAULT NULL, PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin +) DEFAULT CHARSET=utf8 COLLATE=utf8_bin