2
CREATE TEMPORARY TABLE virtual_interfaces_backup (
10
instance_id INTEGER NOT NULL,
15
INSERT INTO virtual_interfaces_backup
16
SELECT created_at, updated_at, deleted_at, deleted, id, address,
17
network_id, instance_id, uuid
18
FROM virtual_interfaces;
20
DROP TABLE virtual_interfaces;
22
CREATE TABLE virtual_interfaces (
30
instance_id INTEGER NOT NULL,
33
FOREIGN KEY(network_id) REFERENCES networks (id),
35
CHECK (deleted IN (0, 1))
38
INSERT INTO virtual_interfaces
39
SELECT created_at, updated_at, deleted_at, deleted, id, address,
40
network_id, instance_id, uuid
41
FROM virtual_interfaces_backup;
43
DROP TABLE virtual_interfaces_backup;