old_contents: # This file is part of Indico.
  # Copyright (C) 2002 - 2015 European Organization for Nuclear Research (CERN).
  #
  # Indico is free software; you can redistribute it and/or
  # modify it under the terms of the GNU General Public License as
  # published by the Free Software Foundation; either version 3 of the
  # License, or (at your option) any later version.
  #
  # Indico is distributed in the hope that it will be useful, but
  # WITHOUT ANY WARRANTY; without even the implied warranty of
  # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
  # General Public License for more details.
  #
  # You should have received a copy of the GNU General Public License
  # along with Indico; if not, see <http://www.gnu.org/licenses/>.
  
  from __future__ import unicode_literals
  
  from indico.core.db import db
  from indico.util.string import return_ascii
  
  
  class UserAffiliation(db.Model):
      __tablename__ = 'affiliations'
      __table_args__ = {'schema': 'users'}
  
      #: the unique id of the affiliations
      id = db.Column(
          db.Integer,
          primary_key=True
      )
      #: the id of the associated user
      user_id = db.Column(
          db.Integer,
          db.ForeignKey('users.users.id'),
          nullable=False,
          index=True
      )
      #: the affiliation
      name = db.Column(
          db.String,
          nullable=False,
          index=True
      )
  
      @return_ascii
      def __repr__(self):
          return '<UserAffiliation({}, {}, {})>'.format(self.id, self.name, self.user)
  
new_contents: # This file is part of Indico.
  # Copyright (C) 2002 - 2015 European Organization for Nuclear Research (CERN).
  #
  # Indico is free software; you can redistribute it and/or
  # modify it under the terms of the GNU General Public License as
  # published by the Free Software Foundation; either version 3 of the
  # License, or (at your option) any later version.
  #
  # Indico is distributed in the hope that it will be useful, but
  # WITHOUT ANY WARRANTY; without even the implied warranty of
  # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
  # General Public License for more details.
  #
  # You should have received a copy of the GNU General Public License
  # along with Indico; if not, see <http://www.gnu.org/licenses/>.
  
  from __future__ import unicode_literals
  
  from indico.core.db import db
  from indico.util.string import return_ascii
  
  
  class UserAffiliation(db.Model):
      __tablename__ = 'affiliations'
      __table_args__ = {'schema': 'users'}
  
      #: the unique id of the affiliations
      id = db.Column(
          db.Integer,
          primary_key=True
      )
      #: the id of the associated user
      user_id = db.Column(
          db.Integer,
          db.ForeignKey('users.users.id'),
          nullable=False,
          index=True
      )
  
      #: the affiliation
      name = db.Column(
          db.String,
          nullable=False,
          index=True
      )
  
      #: The associated :class:VCRoom
      user = db.relationship(
          'User',
          lazy=False
      )
  
      @return_ascii
      def __repr__(self):
          return '<UserAffiliation({}, {}, {})>'.format(self.id, self.name, self.user)
  
subject: Fix __repr__ of affiliations