YuTB9YKX

1--
2-- STATS DB
3--
4
5DROP TABLE IF EXISTS `wl_stats`.`pug_players`, `wl_stats`.`stats_reset`, `wl_stats`.`teams`, `wl_stats`.`team_matches`, `wl_stats`.`team_members`, `wl_stats`.`team_member_log`, `wl_stats`.`tournament`, `wl_stats`.`tournament_team_members`;
6
7ALTER TABLE `wl_stats`.`karma` CHANGE `date` `date` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
8
9ALTER TABLE `wl_stats`.`pugs` CHANGE `server` `serverip` INT(11) NULL DEFAULT NULL;
10ALTER TABLE `wl_stats`.`servers` CHANGE `server` `serverip` INT(11) NOT NULL DEFAULT '0';
11ALTER TABLE `wl_stats`.`server_players` CHANGE `server` `serverip` INT(11) NULL DEFAULT NULL;
12
13ALTER TABLE `wl_stats`.`servers`
14  DROP `dns`,
15  DROP `tvport`,
16  DROP `hostname`,
17  DROP `pass`,
18  DROP `group`,
19  DROP `map`,
20  DROP `maxplayers`,
21  DROP `engine`;
22
23
24--
25-- SERVERCP DB
26--
27
28ALTER TABLE `wl_servercp`.`box` CHANGE `ip` `serverip` INT(11) NOT NULL;
29ALTER TABLE `wl_servercp`.`box_ips` CHANGE `ip` `serverip` INT(11) NOT NULL;
30ALTER TABLE `wl_servercp`.`gameservers` CHANGE `ip` `serverip` INT(11) NOT NULL;
31
32ALTER TABLE `wl_servercp`.`gameservers` CHANGE `gameme` `hlstatsx` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;
33
34UPDATE `wl_servercp`.`gameservers` SET `dns`= NULL WHERE `dns` = '';
35UPDATE `wl_servercp`.`gameservers` SET `hlstatsx` = NULL WHERE boxid > 10;
36
37ALTER TABLE `wl_servercp`.`gameservers` ADD UNIQUE KEY `dns` (`dns`);
38
39
40--
41-- CACHE DB
42--
43
44DROP TABLE IF EXISTS `wl_cache`.`pub_servers`, `wl_cache`.`servers`, `wl_cache`.`gameme_ranks`, `wl_cache`.`ipn_log`, `wl_cache`.`ipn_orders`, `wl_cache`.`ipn_order_items`, `wl_cache`.`motd_players`;
45
46CREATE TABLE `wl_cache`.`donations_ipn` (
47  `txn_id` varchar(20) NOT NULL,
48  `amount` float NOT NULL,
49  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
50  `uid` int(11) NOT NULL,
51  `aid` int(11) NOT NULL,
52  `anonymous` tinyint(1) NOT NULL,
53  `full_request` text NOT NULL
54) ENGINE=InnoDB DEFAULT CHARSET=latin1;
55
56ALTER TABLE `wl_cache`.`donations_ipn` ADD PRIMARY KEY (`txn_id`);
57
58INSERT INTO `wl_cache`.`donations_ipn` (`txn_id`, `amount`, `date`, `uid`, `aid`, `anonymous`, `full_request`)
59SELECT `txn_id`, `amount`, `date`, `uid`, `aid`, `anonymous`, `original_request` FROM `wl_mybb`.`mybb_donations_ipn`;
60
61UPDATE `wl_cache`.`donations_ipn` SET `uid` = '1011', `aid` = '84664391', `anonymous` = '1' WHERE `donations_ipn`.`txn_id` = '7';
62
63
64
65--
66-- MYBB DB
67--
68
69DROP TABLE IF EXISTS `wl_mybb`.`mybb_donations_ipn`;
70
71ALTER TABLE `wl_mybb`.`mybb_steam` DROP `status`;
72
73ALTER TABLE `wl_mybb`.`mybb_steam` DROP INDEX `PRIMARY`;
74ALTER TABLE `wl_mybb`.`mybb_steam` DROP INDEX `uid`;
75
76DELETE FROM `wl_mybb`.`mybb_steam` WHERE aid IS NULL;
77
78ALTER TABLE `wl_mybb`.`mybb_steam` CHANGE `aid` `aid` INT(11) NOT NULL FIRST;
79ALTER TABLE `wl_mybb`.`mybb_steam` CHANGE `uid` `uid` INT(11) NULL DEFAULT NULL;
80ALTER TABLE `wl_mybb`.`mybb_steam` CHANGE `donation_expiration` `donation_expiration` DATETIME NULL DEFAULT NULL AFTER `uid`;
81
82ALTER TABLE `wl_mybb`.`mybb_steam`
83  ADD PRIMARY KEY (`aid`),
84  ADD UNIQUE KEY `uid` (`uid`);
85
86--
87-- BANS DB
88--
89
90DROP TABLE IF EXISTS `wl_bans`.`ban_data2_export`;
91DROP TABLE IF EXISTS `wl_bans`.`ban_data3`;
92DROP TABLE IF EXISTS `wl_bans`.`ban_data4`;
93DROP TABLE IF EXISTS `wl_bans`.`ban_data_orig`;
94DROP TABLE IF EXISTS `wl_bans`.`bans_export`;
95
96ALTER TABLE `wl_bans`.`action_log` CHANGE `server` `serverip` INT(11) NOT NULL;
97ALTER TABLE `wl_bans`.`ban_data2` CHANGE `server` `serverip` INT(11) NOT NULL DEFAULT '0';
98ALTER TABLE `wl_bans`.`ban_data2` CHANGE `server` `serverip` INT(11) NOT NULL DEFAULT '0';
99ALTER TABLE `wl_bans`.`ban_comments` CHANGE `editaid` `edit_aid` INT(11) NULL DEFAULT NULL;
100ALTER TABLE `wl_bans`.`ban_comments` CHANGE `created` `created` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;
101ALTER TABLE `wl_bans`.`action_log` CHANGE `taid` `target_aid` INT(11) NOT NULL;