CREATE TABLE `members` ( `memberID` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `active` varchar(255) NOT NULL, `resetToken` varchar(255) DEFAULT NULL, `resetComplete` varchar(3) DEFAULT 'No', `user_rang` INT NOT NULL DEFAULT '0', `monety` INT NOT NULL DEFAULT '0.00', PRIMARY KEY (`memberID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;