import { type MigrationExecutor } from '../pg-migrator';

export default {
  name: '2021-04-30T11-47-26.validation.sql',
  run: ({ sql }) => sql`
--validation (up)
ALTER TABLE
  targets
ADD COLUMN
  validation_enabled BOOLEAN NOT NULL DEFAULT FALSE;

ALTER TABLE
  targets
ADD COLUMN
  validation_period SMALLINT NOT NULL DEFAULT 30;

ALTER TABLE
  targets
ADD COLUMN
  validation_percentage FLOAT NOT NULL DEFAULT 0.00;
`,
} satisfies MigrationExecutor;
