-- revert record slug='archive' in table preferences_metadata to previous schema version 1.2
begin;

update "preferences_metadata"
set "schema" = 'object {
            boolean enabled;
            array [
              string [ "JSON", "XML" ];
            ] {1,2} data_format;
            string  default_archive_container_url?;
            object {
              string iad;
              string ord;
              string dfw;
              string lon;
              string hkg;
              string syd;
            } archive_container_urls?;
        };'
where "slug" = 'archive';

-- remove the flyway version 1.3
delete from "schema_version"
where "version" = '1.3';

end;

Add rollback script for schema V1.3
Add rollback script for schema V1.3
