From cf14306c2b3f82a81f8d56669a71633b4d4b5fce Mon Sep 17 00:00:00 2001
From: marvin-borner@live.com
Date: Mon, 16 Apr 2018 21:09:05 +0200
Subject: Main merge to user management system - files are now at /main/public/

---
 .../src/Database/Migrations/v400/MembersTable.php  | 34 ++++++++++++++++++++++
 1 file changed, 34 insertions(+)
 create mode 100755 main/app/sprinkles/extend-user/src/Database/Migrations/v400/MembersTable.php

(limited to 'main/app/sprinkles/extend-user/src/Database/Migrations/v400/MembersTable.php')

diff --git a/main/app/sprinkles/extend-user/src/Database/Migrations/v400/MembersTable.php b/main/app/sprinkles/extend-user/src/Database/Migrations/v400/MembersTable.php
new file mode 100755
index 0000000..a27d485
--- /dev/null
+++ b/main/app/sprinkles/extend-user/src/Database/Migrations/v400/MembersTable.php
@@ -0,0 +1,34 @@
+<?php
+namespace UserFrosting\Sprinkle\ExtendUser\Database\Migrations\v400;
+
+use UserFrosting\System\Bakery\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Database\Schema\Builder;
+
+class MembersTable extends Migration
+{
+    public $dependencies = [
+        '\UserFrosting\Sprinkle\Account\Database\Migrations\v400\UsersTable'
+    ];
+
+    public function up()
+    {
+        if (!$this->schema->hasTable('members')) {
+            $this->schema->create('members', function (Blueprint $table) {
+                $table->increments('id');
+                $table->string('city', 255)->nullable();
+                $table->string('country', 255)->nullable();
+
+                $table->engine = 'InnoDB';
+                $table->collation = 'utf8_unicode_ci';
+                $table->charset = 'utf8';
+                $table->foreign('id')->references('id')->on('users');
+            });
+        }
+    }
+
+    public function down()
+    {
+        $this->schema->drop('members');
+    }
+}
-- 
cgit v1.2.3