diff options
| author | friendica <info@friendica.com> | 2011-12-06 19:15:42 -0800 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2011-12-06 19:15:42 -0800 |
| commit | 7eba8adbf7ce1656b9c85f02b21fe46303b219e7 (patch) | |
| tree | b9f197666b827add55798b48c07aef8034642d86 /database.sql | |
| parent | 0c24784f5e92e0c8269f255e962312574871f2f0 (diff) | |
| download | volse-hubzilla-7eba8adbf7ce1656b9c85f02b21fe46303b219e7.tar.gz volse-hubzilla-7eba8adbf7ce1656b9c85f02b21fe46303b219e7.tar.bz2 volse-hubzilla-7eba8adbf7ce1656b9c85f02b21fe46303b219e7.zip | |
pm replies
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/database.sql b/database.sql index cdbc8a93b..1d57b9c6c 100644 --- a/database.sql +++ b/database.sql @@ -279,11 +279,19 @@ CREATE TABLE IF NOT EXISTS `mail` ( `title` char(255) NOT NULL, `body` mediumtext NOT NULL, `seen` tinyint(1) NOT NULL, + `reply` tinyint(1) NOT NULL DEFAULT '0', `replied` tinyint(1) NOT NULL, `uri` char(255) NOT NULL, `parent-uri` char(255) NOT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - PRIMARY KEY (`id`) + PRIMARY KEY (`id`), + KEY `uid` (`uid`), + KEY `guid` (`guid`), + KEY `convid` (`convid`), + KEY `reply` (`reply`), + KEY `uri` (`uri`), + KEY `parent-uri` (`parent-uri`), + KEY `created` (`created`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- |