Hi all,
I'm wondering if it is possible to manage tables and tables columns in rails... Might be not very clear so here is an example :
I have an application that has specific tables for the users of my app. Let say, I create a database with a 'users' table template (first_name, last_name, email, country). When "joe" creates an account in my app , I want to creates a "joo_users" table which is a "copy" of my template "users" table. Now, joe doesn't care of, let say, the country of his customers so he decides to "remove" the "country" column of his "joe_users" table ...
The same thing if "joe" wants to creates a new column in a specific table ...
What I would like to have is user be able to remove some table columns so his "screen" won't be polluated with fields that he doesn't care of.
Is it possible ? If so I can I do this ?
-> do some create table stuff using SQL command within rails and pass to "table_prefix" "joe" (or whatever is my client name) my "user" model -> do some ALTER table stuff using SQL command within rails to remove unwanted table column ?
Thanks for all your answers !