wp_statistics

Verified

Stores statistics data created by this plugin.

CREATE TABLE Statement

CREATE TABLE `statistics` (\n  `id` int NOT NULL AUTO_INCREMENT,\n  `corrects` int NOT NULL,\n  `wrongs` int NOT NULL,\n  `voids` int NOT NULL,\n  `total_units` float NOT NULL,\n  `win_units` float NOT NULL,\n  `lost_units` float NOT NULL,\n  `yield` float NOT NULL,\n  `last_stat` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\n  `user_id` int NOT NULL,\n  PRIMARY KEY (`id`),\n  KEY `user_id` (`user_id`),\n  KEY `user_group_units` (`user_id`,`total_units`),\n  KEY `total_units` (`total_units`),\n  KEY `last_stat_date` (`last_stat`),\n  KEY `last_stat_date_total_units` (`total_units`,`last_stat`),\n  KEY `user_date_units` (`user_id`,`last_stat`,`total_units`),\n  KEY `last_stat_total_units` (`total_units`,`last_stat`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

Safe to delete?

If you have uninstalled Tipster TAP, 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_statistics`;

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

Other tables from Tipster TAP

wp_picks