wp_epictr_events
StaticStores epictr events data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| page_url | varchar(500) | NO |
| selector | varchar(500) | NO |
| reference_name | varchar(255) | NO |
| event_tag | varchar(100) | NO |
| event_type | varchar(50) | NO |
| created_at | datetime | NO |
| updated_at | datetime | NO |
| visitor_id | varchar(64) | NO |
| page_url | varchar(500) | NO |
| referrer | varchar(500) | YES |
| user_agent | varchar(500) | YES |
| device_type | varchar(20) | NO |
| browser | varchar(50) | NO |
| os | varchar(50) | NO |
| country | varchar(100) | NO |
| country_code | varchar(2) | NO |
| created_at | datetime | NO |
| event_id | bigint(20) unsigned | NO |
| visitor_id | varchar(64) | NO |
| page_url | varchar(500) | NO |
| created_at | datetime | NO |
CREATE TABLE Statement
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);
Safe to delete?
If you have uninstalled Epic Tracking – Click & Event Tracking for WordPress, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_epictr_events`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Epic Tracking – Click & Event Tracking for WordPress