-- Aurora 4X: 10 user-selected community traits (SQLite)
-- Exact nonblank selections supplied by the user on 2026-10-13.
-- Source context: https://aurora4x.com/t/expanding-the-trait-list/764/1
-- Uses the user's corrected spelling 'Elitist'.
--
-- Use this file if you already ran the original 182-row import.
-- The updated 01_import_expanded_traits.sql already includes these 10 rows.
-- Running both is safe: matching (GroupID, Name) pairs are skipped,
-- ignoring name case. No existing traits or commander assignments are changed.
-- After the original import ends at ID 330, these receive IDs 331-340.
-- Other existing custom traits cause IDs to continue after the current sequence.
--
-- Close Aurora and back up AuroraDB.db before applying this file.
-- Open AuroraDB.db in a SQLite editor and execute this entire file.
-- Save/commit any pending changes afterward. All 10 rows are inserted atomically.

WITH proposed (SortOrder, GroupID, Name) AS (
    VALUES
    (1, 2, 'Alcoholic'),
    (2, 2, 'Science Focus'),
    (3, 2, 'Engineering Background'),
    (4, 2, 'Historian'),
    (5, 2, 'Good hair'),
    (6, 6, 'Gambler'),
    (7, 2, 'Poor Posture'),
    (8, 1, 'Elitist'),
    (9, 3, 'Inspirational'),
    (10, 3, 'Protective')
)
INSERT INTO DIM_TraitsList (GroupID, Name)
SELECT p.GroupID, p.Name
FROM proposed AS p
WHERE NOT EXISTS (
    SELECT 1
    FROM DIM_TraitsList AS existing
    WHERE existing.GroupID = p.GroupID
      AND existing.Name = p.Name COLLATE NOCASE
)
ORDER BY p.SortOrder;

SELECT changes() AS TraitsInserted,
       COUNT(*) AS TotalTraits,
       MAX(TraitID) AS HighestTraitID
FROM DIM_TraitsList;