3
CREATE TEMPORARY TABLE migrations_backup (
9
source_compute VARCHAR(255),
10
dest_compute VARCHAR(255),
11
dest_host VARCHAR(255),
14
old_flavor_id INTEGER,
15
new_flavor_id INTEGER,
17
CHECK (deleted IN (0, 1)),
18
FOREIGN KEY(instance_id) REFERENCES instances (id)
21
INSERT INTO migrations_backup
36
DROP TABLE migrations;
38
CREATE TABLE migrations (
44
source_compute VARCHAR(255),
45
dest_compute VARCHAR(255),
46
dest_host VARCHAR(255),
50
CHECK (deleted IN (0, 1)),
51
FOREIGN KEY(instance_id) REFERENCES instances (id)
54
INSERT INTO migrations
65
FROM migrations_backup;
67
DROP TABLE migrations_backup;