Server: add unique to unique indexes

3 files changed, 10 insertions, 3 deletions

diff --git a/server/models/author.js b/server/models/author.js
index 7d15fb6ec..f036193c8 100644
--- a/server/models/author.js
+++ b/server/models/author.js
@@ -25,7 +25,12 @@ module.exports = function (sequelize, DataTypes) {
           fields: [ 'podId' ]
         },
         {
-          fields: [ 'userId' ]
+          fields: [ 'userId' ],
+          unique: true
+        },
+        {
+          fields: [ 'name', 'podId' ],
+          unique: true
         }
       ],
       classMethods: {
diff --git a/server/models/pod.js b/server/models/pod.js
index 6ae4b0999..575ebbc61 100644
--- a/server/models/pod.js
+++ b/server/models/pod.js
@@ -41,7 +41,8 @@ module.exports = function (sequelize, DataTypes) {
     {
       indexes: [
         {
-          fields: [ 'host' ]
+          fields: [ 'host' ],
+          unique: true
         },
         {
           fields: [ 'score' ]
diff --git a/server/models/user.js b/server/models/user.js
index 36ed723cc..6cb9eec3f 100644
--- a/server/models/user.js
+++ b/server/models/user.js
@@ -40,7 +40,8 @@ module.exports = function (sequelize, DataTypes) {
     {
       indexes: [
         {
-          fields: [ 'username' ]
+          fields: [ 'username' ],
+          unique: true
         }
       ],
       classMethods: {