diff options
| author | friendica <info@friendica.com> | 2012-02-20 19:50:05 -0800 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-02-20 19:50:05 -0800 |
| commit | b821399f001cd4082707ba9fb6df9c419e0b8e5e (patch) | |
| tree | 1e858c850055542794c3f99d21517fdf897c5881 /database.sql | |
| parent | 6edd6d8ae1e3a6b64fa11ae6a4cc79965084b0d7 (diff) | |
| download | volse-hubzilla-b821399f001cd4082707ba9fb6df9c419e0b8e5e.tar.gz volse-hubzilla-b821399f001cd4082707ba9fb6df9c419e0b8e5e.tar.bz2 volse-hubzilla-b821399f001cd4082707ba9fb6df9c419e0b8e5e.zip | |
email notify now redirected through mod_notify, weirdness in local deliver caused by community page changes
Diffstat (limited to 'database.sql')
| -rwxr-xr-x | database.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/database.sql b/database.sql index 32d7cf40b..e051cdaac 100755 --- a/database.sql +++ b/database.sql @@ -741,6 +741,7 @@ CREATE TABLE IF NOT EXISTS `conv` ( CREATE TABLE IF NOT EXISTS `notify` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , +`hash` CHAR( 64 ) NOT NULL, `type` INT( 11 ) NOT NULL , `name` CHAR( 255 ) NOT NULL , `url` CHAR( 255 ) NOT NULL , @@ -752,6 +753,7 @@ CREATE TABLE IF NOT EXISTS `notify` ( `seen` TINYINT( 1 ) NOT NULL DEFAULT '0', `verb` CHAR( 255 ) NOT NULL, `otype` CHAR( 16 ) NOT NULL, +INDEX ( `hash` ), INDEX ( `type` ), INDEX ( `uid` ), INDEX ( `seen` ), |