capsul-flask/capsulflask/schema_migrations/03_up_openbsd67.sql

10 lines
333 B
SQL

ALTER TABLE os_images
ADD COLUMN deprecated BOOLEAN NOT NULL DEFAULT FALSE;
INSERT INTO os_images (id, template_image_file_name, description, deprecated)
VALUES ('openbsd67', 'openbsd-6.7-x86_64.qcow2', 'OpenBSD 6.7', FALSE);
UPDATE os_images SET deprecated = TRUE WHERE id = 'openbsd66';
UPDATE schemaversion SET version = 3;