diff options
| author | friendica <info@friendica.com> | 2012-01-31 23:54:53 -0800 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-01-31 23:54:53 -0800 |
| commit | c0c0f2dc151300f7578cf77a059403369edba07d (patch) | |
| tree | d6731b4a052e7f055bd79b1ebde81d22e26a7401 /database.sql | |
| parent | 86c0eac27d4ed2a454f752615a1b446cf2acd2b2 (diff) | |
| download | volse-hubzilla-c0c0f2dc151300f7578cf77a059403369edba07d.tar.gz volse-hubzilla-c0c0f2dc151300f7578cf77a059403369edba07d.tar.bz2 volse-hubzilla-c0c0f2dc151300f7578cf77a059403369edba07d.zip | |
add closeness attribute
Diffstat (limited to 'database.sql')
| -rwxr-xr-x | database.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/database.sql b/database.sql index 9a2e5c8dd..8abaa5a93 100755 --- a/database.sql +++ b/database.sql @@ -96,6 +96,7 @@ CREATE TABLE IF NOT EXISTS `contact` ( `pending` tinyint(1) NOT NULL DEFAULT '1', `rating` tinyint(1) NOT NULL DEFAULT '0', `reason` text NOT NULL, + `closeness` tinyint(2) NOT NULL DEFAULT '99', `info` mediumtext NOT NULL, `profile-id` int(11) NOT NULL DEFAULT '0', `bdyear` CHAR( 4 ) NOT NULL COMMENT 'birthday notify flag', @@ -116,7 +117,8 @@ CREATE TABLE IF NOT EXISTS `contact` ( KEY `blocked` (`blocked`), KEY `readonly` (`readonly`), KEY `hidden` (`hidden`), - KEY `pending` (`pending`) + KEY `pending` (`pending`), + KEY `closeness` (`closeness`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- |