curly braces + spaces added

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 64d8d9f7d0cd605d3e5cc69a164241ca30e24b8b..c7ab893d722253fb1e6b36dbe28198c3ac5a3b42 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -1,6 +1,6 @@
 -- ------------------------------------------
--- Friendica 3.5.1-dev (Asparagus)
--- DB_UPDATE_VERSION 1213
+-- Friendica 3.5.2-dev (Asparagus)
+-- DB_UPDATE_VERSION 1215
 -- ------------------------------------------
 
 
@@ -204,18 +204,6 @@ CREATE TABLE IF NOT EXISTS `conv` (
         INDEX `uid` (`uid`)
 ) DEFAULT CHARSET=utf8mb4;
 
---
--- TABLE deliverq
---
-CREATE TABLE IF NOT EXISTS `deliverq` (
-       `id` int(10) unsigned NOT NULL auto_increment,
-       `cmd` varbinary(32) NOT NULL DEFAULT '',
-       `item` int(11) NOT NULL DEFAULT 0,
-       `contact` int(11) NOT NULL DEFAULT 0,
-        PRIMARY KEY(`id`),
-        UNIQUE INDEX `cmd_item_contact` (`cmd`,`item`,`contact`)
-) DEFAULT CHARSET=utf8mb4;
-
 --
 -- TABLE event
 --
@@ -532,6 +520,7 @@ CREATE TABLE IF NOT EXISTS `item` (
         INDEX `parent-uri` (`parent-uri`),
         INDEX `extid` (`extid`),
         INDEX `uid_id` (`uid`,`id`),
+        INDEX `uid_contactid_id` (`uid`,`contact-id`,`id`),
         INDEX `uid_created` (`uid`,`created`),
         INDEX `uid_unseen_contactid` (`uid`,`unseen`,`contact-id`),
         INDEX `uid_network_received` (`uid`,`network`,`received`),
@@ -1016,7 +1005,8 @@ CREATE TABLE IF NOT EXISTS `thread` (
         INDEX `uid_contactid_commented` (`uid`,`contact-id`,`commented`),
         INDEX `uid_contactid_created` (`uid`,`contact-id`,`created`),
         INDEX `uid_created` (`uid`,`created`),
-        INDEX `uid_commented` (`uid`,`commented`)
+        INDEX `uid_commented` (`uid`,`commented`),
+        INDEX `uid_wall_created` (`uid`,`wall`,`created`)
 ) DEFAULT CHARSET=utf8mb4;
 
 --