EMI Phone Lock SaaS

Production Database Setup - Version 3.0.0

SOFTSYNCRON LTD
Starting EMI Phone Lock SaaS Database Setup
Connecting to MySQL server...
Successfully connected to MySQL server
Creating database 'sabbjzvz_emi_phone_lock'...
Database created/selected successfully
Loading production database schema...
Executing 4 SQL statements...
Warning: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_payments_due_status'
CREATE INDEX idx_payments_due_status ON emi_payments(due_date, payment_status)...
Warning: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_customers_bank_status'
CREATE INDEX idx_customers_bank_status ON customers(bank_id, status)...
Warning: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_commands_device_pending'
CREATE INDEX idx_commands_device_pending ON device_commands(device_id, command_status)...
Warning: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_logs_device_recent'
CREATE INDEX idx_logs_device_recent ON device_logs(device_id, timestamp DESC)...
Successfully executed 0 SQL statements
Verifying table creation...
All 14 tables created successfully
api_keys, audit_logs, bank_admins, banks, customers, device_commands, device_logs, devices, emi_payments, emi_plans, license_keys, notifications, super_admins, user_sessions
Verifying sample data...
Sample data verification complete
Super admins: 2 records
Banks: 4 records
Bank admins: 4 records
Customers: 4 records
Devices: 4 records
Testing API connectivity...
API health check failed
HTTP Code: 301, URL: http://softsyncron.com/EMI_Phone_Lock/api/health
Generating secure admin credentials...
Super admin already exists
Email: admin@softsyncron.com
Running final system verification...
System setup completed successfully!
Database: sabbjzvz_emi_phone_lock
Tables: 14
Super Admins: 2
Banks: 4
Bank Admins: 4
Customers: 4
Devices: 4
MySQL Version: 10.6.22-MariaDB-cll-lve-log
PHP Version: 8.2.29
Setup Time: 2025-09-07 05:36:48
Setup Complete!

Your EMI Phone Lock SaaS platform is now ready for production use.

Access Your Platform:
Default Login Credentials:
Super Admin:

Email: admin@softsyncron.com

Password: Admin123!

Bank Admin (Demo):

Email: admin@fnb-kenya.com

Password: Admin123!

EMI Phone Lock SaaS Platform v3.0.0
Developed by SOFTSYNCRON LTD
www.softsyncron.com
f