from pathlib import Path
p=Path('/opt/struktur/social-media-agent/publish_ready.py'); s=p.read_text()
needle='''    CREATE INDEX IF NOT EXISTS idx_package_image_variants_package ON package_image_variants(package_id, variant_order);'''
insert='''    CREATE TABLE IF NOT EXISTS mas_experiences (
        experience_id TEXT PRIMARY KEY,
        title TEXT NOT NULL,
        content_pillar TEXT NOT NULL,
        source_type TEXT NOT NULL DEFAULT 'mas_experience',
        source_ref TEXT NOT NULL,
        original_case_id TEXT NOT NULL DEFAULT '',
        situation TEXT NOT NULL,
        technical_observation TEXT NOT NULL,
        finding TEXT NOT NULL,
        measured_values_json TEXT NOT NULL DEFAULT '{}',
        possible_cause TEXT NOT NULL DEFAULT '',
        measure_taken_or_recommended TEXT NOT NULL DEFAULT '',
        core_claim TEXT NOT NULL,
        allowed_claims_json TEXT NOT NULL DEFAULT '[]',
        fact_json TEXT NOT NULL DEFAULT '{}',
        inference_json TEXT NOT NULL DEFAULT '{}',
        unknown_json TEXT NOT NULL DEFAULT '{}',
        anonymization_status TEXT NOT NULL DEFAULT 'anonymized',
        evidence_status TEXT NOT NULL DEFAULT 'documented',
        usage_status TEXT NOT NULL DEFAULT 'available',
        canonical_key TEXT NOT NULL,
        created_at TEXT NOT NULL,
        updated_at TEXT NOT NULL
    );
    CREATE UNIQUE INDEX IF NOT EXISTS idx_mas_experiences_canonical ON mas_experiences(canonical_key);
    CREATE INDEX IF NOT EXISTS idx_mas_experiences_pillar ON mas_experiences(content_pillar);
    '''+needle
assert s.count(needle)==1; s=s.replace(needle,insert)
p.write_text(s); print('experience schema added to init_schema')