"""Initial migration.

Revision ID: e05ed41f106d
Revises: 
Create Date: 2024-09-28 10:42:37.764580

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'e05ed41f106d'
down_revision = None
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_table('publish')
    op.drop_table('cycleBook')
    op.drop_table('files')
    op.drop_table('sqlite_sequence')
    op.drop_table('books')
    op.drop_table('lastPlay')
    op.drop_table('reader')
    op.drop_table('author')
    op.drop_table('users')
    op.drop_table('ganre')
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('ganre',
    sa.Column('id', sa.INTEGER(), nullable=True),
    sa.Column('name', sa.CHAR(length=150), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('users',
    sa.Column('id', sa.INTEGER(), nullable=True),
    sa.Column('login', sa.VARCHAR(length=50), nullable=True),
    sa.Column('password', sa.VARCHAR(length=50), nullable=True),
    sa.Column('email', sa.VARCHAR(length=50), nullable=True),
    sa.Column('lastbookId', sa.INTEGER(), nullable=True),
    sa.Column('hash', sa.VARCHAR(length=255), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('author',
    sa.Column('id', sa.INTEGER(), nullable=True),
    sa.Column('name', sa.CHAR(length=150), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('reader',
    sa.Column('id', sa.INTEGER(), nullable=True),
    sa.Column('name', sa.CHAR(length=150), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('lastPlay',
    sa.Column('id', sa.INTEGER(), nullable=True),
    sa.Column('userId', sa.INTEGER(), nullable=False),
    sa.Column('bookid', sa.INTEGER(), nullable=False),
    sa.Column('filenum', sa.INTEGER(), nullable=False),
    sa.Column('time', sa.DECIMAL(precision=5, scale=18), nullable=True),
    sa.Column('lastupdate', sa.DATETIME(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('books',
    sa.Column('id', sa.INTEGER(), nullable=True),
    sa.Column('name', sa.CHAR(length=255), nullable=True),
    sa.Column('description', sa.TEXT(), nullable=True),
    sa.Column('authorId', sa.INTEGER(), nullable=False),
    sa.Column('ganreId', sa.INTEGER(), nullable=False),
    sa.Column('year', sa.INTEGER(), nullable=False),
    sa.Column('readerId', sa.INTEGER(), nullable=False),
    sa.Column('source', sa.TEXT(), nullable=True),
    sa.Column('playlist', sa.TEXT(), nullable=True),
    sa.Column('publishId', sa.INTEGER(), nullable=False),
    sa.Column('time', sa.CHAR(length=50), nullable=True),
    sa.Column('img', sa.TEXT(), nullable=True),
    sa.Column('cycleId', sa.INTEGER(), nullable=True),
    sa.Column('orderId', sa.INTEGER(), nullable=True),
    sa.Column('status', sa.INTEGER(), nullable=False),
    sa.Column('torrent', sa.VARCHAR(length=255), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('sqlite_sequence',
    sa.Column('name', sa.NullType(), nullable=True),
    sa.Column('seq', sa.NullType(), nullable=True)
    )
    op.create_table('files',
    sa.Column('id', sa.INTEGER(), nullable=True),
    sa.Column('name', sa.CHAR(length=150), nullable=True),
    sa.Column('source', sa.TEXT(), nullable=False),
    sa.Column('status', sa.INTEGER(), nullable=False),
    sa.Column('bookid', sa.INTEGER(), nullable=False),
    sa.Column('fileNum', sa.INTEGER(), nullable=False),
    sa.Column('numOrder', sa.INTEGER(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('cycleBook',
    sa.Column('id', sa.INTEGER(), nullable=True),
    sa.Column('authorId', sa.INTEGER(), nullable=False),
    sa.Column('name', sa.CHAR(length=150), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('publish',
    sa.Column('id', sa.INTEGER(), nullable=True),
    sa.Column('name', sa.CHAR(length=150), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    # ### end Alembic commands ###