EP2ucRGr

1
2SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
3CREATE TABLE IF NOT EXISTS `aero_logs` (
4  `id` int(11) NOT NULL auto_increment,
5  `owner` varchar(50) NOT NULL,
6  `date` varchar(50) NOT NULL,
7  `token` varchar(50) NOT NULL,
8  `habbo` varchar(50) NOT NULL,
9  `del` varchar(50) NOT NULL,
10  `ip` varchar(50) NOT NULL,
11  `vip` varchar(50) NOT NULL,
12  `hotel` varchar(50) NOT NULL,
13  PRIMARY KEY  (`id`)
14) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
15
16CREATE TABLE IF NOT EXISTS `aero_users` (
17  `id` int(11) NOT NULL auto_increment,
18  `nick` varchar(15) NOT NULL,
19  `senha` varchar(15) NOT NULL,
20  `wcnick` varchar(40) NOT NULL,
21  `ativado` int(1) NOT NULL,
22  `habbo` varchar(15) NOT NULL,
23  `email` varchar(50) NOT NULL,
24  `last_loginstamp` varchar(123) NOT NULL,
25  `ip` varchar(90) NOT NULL,
26  `banned_reason` varchar(1000) NOT NULL,
27   `chat_rank` int(1) NOT NULL,
28  `chat_cor` varchar(8) NOT NULL,
29  `chat_banned` int(15) NOT NULL,
30  `chat_mudo` int(1) NOT NULL,
31  `rank` varchar(70) NOT NULL,
32  `laststamp` varchar(70) NOT NULL,
33  PRIMARY KEY  (`id`)
34) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
35CREATE TABLE IF NOT EXISTS `hbx_chat` (
36  `id` int(11) NOT NULL auto_increment,
37  `nick` varchar(15) collate latin1_general_ci NOT NULL,
38  `message` varchar(100) collate latin1_general_ci NOT NULL,
39  `del` int(11) NOT NULL,
40  `hbx_id` varchar(10) collate latin1_general_ci NOT NULL,
41  PRIMARY KEY  (`id`)
42) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
43CREATE TABLE IF NOT EXISTS `hbx_alert` (
44  `id` int(11) NOT NULL auto_increment,
45  `user` varchar(60) collate latin1_general_ci NOT NULL,
46  `msg` varchar(560) collate latin1_general_ci NOT NULL,
47  `read` int(11) NOT NULL,
48  `hbx_id` varchar(10) collate latin1_general_ci NOT NULL,
49  PRIMARY KEY  (`id`)
50) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
51
52ALTER TABLE  `aero_users` ADD  `banned` INT NOT NULL AFTER  `last_loginstamp` ;