-- Aurora 4X expanded traits import (SQLite)
-- Source: https://aurora4x.com/t/expanding-the-trait-list/764/1
-- Author: rom8n; original post revision 5.
-- Source updated: 2026-10-10T17:02:33.615Z; retrieved: 2026-10-13.
--
-- Close Aurora and back up AuroraDB.db before applying this file.
-- Open AuroraDB.db in a SQLite editor and execute this entire file.
-- If your editor holds pending changes, save/commit them afterward.
-- The actual table name is DIM_TraitsList (plural Traits).
-- Main table: 182 rows, in the order of the original post.
-- With the existing 148 traits and sequence=148, these receive IDs 149-330.
-- The source lists 'Measured' in BOTH groups 3 and 5; both are preserved.
-- The separate community suggestions are excluded.
--
-- TraitID is an INTEGER PRIMARY KEY AUTOINCREMENT in the verified schema.
-- Omitting it appends after the highest allocated ID without overwriting rows.
-- Existing matching (GroupID, Name) pairs are skipped, ignoring name case.
-- Thus rerunning this file adds no duplicates; different groups stay distinct.
-- All additions occur in a single atomic INSERT statement. This script does
-- not change existing traits, trait groups, or commander assignments.

WITH proposed (SortOrder, GroupID, Name) AS (
    VALUES
    (1, 1, 'Dismissive'),
    (2, 1, 'Condescending'),
    (3, 1, 'Unapproachable'),
    (4, 1, 'Resentful of Authority'),
    (5, 1, 'Territorially Minded'),
    (6, 1, 'Self-righteous'),
    (7, 1, 'Unnecessarily Blunt'),
    (8, 1, 'Micromanager'),
    (9, 1, 'Holds Grudges'),
    (10, 1, 'Poor Listener'),
    (11, 1, 'Tactless'),
    (12, 1, 'Resistant to Feedback'),
    (13, 1, 'Pedantic'),
    (14, 1, 'Inflated Sense of Duty'),
    (15, 1, 'Excessively Formal'),
    (16, 1, 'Bureaucratic'),
    (17, 1, 'Credit-Hungry'),
    (18, 1, 'Overly Critical'),
    (19, 1, 'Dour'),
    (20, 1, 'Irritable'),
    (21, 1, 'Bossy'),
    (22, 1, 'Easily Disgusted'),
    (23, 1, 'Abrasive'),
    (24, 1, 'Entitled'),
    (25, 1, 'Withholding'),
    (26, 1, 'Thin-skinned'),
    (27, 1, 'Humorless'),
    (28, 1, 'Joyless'),
    (29, 1, 'Inscrutable'),
    (30, 1, 'Cynic'),
    (31, 1, 'Lone Wolf'),
    (32, 1, 'Ethical'),
    (33, 2, 'Chess Player'),
    (34, 2, 'Distance Runner'),
    (35, 2, 'Voracious Reader'),
    (36, 2, 'Night Owl'),
    (37, 2, 'Early Riser'),
    (38, 2, 'Multilingual'),
    (39, 2, 'Minimalist'),
    (40, 2, 'Collector'),
    (41, 2, 'Fitness Enthusiast'),
    (42, 2, 'Poker Player'),
    (43, 2, 'Politically Connected'),
    (44, 2, 'Well-Traveled'),
    (45, 2, 'Polymath'),
    (46, 2, 'Ambidextrous'),
    (47, 2, 'Technophile'),
    (48, 2, 'Technophobe'),
    (49, 2, 'Chronic Pain'),
    (50, 2, 'Insomnia'),
    (51, 2, 'Colorblind'),
    (52, 2, 'Photographic Memory'),
    (53, 2, 'Synesthesia'),
    (54, 2, 'Prosthetic'),
    (55, 2, 'Tinkerer'),
    (56, 2, 'Media Buff'),
    (57, 2, 'Talented Writer'),
    (58, 2, 'Famous'),
    (59, 2, 'Sports Fan'),
    (60, 2, 'Gardener'),
    (61, 2, 'Gamer'),
    (62, 2, 'Self-made'),
    (63, 2, 'Political Exile'),
    (64, 2, 'Hard of Hearing'),
    (65, 2, 'Exceptional Physique'),
    (66, 2, 'Keeps Journal'),
    (67, 2, 'Criminal Upbringing'),
    (68, 2, 'Eccentric'),
    (69, 2, 'Seductive'),
    (70, 3, 'Empathetic'),
    (71, 3, 'Level-headed'),
    (72, 3, 'Collaborative'),
    (73, 3, 'Transparent'),
    (74, 3, 'Self-aware'),
    (75, 3, 'Diplomatic'),
    (76, 3, 'Loyal'),
    (77, 3, 'Nurturing'),
    (78, 3, 'Steadfast'),
    (79, 3, 'Patient Teacher'),
    (80, 3, 'Quick Learner'),
    (81, 3, 'Constructive'),
    (82, 3, 'Detail-oriented'),
    (83, 3, 'Proactive'),
    (84, 3, 'Resilient'),
    (85, 3, 'Tactful'),
    (86, 3, 'Equitable'),
    (87, 3, 'Gracious'),
    (88, 3, 'Sharp Instincts'),
    (89, 3, 'Composed'),
    (90, 3, 'Measured'),
    (91, 3, 'Accountable'),
    (92, 3, 'Counselor'),
    (93, 3, 'Reformer'),
    (94, 3, 'Curious'),
    (95, 3, 'Generous'),
    (96, 3, 'Gregarious'),
    (97, 3, 'Charismatic'),
    (98, 3, 'Even-tempered'),
    (99, 3, 'Forgiving'),
    (100, 3, 'Incorruptible'),
    (101, 3, 'Devout'),
    (102, 3, 'Principled'),
    (103, 3, 'Prankster'),
    (104, 4, 'Tenacious'),
    (105, 4, 'Relentless'),
    (106, 4, 'Competitive'),
    (107, 4, 'Initiative-taker'),
    (108, 4, 'Opportunistic'),
    (109, 4, 'Confrontational'),
    (110, 4, 'Demanding'),
    (111, 4, 'Self-starter'),
    (112, 4, 'Uncompromising'),
    (113, 4, 'Assertive'),
    (114, 4, 'Domineering'),
    (115, 4, 'Iron-willed'),
    (116, 4, 'Cutthroat'),
    (117, 4, 'Instinct-driven'),
    (118, 4, 'Forceful'),
    (119, 4, 'Thrill Seeker'),
    (120, 4, 'Agitator'),
    (121, 4, 'Firebrand'),
    (122, 4, 'Brazen'),
    (123, 4, 'Iron Hand'),
    (124, 4, 'Headstrong'),
    (125, 4, 'Unyielding'),
    (126, 4, 'Provocateur'),
    (127, 4, 'Glory-seeker'),
    (128, 4, 'Audacious'),
    (129, 5, 'Deliberate'),
    (130, 5, 'Hesitant'),
    (131, 5, 'Overcautious'),
    (132, 5, 'Slow to Commit'),
    (133, 5, 'Measured'),
    (134, 5, 'Non-confrontational'),
    (135, 5, 'Data-driven'),
    (136, 5, 'Traditionalist'),
    (137, 5, 'Fatalistic'),
    (138, 5, 'Private'),
    (139, 5, 'Picky Eater'),
    (140, 5, 'Strange Diet'),
    (141, 5, 'Low-profile'),
    (142, 5, 'Technocrat'),
    (143, 5, 'Grounded'),
    (144, 5, 'Introspective'),
    (145, 5, 'Stoic'),
    (146, 5, 'Far-sighted'),
    (147, 5, 'Calculating'),
    (148, 5, 'Planner'),
    (149, 5, 'Tactical'),
    (150, 5, 'Content'),
    (151, 5, 'Temperate'),
    (152, 5, 'Perceptive'),
    (153, 6, 'Vindictive'),
    (154, 6, 'Manipulative'),
    (155, 6, 'Self-serving'),
    (156, 6, 'Reckless'),
    (157, 6, 'Volatile'),
    (158, 6, 'Nihilistic'),
    (159, 6, 'Impulsive'),
    (160, 6, 'Defeatist'),
    (161, 6, 'Contemptuous'),
    (162, 6, 'Petty'),
    (163, 6, 'Sycophantic'),
    (164, 6, 'Obsessive'),
    (165, 6, 'Fame-seeker'),
    (166, 6, 'Juvenile'),
    (167, 6, 'Pollyanna'),
    (168, 6, 'Apocalyptic'),
    (169, 6, 'Careless'),
    (170, 6, 'Conspiracy Theorist'),
    (171, 6, 'Indulgent'),
    (172, 6, 'Sadistic'),
    (173, 6, 'Shy'),
    (174, 6, 'Self-destructive'),
    (175, 6, 'Martyr'),
    (176, 6, 'Furtive'),
    (177, 6, 'Demagogue'),
    (178, 6, 'Fanatic'),
    (179, 6, 'Exploitative'),
    (180, 6, 'Greedy'),
    (181, 6, 'Sociopath'),
    (182, 6, 'Corrupt')
)
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;

-- First run on the checked database: 182 inserted; rerun: 0 inserted.
SELECT changes() AS TraitsInserted,
       COUNT(*) AS TotalTraits,
       MAX(TraitID) AS HighestTraitID
FROM DIM_TraitsList;