Testing Premium Status System
✅ Column 'is_premium' EXISTS in users table
Users Table Structure:
| Field | Type | Null | Key | Default |
|---|
| id | int(11) | NO | PRI | |
| chat_id | bigint(20) | YES | UNI | |
| telegram_id | bigint(20) | NO | UNI | |
| username | varchar(100) | YES | | |
| first_name | varchar(100) | YES | | |
| balance | decimal(10,2) | YES | | 0.00 |
| is_premium | tinyint(1) | YES | | 0 |
| premium_expiry | datetime | YES | | |
| created_at | timestamp | NO | | current_timestamp() |
| updated_at | timestamp | NO | | current_timestamp() |
| referral_balance | decimal(10,2) | NO | | 0.00 |
| referred_by | varchar(50) | YES | | |
| profile_pic | varchar(255) | YES | | |
Sample Users with Premium Status:
| Telegram ID | Name | Balance | Is Premium |
|---|
| 8353224925 | Ishikatasmin | ৳0.00 | ❌ Free |