· 8 years ago · May 25, 2018, 11:32 AM
1CREATE TABLE IF NOT EXISTS `users` (
2 `ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Players ID',
3 `Username` text NOT NULL COMMENT 'Players Username',
4 `Password` text NOT NULL COMMENT 'Players Password',
5 `Salt` text NOT NULL COMMENT 'The Passwords Salt',
6 `Email` text NOT NULL COMMENT 'Players Email',
7 `SysCrumbs` longtext NOT NULL COMMENT 'System Crumbs',
8 `ComCrumbs` longtext NOT NULL COMMENT 'Communication Crumbs',
9 `IglooCrumbs` longtext NOT NULL COMMENT 'Igloo Crumbs',
10 `Inventory` longtext NOT NULL COMMENT 'Users Inventory',
11 `rndK` text NOT NULL COMMENT 'Random Key',
12 PRIMARY KEY (`ID`)
13) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='User Accounts' AUTO_INCREMENT=3696 ;