X-Git-Url: http://git.pk910.de/?p=NeonServV5.git;a=blobdiff_plain;f=database.upgrade.sql;h=bb26d92bdfcddccd2a0cfb79869e5db3be1eda5b;hp=f44c5eed6e8bf7534eff384798aba6ada552411e;hb=HEAD;hpb=053cd1002b31ad83d505dabce9f37b2a737fcabd diff --git a/database.upgrade.sql b/database.upgrade.sql index f44c5ee..bb26d92 100644 --- a/database.upgrade.sql +++ b/database.upgrade.sql @@ -18,3 +18,171 @@ ALTER TABLE `owner_history` CHANGE `owner_history_uid` `owner_history_to_uid` IN ALTER TABLE `owner_history` ADD `owner_history_from_uid` INT( 11 ) NOT NULL AFTER `owner_history_to_uid`; -- version: 3 + +ALTER TABLE `channels` + DROP `channel_scanstate`, + DROP `channel_scanexcept`, + DROP `channel_maxrepeat`, + DROP `channel_repeatreaction`, + DROP `channel_maxflood`, + DROP `channel_floodtime`, + DROP `channel_floodreaction`, + DROP `channel_maxjoin`, + DROP `channel_jointime`, + DROP `channel_joinreaction`; + +ALTER TABLE `channels` + ADD `channel_scanner` VARCHAR(50) NULL, + ADD `channel_spam_limit` SMALLINT(3) NULL, + ADD `channel_spam_reaction` TINYINT(1) NULL, + ADD `channel_spam_reaction_duration` MEDIUMINT(7) NULL, + ADD `channel_spam_except` SMALLINT(3) NULL, + ADD `channel_flood_limit` SMALLINT(3) NULL, + ADD `channel_flood_time` SMALLINT(3) NULL, + ADD `channel_flood_reaction` TINYINT(1) NULL, + ADD `channel_flood_reaction_duration` MEDIUMINT(7) NULL, + ADD `channel_flood_except` SMALLINT(3) NULL, + ADD `channel_join_limit` SMALLINT(3) NULL, + ADD `channel_join_time` SMALLINT(3) NULL, + ADD `channel_join_reaction` TINYINT(1) NULL, + ADD `channel_join_reaction_duration` MEDIUMINT(7) NULL, + ADD `channel_join_except` SMALLINT(3) NULL, + ADD `channel_botnet_bantime` MEDIUMINT(7) NULL, + ADD `channel_botnet_except` SMALLINT(3) NULL, + ADD `channel_caps_percent` TINYINT(3) NULL, + ADD `channel_caps_reaction` TINYINT(1) NULL, + ADD `channel_caps_reaction_duration` MEDIUMINT(7) NULL, + ADD `channel_caps_except` SMALLINT(3) NULL, + ADD `channel_digit_percent` TINYINT(3) NULL, + ADD `channel_digit_reaction` TINYINT(1) NULL, + ADD `channel_digit_reaction_duration` MEDIUMINT(7) NULL, + ADD `channel_digit_except` SMALLINT(3) NULL; + +-- version: 4 + +ALTER TABLE `bots` ADD `queue` TINYINT( 1 ) NOT NULL AFTER `textbot` + +-- version: 5 + +CREATE TABLE `donotregister` ( +`dnr_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , +`dnr_target` VARCHAR( 256 ) NOT NULL , +`dnr_user` INT( 11 ) NOT NULL , +`dnr_timeout` INT( 20 ) NOT NULL , +`dnr_reason` TEXT NOT NULL , +UNIQUE ( +`dnr_target` +) +) ENGINE = MYISAM ; + +-- version: 6 + +ALTER TABLE `fundata` CHANGE `uid` `user` VARCHAR( 50 ) NOT NULL; +ALTER TABLE `fundata` ADD INDEX ( `cid` ); +ALTER TABLE `fundata` ADD INDEX ( `user` ); +ALTER TABLE `fundata` ADD INDEX ( `name` ); + +-- version: 7 + +ALTER TABLE `bot_binds` ADD `botid` INT( 11 ) NOT NULL AFTER `botclass`; +ALTER TABLE `bot_binds` ADD INDEX ( `botclass` ); + +-- version: 8 + +ALTER TABLE `bot_channels` CHANGE `trigger` `trigger` VARCHAR( 50 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '+'; + +-- version: 9 + +ALTER TABLE `bot_binds` CHANGE `flags` `flags` INT( 10 ) NOT NULL ; + +-- version: 10 + +CREATE TABLE IF NOT EXISTS `helpserv_requests` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `host` varchar(200) NOT NULL, + `hand` varchar(50) NOT NULL, + `nick` varchar(50) NOT NULL, + `status` int(1) NOT NULL, + `supporter` int(11) NOT NULL, + `time` int(20) NOT NULL, + `text` text NOT NULL, + `log` text NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +CREATE TABLE IF NOT EXISTS `helpserv_settings` ( + `helpserv_botid` int(11) NOT NULL, + `helpserv_support` varchar(256) NOT NULL, + `helpserv_public` varchar(256) DEFAULT NULL, + `helpserv_intern` varchar(256) DEFAULT NULL, + PRIMARY KEY (`helpserv_botid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- version: 11 + +ALTER TABLE `helpserv_requests` ADD `botid` INT( 11 ) NOT NULL AFTER `id`; + +-- version: 12 + +ALTER TABLE `helpserv_settings` ADD `helpserv_intern_announce` TINYINT( 1 ) NOT NULL; + +-- version: 13 + +ALTER TABLE `channels` ADD `channel_canhalfop` SMALLINT( 3 ) NULL AFTER `channel_canop`; +ALTER TABLE `channels` ADD `channel_gethalfop` SMALLINT( 3 ) NULL AFTER `channel_getop`; +UPDATE `channels` SET `channel_canhalfop` = '150', +`channel_gethalfop` = '150' WHERE `channel_name` = 'defaults'; + +-- version: 14 + +ALTER TABLE `users` ADD `user_registered` INT( 20 ) NOT NULL , +ADD `user_lastcheck` INT( 20 ) NOT NULL; + +-- version: 15 + +CREATE TABLE IF NOT EXISTS `settings` ( + `name` varchar(100) NOT NULL, + `value` text NOT NULL, + PRIMARY KEY (`name`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- version: 16 + +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; + +ALTER TABLE `channels` ADD `channel_badword_reaction` TINYINT( 1 ) NULL , +ADD `channel_badword_reaction_duration` MEDIUMINT( 7 ) NULL AFTER `channel_badword_reaction` , +ADD `channel_badword_except` SMALLINT( 3 ) NULL AFTER `channel_badword_reaction_duration`; + +UPDATE `channels` SET `channel_badword_reaction` = '0', +`channel_badword_reaction_duration` = '60', +`channel_badword_except` = '400' WHERE `channel_name` = 'defaults'; + +-- version: 17 + +ALTER TABLE `bots` ADD `oper_user` VARCHAR( 50 ) NULL AFTER `automodes` , +ADD `oper_pass` VARCHAR( 50 ) NULL AFTER `oper_user`; + +-- version: 18 + +ALTER TABLE `users` ADD `user_block_invites` TINYINT NOT NULL AFTER `user_reply_privmsg`; + +-- version: 19 + +ALTER TABLE `bots` ADD `secret` TINYINT( 1 ) NOT NULL AFTER `queue`; + +-- version: 20