AuthMe SQL

CREATE TABLE `authme` (
  `id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(255) NOT NULL,
  `realname` VARCHAR(255) NOT NULL,
  `password` VARCHAR(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `ip` VARCHAR(40) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
  `lastlogin` BIGINT DEFAULT NULL,
  `x` DOUBLE NOT NULL DEFAULT '0',
  `y` DOUBLE NOT NULL DEFAULT '0',
  `z` DOUBLE NOT NULL DEFAULT '0',
  `world` VARCHAR(255) NOT NULL DEFAULT 'world',
  `regdate` BIGINT NOT NULL DEFAULT '0',
  `regip` VARCHAR(40) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
  `yaw` FLOAT DEFAULT NULL,
  `pitch` FLOAT DEFAULT NULL,
  `email` VARCHAR(255) DEFAULT NULL,
  `isLogged` SMALLINT NOT NULL DEFAULT '0',
  `hasSession` SMALLINT NOT NULL DEFAULT '0',
  `totp` VARCHAR(32) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb3;
SELECT * FROM aquaville_dev.users;