diff options
author | friendica <info@friendica.com> | 2013-01-01 23:56:27 -0800 |
---|---|---|
committer | friendica <info@friendica.com> | 2013-01-01 23:56:27 -0800 |
commit | 50d1cb2e3afe265004c7c08c8a63876c4b541469 (patch) | |
tree | 917fa3317eac2ec6f2d23462775e83fab014ce9d /install/database.sql | |
parent | 4d7fe15d3b31f7c5279b08c73e23cb21f906cd15 (diff) | |
download | volse-hubzilla-50d1cb2e3afe265004c7c08c8a63876c4b541469.tar.gz volse-hubzilla-50d1cb2e3afe265004c7c08c8a63876c4b541469.tar.bz2 volse-hubzilla-50d1cb2e3afe265004c7c08c8a63876c4b541469.zip |
start building social graph
Diffstat (limited to 'install/database.sql')
-rw-r--r-- | install/database.sql | 11 |
1 files changed, 11 insertions, 0 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 '', |