3
CREATE TEMPORARY TABLE fixed_ips_backup (
6
virtual_interface_id INTEGER,
9
allocated BOOLEAN default FALSE,
10
leased BOOLEAN default FALSE,
11
reserved BOOLEAN default FALSE,
12
created_at DATETIME NOT NULL,
15
deleted BOOLEAN NOT NULL,
19
INSERT INTO fixed_ips_backup
20
SELECT id, address, virtual_interface_id, network_id, instance_id, allocated, leased, reserved, created_at, updated_at, deleted_at, deleted
25
CREATE TABLE fixed_ips (
28
virtual_interface_id INTEGER,
31
allocated BOOLEAN default FALSE,
32
leased BOOLEAN default FALSE,
33
reserved BOOLEAN default FALSE,
34
created_at DATETIME NOT NULL,
37
deleted BOOLEAN NOT NULL,
39
FOREIGN KEY(virtual_interface_id) REFERENCES virtual_interfaces (id)
43
SELECT id, address, virtual_interface_id, network_id, instance_id, allocated, leased, reserved, created_at, updated_at, deleted_at, deleted
46
DROP TABLE fixed_ips_backup;