-- --------------------------------------------------------
--
-- Table structure for table players
--
CREATE TABLE players (
ID int(11) NOT NULL,
user varchar(24) NOT NULL,
pass varchar(129) NOT NULL,
Admin tinyint(2) NOT NULL,
Helper tinyint(1) NOT NULL,
Money int(12) NOT NULL,
Score smallint(3) NOT NULL,
Status tinyint(1) NOT NULL,
Reg tinyint(1) NOT NULL,
Sex tinyint(1) NOT NULL,
Age tinyint(2) NOT NULL,
Mute int(11) NOT NULL DEFAULT -1,
HoursPlayed float NOT NULL,
sec_jucate float NOT NULL,
RPoints int(11) NOT NULL,
BankMoney int(11) NOT NULL DEFAULT 300000,
WantedLevel tinyint(1) NOT NULL,
PhoneBook tinyint(1) NOT NULL,
Job tinyint(2) NOT NULL,
Jailed int(11) NOT NULL DEFAULT -1,
Premium int(16) NOT NULL,
Materials int(7) NOT NULL,
Drugs int(7) NOT NULL,
Member tinyint(2) NOT NULL,
Rank tinyint(2) NOT NULL,
PhoneNumber mediumint(6) NOT NULL,
House smallint(3) NOT NULL[...]