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_uuid = instances.uuid
36
DROP TABLE virtual_interfaces;
38
CREATE TABLE virtual_interfaces (
46
instance_id VARCHAR(36) NOT NULL,
49
FOREIGN KEY(instance_id) REFERENCES instances (id)
52
CREATE INDEX virtual_interfaces_instance_id ON
53
virtual_interfaces(instance_id);
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;
b'\\ No newline at end of file'