diff --git a/priv/repo/migrations/20220205091136_add_unique_index_to_users_organisations.exs b/priv/repo/migrations/20220205091136_add_unique_index_to_users_organisations.exs
new file mode 100644
index 0000000..5528c98
--- /dev/null
+++ b/priv/repo/migrations/20220205091136_add_unique_index_to_users_organisations.exs
@@ -0,0 +1,7 @@
+defmodule Kmxgit.Repo.Migrations.AddUniqueIndexToUsersOrganisations do
+ use Ecto.Migration
+
+ def change do
+ create index(:users_organisations, [:user_id, :organisation_id], unique: true)
+ end
+end