BEGIN; SET ROLE self_role; CREATE TABLE IF NOT EXISTS self.learning_signals ( signal_id TEXT PRIMARY KEY, principal_id TEXT NOT NULL, kind TEXT NOT NULL, task_pattern TEXT NOT NULL, scope_key TEXT NOT NULL, subject_ref JSONB NOT NULL, evidence_refs JSONB NOT NULL, expected_outcome TEXT NOT NULL DEFAULT '', actual_outcome TEXT NOT NULL DEFAULT '', dependency_refs JSONB NOT NULL DEFAULT '[]'::jsonb, environment_version TEXT NOT NULL DEFAULT '', observed_at_unix_millis BIGINT NOT NULL, severity INTEGER NOT NULL DEFAULT 0, user_impact INTEGER NOT NULL DEFAULT 0, correction_count INTEGER NOT NULL DEFAULT 0, decision_regret TEXT NOT NULL DEFAULT '' ); CREATE TABLE IF NOT EXISTS self.weakness_patterns ( assessment_id TEXT PRIMARY KEY, principal_id TEXT NOT NULL, revision BIGINT NOT NULL CHECK (revision > 0), pattern_key TEXT NOT NULL, task_pattern TEXT NOT NULL, scope_key TEXT NOT NULL, environment_version TEXT NOT NULL DEFAULT '', dependency_refs JSONB NOT NULL DEFAULT '[]'::jsonb, failure_mode TEXT NOT NULL, detection_evidence_refs JSONB NOT NULL, frequency INTEGER NOT NULL, last_observed_at_unix_millis BIGINT NOT NULL, severity INTEGER NOT NULL, affected_component TEXT NOT NULL, affected_strategy TEXT NOT NULL DEFAULT '', confidence_millis BIGINT NOT NULL, epistemic_status TEXT NOT NULL, state TEXT NOT NULL, recorded_at_unix_millis BIGINT NOT NULL ); CREATE TABLE IF NOT EXISTS self.improvement_candidates ( candidate_id TEXT PRIMARY KEY, principal_id TEXT NOT NULL, need_ref JSONB NOT NULL, hypothesis TEXT NOT NULL, expected_effect TEXT NOT NULL, evaluation_plan TEXT NOT NULL, must_not_worsen JSONB NOT NULL, rollback_plan TEXT NOT NULL, resource_cost TEXT NOT NULL, creator TEXT NOT NULL, independent_evaluator TEXT NOT NULL, state TEXT NOT NULL, evidence_refs JSONB NOT NULL, created_at_unix_millis BIGINT NOT NULL ); CREATE TABLE IF NOT EXISTS self.personal_benchmark_cases ( case_id TEXT PRIMARY KEY, principal_id TEXT NOT NULL, task_class TEXT NOT NULL, evidence_refs JSONB NOT NULL, recorded_at_unix_millis BIGINT NOT NULL ); GRANT SELECT, INSERT, UPDATE ON self.learning_signals, self.weakness_patterns, self.improvement_candidates, self.personal_benchmark_cases TO self_role; RESET ROLE; COMMIT;