EQ2EMu/EQ2/devtools/PacketParser/sql_updates/raw_item_details_armorset.sql

/* New Item Type 18 (Armor Set) table structure */

CREATE TABLE `raw_item_details_armorset` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`armorset_item_id` int(10) NOT NULL default '0',
	`item_id` int(10) NOT NULL default '0',
	`item_crc` int(10) NOT NULL default '0',
	`item_icon` smallint(5) unsigned NOT NULL default '0',
	`item_name` varchar(250) collate latin1_general_ci default '',
	`unknown_piece` int(10) unsigned NOT NULL default '0',
	`language_type` tinyint(3) NOT NULL default '0',
	PRIMARY KEY  (`id`)
) ENGINE=MyISAM;


alter table `raw_items` change `item_type` `item_type` enum('Normal','Armor','Food','Bag','Weapon','Ranged','Shield','Spell','Recipe','Book','House','Thrown','Bauble','House Container','Adornment','Pattern','Armor Set') default 'Normal' NOT NULL;