adding a new table using rails migration..?

Question

I want to add new table using rails migration:

**table_name** users_location_track
**columns** id (primary key, auto increment serial),
            user_id (reference to users), location_info (string), 
            creation_time(time-stamp)

please suggest procedure and code I am new to rails?

It is VERY basic stuff, so I suggest starting from some tutorials/guides, like this: http://guides.rubyonrails.org/ — Marek Lipka, Apr 21 '15 at 09:44

Manish Shrivastava · Answer 1 · 2015-04-21T09:58:46.130

2

In Rails we don't do like you asked. you need to write command like below:

 rails generate migration CreateUserLocationTrack user_id:integer location_info:string

you don't need creation_time as created_at is created by default.

For more information, please follow rails guide.

edited Apr 21 '15 at 09:58

answered Apr 21 '15 at 09:54

Manish Shrivastava

26,075
13
88
100

hey @Manish that much I explored but i want to make user_id as ref type. – piyushmandovra Apr 21 '15 at 09:56
@piyushmandovra, use `add_foreign_key :users_location_track, :users` and check migration guide for more info. – Manish Shrivastava Apr 21 '15 at 09:58
so should I have to add another migration or in same migration I can add ref – piyushmandovra Apr 21 '15 at 10:06
@piyushmandovra, you can edit migration before running `rake db:migrate` – Manish Shrivastava Apr 21 '15 at 10:19

piyushmandovra · Accepted Answer · 2015-04-22T05:45:08.560

thank you for criticizing. Finally I got my answer:

Here's the solution for whoever want in future.

first go to project directory then run following command

rails generate migration add_user_lat_long

and then a migration file will be generate then you can edit in following style:

class AddUserLatLong < ActiveRecord::Migration
  def self.up
    create_table :users_location_track do |t|
      t.string :location_info
      t.references :user

      t.timestamps

end
    add_index :users_location_track, :user_id, :name =>'index_user_lat_longs_on_user_id'
  end

  def self.down
        drop_table :users_location_track
  end
end

adding a new table using rails migration..?

2 Answers2