Replaced check with hardwired path

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 93f9bbef7e7e334a0e9f3acf16f468ce592bc133..1d632eb3fbfc6e0d9e907ab495b416fc95b90a1b 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -1071,8 +1071,8 @@ CREATE TABLE IF NOT EXISTS `post-category` (
        `type` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '',
        `tid` int unsigned NOT NULL DEFAULT 0 COMMENT '',
         PRIMARY KEY(`uri-id`,`uid`,`type`,`tid`),
-        INDEX `uri-id` (`tid`),
-        INDEX `uid` (`uid`),
+        INDEX `tid` (`tid`),
+        INDEX `uid_uri-id` (`uid`,`uri-id`),
        FOREIGN KEY (`uri-id`) REFERENCES `item-uri` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE,
        FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE,
        FOREIGN KEY (`tid`) REFERENCES `tag` (`id`) ON UPDATE RESTRICT ON DELETE RESTRICT
@@ -1132,7 +1132,7 @@ CREATE TABLE IF NOT EXISTS `post-delivery` (
        FOREIGN KEY (`uri-id`) REFERENCES `item-uri` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE,
        FOREIGN KEY (`inbox-id`) REFERENCES `item-uri` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE,
        FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE
-) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Status of ActivityPub inboxes';
+) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Delivery data for posts for the batch processing';
 
 --
 -- TABLE post-delivery-data