I have a few blogs/websites hosted on my vps. Recently I’ve decided to move a db on a single central server/vps because all the blogs have the same structure in terms of code and structure of the db.

The problem is, how can I effortlessly start using “application_id” in my db? It will denote a website data belongs to.

Say, I have these tables:

   -- users    -- articles    -- categories    -- tags 

and others. Now I’ll have to insert one additional column in each table: “application_id”

Not a big deal. I think. But perhaps there’s a simple and more smart way to archieve the same goal?

And in general, is it a good idea to move it to a central, single vps/server/db?