diff options
| author | Chocobozzz <me@florianbigard.com> | 2018-07-23 20:13:30 +0200 |
|---|---|---|
| committer | Chocobozzz <me@florianbigard.com> | 2018-07-24 14:04:05 +0200 |
| commit | 8cd72bd37724054f8942f2fefc7aa2e60eca74cf (patch) | |
| tree | f2ed8da2a5a804286335156283659e9eaec5291a /server/models/account/account-video-rate.ts | |
| parent | 5bcfd02974389e1a131496d22f4321a79bed0fbb (diff) | |
| download | PeerTube-8cd72bd37724054f8942f2fefc7aa2e60eca74cf.tar.gz PeerTube-8cd72bd37724054f8942f2fefc7aa2e60eca74cf.tar.zst PeerTube-8cd72bd37724054f8942f2fefc7aa2e60eca74cf.zip | |
Optimize SQL queries
Diffstat (limited to 'server/models/account/account-video-rate.ts')
| -rw-r--r-- | server/models/account/account-video-rate.ts | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/server/models/account/account-video-rate.ts b/server/models/account/account-video-rate.ts index 9c19ec748..c99e32012 100644 --- a/server/models/account/account-video-rate.ts +++ b/server/models/account/account-video-rate.ts | |||
| @@ -17,6 +17,15 @@ import { ActorModel } from '../activitypub/actor' | |||
| 17 | { | 17 | { |
| 18 | fields: [ 'videoId', 'accountId' ], | 18 | fields: [ 'videoId', 'accountId' ], |
| 19 | unique: true | 19 | unique: true |
| 20 | }, | ||
| 21 | { | ||
| 22 | fields: [ 'videoId' ] | ||
| 23 | }, | ||
| 24 | { | ||
| 25 | fields: [ 'accountId' ] | ||
| 26 | }, | ||
| 27 | { | ||
| 28 | fields: [ 'videoId', 'type' ] | ||
| 20 | } | 29 | } |
| 21 | ] | 30 | ] |
| 22 | }) | 31 | }) |