{"slug":"tipster-tap","name":"Tipster TAP","description":"Manage tipsters and picks.","author":"todoapuestas","active_installs":20,"version":"4.2.2","wp_org_url":"https://wordpress.org/plugins/tipster-tap/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"picks","full_table_name":"wp_picks","description":"Stores picks data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"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"},{"table_name":"statistics","full_table_name":"wp_statistics","description":"Stores statistics data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"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"}],"table_count":2}