diff options
| author | Andrei Karas <akaras@inbox.ru> | 2016-08-05 21:27:48 +0300 |
|---|---|---|
| committer | Andrei Karas <akaras@inbox.ru> | 2016-08-05 21:27:48 +0300 |
| commit | 3bf3c1375fcf65755e360ad8108afdb758a89c0a (patch) | |
| tree | f6eb57893a12e113098ec3ca4e50e7c6a79bb361 /hercules/templates/char.sql | |
| parent | 1c6c8889704dc1d7c733a225a8b3cecba8f405e9 (diff) | |
| download | evol-tools-3bf3c1375fcf65755e360ad8108afdb758a89c0a.tar.gz evol-tools-3bf3c1375fcf65755e360ad8108afdb758a89c0a.tar.bz2 evol-tools-3bf3c1375fcf65755e360ad8108afdb758a89c0a.tar.xz evol-tools-3bf3c1375fcf65755e360ad8108afdb758a89c0a.zip | |
hercules: update db cnverter for support new db fields.
Diffstat (limited to 'hercules/templates/char.sql')
| -rw-r--r-- | hercules/templates/char.sql | 12 |
1 files changed, 7 insertions, 5 deletions
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`), |