=== COIN SYSTEM TEST SUITE ===

Test 1: Database Schema Validation
✓ redemption_lock column exists

Test 2: Create Test User
✓ Test user created: ID=14, Username=test_coin_user_1781009889

Test 3: Initialize User Coins
✓ User coins initialized: Total=100, Available=100, Redeemed=0

Test 4: Transaction with Redemption Lock
✓ Transaction completed successfully
  - Available coins after deduction: 90 (was 100, deducted 10)
  - Redeemed coins: 10
  - Redemption lock released: UNLOCKED (OK)

Test 5: Verify New API Response Structure
✓ API response structure is valid
  - cache_version included: YES
  - All required fields present

Test 6: Verify Admin Display Logic
✓ Admin display logic correct
  - Showing available_coins: 90 (what user can redeem)
  - Full display: 90 / 100
  - Redeemed coins: 10

Test 7: Cleanup
✓ Test data cleaned up

=== TEST SUMMARY ===
Tests Passed: 7 / 7

✓ ALL TESTS PASSED - Coin system is functioning correctly!

Key fixes applied:
1. ✓ Database transactions with row locking
2. ✓ Redemption lock prevents concurrent ad awards
3. ✓ Cache version in all responses
4. ✓ Admin display shows redeemable coins
5. ✓ Race condition prevention