Add array column to DB using Devise

Question

I want to add an extra field "favourites' to my database, obviously favourites should be an array of Int (ID of the event to add as favourite). How can I generate a migration for that?

Il'ya Demchenko · Accepted Answer · 2020-03-03 00:10:56Z

1

you need something like this in your migration

add_column :users, :favourites, :integer, array: true, default: []

probably better rename column to favourites_ids

answered Mar 3, 2020 at 0:10

Il'ya Demchenko

114 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

SteveTurczyn · Accepted Answer · 2020-03-02 15:35:57Z

0

You can do

rails g migration AddFavouritesToUser favourites:text

Then modify the migration before you run it...

add_column :users, :favourites, :text, array: true, default: []

answered Mar 2, 2020 at 15:35

SteveTurczyn

37k6 gold badges46 silver badges56 bronze badges

Collectives™ on Stack Overflow

Add array column to DB using Devise

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related