-- Ehe: öffentliche Stabilität (Daemon-Drift). Hausfrieden: persistenter Spannungswert 0..100.
-- Siehe docs/FALUKANT_MARRIAGE_HOUSEPEACE_DAEMON_HANDOFF.md

ALTER TABLE falukant_data.relationship
    ADD COLUMN IF NOT EXISTS marriage_public_stability smallint NOT NULL DEFAULT 55
        CHECK (marriage_public_stability >= 0 AND marriage_public_stability <= 100);

COMMENT ON COLUMN falukant_data.relationship.marriage_public_stability IS
    'Öffentliche Ehe-Stabilität 0..100; Daily-Drift durch Daemon (Liebschaften, Haus, Stand)';

ALTER TABLE falukant_data.user_house
    ADD COLUMN IF NOT EXISTS household_tension_score smallint NOT NULL DEFAULT 0
        CHECK (household_tension_score >= 0 AND household_tension_score <= 100);

COMMENT ON COLUMN falukant_data.user_house.household_tension_score IS
    'Hausfrieden-Spannung 0..100 (Daemon); UI: low 0–24, medium 25–59, high 60–100';