1 -- Database upgrades (running all SQL commands below the matching "-- version: x" line)
5 CREATE TABLE `support_ranks` (
6 `rank_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
7 `rank_name` VARCHAR( 256 ) NOT NULL ,
8 `rank_access` INT( 4 ) NOT NULL ,
9 `rank_info` VARCHAR( 512 ) NOT NULL ,
10 `rank_order` SMALLINT( 4 ) NOT NULL
13 ALTER TABLE `users` ADD `user_rank` INT( 11 ) NOT NULL AFTER `user_access`;
17 ALTER TABLE `owner_history` CHANGE `owner_history_uid` `owner_history_to_uid` INT( 11 ) NOT NULL;
18 ALTER TABLE `owner_history` ADD `owner_history_from_uid` INT( 11 ) NOT NULL AFTER `owner_history_to_uid`;
22 ALTER TABLE `channels`
23 DROP `channel_scanstate`,
24 DROP `channel_scanexcept`,
25 DROP `channel_maxrepeat`,
26 DROP `channel_repeatreaction`,
27 DROP `channel_maxflood`,
28 DROP `channel_floodtime`,
29 DROP `channel_floodreaction`,
30 DROP `channel_maxjoin`,
31 DROP `channel_jointime`,
32 DROP `channel_joinreaction`;
34 ALTER TABLE `channels`
35 ADD `channel_scanner` VARCHAR(50) NULL,
36 ADD `channel_spam_limit` SMALLINT(3) NULL,
37 ADD `channel_spam_reaction` TINYINT(1) NULL,
38 ADD `channel_spam_reaction_duration` MEDIUMINT(7) NULL,
39 ADD `channel_spam_except` SMALLINT(3) NULL,
40 ADD `channel_flood_limit` SMALLINT(3) NULL,
41 ADD `channel_flood_time` SMALLINT(3) NULL,
42 ADD `channel_flood_reaction` TINYINT(1) NULL,
43 ADD `channel_flood_reaction_duration` MEDIUMINT(7) NULL,
44 ADD `channel_flood_except` SMALLINT(3) NULL,
45 ADD `channel_join_limit` SMALLINT(3) NULL,
46 ADD `channel_join_time` SMALLINT(3) NULL,
47 ADD `channel_join_reaction` TINYINT(1) NULL,
48 ADD `channel_join_reaction_duration` MEDIUMINT(7) NULL,
49 ADD `channel_join_except` SMALLINT(3) NULL,
50 ADD `channel_botnet_bantime` MEDIUMINT(7) NULL,
51 ADD `channel_botnet_except` SMALLINT(3) NULL,
52 ADD `channel_caps_percent` TINYINT(3) NULL,
53 ADD `channel_caps_reaction` TINYINT(1) NULL,
54 ADD `channel_caps_reaction_duration` MEDIUMINT(7) NULL,
55 ADD `channel_caps_except` SMALLINT(3) NULL,
56 ADD `channel_digit_percent` TINYINT(3) NULL,
57 ADD `channel_digit_reaction` TINYINT(1) NULL,
58 ADD `channel_digit_reaction_duration` MEDIUMINT(7) NULL,
59 ADD `channel_digit_except` SMALLINT(3) NULL;
63 ALTER TABLE `bots` ADD `queue` TINYINT( 1 ) NOT NULL AFTER `textbot`
67 CREATE TABLE `donotregister` (
68 `dnr_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
69 `dnr_target` VARCHAR( 256 ) NOT NULL ,
70 `dnr_user` INT( 11 ) NOT NULL ,
71 `dnr_timeout` INT( 20 ) NOT NULL ,
72 `dnr_reason` TEXT NOT NULL ,
80 ALTER TABLE `fundata` CHANGE `uid` `user` VARCHAR( 50 ) NOT NULL;
81 ALTER TABLE `fundata` ADD INDEX ( `cid` );
82 ALTER TABLE `fundata` ADD INDEX ( `user` );
83 ALTER TABLE `fundata` ADD INDEX ( `name` );
87 ALTER TABLE `bot_binds` ADD `botid` INT( 11 ) NOT NULL AFTER `botclass`;
88 ALTER TABLE `bot_binds` ADD INDEX ( `botclass` );
92 ALTER TABLE `bot_channels` CHANGE `trigger` `trigger` VARCHAR( 50 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '+';
96 ALTER TABLE `bot_binds` CHANGE `flags` `flags` INT( 10 ) NOT NULL ;
100 CREATE TABLE IF NOT EXISTS `helpserv_requests` (
101 `id` int(11) NOT NULL AUTO_INCREMENT,
102 `host` varchar(200) NOT NULL,
103 `hand` varchar(50) NOT NULL,
104 `nick` varchar(50) NOT NULL,
105 `status` int(1) NOT NULL,
106 `supporter` int(11) NOT NULL,
107 `time` int(20) NOT NULL,
108 `text` text NOT NULL,
111 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
113 CREATE TABLE IF NOT EXISTS `helpserv_settings` (
114 `helpserv_botid` int(11) NOT NULL,
115 `helpserv_support` varchar(256) NOT NULL,
116 `helpserv_public` varchar(256) DEFAULT NULL,
117 `helpserv_intern` varchar(256) DEFAULT NULL,
118 PRIMARY KEY (`helpserv_botid`)
119 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
123 ALTER TABLE `helpserv_requests` ADD `botid` INT( 11 ) NOT NULL AFTER `id`;
127 ALTER TABLE `helpserv_settings` ADD `helpserv_intern_announce` TINYINT( 1 ) NOT NULL;
131 ALTER TABLE `channels` ADD `channel_canhalfop` SMALLINT( 3 ) NULL AFTER `channel_canop`;
132 ALTER TABLE `channels` ADD `channel_gethalfop` SMALLINT( 3 ) NULL AFTER `channel_getop`;
133 UPDATE `channels` SET `channel_canhalfop` = '150',
134 `channel_gethalfop` = '150' WHERE `channel_name` = 'defaults';
138 ALTER TABLE `users` ADD `user_registered` INT( 20 ) NOT NULL ,
139 ADD `user_lastcheck` INT( 20 ) NOT NULL;
143 CREATE TABLE IF NOT EXISTS `settings` (
144 `name` varchar(100) NOT NULL,
145 `value` text NOT NULL,
147 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
151 CREATE TABLE IF NOT EXISTS `spamserv_badwords` (
152 `badword_id` int(11) NOT NULL AUTO_INCREMENT,
153 `badword_cid` int(11) NOT NULL,
154 `badword_match` varchar(128) NOT NULL,
155 `badword_uid` int(11) NOT NULL,
156 `badword_use_default` tinyint(1) NOT NULL,
157 `badword_exceptlevel` smallint(3) NOT NULL,
158 `badword_scan_ops` tinyint(1) NOT NULL,
159 `badword_scan_voice` tinyint(1) NOT NULL,
160 `badword_use_default_reaction` tinyint(1) NOT NULL,
161 `badword_reaction` tinyint(1) NOT NULL,
162 `badword_reaction_time` int(20) NOT NULL,
163 PRIMARY KEY (`badword_id`),
164 KEY `badword_cid` (`badword_cid`)
165 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
167 ALTER TABLE `channels` ADD `channel_badword_reaction` TINYINT( 1 ) NULL ,
168 ADD `channel_badword_reaction_duration` MEDIUMINT( 7 ) NULL AFTER `channel_badword_reaction` ,
169 ADD `channel_badword_except` SMALLINT( 3 ) NULL AFTER `channel_badword_reaction_duration`;
171 UPDATE `channels` SET `channel_badword_reaction` = '0',
172 `channel_badword_reaction_duration` = '60',
173 `channel_badword_except` = '400' WHERE `channel_name` = 'defaults';
177 ALTER TABLE `bots` ADD `oper_user` VARCHAR( 50 ) NULL AFTER `automodes` ,
178 ADD `oper_pass` VARCHAR( 50 ) NULL AFTER `oper_user`;
182 ALTER TABLE `users` ADD `user_block_invites` TINYINT NOT NULL AFTER `user_reply_privmsg`;
186 ALTER TABLE `bots` ADD `secret` TINYINT( 1 ) NOT NULL AFTER `queue`;