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`