{"slug":"koko-analytics","name":"Koko Analytics – Privacy-Friendly WordPress Analytics","description":"WordPress analytics without cookies or third-party tracking. A fast, privacy-friendly Google Analytics alternative","author":"Danny van Kooten","active_installs":60000,"version":"2.5.0","wp_org_url":"https://wordpress.org/plugins/koko-analytics/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":true},"tables":[{"table_name":"koko_analytics_dates","full_table_name":"wp_koko_analytics_dates","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[{"name":"date","type":"DATE","nullable":false,"primary_key":true}],"create_sql":"CREATE TABLE wp_koko_analytics_dates ( date DATE PRIMARY KEY NOT NULL ) ENGINE"},{"table_name":"koko_analytics_paths","full_table_name":"wp_koko_analytics_paths","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT UNSIGNED","nullable":false,"primary_key":true},{"name":"path","type":"VARCHAR(2000)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_koko_analytics_paths ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, path VARCHAR(2000) NOT NULL, INDEX (path(255)) ) ENGINE"},{"table_name":"koko_analytics_post_stats","full_table_name":"wp_koko_analytics_post_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[{"name":"date","type":"DATE","nullable":false,"primary_key":false},{"name":"path_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"post_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"visitors","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"pageviews","type":"INT UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_koko_analytics_post_stats ( date DATE NOT NULL, path_id INT UNSIGNED NOT NULL, post_id INT UNSIGNED NOT NULL DEFAULT 0, visitors INT UNSIGNED NOT NULL DEFAULT 0, pageviews INT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (date, path_id) ) ENGINE"},{"table_name":"koko_analytics_referrer_stats","full_table_name":"wp_koko_analytics_referrer_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[{"name":"date","type":"DATE","nullable":false,"primary_key":false},{"name":"id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"visitors","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"pageviews","type":"INT UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_koko_analytics_referrer_stats ( date DATE NOT NULL, id INT UNSIGNED NOT NULL, visitors INT UNSIGNED NOT NULL DEFAULT 0, pageviews INT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (date, id) ) ENGINE"},{"table_name":"koko_analytics_referrer_urls","full_table_name":"wp_koko_analytics_referrer_urls","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT UNSIGNED","nullable":false,"primary_key":true},{"name":"url","type":"VARCHAR(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_koko_analytics_referrer_urls ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, url VARCHAR(255) NOT NULL, UNIQUE INDEX (url) ) ENGINE"},{"table_name":"koko_analytics_site_stats","full_table_name":"wp_koko_analytics_site_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[{"name":"date","type":"DATE","nullable":false,"primary_key":true},{"name":"visitors","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"pageviews","type":"INT UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_koko_analytics_site_stats ( date DATE PRIMARY KEY NOT NULL, visitors INT UNSIGNED NOT NULL DEFAULT 0, pageviews INT UNSIGNED NOT NULL DEFAULT 0 ) ENGINE"}],"table_count":6}