buylists.sql 272 B

1234567
  1. CREATE TABLE IF NOT EXISTS `buylists` (
  2. `buylist_id` INT UNSIGNED,
  3. `item_id` INT UNSIGNED,
  4. `count` BIGINT UNSIGNED NOT NULL DEFAULT 0,
  5. `next_restock_time` BIGINT UNSIGNED NOT NULL DEFAULT 0,
  6. PRIMARY KEY (`buylist_id`, `item_id`)
  7. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;