🗄️What WP Table Is This?
Home / Sport Predictions for JoomSport / wp_jswprediction_round_users

wp_jswprediction_round_users

Static

Stores jswprediction round users data created by this plugin.

CREATE TABLE Statement

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

Safe to delete?

If you have uninstalled Sport Predictions for JoomSport, 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_jswprediction_round_users`;

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

Other tables from Sport Predictions for JoomSport