from sqlalchemy import (Column, ForeignKey, SmallInteger)
from sqlalchemy.dialects import mysql as mysql_types

from api.connectors import mysql


class Message(mysql.OrchardZenBaseModel):
    __tablename__ = 'msgs'
    id = Column(SmallInteger, primary_key=True)
    thread_id = Column(SmallInteger, ForeignKey('threads.id'))
    msg_from = Column(mysql_types.TEXT)
    msg_to = Column(mysql_types.TEXT)
    message = Column(mysql_types.TEXT)
    html = Column(mysql_types.TEXT)
    date_created = Column(mysql_types.TIMESTAMP, nullable=False)