{"table_name":"jswprediction_round_users","full_table_name":"wp_jswprediction_round_users","description":"Stores jswprediction round users data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE `wp_jswprediction_round_users` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `user_id` int NOT NULL,\\n  `round_id` int NOT NULL,\\n  `prediction` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `editdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\\n  `filldate` timestamp NULL DEFAULT NULL,\\n  `points` int NOT NULL,\\n  `place` smallint NOT NULL,\\n  `filled` smallint NOT NULL DEFAULT '0',\\n  `options` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `success` smallint NOT NULL DEFAULT '0',\\n  `winner_side` smallint NOT NULL DEFAULT '0',\\n  `score_diff` smallint NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `user_id` (`user_id`,`round_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci","columns":[],"plugin":{"slug":"joomsport-prediction","name":"Sport Predictions for JoomSport","active_installs":70,"version":"4.0","wp_org_url":"https://wordpress.org/plugins/joomsport-prediction/"}}