Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
table prefix instead of database
02-25-2014, 11:25 AM,
#1
table prefix instead of database
Just a request, could it be possible to consider using table prefixes for new companies instead of requiring a new schema for each one (similarly for the initial set-up: database prefix actually appends the prefix to the database instead of the more useful and common prefix to table names)...
Most MySQL-heavy suites I know of make that an option. I am willing to contribute code towards it if necessary... what is the rationale behind having database prefixes instead of table prefixes anyways?
Reply
02-25-2014, 11:31 AM,
#2
RE: table prefix instead of database
Hi serakfalcon,

(02-25-2014, 11:25 AM)serakfalcon Wrote: what is the rationale behind having database prefixes instead of table prefixes anyways?

I wondered the same (see http://www.weberp.org/forum/showthread.php?tid=973).

My own thoughts as per that thread were that perhaps in some automated install process for a hosting company, pre-pending database with user name might be done. Although I can't picture an actual use case. One could just add the prefix in the database name in the installer. I'd be interested to hear of some use cases too.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)