diff options
| author | xinef1 <w.szyszko2@gmail.com> | 2017-04-12 03:22:50 +0200 |
|---|---|---|
| committer | ariel- <ariel-@users.noreply.github.com> | 2017-04-11 22:22:50 -0300 |
| commit | 9dc3de10f0044c35a95e9b72e7b874f4b5b8e867 (patch) | |
| tree | 64b5fff4d0c0afcc17fea8e1f207d500b7d7a12a /sql/updates | |
| parent | 1787718e258f0e3c7673b5886c098878fb8a17f6 (diff) | |
Core/Loot: implement Loot Item Storage (#19018)
* Created Item Loot Storage, no more synchronous DB selects
* Fixed buyback case, where stored loot was not removed from db
* Added Primary key, and changed field types to be unsigned for table item_loot_money
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/characters/3.3.5/2017_04_12_00_characters.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/characters/3.3.5/2017_04_12_00_characters.sql b/sql/updates/characters/3.3.5/2017_04_12_00_characters.sql new file mode 100644 index 00000000000..117e3baa78d --- /dev/null +++ b/sql/updates/characters/3.3.5/2017_04_12_00_characters.sql @@ -0,0 +1,3 @@ +ALTER TABLE `item_loot_money` +CHANGE `money` `money` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'money loot (in copper)', +ADD PRIMARY KEY (`container_id`); |