wp_ip_comment_trace

Static

Stores ip comment trace data created by this plugin.

Column Definitions

ColumnTypeNullable
🔑idint(11)NO
comment_idint(11)YES
countryvarchar(255)YES
regionvarchar(255)YES
cityvarchar(255)YES
date_addeddatetimeYES

CREATE TABLE Statement

CREATE TABLE wp_ip_comment_trace ( `id` int(11) NOT NULL AUTO_INCREMENT , `comment_id` int(11) , `country` varchar(255) , `region` varchar(255) , `city` varchar(255) , `date_added` datetime , PRIMARY KEY (id) ) {$charset_collate};"; // Require upgrade funtions require_once ( ABSPATH . 'wp-admin/upgrade-functions.php' );

Safe to delete?

If you have uninstalled Comment Location Tracker, 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_ip_comment_trace`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.