3
CREATE TABLE instance_types_temp (
10
memory_mb INTEGER NOT NULL,
11
vcpus INTEGER NOT NULL,
12
root_gb INTEGER NOT NULL,
13
ephemeral_gb INTEGER NOT NULL,
14
swap INTEGER NOT NULL,
17
flavorid VARCHAR(255),
19
CHECK (deleted IN (0, 1))
21
INSERT INTO instance_types_temp SELECT
37
DROP TABLE instance_types;
38
ALTER TABLE instance_types_temp RENAME TO instance_types;
39
CREATE TABLE volume_types_temp (
47
CHECK (deleted IN (0, 1))
49
INSERT INTO volume_types_temp SELECT
57
DROP TABLE volume_types;
58
ALTER TABLE volume_types_temp RENAME TO volume_types;