wp_picks

Live

Stores picks data created by this plugin.

CREATE TABLE Statement

CREATE TABLE `wp_picks` (\n  `id` int NOT NULL AUTO_INCREMENT,\n  `tipster_id` int NOT NULL,\n  `pick_id` int NOT NULL,\n  `bookie_id` varchar(255) NOT NULL,\n  `sport_id` int NOT NULL,\n  `competition_id` int NOT NULL,\n  `pick_datetime` bigint DEFAULT NULL,\n  `pick_cuote` double DEFAULT NULL,\n  `pick_stake` double DEFAULT NULL,\n  `pick_type` varchar(15) NOT NULL,\n  `pick_result` varchar(15) NOT NULL,\n  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\n  PRIMARY KEY (`id`),\n  KEY `wp_picks_tipster_id` (`tipster_id`),\n  KEY `wp_picks_pick_id` (`pick_id`),\n  KEY `wp_picks_bookie_id` (`bookie_id`(250)),\n  KEY `wp_picks_tipster_id_datetime` (`tipster_id`,`pick_datetime`)\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_picks`;

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

Other tables from Tipster TAP

wp_statistics