<?php

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

class CreateProductsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('products', function (Blueprint $table) {
            $table->id();
            $table->string('category_shop_slug')->default('Товары без категории');
            $table->string('category_shop_slug_to')->nullable();
            $table->string('category_shop_slug_three')->nullable();
            $table->integer('category_shop_id')->nullable();
            $table->integer('category_shop_to_id')->nullable();
            $table->integer('category_shop_three_id')->nullable();
            $table->integer('brand_id')->nullable();
            $table->integer('provider_id')->nullable();
            $table->string('name');
            $table->string('slug');
            $table->string('link_to_original')->nullable();
            $table->string('color')->nullable();
            $table->integer('price');
            $table->integer('price_to')->nullable();
            $table->integer('price_purchase')->nullable();
            $table->string('discount')->nullable();
            $table->string('image')->nullable();
            $table->string('is_sale')->nullable();
            $table->string('is_featured')->nullable();
            $table->string('is_best')->nullable();
            $table->string('is_best_category')->nullable();
            $table->string('is_new')->nullable();
            $table->string('is_top')->nullable();
            $table->string('availability')->nullable();
            $table->string('SKU')->nullable();
            $table->text('description')->nullable();
            $table->string('delivery')->nullable();
            $table->string('status')->nullable();
            $table->string('sort_order')->nullable();
            $table->string('users_add')->nullable();
            $table->string('Num_of_Sale')->nullable();
            $table->string('PDF_Specification')->nullable();
            $table->string('Free_Shippin')->nullable();
            $table->string('rating')->nullable();
            $table->string('meta_title')->nullable();
            $table->string('meta_description')->nullable();
            $table->string('Tags')->nullable();
            $table->string('temp1')->nullable();
            $table->string('temp2')->nullable();
            $table->string('temp3')->nullable();
            $table->string('temp4')->nullable();
            $table->string('temp5')->nullable();
            $table->string('temp6')->nullable();
            $table->string('temp7')->nullable();
            $table->string('temp8')->nullable();
            $table->string('temp9')->nullable();
            $table->string('temp10')->nullable();
            $table->string('temp11')->nullable();
            $table->string('temp12')->nullable();
            $table->string('temp13')->nullable();
            $table->string('temp14')->nullable();
            $table->string('temp15')->nullable();
            $table->string('temp16')->nullable();
            $table->string('temp17')->nullable();
            $table->string('temp18')->nullable();
            $table->string('temp19')->nullable();
            $table->string('temp20')->nullable();
            $table->string('temp21')->nullable();
            $table->string('temp22')->nullable();
            $table->string('temp23')->nullable();
            $table->string('temp24')->nullable();
            $table->string('temp25')->nullable();
            $table->string('club_point')->nullable();
            $table->timestamps();
        });
    }

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