· 8 years ago · Jun 20, 2018, 09:24 AM
1DROP TABLE IF EXISTS `creature_currency`;
2CREATE TABLE IF NOT EXISTS `creature_currency` (
3 `creature_id` mediumint(8) unsigned NOT NULL,
4 `CurrencyId1` smallint(5) unsigned DEFAULT NULL,
5 `CurrencyId2` smallint(5) unsigned DEFAULT NULL,
6 `CurrencyId3` smallint(5) unsigned DEFAULT NULL,
7 `CurrencyCount1` smallint(6) DEFAULT NULL,
8 `CurrencyCount2` smallint(6) DEFAULT NULL,
9 `CurrencyCount3` smallint(6) DEFAULT NULL
10);