aboutsummaryrefslogtreecommitdiffstats
path: root/install/database.sql
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2012-12-04 18:24:46 -0800
committerfriendica <info@friendica.com>2012-12-04 18:24:46 -0800
commite17ba14696d6ee7532bacce6b5519594e001f13f (patch)
tree490c90c8ec7cebc3fec94a7ad4c1eab4e9bacab3 /install/database.sql
parent707397580c1c4547c0e308f90df61bc68e91b219 (diff)
downloadvolse-hubzilla-e17ba14696d6ee7532bacce6b5519594e001f13f.tar.gz
volse-hubzilla-e17ba14696d6ee7532bacce6b5519594e001f13f.tar.bz2
volse-hubzilla-e17ba14696d6ee7532bacce6b5519594e001f13f.zip
DB: do the mail table again. Mail almost working onsite, still needs to zot though
Diffstat (limited to 'install/database.sql')
-rw-r--r--install/database.sql10
1 files changed, 6 insertions, 4 deletions
diff --git a/install/database.sql b/install/database.sql
index bcdf969c4..24c9b9922 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -594,7 +594,8 @@ CREATE TABLE IF NOT EXISTS `item_id` (
CREATE TABLE IF NOT EXISTS `mail` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`mail_flags` int(10) unsigned NOT NULL DEFAULT '0',
- `author_xchan` char(255) NOT NULL DEFAULT '',
+ `from_xchan` char(255) NOT NULL DEFAULT '',
+ `to_xchan` char(255) NOT NULL DEFAULT '',
`account_id` int(10) unsigned NOT NULL DEFAULT '0',
`channel_id` int(10) unsigned NOT NULL,
`title` char(255) NOT NULL,
@@ -606,11 +607,12 @@ CREATE TABLE IF NOT EXISTS `mail` (
KEY `uri` (`uri`),
KEY `created` (`created`),
KEY `mail_flags` (`mail_flags`),
- KEY `author_xchan` (`author_xchan`),
KEY `account_id` (`account_id`),
KEY `channel_id` (`channel_id`),
- KEY `parent_uri` (`parent_uri`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+ KEY `parent_uri` (`parent_uri`),
+ KEY `from_xchan` (`from_xchan`),
+ KEY `to_xchan` (`to_xchan`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `manage` (
`id` int(11) NOT NULL AUTO_INCREMENT,