from sqlalchemy import Column, DECIMAL, DateTime, Integer, String, Table
from sqlalchemy.sql.sqltypes import NullType

from sqlalchemy.orm import declarative_base

Base = declarative_base()
metadata = Base.metadata


class LastPlay(Base):
    __tablename__ = 'lastPlay'

    userId = Column(Integer, nullable=False)
    bookid = Column(Integer, nullable=False)
    filenum = Column(Integer, nullable=False)
    id = Column(Integer, primary_key=True)
    time = Column(DECIMAL(5, 18))
    lastupdate = Column(DateTime)


t_sqlite_sequence = Table(
    'sqlite_sequence', metadata,
    Column('name', NullType),
    Column('seq', NullType)
)


class Users(Base):
    __tablename__ = 'users'

    id = Column(Integer, primary_key=True)
    login = Column(String(50))
    password = Column(String(50))
    email = Column(String(50))
    lastbookId = Column(Integer)
    hash = Column(String(255))