Master Database Initialization & Update Script
Running A-Z database updates. Please wait...
[SUCCESS] Creating 'users' table
[SUCCESS] Creating 'jobs' table
[SUCCESS] Creating 'amc_records' table
[SUCCESS] Creating 'attendance' table
[SUCCESS] Creating 'bookings' table for website integration
[SUCCESS] Creating admin 'expenses' table
[SUCCESS] Creating main 'inventory' table
[SUCCESS] Creating 'technician_inventory' table
[SUCCESS] Creating 'inventory_assignments' table
[SUCCESS] Creating 'job_history' log table
[SUCCESS] Creating 'job_parts' usage table
[SUCCESS] Creating 'technician_expenses' table
[SUCCESS] Creating 'user_notes' table
Checking Sub-Columns & Integrity...
[SUCCESS] Standardizing User Roles
[SKIPPED] Adding Column to jobs: customer_phone (Already exists)
[SKIPPED] Adding Column to jobs: address (Already exists)
[SKIPPED] Adding Column to jobs: product_type (Already exists)
[SKIPPED] Adding Column to jobs: brand_name (Already exists)
[SKIPPED] Adding Column to jobs: device_model (Already exists)
[SKIPPED] Adding Column to jobs: preferred_service_date (Already exists)
[SKIPPED] Adding Column to jobs: service_type (Already exists)
[SKIPPED] Adding Column to jobs: resolution (Already exists)
[SKIPPED] Adding Column to jobs: parts_used (Already exists)
[SKIPPED] Adding Column to jobs: part_price (Already exists)
[SKIPPED] Adding Column to jobs: visiting_charge (Already exists)
[SKIPPED] Adding Column to jobs: discount (Already exists)
[SKIPPED] Adding Column to jobs: total_bill (Already exists)
[SKIPPED] Adding Column to jobs: total_collection (Already exists)
[SKIPPED] Adding Column to jobs: payment_mode (Already exists)
[SKIPPED] Adding Column to jobs: img_faulty_part (Already exists)
[SKIPPED] Adding Column to jobs: img_new_part (Already exists)
[SKIPPED] Adding Column to jobs: img_bill (Already exists)
[SKIPPED] Adding Column to jobs: img_job_sheet (Already exists)
[SKIPPED] Adding Column to jobs: assigned_to (Already exists)
[SKIPPED] Adding Column to jobs: has_amc (Already exists)
[SKIPPED] Adding Column to jobs: is_deposited (Already exists)
[SKIPPED] Adding Column to jobs: deposited_at (Already exists)
[SKIPPED] Adding Column to jobs: customer_rating (Already exists)
[SKIPPED] Adding Column to jobs: customer_feedback (Already exists)
[SKIPPED] Adding Column to jobs: feedback_date (Already exists)
[SUCCESS] Standardizing Job Status enum
[SKIPPED] Adding Column to amc_records: customer_phone (Already exists)
[SKIPPED] Adding Column to amc_records: is_deposited (Already exists)
[SKIPPED] Adding Column to amc_records: deposited_at (Already exists)
Checking Default Administrator...
[SKIPPED] Admin account already exists.
A to Z Database Update Completed Successfully!
If you are moving to a new domain, everything is perfectly set up. You can safely delete this script or keep it for future domain migrations.