<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        // Schema::table('sale_invoice_batches', function (Blueprint $table) {
        //     $table->index('invoice_id');
        // });

        // Schema::table('account_addresses', function (Blueprint $table) {
        //     $table->index('address_type_id');
        //     $table->index('state_id');
        //     $table->index('city_id');
        // });

        // Schema::table('account_contacts', function (Blueprint $table) {
        //     $table->index('account_id');
        // });

        // Schema::table('ac_journals', function (Blueprint $table) {
        //     $table->index('voucher_master_id');
        //     $table->index('settlement_voucher_id');
        // });

        // Schema::table('ac_journal_transactions', function (Blueprint $table) {
        //     $table->index('voucher_type');
        // });

        // Schema::table('ac_receipts', function (Blueprint $table) {
        //     $table->index('created_by');
        //     $table->index('updated_by');
        //     $table->index('deleted_by');
        //     $table->index('settlement_voucher_id');
        //     $table->index('voucher_id');
        // });

        // Schema::table('advance_settings', function (Blueprint $table) {
        //     $table->index('master_setting_id');
        //     $table->index('voucher_type_id');
        //     $table->index('voucher_master_id');
        // });

        Schema::table('beds', function (Blueprint $table) {
            // $table->index('company_id');
            // $table->index('room_id');
            // $table->index('floor_id');
            // $table->index('building_id');
            // $table->index('ipd_admission_no');
            // $table->index('waiting_ipd_admission_id');
        });

        // Schema::table('bed_groups', function (Blueprint $table) {
        //     $table->index('code');
        // });

        // Schema::table('bed_types', function (Blueprint $table) {
        //     $table->index('code');
        //     $table->index('product_id');
        // });

        // Schema::table('biling_intervals', function (Blueprint $table) {
        //     $table->index('code');
        //     $table->index('billing_type');
        // });

        // Schema::table('blogs', function (Blueprint $table) {
        //     $table->index('category_id');
        //     $table->index('company_id');
        //     $table->index('slug');
        // });

        // Schema::table('body_vitals', function (Blueprint $table) {
        //     $table->index('code');
        // });

        // Schema::table('booking_calendar', function (Blueprint $table) {
        //     $table->index('booking_id');
        //     $table->index('customer_account_id');
        //     $table->index('doctor_ac_id');
        //     $table->index('shift_id');
        //     $table->index('appointment_date');
        // });

        // Schema::table('branches', function (Blueprint $table) {
        //     $table->index('branch_type_id');
        //     $table->index('email');
        //     $table->index('company_id');
        // });

        // Schema::table('branch_types', function (Blueprint $table) {
        //     $table->index('code');
        //     $table->index('company_id');
        // });

        // Schema::table('buildings', function (Blueprint $table) {
        //     $table->index('code');
        //     $table->index('company_id');
        // });

        // Schema::table('business_categories', function (Blueprint $table) {
        //     $table->index('code');
        // });

        // Schema::table('business_divisions', function (Blueprint $table) {
        //     $table->index('code');
        // });

        // Schema::table('card_types', function (Blueprint $table) {
        //     $table->index('prefix_code');
        //     $table->index('suffix_code');
        // });

        // Schema::table('company_images', function (Blueprint $table) {
        //     $table->index('company_id');
        // });

        // Schema::table('contra_vouchers', function (Blueprint $table) {
        //     $table->index('voucher_no');
        //     $table->index('company_id');
        //     $table->index('financial_year_id');
        //     $table->index('receipt_time');
        //     $table->index('created_by');
        //     $table->index('voucher_master_id');
        // });

        // Schema::table('contra_voucher_transactions', function (Blueprint $table) {
        //     $table->index('transactions_no');
        //     $table->index('transaction_date');
        //     $table->index('module_id');
        //     $table->index('voucher_id');
        //     $table->index('voucher_type');
        //     $table->index('account_id');
        //     $table->index('transaction_type');
        //     $table->index('created_by');
        //     $table->index('company_id');
        //     $table->index('financial_year_id');
        //     $table->index('currency_id');
        // });

        // Schema::table('countries', function (Blueprint $table) {
        //     $table->index('code');
        //     $table->index('gsm_code');
        // });

        // Schema::table('country_currencies', function (Blueprint $table) {
        //     $table->index('code');
        // });

        // Schema::table('discharge_types', function (Blueprint $table) {
        //     $table->index('code');
        // });

        // Schema::table('document_management', function (Blueprint $table) {
        //     $table->index('document_no');
        //     $table->index('date_time');
        //     $table->index('voucher_id');
        //     $table->index('voucher_type');
        //     $table->index('account_id');
        //     $table->index('company_id');
        //     $table->index('user_id');
        // });

        // Schema::table('ipd_admissions', function (Blueprint $table) {
        //     $table->index('ipd_admission_no');
        //     $table->index('ipd_file_no');
        //     $table->index('referral_partner_id');
        //     $table->index('sale_invoice_id');
        // });

        // Schema::table('ipd_discharges', function (Blueprint $table) {
        //     $table->index('ipd_admission_id');
        //     $table->index('discharge_type_code');
        //     $table->index('created_by_id');
        //     $table->index('edited_by_id');
        //     $table->index('deleted_by_id');
        // });

        // Schema::table('ipd_discharge_details', function (Blueprint $table) {
        //     $table->index('ipd_discharge_id');
        //     $table->index('ipd_discharge_type_settings_id');
        // });

        // Schema::table('lab_billing_reports', function (Blueprint $table) {
        //     $table->index('sale_invoice_id');
        //     $table->index('test_package_id');
        //     $table->index('test_item_id');
        //     $table->index('test_package_group_id');
        // });

        // Schema::table('lab_report_result_big_texts', function (Blueprint $table) {
        //     $table->index('lab_billing_report_id');
        // });

        // Schema::table('license_activation_histories', function (Blueprint $table) {
        //     $table->index('license_id');
        //     $table->index('expiry_date');
        // });

        // Schema::table('license_products', function (Blueprint $table) {
        //     $table->index('product_id');
        //     $table->index('product_price_id');
        //     $table->index('license_id');
        // });

        // Schema::table('license_registereds', function (Blueprint $table) {
        //     $table->index('license_no');
        //     $table->index('ship_to_account_id');
        //     $table->index('bill_to_account_id');
        //     $table->index('project_id');
        //     $table->index('partner_id');
        //     $table->index('sales_person_id');
        //     $table->index('account_manager_id');
        // });

        // Schema::table('master_settings', function (Blueprint $table) {
        //     $table->index('code');
        // });

        // Schema::table('opd_block_serial', function (Blueprint $table) {
        //     $table->index('slot_no');
        //     $table->index('login_id');
        //     $table->index('shift_id');
        //     $table->index('doctor_id');
        // });

        // Schema::table('opd_bookings', function (Blueprint $table) {
        //     $table->index('booking_id');
        //     $table->index('booking_no');
        //     $table->index('company_id');
        //     $table->index('patient_id');
        //     $table->index('doctor_ac_id');
        //     $table->index('chamber_id');
        //     $table->index('refferal_lab_id');
        //     $table->index('collection_agent_id');
        //     $table->index('shift_id');
        //     $table->index('appointment_serial_no');
        //     $table->index('payment_mode_id');
        //     $table->index('operator_id');
        //     $table->index('sale_invoice_id');
        //     $table->index('batch_id');
        // });

        // Schema::table('opd_booking_details', function (Blueprint $table) {
        //     $table->index('opd_booking_id');
        //     $table->index('product_id');
        //     $table->index('price_id');
        //     $table->index('brand_id');
        // });

        // Schema::table('opd_prescription_images', function (Blueprint $table) {
        //     $table->index('doctor_id');
        //     $table->index('chamber_id');
        // });

        // Schema::table('opd_schedule_types', function (Blueprint $table) {
        //     $table->index('code');
        // });

        // Schema::table('products', function (Blueprint $table) {
        //     $table->index('product_code');
        //     $table->index('shortcode');
        //     $table->index('hsncode');
        //     $table->index('business_division_id');
        //     $table->index('industry_type');
        // });

        // Schema::table('product_attributes', function (Blueprint $table) {
        //     $table->index('code');
        // });

        // Schema::table('product_attribute_types', function (Blueprint $table) {
        //     $table->index('code');
        // });

        // Schema::table('product_brands', function (Blueprint $table) {
        //     $table->index('code');
        // });

        // Schema::table('sale_invoices', function (Blueprint $table) {
        //     $table->index('main_invoice_no');
        //     $table->index('voucher_type_invoice_no');
        //     $table->index('branch_invoice_no');
        //     $table->index('invoice_date');
        //     $table->index('voucher_type_code');
        //     $table->index('tpa_corporate_id');
        //     $table->index('bill_to_account_id');
        //     $table->index('invoice_type');
        //     $table->index('transaction_mode_id');
        //     $table->index('deleted_by');
        //     $table->index('updated_by');
        //     $table->index('third_party_account_id');
        // });

        // Schema::table('sale_invoice_batches', function (Blueprint $table) {
        //     $table->index('invoice_batch_no');
        //     $table->index('account_id');
        //     $table->index('consultant_id');
        //     $table->index('referrence_voucher_type');
        //     $table->index('referrence_voucher_id');
        // });

        // Schema::table('sale_invoice_details', function (Blueprint $table) {
        //     $table->index('batch_id');
        // });

        // Schema::table('sale_invoice_task_trackings', function (Blueprint $table) {
        //     $table->index('user_id');
        //     $table->index('tracking_type');
        //     $table->index('sale_invoice_sub_details_id');
        // });

        // Schema::table('sale_orders', function (Blueprint $table) {
        //     $table->index('main_order_no');
        //     $table->index('branch_order_no');
        //     $table->index('voucher_type_code');
        //     $table->index('patient_id');
        //     $table->index('doctor_id');
        //     $table->index('order_type');
        //     $table->index('collection_agent_id');
        //     $table->index('refferal_lab_id');
        //     $table->index('bussiness_source_id');
        //     $table->index('payment_term_id');
        //     $table->index('broker_id');
        //     $table->index('operator_id');
        //     $table->index('company_id');
        //     $table->index('financial_year_id');
        //     $table->index('industry_type_id');
        //     $table->index('dispatch_from_id');
        //     $table->index('ship_to_id');
        //     $table->index('tracking_id');
        //     $table->index('special_case_id');
        // });

        // Schema::table('signatures', function (Blueprint $table) {
        //     $table->index('signature_for');
        // });

        // Schema::table('test_packages', function (Blueprint $table) {
        //     $table->index('code');
        //     $table->index('test_method_id');
        // });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
    }
};
