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
- Started by
- Completed by
Related branches
Related bugs
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.