From 5218f90d0b77f22bc513454da6cc3745f6c7f3a2 Mon Sep 17 00:00:00 2001 From: pk910 Date: Sun, 23 Oct 2011 00:55:23 +0200 Subject: [PATCH] updated database.sql --- database.sql | 35 +++++++++++++++++++++++++---------- 1 file changed, 25 insertions(+), 10 deletions(-) diff --git a/database.sql b/database.sql index 4c82678..5415230 100644 --- a/database.sql +++ b/database.sql @@ -105,16 +105,6 @@ CREATE TABLE IF NOT EXISTS `channels` ( `channel_greeting` varchar(512) NOT NULL, `channel_usergreeting` varchar(512) NOT NULL, `channel_userinfo` smallint(3) DEFAULT NULL, - `channel_scanstate` int(11) DEFAULT NULL, - `channel_scanexcept` smallint(3) DEFAULT NULL, - `channel_maxrepeat` smallint(5) DEFAULT NULL, - `channel_repeatreaction` tinyint(1) DEFAULT NULL, - `channel_maxflood` smallint(5) DEFAULT NULL, - `channel_floodtime` smallint(5) DEFAULT NULL, - `channel_floodreaction` tinyint(1) DEFAULT NULL, - `channel_maxjoin` smallint(5) DEFAULT NULL, - `channel_jointime` smallint(5) DEFAULT NULL, - `channel_joinreaction` tinyint(1) DEFAULT NULL, `channel_dynlimit` smallint(5) DEFAULT NULL, `channel_getinvite` smallint(3) DEFAULT NULL, `channel_topicmask` varchar(512) NOT NULL, @@ -137,6 +127,31 @@ CREATE TABLE IF NOT EXISTS `channels` ( `channel_registered` int(11) NOT NULL, `channel_registrator` int(11) NOT NULL, `channel_toys` tinyint(1) NOT NULL, + `channel_scanner` varchar(50) DEFAULT NULL, + `channel_spam_limit` smallint(3) DEFAULT NULL, + `channel_spam_reaction` tinyint(1) DEFAULT NULL, + `channel_spam_reaction_duration` mediumint(7) DEFAULT NULL, + `channel_spam_except` smallint(3) DEFAULT NULL, + `channel_flood_limit` smallint(3) DEFAULT NULL, + `channel_flood_time` smallint(3) DEFAULT NULL, + `channel_flood_reaction` tinyint(1) DEFAULT NULL, + `channel_flood_reaction_duration` mediumint(7) DEFAULT NULL, + `channel_flood_except` smallint(3) DEFAULT NULL, + `channel_join_limit` smallint(3) DEFAULT NULL, + `channel_join_time` smallint(3) DEFAULT NULL, + `channel_join_reaction` tinyint(1) DEFAULT NULL, + `channel_join_reaction_duration` mediumint(7) DEFAULT NULL, + `channel_join_except` smallint(3) DEFAULT NULL, + `channel_botnet_bantime` mediumint(7) DEFAULT NULL, + `channel_botnet_except` smallint(3) DEFAULT NULL, + `channel_caps_percent` tinyint(3) DEFAULT NULL, + `channel_caps_reaction` tinyint(1) DEFAULT NULL, + `channel_caps_reaction_duration` mediumint(7) DEFAULT NULL, + `channel_caps_except` smallint(3) DEFAULT NULL, + `channel_digit_percent` tinyint(3) DEFAULT NULL, + `channel_digit_reaction` tinyint(1) DEFAULT NULL, + `channel_digit_reaction_duration` mediumint(7) DEFAULT NULL, + `channel_digit_except` smallint(3) DEFAULT NULL, PRIMARY KEY (`channel_id`), UNIQUE KEY `channel_name` (`channel_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- 2.20.1