HEX
Server: Apache/2.4.52 (Ubuntu)
System: Linux ip-10-0-8-47 6.8.0-1021-aws #23~22.04.1-Ubuntu SMP Tue Dec 10 16:31:58 UTC 2024 aarch64
User: ubuntu (1000)
PHP: 8.1.2-1ubuntu2.22
Disabled: NONE
Upload Files
File: /var/www/admin.javaapp.co.uk/database/migrations/2023_04_10_054305_add_columns_to_orders_table.php
<?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('orders', function (Blueprint $table) {
            $table->foreignId('cafe_coupon_order_id')->nullable()->constrained('manage_loyalty_stamps');
            $table->unsignedInteger('cafe_coupon_expired_time')->default(0);
            $table->foreignId('universal_coupon_order_id')->nullable()->constrained('manage_loyalty_stamps');
            $table->unsignedInteger('universal_coupon_expired_time')->default(0);
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('orders', function (Blueprint $table) {
            $table->dropConstrainedForeignId('cafe_coupon_order_id');
            $table->dropColumn('cafe_coupon_expired_time');
            $table->dropConstrainedForeignId('universal_coupon_order_id');
            $table->dropColumn('universal_coupon_expired_time');
        });
    }
};