wp_rezatain_redirections

Column Definitions

CREATE TABLE Statement

CREATE TABLE wp_rezatain_redirections ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, from_url VARCHAR(2048) NOT NULL, to_url VARCHAR(2048) NOT NULL, type SMALLINT(4) NOT NULL DEFAULT 301, hits BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, status VARCHAR(20) NOT NULL DEFAULT 'active', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY from_url_idx (from_url(191)) ) {$charset_collate}; CREATE TABLE wp_rezatain_404_log ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, url VARCHAR(2048) NOT NULL, referer VARCHAR(2048) DEFAULT '', user_agent VARCHAR(512) DEFAULT '', hits BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY url_unique (url(191)), KEY created_at_idx (created_at) ) {$charset_collate}; CREATE TABLE wp_rezatain_internal_links ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, post_id BIGINT(20) UNSIGNED NOT NULL, url VARCHAR(2048) NOT NULL, type VARCHAR(20) NOT NULL DEFAULT 'internal', anchor_text VARCHAR(512) DEFAULT '', PRIMARY KEY (id), KEY post_id_idx (post_id), KEY type_idx (type) ) {$charset_collate}; CREATE TABLE wp_rezatain_visitor_pageviews ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, page_path VARCHAR(500) NOT NULL, page_type VARCHAR(50) DEFAULT NULL, post_id BIGINT(20) UNSIGNED DEFAULT NULL, referrer_domain VARCHAR(255) DEFAULT NULL, referrer_type VARCHAR(20) NOT NULL DEFAULT 'direct', device_type VARCHAR(20) NOT NULL DEFAULT 'desktop', browser_family VARCHAR(50) DEFAULT NULL, os_family VARCHAR(50) DEFAULT NULL, country CHAR(2) DEFAULT NULL, viewport VARCHAR(20) DEFAULT NULL, visitor_hash VARCHAR(32) DEFAULT NULL, session_id VARCHAR(64) DEFAULT NULL, utm_source VARCHAR(150) DEFAULT NULL, utm_medium VARCHAR(150) DEFAULT NULL, utm_campaign VARCHAR(150) DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY created_at_idx (created_at), KEY page_path_idx (page_path(100)), KEY page_type_idx (page_type), KEY visitor_hash_idx (visitor_hash), KEY session_idx (session_id), KEY referrer_type_idx (referrer_type) ) {$charset_collate}; CREATE TABLE wp_rezatain_visitor_sessions ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, session_id VARCHAR(64) NOT NULL, visitor_id VARCHAR(64) DEFAULT NULL, landing_page VARCHAR(500) NOT NULL, exit_page VARCHAR(500) DEFAULT NULL, referrer_domain VARCHAR(255) DEFAULT NULL, referrer_type VARCHAR(20) NOT NULL DEFAULT 'direct', device_type VARCHAR(20) NOT NULL DEFAULT 'desktop', browser_family VARCHAR(50) DEFAULT NULL, os_family VARCHAR(50) DEFAULT NULL, country CHAR(2) DEFAULT NULL, page_count INT UNSIGNED NOT NULL DEFAULT 1, event_count INT UNSIGNED NOT NULL DEFAULT 0, duration_seconds INT UNSIGNED NOT NULL DEFAULT 0, max_scroll_pct TINYINT UNSIGNED NOT NULL DEFAULT 0, is_bounce TINYINT(1) NOT NULL DEFAULT 1, is_returning TINYINT(1) NOT NULL DEFAULT 0, started_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, last_activity_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY session_unique (session_id), KEY started_at_idx (started_at), KEY visitor_id_idx (visitor_id), KEY landing_idx (landing_page(100)) ) {$charset_collate}; CREATE TABLE wp_rezatain_visitor_events ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, session_id VARCHAR(64) NOT NULL, category VARCHAR(50) NOT NULL, action VARCHAR(100) NOT NULL, label VARCHAR(255) DEFAULT NULL, value INT DEFAULT NULL, page_path VARCHAR(500) DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY session_idx (session_id), KEY category_idx (category), KEY action_idx (action), KEY created_at_idx (created_at) ) {$charset_collate}; CREATE TABLE wp_rezatain_visitor_daily ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, stat_date DATE NOT NULL, page_path VARCHAR(500) DEFAULT NULL, page_type VARCHAR(50) DEFAULT NULL, pageviews INT UNSIGNED NOT NULL DEFAULT 0, unique_visitors INT UNSIGNED NOT NULL DEFAULT 0, unique_sessions INT UNSIGNED NOT NULL DEFAULT 0, avg_duration INT UNSIGNED NOT NULL DEFAULT 0, bounce_rate DECIMAL(5,2) NOT NULL DEFAULT 0.00, avg_scroll_pct TINYINT UNSIGNED NOT NULL DEFAULT 0, device_desktop INT UNSIGNED NOT NULL DEFAULT 0, device_mobile INT UNSIGNED NOT NULL DEFAULT 0, device_tablet INT UNSIGNED NOT NULL DEFAULT 0, referrer_direct INT UNSIGNED NOT NULL DEFAULT 0, referrer_search INT UNSIGNED NOT NULL DEFAULT 0, referrer_social INT UNSIGNED NOT NULL DEFAULT 0, referrer_website INT UNSIGNED NOT NULL DEFAULT 0, referrer_internal INT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY stat_date_idx (stat_date), KEY page_path_idx (page_path(100)) ) {$charset_collate}; CREATE TABLE wp_rezatain_broken_links ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, post_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, source_url VARCHAR(2048) NOT NULL, target_url VARCHAR(2048) NOT NULL, anchor_text VARCHAR(512) DEFAULT '', http_status SMALLINT(4) DEFAULT NULL, error_message VARCHAR(512) DEFAULT '', link_type VARCHAR(20) NOT NULL DEFAULT 'internal', first_found DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, last_checked DATETIME DEFAULT NULL, dismissed TINYINT(1) NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY post_id_idx (post_id), KEY target_url_idx (target_url(191)), KEY http_status_idx (http_status), KEY dismissed_idx (dismissed) ) {$charset_collate}; "; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_rezatain_redirections`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from RezaTain SEO