CREATE TABLE IF NOT EXISTS `file_favorites` (
    `uid` INT ( 11 ) NOT NULL,
    `file_id` VARCHAR ( 6 ) NOT NULL,
    `favorite` INT ( 2 ) SIGNED NOT NULL,
    KEY `uid` (`uid`),
    KEY `file_id` (`file_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

class FileFavorite(Base):
    """ The SQLAlchemy declarative model class for a FileFavorite object. """
    __tablename__ = 'file_favorites'
    __table_args__ = {
        'mysql_engine': 'InnoDB',
        'mysql_charset': 'utf8'
    }
    uid = Column(INTEGER(11), nullable=False)
    file_id = Column(VARCHAR(6), nullable=False)
    favorite = Column(INTEGER(2), nullable=False)