Database Design

[Serializator]

Please... Improve your database design!

[weaondara]

just complaining will not improve it ... make suggestions

[Serializator]

A database isn't the same as a configuration file with a path, use separate tables/columns for data and normalize it.

You're literally using paths in a database...

[weaondara]

did you try the mysql2 bsackend? it uses mysql ... just to clearify that

[Serializator]

It's not what I'm talking about, I'm talking about your database design/structure. The only columns you have are "key" and "value" and you use paths such as (example) "groups.test.prefix" as the key and the prefix as the value.

You could split your current table/columns into (example):

• groups
• group_options
• group_permissions
• group_inheritances

And use foreign keys to reference a row in the "groups" table from "group_permissions".

[ducc]

my s q l = relational database use it as a relational database

[Serializator]

What's with the spacing @Sponges x-)

[ducc]

Stop BUllyINg mE @Serializator

[aurorasmiles]

This was the old backend, which is now deprecated. Please use MySQL2 as a backend.