aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2012-02-26 18:53:48 -0800
committerfriendica <info@friendica.com>2012-02-26 18:53:48 -0800
commitfc036210fb599cff936b647689362ebacf86a16b (patch)
treee216e1fa6007b8bbe4aa994cb7c9a7db6d8a23b9
parent6bc48b29ccdab1c9d48f159282f5dbd8eaa5d5ef (diff)
downloadvolse-hubzilla-fc036210fb599cff936b647689362ebacf86a16b.tar.gz
volse-hubzilla-fc036210fb599cff936b647689362ebacf86a16b.tar.bz2
volse-hubzilla-fc036210fb599cff936b647689362ebacf86a16b.zip
spam db
-rwxr-xr-xboot.php2
-rwxr-xr-xdatabase.sql12
-rwxr-xr-xupdate.php17
3 files changed, 29 insertions, 2 deletions
diff --git a/boot.php b/boot.php
index ada0f563d..bac7861c0 100755
--- a/boot.php
+++ b/boot.php
@@ -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");
+}
+