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_210536_create_user.php  | 34 --------------------
 src/migrations/2015_02_20_210536_create_users.php | 36 +++++++++++++++++++++
 src/migrations/2015_02_20_211306_create_game.php  | 33 -------------------
 src/migrations/2015_02_20_211306_create_games.php | 33 +++++++++++++++++++
 src/migrations/2015_02_20_211317_create_bot.php   | 36 ---------------------
 src/migrations/2015_02_20_211317_create_bots.php  | 39 +++++++++++++++++++++++
 6 files changed, 108 insertions(+), 103 deletions(-)
 delete mode 100644 src/migrations/2015_02_20_210536_create_user.php
 create mode 100644 src/migrations/2015_02_20_210536_create_users.php
 delete mode 100644 src/migrations/2015_02_20_211306_create_game.php
 create mode 100644 src/migrations/2015_02_20_211306_create_games.php
 delete mode 100644 src/migrations/2015_02_20_211317_create_bot.php
 create mode 100644 src/migrations/2015_02_20_211317_create_bots.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
deleted file mode 100644
index 39ff9e1..0000000
--- a/src/migrations/2015_02_20_210536_create_user.php
+++ /dev/null
@@ -1,34 +0,0 @@
-<?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_210536_create_users.php b/src/migrations/2015_02_20_210536_create_users.php
new file mode 100644
index 0000000..baf6c19
--- /dev/null
+++ b/src/migrations/2015_02_20_210536_create_users.php
@@ -0,0 +1,36 @@
+<?php
+
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Database\Migrations\Migration;
+
+class CreateUsers extends Migration {
+
+	/**
+	 * Run the migrations.
+	 *
+	 * @return void
+	 */
+	public function up()
+	{
+		Schema::create('users', function(Blueprint $table)
+		{
+			$table->increments('id')->unsigned();
+			$table->string('email', 127)->unique();
+			$table->string('password', 60);
+			$table->rememberToken();
+			$table->string('key', 255);
+			$table->timestamps();
+		});
+	}
+
+	/**
+	 * Reverse the migrations.
+	 *
+	 * @return void
+	 */
+	public function down()
+	{
+		Schema::drop('users');
+	}
+
+}
diff --git a/src/migrations/2015_02_20_211306_create_game.php b/src/migrations/2015_02_20_211306_create_game.php
deleted file mode 100644
index 7fd5db5..0000000
--- a/src/migrations/2015_02_20_211306_create_game.php
+++ /dev/null
@@ -1,33 +0,0 @@
-<?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_211306_create_games.php b/src/migrations/2015_02_20_211306_create_games.php
new file mode 100644
index 0000000..5466404
--- /dev/null
+++ b/src/migrations/2015_02_20_211306_create_games.php
@@ -0,0 +1,33 @@
+<?php
+
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Database\Migrations\Migration;
+
+class CreateGames extends Migration {
+
+	/**
+	 * Run the migrations.
+	 *
+	 * @return void
+	 */
+	public function up()
+	{
+		Schema::create('games', function(Blueprint $table)
+		{
+			$table->increments('id')->unsigned();
+			$table->string('title')->unique();
+			$table->timestamps();
+		});
+	}
+
+	/**
+	 * Reverse the migrations.
+	 *
+	 * @return void
+	 */
+	public function down()
+	{
+		Schema::drop('games');
+	}
+
+}
diff --git a/src/migrations/2015_02_20_211317_create_bot.php b/src/migrations/2015_02_20_211317_create_bot.php
deleted file mode 100644
index 86285a7..0000000
--- a/src/migrations/2015_02_20_211317_create_bot.php
+++ /dev/null
@@ -1,36 +0,0 @@
-<?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');
-	}
-
-}
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