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