GFSTqCwH

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