old_contents: #
  # This file is part of Invenio.
  # Copyright (C) 2022 CERN.
  #
  # Invenio is free software; you can redistribute it and/or modify it
  # under the terms of the MIT License; see LICENSE file for more details.
  
  """Create UserIdentity table."""
  
  import sqlalchemy as sa
  from alembic import op
  
  # revision identifiers, used by Alembic.
  revision = '62efc52773d4'
  down_revision = 'dfbdf43a3e96'
  branch_labels = ()
  depends_on = None
  
  
  def upgrade():
      """Upgrade database."""
      op.create_table(
          'accounts_useridentity',
          sa.Column('created', sa.DateTime(), nullable=False),
          sa.Column('updated', sa.DateTime(), nullable=False),
          sa.Column('id', sa.String(length=255), nullable=False),
          sa.Column('method', sa.String(length=255), nullable=False),
          sa.Column('id_user', sa.Integer(), nullable=False),
          sa.ForeignKeyConstraint(
              ['id_user'],
              ['accounts_user.id'],
              name=op.f('fk_accounts_useridentity_id_user_accounts_user')
          ),
          sa.PrimaryKeyConstraint(
              'id',
              'method',
              name=op.f('pk_accounts_useridentity')
          )
      )
      op.create_index(
          'accounts_useridentity_id_user_method',
          'accounts_useridentity',
          ['id_user', 'method'],
          unique=True
      )
  
  
  def downgrade():
      """Downgrade database."""
      op.drop_index(
          'accounts_useridentity_id_user_method',
          table_name='accounts_useridentity'
      )
      op.drop_table('accounts_useridentity')
  
new_contents: #
  # This file is part of Invenio.
  # Copyright (C) 2022 CERN.
  #
  # Invenio is free software; you can redistribute it and/or modify it
  # under the terms of the MIT License; see LICENSE file for more details.
  
  """Create UserIdentity table."""
  
  import sqlalchemy as sa
  from alembic import op
  
  # revision identifiers, used by Alembic.
  revision = '62efc52773d4'
  down_revision = 'dfbdf43a3e96'
  branch_labels = ()
  depends_on = None
  
  
  def upgrade():
      """Upgrade database."""
      op.create_table(
          'accounts_useridentity',
          sa.Column('created', sa.DateTime(), nullable=False),
          sa.Column('updated', sa.DateTime(), nullable=False),
          sa.Column('id', sa.String(length=255), nullable=False),
          sa.Column('method', sa.String(length=255), nullable=False),
          sa.Column('id_user', sa.Integer(), nullable=False),
          sa.ForeignKeyConstraint(
              ['id_user'],
              ['accounts_user.id'],
              name=op.f('fk_accounts_useridentity_id_user_accounts_user')
          ),
          sa.PrimaryKeyConstraint(
              'id',
              'method',
              name=op.f('pk_accounts_useridentity')
          )
      )
      op.create_index(
          'accounts_useridentity_id_user_method',
          'accounts_useridentity',
          ['id_user', 'method'],
          unique=True
      )
  
  
  def downgrade():
      """Downgrade database."""
      op.drop_table('accounts_useridentity')
  
subject: fix migration for oauthclient