`ident` varchar(12) NOT NULL,
`realname` varchar(255) NOT NULL,
`automodes` varchar(20) NOT NULL,
+ `oper_user` varchar(50) DEFAULT NULL,
+ `oper_pass` varchar(50) DEFAULT NULL,
`botclass` int(10) NOT NULL,
`textbot` tinyint(1) NOT NULL,
`queue` tinyint(1) NOT NULL,
+ `secret` tinyint(1) NOT NULL,
`defaulttrigger` varchar(10) NOT NULL,
`max_channels` int(5) NOT NULL,
`register_priority` int(2) NOT NULL,
`channel_staticban` smallint(3) DEFAULT NULL,
`channel_protect` tinyint(1) DEFAULT NULL,
`channel_canop` smallint(3) DEFAULT NULL,
+ `channel_canhalfop` smallint(3) DEFAULT NULL,
`channel_canvoice` smallint(3) DEFAULT NULL,
`channel_getop` smallint(3) DEFAULT NULL,
+ `channel_gethalfop` smallint(3) DEFAULT NULL,
`channel_getvoice` smallint(3) DEFAULT NULL,
`channel_greeting` varchar(512) NOT NULL,
`channel_usergreeting` varchar(512) NOT NULL,
`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;
`user_god` tinyint(1) NOT NULL,
`user_lang` varchar(6) NOT NULL,
`user_reply_privmsg` tinyint(1) NOT NULL,
+ `user_block_invites` tinyint(1) NOT NULL,
+ `user_registered` INT(20) NOT NULL,
+ `user_lastcheck` INT(20) NOT NULL,
PRIMARY KEY (`user_id`),
UNIQUE KEY `user_user` (`user_user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
PRIMARY KEY (`helpserv_botid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `settings`
+--
+
+CREATE TABLE IF NOT EXISTS `settings` (
+ `name` varchar(100) NOT NULL,
+ `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 ;