Create New Item
×
Item Type
File
Folder
Item Name
×
Search file in folder and subfolders...
File Manager
/
wp-content
/
plugins
/
redirection
/
database
/
schema
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php class Red_Database_231 extends Red_Database_Upgrader { public function get_stages() { return ['remove_404_module_231' => 'Remove 404 module', 'create_404_table_231' => 'Create 404 table']; } protected function remove_404_module_231($wpdb) { return $this->do_query($wpdb, "UPDATE {$wpdb->prefix}redirection_groups SET module_id=1 WHERE module_id=3"); } protected function create_404_table_231($wpdb) { $this->do_query($wpdb, $this->get_404_table($wpdb)); } private function get_404_table($wpdb) { $charset_collate = $this->get_charset(); return "CREATE TABLE `{$wpdb->prefix}redirection_404` (\n\t\t\t`id` int(11) unsigned NOT NULL AUTO_INCREMENT,\n\t\t\t`created` datetime NOT NULL,\n\t\t\t`url` varchar(255) NOT NULL DEFAULT '',\n\t\t\t`agent` varchar(255) DEFAULT NULL,\n\t\t\t`referrer` varchar(255) DEFAULT NULL,\n\t\t\t`ip` int(10) unsigned NOT NULL,\n\t\t\tPRIMARY KEY (`id`),\n\t\t\tKEY `created` (`created`),\n\t\t\tKEY `url` (`url`(191)),\n\t\t\tKEY `ip` (`ip`),\n\t\t\tKEY `referrer` (`referrer`(191))\n\t\t ) {$charset_collate}"; } }