Project

General

Profile

Actions
Copy link

Feature proposal #7619

closed

Implement additional unique indexes

Feature proposal #7619: Implement additional unique indexes

Added by krileon over 6 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
Normal
Assignee:
krileon
Target version:
6.0.0
Start date:
09 July 2019
Due date:
% Done:

100%

Estimated time:

Description

A unique index should be on the likes and follows tables for user id and asset. A user can't like or follow the same asset twice. This would further improve SQL performance, but migration code needs to be implemented to clean up the duplicates first before the index is made unique.

Actions
Copy link

Also available in: PDF Atom