Merge pull request #486 from cvogeley/master

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 1faaf5f2e09104b57a218945099e529f9a2113ac..0f82616f7b0188d89f035a27049c195ab709ec38 100644 (file)
--- 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`)