2
CREATE TEMPORARY TABLE virtual_interfaces_backup (
11
instance_uuid VARCHAR(36),
16
INSERT INTO virtual_interfaces_backup
27
FROM virtual_interfaces;
29
UPDATE virtual_interfaces_backup
33
WHERE virtual_interfaces_backup.instance_id = instances.id
36
DROP TABLE virtual_interfaces;
38
CREATE TABLE virtual_interfaces (
46
instance_uuid VARCHAR(36) NOT NULL,
49
FOREIGN KEY(instance_uuid) REFERENCES instances (uuid)
52
CREATE INDEX virtual_interfaces_instance_uuid ON
53
virtual_interfaces(instance_uuid);
54
CREATE INDEX virtual_interfaces_network_id ON
55
virtual_interfaces(network_id);
57
INSERT INTO virtual_interfaces
67
FROM virtual_interfaces_backup;
69
DROP TABLE virtual_interfaces_backup;