Hello, I recently decided to open a sh server, (a bit of nostalgia) but I have a problem, every time the map is changed or someone leaves and enters the server, they have to choose all the powers again. I use a mysql saving method, with those tables:
CREATE TABLE `sh_savexp` (
`SH_KEY` varchar(32) binary NOT NULL default '',
`PLAYER_NAME` varchar(32) binary NOT NULL default '',
`LAST_PLAY_DATE` timestamp(6) NOT NULL,
`XP` int(10) NOT NULL default '0',
`HUDHELP` tinyint(3) unsigned NOT NULL default '1',
`SKILL_COUNT` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`SH_KEY`)
) ENGINE=MyISAM COMMENT='SUPERHERO XP Saving Table';
CREATE TABLE `sh_saveskills` (
`SH_KEY` varchar(32) binary NOT NULL default '',
`SKILL_NUMBER` tinyint(3) unsigned NOT NULL default '0',
`HERO_NAME` varchar(25) NOT NULL default '',
PRIMARY KEY (`SH_KEY`,`SKILL_NUMBER`)
) ENGINE=MyISAM COMMENT='SUPERHERO Skill Saving Table';
-And these are the errors that appear in the console:
[superheromodmysql.amxx] DEBUG: Error Writing MySQL Skills for [BOT]V0id: [1064] 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to us' - 'INSERT INTO `sh_saveskills` VALUES ('[BOT]V0id','11','Xavier'), ('[BOT]V0id','12','Morpheus'), ('[BOT]V0id','13','US Marine'), ('[BOT]V0id','14L 02/12/2022 - 21

6:07: "[P0D]M0rbid
L 02/28/2022 - 10

9:03: [superheromodmysql.amxx] DEBUG: Error Making Tables: [1426] 'Too big precision 14 specified for column 'LAST_PLAY_DATE'. Maximum is 6.' - 'CREATE TABLE IF NOT EXISTS `sh_savexp` ( `SH_KEY` varchar(32) binary NOT NULL default '', `PLAYER_NAME` varchar(32) binary NOT NULL default '', `LAST_PLAY_DATE` timestamp(14) NOT NULL, `XP` int(10) NOT NULL default '0'L 02/28/2022 - 10

9:03: "Breyke<213><STEAM_0:1:82881504><>" entered the game
I don't know if I'm missing something, I'm new to this, I hope you can help me, have a good day!