3
CREATE TEMPORARY TABLE virtual_interfaces_backup (
11
instance_id INTEGER NOT NULL,
14
FOREIGN KEY(network_id) REFERENCES networks (id),
15
FOREIGN KEY(instance_id) REFERENCES instances (id),
17
CHECK (deleted IN (0, 1))
20
INSERT INTO virtual_interfaces_backup
30
FROM virtual_interfaces;
32
DROP TABLE virtual_interfaces;
34
CREATE TABLE virtual_interfaces (
42
instance_id INTEGER NOT NULL,
44
FOREIGN KEY(network_id) REFERENCES networks (id),
45
FOREIGN KEY(instance_id) REFERENCES instances (id),
47
CHECK (deleted IN (0, 1))
50
INSERT INTO virtual_interfaces
59
FROM virtual_interfaces_backup;
61
DROP TABLE virtual_interfaces_backup;