search

mm201 / pkmn-classic-framework

Pokémon application logic for Generation IV and V, including servers
http://pkmnclassic.net/
Other
219 stars 43 forks source link

Case sensitive Database Table Names under Linux -> inconsistent names #110

Closed Cowboyjunkie closed 2 years ago

Cowboyjunkie commented 2 years ago

I noticed that the mariaDB which I use under Pi OS is case sensitive with Table Names.

Library -> Data -> MySQL.cs 3288 "FROM pkmncf_pokedex_pokemon_form_Stats"))

Library -> Data -> MySQL.cs 3014 db.ExecuteNonQuery("INSERT INTO pkmncf_pokedex_pokemon_form_stats " +

Line 3288 is so far the only one I found where the "S" is _stats has a uppercase "S". In all other instances the s is lowercase.

Might not be relevant under Windows (not used MySQL in Windows, but SQL Express is not case sensitive with Table Names.

Regards, John

mm201 commented 2 years ago

It's a typo. Neither Windows nor Mac have case-sensitive table names by default, so I never noticed. Should be fixed soon.