Post by al3xandr1a » Sat Jun 01, 2013 12:33 pm

Installing opencart, is an underscore "_" necessary in table prefixes?

What will happen if I use "prefixname" only instead of "prefixname_" ?

~al3xandr1a
Newbie / Student


User avatar
New member

Posts

Joined
Fri Jul 02, 2010 7:27 pm

Post by ChetanCx » Sat Jun 01, 2013 3:08 pm

Its not compulsory to use underscore in prefix

example :
table prefix = mystore
table names :- mystoreorders , mystoreproducts etc...

table prefix = mystore_
table names :- mystore_orders , mystore_products etc...

conclusion - easier to read table names

User avatar
Active Member

Posts

Joined
Sat Dec 08, 2012 8:12 pm

Post by al3xandr1a » Sat Jun 01, 2013 6:02 pm

So its only for readability of the developer and nothing to do with database function.... is that correct?

~al3xandr1a
Newbie / Student


User avatar
New member

Posts

Joined
Fri Jul 02, 2010 7:27 pm

Post by Johnathan » Sat Jun 01, 2013 9:36 pm

Yes, the underscore is not required. It's just a database convention to prefix the tables with something related to the software, followed by an underscore.

Image Image Image Image Image


User avatar
Administrator

Posts

Joined
Fri Dec 18, 2009 3:08 am

Who is online

Users browsing this forum: No registered users and 309 guests