{"slug":"joomsport-prediction","name":"Sport Predictions for JoomSport","description":"Organize a sports prediction game on your site to improve fan engagement. Matches are pulled from JoomSport. The points are updated automatically!","author":"beardev","active_installs":70,"version":"4.0","wp_org_url":"https://wordpress.org/plugins/joomsport-prediction/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"jswprediction_league","full_table_name":"wp_jswprediction_league","description":"Stores jswprediction league data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_jswprediction_league` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `seasons` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `predictions` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `options` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"jswprediction_private_based","full_table_name":"wp_jswprediction_private_based","description":"Stores jswprediction private based data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"jswprediction_private_league","full_table_name":"wp_jswprediction_private_league","description":"Stores jswprediction private league data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"jswprediction_private_users","full_table_name":"wp_jswprediction_private_users","description":"Stores jswprediction private users data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"jswprediction_round","full_table_name":"wp_jswprediction_round","description":"Stores jswprediction round data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_jswprediction_round` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `rname` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `ordering` tinyint NOT NULL,\\n  `league_id` int NOT NULL,\\n  `closedate` int NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"jswprediction_round_matches","full_table_name":"wp_jswprediction_round_matches","description":"Stores jswprediction round matches data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_jswprediction_round_matches` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `round_id` int NOT NULL,\\n  `match_id` int NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"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","columns":[],"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"},{"table_name":"jswprediction_scorepredict","full_table_name":"wp_jswprediction_scorepredict","description":"Stores jswprediction scorepredict data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"jswprediction_types","full_table_name":"wp_jswprediction_types","description":"Stores jswprediction types data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_jswprediction_types` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `name` varchar(150) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `identif` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `ptype` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `ordering` tinyint NOT NULL,\\n  `showtype` varchar(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '0',\\n  `options` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":9}