ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / lab2454c / costbloc.com / database / migrations

<?php

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

class AddForeignKeysToTransactionsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('transactions', function (Blueprint $table) {
            $table->foreign('user_id')->references('id')->on('users')->onUpdate('cascade')->onDelete('cascade');
            $table->foreign('currency_id')->references('id')->on('currencies')->onUpdate('cascade')->onDelete('cascade');
            $table->foreign('withdrawal_method_id')->references('id')->on('withdrawal_methods')->onUpdate('cascade')->onDelete('cascade');
            $table->foreign('vendor_id')->references('id')->on('vendors')->onUpdate('cascade')->onDelete('cascade');
            $table->foreign('shop_id')->references('id')->on('shops')->onUpdate('cascade')->onDelete('cascade');
            $table->foreign('order_id')->references('id')->on('orders')->onUpdate('cascade')->onDelete('cascade');
            $table->foreign('exchange_currency_id')->references('id')->on('currencies')->onUpdate('cascade')->onDelete('cascade');

});
    }

/**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('transactions', function (Blueprint $table) {
            $table->dropForeign('transactions_user_id_foreign');
            $table->dropForeign('transactions_currency_id_foreign');
            $table->dropForeign('transactions_withdrawal_method_id_foreign');
            $table->dropForeign('transactions_vendor_id_foreign');
            $table->dropForeign('transactions_shop_id_foreign');
            $table->dropForeign('transactions_order_id_foreign');
            $table->dropForeign('transactions_exchange_currency_id_foreign');
        });
    }
}

[+] ..
[-] 2021_10_10_065928_add_foreign_keys_to_favourites_table.php [edit]
[-] 2021_10_10_065927_create_vendor_users_table.php [edit]
[-] 2021_10_10_065927_create_flash_sales_table.php [edit]
[-] 2022_01_18_072726_create_brand_stats_table.php [edit]
[-] 2022_02_15_0000042_add_foreign_keys_to_user_withdrawal_settings_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_attributes_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_subscription_invoice_items_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_reviews_table.php [edit]
[-] 2022_09_05_073603_add_foreign_keys_to_orders_meta_table.php [edit]
[-] 2016_06_01_000005_create_oauth_personal_access_clients_table.php [edit]
[-] 2021_10_10_065927_create_languages_table.php [edit]
[-] 2022_01_31_093341_create_order_status_roles_table.php [edit]
[-] 2021_10_10_065928_create_addresses_table.php [edit]
[-] 2021_10_10_065927_create_categories_table.php [edit]
[-] 2021_10_10_065927_create_reviews_table.php [edit]
[-] 2021_10_10_065927_create_email_templates_table.php [edit]
[-] 2021_11_25_072726_category_trigger.php [edit]
[-] 2022_02_15_0000041_create_user_withdrawal_settings_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_product_tags_table.php [edit]
[-] 2022_02_15_0000043_create_transactions_table.php [edit]
[-] 2016_06_01_000001_create_oauth_auth_codes_table.php [edit]
[-] 2022_05_18_094636_create_metas.php [edit]
[-] 2022_05_18_092820_create_user_searches_table.php [edit]
[-] 2021_10_10_065927_create_products_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_products_table.php [edit]
[-] 2021_10_10_065927_create_category_attributes_table.php [edit]
[-] 2021_10_10_065927_create_product_tags_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_product_cross_sales_table.php [edit]
[-] 2021_10_10_065927_create_preferences_table.php [edit]
[-] 2022_05_18_074840_create_users_meta.php [edit]
[-] 2021_10_10_065927_create_role_users_table.php [edit]
[-] 2021_10_10_065927_create_subscription_invoices_table.php [edit]
[-] 2021_10_10_065927_create_vendors_table.php [edit]
[-] 2021_10_10_065927_create_currencies_table.php [edit]
[-] 2021_10_10_065927_create_email_configurations_table.php [edit]
[-] 2016_06_01_000004_create_oauth_clients_table.php [edit]
[-] 2021_12_16_111713_add_foreign_keys_to_order_details_table.php [edit]
[-] 2022_02_13_0000035_create_wallets_table.php [edit]
[-] 2021_10_10_065927_create_product_relates_table.php [edit]
[-] 2022_02_15_0000044_add_foreign_keys_to_transactions_table.php [edit]
[-] 2022_01_18_072726_create_category_stats_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_product_relates_table.php [edit]
[-] 2022_06_01_052414_add_foreign_keys_to_order_note_histories_table.php [edit]
[-] 2021_10_10_065927_create_attribute_groups_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_attribute_values_table.php [edit]
[-] 2021_10_10_065927_create_users_table.php [edit]
[-] 2021_10_10_065929_add_foreign_keys_to_addresses_table.php [edit]
[-] 2021_10_10_065927_create_locations_table.php [edit]
[-] 2021_11_25_072702_tag_trigger.php [edit]
[-] 2021_10_10_065927_create_product_categories_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_categories_table.php [edit]
[-] 2021_10_10_065927_create_tags_table.php [edit]
[-] 2021_10_10_065927_create_product_cross_sales_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_permission_roles_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_role_users_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_product_categories_table.php [edit]
[-] 2022_06_07_050839_create_products_meta_table.php [edit]
[-] 2021_10_10_065927_create_translations_table.php [edit]
[-] 2021_10_10_065927_create_brands_table.php [edit]
[-] 2016_06_01_000003_create_oauth_refresh_tokens_table.php [edit]
[-] 2022_10_30_062626_create_activity_log_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_vendor_users_table.php [edit]
[-] 2021_10_10_065927_create_backups_table.php [edit]
[-] 2021_10_10_065927_create_subscription_invoice_items_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_email_templates_table.php [edit]
[-] 2021_10_10_065927_create_password_resets_table.php [edit]
[-] 2022_01_31_093342_add_foreign_keys_to_order_status_roles_table.php [edit]
[-] 2022_04_06_104629_add_foreign_keys_to_seos_table.php [edit]
[-] 2022_01_18_072726_product_trigger.php [edit]
[-] 2021_12_16_111710_create_orders_table.php [edit]
[-] 2021_11_25_072727_product_category_trigger.php [edit]
[-] 2021_10_10_065927_create_failed_jobs_table.php [edit]
[-] 2021_10_10_065927_create_favourites_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_wishlists_table.php [edit]
[-] 2022_01_31_093451_add_foreign_keys_to_order_status_histories_table.php [edit]
[-] 2016_06_01_000002_create_oauth_access_tokens_table.php [edit]
[-] 2022_02_13_0000037_add_foreign_keys_to_wallets_table.php [edit]
[-] 2021_12_16_111712_create_order_details_table.php [edit]
[-] 2021_10_10_065927_create_wishlists_table.php [edit]
[-] 2021_10_10_065927_create_countries_table.php [edit]
[-] 2022_08_22_073603_add_foreign_keys_to_products_meta_table.php [edit]
[-] 2021_10_10_065927_create_permissions_table.php [edit]
[-] 2022_09_04_050839_create_orders_meta_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_category_attributes_table.php [edit]
[-] 2022_06_01_052314_create_order_note_histories_table.php [edit]
[-] 2021_12_16_111707_create_order_statuses_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_brands_table.php [edit]
[-] 2022_02_15_0000040_create_withdrawal_methods_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_flash_sales_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_attribute_groups_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_roles_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_tags_table.php [edit]
[-] 2021_10_10_065927_create_attributes_table.php [edit]
[-] 2022_01_31_093450_create_order_status_histories_table.php [edit]
[-] 2021_10_10_065928_add_foreign_keys_to_product_upsales_table.php [edit]
[-] 2022_05_18_092821_add_foreign_keys_to_user_searches_table.php [edit]
[-] 2022_04_06_104628_create_seos_table.php [edit]
[-] 2022_01_18_072726_create_product_stats_table.php [edit]
[-] 2021_12_16_111711_add_foreign_keys_to_orders_table.php [edit]
[-] 2021_10_10_065927_create_permission_roles_table.php [edit]
[-] 2021_10_10_065927_create_product_upsales_table.php [edit]
[-] 2022_05_18_092750_create_searches_table.php [edit]
[-] 2021_10_10_065927_create_subscription_quotes_table.php [edit]
[-] 2021_10_10_065927_create_attribute_values_table.php [edit]
[-] 2022_10_03_060019_create_vendors_meta_table.php [edit]
[-] 2021_10_10_065927_create_roles_table.php [edit]