diff options
| author | Friendika <info@friendika.com> | 2011-03-13 21:53:39 -0700 |
|---|---|---|
| committer | Friendika <info@friendika.com> | 2011-03-13 21:53:39 -0700 |
| commit | 79a6b70a26bdfc8e02b94ecef3d20559590eacc7 (patch) | |
| tree | 82cab3bd26ffbb4551fbdc8c32fa6bdcd502f2a1 /database.sql | |
| parent | 0d161c6ef60e4bcfe36f0a9b1e090955156a162a (diff) | |
| download | volse-hubzilla-79a6b70a26bdfc8e02b94ecef3d20559590eacc7.tar.gz volse-hubzilla-79a6b70a26bdfc8e02b94ecef3d20559590eacc7.tar.bz2 volse-hubzilla-79a6b70a26bdfc8e02b94ecef3d20559590eacc7.zip | |
friend finder data structures
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 16 |
1 files changed, 16 insertions, 0 deletions
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; + |