capsul-flask/capsulflask/schema_migrations/06_down_images_migration.sql

10 lines
705 B
SQL

UPDATE os_images SET deprecated = FALSE WHERE id = 'ubuntu18';
DELETE FROM os_images WHERE id = 'ubuntu20';
UPDATE os_images SET template_image_file_name = 'alpine-cloud-2020-04-18.qcow2' WHERE id = 'alpine311';
UPDATE os_images SET template_image_file_name = 'openbsd-6.7-x86_64.qcow2' WHERE id = 'openbsd67';
UPDATE os_images SET template_image_file_name = 'debian-10-genericcloud-amd64-20191117-80.qcow2' WHERE id = 'debian10';
UPDATE os_images SET template_image_file_name = 'CentOS-7-x86_64-GenericCloud.qcow2' WHERE id = 'centos7';
UPDATE os_images SET template_image_file_name = 'CentOS-8-GenericCloud-8.1.1911-20200113.3.x86_64.qcow2' WHERE id = 'centos8';
UPDATE schemaversion SET version = 5;