b2MLR55r

1DROP TABLE IF EXISTS `user`;
2CREATE TABLE `user` (
3  `ID_PLAYER` int(11) NOT NULL,
4  `NAME_PLAYER` varchar(32) NOT NULL,
5  `USER` varchar(32) NOT NULL,
6  `PASSWORD` varchar(32) DEFAULT NULL,
7  `LOGIP` varchar(32) DEFAULT NULL,
8  `LOGDATA` varchar(32) DEFAULT NULL,
9  `PLAYER_CREATE` char(3) DEFAULT NULL,
10  `EMAIL` varchar(127) DEFAULT NULL,
11  `SEX` char(1) DEFAULT NULL,
12  `PANG` int(11) DEFAULT NULL,
13  `COOKIE` int(11) DEFAULT NULL,
14  `MACROHOTKEYF1` char(64) DEFAULT NULL,
15  `MACROHOTKEYF2` char(64) DEFAULT NULL,
16  `MACROHOTKEYF3` char(64) DEFAULT NULL,
17  `MACROHOTKEYF4` char(64) DEFAULT NULL,
18  `MACROHOTKEYF5` char(64) DEFAULT '',
19  `MACROHOTKEYF6` char(64) DEFAULT NULL,
20  `MACROHOTKEYF7` char(64) DEFAULT NULL,
21  `MACROHOTKEYF8` char(64) DEFAULT NULL,
22  `MACROHOTKEYF9` char(64) DEFAULT NULL,
23  `OFFSETPRIMARY` varchar(8) NOT NULL,
24  `OFFSETSECUNDARY` varchar(8) NOT NULL,
25  `ONLINE` int(1) DEFAULT NULL,
26  `BAN` char(1) DEFAULT NULL,
27  `INDEX_SOCKET` int(12) DEFAULT NULL,
28  `LEVEL` int(12) DEFAULT NULL,
29  `ID_CLUB_SET` varchar(11) DEFAULT NULL,
30  `ID_COMET` varchar(255) DEFAULT NULL,
31  `ID_TITLE` varchar(11) DEFAULT NULL,
32  `ID_CADDIE` varchar(255) DEFAULT NULL,
33  `ID_MASCOT` varchar(11) DEFAULT NULL,
34  `ID_BACKGROUND` varchar(11) DEFAULT NULL,
35  `ID_FRAMES` varchar(11) DEFAULT NULL,
36  `ID_STICKERS` varchar(255) DEFAULT NULL,
37  `ID_CUT_IN` varchar(11) DEFAULT NULL,
38  `DAYS_LOGGED_ON` int(11) DEFAULT NULL,
39  `DATE_LAST_ENTRY` int(11) DEFAULT NULL,
40  `CHAR_SELECT` int(11) DEFAULT NULL,
41  `ID_SKIN` varchar(11) DEFAULT NULL,
42  `ID_SLOT` varchar(255) DEFAULT NULL,
43  PRIMARY KEY (`ID_PLAYER`,`OFFSETSECUNDARY`,`OFFSETPRIMARY`,`NAME_PLAYER`,`USER`)
44) ENGINE=InnoDB DEFAULT CHARSET=latin1;