`channel_digit_reaction` tinyint(1) DEFAULT NULL,
`channel_digit_reaction_duration` mediumint(7) DEFAULT NULL,
`channel_digit_except` smallint(3) DEFAULT NULL,
+ `channel_badword_reaction` tinyint(1) DEFAULT NULL,
+ `channel_badword_reaction_duration` mediumint(7) DEFAULT NULL,
+ `channel_badword_except` smallint(3) DEFAULT NULL,
PRIMARY KEY (`channel_id`),
UNIQUE KEY `channel_name` (`channel_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
`value` text NOT NULL,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `spamserv_badwords`
+--
+
+CREATE TABLE IF NOT EXISTS `spamserv_badwords` (
+ `badword_id` int(11) NOT NULL AUTO_INCREMENT,
+ `badword_cid` int(11) NOT NULL,
+ `badword_match` varchar(128) NOT NULL,
+ `badword_uid` int(11) NOT NULL,
+ `badword_use_default` tinyint(1) NOT NULL,
+ `badword_exceptlevel` smallint(3) NOT NULL,
+ `badword_scan_ops` tinyint(1) NOT NULL,
+ `badword_scan_voice` tinyint(1) NOT NULL,
+ `badword_use_default_reaction` tinyint(1) NOT NULL,
+ `badword_reaction` tinyint(1) NOT NULL,
+ `badword_reaction_time` int(20) NOT NULL,
+ PRIMARY KEY (`badword_id`),
+ KEY `badword_cid` (`badword_cid`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;