-- Dragon Legacy teaching NPC. Spawned next to the existing Deputy Willem (entry 823, Northshire Valley)
-- as a safe, verified-walkable placeholder location -- relocate with `.npc move` once the module is live.
DELETE FROM `creature_template` WHERE `entry` = 901000;
INSERT INTO `creature_template`
    (`entry`, `name`, `subname`, `minlevel`, `maxlevel`, `faction`, `npcflag`,
     `speed_walk`, `speed_run`, `unit_class`, `type`, `RegenHealth`, `ScriptName`)
VALUES
    (901000, 'Aerion Dragonspeaker', 'Dragon Legacy', 30, 30, 12, 1,
     1, 1.14286, 1, 7, 1, 'DragonLegacy_NPC');

DELETE FROM `creature_template_model` WHERE `CreatureID` = 901000;
INSERT INTO `creature_template_model`
    (`CreatureID`, `Idx`, `CreatureDisplayID`, `DisplayScale`, `Probability`)
VALUES
    (901000, 0, 2072, 1, 1);

DELETE FROM `creature` WHERE `id` = 901000;
INSERT INTO `creature`
    (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`)
VALUES
    (901000, 0, 1, 1, -8950.64, -132.319, 83.7199, 3.33358, 300);

DELETE FROM `npc_text` WHERE `ID` = 901000;
INSERT INTO `npc_text` (`ID`, `text0_0`) VALUES (901000, 'Do you seek the way of the dragon?');