{"slug":"rezatain-seo","name":"RezaTain SEO","description":"SEO-Plugin auf Deutsch: Titel & Meta, Schema, Sitemaps, Weiterleitungen, llms.txt, KI-Crawler und DSGVO-freundliche Statistik — lokal, ohne Konto.","author":"reza0tain0smart0solutions","active_installs":0,"version":"1.0.37","wp_org_url":"https://wordpress.org/plugins/rezatain-seo/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"ai_aide_","full_table_name":"wp_ai_aide_","description":"Stores ai aide  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"rezatain_","full_table_name":"wp_rezatain_","description":"Stores rezatain  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"rezatain_404_log","full_table_name":"wp_rezatain_404_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"rezatain_broken_links","full_table_name":"wp_rezatain_broken_links","description":"Stores rezatain broken links data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"rezatain_internal_links","full_table_name":"wp_rezatain_internal_links","description":"Stores rezatain internal links data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"rezatain_redirections","full_table_name":"wp_rezatain_redirections","description":"Stores rezatain redirections data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"from_url","type":"VARCHAR(2048)","nullable":false,"primary_key":false},{"name":"to_url","type":"VARCHAR(2048)","nullable":false,"primary_key":false},{"name":"type","type":"SMALLINT(4)","nullable":false,"primary_key":false},{"name":"hits","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"url","type":"VARCHAR(2048)","nullable":false,"primary_key":false},{"name":"referer","type":"VARCHAR(2048)","nullable":true,"primary_key":false},{"name":"user_agent","type":"VARCHAR(512)","nullable":true,"primary_key":false},{"name":"hits","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"post_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"url","type":"VARCHAR(2048)","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"anchor_text","type":"VARCHAR(512)","nullable":true,"primary_key":false},{"name":"page_path","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"page_type","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"post_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"referrer_domain","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"referrer_type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"device_type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"browser_family","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"os_family","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"country","type":"CHAR(2)","nullable":true,"primary_key":false},{"name":"viewport","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"visitor_hash","type":"VARCHAR(32)","nullable":true,"primary_key":false},{"name":"session_id","type":"VARCHAR(64)","nullable":true,"primary_key":false},{"name":"utm_source","type":"VARCHAR(150)","nullable":true,"primary_key":false},{"name":"utm_medium","type":"VARCHAR(150)","nullable":true,"primary_key":false},{"name":"utm_campaign","type":"VARCHAR(150)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"session_id","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"visitor_id","type":"VARCHAR(64)","nullable":true,"primary_key":false},{"name":"landing_page","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"exit_page","type":"VARCHAR(500)","nullable":true,"primary_key":false},{"name":"referrer_domain","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"referrer_type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"device_type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"browser_family","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"os_family","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"country","type":"CHAR(2)","nullable":true,"primary_key":false},{"name":"page_count","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"event_count","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"duration_seconds","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"max_scroll_pct","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"is_bounce","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"is_returning","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"started_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"last_activity_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"session_id","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"category","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"action","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"label","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"value","type":"INT","nullable":true,"primary_key":false},{"name":"page_path","type":"VARCHAR(500)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"stat_date","type":"DATE","nullable":false,"primary_key":false},{"name":"page_path","type":"VARCHAR(500)","nullable":true,"primary_key":false},{"name":"page_type","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"pageviews","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"avg_duration","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"bounce_rate","type":"DECIMAL(5,2)","nullable":false,"primary_key":false},{"name":"avg_scroll_pct","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"device_desktop","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"device_mobile","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"device_tablet","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"referrer_direct","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"referrer_search","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"referrer_social","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"referrer_website","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"referrer_internal","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"post_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"source_url","type":"VARCHAR(2048)","nullable":false,"primary_key":false},{"name":"target_url","type":"VARCHAR(2048)","nullable":false,"primary_key":false},{"name":"anchor_text","type":"VARCHAR(512)","nullable":true,"primary_key":false},{"name":"http_status","type":"SMALLINT(4)","nullable":true,"primary_key":false},{"name":"error_message","type":"VARCHAR(512)","nullable":true,"primary_key":false},{"name":"link_type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"first_found","type":"DATETIME","nullable":false,"primary_key":false},{"name":"last_checked","type":"DATETIME","nullable":true,"primary_key":false},{"name":"dismissed","type":"TINYINT(1)","nullable":false,"primary_key":false}],"create_sql":"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 );"},{"table_name":"rezatain_visitor_daily","full_table_name":"wp_rezatain_visitor_daily","description":"Stores rezatain visitor daily data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"rezatain_visitor_events","full_table_name":"wp_rezatain_visitor_events","description":"Stores rezatain visitor events data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"rezatain_visitor_pageviews","full_table_name":"wp_rezatain_visitor_pageviews","description":"Stores rezatain visitor pageviews data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"rezatain_visitor_sessions","full_table_name":"wp_rezatain_visitor_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":10}