migrations have package's namespace for compatibility

3 files changed, 108 insertions, 0 deletions

diff --git a/src/migrations/2015_02_23_184402_botleaguesapi-create_users.php b/src/migrations/2015_02_23_184402_botleaguesapi-create_users.php
new file mode 100644
index 0000000..0df36d0
--- /dev/null
+++ b/src/migrations/2015_02_23_184402_botleaguesapi-create_users.php
@@ -0,0 +1,36 @@
+<?php
+
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Database\Migrations\Migration;
+
+class BotleaguesapiCreateUsers 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_23_184407_botleaguesapi-create_games.php b/src/migrations/2015_02_23_184407_botleaguesapi-create_games.php
new file mode 100644
index 0000000..3ecc1e2
--- /dev/null
+++ b/src/migrations/2015_02_23_184407_botleaguesapi-create_games.php
@@ -0,0 +1,33 @@
+<?php
+
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Database\Migrations\Migration;
+
+class BotleaguesapiCreateGames 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_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');
+	}
+
+}