sql/old/3.1.3/04346_8098_world.sql


1
2
3
4
5
6
7
8
9
10

-- ALTER TABLE db_version CHANGE COLUMN required_8071_01_mangos_command required_8098_02_mangos_playercreateinfo_action bit;

ALTER TABLE playercreateinfo_action
  CHANGE COLUMN action action int(11) unsigned NOT NULL default '0';

UPDATE playercreateinfo_action
  SET action = action | ( misc << 16 );

ALTER TABLE playercreateinfo_action
    DROP COLUMN misc;