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