premium_storage.sql 1.8 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. --
  2. -- Table structure for table `vip_storage`
  3. --
  4. CREATE TABLE IF NOT EXISTS `vip_storage` (
  5. `id` int(11) unsigned NOT NULL auto_increment,
  6. `account_id` int(11) unsigned NOT NULL default '0',
  7. `nameid` int(10) unsigned NOT NULL default '0',
  8. `amount` smallint(11) unsigned NOT NULL default '0',
  9. `equip` int(11) unsigned NOT NULL default '0',
  10. `identify` smallint(6) unsigned NOT NULL default '0',
  11. `refine` tinyint(3) unsigned NOT NULL default '0',
  12. `attribute` tinyint(4) unsigned NOT NULL default '0',
  13. `card0` int(10) unsigned NOT NULL default '0',
  14. `card1` int(10) unsigned NOT NULL default '0',
  15. `card2` int(10) unsigned NOT NULL default '0',
  16. `card3` int(10) unsigned NOT NULL default '0',
  17. `option_id0` smallint(5) unsigned NOT NULL default '0',
  18. `option_val0` smallint(5) unsigned NOT NULL default '0',
  19. `option_parm0` tinyint(3) unsigned NOT NULL default '0',
  20. `option_id1` smallint(5) unsigned NOT NULL default '0',
  21. `option_val1` smallint(5) unsigned NOT NULL default '0',
  22. `option_parm1` tinyint(3) unsigned NOT NULL default '0',
  23. `option_id2` smallint(5) unsigned NOT NULL default '0',
  24. `option_val2` smallint(5) unsigned NOT NULL default '0',
  25. `option_parm2` tinyint(3) unsigned NOT NULL default '0',
  26. `option_id3` smallint(5) unsigned NOT NULL default '0',
  27. `option_val3` smallint(5) unsigned NOT NULL default '0',
  28. `option_parm3` tinyint(3) unsigned NOT NULL default '0',
  29. `option_id4` smallint(5) unsigned NOT NULL default '0',
  30. `option_val4` smallint(5) unsigned NOT NULL default '0',
  31. `option_parm4` tinyint(3) unsigned NOT NULL default '0',
  32. `expire_time` int(11) unsigned NOT NULL default '0',
  33. `bound` tinyint(3) unsigned NOT NULL default '0',
  34. `unique_id` bigint(20) unsigned NOT NULL default '0',
  35. `enchantgrade` tinyint unsigned NOT NULL default '0',
  36. PRIMARY KEY (`id`),
  37. KEY `account_id` (`account_id`)
  38. ) ENGINE=MyISAM;