debian-koji/schemas/schema-upgrade-1.8-1.9.sql
2023-09-13 12:17:10 +02:00

16 lines
619 B
PL/PgSQL

BEGIN;
-- new archive types
insert into archivetypes (name, description, extensions) values ('vmdk', 'vSphere image', 'vmdk');
insert into archivetypes (name, description, extensions) values ('ova', 'OVA image', 'ova');
insert into archivetypes (name, description, extensions) values ('ks', 'Kickstart', 'ks');
insert into archivetypes (name, description, extensions) values ('cfg', 'Configuration file', 'cfg');
COMMIT;
BEGIN;
-- it's harmless if this part fails.
-- there shouldn't be any references to this, but keep it in a separate transaction just in case
delete from archivetypes where name = 'vmx';
COMMIT;