diff options
| author | Simon L'nu <simon.lnu@gmail.com> | 2012-02-29 23:26:49 -0500 |
|---|---|---|
| committer | Simon L'nu <simon.lnu@gmail.com> | 2012-02-29 23:26:49 -0500 |
| commit | b7ab2a2fc92bbd7ec3a506e18f950579e10719eb (patch) | |
| tree | 951a691592d7a52a85267da7aba9c2d8e15a53bd /database.sql | |
| parent | 68554741465e92fe2e462b8de4470ddd0eb91302 (diff) | |
| parent | bd2c8c92f1b30d8f811bd4aab0fe3a2c5496ec61 (diff) | |
| download | volse-hubzilla-b7ab2a2fc92bbd7ec3a506e18f950579e10719eb.tar.gz volse-hubzilla-b7ab2a2fc92bbd7ec3a506e18f950579e10719eb.tar.bz2 volse-hubzilla-b7ab2a2fc92bbd7ec3a506e18f950579e10719eb.zip | |
Merge branch 'master', remote-tracking branch 'remotes/upstream/master'
* remotes/upstream/master:
yet more work on notifications
notification enhancements
better handling of multiple notifications for same item, and old notifications
* master:
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` ( |