db/migrations/2018_01_01_000002_import_update_sql.php


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

<?php

use Engelsystem\Database\Migration\Migration;

class ImportUpdateSql extends Migration
{
    /**
     * Run the migration
     */
    public function up()
    {
        if ($this->schema->hasTable('UserWorkLog')) {
            return;
        }

        $sql = file_get_contents(__DIR__ . '/../update.sql');
        $this->schema->getConnection()->unprepared($sql);
    }

    /**
     * Reverse the migration
     */
    public function down()
    {
        $this->schema->dropIfExists('UserWorkLog');
    }
}