jeudi 9 février 2017

Errors when refreshing migration of DB tables

After refreshing my migrations im getting issues between users migrations and account Types users table, cant figure out the problem.

Error is:

[Illuminate\Database\QueryException]
  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'account_typ
  es' already exists (SQL: create table `account_types` (`id` int unsigned no
  t null auto_increment primary key, `name` varchar(50) not null, `created_at
  ` timestamp null, `updated_at` timestamp null) default character set utf8mb
  4 collate utf8mb4_unicode_ci)



  [PDOException]
  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'account_typ
  es' already exists

My Migrations: Account Types:

 public function up()
    {
        Schema::create('account_types', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name', 50);
            $table->timestamps();
        });
    }


    public function down()
    {
        Schema::dropIfExists('account_types');
    }

Users:

 public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->string('surname', 20);
            $table->string('email')->unique();
            $table->string('password');
            $table->string('mobilephone', 9);
            $table->rememberToken();
            $table->timestamps();
        });


    }
    public function down()
    {
        Schema::dropIfExists('users');
    }

Relation ship between the users and account types, i believe that maybe the problem is here, but still cant figure out what is wrong with the migration code.

Relation of Users and Account Types:

 public function up()
    {
        Schema::table('users', function($table) {
            $table->integer('account_type_id')->unsigned();
            $table->foreign('account_type_id')
                ->references('id')->on('account_types');
        });
    }


    public function down()
    {
        Schema::table('users', function (Blueprint $table) {
            $table->dropForeign('users_account_type_id_foreign');
            $table->dropColumn('account_type_id');
        });
    }



from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2kr6sPM
via IFTTT

Aucun commentaire:

Enregistrer un commentaire