Hostinger Database Setup

This script will create all required database tables for the DCAPP system.

Database Connection

✓ Connected to database: u939233081_dcapp_db

Creating Tables

✓ Table 'mis_users' created/verified
✓ Table 'mis_roles' created/verified
✓ Table 'mis_user_roles' created/verified
✓ Table 'mis_permissions' created/verified
✓ Table 'mis_role_permissions' created/verified
✓ Table 'mis_audit_logs' created/verified
✓ Table 'mis_status_history' created/verified
✓ Table 'dc_indicators' created/verified
✓ Table 'dc_targets' created/verified
✓ Table 'dc_submissions' created/verified
✓ Table 'dc_submission_history' created/verified
✓ Table 'dc_dashboard_cache' created/verified

Inserting Default Roles

✓ Role 'admin' inserted/verified
✓ Role 'reviewer' inserted/verified
✓ Role 'approver' inserted/verified
✓ Role 'submitter' inserted/verified

Inserting Default Permissions

✓ Permission 'dashboard.view' inserted/verified
✓ Permission 'indicators.view' inserted/verified
✓ Permission 'indicators.create' inserted/verified
✓ Permission 'indicators.edit' inserted/verified
✓ Permission 'submissions.view' inserted/verified
✓ Permission 'submissions.create' inserted/verified
✓ Permission 'submissions.edit' inserted/verified
✓ Permission 'submissions.review' inserted/verified
✓ Permission 'submissions.approve' inserted/verified
✓ Permission 'users.view' inserted/verified
✓ Permission 'users.create' inserted/verified
✓ Permission 'users.edit' inserted/verified
✓ Permission 'report.download' inserted/verified

Assigning Permissions to Roles

✓ Assigned permission 'dashboard.view' to role 'admin'
✓ Assigned permission 'indicators.view' to role 'admin'
✓ Assigned permission 'indicators.create' to role 'admin'
✓ Assigned permission 'indicators.edit' to role 'admin'
✓ Assigned permission 'submissions.view' to role 'admin'
✓ Assigned permission 'submissions.create' to role 'admin'
✓ Assigned permission 'submissions.edit' to role 'admin'
✓ Assigned permission 'submissions.review' to role 'admin'
✓ Assigned permission 'submissions.approve' to role 'admin'
✓ Assigned permission 'users.view' to role 'admin'
✓ Assigned permission 'users.create' to role 'admin'
✓ Assigned permission 'users.edit' to role 'admin'
✓ Assigned permission 'report.download' to role 'admin'
✓ Assigned permission 'indicators.view' to role 'reviewer'
✓ Assigned permission 'submissions.view' to role 'reviewer'
✓ Assigned permission 'submissions.review' to role 'reviewer'
✓ Assigned permission 'report.download' to role 'reviewer'
✓ Assigned permission 'dashboard.view' to role 'approver'
✓ Assigned permission 'indicators.view' to role 'approver'
✓ Assigned permission 'submissions.view' to role 'approver'
✓ Assigned permission 'submissions.create' to role 'approver'
✓ Assigned permission 'submissions.edit' to role 'approver'
✓ Assigned permission 'submissions.approve' to role 'approver'
✓ Assigned permission 'report.download' to role 'approver'
✓ Assigned permission 'dashboard.view' to role 'submitter'
✓ Assigned permission 'indicators.view' to role 'submitter'
✓ Assigned permission 'submissions.view' to role 'submitter'
✓ Assigned permission 'submissions.create' to role 'submitter'
✓ Assigned permission 'submissions.edit' to role 'submitter'

Creating Default Admin User

✓ Admin user already exists

Setup Complete!

Database setup completed successfully. You can now access the dashboard.

Go to Dashboard | Run Diagnostics