{"slug":"epic-tracking","name":"Epic Tracking – Click & Event Tracking for WordPress","description":"Click and event tracking for WordPress. Point, click, and track — no code, no tag managers, no third-party scripts.","author":"EPICWP","active_installs":0,"version":"1.3.8","wp_org_url":"https://wordpress.org/plugins/epic-tracking/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"epictr_event_log","full_table_name":"wp_epictr_event_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"epictr_events","full_table_name":"wp_epictr_events","description":"Stores epictr 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_url","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"selector","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"reference_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"event_tag","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"event_type","type":"varchar(50)","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":"visitor_id","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"page_url","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"referrer","type":"varchar(500)","nullable":true,"primary_key":false},{"name":"user_agent","type":"varchar(500)","nullable":true,"primary_key":false},{"name":"device_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"browser","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"os","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"country","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"country_code","type":"varchar(2)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"event_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"visitor_id","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"page_url","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_epictr_events ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, page_url varchar(500) NOT NULL, selector varchar(500) NOT NULL, reference_name varchar(255) NOT NULL, event_tag varchar(100) NOT NULL, event_type varchar(50) NOT NULL DEFAULT 'click', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY page_url (page_url(191)) ) $charset; CREATE TABLE wp_epictr_visits ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, visitor_id varchar(64) NOT NULL, page_url varchar(500) NOT NULL, referrer varchar(500) DEFAULT '', user_agent varchar(500) DEFAULT '', device_type varchar(20) NOT NULL DEFAULT '', browser varchar(50) NOT NULL DEFAULT '', os varchar(50) NOT NULL DEFAULT '', country varchar(100) NOT NULL DEFAULT '', country_code varchar(2) NOT NULL DEFAULT '', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY visitor_id (visitor_id), KEY page_url (page_url(191)), KEY created_at (created_at), KEY device_type (device_type), KEY browser (browser), KEY os (os), KEY country_code (country_code) ) $charset; CREATE TABLE wp_epictr_event_log ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, event_id bigint(20) unsigned NOT NULL, visitor_id varchar(64) NOT NULL, page_url varchar(500) NOT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY event_id (event_id), KEY visitor_id (visitor_id), KEY created_at (created_at) ) $charset;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange dbDelta($sql);"},{"table_name":"epictr_visits","full_table_name":"wp_epictr_visits","description":"Stores epictr visits data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":3}