Sid Gifari File Manager
🏠 Root
/
home
/
genremedia08
/
musicjukebox.overlookedtracks.com
/
database
/
migrations
/
Editing: 2021_04_24_164138_create_user_artist_table.php
<?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateUserArtistTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { if (Schema::hasTable('user_artist')) return; Schema::create('user_artist', function (Blueprint $table) { $table->id(); $table->bigInteger('user_id')->unsigned()->index(); $table->bigInteger('artist_id')->unsigned()->index(); $table->string('role', 30)->index()->default('artist'); $table->timestamps(); $table->unique(['user_id', 'artist_id']); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('user_artist'); } }
Save
Cancel
