17 lines
901 B
SQL
17 lines
901 B
SQL
-- 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';
|