1 files changed, 39 insertions, 0 deletions
diff --git a/src/migrations/2015_02_23_184413_botleaguesapi-create_bots.php b/src/migrations/2015_02_23_184413_botleaguesapi-create_bots.php
new file mode 100644
index 0000000..11ab786
--- /dev/null
+++ b/src/migrations/2015_02_23_184413_botleaguesapi-create_bots.php
@@ -0,0 +1,39 @@
+<?php
+
+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->integer('userId')->unsigned();
+			$table->foreign('userId')->references('id')->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');
+	}
+
+}