· 9 years ago · Dec 16, 2016, 05:54 PM
1-- phpMyAdmin SQL Dump
2-- version 3.5.8.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Dec 17, 2016 at 02:03 AM
7-- Server version: 5.1.73
8-- PHP Version: 5.3.3
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `sarah2016`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `char`
27--
28
29CREATE TABLE IF NOT EXISTS `char` (
30 `char_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
31 `account_id` int(11) unsigned NOT NULL DEFAULT '0',
32 `char_num` tinyint(1) NOT NULL DEFAULT '0',
33 `name` varchar(30) NOT NULL DEFAULT '',
34 `class` smallint(6) unsigned NOT NULL DEFAULT '0',
35 `base_level` smallint(6) unsigned NOT NULL DEFAULT '1',
36 `job_level` smallint(6) unsigned NOT NULL DEFAULT '1',
37 `base_exp` bigint(20) unsigned NOT NULL DEFAULT '0',
38 `job_exp` bigint(20) unsigned NOT NULL DEFAULT '0',
39 `zeny` int(11) unsigned NOT NULL DEFAULT '0',
40 `str` smallint(4) unsigned NOT NULL DEFAULT '0',
41 `agi` smallint(4) unsigned NOT NULL DEFAULT '0',
42 `vit` smallint(4) unsigned NOT NULL DEFAULT '0',
43 `int` smallint(4) unsigned NOT NULL DEFAULT '0',
44 `dex` smallint(4) unsigned NOT NULL DEFAULT '0',
45 `luk` smallint(4) unsigned NOT NULL DEFAULT '0',
46 `max_hp` mediumint(8) unsigned NOT NULL DEFAULT '0',
47 `hp` mediumint(8) unsigned NOT NULL DEFAULT '0',
48 `max_sp` mediumint(6) unsigned NOT NULL DEFAULT '0',
49 `sp` mediumint(6) unsigned NOT NULL DEFAULT '0',
50 `status_point` int(11) unsigned NOT NULL DEFAULT '0',
51 `skill_point` int(11) unsigned NOT NULL DEFAULT '0',
52 `option` int(11) NOT NULL DEFAULT '0',
53 `karma` tinyint(3) NOT NULL DEFAULT '0',
54 `manner` smallint(6) NOT NULL DEFAULT '0',
55 `party_id` int(11) unsigned NOT NULL DEFAULT '0',
56 `guild_id` int(11) unsigned NOT NULL DEFAULT '0',
57 `pet_id` int(11) unsigned NOT NULL DEFAULT '0',
58 `homun_id` int(11) unsigned NOT NULL DEFAULT '0',
59 `elemental_id` int(11) unsigned NOT NULL DEFAULT '0',
60 `faction_id` int(11) NOT NULL DEFAULT '0',
61 `hair` tinyint(4) unsigned NOT NULL DEFAULT '0',
62 `hair_color` smallint(5) unsigned NOT NULL DEFAULT '0',
63 `clothes_color` smallint(5) unsigned NOT NULL DEFAULT '0',
64 `weapon` smallint(6) unsigned NOT NULL DEFAULT '0',
65 `shield` smallint(6) unsigned NOT NULL DEFAULT '0',
66 `head_top` smallint(6) unsigned NOT NULL DEFAULT '0',
67 `head_mid` smallint(6) unsigned NOT NULL DEFAULT '0',
68 `head_bottom` smallint(6) unsigned NOT NULL DEFAULT '0',
69 `robe` smallint(6) unsigned NOT NULL DEFAULT '0',
70 `last_map` varchar(11) NOT NULL DEFAULT '',
71 `last_x` smallint(4) unsigned NOT NULL DEFAULT '53',
72 `last_y` smallint(4) unsigned NOT NULL DEFAULT '111',
73 `save_map` varchar(11) NOT NULL DEFAULT '',
74 `save_x` smallint(4) unsigned NOT NULL DEFAULT '53',
75 `save_y` smallint(4) unsigned NOT NULL DEFAULT '111',
76 `partner_id` int(11) unsigned NOT NULL DEFAULT '0',
77 `online` tinyint(2) NOT NULL DEFAULT '0',
78 `father` int(11) unsigned NOT NULL DEFAULT '0',
79 `mother` int(11) unsigned NOT NULL DEFAULT '0',
80 `child` int(11) unsigned NOT NULL DEFAULT '0',
81 `fame` int(11) unsigned NOT NULL DEFAULT '0',
82 `rename` smallint(3) unsigned NOT NULL DEFAULT '0',
83 `delete_date` int(11) unsigned NOT NULL DEFAULT '0',
84 `moves` int(11) unsigned NOT NULL DEFAULT '0',
85 `unban_time` int(11) unsigned NOT NULL DEFAULT '0',
86 `playtime` bigint(20) unsigned NOT NULL DEFAULT '0',
87 `bg_gold` int(11) NOT NULL DEFAULT '0',
88 `bg_silver` int(11) NOT NULL DEFAULT '0',
89 `bg_bronze` int(11) NOT NULL DEFAULT '0',
90 PRIMARY KEY (`char_id`),
91 UNIQUE KEY `name_key` (`name`),
92 KEY `account_id` (`account_id`),
93 KEY `party_id` (`party_id`),
94 KEY `guild_id` (`guild_id`),
95 KEY `online` (`online`)
96) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=339928 ;
97
98--
99-- Dumping data for table `char`
100--
101
102INSERT INTO `char` (`name`) VALUES
103('(A S U N A)'),
104('* Aqua *'),
105('* m A r U *'),
106('*AlphA*'),
107('*Harmonizer'),
108('*JEK PRIME*'),
109('*PutA*PetE*'),
110('+Madara+'),
111('+NIGHTMARE +'),
112('20th Wonder'),
113('a I y'),
114('Anya Stark'),
115('arbil III'),
116('asdfasdf'),
117('AttyTheVirgin'),
118('Axcalo'),
119('Ayaka Shindou'),
120('bailarinYani'),
121('BebeGerl'),
122('Bishoujo'),
123('Blitz*'),
124('BossDRE'),
125('BPI BANK'),
126('C h e n'),
127('Champagne_Supernova_v3'),
128('chanee'),
129('Chartreux'),
130('ChingChangSung'),
131('CorneliaBlight'),
132('Crimson Fatalis G'),
133('Ctrl^Alt^Delete'),
134('CuteNovie'),
135('Dennyy'),
136('Doctor_Strange'),
137('DonBoDict'),
138('Double Black'),
139('Dragon Wind'),
140('Emilio Barzini'),
141('Erzteufel'),
142('eSforger'),
143('Fem Fem'),
144('fghjk'),
145('Flareon'),
146('Flightclub'),
147('Flying Monk'),
148('friedice'),
149('FS Jammo'),
150('FS_pugak'),
151('Garcie21'),
152('Gets24'),
153('GK The Great'),
154('Global Risk'),
155('God Arrow'),
156('GotToBelieveInMagic'),
157('Greed D Kid'),
158('HughJazz'),
159('iloilo supermart'),
160('iPunchUDie'),
161('J h a'),
162('Jek Source'),
163('Jha_05'),
164('Jhenaya Hailey'),
165('Jitan_Heartnet'),
166('Jose Raymundo Avelino'),
167('Juan CassidyY'),
168('k aL eL'),
169('K e n j i'),
170('Karmilitos'),
171('kkrrr'),
172('Kuro Merou'),
173('L0RD MADARA'),
174('Lady Anica'),
175('Lady Ceres'),
176('Last Hit'),
177('Liar'),
178('Liar Babe'),
179('LimitBreaker Lomiii'),
180('ll e a h ll'),
181('lLordOflLight'),
182('Lunatic Sky'),
183('M a l d i t h a'),
184('Malivouge'),
185('Master zeUz'),
186('MatSuki'),
187('MayPuhunan'),
188('Mesha'),
189('Miyu Dee'),
190('Miyu Vee'),
191('Moldie'),
192('Monay23'),
193('Monk ni Fierra'),
194('MonMamon'),
195('Murcielago'),
196('MVP WoOp'),
197('Nephesh'),
198('Nyxia'),
199('oO AlphA Oo'),
200('Panget ka rin'),
201('Patriotic'),
202('Peekachu'),
203('Philip Tattaglia'),
204('Power Amplifier'),
205('PrettyReckless'),
206('qtJane'),
207('R a i v i u s'),
208('r E n i L'),
209('Raiblitz'),
210('Raichuu'),
211('Riko Tachibana'),
212('Royal Bank Of Canada'),
213('S m a s h'),
214('saharic'),
215('Sanchay'),
216('Sense'),
217('Shenron'),
218('Shit Got Real'),
219('SteelForge'),
220('Success!'),
221('Super Migi'),
222('tagabenta99'),
223('theanswer'),
224('TipsyToe'),
225('TurnUndied'),
226('Vaffy'),
227('Vankaii'),
228('Versifier'),
229('WASAR'),
230('WizVany'),
231('Xernyyy'),
232('xharryx'),
233('Xirq'),
234('Yliah'),
235('z e U z x'),
236('Z z Z z'),
237('ZZZZZZZZZZZZZZZZZZZZZZZ');
238
239/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
240/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
241/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;