1 ALTER TABLE character_db_version CHANGE COLUMN required_7251_02_characters_character_spell required_7255_01_characters_characters bit;
3 ALTER TABLE `characters`
4 ADD COLUMN `bgid` int(10) unsigned NOT NULL default '0' AFTER `arena_pending_points`,
5 ADD COLUMN `bgteam` int(10) unsigned NOT NULL default '0' AFTER `bgid`,
6 ADD COLUMN `bgmap` int(10) unsigned NOT NULL default '0' AFTER `bgteam`,
7 ADD COLUMN `bgx` float NOT NULL default '0' AFTER `bgmap`,
8 ADD COLUMN `bgy` float NOT NULL default '0' AFTER `bgx`,
9 ADD COLUMN `bgz` float NOT NULL default '0' AFTER `bgy`,
10 ADD COLUMN `bgo` float NOT NULL default '0' AFTER `bgz`;