I'm wondering if it is possible to manage tables and tables columns in
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
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 !