Code: Select all

/*
SQLyog Community Edition- MySQL GUI v5.30
Host - 5.0.27 : Database - eq2
*********************************************************************
Server version : 5.0.27
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `npcs` */

DROP TABLE IF EXISTS `npcs`;

CREATE TABLE `npcs` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(64) NOT NULL default '',
  `min_level` tinyint(3) unsigned NOT NULL default '0',
  `max_level` tinyint(3) unsigned NOT NULL default '0',
  `enc_level` tinyint(3) unsigned NOT NULL default '0',
  `race` tinyint(3) unsigned NOT NULL default '0',
  `race_type` smallint(5) unsigned NOT NULL default '0',
  `class_` tinyint(3) unsigned NOT NULL default '0',
  `gender` tinyint(3) unsigned NOT NULL default '0',
  `min_group_size` tinyint(3) unsigned NOT NULL default '0',
  `max_group_size` tinyint(3) unsigned NOT NULL default '0',
  `show_name` tinyint(3) unsigned NOT NULL default '1',
  `attackable` tinyint(3) unsigned NOT NULL default '1',
  `show_level` tinyint(3) unsigned NOT NULL default '1',
  `targetable` tinyint(3) unsigned NOT NULL default '1',
  `show_command_icon` tinyint(3) unsigned NOT NULL default '1',
  `display_hand_icon` tinyint(3) unsigned NOT NULL default '0',
  `command_list_type` varchar(32) NOT NULL default '',
  `command_list_subtype` varchar(32) NOT NULL default '',
  `faction_id` int(10) unsigned NOT NULL default '0',
  `hair_type_id` smallint(5) unsigned NOT NULL default '0',
  `facial_hair_type_id` smallint(5) unsigned NOT NULL default '0',
  `wing_type_id` smallint(5) unsigned NOT NULL default '0',
  `chest_type_id` smallint(5) unsigned NOT NULL default '0',
  `legs_type_id` smallint(5) unsigned NOT NULL default '0',
  `soga_hair_type_id` smallint(5) unsigned NOT NULL default '0',
  `soga_facial_hair_type_id` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the table `npcs` */

insert  into `npcs`(`id`,`name`,`min_level`,`max_level`,`enc_level`,`race`,`race_type`,`class_`,`gender`,`min_group_size`,`max_group_size`,`show_name`,`attackable`,`show_level`,`targetable`,`show_command_icon`,`display_hand_icon`,`command_list_type`,`command_list_subtype`,`faction_id`,`hair_type_id`,`facial_hair_type_id`,`wing_type_id`,`chest_type_id`,`legs_type_id`,`soga_hair_type_id`,`soga_facial_hair_type_id`) values (1,'Captain Varlos',2,2,3,9,134,33,1,0,0,1,1,1,1,1,0,'NPC','DEFAULT',0,1126,1166,0,5533,5534,1126,1166);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;