/* eslint-disable */
/** 评估有效期：默认 6 个月，到期可一键复评。 */

exports.up = (pgm) => {
  pgm.sql(`ALTER TABLE assessments ADD COLUMN IF NOT EXISTS expires_at TIMESTAMPTZ;`);
  pgm.sql(`UPDATE assessments SET expires_at = saved_at + INTERVAL '6 months' WHERE expires_at IS NULL;`);
  pgm.sql(`CREATE INDEX IF NOT EXISTS idx_assessments_expires ON assessments(expires_at);`);
};

exports.down = (pgm) => {
  pgm.sql(`DROP INDEX IF EXISTS idx_assessments_expires;`);
  pgm.sql(`ALTER TABLE assessments DROP COLUMN IF EXISTS expires_at;`);
};