Skip to content

Instantly share code, notes, and snippets.

@Goatform

Goatform/char_phase_updates_1

Created April 10, 2015 20:43
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Goatform/afb4224f5581002504f8 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Goatform/afb4224f5581002504f8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
char_phase_updates_1
ALTER TABLE `corpse` DROP `phaseMask`;
DROP TABLE IF EXISTS `corpse_phases`;
CREATE TABLE `corpse_phases` (
`Guid` int(10) unsigned NOT NULL,
`PhaseId` int(10) unsigned NOT NULL,
`OwnerGuid` int(10) unsigned NOT NULL,
`Time` int(10) unsigned NOT NULL DEFAULT '0',
`CorpseType` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`Guid`,`PhaseId`)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment