/**
 * @type {import('node-pg-migrate').ColumnDefinitions | undefined}
 */
export const shorthands = undefined;

/**
 * @param pgm {import('node-pg-migrate').MigrationBuilder}
 * @param run {() => void | undefined}
 * @returns {Promise<void> | void}
 */
export const up = (pgm) => {
  // 添加缺失的 peak_magnitude 列到 validated_events 表
  pgm.addColumns('validated_events', {
    peak_magnitude: { 
      type: 'decimal(4,2)', 
      notNull: false,
      comment: 'Peak magnitude of the meteor event'
    }
  });
};

/**
 * @param pgm {import('node-pg-migrate').MigrationBuilder}
 * @param run {() => void | undefined}
 * @returns {Promise<void> | void}
 */
export const down = (pgm) => {
  pgm.dropColumns('validated_events', ['peak_magnitude']);
};