Provide unique constraints on all tables

Registered by Yuriy Zveryanskyy

- 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.

Blueprint information

Status:
Not started
Approver:
None
Priority:
Undefined
Drafter:
None
Direction:
Approved
Assignee:
Yuriy Zveryanskyy
Definition:
New
Series goal:
None
Implementation:
Unknown
Milestone target:
None

Related branches

Sprints

Whiteboard

I think this approach makes sense for making soft-deletion work better and to allow admins to re-use image ids. Is anyone actively working on this blueprint?
markwash more-info 2014-02-15
markwash wishlist 2014-03-03

(?)

Work Items

Dependency tree

* Blueprints in grey have been implemented.

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.