premium_storage.sql 1.8 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. --
  2. -- Table structure for table `storage_1`
  3. --
  4. CREATE TABLE IF NOT EXISTS `storage_1` (
  5. `id` int(11) unsigned NOT NULL auto_increment,
  6. `account_id` int(11) unsigned NOT NULL default '0',
  7. `nameid` smallint(5) 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` smallint(5) unsigned NOT NULL default '0',
  14. `card1` smallint(5) unsigned NOT NULL default '0',
  15. `card2` smallint(5) unsigned NOT NULL default '0',
  16. `card3` smallint(5) 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. PRIMARY KEY (`id`),
  36. KEY `account_id` (`account_id`)
  37. ) ENGINE=MyISAM;