Single database naming style

[Arantir]

What about rework all column names in database, all to be in the same conventional style?
I propose a simple: all names have to be lowercase; words are separated with underscore.
Lowercase names are more compatible in general case.

There is a lot style blending, even in a single table... For example "created_time", "accessLevel", "lastIP", "pcIp" columns in accounts table. It's some salad of styles . Especially "lastIP" vs "pcIp"...
It really doesn't look pretty for me as for programmer.

[jurchiks]

table names - lowercase with underscores
column names - lower camel case

That's the most used standard, not just in L2J.
I do agree that the column names should be changed to a single style, but not like table names.

[Arantir]

That's the most used standard, not just in L2J.
I do agree that the column names should be changed to a single style, but not like table names.

I would agree for any style if it is just the same altogether through a database =)

[UnAfraid]

Yes i am agree but that's kinda time consuming task.
I don't think we have that much time now to perform such database update also there will be lots of typos.
By our side or by community's side (miss updated some change) and we'll create a lot of problems i think.

[Arantir]

You could start with a little and do step by step =)

Sadly, but you're quite right about community's side. Simplest example is websites' registration scripts which, surely, use queries based on current db structure.
But, I think, those who can update their serves also should can change some other things, e.g. reg forms on site.
Not all updates are perfectly compatible with l2j-users' features =)

I hope you will keep in mind this good idea, to make l2j more gracefully, for a while... while there be a good chance for it.

Yeah, nothing hinders me to make a changes which I want on my sever. I just want also make something good for others too =)

[UnAfraid]

well changes like this one requires team decision, my isn't enough.