โ Database connection successful!
๐ง Checking and adding missing columns...
โ 'is_blocked' column already exists
โ 'blocked_at' column already exists
โ 'blocked_reason' column already exists
โ Updated existing users with default values
๐ง Setting up admin table...
โ Admin table created/verified
โ Admin user already exists
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| name | varchar(100) | NO | |||
| varchar(100) | NO | UNI | |||
| password | varchar(255) | NO | |||
| mpin | varchar(255) | NO | |||
| balance | decimal(10,2) | YES | 0.00 | ||
| created_at | timestamp | NO | current_timestamp() | ||
| updated_at | timestamp | NO | current_timestamp() | on update current_timestamp() | |
| is_active | tinyint(1) | YES | 1 | ||
| is_blocked | tinyint(1) | YES | 0 | ||
| blocked_at | timestamp | YES | |||
| blocked_reason | text | YES |
๐งช Testing Get Users API: http://dev.shyamatka.com/admin/../api/admin_get_users.php
Next Steps: