ZiyektZ9

1/*
2MySQL Data Transfer
3Source Host: localhost
4Source Database: world
5Target Host: localhost
6Target Database: world
7Date: 5-1-2012 13:09:39
8*/
9
10SET FOREIGN_KEY_CHECKS=0;
11-- ----------------------------
12-- Table structure for creature_check_dupes_sniffs
13-- ----------------------------
14DROP TABLE IF EXISTS `creature_check_dupes_sniffs`;
15CREATE TABLE `creature_check_dupes_sniffs` (
16  `guid` int(10) DEFAULT NULL COMMENT 'Global Unique Identifier',
17  `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier',
18  `map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
19  `spawnMask` tinyint(3) unsigned NOT NULL DEFAULT '1',
20  `phaseMask` smallint(5) unsigned NOT NULL DEFAULT '1',
21  `position_x` float NOT NULL DEFAULT '0',
22  `position_y` float NOT NULL DEFAULT '0',
23  `position_z` float NOT NULL DEFAULT '0',
24  `orientation` float NOT NULL DEFAULT '0',
25  `spawntimesecs` int(10) unsigned NOT NULL DEFAULT '120',
26  `spawndist` float NOT NULL DEFAULT '0',
27  `MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0',
28  PRIMARY KEY (`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`),
29  KEY `idx_map` (`map`),
30  KEY `idx_id` (`id`)
31) ENGINE=MyISAM AUTO_INCREMENT=1022682 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature System';
32
33-- ----------------------------
34-- Records 
35-- ----------------------------