How can i set already migrated migrations as a migrated migrations in Laravel without migrate:fresh?

Question

I have 20 tables in my database. and i want to migrate a new one into the database. But i get the error :

Base table or view already exists: 1050 Table 'house_statuses' already exists.

This table is already in database but everytime i want to migrate something new i got this while this migration already has been migrated earlier.

I see some solutions like yeah Migrate:fresh, But i dont want to remove my records in database because its so much work to set the records back

Why dont you create a new migration? – Piazzi Mar 07 '19 at 12:26 — Piazzi, Mar 07 '19 at 12:26
What do that make a diffrence? i – Thomas Van de Weg Mar 07 '19 at 12:29 — Thomas Van de Weg, Mar 07 '19 at 12:29

score 1 · Accepted Answer · answered Mar 07 '19 at 12:33

If you want to insert more columns in your table you should use the Schema::table, for example:

Let's say you need one more column in your users table, you can simply do that:

Use the command:

php artisan make:migration add_age_to_users_table --table=users

Schema::table('users', function (Blueprint $table) {
    $table->integer('age');
});

And then use:

php artisan migrate

This way your users table will be updated with the new column age

Everytime you want to make a change in your Database you should create a new migration and not edit the last one.

score 0 · Answer 2 · edited Mar 07 '19 at 12:46

0

Follow following steps:

It might help you.

edited Mar 07 '19 at 12:46

Piazzi

answered Mar 07 '19 at 12:16

narayansharma91

Its already in the migrations table. and i removed it and added it back and still not working – Thomas Van de Weg Mar 07 '19 at 12:24

2 Answers2