From 79a6b70a26bdfc8e02b94ecef3d20559590eacc7 Mon Sep 17 00:00:00 2001 From: Friendika Date: Sun, 13 Mar 2011 21:53:39 -0700 Subject: friend finder data structures --- database.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'database.sql') diff --git a/database.sql b/database.sql index f47a5967e..593e56746 100644 --- a/database.sql +++ b/database.sql @@ -479,3 +479,19 @@ CREATE TABLE IF NOT EXISTS `cache` ( `v` TEXT NOT NULL, `updated` DATETIME NOT NULL ) ENGINE = MYISAM DEFAULT CHARSET=utf8; + + +CREATE TABLE IF NOT EXISTS `fcontact` ( +`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , +`url` CHAR( 255 ) NOT NULL , +`name` CHAR( 255 ) NOT NULL , +`photo` CHAR( 255 ) NOT NULL +) ENGINE = MYISAM DEFAULT CHARSET=utf8; + +CREATE TABLE IF NOT EXISTS `ffinder` ( +`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , +`uid` INT UNSIGNED NOT NULL , +`cid` INT UNSIGNED NOT NULL , +`fid` INT UNSIGNED NOT NULL +) ENGINE = MYISAM DEFAULT CHARSET=utf8; + -- cgit v1.2.3