X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=0f82616f7b0188d89f035a27049c195ab709ec38;hb=0180ac563eebea23df3ffb95c35f5a9da164de52;hp=1faaf5f2e09104b57a218945099e529f9a2113ac;hpb=59d98647fbb5ea063b8de4e38d77847c90951e4e;p=friendica.git

diff --git a/database.sql b/database.sql
index 1faaf5f2e0..0f82616f7b 100644
--- a/database.sql
+++ b/database.sql
@@ -592,11 +592,13 @@ CREATE TABLE IF NOT EXISTS `item` (
 --
 
 CREATE TABLE IF NOT EXISTS `item_id` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
   `iid` int(11) NOT NULL,
   `uid` int(11) NOT NULL,
   `sid` char(255) NOT NULL,
   `service` char(255) NOT NULL,
-  PRIMARY KEY (`iid`),
+  PRIMARY KEY (`id`),
+  KEY `iid` (`iid`),
   KEY `uid` (`uid`),
   KEY `sid` (`sid`),
   KEY `service` (`service`)