alert_channels: it should also be a pkey

backend/src/appenlight/migrations/versions/e9fcfbdd9498_connect_resources_to_alert_channels.py

@@ -1,30 +1,32 b''
 """connect resources to alert_channels
 
 Revision ID: e9fcfbdd9498
 Revises: 55b6e612672f
 Create Date: 2018-02-28 13:52:50.717217
 
 """
 
 # revision identifiers, used by Alembic.
 revision = 'e9fcfbdd9498'
 down_revision = '55b6e612672f'
 
 from alembic import op
 import sqlalchemy as sa
 
 
 def upgrade():
     op.create_table(
         '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)
     )
 
 
 def downgrade():
     op.drop_table('channels_resources')