· 9 years ago · Dec 22, 2016, 09:28 PM
1-- phpMyAdmin SQL Dump
2-- version 3.3.9.2
3-- http://www.phpmyadmin.net
4--
5-- Servidor: localhost
6-- Tempo de Geração: Dez 22, 2016 as 07:25 PM
7-- Versão do Servidor: 5.5.10
8-- Versão do PHP: 5.3.6
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12
13/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16/*!40101 SET NAMES utf8 */;
17
18--
19-- Banco de Dados: `hubbo`
20--
21
22-- --------------------------------------------------------
23
24--
25-- Estrutura da tabela `users`
26--
27
28CREATE TABLE IF NOT EXISTS `users` (
29 `id` int(11) NOT NULL AUTO_INCREMENT,
30 `user_id` int(250) DEFAULT NULL,
31 `username` varchar(125) CHARACTER SET latin1 NOT NULL,
32 `real_name` varchar(40) CHARACTER SET latin1 NOT NULL,
33 `password` varchar(255) DEFAULT NULL,
34 `auth_ticket` varchar(60) CHARACTER SET latin1 NOT NULL,
35 `working` varchar(60) CHARACTER SET latin1 NOT NULL,
36 `mymusik` varchar(60) CHARACTER SET latin1 NOT NULL,
37 `secretcode` varchar(60) CHARACTER SET latin1 NOT NULL,
38 `rank` int(1) unsigned DEFAULT '1',
39 `vip_points` int(11) NOT NULL DEFAULT '0',
40 `credits` int(11) DEFAULT '35000',
41 `activity_points` int(11) DEFAULT '3500',
42 `activity_points_lastupdate` double NOT NULL DEFAULT '0',
43 `diamonds` int(11) NOT NULL DEFAULT '0',
44 `look` char(255) CHARACTER SET latin1 DEFAULT NULL,
45 `gender` enum('M','F') CHARACTER SET latin1 NOT NULL DEFAULT 'M',
46 `motto` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
47 `mail` varchar(255) NOT NULL DEFAULT 'undefined',
48 `account_created` double(50,0) NOT NULL DEFAULT '0',
49 `last_online` int(11) NOT NULL DEFAULT '0',
50 `online` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
51 `ip_last` varchar(120) CHARACTER SET latin1 NOT NULL DEFAULT '',
52 `ip_reg` varchar(120) CHARACTER SET latin1 NOT NULL DEFAULT '',
53 `home_room` int(10) unsigned NOT NULL DEFAULT '0',
54 `newbie_status` int(11) NOT NULL DEFAULT '0',
55 `is_muted` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
56 `mutant_penalty` enum('0','1','2') CHARACTER SET latin1 NOT NULL DEFAULT '0',
57 `mutant_penalty_expire` int(11) NOT NULL DEFAULT '0',
58 `trade_lock` enum('0','1') NOT NULL DEFAULT '0',
59 `trade_lock_expire` int(11) NOT NULL DEFAULT '0',
60 `block_newfriends` enum('1','0') NOT NULL DEFAULT '0',
61 `hide_online` enum('1','0') NOT NULL DEFAULT '0',
62 `hide_inroom` enum('1','0') NOT NULL DEFAULT '0',
63 `vip` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
64 `vip_expire` timestamp NOT NULL DEFAULT '2014-05-13 18:58:48',
65 `birth` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
66 `talent_status` enum('citizenship','helper') NOT NULL DEFAULT 'citizenship',
67 `mysterybox_key_colour` int(11) NOT NULL DEFAULT '0',
68 `last_name_change` int(11) NOT NULL DEFAULT '0',
69 `client_volume` varchar(255) NOT NULL DEFAULT '100,100,100',
70 `nux_passed` enum('0','1') NOT NULL DEFAULT '0',
71 `seckey` varchar(999) NOT NULL DEFAULT '',
72 `voted` int(11) NOT NULL DEFAULT '0',
73 `owner` int(99) NOT NULL DEFAULT '0',
74 `novato` int(99) NOT NULL DEFAULT '0',
75 `fundom` varchar(255) NOT NULL DEFAULT '#43AC6A',
76 `builders_expire` int(11) DEFAULT '3700',
77 `builders_items_max` int(11) NOT NULL DEFAULT '100',
78 `builders_items_used` int(11) NOT NULL DEFAULT '0',
79 `release_version` int(11) NOT NULL DEFAULT '2',
80 `on_duty` enum('0','1','2','3') NOT NULL DEFAULT '0',
81 `OnDuty` varchar(255) NOT NULL DEFAULT 'false',
82 `DutyLevel` int(11) NOT NULL DEFAULT '0',
83 `navilogs` varchar(255) CHARACTER SET latin1 DEFAULT '1,official-root,;2,popular,;3,my,;4,favorites,',
84 `navigator` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
85 `respect` int(11) NOT NULL DEFAULT '0',
86 `allow_pull` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
87 `cms_currency` varchar(255) NOT NULL,
88 `seashells` int(11) NOT NULL DEFAULT '0',
89 `trusted` int(11) NOT NULL DEFAULT '0',
90 `age` varchar(255) NOT NULL,
91 `role` varchar(255) NOT NULL,
92 `country` varchar(255) NOT NULL DEFAULT 'Unknown',
93 `rank_vip` int(1) DEFAULT '3',
94 `volume` varchar(15) CHARACTER SET latin1 DEFAULT '100,100,100',
95 `last_change` int(20) DEFAULT '0',
96 `machine_id` varchar(125) CHARACTER SET latin1 DEFAULT NULL,
97 `focus_preference` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
98 `chat_preference` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
99 `pets_muted` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
100 `bots_muted` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
101 `advertising_report_blocked` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
102 `gotw_points` int(11) DEFAULT '0',
103 `ignore_invites` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
104 `time_muted` double DEFAULT '0',
105 `allow_gifts` enum('0','1') CHARACTER SET latin1 DEFAULT '1',
106 `trading_locked` double DEFAULT '0',
107 `friend_bar_state` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '1',
108 `disable_forced_effects` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
109 `allow_mimic` enum('1','0') CHARACTER SET latin1 NOT NULL DEFAULT '1',
110 `votos` int(11) DEFAULT NULL,
111 `pin` int(11) DEFAULT NULL,
112 `photo_perfil` varchar(255) NOT NULL,
113 `portada` varchar(255) DEFAULT NULL,
114 `seasonal_currency` int(11) NOT NULL DEFAULT '40',
115 `refer_points` varchar(10) CHARACTER SET latin1 NOT NULL DEFAULT '0',
116 `refer_count` varchar(50) DEFAULT '0',
117 `last_used` varchar(50) DEFAULT '0',
118 `facebook_change` varchar(50) DEFAULT '0',
119 `loyalty_points` int(11) NOT NULL DEFAULT '0',
120 `staff_twitter` varchar(50) DEFAULT NULL,
121 `staff_facebook` varchar(50) DEFAULT NULL,
122 `forgot_ticket` varchar(50) DEFAULT NULL,
123 `facebook_id` varchar(50) DEFAULT NULL,
124 `facebook` int(50) DEFAULT NULL,
125 `staff_background_url` text,
126 `staff_ocult` varchar(50) DEFAULT '0',
127 `country_cf` varchar(50) DEFAULT 'ec',
128 `staff_profileimage_url` varchar(150) DEFAULT '0',
129 `belcredits` int(11) NOT NULL DEFAULT '30',
130 `radio` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '1',
131 `cookies` int(11) NOT NULL DEFAULT '60',
132 `facebook_vin` varchar(11) CHARACTER SET latin1 NOT NULL DEFAULT '0',
133 `homework` varchar(400) CHARACTER SET latin1 NOT NULL,
134 `RequireChangenameForFacebook` varchar(11) CHARACTER SET latin1 NOT NULL DEFAULT '0',
135 `birthday` varchar(50) DEFAULT NULL,
136 `color` varchar(10) CHARACTER SET latin1 NOT NULL,
137 `points_e` int(11) NOT NULL DEFAULT '0',
138 `points_p` int(11) NOT NULL DEFAULT '0',
139 `change_name` int(1) NOT NULL DEFAULT '0',
140 `cms_birthday` varchar(100) NOT NULL,
141 `cms_changename` enum('0','1') NOT NULL DEFAULT '0',
142 `cms_radio` enum('0','1') NOT NULL DEFAULT '1',
143 `cms_refers` int(10) NOT NULL DEFAULT '0',
144 `cms_pbackground` varchar(200) NOT NULL DEFAULT 'http://img4.cdn1.habbo.com/c_images/backgrounds2/bg_pattern_abstract2.gif',
145 `cms_pprofile` varchar(200) NOT NULL DEFAULT '/gallery/images/dftl_perfil.png',
146 `cms_twitter` varchar(100) NOT NULL,
147 `cms_staffocult` enum('0','1') NOT NULL DEFAULT '0',
148 `cms_style` enum('default','gold','note','girl','block','speech','silver','hc') NOT NULL DEFAULT 'default',
149 `cms_video` varchar(50) NOT NULL,
150 `cms_pin` varchar(10) NOT NULL,
151 `cms_role` varchar(50) NOT NULL,
152 `hubbotarefa` varchar(500) NOT NULL DEFAULT 'Realizar os eventos diários e dar suporte aos jogadores.',
153 PRIMARY KEY (`id`),
154 UNIQUE KEY `id` (`id`)
155) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
156
157--
158-- Extraindo dados da tabela `users`
159--
160
161INSERT INTO `users` (`id`, `user_id`, `username`, `real_name`, `password`, `auth_ticket`, `working`, `mymusik`, `secretcode`, `rank`, `vip_points`, `credits`, `activity_points`, `activity_points_lastupdate`, `diamonds`, `look`, `gender`, `motto`, `mail`, `account_created`, `last_online`, `online`, `ip_last`, `ip_reg`, `home_room`, `newbie_status`, `is_muted`, `mutant_penalty`, `mutant_penalty_expire`, `trade_lock`, `trade_lock_expire`, `block_newfriends`, `hide_online`, `hide_inroom`, `vip`, `vip_expire`, `birth`, `talent_status`, `mysterybox_key_colour`, `last_name_change`, `client_volume`, `nux_passed`, `seckey`, `voted`, `owner`, `novato`, `fundom`, `builders_expire`, `builders_items_max`, `builders_items_used`, `release_version`, `on_duty`, `OnDuty`, `DutyLevel`, `navilogs`, `navigator`, `respect`, `allow_pull`, `cms_currency`, `seashells`, `trusted`, `age`, `role`, `country`, `rank_vip`, `volume`, `last_change`, `machine_id`, `focus_preference`, `chat_preference`, `pets_muted`, `bots_muted`, `advertising_report_blocked`, `gotw_points`, `ignore_invites`, `time_muted`, `allow_gifts`, `trading_locked`, `friend_bar_state`, `disable_forced_effects`, `allow_mimic`, `votos`, `pin`, `photo_perfil`, `portada`, `seasonal_currency`, `refer_points`, `refer_count`, `last_used`, `facebook_change`, `loyalty_points`, `staff_twitter`, `staff_facebook`, `forgot_ticket`, `facebook_id`, `facebook`, `staff_background_url`, `staff_ocult`, `country_cf`, `staff_profileimage_url`, `belcredits`, `radio`, `cookies`, `facebook_vin`, `homework`, `RequireChangenameForFacebook`, `birthday`, `color`, `points_e`, `points_p`, `change_name`, `cms_birthday`, `cms_changename`, `cms_radio`, `cms_refers`, `cms_pbackground`, `cms_pprofile`, `cms_twitter`, `cms_staffocult`, `cms_style`, `cms_video`, `cms_pin`, `cms_role`, `hubbotarefa`) VALUES
162(2, NULL, 'mathx', '', 'afbcedd38b6a8bb04d5669fd01b401cb', '', '', '', '', 9, 0, 35000, 3500, 0, 0, 'ha-1022-110.hd-180-10.wa-2002-62.lg-3257-110.cp-3126-62.sh-3035-110.ch-210-110.ea-3141-62-', 'M', 'welcome to new world! <3', 'nadius@gmail.com', 1475378733, 1475378733, '0', '::1', '::1', 0, 0, '0', '0', 0, '0', 0, '0', '0', '0', '0', '2014-05-13 18:58:48', '111993', 'citizenship', 0, 0, '100,100,100', '0', '', 0, 0, 0, '#43AC6A', 3700, 100, 0, 2, '0', 'false', 0, '1,official-root,;2,popular,;3,my,;4,favorites,', '0', 0, '0', '', 0, 0, '', '', 'Unknown', 3, '100,100,100', 0, 'f51560b40328a0a3a84a4e69926748b2', '0', '0', '0', '0', '0', 0, '0', 0, '1', 0, '1', '0', '1', NULL, NULL, '', NULL, 40, '0', '0', '0', '0', 0, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'ec', '0', 30, '1', 60, '0', '', '0', NULL, '', 0, 0, 0, '', '0', '1', 0, 'http://img4.cdn1.habbo.com/c_images/backgrounds2/bg_pattern_abstract2.gif', '/gallery/images/dftl_perfil.png', '', '0', 'default', '', '', '', 'Responsável pela administração geral do Hubbo. '),
163(3, NULL, 'Kauan', 'default', '08b281ce30e7703f6adb2420117a8bb9', '-/-', '', '', '', 9, 0, 35000, 3500, 0, 0, 'sh-3016-96.fa-1202-96.ch-3032-81-92.hd-190-10.lg-275-82.hr-830-61.wa-3264-81-82.ha-8485441-62', 'M', 'Qual seu pensamento de hoje?', 'kauan@hubbohotel.biz', 1482425844, 1482425844, '1', '127.0.0.1', '127.0.0.1', 0, 0, '0', '0', 0, '0', 0, '0', '0', '0', '0', '2014-05-13 18:58:48', '', 'citizenship', 0, 0, '100,100,100', '0', '', 0, 0, 0, '#43AC6A', 3700, 100, 0, 2, '0', 'false', 0, '1,official-root,;2,popular,;3,my,;4,favorites,', '0', 0, '0', '', 0, 0, '', '', 'Unknown', 3, '100,100,100', 0, NULL, '0', '0', '0', '0', '0', 0, '0', 0, '1', 0, '1', '0', '1', NULL, NULL, '', NULL, 40, '0', '0', '0', '0', 0, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'ec', '0', 30, '1', 60, '0', '', '0', NULL, '', 0, 0, 0, '', '0', '1', 0, 'http://img4.cdn1.habbo.com/c_images/backgrounds2/bg_pattern_abstract2.gif', '/gallery/images/dftl_perfil.png', '', '0', 'default', '', '', '', 'Responsável pela parte técnica do Hubbo. ');