custom_armorsets.sql 708 B

12345678910111213141516171819
  1. --
  2. -- Table structure for table `custom_armorsets`
  3. --
  4. DROP TABLE IF EXISTS custom_armorsets;
  5. CREATE TABLE custom_armorsets (
  6. id SMALLINT UNSIGNED NOT NULL auto_increment,
  7. chest SMALLINT UNSIGNED NOT NULL default 0,
  8. legs SMALLINT UNSIGNED NOT NULL default 0,
  9. head SMALLINT UNSIGNED NOT NULL default 0,
  10. gloves SMALLINT UNSIGNED NOT NULL default 0,
  11. feet SMALLINT UNSIGNED NOT NULL default 0,
  12. skill_id SMALLINT UNSIGNED NOT NULL default 0,
  13. skill_lvl TINYINT UNSIGNED NOT NULL default 0,
  14. shield SMALLINT UNSIGNED NOT NULL default 0,
  15. shield_skill_id SMALLINT UNSIGNED NOT NULL default 0,
  16. enchant6skill SMALLINT UNSIGNED NOT NULL default 0,
  17. PRIMARY KEY (id,chest)
  18. ) ENGINE=MyISAM;