diff options
| author | friendica <info@friendica.com> | 2012-02-26 18:53:48 -0800 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-02-26 18:53:48 -0800 |
| commit | fc036210fb599cff936b647689362ebacf86a16b (patch) | |
| tree | e216e1fa6007b8bbe4aa994cb7c9a7db6d8a23b9 /database.sql | |
| parent | 6bc48b29ccdab1c9d48f159282f5dbd8eaa5d5ef (diff) | |
| download | volse-hubzilla-fc036210fb599cff936b647689362ebacf86a16b.tar.gz volse-hubzilla-fc036210fb599cff936b647689362ebacf86a16b.tar.bz2 volse-hubzilla-fc036210fb599cff936b647689362ebacf86a16b.zip | |
spam db
Diffstat (limited to 'database.sql')
| -rwxr-xr-x | database.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/database.sql b/database.sql index ced646f59..349dd2a27 100755 --- a/database.sql +++ b/database.sql @@ -838,4 +838,16 @@ INDEX ( `master-parent-item` ), INDEX ( `receiver-uid` ) ) ENGINE = MyISAM DEFAULT CHARSET=utf8; +CREATE TABLE IF NOT EXISTS `spam` ( +`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , +`uid` INT NOT NULL, +`spam` INT NOT NULL DEFAULT '0', +`ham` INT NOT NULL DEFAULT '0', +`term` CHAR(255) NOT NULL, +INDEX ( `uid` ), +INDEX ( `spam` ), +INDEX ( `ham` ), +INDEX ( `term` ) +) ENGINE = MyISAM DEFAULT CHARSET=utf8; + |