Mysql table prefix
edited April 2012
Hello, i want to use this script with a table prefix on mysql. For example, the table avatar like 1_avatar.
how can i made it?
Sorry for the expression, but I'm Spanish and do not speak English very well :)
Since you cannot share a database with another application, prefixes are not needed. See
"Note that StatusNet must have its own database; you can't share the database with another program. You can name it whatever you want, though."
I need this, because i want to develop a multisite with status.net script.
I'm editting the script to get it :D with the var $__table in each class is easy make it.
If you're doing a multisite, why not have separate databases? You could name the databases subdomain_ name_statusnet. (For instance, site1.yoursite.com could use a database named site1_statusnet, while site2.yoursite.com could use site2_statusnet as its database.)
That way, you have less risk of database corruption and a less confusing situation to manage.
I like the idea :)
I'll try to do so.
For more security you can change database prefixes. I have do that for
How did you do?
I see in the classes $ __table without any prefix integrated.
For more security? I fail to see how using prefixes vs multiple databases increases security. All I can see is that it decreases reliability. Care to explain?
I do it with bash script, but I need some time to publish it.
It looks like you're new here. If you want to get involved, click one of these buttons!
Powered by Vanilla