44 lines
769 B
Plaintext
44 lines
769 B
Plaintext
<?php
|
|
|
|
use Illuminate\Database\Migrations\Migration;
|
|
use Illuminate\Database\Schema\Blueprint;
|
|
use Illuminate\Support\Facades\Schema;
|
|
|
|
class Create[ViewName:Studly]View extends Migration
|
|
{
|
|
/**
|
|
* Run the migrations.
|
|
*
|
|
* @return void
|
|
*/
|
|
public function up()
|
|
{
|
|
DB::statement($this->dropView());
|
|
DB::statement($this->createView());
|
|
}
|
|
|
|
/**
|
|
* Reverse the migrations.
|
|
*
|
|
* @return void
|
|
*/
|
|
public function down()
|
|
{
|
|
DB::statement($this->dropView());
|
|
}
|
|
|
|
private function createView()
|
|
{
|
|
return <<<SQL
|
|
[Schema]
|
|
SQL;
|
|
}
|
|
|
|
private function dropView()
|
|
{
|
|
return <<<SQL
|
|
DROP VIEW IF EXISTS `[ViewName]`;
|
|
SQL;
|
|
}
|
|
}
|