| 1 |
<?php |
| 2 |
|
| 3 |
class Red_Database_420 extends Red_Database_Upgrader { |
| 4 |
public function get_stages() { |
| 5 |
return [ |
| 6 |
'add_extra_logging' => 'Add extra logging support', |
| 7 |
'remove_module_id' => 'Remove module ID from logs', |
| 8 |
'remove_group_id' => 'Remove group ID from logs', |
| 9 |
'add_extra_404' => 'Add extra 404 logging support', |
| 10 |
'allow_null_agent' => 'Allow null log agent', |
| 11 |
'convert_404_url_to_text' => 'Convert 404 url to text', |
| 12 |
]; |
| 13 |
} |
| 14 |
|
| 15 |
protected function remove_module_id( $wpdb ) { |
| 16 |
return $this->do_query( $wpdb, "ALTER TABLE `{$wpdb->prefix}redirection_logs` DROP `module_id`" ); |
| 17 |
} |
| 18 |
|
| 19 |
protected function remove_group_id( $wpdb ) { |
| 20 |
return $this->do_query( $wpdb, "ALTER TABLE `{$wpdb->prefix}redirection_logs` DROP `group_id`" ); |
| 21 |
} |
| 22 |
|
| 23 |
protected function add_extra_logging( $wpdb ) { |
| 24 |
// Update any URL with a double slash at the end |
| 25 |
$this->do_query( $wpdb, "ALTER TABLE `{$wpdb->prefix}redirection_logs` ADD `domain` VARCHAR(255) NULL DEFAULT NULL AFTER `url`" ); |
| 26 |
$this->do_query( $wpdb, "ALTER TABLE `{$wpdb->prefix}redirection_logs` ADD `http_code` INT(11) unsigned NOT NULL DEFAULT 0 AFTER `referrer`" ); |
| 27 |
$this->do_query( $wpdb, "ALTER TABLE `{$wpdb->prefix}redirection_logs` ADD `request_method` VARCHAR(10) NULL DEFAULT NULL AFTER `http_code`" ); |
| 28 |
$this->do_query( $wpdb, "ALTER TABLE `{$wpdb->prefix}redirection_logs` ADD `redirect_by` VARCHAR(50) NULL DEFAULT NULL AFTER `request_method`" ); |
| 29 |
|
| 30 |
return $this->do_query( $wpdb, "ALTER TABLE `{$wpdb->prefix}redirection_logs` ADD `request_data` MEDIUMTEXT NULL DEFAULT NULL AFTER `request_method`" ); |
| 31 |
} |
| 32 |
|
| 33 |
protected function allow_null_agent( $wpdb ) { |
| 34 |
return $this->do_query( $wpdb, "ALTER TABLE `{$wpdb->prefix}redirection_logs` CHANGE COLUMN `agent` `agent` MEDIUMTEXT NULL" ); |
| 35 |
} |
| 36 |
|
| 37 |
protected function add_extra_404( $wpdb ) { |
| 38 |
// Update any URL with a double slash at the end |
| 39 |
$this->do_query( $wpdb, "ALTER TABLE `{$wpdb->prefix}redirection_404` ADD `domain` VARCHAR(255) NULL DEFAULT NULL AFTER `url`" ); |
| 40 |
$this->do_query( $wpdb, "ALTER TABLE `{$wpdb->prefix}redirection_404` ADD `http_code` INT(11) unsigned NOT NULL DEFAULT 0 AFTER `referrer`" ); |
| 41 |
$this->do_query( $wpdb, "ALTER TABLE `{$wpdb->prefix}redirection_404` ADD `request_method` VARCHAR(10) NULL DEFAULT NULL AFTER `http_code`" ); |
| 42 |
|
| 43 |
return $this->do_query( $wpdb, "ALTER TABLE `{$wpdb->prefix}redirection_404` ADD `request_data` MEDIUMTEXT NULL DEFAULT NULL AFTER `request_method`" ); |
| 44 |
} |
| 45 |
|
| 46 |
protected function convert_404_url_to_text( $wpdb ) { |
| 47 |
// Same as log table |
| 48 |
$this->do_query( $wpdb, "ALTER TABLE `{$wpdb->prefix}redirection_404` DROP INDEX `url`" ); |
| 49 |
return $this->do_query( $wpdb, "ALTER TABLE `{$wpdb->prefix}redirection_404` CHANGE COLUMN `url` `url` MEDIUMTEXT NOT NULL" ); |
| 50 |
} |
| 51 |
} |
| 52 |
|
