· 8 years ago · Mar 10, 2018, 03:46 AM
1### Eclipse Workspace Patch 1.0
2#P L2jFrozen_DataPack
3Index: sql/custom_notspawned.sql
4===================================================================
5--- sql/custom_notspawned.sql (revisión: 140)
6+++ sql/custom_notspawned.sql (copia de trabajo)
7@@ -1,5 +1,5 @@
8 CREATE TABLE IF NOT EXISTS `custom_notspawned` (
9 `id` int(11) NOT NULL,
10- `isCustom` int(1) NOT NULL,
11+ `isCustom` tinyint(1) NOT NULL,
12 PRIMARY KEY (`id`)
13 ) DEFAULT CHARSET=utf8;
14\ No newline at end of file
15Index: sql/topic.sql
16===================================================================
17--- sql/topic.sql (revisión: 140)
18+++ sql/topic.sql (copia de trabajo)
19@@ -5,7 +5,7 @@
20 `topic_id` int(8) NOT NULL default '0',
21 `topic_forum_id` int(8) NOT NULL default '0',
22 `topic_name` varchar(255) NOT NULL default '',
23- `topic_date` decimal(20,0) NOT NULL default '0',
24+ `topic_date` bigint(20) NOT NULL default '0',
25 `topic_ownername` varchar(255) NOT NULL default '0',
26 `topic_ownerid` int(8) NOT NULL default '0',
27 `topic_type` int(8) NOT NULL default '0',
28Index: sql/character_skills.sql
29===================================================================
30--- sql/character_skills.sql (revisión: 140)
31+++ sql/character_skills.sql (copia de trabajo)
32@@ -6,6 +6,6 @@
33 skill_id INT NOT NULL default 0,
34 skill_level varchar(5) ,
35 skill_name varchar(40),
36- `class_index` INT(1) NOT NULL DEFAULT 0,
37+ `class_index` tinyint(1) NOT NULL DEFAULT 0,
38 PRIMARY KEY (char_obj_id,skill_id,`class_index`)
39 ) DEFAULT CHARSET=utf8;
40Index: sql/henna_trees.sql
41===================================================================
42--- sql/henna_trees.sql (revisión: 140)
43+++ sql/henna_trees.sql (copia de trabajo)
44@@ -3,8 +3,8 @@
45 --
46 DROP TABLE IF EXISTS henna_trees;
47 CREATE TABLE `henna_trees` (
48- `class_id` decimal(10,0) NOT NULL default 0,
49- `symbol_id` decimal(10,0) NOT NULL default 0,
50+ `class_id` int(10) NOT NULL default 0,
51+ `symbol_id` int(10) NOT NULL default 0,
52 PRIMARY KEY (`class_id`,`symbol_id`)
53 ) DEFAULT CHARSET=utf8;
54
55Index: sql/hitman_list.sql
56===================================================================
57--- sql/hitman_list.sql (revisión: 140)
58+++ sql/hitman_list.sql (copia de trabajo)
59@@ -3,10 +3,10 @@
60 -- ----------------------------
61 DROP TABLE IF EXISTS `hitman_list`;
62 CREATE TABLE `hitman_list` (
63- `targetId` int(16) NOT NULL DEFAULT '0',
64- `clientId` int(16) NOT NULL DEFAULT '0',
65+ `targetId` int(11) NOT NULL DEFAULT '0',
66+ `clientId` int(11) NOT NULL DEFAULT '0',
67 `target_name` varchar(24) NOT NULL DEFAULT '',
68- `bounty` int(30) NOT NULL DEFAULT '0',
69- `pending_delete` int(16) NOT NULL DEFAULT '0',
70+ `bounty` int(11) NOT NULL DEFAULT '0',
71+ `pending_delete` bigint(16) NOT NULL DEFAULT '0',
72 PRIMARY KEY (`targetId`)
73 ) DEFAULT CHARSET=utf8;
74Index: sql/character_quests.sql
75===================================================================
76--- sql/character_quests.sql (revisión: 140)
77+++ sql/character_quests.sql (copia de trabajo)
78@@ -6,6 +6,6 @@
79 `name` VARCHAR(40) NOT NULL DEFAULT '',
80 `var` VARCHAR(20) NOT NULL DEFAULT '',
81 `value` VARCHAR(255) ,
82- `class_index` int(1) NOT NULL default '0',
83+ `class_index` tinyint(1) NOT NULL default '0',
84 PRIMARY KEY (`char_id`,`name`,`var`,`class_index`)
85 ) DEFAULT CHARSET=utf8;
86Index: sql/grandboss_data.sql
87===================================================================
88--- sql/grandboss_data.sql (revisión: 140)
89+++ sql/grandboss_data.sql (copia de trabajo)
90@@ -9,8 +9,8 @@
91 `loc_z` int(11) NOT NULL DEFAULT '0',
92 `heading` int(11) NOT NULL DEFAULT '0',
93 `respawn_time` bigint(20) NOT NULL DEFAULT '0',
94- `currentHP` decimal(8,0) DEFAULT NULL,
95- `currentMP` decimal(8,0) DEFAULT NULL,
96+ `currentHP` int(8) DEFAULT NULL,
97+ `currentMP` int(8) DEFAULT NULL,
98 `status` tinyint(4) NOT NULL DEFAULT '0',
99 PRIMARY KEY (`boss_id`)
100 ) DEFAULT CHARSET=utf8;
101Index: sql/character_skills_save.sql
102===================================================================
103--- sql/character_skills_save.sql (revisión: 140)
104+++ sql/character_skills_save.sql (copia de trabajo)
105@@ -9,8 +9,8 @@
106 effect_cur_time INT NOT NULL default 0,
107 reuse_delay INT(8) NOT NULL DEFAULT 0,
108 `systime` BIGINT UNSIGNED NOT NULL DEFAULT 0,
109- restore_type INT(1) NOT NULL DEFAULT 0,
110- `class_index` INT(1) NOT NULL DEFAULT 0,
111- buff_index INT(2) NOT NULL default 0,
112+ restore_type tinyint(1) NOT NULL DEFAULT 0,
113+ `class_index` tinyint(1) NOT NULL DEFAULT 0,
114+ buff_index tinyint(2) NOT NULL default 0,
115 PRIMARY KEY (char_obj_id,skill_id,`class_index`)
116 ) DEFAULT CHARSET=utf8;
117\ No newline at end of file
118Index: sql/enchant_skill_trees.sql
119===================================================================
120--- sql/enchant_skill_trees.sql (revisión: 140)
121+++ sql/enchant_skill_trees.sql (copia de trabajo)
122@@ -6,7 +6,7 @@
123 `base_lvl` int(2) NOT NULL DEFAULT '0',
124 `enchant_type` varchar(25) DEFAULT NULL,
125 `sp` int(10) NOT NULL DEFAULT '0',
126- `exp` int(20) DEFAULT NULL,
127+ `exp` bigint(20) DEFAULT NULL,
128 `min_skill_lvl` int(2) NOT NULL DEFAULT '0',
129 `success_rate76` int(3) unsigned NOT NULL DEFAULT '0',
130 `success_rate77` int(3) NOT NULL DEFAULT '0',
131Index: sql/custom_spawnlist.sql
132===================================================================
133--- sql/custom_spawnlist.sql (revisión: 140)
134+++ sql/custom_spawnlist.sql (copia de trabajo)
135@@ -15,7 +15,7 @@
136 `heading` int(9) NOT NULL DEFAULT '0',
137 `respawn_delay` int(9) NOT NULL DEFAULT '0',
138 `loc_id` int(9) NOT NULL DEFAULT '0',
139- `periodOfDay` decimal(2,0) DEFAULT '0',
140+ `periodOfDay` tinyint(2) DEFAULT '0',
141 PRIMARY KEY (`id`),
142 KEY `key_npc_templateid` (`npc_templateid`)
143 ) DEFAULT CHARSET=utf8;
144Index: sql/clan_data.sql
145===================================================================
146--- sql/clan_data.sql (revisión: 140)
147+++ sql/clan_data.sql (copia de trabajo)
148@@ -14,10 +14,10 @@
149 crest_large_id INT,
150 ally_crest_id INT,
151 auction_bid_at INT NOT NULL default 0,
152- ally_penalty_expiry_time DECIMAL( 20,0 ) NOT NULL DEFAULT 0,
153- ally_penalty_type DECIMAL( 1 ) NOT NULL DEFAULT 0,
154- char_penalty_expiry_time DECIMAL( 20,0 ) NOT NULL DEFAULT 0,
155- dissolving_expiry_time DECIMAL( 20,0 ) NOT NULL DEFAULT 0,
156+ ally_penalty_expiry_time bigint(20) NOT NULL DEFAULT 0,
157+ ally_penalty_type tinyint(1) NOT NULL DEFAULT 0,
158+ char_penalty_expiry_time bigint(20) NOT NULL DEFAULT 0,
159+ dissolving_expiry_time bigint(20) NOT NULL DEFAULT 0,
160 PRIMARY KEY (clan_id),
161 KEY `leader_id` (`leader_id`),
162 KEY `ally_id` (`ally_id`)
163Index: sql/merchant_buylists.sql
164===================================================================
165--- sql/merchant_buylists.sql (revisión: 140)
166+++ sql/merchant_buylists.sql (copia de trabajo)
167@@ -3,14 +3,14 @@
168 --
169 DROP TABLE IF EXISTS merchant_buylists;
170 CREATE TABLE merchant_buylists (
171- item_id decimal(9,0) NOT NULL default '0',
172- price decimal(11,0) NOT NULL default '0',
173- shop_id decimal(9,0) NOT NULL default '0',
174- `order` decimal(4,0) NOT NULL default '0',
175- `count` INT( 11 ) NOT NULL DEFAULT '-1',
176- `currentCount` INT( 11 ) NOT NULL DEFAULT '-1',
177- time INT NOT NULL DEFAULT '0',
178- savetimer DECIMAL(20,0) NOT NULL DEFAULT '0',
179+ item_id int(11) NOT NULL default '0',
180+ price int(11) NOT NULL default '0',
181+ shop_id int(9) NOT NULL default '0',
182+ `order` int(4) NOT NULL default '0',
183+ `count` int(11) NOT NULL DEFAULT '-1',
184+ `currentCount` int(11) NOT NULL DEFAULT '-1',
185+ `time` int(11) NOT NULL DEFAULT '0',
186+ savetimer bigint(20) NOT NULL DEFAULT '0',
187 PRIMARY KEY (shop_id,`order`)
188 ) DEFAULT CHARSET=utf8;
189
190Index: sql/clanhall_functions.sql
191===================================================================
192--- sql/clanhall_functions.sql (revisión: 140)
193+++ sql/clanhall_functions.sql (copia de trabajo)
194@@ -2,11 +2,11 @@
195 -- Table structure for `clanhall_functions`
196 -- ---------------------------
197 CREATE TABLE IF NOT EXISTS `clanhall_functions` (
198- `hall_id` int(2) NOT NULL default '0',
199- `type` int(1) NOT NULL default '0',
200+ `hall_id` tinyint(2) NOT NULL default '0',
201+ `type` tinyint(1) NOT NULL default '0',
202 `lvl` int(3) NOT NULL default '0',
203 `lease` int(10) NOT NULL default '0',
204- `rate` decimal(20,0) NOT NULL default '0',
205- `endTime` decimal(20,0) NOT NULL default '0',
206+ `rate` bigint(20) NOT NULL default '0',
207+ `endTime` bigint(20) NOT NULL default '0',
208 PRIMARY KEY (`hall_id`,`type`)
209 ) DEFAULT CHARSET=utf8;
210Index: sql/character_offline_trade.sql
211===================================================================
212--- sql/character_offline_trade.sql (revisión: 140)
213+++ sql/character_offline_trade.sql (copia de trabajo)
214@@ -2,7 +2,7 @@
215 CREATE TABLE `character_offline_trade` (
216 `charId` int(11) NOT NULL,
217 `time` bigint(20) unsigned NOT NULL DEFAULT '0',
218- `type` tinyint(4) NOT NULL DEFAULT '0',
219+ `type` int(4) NOT NULL DEFAULT '0',
220 `title` varchar(100) DEFAULT NULL,
221 PRIMARY KEY (`charId`)
222 ) DEFAULT CHARSET=utf8;
223@@ -9,9 +9,9 @@
224
225 DROP TABLE IF EXISTS `character_offline_trade_items`;
226 CREATE TABLE `character_offline_trade_items` (
227- `charId` int(10) NOT NULL DEFAULT '0',
228- `item` int(10) NOT NULL DEFAULT '0',
229- `count` int(20) NOT NULL DEFAULT '0',
230- `price` int(20) NOT NULL DEFAULT '0',
231- `enchant` int(20) NOT NULL DEFAULT '0'
232+ `charId` int(11) NOT NULL DEFAULT '0',
233+ `item` int(11) NOT NULL DEFAULT '0',
234+ `count` int(11) NOT NULL DEFAULT '0',
235+ `price` int(11) NOT NULL DEFAULT '0',
236+ `enchant` int(11) NOT NULL DEFAULT '0'
237 ) DEFAULT CHARSET=utf8;
238Index: sql/olympiad_nobles.sql
239===================================================================
240--- sql/olympiad_nobles.sql (revisión: 140)
241+++ sql/olympiad_nobles.sql (copia de trabajo)
242@@ -1,23 +1,23 @@
243 CREATE TABLE IF NOT EXISTS `olympiad_nobles` (
244- `charId` decimal(11,0) NOT NULL default '0',
245- `class_id` decimal(3,0) NOT NULL default '0',
246+ `charId` int(11) NOT NULL default '0',
247+ `class_id` int(3) NOT NULL default '0',
248 `char_name` varchar(45) NOT NULL default '',
249- `olympiad_points` decimal(10,0) NOT NULL default '0',
250- `competitions_done` decimal(3,0) NOT NULL default '0',
251- `competitions_won` decimal(3,0) NOT NULL default '0',
252- `competitions_lost` decimal(3,0) NOT NULL default '0',
253- `competitions_drawn` decimal(3,0) NOT NULL default '0',
254+ `olympiad_points` int(10) NOT NULL default '0',
255+ `competitions_done` int(3) NOT NULL default '0',
256+ `competitions_won` int(3) NOT NULL default '0',
257+ `competitions_lost` int(3) NOT NULL default '0',
258+ `competitions_drawn` int(3) NOT NULL default '0',
259 PRIMARY KEY (`charId`)
260 ) DEFAULT CHARSET=utf8;
261
262 CREATE TABLE IF NOT EXISTS `olympiad_nobles_eom` (
263- `charId` decimal(11,0) NOT NULL default '0',
264- `class_id` decimal(3,0) NOT NULL default '0',
265+ `charId` int(11) NOT NULL default '0',
266+ `class_id` int(3) NOT NULL default '0',
267 `char_name` varchar(45) NOT NULL default '',
268- `olympiad_points` decimal(10,0) NOT NULL default '0',
269- `competitions_done` decimal(3,0) NOT NULL default '0',
270- `competitions_won` decimal(3,0) NOT NULL default '0',
271- `competitions_lost` decimal(3,0) NOT NULL default '0',
272- `competitions_drawn` decimal(3,0) NOT NULL default '0',
273+ `olympiad_points` int(10) NOT NULL default '0',
274+ `competitions_done` int(3) NOT NULL default '0',
275+ `competitions_won` int(3) NOT NULL default '0',
276+ `competitions_lost` int(3) NOT NULL default '0',
277+ `competitions_drawn` int(3) NOT NULL default '0',
278 PRIMARY KEY (`charId`)
279 ) DEFAULT CHARSET=utf8;
280\ No newline at end of file
281Index: sql/boxes.sql
282===================================================================
283--- sql/boxes.sql (revisión: 140)
284+++ sql/boxes.sql (copia de trabajo)
285@@ -3,12 +3,12 @@
286 --
287 CREATE TABLE IF NOT EXISTS boxes (
288 id int(11) NOT NULL auto_increment,
289- spawn decimal(11,0) default NULL,
290- npcid decimal(11,0) default NULL,
291+ spawn int(11) default NULL,
292+ npcid int(11) default NULL,
293 drawer varchar(32) default NULL,
294- itemid decimal(11,0) default NULL,
295+ itemid int(11) default NULL,
296 name varchar(32) default '',
297- count decimal(11,0) default NULL,
298- enchant decimal(2,0) default NULL,
299+ count int(11) default NULL,
300+ enchant tinyint(2) default NULL,
301 PRIMARY KEY (id)
302 ) DEFAULT CHARSET=utf8;
303\ No newline at end of file
304Index: sql/character_raid_points.sql
305===================================================================
306--- sql/character_raid_points.sql (revisión: 140)
307+++ sql/character_raid_points.sql (copia de trabajo)
308@@ -1,6 +1,6 @@
309 CREATE TABLE IF NOT EXISTS `character_raid_points` (
310- `charId` INT UNSIGNED NOT NULL DEFAULT 0,
311- `boss_id` INT UNSIGNED NOT NULL DEFAULT 0,
312- `points` INT UNSIGNED NOT NULL DEFAULT 0,
313+ `charId` int(11) NOT NULL DEFAULT 0,
314+ `boss_id` int(11) NOT NULL DEFAULT 0,
315+ `points` int(11) NOT NULL DEFAULT 0,
316 PRIMARY KEY (`charId`,`boss_id`)
317 ) DEFAULT CHARSET=utf8;
318\ No newline at end of file
319Index: sql/clan_wars.sql
320===================================================================
321--- sql/clan_wars.sql (revisión: 140)
322+++ sql/clan_wars.sql (copia de trabajo)
323@@ -1,9 +1,9 @@
324---
325--- Table structure for `clan_wars`
326---
327+--
328+-- Table structure for `clan_wars`
329+--
330 CREATE TABLE IF NOT EXISTS `clan_wars` (
331 `clan1` varchar(35) NOT NULL default '',
332 `clan2` varchar(35) NOT NULL default '',
333- `wantspeace1` decimal(1,0) NOT NULL default '0',
334- `wantspeace2` decimal(1,0) NOT NULL default '0'
335+ `wantspeace1` tinyint(1) NOT NULL default '0',
336+ `wantspeace2` tinyint(1) NOT NULL default '0'
337 ) DEFAULT CHARSET=utf8;
338\ No newline at end of file
339Index: sql/boxaccess.sql
340===================================================================
341--- sql/boxaccess.sql (revisión: 140)
342+++ sql/boxaccess.sql (copia de trabajo)
343@@ -2,6 +2,6 @@
344 -- Table structure for table `boxaccess`
345 --
346 CREATE TABLE IF NOT EXISTS boxaccess (
347- spawn decimal(11,0) default NULL,
348+ spawn int(11) default NULL,
349 charname varchar(32) default NULL
350 ) DEFAULT CHARSET=utf8;
351\ No newline at end of file
352Index: sql/character_recipebook.sql
353===================================================================
354--- sql/character_recipebook.sql (revisión: 140)
355+++ sql/character_recipebook.sql (copia de trabajo)
356@@ -2,8 +2,8 @@
357 -- Table structure for character_recipebook
358 -- ---------------------------
359 CREATE TABLE IF NOT EXISTS character_recipebook (
360- char_id decimal(11) NOT NULL default 0,
361- id decimal(11) NOT NULL default 0,
362- type INT NOT NULL default 0,
363+ char_id int(11) NOT NULL default 0,
364+ id int(11) NOT NULL default 0,
365+ type int NOT NULL default 0,
366 PRIMARY KEY (id,char_id)
367 ) DEFAULT CHARSET=utf8;
368\ No newline at end of file
369Index: sql/games.sql
370===================================================================
371--- sql/games.sql (revisión: 140)
372+++ sql/games.sql (copia de trabajo)
373@@ -11,8 +11,8 @@
374 prize1 INT NOT NULL default 0,
375 prize2 INT NOT NULL default 0,
376 prize3 INT NOT NULL default 0,
377- enddate decimal(20,0) NOT NULL default 0,
378+ enddate bigint(20) NOT NULL default 0,
379 finished INT NOT NULL default 0,
380- PRIMARY KEY (`id`,`idnr`)
381+ PRIMARY KEY (`id`,`idnr`)
382 ) DEFAULT CHARSET=utf8;
383
384Index: sql/auction.sql
385===================================================================
386--- sql/auction.sql (revisión: 140)
387+++ sql/auction.sql (copia de trabajo)
388@@ -13,7 +13,7 @@
389 itemQuantity int(11) NOT NULL default '0',
390 startingBid int(11) NOT NULL default '0',
391 currentBid int(11) NOT NULL default '0',
392- endDate decimal(20,0) NOT NULL default '0',
393+ endDate bigint(20) NOT NULL default '0',
394 PRIMARY KEY (`itemType`,`itemId`,`itemObjectId`),
395 KEY `id` (`id`)
396 ) DEFAULT CHARSET=utf8;
397Index: sql/custom_merchant_shopids.sql
398===================================================================
399--- sql/custom_merchant_shopids.sql (revisión: 140)
400+++ sql/custom_merchant_shopids.sql (copia de trabajo)
401@@ -3,7 +3,7 @@
402 --
403 DROP TABLE IF EXISTS custom_merchant_shopids;
404 CREATE TABLE custom_merchant_shopids (
405- shop_id decimal(9,0) NOT NULL default '0',
406+ shop_id int(9) NOT NULL default '0',
407 npc_id varchar(9) default NULL,
408 PRIMARY KEY (shop_id)
409 ) DEFAULT CHARSET=utf8;
410\ No newline at end of file
411Index: sql/pkkills.sql
412===================================================================
413--- sql/pkkills.sql (revisión: 140)
414+++ sql/pkkills.sql (copia de trabajo)
415@@ -4,6 +4,6 @@
416 CREATE TABLE IF NOT EXISTS `pkkills` (
417 `killerId` varchar(45) NOT NULL,
418 `killedId` varchar(45) NOT NULL,
419- `kills` decimal(11,0) NOT NULL,
420+ `kills` int(11) NOT NULL,
421 PRIMARY KEY (`killerId` ,`killedId` )
422 ) DEFAULT CHARSET=utf8;
423\ No newline at end of file
424Index: sql/custom_teleport.sql
425===================================================================
426--- sql/custom_teleport.sql (revisión: 140)
427+++ sql/custom_teleport.sql (copia de trabajo)
428@@ -4,12 +4,12 @@
429 DROP TABLE IF EXISTS `custom_teleport`;
430 CREATE TABLE `custom_teleport` (
431 `Description` varchar(75) DEFAULT NULL,
432- `id` decimal(11,0) NOT NULL DEFAULT '0',
433- `loc_x` decimal(9,0) DEFAULT NULL,
434- `loc_y` decimal(9,0) DEFAULT NULL,
435- `loc_z` decimal(9,0) DEFAULT NULL,
436- `price` decimal(6,0) DEFAULT NULL,
437- `fornoble` int(1) NOT NULL DEFAULT '0',
438+ `id` int(11) NOT NULL DEFAULT '0',
439+ `loc_x` int(9) DEFAULT NULL,
440+ `loc_y` int(9) DEFAULT NULL,
441+ `loc_z` int(9) DEFAULT NULL,
442+ `price` int(6) DEFAULT NULL,
443+ `fornoble` tinyint(1) NOT NULL DEFAULT '0',
444 PRIMARY KEY (`id`)
445 ) DEFAULT CHARSET=utf8;
446
447Index: sql/posts.sql
448===================================================================
449--- sql/posts.sql (revisión: 140)
450+++ sql/posts.sql (copia de trabajo)
451@@ -5,7 +5,7 @@
452 `post_id` int(8) NOT NULL default '0',
453 `post_owner_name` varchar(255) NOT NULL default '',
454 `post_ownerid` int(8) NOT NULL default '0',
455- `post_date` decimal(20,0) NOT NULL default '0',
456+ `post_date` bigint(20) NOT NULL default '0',
457 `post_topic_id` int(8) NOT NULL default '0',
458 `post_forum_id` int(8) NOT NULL default '0',
459 `post_txt` text NOT NULL
460Index: sql/auction_bid.sql
461===================================================================
462--- sql/auction_bid.sql (revisión: 140)
463+++ sql/auction_bid.sql (copia de trabajo)
464@@ -8,7 +8,7 @@
465 bidderName varchar(50) NOT NULL,
466 clan_name varchar(50) NOT NULL,
467 maxBid int(11) NOT NULL default 0,
468- time_bid decimal(20,0) NOT NULL default '0',
469+ time_bid bigint(20) NOT NULL default '0',
470 PRIMARY KEY (auctionId, bidderId),
471 KEY id (id)
472 ) DEFAULT CHARSET=utf8;
473Index: sql/castle.sql
474===================================================================
475--- sql/castle.sql (revisión: 140)
476+++ sql/castle.sql (copia de trabajo)
477@@ -6,7 +6,7 @@
478 name varchar(25) NOT NULL,
479 taxPercent INT NOT NULL default 15,
480 treasury INT NOT NULL default 0,
481- siegeDate DECIMAL(20,0) NOT NULL default 0,
482+ siegeDate bigint(20) NOT NULL default 0,
483 siegeDayOfWeek INT NOT NULL default 7,
484 siegeHourOfDay INT NOT NULL default 20,
485 showNpcCrest enum('true','false') NOT NULL DEFAULT 'false',
486Index: sql/itemsonground.sql
487===================================================================
488--- sql/itemsonground.sql (revisión: 140)
489+++ sql/itemsonground.sql (copia de trabajo)
490@@ -9,7 +9,7 @@
491 `x` int(11) default NULL,
492 `y` int(11) default NULL,
493 `z` int(11) default NULL,
494- `drop_time` decimal(20,0) default NULL,
495+ `drop_time` bigint(20) default NULL,
496 `equipable` int(1) default '0',
497 PRIMARY KEY (`object_id`)
498 ) DEFAULT CHARSET=utf8;
499\ No newline at end of file
500Index: sql/clan_notices.sql
501===================================================================
502--- sql/clan_notices.sql (revisión: 140)
503+++ sql/clan_notices.sql (copia de trabajo)
504@@ -3,7 +3,7 @@
505 -- ----------------------------
506 DROP TABLE IF EXISTS `clan_notices`;
507 CREATE TABLE `clan_notices` (
508- `clan_id` int(32) NOT NULL,
509+ `clan_id` int(11) NOT NULL,
510 `notice` varchar(512) NOT NULL,
511 `enabled` varchar(5) NOT NULL,
512 PRIMARY KEY (`clan_id`)
513Index: sql/fort.sql
514===================================================================
515--- sql/fort.sql (revisión: 140)
516+++ sql/fort.sql (copia de trabajo)
517@@ -4,7 +4,7 @@
518 CREATE TABLE `fort` (
519 `id` int(11) NOT NULL default '0',
520 `name` varchar(25) NOT NULL,
521- `siegeDate` decimal(20,0) NOT NULL default '0',
522+ `siegeDate` bigint(20) NOT NULL default '0',
523 `siegeDayOfWeek` int(11) NOT NULL default '7',
524 `siegeHourOfDay` int(11) NOT NULL default '20',
525 `owner` int(11) NOT NULL default '0',
526Index: sql/pets.sql
527===================================================================
528--- sql/pets.sql (revisión: 140)
529+++ sql/pets.sql (copia de trabajo)
530@@ -1,16 +1,16 @@
531 -- ---------------------------
532 -- Table structure for pets
533--- ---------------------------
534+-- ---------------------------
535 CREATE TABLE IF NOT EXISTS pets (
536- item_obj_id decimal(11) NOT NULL default 0,
537+ item_obj_id int(11) NOT NULL default 0,
538 name varchar(16) ,
539- level decimal(11) ,
540- curHp decimal(18,0) ,
541- curMp decimal(18,0) ,
542- exp decimal(20, 0) ,
543- sp decimal(11) ,
544- karma decimal(11) ,
545- pkkills decimal(11) ,
546- fed decimal(11) ,
547+ level int(11) ,
548+ curHp bigint(18) ,
549+ curMp bigint(18) ,
550+ exp bigint(20) ,
551+ sp int(11) ,
552+ karma int(11) ,
553+ pkkills int(11) ,
554+ fed int(11) ,
555 PRIMARY KEY (item_obj_id)
556 ) DEFAULT CHARSET=utf8;
557Index: sql/cursed_weapons.sql
558===================================================================
559--- sql/cursed_weapons.sql (revisión: 140)
560+++ sql/cursed_weapons.sql (copia de trabajo)
561@@ -7,6 +7,6 @@
562 `playerKarma` INT DEFAULT 0,
563 `playerPkKills` INT DEFAULT 0,
564 `nbKills` INT DEFAULT 0,
565- `endTime` DECIMAL(20,0) DEFAULT 0,
566+ `endTime` bigint(20) DEFAULT 0,
567 PRIMARY KEY (`itemId`)
568 ) DEFAULT CHARSET=utf8;
569Index: sql/mods_wedding.sql
570===================================================================
571--- sql/mods_wedding.sql (revisión: 140)
572+++ sql/mods_wedding.sql (copia de trabajo)
573@@ -7,8 +7,8 @@
574 `player1Id` int(11) NOT NULL default '0',
575 `player2Id` int(11) NOT NULL default '0',
576 `married` varchar(5) default NULL,
577- `affianceDate` decimal(20,0) default '0',
578- `weddingDate` decimal(20,0) default '0',
579+ `affianceDate` bigint(20) default '0',
580+ `weddingDate` bigint(20) default '0',
581 `coupleType` int(11) NOT NULL default '0',
582 PRIMARY KEY (`id`)
583 ) DEFAULT CHARSET=utf8;
584Index: sql/merchant_shopids.sql
585===================================================================
586--- sql/merchant_shopids.sql (revisión: 140)
587+++ sql/merchant_shopids.sql (copia de trabajo)
588@@ -3,7 +3,7 @@
589 --
590 DROP TABLE IF EXISTS merchant_shopids;
591 CREATE TABLE merchant_shopids (
592- shop_id decimal(9,0) NOT NULL default '0',
593+ shop_id int(11) NOT NULL default '0',
594 npc_id varchar(9) default NULL,
595 PRIMARY KEY (shop_id)
596 ) DEFAULT CHARSET=utf8;
597Index: sql/teleport.sql
598===================================================================
599--- sql/teleport.sql (revisión: 140)
600+++ sql/teleport.sql (copia de trabajo)
601@@ -4,12 +4,12 @@
602 DROP TABLE IF EXISTS teleport;
603 CREATE TABLE teleport (
604 Description varchar(75) default NULL,
605- id decimal(11,0) NOT NULL default '0',
606- loc_x decimal(9,0) default NULL,
607- loc_y decimal(9,0) default NULL,
608- loc_z decimal(9,0) default NULL,
609- price decimal(6,0) default NULL,
610- fornoble int(1) NOT NULL default '0',
611+ id int(11) NOT NULL default '0',
612+ loc_x int(9) default NULL,
613+ loc_y int(9) default NULL,
614+ loc_z int(9) default NULL,
615+ price int(6) default NULL,
616+ fornoble tinyint(1) NOT NULL default '0',
617 PRIMARY KEY (id)
618 ) DEFAULT CHARSET=utf8;
619
620Index: sql/custom_npc.sql
621===================================================================
622--- sql/custom_npc.sql (revisión: 143)
623+++ sql/custom_npc.sql (copia de trabajo)
624@@ -3,45 +3,45 @@
625 -- ----------------------------
626 DROP TABLE IF EXISTS `custom_npc`;
627 CREATE TABLE `custom_npc` (
628- `id` decimal(11,0) NOT NULL DEFAULT '0',
629+ `id` int(11) NOT NULL DEFAULT '0',
630 `idTemplate` int(11) NOT NULL DEFAULT '0',
631 `name` varchar(200) DEFAULT NULL,
632- `serverSideName` int(1) DEFAULT '0',
633+ `serverSideName` tinyint(1) DEFAULT '0',
634 `title` varchar(45) DEFAULT '',
635- `serverSideTitle` int(1) DEFAULT '0',
636+ `serverSideTitle` tinyint(1) DEFAULT '0',
637 `class` varchar(200) DEFAULT NULL,
638- `collision_radius` decimal(5,2) DEFAULT NULL,
639- `collision_height` decimal(5,2) DEFAULT NULL,
640- `level` decimal(2,0) DEFAULT NULL,
641+ `collision_radius` int(5) DEFAULT NULL,
642+ `collision_height` int(5) DEFAULT NULL,
643+ `level` tinyint(2) DEFAULT NULL,
644 `sex` varchar(6) DEFAULT NULL,
645 `type` varchar(20) DEFAULT NULL,
646 `attackrange` int(11) DEFAULT NULL,
647- `hp` decimal(8,0) DEFAULT NULL,
648- `mp` decimal(5,0) DEFAULT NULL,
649+ `hp` int(8) DEFAULT NULL,
650+ `mp` int(5) DEFAULT NULL,
651 `hpreg` decimal(8,2) DEFAULT NULL,
652 `mpreg` decimal(5,2) DEFAULT NULL,
653- `str` decimal(7,0) DEFAULT NULL,
654- `con` decimal(7,0) DEFAULT NULL,
655- `dex` decimal(7,0) DEFAULT NULL,
656- `int` decimal(7,0) DEFAULT NULL,
657- `wit` decimal(7,0) DEFAULT NULL,
658- `men` decimal(7,0) DEFAULT NULL,
659- `exp` decimal(9,0) DEFAULT NULL,
660- `sp` decimal(8,0) DEFAULT NULL,
661- `patk` decimal(5,0) DEFAULT NULL,
662- `pdef` decimal(5,0) DEFAULT NULL,
663- `matk` decimal(5,0) DEFAULT NULL,
664- `mdef` decimal(5,0) DEFAULT NULL,
665- `atkspd` decimal(3,0) DEFAULT NULL,
666- `aggro` decimal(6,0) DEFAULT NULL,
667- `matkspd` decimal(4,0) DEFAULT NULL,
668- `rhand` decimal(4,0) DEFAULT NULL,
669- `lhand` decimal(4,0) DEFAULT NULL,
670- `armor` decimal(1,0) DEFAULT NULL,
671- `walkspd` decimal(3,0) DEFAULT NULL,
672- `runspd` decimal(3,0) DEFAULT NULL,
673+ `str` int(7) DEFAULT NULL,
674+ `con` int(7) DEFAULT NULL,
675+ `dex` int(7) DEFAULT NULL,
676+ `int` int(7) DEFAULT NULL,
677+ `wit` int(7) DEFAULT NULL,
678+ `men` int(7) DEFAULT NULL,
679+ `exp` int(9) DEFAULT NULL,
680+ `sp` int(8) DEFAULT NULL,
681+ `patk` int(5) DEFAULT NULL,
682+ `pdef` int(5) DEFAULT NULL,
683+ `matk` int(5) DEFAULT NULL,
684+ `mdef` int(5) DEFAULT NULL,
685+ `atkspd` int(3) DEFAULT NULL,
686+ `aggro` int(6) DEFAULT NULL,
687+ `matkspd` int(4) DEFAULT NULL,
688+ `rhand` int(4) DEFAULT NULL,
689+ `lhand` int(4) DEFAULT NULL,
690+ `armor` int(1) DEFAULT NULL,
691+ `walkspd` int(3) DEFAULT NULL,
692+ `runspd` int(3) DEFAULT NULL,
693 `faction_id` varchar(40) DEFAULT NULL,
694- `faction_range` decimal(4,0) DEFAULT NULL,
695+ `faction_range` int(4) DEFAULT NULL,
696 `isUndead` int(11) DEFAULT '0',
697 `absorb_level` decimal(2,0) DEFAULT '0',
698 `absorb_type` enum('FULL_PARTY','LAST_HIT','PARTY_ONE_RANDOM') NOT NULL DEFAULT 'LAST_HIT',
699Index: sql/characters_custom_data.sql
700===================================================================
701--- sql/characters_custom_data.sql (revisión: 140)
702+++ sql/characters_custom_data.sql (copia de trabajo)
703@@ -3,12 +3,12 @@
704 -- ----------------------------
705 DROP TABLE IF EXISTS `characters_custom_data`;
706 CREATE TABLE `characters_custom_data` (
707- `obj_Id` decimal(11,0) NOT NULL DEFAULT '0',
708+ `obj_Id` int(11) NOT NULL DEFAULT '0',
709 `char_name` varchar(35) NOT NULL DEFAULT '',
710- `noble` decimal(1,0) NOT NULL DEFAULT '0',
711- `hero` decimal(1,0) NOT NULL DEFAULT '0',
712+ `noble` tinyint(1) NOT NULL DEFAULT '0',
713+ `hero` tinyint(1) NOT NULL DEFAULT '0',
714 `hero_end_date` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Use "-1" to infinte hero',
715- `donator` decimal(1,0) NOT NULL DEFAULT '0',
716+ `donator` tinyint(1) NOT NULL DEFAULT '0',
717 `donator_end_date` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Use "-1" to infinite donator status',
718 PRIMARY KEY (`obj_Id`)
719 ) DEFAULT CHARSET=utf8;
720Index: sql/seven_signs.sql
721===================================================================
722--- sql/seven_signs.sql (revisión: 140)
723+++ sql/seven_signs.sql (copia de trabajo)
724@@ -5,7 +5,7 @@
725 `red_stones` INT NOT NULL default '0',
726 `green_stones` INT NOT NULL default '0',
727 `blue_stones` INT NOT NULL default '0',
728- `ancient_adena_amount` DECIMAL(20,0) NOT NULL default '0',
729- `contribution_score` DECIMAL(20,0) NOT NULL default '0',
730+ `ancient_adena_amount` bigint(20) NOT NULL default '0',
731+ `contribution_score` bigint(20) NOT NULL default '0',
732 PRIMARY KEY (`char_obj_id`)
733 ) DEFAULT CHARSET=utf8;
734Index: sql/vanhalter_spawnlist.sql
735===================================================================
736--- sql/vanhalter_spawnlist.sql (revisión: 140)
737+++ sql/vanhalter_spawnlist.sql (copia de trabajo)
738@@ -12,7 +12,7 @@
739 `heading` INT(9) NOT NULL DEFAULT 0,
740 `respawn_delay` INT(9) NOT NULL DEFAULT 0,
741 `loc_id` INT(9) NOT NULL DEFAULT 0,
742- `periodOfDay` DECIMAL(2,0) DEFAULT 0,
743+ `periodOfDay` tinyint(2) DEFAULT 0,
744 PRIMARY KEY (`id`),
745 KEY `key_npc_templateid` (`npc_templateid`)
746 ) DEFAULT CHARSET=utf8;
747Index: sql/accounts.sql
748===================================================================
749--- sql/accounts.sql (revisión: 140)
750+++ sql/accounts.sql (copia de trabajo)
751@@ -4,7 +4,7 @@
752 CREATE TABLE IF NOT EXISTS `accounts` (
753 `login` VARCHAR(45) NOT NULL default '',
754 `password` VARCHAR(45) ,
755- `lastactive` DECIMAL(20),
756+ `lastactive` bigint(20),
757 `access_level` INT,
758 `lastIP` VARCHAR(20),
759 `lastServer` int(4) default 1,
760Index: sql/character_hennas.sql
761===================================================================
762--- sql/character_hennas.sql (revisión: 140)
763+++ sql/character_hennas.sql (copia de trabajo)
764@@ -2,6 +2,6 @@
765 `char_obj_id` INT NOT NULL DEFAULT 0,
766 `symbol_id` INT,
767 `slot` INT NOT NULL DEFAULT 0,
768- `class_index` INT(1) NOT NULL DEFAULT 0,
769+ `class_index` tinyint(1) NOT NULL DEFAULT 0,
770 PRIMARY KEY (`char_obj_id`,`slot`,`class_index`)
771 ) DEFAULT CHARSET=utf8;
772\ No newline at end of file
773Index: sql/engrave.sql
774===================================================================
775--- sql/engrave.sql (revisión: 140)
776+++ sql/engrave.sql (copia de trabajo)
777@@ -7,7 +7,7 @@
778
779 CREATE TABLE IF NOT EXISTS `engraved_log` (
780 `object_id` int(11) NOT NULL,
781- `actiondate` decimal(12,0) NOT NULL,
782+ `actiondate` bigint(20) NOT NULL,
783 `process` varchar(64) NOT NULL,
784 `itemName` varchar(64) NOT NULL,
785 `form_char` varchar(64) NOT NULL,
786Index: sql/seven_signs_festival.sql
787===================================================================
788--- sql/seven_signs_festival.sql (revisión: 140)
789+++ sql/seven_signs_festival.sql (copia de trabajo)
790@@ -5,7 +5,7 @@
791 `festivalId` int(1) NOT NULL default '0',
792 `cabal` varchar(4) NOT NULL default '',
793 `cycle` int(4) NOT NULL default '0',
794- `date` bigint(50) default '0',
795+ `date` bigint(20) default '0',
796 `score` int(5) NOT NULL default '0',
797 `members` varchar(255) NOT NULL default '',
798 PRIMARY KEY (`festivalId`,`cabal`,`cycle`)
799Index: sql/rebirth_manager.sql
800===================================================================
801--- sql/rebirth_manager.sql (revisión: 140)
802+++ sql/rebirth_manager.sql (copia de trabajo)
803@@ -2,7 +2,7 @@
804 -- Table structure for rebirth_manager
805 -- ----------------------------
806 CREATE TABLE IF NOT EXISTS `rebirth_manager`(
807- `playerId` int(20) NOT NULL,
808+ `playerId` int(11) NOT NULL,
809 `rebirthCount` int(2) NOT NULL,
810 PRIMARY KEY (`playerId`)
811 ) DEFAULT CHARSET=utf8;
812Index: sql/global_tasks.sql
813===================================================================
814--- sql/global_tasks.sql (revisión: 140)
815+++ sql/global_tasks.sql (copia de trabajo)
816@@ -5,7 +5,7 @@
817 id int(11) NOT NULL auto_increment,
818 task varchar(50) NOT NULL default '',
819 type varchar(50) NOT NULL default '',
820- last_activation decimal(20,0) NOT NULL default 0,
821+ last_activation bigint(20) NOT NULL default 0,
822 param1 varchar(100) NOT NULL default '',
823 param2 varchar(100) NOT NULL default '',
824 param3 varchar(255) NOT NULL default '',
825Index: sql/custom_merchant_buylists.sql
826===================================================================
827--- sql/custom_merchant_buylists.sql (revisión: 140)
828+++ sql/custom_merchant_buylists.sql (copia de trabajo)
829@@ -3,13 +3,13 @@
830 --
831 DROP TABLE IF EXISTS custom_merchant_buylists;
832 CREATE TABLE custom_merchant_buylists (
833- item_id decimal(9,0) NOT NULL default '0',
834- price decimal(11,0) NOT NULL default '0',
835- shop_id decimal(9,0) NOT NULL default '0',
836- `order` decimal(4,0) NOT NULL default '0',
837- `count` INT( 11 ) NOT NULL DEFAULT '-1',
838- `currentCount` INT( 11 ) NOT NULL DEFAULT '-1',
839- time INT NOT NULL DEFAULT '0',
840- savetimer DECIMAL(20,0) NOT NULL DEFAULT '0',
841+ item_id int(11) NOT NULL default '0',
842+ price int(11) NOT NULL default '0',
843+ shop_id int(11) NOT NULL default '0',
844+ `order` int(4) NOT NULL default '0',
845+ `count` int(11) NOT NULL DEFAULT '-1',
846+ `currentCount` int(11) NOT NULL DEFAULT '-1',
847+ `time` INT NOT NULL DEFAULT '0',
848+ savetimer bigint(20) NOT NULL DEFAULT '0',
849 PRIMARY KEY (shop_id,`order`)
850 ) DEFAULT CHARSET=utf8;
851\ No newline at end of file
852Index: sql/grandboss_list.sql
853===================================================================
854--- sql/grandboss_list.sql (revisión: 140)
855+++ sql/grandboss_list.sql (copia de trabajo)
856@@ -3,7 +3,7 @@
857 -- ----------------------------
858 DROP TABLE IF EXISTS `grandboss_list`;
859 CREATE TABLE `grandboss_list` (
860- `player_id` decimal(11,0) NOT NULL,
861- `zone` decimal(11,0) NOT NULL,
862+ `player_id` int(11) NOT NULL,
863+ `zone` int(11) NOT NULL,
864 PRIMARY KEY (`player_id`)
865 ) DEFAULT CHARSET=utf8;
866\ No newline at end of file
867Index: sql/clanhall_siege.sql
868===================================================================
869--- sql/clanhall_siege.sql (revisión: 140)
870+++ sql/clanhall_siege.sql (copia de trabajo)
871@@ -5,7 +5,7 @@
872 CREATE TABLE IF NOT EXISTS `clanhall_siege` (
873 `id` int(11) NOT NULL,
874 `name` varchar(40) NOT NULL,
875- `siege_data` decimal(20,0) NOT NULL,
876+ `siege_data` bigint(20) NOT NULL,
877 PRIMARY KEY (`id`)
878 ) DEFAULT CHARSET=utf8;
879 -- ----------------------------
880Index: sql/characters.sql
881===================================================================
882--- sql/characters.sql (revisión: 140)
883+++ sql/characters.sql (copia de trabajo)
884@@ -1,99 +1,100 @@
885--- ---------------------------
886+-- ----------------------------
887 -- Table structure for characters
888--- ---------------------------
889-CREATE TABLE IF NOT EXISTS characters (
890- account_name varchar(45) default NULL,
891- obj_Id decimal(11,0) NOT NULL default '0',
892- char_name varchar(35) NOT NULL,
893- `level` decimal(11,0) default NULL,
894- maxHp decimal(11,0) default 1,
895- curHp decimal(18,0) default 1,
896- maxCp decimal(11,0) default 1,
897- curCp decimal(18,0) default 1,
898- maxMp decimal(11,0) default 1,
899- curMp decimal(18,0) default 1,
900- acc decimal(11,0) default NULL,
901- crit decimal(10,0) default NULL,
902- evasion decimal(11,0) default NULL,
903- mAtk decimal(11,0) default NULL,
904- mDef decimal(11,0) default NULL,
905- mSpd decimal(11,0) default NULL,
906- pAtk decimal(11,0) default NULL,
907- pDef decimal(11,0) default NULL,
908- pSpd decimal(11,0) default NULL,
909- runSpd decimal(11,0) default NULL,
910- walkSpd decimal(11,0) default NULL,
911- str decimal(11,0) default NULL,
912- con decimal(11,0) default NULL,
913- dex decimal(11,0) default NULL,
914- _int decimal(11,0) default NULL,
915- men decimal(11,0) default NULL,
916- wit decimal(11,0) default NULL,
917- face decimal(11,0) default NULL,
918- hairStyle decimal(11,0) default NULL,
919- hairColor decimal(11,0) default NULL,
920- sex decimal(11,0) default NULL,
921- heading decimal(11,0) default NULL,
922- x decimal(11,0) default NULL,
923- y decimal(11,0) default NULL,
924- z decimal(11,0) default NULL,
925- movement_multiplier decimal(9,8) default NULL,
926- attack_speed_multiplier decimal(10,9) default NULL,
927- colRad decimal(10,3) default NULL,
928- colHeight decimal(10,3) default NULL,
929- exp decimal(20,0) default NULL,
930- expBeforeDeath decimal(20,0) default 0,
931- sp decimal(11,0) default NULL,
932- karma decimal(11,0) default NULL,
933- pvpkills decimal(11,0) default NULL,
934- pkkills decimal(11,0) default NULL,
935- clanid decimal(11,0) default NULL,
936- maxload decimal(11,0) default NULL,
937- race decimal(11,0) default NULL,
938- classid decimal(11,0) default NULL,
939- base_class int(2) NOT NULL default '0',
940- deletetime decimal(20,0) default NULL,
941- cancraft decimal(11,0) default NULL,
942- title varchar(16) default NULL,
943- rec_have int(3) NOT NULL default '0',
944- rec_left int(3) NOT NULL default '0',
945- accesslevel decimal(4,0) default NULL,
946- online decimal(1,0) default NULL,
947- onlinetime decimal(20,0) default NULL,
948- char_slot decimal(1) default NULL,
949- newbie decimal(1,0) default '1',
950- lastAccess decimal(20,0) default NULL,
951- clan_privs INT DEFAULT 0,
952- wantspeace decimal(1,0) DEFAULT 0,
953- isin7sdungeon decimal(1,0) NOT NULL default 0,
954- punish_level TINYINT UNSIGNED NOT NULL DEFAULT 0,
955- punish_timer INT UNSIGNED NOT NULL DEFAULT 0,
956- power_grade decimal(11,0) DEFAULT NULL,
957- nobless decimal(1,0) NOT NULL DEFAULT 0,
958- subpledge int(1) NOT NULL DEFAULT 0,
959- last_recom_date decimal(20,0) NOT NULL DEFAULT 0,
960- lvl_joined_academy int(1) NOT NULL DEFAULT 0,
961- apprentice int(1) NOT NULL DEFAULT 0,
962- sponsor int(1) NOT NULL DEFAULT 0,
963- varka_ketra_ally int(1) NOT NULL DEFAULT 0,
964- clan_join_expiry_time DECIMAL(20,0) NOT NULL DEFAULT 0,
965- clan_create_expiry_time DECIMAL(20,0) NOT NULL DEFAULT 0,
966- death_penalty_level int(2) NOT NULL DEFAULT 0,
967- pc_point int(5) NOT NULL DEFAULT 0,
968- name_color varchar(8) NOT NULL DEFAULT 0x000000,
969- title_color varchar(8) NOT NULL DEFAULT 0x000000,
970- first_log INT DEFAULT 1,
971- aio decimal(1,0) NOT NULL DEFAULT 0,
972- aio_end decimal(20,0) NOT NULL DEFAULT 0,
973- arena_wins int(11) NOT NULL DEFAULT 0,
974- arena_defeats int(11) NOT NULL DEFAULT 0,
975- hitman_target int(16) NOT NULL DEFAULT 0,
976- exp_multiplier int(11) DEFAULT '1' COMMENT 'Rate exp multiplier for player',
977- autoloot tinyint(1) DEFAULT '0' COMMENT '1 = true , 0 = false',
978- autoskill tinyint(1) DEFAULT '0' COMMENT '1 = true , 0 = false',
979- acp tinyint(1) DEFAULT '0' COMMENT 'Enable use Auto CP 1 = true , 0 = false',
980- ahp tinyint(1) DEFAULT '0' COMMENT 'Enable use Auto HP 1 = true , 0 = false',
981- amp tinyint(1) DEFAULT NULL COMMENT 'Enable use Auto MP 1 = true , 0 = false',
982- PRIMARY KEY (obj_Id),
983+-- ----------------------------
984+DROP TABLE IF EXISTS `characters`;
985+CREATE TABLE `characters` (
986+ `account_name` varchar(45) DEFAULT NULL,
987+ `obj_Id` int(11) NOT NULL DEFAULT '0',
988+ `char_name` varchar(35) NOT NULL,
989+ `level` int(11) DEFAULT NULL,
990+ `maxHp` int(11) DEFAULT '1',
991+ `curHp` bigint(18) DEFAULT '1',
992+ `maxCp` int(11) DEFAULT '1',
993+ `curCp` bigint(18) DEFAULT '1',
994+ `maxMp` int(11) DEFAULT '1',
995+ `curMp` bigint(18) DEFAULT '1',
996+ `acc` int(11) DEFAULT NULL,
997+ `crit` int(10) DEFAULT NULL,
998+ `evasion` int(11) DEFAULT NULL,
999+ `mAtk` int(11) DEFAULT NULL,
1000+ `mDef` int(11) DEFAULT NULL,
1001+ `mSpd` int(11) DEFAULT NULL,
1002+ `pAtk` int(11) DEFAULT NULL,
1003+ `pDef` int(11) DEFAULT NULL,
1004+ `pSpd` int(11) DEFAULT NULL,
1005+ `runSpd` int(11) DEFAULT NULL,
1006+ `walkSpd` int(11) DEFAULT NULL,
1007+ `str` int(11) DEFAULT NULL,
1008+ `con` int(11) DEFAULT NULL,
1009+ `dex` int(11) DEFAULT NULL,
1010+ `_int` int(11) DEFAULT NULL,
1011+ `men` int(11) DEFAULT NULL,
1012+ `wit` int(11) DEFAULT NULL,
1013+ `face` int(11) DEFAULT NULL,
1014+ `hairStyle` int(11) DEFAULT NULL,
1015+ `hairColor` int(11) DEFAULT NULL,
1016+ `sex` int(11) DEFAULT NULL,
1017+ `heading` int(11) DEFAULT NULL,
1018+ `x` int(11) DEFAULT NULL,
1019+ `y` int(11) DEFAULT NULL,
1020+ `z` int(11) DEFAULT NULL,
1021+ `movement_multiplier` int(9) DEFAULT NULL,
1022+ `attack_speed_multiplier` int(10) DEFAULT NULL,
1023+ `colRad` int(10) DEFAULT NULL,
1024+ `colHeight` int(10) DEFAULT NULL,
1025+ `exp` bigint(20) DEFAULT NULL,
1026+ `expBeforeDeath` bigint(20) DEFAULT '0',
1027+ `sp` int(11) DEFAULT NULL,
1028+ `karma` int(11) DEFAULT NULL,
1029+ `pvpkills` int(11) DEFAULT NULL,
1030+ `pkkills` int(11) DEFAULT NULL,
1031+ `clanid` int(11) DEFAULT NULL,
1032+ `maxload` int(11) DEFAULT NULL,
1033+ `race` int(11) DEFAULT NULL,
1034+ `classid` int(11) DEFAULT NULL,
1035+ `base_class` int(2) NOT NULL DEFAULT '0',
1036+ `deletetime` bigint(20) DEFAULT NULL,
1037+ `cancraft` int(11) DEFAULT NULL,
1038+ `title` varchar(16) DEFAULT NULL,
1039+ `rec_have` int(3) NOT NULL DEFAULT '0',
1040+ `rec_left` int(3) NOT NULL DEFAULT '0',
1041+ `accesslevel` int(4) DEFAULT NULL,
1042+ `online` tinyint(1) DEFAULT NULL,
1043+ `onlinetime` bigint(20) DEFAULT NULL,
1044+ `char_slot` tinyint(1) DEFAULT NULL,
1045+ `newbie` tinyint(1) DEFAULT '1',
1046+ `lastAccess` bigint(20) DEFAULT NULL,
1047+ `clan_privs` int(11) DEFAULT '0',
1048+ `wantspeace` tinyint(1) DEFAULT '0',
1049+ `isin7sdungeon` tinyint(1) NOT NULL DEFAULT '0',
1050+ `punish_level` tinyint(3) unsigned NOT NULL DEFAULT '0',
1051+ `punish_timer` int(10) unsigned NOT NULL DEFAULT '0',
1052+ `power_grade` int(11) DEFAULT NULL,
1053+ `nobless` tinyint(1) NOT NULL DEFAULT '0',
1054+ `subpledge` tinyint(1) NOT NULL DEFAULT '0',
1055+ `last_recom_date` bigint(20) NOT NULL DEFAULT '0',
1056+ `lvl_joined_academy` tinyint(1) NOT NULL DEFAULT '0',
1057+ `apprentice` tinyint(1) NOT NULL DEFAULT '0',
1058+ `sponsor` tinyint(1) NOT NULL DEFAULT '0',
1059+ `varka_ketra_ally` tinyint(1) NOT NULL DEFAULT '0',
1060+ `clan_join_expiry_time` bigint(20) NOT NULL DEFAULT '0',
1061+ `clan_create_expiry_time` bigint(20) NOT NULL DEFAULT '0',
1062+ `death_penalty_level` tinyint(2) NOT NULL DEFAULT '0',
1063+ `pc_point` int(5) NOT NULL DEFAULT '0',
1064+ `name_color` varchar(8) NOT NULL DEFAULT '\0\0\0',
1065+ `title_color` varchar(8) NOT NULL DEFAULT '\0\0\0',
1066+ `first_log` int(11) DEFAULT '1',
1067+ `aio` tinyint(1) NOT NULL DEFAULT '0',
1068+ `aio_end` bigint(20) NOT NULL DEFAULT '0',
1069+ `arena_wins` int(11) NOT NULL DEFAULT '0',
1070+ `arena_defeats` int(11) NOT NULL DEFAULT '0',
1071+ `hitman_target` bigint(16) NOT NULL DEFAULT '0',
1072+ `exp_multiplier` int(11) DEFAULT '1' COMMENT 'Rate exp multiplier for player',
1073+ `autoloot` tinyint(1) DEFAULT '0' COMMENT '1 = true , 0 = false',
1074+ `autoskill` tinyint(1) DEFAULT '0' COMMENT '1 = true , 0 = false',
1075+ `acp` tinyint(1) DEFAULT '0' COMMENT 'Enable use Auto CP 1 = true , 0 = false',
1076+ `ahp` tinyint(1) DEFAULT '0' COMMENT 'Enable use Auto HP 1 = true , 0 = false',
1077+ `amp` tinyint(1) DEFAULT NULL COMMENT 'Enable use Auto MP 1 = true , 0 = false',
1078+ PRIMARY KEY (`obj_Id`),
1079 KEY `clanid` (`clanid`)
1080 ) DEFAULT CHARSET=utf8;
1081Index: sql/character_shortcuts.sql
1082===================================================================
1083--- sql/character_shortcuts.sql (revisión: 140)
1084+++ sql/character_shortcuts.sql (copia de trabajo)
1085@@ -2,13 +2,13 @@
1086 -- Table structure for character_shortcuts
1087 -- ---------------------------
1088 CREATE TABLE IF NOT EXISTS character_shortcuts (
1089- char_obj_id decimal(11) NOT NULL default 0,
1090- slot decimal(3) NOT NULL default 0,
1091- page decimal(3) NOT NULL default 0,
1092- type decimal(3) ,
1093- shortcut_id decimal(16) ,
1094+ char_obj_id int(11) NOT NULL default 0,
1095+ slot tinyint(3) NOT NULL default 0,
1096+ page tinyint(3) NOT NULL default 0,
1097+ type tinyint(3) ,
1098+ shortcut_id bigint(16) ,
1099 level varchar(4) ,
1100- `class_index` int(1) NOT NULL default '0',
1101+ `class_index` tinyint(1) NOT NULL default '0',
1102 PRIMARY KEY (char_obj_id,slot,page,`class_index`),
1103 KEY `shortcut_id` (`shortcut_id`)
1104 ) DEFAULT CHARSET=utf8;
1105Index: sql/seven_signs_status.sql
1106===================================================================
1107--- sql/seven_signs_status.sql (revisión: 140)
1108+++ sql/seven_signs_status.sql (copia de trabajo)
1109@@ -5,9 +5,9 @@
1110 `active_period` int(10) NOT NULL default '1',
1111 `date` int(10) NOT NULL default '1',
1112 `previous_winner` int(10) NOT NULL default '0',
1113- `dawn_stone_score` DECIMAL(20,0) NOT NULL default '0',
1114+ `dawn_stone_score` bigint(20) NOT NULL default '0',
1115 `dawn_festival_score` int(10) NOT NULL default '0',
1116- `dusk_stone_score` DECIMAL(20,0) NOT NULL default '0',
1117+ `dusk_stone_score` bigint(20) NOT NULL default '0',
1118 `dusk_festival_score` int(10) NOT NULL default '0',
1119 `avarice_owner` int(10) NOT NULL default '0',
1120 `gnosis_owner` int(10) NOT NULL default '0',
1121Index: sql/clanhall.sql
1122===================================================================
1123--- sql/clanhall.sql (revisión: 140)
1124+++ sql/clanhall.sql (copia de trabajo)
1125@@ -8,9 +8,9 @@
1126 `lease` int(10) NOT NULL default '0',
1127 `desc` text NOT NULL,
1128 `location` varchar(15) NOT NULL default '',
1129- `paidUntil` decimal(20,0) NOT NULL default '0',
1130- `Grade` decimal(1,0) NOT NULL default '0',
1131- `paid` int( 1 ) NOT NULL default '0',
1132+ `paidUntil` bigint(20) NOT NULL default '0',
1133+ `Grade` tinyint(1) NOT NULL default '0',
1134+ `paid` tinyint(1) NOT NULL default '0',
1135 PRIMARY KEY `id` (`id`)
1136 ) DEFAULT CHARSET=utf8;
1137
1138Index: sql/heroes.sql
1139===================================================================
1140--- sql/heroes.sql (revisión: 140)
1141+++ sql/heroes.sql (copia de trabajo)
1142@@ -1,8 +1,8 @@
1143 CREATE TABLE IF NOT EXISTS `heroes` (
1144- `charId` decimal(11,0) NOT NULL default '0',
1145+ `charId` int(11) NOT NULL default '0',
1146 `char_name` varchar(45) NOT NULL default '',
1147- `class_id` decimal(3,0) NOT NULL default '0',
1148- `count` decimal(3,0) NOT NULL default '0',
1149- `played` decimal(1,0) NOT NULL default '0',
1150+ `class_id` int(3) NOT NULL default '0',
1151+ `count` int(11) NOT NULL default '0',
1152+ `played` tinyint(1) NOT NULL default '0',
1153 PRIMARY KEY (`charId`)
1154 ) DEFAULT CHARSET=utf8;
1155\ No newline at end of file
1156Index: sql/spawnlist.sql
1157===================================================================
1158--- sql/spawnlist.sql (revisión: 140)
1159+++ sql/spawnlist.sql (copia de trabajo)
1160@@ -15,7 +15,7 @@
1161 `heading` int(9) NOT NULL default '0',
1162 `respawn_delay` int(9) NOT NULL default '0',
1163 `loc_id` int(9) NOT NULL default '0',
1164- `periodOfDay` decimal(2,0) default '0',
1165+ `periodOfDay` tinyint(2) default '0',
1166 PRIMARY KEY (id),
1167 KEY `key_npc_templateid` (`npc_templateid`)
1168 ) DEFAULT CHARSET=utf8;
1169Index: sql/character_subclasses.sql
1170===================================================================
1171--- sql/character_subclasses.sql (revisión: 140)
1172+++ sql/character_subclasses.sql (copia de trabajo)
1173@@ -2,11 +2,11 @@
1174 -- Table structure for character_subclasses
1175 -- ---------------------------
1176 CREATE TABLE IF NOT EXISTS `character_subclasses` (
1177- `char_obj_id` decimal(11,0) NOT NULL default '0',
1178- `class_id` int(2) NOT NULL default '0',
1179- `exp` decimal(20,0) NOT NULL default '0',
1180- `sp` decimal(11,0) NOT NULL default '0',
1181- `level` int(2) NOT NULL default '40',
1182- `class_index` int(1) NOT NULL default '0',
1183+ `char_obj_id` int(11) NOT NULL default '0',
1184+ `class_id` tinyint(2) NOT NULL default '0',
1185+ `exp` bigint(20) NOT NULL default '0',
1186+ `sp` int(11) NOT NULL default '0',
1187+ `level` tinyint(2) NOT NULL default '40',
1188+ `class_index` tinyint(1) NOT NULL default '0',
1189 PRIMARY KEY (`char_obj_id`,`class_id`)
1190 ) DEFAULT CHARSET=utf8;
1191\ No newline at end of file