1: <?php
2:
3: use Illuminate\Database\Schema\Blueprint;
4: use Illuminate\Database\Migrations\Migration;
5:
6: class CreateOptionsTable extends Migration {
7:
8: 9: 10: 11: 12: 13:
14: public function up()
15: {
16: if (!Schema::hasTable('_db_options'))
17: {
18: Schema::create('_db_options', function ($table)
19: {
20: $table->increments('id')->unique();
21: $table->string('name', 100)->nullable();
22: $table->string('value', 100)->nullable();
23: $table->integer('option_type_id')->nullable();
24: $table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
25: $table->timestamp('updated_at')->default('0000-00-00 00:00:00');
26: });
27: }
28: }
29:
30: 31: 32: 33: 34: 35:
36: public function down()
37: {
38: Schema::dropIfExists('_db_options');
39: }
40:
41: }
42: