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

10 lines
333 B
MySQL
Raw Permalink Normal View History

2020-05-20 03:55:23 +00:00
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);
2020-05-20 04:01:01 +00:00
UPDATE os_images SET deprecated = TRUE WHERE id = 'openbsd66';
UPDATE schemaversion SET version = 3;