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,
34
CHECK (deleted IN (0, 1))
37
INSERT INTO virtual_interfaces
38
SELECT created_at, updated_at, deleted_at, deleted, id, address,
39
network_id, instance_id, uuid
40
FROM virtual_interfaces_backup;
42
DROP TABLE virtual_interfaces_backup;