diff options
| author | friendica <info@friendica.com> | 2012-02-29 18:19:08 -0800 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-02-29 18:19:08 -0800 |
| commit | bbebb4c2a050f22e9aa51cb123359b169bcb3b3c (patch) | |
| tree | 691c6f2b64556df936a7f9e9b23a69b3873b962a /database.sql | |
| parent | 84d5f495e6e6edd7114b7e72711035e96479e39a (diff) | |
| download | volse-hubzilla-bbebb4c2a050f22e9aa51cb123359b169bcb3b3c.tar.gz volse-hubzilla-bbebb4c2a050f22e9aa51cb123359b169bcb3b3c.tar.bz2 volse-hubzilla-bbebb4c2a050f22e9aa51cb123359b169bcb3b3c.zip | |
notification enhancements
Diffstat (limited to 'database.sql')
| -rwxr-xr-x | database.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/database.sql b/database.sql index 8c74ecddf..806f75419 100755 --- a/database.sql +++ b/database.sql @@ -752,14 +752,18 @@ CREATE TABLE IF NOT EXISTS `notify` ( `msg` MEDIUMTEXT NOT NULL , `uid` INT NOT NULL , `link` CHAR( 255 ) NOT NULL , +`parent` INT( 11 ) NOT NULL, `seen` TINYINT( 1 ) NOT NULL DEFAULT '0', `verb` CHAR( 255 ) NOT NULL, `otype` CHAR( 16 ) NOT NULL, INDEX ( `hash` ), INDEX ( `type` ), INDEX ( `uid` ), +INDEX ( `link` ), +INDEX ( `parent` ), INDEX ( `seen` ), -INDEX ( `date` ) +INDEX ( `date` ), +INDEX ( `otype` ) ) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `item_id` ( |