From a564a95ab40eb1c9cc7de142db60aedb3e749176 Mon Sep 17 00:00:00 2001 From: Michael Save Date: Thu, 12 Apr 2012 21:56:01 +1000 Subject: Improved Tinyboard anti-bot/spam filter. See large comment in inc/config.php for details. --- install.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) (limited to 'install.sql') 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 */; -- cgit v1.3