diff options
| author | Jesusaves <cpntb1@ymail.com> | 2020-05-12 12:56:54 -0300 |
|---|---|---|
| committer | Jesusaves <cpntb1@ymail.com> | 2020-05-12 12:56:54 -0300 |
| commit | f91413a6b22b698881068fcf85a5402a42381e0d (patch) | |
| tree | c4a3f1a1ae5f2e98f7e218bd56433080ccf3eabc /sql-files | |
| parent | 1119e48182fef2de3f01e70c82ebeff1bd9cbebc (diff) | |
| download | serverdata-f91413a6b22b698881068fcf85a5402a42381e0d.tar.gz serverdata-f91413a6b22b698881068fcf85a5402a42381e0d.tar.bz2 serverdata-f91413a6b22b698881068fcf85a5402a42381e0d.tar.xz serverdata-f91413a6b22b698881068fcf85a5402a42381e0d.zip | |
ManaMarket sketch
Diffstat (limited to 'sql-files')
| -rw-r--r-- | sql-files/main.sql | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index 6810f74a6..a353e6a1c 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -1053,3 +1053,34 @@ CREATE TABLE IF NOT EXISTS `npc_barter_data` ( `priceAmount` INT(11) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`name`, `itemid`, `priceId`, `priceAmount`) ) ENGINE=MyISAM; + +-- Bound items cannot go to ManaMarket anyway +-- PS. id autofilled, accountid/price/expire by MM +-- options by index, all others by getinventorylist() +CREATE TABLE IF NOT EXISTS `manamarket` ( + `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, + `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `price` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `amount` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0', + `equip` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `identify` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', + `refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + `attribute` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', + `card0` INT(11) NOT NULL DEFAULT '0', + `card1` INT(11) NOT NULL DEFAULT '0', + `card2` INT(11) NOT NULL DEFAULT '0', + `card3` INT(11) NOT NULL DEFAULT '0', + `opt_idx0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', + `opt_val0` SMALLINT(5) NOT NULL DEFAULT '0', + `opt_idx1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', + `opt_val1` SMALLINT(5) NOT NULL DEFAULT '0', + `opt_idx2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', + `opt_val2` SMALLINT(5) NOT NULL DEFAULT '0', + `opt_idx3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', + `opt_val3` SMALLINT(5) NOT NULL DEFAULT '0', + `opt_idx4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', + `opt_val4` SMALLINT(5) NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) +) ENGINE=MyISAM; |