Bug 1041781 - [RFE][glance]: Provide unique constraints on all tables
Summary: [RFE][glance]: Provide unique constraints on all tables
Keywords:
Status: CLOSED UPSTREAM
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: RFEs
Version: unspecified
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
: ---
Assignee: RHOS Maint
QA Contact:
URL: https://blueprints.launchpad.net/glan...
Whiteboard: upstream_milestone_none upstream_stat...
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-12-12 19:17 UTC by RHOS Integration
Modified: 2015-03-19 16:59 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Enhancement
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-03-19 16:59:54 UTC
Target Upstream Version:

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

Description RHOS Integration 2013-12-12 19:17:43 UTC 
Cloned from launchpad blueprint https://blueprints.launchpad.net/glance/+spec/db-unique-keys.

Description:

- add unique indexes on  (`col`,`deleted`), and set `deleted`=`id` instead of `deleted`=1 after delete.
- handle duplicate key errors.
- add missing unique constraints to models.
-  add proper migrations.

Specification URL (additional information):

None
Note You need to log in before you can comment on or make changes to this bug.