"item_id" and "spam" aren't used

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index c058c06f51803750bde65d6fe233ae8825bf85fa..b41c0bc5459f9490346192d3acd74c811d32d458 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -535,22 +535,6 @@ CREATE TABLE IF NOT EXISTS `item` (
         INDEX `uid_ownerlink` (`uid`,`owner-link`(190))
 ) DEFAULT COLLATE utf8mb4_general_ci;
 
---
--- TABLE item_id
---
-CREATE TABLE IF NOT EXISTS `item_id` (
-       `id` int(11) NOT NULL auto_increment,
-       `iid` int(11) NOT NULL DEFAULT 0,
-       `uid` int(11) NOT NULL DEFAULT 0,
-       `sid` varchar(255) NOT NULL DEFAULT '',
-       `service` varchar(255) NOT NULL DEFAULT '',
-        PRIMARY KEY(`id`),
-        INDEX `uid` (`uid`),
-        INDEX `sid` (`sid`(32)),
-        INDEX `service` (`service`(32)),
-        INDEX `iid` (`iid`)
-) DEFAULT COLLATE utf8mb4_general_ci;
-
 --
 -- TABLE locks
 --