Laravel migration table field s type change

Question

Following is my file 2015 09 14 051851 create orders table php  And I want to change  table- gt integer  category id    as a string with new migration    lt  php  use Illuminate Database Schema Blueprint  use Illuminate Database Migrations Migration   class CreateOrdersTable extends Migration                   Run the migrations                 return void             public function up                 Schema  create  orders   function Blueprint  table                         table- gt increments  id                 table- gt string  num                 table- gt integer  user id                  table- gt text  store name                 table- gt integer  store name publication                  table- gt string  postal code   255                table- gt string  phone number   255                 table- gt text  title                 table- gt text  description                  table- gt string  list image filename1   255                table- gt string  list image filename2   255 - gt nullable                 table- gt string  list image filename3   255 - gt nullable                 table- gt string  list image filename4   255 - gt nullable                 table- gt string  list image filename5   255 - gt nullable                  table- gt integer  term                  table- gt datetime  state0 at  - gt nullable                 table- gt datetime  state1 at  - gt nullable                 table- gt datetime  state2 at  - gt nullable                 table- gt datetime  state3 at  - gt nullable                 table- gt datetime  state4 at  - gt nullable                 table- gt datetime  state5 at  - gt nullable                 table- gt datetime  state6 at  - gt nullable                 table- gt datetime  state7 at  - gt nullable                 table- gt datetime  state8 at  - gt nullable                 table- gt datetime  state9 at  - gt nullable                 table- gt datetime  state10 at  - gt nullable                  table- gt integer  category id                 table- gt integer  target customer sex                 table- gt integer  target customer age                  table- gt integer  payment order                 table- gt integer  num comment                 table- gt integer  num view                 table- gt string  num pop                  table- gt integer  money                 table- gt integer  point                  table- gt datetime  closed at                 table- gt timestamps                 table- gt softDeletes                                      Reverse the migrations                 return void             public function down                 Schema  drop  orders

User · Answer

Not really an answer  but just a note about - gt change        Only the following column types can be  changed   bigInteger  binary  boolean  date  dateTime  dateTimeTz  decimal  integer  json  longText  mediumText  smallInteger  string  text  time  unsignedBigInteger  unsignedInteger and unsignedSmallInteger    https   laravel com docs 5 8 migrations modifying-columns  If your column isn t one of these you will need to either drop the column or use the alter statement as mentioned in other answers

User · Answer

For me the solution was just replace unsigned with index  This is the full code       Schema  create  champions overview  function  Blueprint  table            table- gt engine    InnoDB            table- gt increments  id             table- gt integer  cid  - gt index             table- gt longText  name                  Schema  create  champions stats  function  Blueprint  table            table- gt engine    InnoDB            table- gt increments  id             table- gt integer  championd id  - gt index             table- gt foreign  championd id    ch id  - gt references  cid  - gt on  champions overview

User · Answer

update  31 Oct 2018  Still usable on laravel 5 7 https   laravel com docs 5 7 migrations modifying-columns  To make some change to existing db  you can modify column type by using  change   in migration   This is what you could do  Schema  table  orders   function   table         table- gt string  category id  - gt change          please note you need to add doctrine dbal dependency to composer json for more information you can find it here http   laravel com docs 5 1 migrations modifying-columns

User · Answer

First composer requires doctrine dbal  then    table- gt longText  column name  - gt change

User · Answer

2018 Solution  still other answers are valid but you dont need to use any dependency   First you have to create a new migration   php artisan make migration change appointment time column type   Then in that migration file up    try       Schema  table  appointments   function   table             table- gt string  time  - gt change              If you donot change the size default will be varchar 191  but If you want to change size of the field       Schema  table  appointments   function   table             table- gt string  time   40 - gt change              Then migrate the file by   php artisan migrate   more info from doc

User · Answer

The standard solution didn t work for me  when changing the type from TEXT to LONGTEXT   I had to it like this   public function up         DB  statement  ALTER TABLE mytable MODIFY mycolumn  LONGTEXT        public function down         DB  statement  ALTER TABLE mytable MODIFY mycolumn TEXT         This could be a Doctrine issue  More information here   Another way to do it is to use the string   method  and set the value to the text type max length       Schema  table  mytable   function   table               Will set the type to LONGTEXT           table- gt string  mycolumn   4294967295 - gt change

User · Answer

all other answers are Correct But  Before you run  php artisan migrate   make sure you run this code first   composer require doctrine dbal   to avoid this error      RuntimeException    Changing columns for table  items  requires Doctrine DBAL  install    doctrine dbal

[php] Laravel migration table field's type change

Examples related to php

Examples related to laravel

Examples related to migration