/usr/share/pyshared/glance/registry/db/migrate_repo/versions/006_mysql_downgrade.sql is in python-glance 2012.1.3+stable~20120821-120fcf-0ubuntu1.5.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 | /*
* This file is necessary because MySQL does not support
* renaming indexes.
*/
DROP INDEX ix_image_properties_image_id_name ON image_properties;
/* Rename the `key` column to `name` */
ALTER TABLE image_properties
CHANGE COLUMN name `key` VARCHAR(255) NOT NULL;
CREATE UNIQUE INDEX ix_image_properties_image_id_key ON image_properties (image_id, key);
|