diff options
| author | Michael <icarus@dabo.de> | 2012-02-27 16:31:58 +0100 |
|---|---|---|
| committer | Michael <icarus@dabo.de> | 2012-02-27 16:31:58 +0100 |
| commit | cce69f05097f559593c06e8595e1da5b904e5323 (patch) | |
| tree | 5b4f1d296723fdbbef6da28e67fc4c65c79e538e /database.sql | |
| parent | 18679111f5aed8f1c5e7ccb9857195e52c57765d (diff) | |
| parent | a33031634efef94c0985cd2517f10ccd36b40b5f (diff) | |
| download | volse-hubzilla-cce69f05097f559593c06e8595e1da5b904e5323.tar.gz volse-hubzilla-cce69f05097f559593c06e8595e1da5b904e5323.tar.bz2 volse-hubzilla-cce69f05097f559593c06e8595e1da5b904e5323.zip | |
Merge remote branch 'upstream/master'
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; + |