Dear friends,
I’m using rails 2.0.2. I have created a model sample and i have created
columns using following codes
class CreateSamples < ActiveRecord::Migration
def self.up
create_table :samples, :id => false do |t|
t.column :user_id, :integer, :limit => 10
t.column :name, :string, :limit => 20
t.column :age, :string, :limit => 3
t.timestamps
end
end
def self.down
drop_table :samples
end
end
The default primary key is id and it is auto incremented. I have set id
=> false and i don’t want to use it again. I need to set my user_id as
primary key. Could any one suggest how to set the primary key other than
id in rails 2.0.2
Thanks in advance
Regards,
Jose Martin
in your user model write
set_primary_key “user_id”
On Jul 19, 9:22 am, dare ruby [email protected]
Bala kishore Pulicherla wrote:
in your user model write
set_primary_key “user_id”
On Jul 19, 9:22�am, dare ruby [email protected]
Dear bala,
Thanks for your suggestion. its working fine now.
Could you please provide details about auto incrementation for above
mentioned primary key.
Thanks in advance
Regards,
Jose Martin
u can put the id as itself as an auto increment and while ur creating
the
new user make the id to user_id and update.
for ex.
user = User.new(params[:user])
if user.save!
user_id = user.id
user.update_attribute(:user_id,"#{user.id})
respond_to |format| do
ur - stuff
end
end
mean while i’ll find any :auto_increment option is there 
On Sat, Jul 19, 2008 at 2:11 PM, dare ruby
[email protected]
t.column :user_id, :primary_key, :null => false
hope this will work for u 
On Sat, Jul 19, 2008 at 3:01 PM, bala kishore pulicherla <
Bala kishore Pulicherla wrote:
t.column :user_id, :primary_key, :null => false
hope this will work for u 
On Sat, Jul 19, 2008 at 3:01 PM, bala kishore pulicherla <
Dear Bala,
Thanks for your very valuable information. I have used the above in my
code and its working fine now
Thanks
regards,
Jose Martin
ur welcome. 
On Sat, Jul 19, 2008 at 4:17 PM, dare ruby
[email protected]