prefix . $table; } /** * Generate SQL schemas for dbDelta. * * @return string[] */ public static function get_schemas() { global $wpdb; $collate = $wpdb->get_charset_collate(); $redirects_table = self::get_table_name( 'slugh_redirects' ); $jobs_table = self::get_table_name( 'slugh_jobs' ); $job_items_table = self::get_table_name( 'slugh_job_items' ); $scan_items_table = self::get_table_name( 'slugh_scan_items' ); $audit_log_table = self::get_table_name( 'slugh_audit_log' ); return array( // Redirects Table. "CREATE TABLE {$redirects_table} ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, source_path varchar(2048) NOT NULL, source_hash char(40) NOT NULL, source_raw text NOT NULL, destination text NOT NULL, destination_type varchar(20) NOT NULL DEFAULT 'internal', destination_hash char(40) NOT NULL DEFAULT '', status_code smallint(5) unsigned NOT NULL DEFAULT 301, match_mode varchar(20) NOT NULL DEFAULT '404_only', post_id bigint(20) unsigned DEFAULT NULL, job_id bigint(20) unsigned DEFAULT NULL, origin varchar(20) NOT NULL DEFAULT 'manual', enabled tinyint(1) NOT NULL DEFAULT 1, hits bigint(20) unsigned NOT NULL DEFAULT 0, last_hit_at datetime DEFAULT NULL, created_by bigint(20) unsigned DEFAULT NULL, created_at datetime NOT NULL, updated_at datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY source_hash (source_hash), KEY post_id (post_id), KEY job_id (job_id), KEY enabled (enabled), KEY destination_hash (destination_hash) ) {$collate};", // Jobs Table. "CREATE TABLE {$jobs_table} ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, type varchar(20) NOT NULL, status varchar(30) NOT NULL DEFAULT 'draft', `cursor` int(10) unsigned NOT NULL DEFAULT 0, counts longtext, settings longtext, parent_job_id bigint(20) unsigned DEFAULT NULL, created_by bigint(20) unsigned DEFAULT NULL, created_at datetime NOT NULL, confirmed_at datetime DEFAULT NULL, started_at datetime DEFAULT NULL, finished_at datetime DEFAULT NULL, PRIMARY KEY (id), KEY status (status), KEY created_at (created_at) ) {$collate};", // Job Items Table. "CREATE TABLE {$job_items_table} ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, job_id bigint(20) unsigned NOT NULL, post_id bigint(20) unsigned NOT NULL, kind varchar(20) NOT NULL DEFAULT 'direct', post_type varchar(50) NOT NULL, parent_id bigint(20) unsigned DEFAULT 0, old_post_name varchar(200) NOT NULL, requested_post_name varchar(200) NOT NULL, actual_post_name varchar(200) DEFAULT NULL, old_permalink text NOT NULL, expected_permalink text NOT NULL, actual_permalink text DEFAULT NULL, hash_before varchar(64) DEFAULT NULL, hash_after varchar(64) DEFAULT NULL, validation_state varchar(30) NOT NULL DEFAULT 'ok', result varchar(30) NOT NULL DEFAULT 'pending', message text, redirect_ids longtext, sort_order int(10) unsigned NOT NULL DEFAULT 0, updated_at datetime NOT NULL, PRIMARY KEY (id), KEY job_id_result (job_id, result), KEY job_id_sort (job_id, sort_order), KEY post_id (post_id) ) {$collate};", // Scan Items Table. "CREATE TABLE {$scan_items_table} ( scan_id bigint(20) unsigned NOT NULL, post_id bigint(20) unsigned NOT NULL, post_type varchar(50) NOT NULL, post_status varchar(20) NOT NULL, decoded_slug varchar(500) NOT NULL, flags int(10) unsigned NOT NULL DEFAULT 0, scripts varchar(255) NOT NULL DEFAULT '', permalink_hash char(40) NOT NULL DEFAULT '', scanned_at datetime NOT NULL, PRIMARY KEY (scan_id, post_id), KEY scan_id_post_type (scan_id, post_type), KEY scan_id_permalink (scan_id, permalink_hash) ) {$collate};", // Audit Log Table. "CREATE TABLE {$audit_log_table} ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, event varchar(50) NOT NULL, object_type varchar(50) NOT NULL, object_id bigint(20) unsigned DEFAULT NULL, job_id bigint(20) unsigned DEFAULT NULL, user_id bigint(20) unsigned DEFAULT NULL, before_value longtext, after_value longtext, created_at datetime NOT NULL, PRIMARY KEY (id), KEY object_type_id (object_type, object_id), KEY job_id (job_id), KEY created_at (created_at) ) {$collate};", ); } }