Improved Tinyboard anti-bot/spam filter. See large comment in inc/config.php for details.

1 files changed, 17 insertions, 0 deletions

diff --git a/install.sql b/install.sql
index 2879e879..0a798198 100644
--- a/install.sql
+++ b/install.sql
@@ -228,6 +228,23 @@ CREATE TABLE IF NOT EXISTS `cites` (
   KEY `post` (`board`,`post`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `antispam`
+--
+
+CREATE TABLE IF NOT EXISTS `antispam` (
+  `board` varchar(255) NOT NULL,
+  `thread` int(11) DEFAULT NULL,
+  `hash` bigint(20) NOT NULL,
+  `created` int(11) NOT NULL,
+  `expires` int(11) DEFAULT NULL,
+  `passed` smallint(6) NOT NULL,
+  PRIMARY KEY (`hash`),
+  KEY `board` (`board`,`thread`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
 
 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;