I am confused about creating tables on runtime... suppose i register to one website, and upon successful registration i want to create a table with my name like--- Neo_Message is the table that i would like to create as soon as i press the button name REGISTER. I am using MYSQL as database..Please help me... thank you..
So you want to create a messages table for the user neo? You know that it would be much easier to create one messages table for everybody and then link that to a specific user by specifying a user_id field in there as well as a has_many :messages on the user model, right?
yes i want to create table for each user. now as u told me .. i am thinkin should i name those table with user ids or name. also please tell me how to do it in rails. i am tryin scaffold method and for that i have also installed active scaffold plugin for rails. but still it is not able to identify the method "active_scaffold" . i dont know y..
I don’t think you understand me.
I said to have ONE messages table for ALL users and inside that table just have a user_id field which references the user.
Yea, you don't seem to understand relational databases and how data is normally stored. Instead of having a new table for each user, you just use foreign keys to mark that a particular record belongs to a user.
users table
-- id -- name -- etc
messages table
-- id -- user_id -- text
User model
has_many :messages
Message model
belongs_to :user
O.. thanks after reading your first reply that thing was going on in my mind.. well now plans changed.. will go your way..
Thanks for the help... I got it..will ask if i face new problem