from app import db

class VoicemailMsgs(db.Model):
    __tablename__ = 'voicemail_msgs'

    id = db.Column(db.BIGINT, primary_key=True, autoincrement=True, nullable=False)
    created_epoch = db.Column(db.BIGINT, nullable=True)
    read_epoch = db.Column(db.BIGINT, nullable=True)
    username = db.Column(db.String, nullable=True)
    domain = db.Column(db.String, nullable=True)
    uuid = db.Column(db.String, nullable=True)
    cid_name = db.Column(db.String, nullable=True)
    cid_number = db.Column(db.String, nullable=True)
    in_folder = db.Column(db.String, nullable=True)
    file_path = db.Column(db.String, nullable=True)
    message_len = db.Column(db.BIGINT, nullable=True)
    flags = db.Column(db.String, nullable=True)
    read_flags = db.Column(db.String, nullable=True)
    forwarded_by = db.Column(db.String, nullable=True)
    email_status = db.Column(db.SmallInteger, nullable=False, default=0)
    update_status = db.Column(db.SmallInteger, nullable=False, default=0)

    def save(self):
        db.session.add(self)
        db.session.commit()