"""empty message

Revision ID: e2f1b5b1df05
Revises: 98dfb2fa9a89
Create Date: 2023-01-24 13:17:16.116972

"""
import sqlalchemy as sa
from alembic import op
from sqlalchemy.dialects import postgresql

# revision identifiers, used by Alembic.
revision = 'e2f1b5b1df05'
down_revision = '98dfb2fa9a89'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    with op.batch_alter_table('non_signed_artist', schema='dna') as batch_op:
        batch_op.alter_column(
            'created_at',
            existing_type=postgresql.TIMESTAMP(timezone=True),
            type_=sa.DateTime(),
            existing_nullable=False,
            existing_server_default=sa.text('now()')
        )

    with op.batch_alter_table('non_signed_track', schema='dna') as batch_op:
        batch_op.alter_column(
            'created_at',
            existing_type=postgresql.TIMESTAMP(timezone=True),
            type_=sa.DateTime(),
            existing_nullable=False,
            existing_server_default=sa.text('now()')
        )

    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    with op.batch_alter_table('non_signed_track', schema='dna') as batch_op:
        batch_op.alter_column(
            'created_at',
            existing_type=sa.DateTime(),
            type_=postgresql.TIMESTAMP(timezone=True),
            existing_nullable=False,
            existing_server_default=sa.text('now()')
        )

    with op.batch_alter_table('non_signed_artist', schema='dna') as batch_op:
        batch_op.alter_column(
            'created_at',
            existing_type=sa.DateTime(),
            type_=postgresql.TIMESTAMP(timezone=True),
            existing_nullable=False,
            existing_server_default=sa.text('now()')
        )

    # ### end Alembic commands ###