diff --git a/backend/src/appenlight/migrations/versions/e9fcfbdd9498_connect_resources_to_alert_channels.py b/backend/src/appenlight/migrations/versions/e9fcfbdd9498_connect_resources_to_alert_channels.py
index 08599aa..d048267 100644
--- a/backend/src/appenlight/migrations/versions/e9fcfbdd9498_connect_resources_to_alert_channels.py
+++ b/backend/src/appenlight/migrations/versions/e9fcfbdd9498_connect_resources_to_alert_channels.py
@@ -19,10 +19,12 @@ def upgrade():
         'channels_resources',
         sa.Column('channel_pkey', sa.Integer,
                   sa.ForeignKey('alert_channels.pkey',
-                                ondelete='CASCADE', onupdate='CASCADE')),
+                                ondelete='CASCADE', onupdate='CASCADE'),
+                  primary_key=True),
         sa.Column('resource_id', sa.Integer,
                   sa.ForeignKey('resources.resource_id',
-                                ondelete='CASCADE', onupdate='CASCADE'))
+                                ondelete='CASCADE', onupdate='CASCADE'),
+                  primary_key=True)
     )