Issue Information
-
#005587
-
2 - Fair
-
Fixed
Issue Confirmations
-
Yes (0)No (0)
0
Originally posted by Kenpachi
`name` column in `char` table should be unique because 3rd party tools like control panels could produce errors.
`name` column in `char` table should be unique because 3rd party tools like control panels could produce errors.
Originally posted by Kenpachi
Fixed in [rev=16490].
Fixed in [rev=16490].
Originally posted by Lemongrass
I thought *Athena isn't going to apply according to 3rd party tools rather they have to apply to *Athena.
Anyways if you're already at fixing the data structures in SQL would you mind adding foreign keys to the tables?
I thought *Athena isn't going to apply according to 3rd party tools rather they have to apply to *Athena.
Anyways if you're already at fixing the data structures in SQL would you mind adding foreign keys to the tables?
Originally posted by Kenpachi
Well, since someone told me that a nooby 3rd party tool doesn't check for duplicate names and creates them I was forced to add this to the DB layout.
We do have many foreign keys already. For example:
- `char`.`account_id`
- `char`.`party_id`
- `char`.`guild_id`
- many more
Just because they aren't connected hard in the DB layout it doesn't mean they are no foreign keys... but I'll discuss this with the other developers (again ^^).
Well, since someone told me that a nooby 3rd party tool doesn't check for duplicate names and creates them I was forced to add this to the DB layout.
We do have many foreign keys already. For example:
- `char`.`account_id`
- `char`.`party_id`
- `char`.`guild_id`
- many more
Just because they aren't connected hard in the DB layout it doesn't mean they are no foreign keys... but I'll discuss this with the other developers (again ^^).
Originally posted by Lemongrass
I know that those are foreign keys. But in truth or as they are they are no real foreign keys, which means there is no consistency check.
Additionally some usage of the "ON DELETE CASCADE" feature would be very nice. It would give administrators a huge benefit during the cleaning of their database(s).
I know that those are foreign keys. But in truth or as they are they are no real foreign keys, which means there is no consistency check.
Additionally some usage of the "ON DELETE CASCADE" feature would be very nice. It would give administrators a huge benefit during the cleaning of their database(s).
