Level 104
MySQL only https://laravel.com/docs/9.x/migrations#column-modifiers
Why does the order of the columns matter at all?
1 like
Sep 5, 2022
7
Level 3
$table->after() not working in database migration!
Hey, I'm running a latest laravel 9 application on my local machine. According to the official db migrations doc , I can move a column of a table using the after() method.
Currently I have a posts table in my sqlite3 database and I want to add a new column named 'views' in it. So I normally ran the migration command and in the migration file, I added $table->bigInteger('views')->after('cover')->default(0); line inside the up() method (also provided convenient stuffs to reverse the migration in the down() method).
So after running the php artisan migrate command, and checking the table, I realized that the views column has been created but in wrong order, in the usual order, I mean at the end of the table.
After testing and performing the same process for couple times, I still ain't got no solution or idea that, why it isn't working!
Is that because I'm using sqlite? 😑😑😑 How can I solve this problem and order my column as I want?
N.B. (Doctrine/Dbal already installed through composer)
Thank You!
Level 3
@tykus Urrrgh... Exactly what I suspected! 😶🌫️ Thanks for your answer.
Btw, I dunno maybe it gives me inner peace ordering the columns sometimes. Or maybe pleasure for eyes 👀
1 like
Level 104
@alnahian2003 really it's not important. TBH I rarely am looking at a DB GUI anymore so I don't feel that pain very often.
1 like
Level 102
Sqlite does not support inserting a column at a specific location. https://stackoverflow.com/questions/4253804/insert-new-column-into-table-in-sqlite/4253879#4253879
1 like
Level 3
@Sinnbeck Aha! Seems like sqlite has many restrictions 😑
ALRIGHT, Thanks a lot. It was kinda out of the box thing for me
Level 80
Seems like sqlite has many restrictions
@alnahian2003 Not restrictions, but the clue is in the name: sqlite
2 likes
Level 122
And obviously this only applies to on-going maintenance migrations. Otherwise, go back to your earlier migrations, amend them and rebuild the database.
3 likes
Please or to participate in this conversation.