Server: Add postgresql indexes

[github/Chocobozzz/PeerTube.git] / server / models / requestToPod.js

diff --git a/server/models/requestToPod.js b/server/models/requestToPod.js
index 378c2bdcf6be85849e2eb4bf044147b767ec5bcf..f42a534586471ccdfda596d2dc0004c123bd2fe1 100644 (file)
--- a/server/models/requestToPod.js
+++ b/server/models/requestToPod.js
@@ -4,6 +4,18 @@
 
 module.exports = function (sequelize, DataTypes) {
   const RequestToPod = sequelize.define('RequestToPod', {}, {
+    indexes: [
+      {
+        fields: [ 'requestId' ]
+      },
+      {
+        fields: [ 'podId' ]
+      },
+      {
+        fields: [ 'requestId', 'podId' ],
+        unique: true
+      }
+    ],
     classMethods: {
       removePodOf
     }