One Hat Cyber Team

Your IP: 216.73.216.26
Server IP: 13.127.59.50
Server: Linux ip-172-31-46-210 5.15.0-1033-aws #37~20.04.1-Ubuntu SMP Fri Mar 17 11:39:30 UTC 2023 x86_64
Server Software: Apache/2.4.41 (Ubuntu)
PHP Version: 7.4.3-4ubuntu2.29
Buat File | Buat Folder

Dir : ~/var/www/styleage_v3/core/database/migrations/

View File Name : 2021_09_20_144419_create_items_table.php

<?php

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

class CreateItemsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {

        Schema::create('items', function (Blueprint $table) {
            $table->id();
            $table->integer('category_id')->default(0)->nullable();
            $table->integer('subcategory_id')->default(0)->nullable();
            $table->integer('childcategory_id')->default(0)->nullable();
            $table->integer('tax_id')->nullable();
            $table->integer('brand_id')->default(0)->nullable();
            $table->text('name')->nullable();
            $table->text('slug')->nullable();
            $table->string('sku')->nullable();
            $table->text('tags')->nullable();
            $table->text('video')->nullable();
            $table->text('sort_details')->nullable();
            $table->text('specification_name')->nullable();
            $table->text('specification_description')->nullable();
            $table->tinyInteger('is_specification')->default(0)->nullable();
            $table->text('details')->nullable();
            $table->string('photo')->nullable();
            $table->double('discount_price')->default(0)->nullable();
            $table->double('previous_price')->default(0)->nullable();
            $table->integer('stock')->default(0)->nullable();
            $table->text('meta_keywords')->nullable();
            $table->text('meta_description')->nullable();
            $table->tinyInteger('status')->default()->nullable();
            $table->string('is_type')->nullable();
            $table->string('date')->nullable();
            $table->enum('item_type',['normal', 'digital'])->default('normal');
            $table->string('file')->nullable();
            $table->text('link')->nullable();
            $table->enum('file_type',['file', 'link'])->nullable();
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('items');
    }
}