wp_gp_activity

Static

Stores gp activity data created by this plugin.

Column Definitions

Column	Type	Nullable
🔑id	int(10) unsigned	NO
user_id	int(10) unsigned	NO
alc_id	int(10) unsigned	NO
activity_time	timestamp	NO

CREATE TABLE Statement

CREATE TABLE wp_gp_activity ( id int(10) unsigned NOT NULL AUTO_INCREMENT, user_id int(10) unsigned NOT NULL, alc_id int(10) unsigned NOT NULL, activity_time timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (id), KEY user_id (user_id) )"; // Include WordPress database upgrade script require_once(ABSPATH . 'wp-admin/includes/upgrade.php');

Safe to delete?

If you have uninstalled Media Activity 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_gp_activity`;

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

Other tables from Media Activity Tracker

wp_gp_tracking_points