Disable 'x', 'y', 'z', 'world', 'yaw', 'pitch' MySQL columns
TheMixaDev opened this issue ยท 3 comments
I'm defined in config to not save players locations, and columns 'x', 'y', 'z', 'world', 'yaw', 'pitch' in MySQL table is excess. When I'm trying to set empty values on them in config, AuthMe catches an error in MySQL syntax. That would be very useful to fully disable them and save some space in DB.
I've removed world, yaw and pitch by setting this values in config:
#Column for storing player LastLocation - X
mySQLlastlocX: 'x'
#Column for storing player LastLocation - Y
mySQLlastlocY: 'y'
#Column for storing player LastLocation - Z
mySQLlastlocZ: 'z'
#Column for storing player LastLocation - World Name
mySQLlastlocWorld: 'Z'
#Column for storing player LastLocation - Yaw
mySQLlastlocYaw: 'X'
#Column for storing player LastLocation - Pitch
mySQLlastlocPitch: 'Y'
I can't set everywhere 'x' or any other letter because of MySQL syntax exception, but values like this isn't creating any issues and allow to avoid of creation 3/6 excess columns
That would be very useful to fully disable them and save some space in DB.
Do you really need that? AuthMe's DB is quite small - about 1mb per ~2.5k players, so for 1gb you have to register, like, 2.5mil accounts. If you really have this total amount of players, I think that you already have some good host for your DB.