From 573670fa0c8a3d8f111430985d263499b79a6ac0 Mon Sep 17 00:00:00 2001 From: Friendika Date: Tue, 1 Nov 2011 16:08:07 -0700 Subject: more social graph stuff --- database.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'database.sql') diff --git a/database.sql b/database.sql index 02701b740..eeb3700ff 100644 --- a/database.sql +++ b/database.sql @@ -66,6 +66,7 @@ CREATE TABLE IF NOT EXISTS `contact` ( `issued-id` char(255) NOT NULL, `dfrn-id` char(255) NOT NULL, `url` char(255) NOT NULL, + `nurl` char(255) NOT NULL, `addr` char(255) NOT NULL, `alias` char(255) NOT NULL, `pubkey` text NOT NULL, @@ -106,6 +107,7 @@ CREATE TABLE IF NOT EXISTS `contact` ( KEY `nick` (`nick`), KEY `attag` (`attag`), KEY `url` (`url`), + KEY `nurl` (`nurl`), KEY `addr` (`addr`), KEY `batch` (`batch`), KEY `issued-id` (`issued-id`), -- cgit v1.2.3