custom_merchant_buylists.sql 565 B

123456789101112131415
  1. --
  2. -- Table structure for table `custom_merchant_buylists`
  3. --
  4. DROP TABLE IF EXISTS custom_merchant_buylists;
  5. CREATE TABLE custom_merchant_buylists (
  6. item_id decimal(9,0) NOT NULL default '0',
  7. price decimal(11,0) NOT NULL default '0',
  8. shop_id decimal(9,0) NOT NULL default '0',
  9. `order` decimal(4,0) NOT NULL default '0',
  10. `count` INT( 11 ) NOT NULL DEFAULT '-1',
  11. `currentCount` INT( 11 ) NOT NULL DEFAULT '-1',
  12. time INT NOT NULL DEFAULT '0',
  13. savetimer DECIMAL(20,0) NOT NULL DEFAULT '0',
  14. PRIMARY KEY (shop_id,`order`)
  15. ) TYPE=MyISAM;