How can I increase the size of columns in DB tables?

October 08, 2021 09:29
Updated

We moved this page to our Documentation Portal. You can find the latest updates here.

Question

How can I increase the size of columns in DB tables?

Answer

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

Go to OnApp add dir:
```
cd /onapp/interface
```
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].