3
CREATE TEMPORARY TABLE volumes_backup (
11
project_id VARCHAR(255),
14
availability_zone VARCHAR(255),
16
mountpoint VARCHAR(255),
17
attach_time VARCHAR(255),
19
attach_status VARCHAR(255),
20
scheduled_at DATETIME,
22
terminated_at DATETIME,
23
display_name VARCHAR(255),
24
display_description VARCHAR(255),
25
provider_location VARCHAR(256),
26
provider_auth VARCHAR(256),
28
CHECK (deleted IN (0, 1)),
29
FOREIGN KEY(instance_id) REFERENCES instances (id)
32
INSERT INTO volumes_backup
60
CREATE TABLE volumes (
68
project_id VARCHAR(255),
71
availability_zone VARCHAR(255),
73
mountpoint VARCHAR(255),
74
attach_time VARCHAR(255),
76
attach_status VARCHAR(255),
77
scheduled_at DATETIME,
79
terminated_at DATETIME,
80
display_name VARCHAR(255),
81
display_description VARCHAR(255),
83
CHECK (deleted IN (0, 1)),
84
FOREIGN KEY(instance_id) REFERENCES instances (id)
111
DROP TABLE volumes_backup;