diff options
| author | Dastgir <dastgirpojee@rocketmail.com> | 2015-12-17 16:10:19 +0530 |
|---|---|---|
| committer | Haru <haru@dotalux.com> | 2016-01-05 13:09:15 +0100 |
| commit | 0c458a4976ea392a71ccfa8d86f2ebf86d03e1b4 (patch) | |
| tree | bb90a52d78795f17f6268f815a77f66d77044b8f /sql-files | |
| parent | 987b90508e7e6528eca2983416ac96cc1452ed61 (diff) | |
| download | hercules-0c458a4976ea392a71ccfa8d86f2ebf86d03e1b4.tar.gz hercules-0c458a4976ea392a71ccfa8d86f2ebf86d03e1b4.tar.bz2 hercules-0c458a4976ea392a71ccfa8d86f2ebf86d03e1b4.tar.xz hercules-0c458a4976ea392a71ccfa8d86f2ebf86d03e1b4.zip | |
Added Support for BodyStyle
Closes #974 as merged
Diffstat (limited to 'sql-files')
| -rw-r--r-- | sql-files/main.sql | 2 | ||||
| -rw-r--r-- | sql-files/upgrades/2015-12-17--15-58.sql | 22 | ||||
| -rw-r--r-- | sql-files/upgrades/index.txt | 3 |
3 files changed, 26 insertions, 1 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index 864b86865..7adac433d 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -169,6 +169,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', @@ -821,6 +822,7 @@ INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1414975503); -- 2014-11-0 INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1435860840); -- 2015-07-02--18-14.sql INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1436360978); -- 2015-07-08--13-08.sql INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1440688342); -- 2015-08-27--20-42.sql +INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1450367880); -- 2015-12-17--15-58.sql -- -- Table structure for table `storage` diff --git a/sql-files/upgrades/2015-12-17--15-58.sql b/sql-files/upgrades/2015-12-17--15-58.sql new file mode 100644 index 000000000..8d3dc51a3 --- /dev/null +++ b/sql-files/upgrades/2015-12-17--15-58.sql @@ -0,0 +1,22 @@ +#1450367880 + +-- This file is part of Hercules. +-- http://herc.ws - http://github.com/HerculesWS/Hercules +-- +-- Copyright (C) 2015 Hercules Dev Team +-- +-- Hercules is free software: you can redistribute it and/or modify +-- it under the terms of the GNU General Public License as published by +-- the Free Software Foundation, either version 3 of the License, or +-- (at your option) any later version. +-- +-- This program is distributed in the hope that it will be useful, +-- but WITHOUT ANY WARRANTY; without even the implied warranty of +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +-- GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License +-- along with this program. If not, see <http://www.gnu.org/licenses/>. + +ALTER TABLE `char` ADD `body` smallint(5) unsigned NOT NULL default '0' AFTER `clothes_color`; +INSERT INTO `sql_updates` (`timestamp`) VALUES (1450367880); diff --git a/sql-files/upgrades/index.txt b/sql-files/upgrades/index.txt index 5f6aed963..e73a8659d 100644 --- a/sql-files/upgrades/index.txt +++ b/sql-files/upgrades/index.txt @@ -27,4 +27,5 @@ 2014-11-03--00-45.sql 2015-07-02--18-14.sql 2015-07-08--13-08.sql -2015-08-27--20-42.sql
\ No newline at end of file +2015-08-27--20-42.sql +2015-12-17--15-58.sql |