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.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.ts')
| -rw-r--r-- | server/models/account/account.ts | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/server/models/account/account.ts b/server/models/account/account.ts index 3ff59887d..2eed66fc2 100644 --- a/server/models/account/account.ts +++ b/server/models/account/account.ts | |||
| @@ -46,7 +46,19 @@ import { UserModel } from './user' | |||
| 46 | ] | 46 | ] |
| 47 | }) | 47 | }) |
| 48 | @Table({ | 48 | @Table({ |
| 49 | tableName: 'account' | 49 | tableName: 'account', |
| 50 | indexes: [ | ||
| 51 | { | ||
| 52 | fields: [ 'actorId' ], | ||
| 53 | unique: true | ||
| 54 | }, | ||
| 55 | { | ||
| 56 | fields: [ 'applicationId' ] | ||
| 57 | }, | ||
| 58 | { | ||
| 59 | fields: [ 'userId' ] | ||
| 60 | } | ||
| 61 | ] | ||
| 50 | }) | 62 | }) |
| 51 | export class AccountModel extends Model<AccountModel> { | 63 | export class AccountModel extends Model<AccountModel> { |
| 52 | 64 | ||