Database Connection Test
✅ Database connection successful!
Connected to: u111133901_test_alm on localhost
Users Table Check
✅ Users table exists
Users Table Structure:
- id (int(11))
- username (varchar(50))
- email (varchar(100))
- password_hash (varchar(255))
- role (enum('admin','user'))
- created_at (timestamp)
- franchisee_name (varchar(255))
- company_name (varchar(255))
- company_address (varchar(500))
- address_line1 (varchar(255))
- address_line2 (varchar(255))
- address_line3 (varchar(255))
- city (varchar(100))
- pincode (varchar(20))
- zone (varchar(100))
- phone (varchar(20))
- mobile (varchar(20))
- business_email (varchar(255))
- gst_no (varchar(50))
- pan_no (varchar(20))
- state_code (varchar(20))
- account_name (varchar(255))
- bank_name (varchar(255))
- branch (varchar(255))
- account_no (varchar(50))
- account_type (varchar(50))
- ifsc_code (varchar(20))
- sac_code (varchar(50))
- website (varchar(255))
- profile_updated (timestamp)
- owner_name (varchar(255))
- profile_picture (varchar(255))
- company_logo (varchar(255))
- payment_id (varchar(50))
- remember_token (varchar(255))
Total users in database: 7
Sample usernames:
- BM1001
- BM999
- demo
- M10237
- MF2053
Other Tables Check
✅ transactions table exists with 7119 records
✅ invoice table exists with 0 records
✅ cn_entries table exists with 12187 records