aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorCamil Staps2015-02-23 22:28:34 +0100
committerCamil Staps2015-02-23 22:28:34 +0100
commit9825071e85b73cf1a97304f9dad938d44af905e5 (patch)
tree57aaef125e885a27c384578d78313a98d8cc9143 /src
parentAdded namespace to migrations for compatibility with other packages (diff)
migrations have package's namespace for compatibility
Diffstat (limited to 'src')
-rw-r--r--src/migrations/2015_02_23_184402_botleaguesapi-create_users.php36
-rw-r--r--src/migrations/2015_02_23_184407_botleaguesapi-create_games.php33
-rw-r--r--src/migrations/2015_02_23_184413_botleaguesapi-create_bots.php39
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');
+ }
+
+}