Atlas can't revert back data type that already changed

[afifurrohman-id]

Hello in my case i have table:

• my initial migration

  CREATE TABLE "prefix"."a" (yes smallint);

• 2nd migration (change smallint type to boolean)

  
  ALTER TABLE "prefix"."a" ADD COLUMN "yes_tmp" boolean;

-- Update the new tmp column with value converted to boolean from old column data UPDATE "prefix"."a" SET "yes_tmp" = CASE WHEN "yes" = 0 THEN FALSE ELSE TRUE END;

-- Drop the old column ALTER TABLE "prefix"."a" DROP COLUMN "yes";

-- Rename the new tmp column to old column name ALTER TABLE "prefix"."a" RENAME COLUMN "yes_tmp" TO "yes";

but in my case when i **revert** / **down** it can't cast back from `boolean` to `smallint` and atlas exit with that error

is there any solution?

[afifurrohman-id]

Hi @a8m also can i ask does atlas have concept called down migration file?

[afifurrohman-id]

Hi @a8m also can i ask does atlas have concept called down migration file?

okay my bad, based on this docs atlas use different approach: docs