1_LocaleTablePrepare.sql

-- This script can be run of either an empty table or on a table with entries
-- It will only add entries in the locale table for tables which are missing

-- Create the Locales base entries from main table
INSERT INTO `locales_command` (`id`)  SELECT `id` FROM `command` WHERE `id` NOT IN (SELECT `id` FROM `locales_command`);

-- Create the Locales base entries from main table
INSERT INTO `locales_creature` (`entry`) SELECT `entry` FROM `creature_template` WHERE `entry` NOT IN (SELECT `entry` FROM `locales_creature`);

-- Create the Locales base entries from main table
INSERT INTO `locales_gameobject` (`entry`) SELECT `entry` FROM `gameobject_template` WHERE `entry` NOT IN (SELECT `entry` FROM `locales_gameobject`);

-- Create the Locales base entries from main table
INSERT INTO `locales_gossip_menu_option` (`menu_id`,`id`) SELECT `menu_id`,`id` FROM `gossip_menu_option` WHERE `gossip_menu_option`.`menu_id` NOT IN (SELECT `menu_id` FROM `locales_gossip_menu_option`) AND `gossip_menu_option`.`id` NOT IN (SELECT `id` FROM `locales_gossip_menu_option`);

-- Create the Locales base entries from main table
INSERT INTO `locales_item` (`entry`) SELECT `entry` FROM `item_template` WHERE `entry` NOT IN (SELECT `entry` FROM `locales_item`);

-- Create the Locales base entries from main table
INSERT INTO `locales_npc_text` (`entry`) SELECT `ID` FROM `npc_text` WHERE `ID` NOT IN (SELECT `entry` FROM `locales_npc_text`);

-- Create the Locales base entries from main table
INSERT INTO `locales_page_text` (`entry`) SELECT `entry` FROM `page_text` WHERE `entry` NOT IN (SELECT `entry` FROM `locales_page_text`);

-- Create the Locales base entries from main table
INSERT INTO `locales_points_of_interest` (`entry`) SELECT `entry` FROM `points_of_interest` WHERE `entry` NOT IN (SELECT `entry` FROM `locales_points_of_interest`);

-- Create the Locales base entries from main table
INSERT INTO `locales_quest` (`entry`) SELECT `entry` FROM `quest_template` WHERE `entry` NOT IN (SELECT `entry` FROM `locales_quest`);

-- Create the Locales base entries from main table
INSERT IGNORE INTO `locales_achievement_reward` (`entry`,`gender`) SELECT `entry`,2 FROM `achievement_reward`;