aboutsummaryrefslogtreecommitdiff
path: root/src/migrations
diff options
context:
space:
mode:
Diffstat (limited to 'src/migrations')
-rw-r--r--src/migrations/2015_02_20_210536_create_user.php34
-rw-r--r--src/migrations/2015_02_20_211306_create_game.php33
-rw-r--r--src/migrations/2015_02_20_211317_create_bot.php36
3 files changed, 103 insertions, 0 deletions
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');
+ }
+
+}