* * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see . * */ use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class BotleaguesapiCreateBots extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('bots', function(Blueprint $table) { $table->increments('id')->unsigned(); $table->string('userEmail', 127)->index(); $table->foreign('userEmail')->references('email')->on('users'); $table->integer('gameId')->unsigned(); $table->foreign('gameId')->references('id')->on('games'); $table->string('title', 45); $table->string('version', 12); $table->unique(array('gameId', 'title', 'version')); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('bots'); } }