custom_armorsets.sql 951 B

123456789101112131415161718
  1. CREATE TABLE IF NOT EXISTS `custom_armorsets` (
  2. `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  3. `chest` smallint(5) unsigned NOT NULL DEFAULT '0',
  4. `legs` smallint(5) unsigned NOT NULL DEFAULT '0',
  5. `head` smallint(5) unsigned NOT NULL DEFAULT '0',
  6. `gloves` smallint(5) unsigned NOT NULL DEFAULT '0',
  7. `feet` smallint(5) unsigned NOT NULL DEFAULT '0',
  8. `skill` varchar(70) NOT NULL DEFAULT '0-0;',
  9. `shield` smallint(5) unsigned NOT NULL DEFAULT '0',
  10. `shield_skill_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  11. `enchant6skill` smallint(5) unsigned NOT NULL DEFAULT '0',
  12. `mw_legs` smallint(5) unsigned NOT NULL DEFAULT '0',
  13. `mw_head` smallint(5) unsigned NOT NULL DEFAULT '0',
  14. `mw_gloves` smallint(5) unsigned NOT NULL DEFAULT '0',
  15. `mw_feet` smallint(5) unsigned NOT NULL DEFAULT '0',
  16. `mw_shield` smallint(5) unsigned NOT NULL DEFAULT '0',
  17. PRIMARY KEY (`id`,`chest`)
  18. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;