class User(db.Model, AuthUser):
    __tablename__ = 'user'

    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True, nullable=False)
    password = db.Column(db.String(120))
    activatecode = db.Column(db.String)
    alias = db.Column(db.String)
    email = db.Column(db.String)
    active = db.Column(db.Boolean, default=True)
    salt = db.Column(db.String(80))
    role = db.Column(db.String(80))
    created = db.Column(db.DateTime(), default=datetime.datetime.now())
    modified = db.Column(db.DateTime())
    logindate = db.Column(db.DateTime())
    group_id = db.Column(db.Integer, db.ForeignKey('group.id'))

    def __init__(self, username=None, alias=None, email=None):
        self.username = username
        self.email = email
        self.alias = alias

    def update_password(self, password):
        if password:
            self.set_and_encrypt_password(password)