summaryrefslogtreecommitdiff
path: root/install.sql
diff options
context:
space:
mode:
Diffstat (limited to 'install.sql')
-rw-r--r--install.sql17
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 */;