ultimatepos/database/migrations/2018_02_21_105329_create_system_table.php

39 lines
784 B
PHP

<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;
return new class extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('system', function (Blueprint $table) {
$table->string('key');
$table->text('value')->nullable();
});
$version = config('author.app_version');
DB::table('system')->insert(
['key' => 'db_version', 'value' => $version]
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('system');
}
};