Database-Prefix for multiple Installations

Permalink
Hi Guys and Gals,

i really felt in love with Concrete5 and built some websites with it.

But, my (acshully) only point of critic is:
Why do we have to point it to a "clear database"?
Hey! All we need, is a DB-Server. Why isn't it possible to give the "current installation" a prefix like "customerx_"?

Should be a simple thing to add this to the source. And it would be a great opportunity to spread Concrete5 (thinking about "have a look here, i set up a site for you").

In the moment, it's a really pain in the a** for me, that i'm not able to set it up in kinda "test/showthingys"-database.

What's your opinion?

Mac65
 
jaredquinn replied on at Permalink Reply
jaredquinn
I guess the biggest issue I see with this is that a lot of marketplace add-ons will reference the tables they create in their package in their models. There would need to be significant rework of a large number of these to achieve a database prefix.

Jared
Mnkras replied on at Permalink Reply
Mnkras
currenty you can't add a prefix, but you really shouldn't stick multiple sites on 1 db for various reasons
Mac65 replied on at Permalink Reply
Mac65
Well, thanks for the quick response.
But i actually just don't see the "problem".
At least here in Europe, Concrete5 isn't well known.
And i'm more than happy to find it before i went my way into Joomla etc...
But (speaking personally for me) i have about 100 customer accounts, but only 20 databases...
And i really don't see the point, why C5 needs "its own" DB and not a chooseable prefix. This really stops me from offering customers this sweet piece of software.
And, i also don't see the point, why a customer that uses (let's say) C5 _and_ $othersoftware, needs TWO databases...
Who cares about tablenames?
Mac65 replied on at Permalink Reply
Mac65
PS: Also talking with a lot of people here (Germany), the response was:
- What a great piece of CMS Software!
- But, isn't it possible to put it in an existing database?

And, honestly, that response came up from 9 of 10 very experienced people...
synlag replied on at Permalink Best Answer Reply
synlag
Hi,

here is what might help you, i haven't tested so far, but give it a try and tell us if it works :)

https://github.com/bvidis/concrete5-table-prefix-tweak...

Best
Ron
Mac65 replied on at Permalink Reply
Mac65
Hi Ron,
thanks for the hint - looks "interesting" ;-)
I love the line "WARNING: THIS SCRIPT WILL BREAK THINGS AND ADD SOME PREFIXES WHERE IT SHOULD NOT!!!!!
YOU WILL HAVE TO MANUALLY UPDATE THE WRONGLY UPDATED FILES."

Well, i'll give it a try between xmas and new year and keep you updated.

Tanks
Mac
Mnkras replied on at Permalink Reply
Mnkras
Backup your db first, please note that install of addons and updates will not work