EQ2EMu/EQ2/devtools/PacketParser/sql_updates/EQ2ParserDB SQL Updates_v0.1.1.txt

ALTER TABLE raw_item_effects CHANGE column `name` `effect` VARCHAR(512) NOT NULL DEFAULT 'Unknown' AFTER `item_id`;
ALTER TABLE raw_item_effects DROP COLUMN `description`;
ALTER TABLE parser_stats ADD COLUMN `total_skills` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `new_books`;
ALTER TABLE parser_stats ADD COLUMN `unique_skills` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `total_skills`;
ALTER TABLE parser_stats ADD COLUMN `new_skills` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `unique_skills`;

CREATE TABLE IF NOT EXISTS `raw_traits` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `level` tinyint(3) unsigned NOT NULL default '0',
  `selection` tinyint(3) unsigned NOT NULL default '0',
  `icon_0` smallint(5) unsigned NOT NULL default '0',
  `icon2_0` smallint(5) unsigned NOT NULL default '0',
  `trait_id_0` int(10) unsigned NOT NULL default '0',
  `unknown_0` int(10) unsigned NOT NULL default '0',
  `name_0` varchar(250) collate latin1_general_ci default NULL,
  `icon_1` smallint(5) unsigned NOT NULL default '0',
  `icon2_1` smallint(5) unsigned NOT NULL default '0',
  `trait_id_1` int(10) unsigned NOT NULL default '0',
  `unknown_1` int(10) unsigned NOT NULL default '0',
  `name_1` varchar(250) collate latin1_general_ci default '',
  `icon_2` smallint(5) unsigned NOT NULL default '0',
  `icon2_2` smallint(5) unsigned NOT NULL default '0',
  `trait_id_2` int(10) unsigned NOT NULL default '0',
  `unknown_2` int(10) unsigned NOT NULL default '0',
  `name_2` varchar(250) collate latin1_general_ci default '',
  `icon_3` smallint(5) unsigned NOT NULL default '0',
  `icon2_3` smallint(5) unsigned NOT NULL default '0',
  `trait_id_3` int(10) unsigned NOT NULL default '0',
  `unknown_3` int(10) unsigned NOT NULL default '0',
  `name_3` varchar(250) collate latin1_general_ci default '',
  `icon_4` smallint(5) unsigned NOT NULL default '0',
  `icon2_4` smallint(5) unsigned NOT NULL default '0',
  `trait_id_4` int(10) unsigned NOT NULL default '0',
  `unknown_4` int(10) unsigned NOT NULL default '0',
  `name_4` varchar(250) collate latin1_general_ci default '',
  `data_version` smallint(5) unsigned NOT NULL,
  `language_type` tinyint(3) unsigned NOT NULL default '0',
  `log_file` varchar(250) collate latin1_general_ci default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `NewIndex1` (`trait_id_0`,`trait_id_1`,`trait_id_2`,`trait_id_3`,`trait_id_4`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE IF NOT EXISTS `raw_skills` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `skill_id` int(10) unsigned NOT NULL default '0',
  `short_name` varchar(32) default 'Unknown',
  `name` varchar(255) default 'Unknown',
  `description` varchar(255) default 'Unknown',
  `data_version` smallint(5) NOT NULL default '0',
  `log_file` varchar(250) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `raw_skills_current` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `skill_id` int(10) unsigned NOT NULL default '0',
  `type` smallint(5) unsigned NOT NULL default '0',
  `current_val` mediumint(7) unsigned NOT NULL default '0',
  `base_val` mediumint(7) unsigned NOT NULL default '0',
  `max_val` mediumint(7) unsigned NOT NULL default '0',
  `skill_delta` mediumint(7) NOT NULL default '0',
  `skill_delta2` mediumint(7) NOT NULL default '0',
  `display_min` tinyint(3) unsigned NOT NULL default '0',
  `display_max` tinyint(3) unsigned NOT NULL default '0',
  `unknown` tinyint(3) unsigned NOT NULL default '0',
  `data_version` smallint(5) unsigned NOT NULL default '0',
  `log_file` varchar(250) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;