{"slug":"amari-show","name":"Amari Show","description":"Amari Show is a professional and lightweight analytics plugin for WordPress.","author":"Alinazarimehr","active_installs":0,"version":"1.0.6","wp_org_url":"https://wordpress.org/plugins/amari-show/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"amari_","full_table_name":"wp_amari_","description":"Stores amari  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"amari_calendar","full_table_name":"wp_amari_calendar","description":"Stores amari calendar data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"calendar","full_table_name":"wp_calendar","description":"Stores calendar data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"post_hits","full_table_name":"wp_post_hits","description":"Stores post hits data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"referrer_hits","full_table_name":"wp_referrer_hits","description":"Stores referrer hits data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"referrers","full_table_name":"wp_referrers","description":"Stores referrers data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"site_hits","full_table_name":"wp_site_hits","description":"Stores site hits data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"hit_date","type":"DATE","nullable":false,"primary_key":false},{"name":"visit_count","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"view_count","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"post_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"visit_count","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"view_count","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"ref_url","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"ref_domain","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"ref_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"visit_count","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"view_count","type":"INT UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_site_hits ( hit_date DATE NOT NULL, visit_count INT UNSIGNED NOT NULL DEFAULT 0, view_count INT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (hit_date) ) $charset_collate;\"; // Post statistics table $sql[] = \"CREATE TABLE IF NOT EXISTS wp_post_hits ( hit_date DATE NOT NULL, post_id BIGINT UNSIGNED NOT NULL, visit_count INT UNSIGNED NOT NULL DEFAULT 0, view_count INT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (hit_date, post_id), KEY post_id (post_id) ) $charset_collate;\"; // Referrers table $sql[] = \"CREATE TABLE IF NOT EXISTS wp_referrers ( ref_id INT UNSIGNED NOT NULL AUTO_INCREMENT, ref_url VARCHAR(512) NOT NULL, ref_domain VARCHAR(255) NOT NULL, PRIMARY KEY (ref_id), UNIQUE KEY ref_domain (ref_domain) ) $charset_collate;\"; // Referrer statistics table $sql[] = \"CREATE TABLE IF NOT EXISTS wp_referrer_hits ( hit_date DATE NOT NULL, ref_id INT UNSIGNED NOT NULL, visit_count INT UNSIGNED NOT NULL DEFAULT 0, view_count INT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (hit_date, ref_id), KEY ref_id (ref_id) ) $charset_collate;\"; // Calendar table $sql[] = \"CREATE TABLE IF NOT EXISTS wp_calendar ( cal_date DATE NOT NULL PRIMARY KEY ) $charset_collate;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ($sql as $query) { dbDelta($query);"}],"table_count":7}