/* eslint-disable */
/** LLM 经验库：沉淀综合研判 + 人工修正后的最终结论，供后续 few-shot。 */

exports.up = (pgm) => {
  pgm.sql(`
    CREATE TABLE IF NOT EXISTS experience_library (
      id BIGSERIAL PRIMARY KEY,
      assessment_id TEXT NOT NULL,
      business_type TEXT NOT NULL,
      industry TEXT NOT NULL,
      project_summary TEXT NOT NULL,
      risk_grade TEXT,
      acceptability TEXT,
      recommendation_level TEXT,
      lesson TEXT NOT NULL,
      tags TEXT[] NOT NULL DEFAULT '{}',
      created_at TIMESTAMPTZ NOT NULL DEFAULT now()
    );
    CREATE INDEX IF NOT EXISTS idx_experience_biz ON experience_library(business_type);
    CREATE INDEX IF NOT EXISTS idx_experience_tags ON experience_library USING gin(tags);
  `);
};

exports.down = (pgm) => {
  pgm.sql(`DROP TABLE IF EXISTS experience_library;`);
};