from extensions import db

class Group(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(100), nullable=False, unique=True)
    orientation = db.Column(db.String(16), nullable=False, default='Landscape')  # <-- Add this line
    players = db.relationship('Player', secondary='group_player', backref='groups')
    playlist_version = db.Column(db.Integer, default=0)

group_player = db.Table('group_player',
    db.Column('group_id', db.Integer, db.ForeignKey('group.id'), primary_key=True),
    db.Column('player_id', db.Integer, db.ForeignKey('player.id'), primary_key=True)
)