2021_05_17_001336_create_design_ml_table.php 2.32 KB
Newer Older
Bagus Pambudi committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69
<?php

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

class CreateDesignMlTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('swp_design_en', function (Blueprint $table) {
            $table->string('id', 36)->primary();
            $table->string('design_id', 36);
            $table->string('title_design')->nullable();
            $table->text('value_design')->nullable();
            $table->string('userid_created', 36)->nullable();
            $table->string('userid_updated', 36)->nullable();
            $table->timestamps();
        });

        Schema::create('swp_design_de', function (Blueprint $table) {
            $table->string('id', 36)->primary();
            $table->string('design_id', 36);
            $table->string('title_design')->nullable();
            $table->text('value_design')->nullable();
            $table->string('userid_created', 36)->nullable();
            $table->string('userid_updated', 36)->nullable();
            $table->timestamps();
        });

        Schema::create('swp_design_sa', function (Blueprint $table) {
            $table->string('id', 36)->primary();
            $table->string('design_id', 36);
            $table->string('title_design')->nullable();
            $table->text('value_design')->nullable();
            $table->string('userid_created', 36)->nullable();
            $table->string('userid_updated', 36)->nullable();
            $table->timestamps();
        });

        Schema::create('swp_design_zh', function (Blueprint $table) {
            $table->string('id', 36)->primary();
            $table->string('design_id', 36);
            $table->string('title_design')->nullable();
            $table->text('value_design')->nullable();
            $table->string('userid_created', 36)->nullable();
            $table->string('userid_updated', 36)->nullable();
            $table->timestamps();
        });
    }

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