From 3bf3c1375fcf65755e360ad8108afdb758a89c0a Mon Sep 17 00:00:00 2001
From: Andrei Karas <akaras@inbox.ru>
Date: Fri, 5 Aug 2016 21:27:48 +0300
Subject: hercules: update db cnverter for support new db fields.

---
 hercules/templates/char.sql | 12 +++++++-----
 1 file changed, 7 insertions(+), 5 deletions(-)

(limited to 'hercules/templates/char.sql')

diff --git a/hercules/templates/char.sql b/hercules/templates/char.sql
index 37a1d55..0f75eb5 100644
--- a/hercules/templates/char.sql
+++ b/hercules/templates/char.sql
@@ -14,13 +14,13 @@ CREATE TABLE IF NOT EXISTS `char` (
   `str` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
   `agi` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
   `vit` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `INT` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
+  `int` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
   `dex` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
   `luk` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
-  `max_hp` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
-  `hp` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
-  `max_sp` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT '0',
-  `sp` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT '0',
+  `max_hp` INT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `hp` INT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `max_sp` INT(9) UNSIGNED NOT NULL DEFAULT '0',
+  `sp` INT(9) UNSIGNED NOT NULL DEFAULT '0',
   `status_point` INT(11) UNSIGNED NOT NULL DEFAULT '0',
   `skill_point` INT(11) UNSIGNED NOT NULL DEFAULT '0',
   `option` INT(11) NOT NULL DEFAULT '0',
@@ -34,6 +34,7 @@ CREATE TABLE IF NOT EXISTS `char` (
   `hair` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
   `hair_color` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
   `clothes_color` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
+  `body` SMALLINT(5) unsigned NOT NULL default '0',
   `weapon` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
   `shield` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
   `head_top` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
@@ -60,6 +61,7 @@ CREATE TABLE IF NOT EXISTS `char` (
   `unban_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
   `uniqueitem_counter` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
   `sex` ENUM('M','F','U') NOT NULL DEFAULT 'U',
+  `hotkey_rowshift` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`char_id`),
   UNIQUE KEY `name_key` (`name`),
   KEY `account_id` (`account_id`),
-- 
cgit v1.2.3-70-g09d2

