photo album finish, general cleanup begins

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 8493e9d1450471888d0ddd4ba20e5423c043b381..1411ec6da9bd1240f73099cdb20189e508cd47b8 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -142,6 +142,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   `body` text NOT NULL,
   `resource-id` char(255) NOT NULL,
   `like` mediumtext NOT NULL,
+  `dislike` mediumtext NOT NULL,
   `tag` mediumtext NOT NULL,
   `allow_cid` mediumtext NOT NULL,
   `allow_gid` mediumtext NOT NULL,
@@ -164,7 +165,6 @@ CREATE TABLE IF NOT EXISTS `item` (
   KEY `deleted` (`deleted`),
   KEY `last-child` (`last-child`),
   KEY `unseen` (`unseen`),
-  KEY `unseen_2` (`unseen`),
   FULLTEXT KEY `title` (`title`),
   FULLTEXT KEY `body` (`body`),
   FULLTEXT KEY `allow_cid` (`allow_cid`),