Database Setup for Xander Global Scholars Payment System
Existing Tables:
- abroad_courses
- ad_subtopics
- ad_topics
- admin_fcm_tokens
- admin_signatures
- admins
- application_packages
- application_payments
- application_study_choices
- attendance
- budapest_applications
- chat_conversations
- chat_messages
- commission_requests
- contract_audit_logs
- contract_templates
- countries
- credit_transfer_applications
- dphu
- email_queue
- employment_contracts
- fee_items
- fee_packages
- form_17_applications
- form_20_applications
- full_scholarships
- georgia_applications
- influencers
- job_list
- job_summary
- jobs
- leave_requests
- loan_providers
- malta_applications
- master_loan_applications
- members
- notifications
- offices
- overtime_payments
- overtime_requests
- overtime_sessions
- packages
- payment_packages
- payment_receipts
- platforms
- program_levels
- programs
- regions
- reminder_emails_queue
- reminder_events
- reminders
- salary_requests
- schools
- staff_platforms
- staff_tasks
- staff_universities
- student_app
- student_applications
- student_assignments
- student_chat_users
- student_contracts
- student_contracts_special
- student_queries
- student_signatures
- student_signatures_special
- turkey_applications
- universities
- university_platforms
- upafa_registration_files
- upafa_registrations
- work_schedule
- youtube_advertisements
Creating Tables:
⚠️ Table 'packages' already exists
⚠️ Table 'payment_packages' already exists
⚠️ Table 'student_assignments' already exists
⚠️ Table 'fee_items' already exists
⚠️ Table 'application_payments' already exists
⚠️ Table 'application_packages' already exists
⚠️ Table 'payment_receipts' already exists
Inserting Sample Data:
⚠️ Packages table already has data
Setup Complete!
Tables created match the exact structure expected by:
- record-payment.php - Uses fee_items, application_payments, application_packages, payment_receipts
- student-manage.php - Uses packages, payment_packages, student_assignments
Go to Payment Portal