aboutsummaryrefslogtreecommitdiffstats
path: root/install/database.sql
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2014-06-23 05:19:28 -0700
committerfriendica <info@friendica.com>2014-06-23 05:19:28 -0700
commit0cfcb023118444bac29014e06a14fc1af2d0cf75 (patch)
tree5f63da84a1ee111cd68481a184c314ae5407c8fd /install/database.sql
parentd43227a730927c88745c5c35029fd57562265e3e (diff)
downloadvolse-hubzilla-0cfcb023118444bac29014e06a14fc1af2d0cf75.tar.gz
volse-hubzilla-0cfcb023118444bac29014e06a14fc1af2d0cf75.tar.bz2
volse-hubzilla-0cfcb023118444bac29014e06a14fc1af2d0cf75.zip
ability to like things
Diffstat (limited to 'install/database.sql')
-rw-r--r--install/database.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/install/database.sql b/install/database.sql
index cb4846b52..e2b814067 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -581,6 +581,7 @@ CREATE TABLE IF NOT EXISTS `likes` (
`iid` int(10) unsigned NOT NULL DEFAULT '0',
`verb` char(255) NOT NULL DEFAULT '',
`target_type` char(255) NOT NULL DEFAULT '',
+ `target_id` char(128) NOT NULL DEFAULT '',
`target` mediumtext NOT NULL,
PRIMARY KEY (`id`),
KEY `channel_id` (`channel_id`),
@@ -588,7 +589,8 @@ CREATE TABLE IF NOT EXISTS `likes` (
KEY `likee` (`likee`),
KEY `iid` (`iid`),
KEY `verb` (`verb`),
- KEY `target_type` (`target_type`)
+ KEY `target_type` (`target_type`),
+ KEY `target_id` (`target_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `mail` (