{"slug":"aurora-heatmap","name":"Aurora Heatmap","description":"Beautiful like an aurora! A simple WordPress heatmap that can be completed with just a plugin.","author":"r3098","active_installs":20000,"version":"1.7.1","wp_org_url":"https://wordpress.org/plugins/aurora-heatmap/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"ahm_events","full_table_name":"wp_ahm_events","description":"Stores ahm events data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)   UNSIGNED","nullable":false,"primary_key":true},{"name":"page_id","type":"int(8)       UNSIGNED","nullable":false,"primary_key":false},{"name":"page_id2","type":"int(8)       UNSIGNED","nullable":false,"primary_key":false},{"name":"event","type":"tinyint(3)   UNSIGNED","nullable":false,"primary_key":false},{"name":"x","type":"mediumint(5) UNSIGNED","nullable":false,"primary_key":false},{"name":"y","type":"mediumint(7) UNSIGNED","nullable":false,"primary_key":false},{"name":"width","type":"mediumint(5) UNSIGNED","nullable":false,"primary_key":false},{"name":"height","type":"mediumint(7) UNSIGNED","nullable":false,"primary_key":false},{"name":"insert_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_ahm_events ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, page_id int(8) UNSIGNED NOT NULL, page_id2 int(8) UNSIGNED NOT NULL, event tinyint(3) UNSIGNED NOT NULL, x mediumint(5) UNSIGNED NOT NULL, y mediumint(7) UNSIGNED NOT NULL, width mediumint(5) UNSIGNED NOT NULL, height mediumint(7) UNSIGNED NOT NULL, insert_at datetime NOT NULL, PRIMARY KEY (id), KEY event (event), KEY page_id2 (page_id2), KEY insert_at (insert_at) ) {$charset_collate}\" );"},{"table_name":"ahm_pages","full_table_name":"wp_ahm_pages","description":"Stores ahm pages data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(8)   UNSIGNED","nullable":false,"primary_key":true},{"name":"url","type":"text","nullable":false,"primary_key":false},{"name":"url2","type":"text","nullable":false,"primary_key":false},{"name":"title","type":"text","nullable":false,"primary_key":false},{"name":"insert_at","type":"datetime","nullable":false,"primary_key":false},{"name":"update_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_ahm_pages ( id int(8) UNSIGNED NOT NULL AUTO_INCREMENT, url text NOT NULL, url2 text NOT NULL, title text NOT NULL, insert_at datetime NOT NULL, update_at datetime NOT NULL, PRIMARY KEY (id), KEY url (url({$max_index_length})), KEY url2 (url2({$max_index_length})) ) {$charset_collate}\" );"}],"table_count":2}