diff options
| author | DDuarte <dnpd.dd@gmail.com> | 2016-04-10 17:58:05 +0200 |
|---|---|---|
| committer | DDuarte <dnpd.dd@gmail.com> | 2016-04-11 02:40:33 +0100 |
| commit | 2f8493952214f328a6dfebd93414ee721a3fff3a (patch) | |
| tree | 9aa10c11068f5727945c52c0acdc5f5fb99bef9e /sql/updates/characters | |
| parent | 070bedae0c78a870ef69f6796ac956896c8e7fa2 (diff) | |
TDB 335.61 - 2016/04/11TDB335.61
Diffstat (limited to 'sql/updates/characters')
| -rw-r--r-- | sql/updates/characters/2016_02_10_00_characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/characters/2016_03_13_2016_01_05_00_characters.sql | 19 | ||||
| -rw-r--r-- | sql/updates/characters/2016_04_11_00_characters.sql (renamed from sql/updates/characters/2015_11_07_00_characters.sql) | 0 |
3 files changed, 0 insertions, 21 deletions
diff --git a/sql/updates/characters/2016_02_10_00_characters.sql b/sql/updates/characters/2016_02_10_00_characters.sql deleted file mode 100644 index d49ed155bc8..00000000000 --- a/sql/updates/characters/2016_02_10_00_characters.sql +++ /dev/null @@ -1,2 +0,0 @@ --- extend=0 is expired, extend=1 is normal, extend=2 is extended -ALTER TABLE `character_instance` ADD COLUMN `extendState` TINYINT(2) UNSIGNED NOT NULL DEFAULT '1'; diff --git a/sql/updates/characters/2016_03_13_2016_01_05_00_characters.sql b/sql/updates/characters/2016_03_13_2016_01_05_00_characters.sql deleted file mode 100644 index 11850067be9..00000000000 --- a/sql/updates/characters/2016_03_13_2016_01_05_00_characters.sql +++ /dev/null @@ -1,19 +0,0 @@ -ALTER TABLE `characters` - ADD `skin` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `money`, - ADD `face` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `skin`, - ADD `hairStyle` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `face`, - ADD `hairColor` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `hairStyle`, - ADD `facialStyle` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `hairColor`, - ADD `bankSlots` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `facialStyle`, - ADD `restState` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `bankSlots`; - -UPDATE `characters` SET - `skin`=`playerBytes`&0xFF, - `face`=(`playerBytes`>>8)&0xFF, - `hairStyle`=(`playerBytes`>>16)&0xFF, - `hairColor`=(`playerBytes`>>24)&0xFF, - `facialStyle`=`playerBytes2`&0xFF, - `bankSlots`=(`playerBytes2`>>16)&0xFF, - `restState`=(`playerBytes2`>>24)&0xFF; - -ALTER TABLE `characters` DROP `playerBytes`, DROP `playerBytes2`; diff --git a/sql/updates/characters/2015_11_07_00_characters.sql b/sql/updates/characters/2016_04_11_00_characters.sql index be8a4d21b66..be8a4d21b66 100644 --- a/sql/updates/characters/2015_11_07_00_characters.sql +++ b/sql/updates/characters/2016_04_11_00_characters.sql |