wp_zestatix_element
StaticStores zestatix element data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | INT( 10 ) | NO |
| selector | VARCHAR( 255 ) | NO |
| browser_width | VARCHAR( 100 ) | NO |
| created | TIMESTAMP | NO |
| tracked | INT( 1 ) | NO |
| user_id | INT( 10 ) | NO |
| url_id | SMALLINT | NO |
| device | VARCHAR( 6 ) | NO |
| width | VARCHAR( 15 ) | NO |
| event | TIMESTAMP | NO |
| 🔑FOREIGN | KEY | NO |
| url | TEXT | NO |
| user | INT( 10 ) | NO |
| url | SMALLINT | NO |
| 🔑FOREIGN | KEY | NO |
| ip | VARCHAR( 40 ) | NO |
| location | VARCHAR( 50 ) | YES |
| login | VARCHAR( 50 ) | YES |
| url | TEXT | NO |
| subdir | INT( 1 ) | NO |
| FOREIGN | KEY | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_zestatix_element ( id INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY, selector VARCHAR( 255 ) NOT NULL UNIQUE, browser_width VARCHAR( 100 ) NOT NULL, created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, tracked INT( 1 ) NOT NULL ) {$charset_collate}"; $create_tables[] = "CREATE TABLE IF NOT EXISTS wp_zestatix_event ( selector_id INT( 10 ) NOT NULL, user_id INT( 10 ) NOT NULL, url_id SMALLINT NOT NULL, device VARCHAR( 6 ) NOT NULL, width VARCHAR( 15 ) NOT NULL, event TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY ( selector_id ) REFERENCES wp_zestatix_element ( id ) ON DELETE CASCADE ) {$charset_collate}"; $create_tables[] = "CREATE TABLE IF NOT EXISTS wp_zestatix_url ( id INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY, url TEXT NOT NULL ) {$charset_collate}"; $create_tables[] = "CREATE TABLE IF NOT EXISTS wp_zestatix_loaded ( elem INT( 10 ) NOT NULL, user INT( 10 ) NOT NULL, url SMALLINT NOT NULL, FOREIGN KEY ( elem ) REFERENCES wp_zestatix_element ( id ) ON DELETE CASCADE ) {$charset_collate}"; $create_tables[] = "CREATE TABLE IF NOT EXISTS wp_zestatix_user ( id INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY, ip VARCHAR( 40 ) NOT NULL, location VARCHAR( 50 ) NULL, login VARCHAR( 50 ) NULL, INDEX( ip ), INDEX( login ) ) {$charset_collate}"; $create_tables[] = "CREATE TABLE IF NOT EXISTS wp_zestatix_url_tracking ( id INT( 10 ) NOT NULL, url TEXT NOT NULL, subdir INT( 1 ) NOT NULL, FOREIGN KEY ( id ) REFERENCES wp_zestatix_element ( id ) ON DELETE CASCADE ) {$charset_collate}"; foreach ( $create_tables as $table ) { $wpdb->query( $table );Safe to delete?
If you have uninstalled zeStatix, 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_zestatix_element`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from zeStatix