Bug 1041639 - [RFE][cinder]: Provide unique constraints on all tables
Summary: [RFE][cinder]: 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
low
Target Milestone: ---
: ---
Assignee: RHOS Maint
QA Contact:
URL: https://blueprints.launchpad.net/cind...
Whiteboard: upstream_milestone_none upstream_stat...
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-12-12 18:26 UTC by RHOS Integration
Modified: 2016-02-02 05:05 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Enhancement
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-03-19 17:11:00 UTC
Target Upstream Version:

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

Description RHOS Integration 2013-12-12 18:26:14 UTC 
Cloned from launchpad blueprint https://blueprints.launchpad.net/cinder/+spec/db-unique-keys.

Description:

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


Specification URL (additional information):

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