character_offline_trade_items.sql 384 B

12345678
  1. CREATE TABLE IF NOT EXISTS `character_offline_trade_items` (
  2. `charId` int(10) unsigned NOT NULL,
  3. `item` int(10) unsigned NOT NULL DEFAULT '0', -- itemId(for buy) & ObjectId(for sell)
  4. `count` bigint(20) unsigned NOT NULL DEFAULT '0',
  5. `price` bigint(20) unsigned NOT NULL DEFAULT '0',
  6. KEY `charId` (`charId`),
  7. KEY `item` (`item`)
  8. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;