From 1608adfa7bfbf027bddffe4051637bf65ce03622 Mon Sep 17 00:00:00 2001
From: Camil Staps
Date: Sat, 21 Feb 2015 13:45:31 +0100
Subject: Basic controllers and authentication

---
 src/migrations/2015_02_20_211317_create_bots.php | 39 ++++++++++++++++++++++++
 1 file changed, 39 insertions(+)
 create mode 100644 src/migrations/2015_02_20_211317_create_bots.php

(limited to 'src/migrations/2015_02_20_211317_create_bots.php')

diff --git a/src/migrations/2015_02_20_211317_create_bots.php b/src/migrations/2015_02_20_211317_create_bots.php
new file mode 100644
index 0000000..665ce0f
--- /dev/null
+++ b/src/migrations/2015_02_20_211317_create_bots.php
@@ -0,0 +1,39 @@
+<?php
+
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Database\Migrations\Migration;
+
+class CreateBots 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');
+	}
+
+}
-- 
cgit v1.2.3