openstack
/
glance
Code Issues Proposed changes

Insure that migration 6 retains deleted image property index. 

Migration 6 for sqlite deletes the entire table and then recreates it,
however it fails to create the image_properties deleted index.

Fixes bug: 1051123

Change-Id: I4740ff1d5b9ec44067e6af7dd822329105222690
This commit is contained in:
John Bresnahan 2013-03-07 13:48:22 -10:00
parent df7d9c7171
commit 03c5a98b22
1 changed files with 1 additions and 0 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

1
glance/db/sqlalchemy/migrate_repo/versions/006_sqlite_upgrade.sql
View File

@ -37,6 +37,7 @@ CREATE TABLE image_properties (
FOREIGN KEY(image_id) REFERENCES images (id)
);
CREATE INDEX ix_image_properties_name ON image_properties (name);
CREATE INDEX ix_image_properties_deleted ON image_properties (deleted);
INSERT INTO image_properties (id, image_id, name, value, created_at, updated_at, deleted_at, deleted)
SELECT id, image_id, name, value, created_at, updated_at, deleted_at, deleted