likes table for liking things besides posts and comments

1 files changed, 23 insertions, 1 deletions

diff --git a/install/update.php b/install/update.php
index 0d5d26237..4981acc5d 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1112 );
+define( 'UPDATE_VERSION' , 1113 );
 
 /**
  *
@@ -1251,3 +1251,25 @@ function update_r1111() {
 		return UPDATE_SUCCESS;
 	return UPDATE_FAILED;
 }
+
+function update_r1112() {
+	$r = q("CREATE TABLE IF NOT EXISTS `likes` (
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `liker` char(128) NOT NULL DEFAULT '',
+  `likee` char(128) NOT NULL DEFAULT '',
+  `iid` int(11) NOT NULL DEFAULT '0',
+  `verb` char(255) NOT NULL DEFAULT '',
+  `target_type` char(255) NOT NULL DEFAULT '',
+  `target` mediumtext NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `liker` (`liker`),
+  KEY `likee` (`likee`),
+  KEY `iid` (`iid`),
+  KEY `verb` (`verb`),
+  KEY `target_type` (`target_type`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8");
+
+	if($r)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+}