diff options
| -rwxr-xr-x | boot.php | 2 | ||||
| -rwxr-xr-x | database.sql | 12 | ||||
| -rwxr-xr-x | update.php | 17 |
3 files changed, 29 insertions, 2 deletions
@@ -11,7 +11,7 @@ require_once('include/cache.php'); define ( 'FRIENDICA_PLATFORM', 'Friendica'); define ( 'FRIENDICA_VERSION', '2.3.1264' ); define ( 'DFRN_PROTOCOL_VERSION', '2.22' ); -define ( 'DB_UPDATE_VERSION', 1127 ); +define ( 'DB_UPDATE_VERSION', 1128 ); define ( 'EOL', "<br />\r\n" ); define ( 'ATOM_TIME', 'Y-m-d\TH:i:s\Z' ); 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; + diff --git a/update.php b/update.php index 8a2d891ca..865c6175e 100755 --- a/update.php +++ b/update.php @@ -1,6 +1,6 @@ <?php -define( 'UPDATE_VERSION' , 1127 ); +define( 'UPDATE_VERSION' , 1128 ); /** * @@ -1094,3 +1094,18 @@ function update_1126() { q("ALTER TABLE `mailacct` ADD `action` INT NOT NULL AFTER `pass`, ADD `movetofolder` CHAR(255) NOT NULL AFTER `action`"); } + +function update_1127() { + q("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"); +} + |