· 8 years ago · Mar 30, 2018, 06:22 AM
1CREATE TABLE IF NOT EXISTS `accounts` (
2 `ID` int(10) NOT NULL auto_increment,
3 `Username` text NOT NULL,
4 `Password` int(11) NOT NULL,
5 `Money` int(11) NOT NULL default '0',
6 `Score` int(11) NOT NULL default '0',
7 `posX` float NOT NULL,
8 `posY` float NOT NULL,
9 `posZ` float NOT NULL,
10 PRIMARY KEY (`ID`)
11) ENGINE=MyISAM DEFAULT CHARSET=latin1;