USE dreamon2_cricket;
SELECT COUNT(*) FROM active_tournaments;
SELECT COUNT(*) FROM countries;
SELECT COUNT(*) FROM dream_team_save_path;
SELECT COUNT(*) FROM matches_20overs;
SELECT COUNT(*) FROM matches_50overs;
SELECT COUNT(*) FROM otp;
SELECT COUNT(*) FROM players;
SELECT COUNT(*) FROM sessions;
SELECT COUNT(*) FROM tournaments;
SELECT COUNT(*) FROM tournaments_type;
SELECT COUNT(*) FROM user_library;
SELECT COUNT(*) FROM user_library_of_players;
SELECT COUNT(*) FROM users;
SELECT COUNT(*) FROM venues;
SELECT COUNT(*) FROM withdraw_requests;



UPDATE countries SET is_country_uploaded = 'y';
UPDATE dream_team_save_path SET is_path_uploaded = 'y';
UPDATE matches_20overs SET is_match20_uploaded = 'y';
UPDATE matches_50overs SET is_match50_uploaded = 'y';
UPDATE players SET is_player_uploaded = 'y';
UPDATE tournaments SET is_tournament_uploaded = 'y';
UPDATE tournaments_type SET is_tournament_type_uploaded = 'y';
UPDATE venues SET is_venue_uploaded = 'y';