1 ALTER TABLE `game_corpse`
4 CREATE TABLE `corpse_grid` (
5 `guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
6 `position_x` int(11) NOT NULL default '0',
7 `position_y` int(11) NOT NULL default '0',
8 `cell_position_x` int(11) NOT NULL default '0',
9 `cell_position_y` int(11) NOT NULL default '0',
10 `grid` int(11) unsigned NOT NULL default '0' COMMENT 'Grid Identifier',
11 `cell` int(11) unsigned NOT NULL default '0' COMMENT 'Cell Identifier',
12 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
13 UNIQUE KEY `idx_search` (`grid`,`cell`,`map`)
14 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Grid System';