start building social graph

2 files changed, 26 insertions, 1 deletions

diff --git a/install/database.sql b/install/database.sql
index 6876514f2..5a17346e1 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -846,6 +846,17 @@ CREATE TABLE IF NOT EXISTS `xchan` (
   KEY `xchan_connurl` (`xchan_connurl`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
+CREATE TABLE IF NOT EXISTS `xlink` (
+  `xlink_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `xlink_xchan` char(255) NOT NULL DEFAULT '',
+  `xlink_link` char(255) NOT NULL DEFAULT '',
+  `xlink_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  PRIMARY KEY (`xlink_id`),
+  KEY `xlink_xchan` ( `xlink_xchan` ),
+  KEY `xlink_link` ( `xlink_link` ),
+  KEY `xlink_updated` ( `xlink_updated` )
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
 CREATE TABLE IF NOT EXISTS `xprof` (
   `xprof_hash` char(255) NOT NULL,
   `xprof_desc` char(255) NOT NULL DEFAULT '',
diff --git a/install/update.php b/install/update.php
index 614887709..075b2f8a6 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1013 );
+define( 'UPDATE_VERSION' , 1014 );
 
 /**
  *
@@ -197,3 +197,17 @@ ADD INDEX ( `xchan_connurl` )");
 		return UPDATE_SUCCESS;
 	return UPDATE_FAILED;
 }
+
+function update_r1013() {
+	$r = q"CREATE TABLE if not exists `xlink` (
+`xlink_id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+`xlink_xchan` CHAR( 255 ) NOT NULL DEFAULT '',
+`xlink_link` CHAR( 255 ) NOT NULL DEFAULT '',
+`xlink_updated` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
+) ENGINE = MYISAM ");
+
+	$r2 = q("alter table xlink add index ( xlink_xchan ), add index ( xlink link ), add index ( xlink_updated ) ");
+	if($r && $r2)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+}