1 ALTER TABLE `creature_template`
2 ADD COLUMN `InhabitType` tinyint(1) unsigned NOT NULL default '3' AFTER `MovementType`;
6 1 - can walk (or fly above ground)
7 2 - can swim (or fly above water)
8 3 (= 1 | 2) - can walk and swim (and fly)
11 UPDATE `creature_template`
12 SET `InhabitType` = 1 WHERE `family` > 0 AND `family` < 6 OR `family` = 8 OR `family` = 11 OR `family` > 14 AND `family` < 20 OR `family` = 25 OR `family` = 27;