2
CREATE TEMPORARY TABLE instance_metadata_backup (
8
instance_id INTEGER NOT NULL,
9
instance_uuid VARCHAR(36),
10
key VARCHAR(255) NOT NULL,
11
value VARCHAR(255) NOT NULL,
15
INSERT INTO instance_metadata_backup
25
FROM instance_metadata;
27
UPDATE instance_metadata_backup
31
WHERE instance_metadata_backup.instance_uuid = instances.uuid
34
DROP TABLE instance_metadata;
36
CREATE TABLE instance_metadata (
42
instance_id INTEGER NOT NULL,
43
key VARCHAR(255) NOT NULL,
44
value VARCHAR(255) NOT NULL,
46
FOREIGN KEY(instance_id) REFERENCES instances (id)
49
CREATE INDEX instance_metadata_instance_id_idx ON instance_metadata(instance_id);
51
INSERT INTO instance_metadata
60
FROM instance_metadata_backup;
62
DROP TABLE instance_metadata_backup;
b'\\ No newline at end of file'