Increase Size of Column in DB Tables

If required, you can change the column type from INT to BIGINT and vice versa in any database table:

  1. Go to OnApp add dir:

    cd /onapp/interface


  2. Execute the rake task:

    • To switch from INT to BIGINT: 
     RAILS_ENV=production rake db:column:to_bigint[table,column]
    • To switch from BIGINT to INT:
     RAILS_ENV=production rake db:column:to_integer[table,column]


    Where you need to specify the table and its column to which you want to apply changes, e.g [edge_statistics,id].