From 70220e8f3ba16e2c2be95cdb2e0fa11b2c343c64 Mon Sep 17 00:00:00 2001
From: Camil Staps
Date: Fri, 20 Feb 2015 22:28:37 +0100
Subject: added migrations, created basic app relying on dingo

---
 src/migrations/2015_02_20_210536_create_user.php | 34 ++++++++++++++++++++++
 src/migrations/2015_02_20_211306_create_game.php | 33 ++++++++++++++++++++++
 src/migrations/2015_02_20_211317_create_bot.php  | 36 ++++++++++++++++++++++++
 3 files changed, 103 insertions(+)
 create mode 100644 src/migrations/2015_02_20_210536_create_user.php
 create mode 100644 src/migrations/2015_02_20_211306_create_game.php
 create mode 100644 src/migrations/2015_02_20_211317_create_bot.php

(limited to 'src/migrations')

diff --git a/src/migrations/2015_02_20_210536_create_user.php b/src/migrations/2015_02_20_210536_create_user.php
new file mode 100644
index 0000000..39ff9e1
--- /dev/null
+++ b/src/migrations/2015_02_20_210536_create_user.php
@@ -0,0 +1,34 @@
+<?php
+
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Database\Migrations\Migration;
+
+class CreateUser extends Migration {
+
+	/**
+	 * Run the migrations.
+	 *
+	 * @return void
+	 */
+	public function up()
+	{
+		Schema::create('user', function(Blueprint $table)
+		{
+			$table->increments('id')->unsigned();
+			$table->string('email', 127)->unique();
+			$table->string('password', 255);
+			$table->timestamps();
+		});
+	}
+
+	/**
+	 * Reverse the migrations.
+	 *
+	 * @return void
+	 */
+	public function down()
+	{
+		Schema::drop('user');
+	}
+
+}
diff --git a/src/migrations/2015_02_20_211306_create_game.php b/src/migrations/2015_02_20_211306_create_game.php
new file mode 100644
index 0000000..7fd5db5
--- /dev/null
+++ b/src/migrations/2015_02_20_211306_create_game.php
@@ -0,0 +1,33 @@
+<?php
+
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Database\Migrations\Migration;
+
+class CreateGame extends Migration {
+
+	/**
+	 * Run the migrations.
+	 *
+	 * @return void
+	 */
+	public function up()
+	{
+		Schema::create('game', function(Blueprint $table)
+		{
+			$table->increments('id')->unsigned();
+			$table->string('title')->unique();
+			$table->timestamps();
+		});
+	}
+
+	/**
+	 * Reverse the migrations.
+	 *
+	 * @return void
+	 */
+	public function down()
+	{
+		Schema::drop('game');
+	}
+
+}
diff --git a/src/migrations/2015_02_20_211317_create_bot.php b/src/migrations/2015_02_20_211317_create_bot.php
new file mode 100644
index 0000000..86285a7
--- /dev/null
+++ b/src/migrations/2015_02_20_211317_create_bot.php
@@ -0,0 +1,36 @@
+<?php
+
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Database\Migrations\Migration;
+
+class CreateBot extends Migration {
+
+	/**
+	 * Run the migrations.
+	 *
+	 * @return void
+	 */
+	public function up()
+	{
+		Schema::create('bot', function(Blueprint $table)
+		{
+			$table->increments('id')->unsigned();
+			$table->integer('userId')->unsigned();
+			$table->foreign('userId')->references('id')->on('user');
+			$table->integer('gameId')->unsigned();
+			$table->foreign('gameId')->references('id')->on('game');
+			$table->timestamps();
+		});
+	}
+
+	/**
+	 * Reverse the migrations.
+	 *
+	 * @return void
+	 */
+	public function down()
+	{
+		Schema::drop('bot');
+	}
+
+}
-- 
cgit v1.2.3