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

10 lines
682 B
SQL

UPDATE os_images SET deprecated = TRUE WHERE id = 'ubuntu18';
INSERT INTO os_images (id, template_image_file_name, description, deprecated) VALUES ('ubuntu20', 'ubuntu20.img', 'Ubuntu 20.04 LTS (Fossa)', FALSE);
UPDATE os_images SET template_image_file_name = 'alpine311.img' WHERE id = 'alpine311';
UPDATE os_images SET template_image_file_name = 'openbsd67.img' WHERE id = 'openbsd67';
UPDATE os_images SET template_image_file_name = 'debian10.img' WHERE id = 'debian10';
UPDATE os_images SET template_image_file_name = 'centos7.img' WHERE id = 'centos7';
UPDATE os_images SET template_image_file_name = 'centos8.img' WHERE id = 'centos8';
UPDATE schemaversion SET version = 6;