"""Initial baseline

Revision ID: b43a39b1cf25
Revises: 
Create Date: 2026-01-21 02:25:55.179218

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

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


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_table('printer_jobs')
    op.drop_table('query_town_ist')
    op.drop_table('taxes_pricing')
    op.drop_table('pricing_service_general')
    op.drop_table('portal_user')
    op.drop_table('delivery_payment')
    with op.batch_alter_table('street_reference', schema=None) as batch_op:
        batch_op.drop_index(batch_op.f('ix_public_street_reference_osm_id'))
        batch_op.drop_index(batch_op.f('ix_public_street_reference_street_name_normalized'))
        batch_op.drop_index(batch_op.f('ix_street_ref_name_town'))
        batch_op.drop_index(batch_op.f('ix_street_ref_town_state'))

    op.drop_table('street_reference')
    with op.batch_alter_table('auth_users', schema=None) as batch_op:
        batch_op.create_unique_constraint(None, ['id'])

    with op.batch_alter_table('auto_delivery', schema=None) as batch_op:
        batch_op.alter_column('estimated_gallons_left',
               existing_type=sa.INTEGER(),
               type_=sa.DECIMAL(precision=6, scale=2),
               existing_nullable=True)
        batch_op.alter_column('estimated_gallons_left_prev_day',
               existing_type=sa.INTEGER(),
               type_=sa.DECIMAL(precision=6, scale=2),
               existing_nullable=True)

    with op.batch_alter_table('customer_customer', schema=None) as batch_op:
        batch_op.create_index(batch_op.f('ix_public_customer_customer_auth_net_profile_id'), ['auth_net_profile_id'], unique=True)
        batch_op.drop_column('verified_at')

    with op.batch_alter_table('service_service', schema=None) as batch_op:
        batch_op.alter_column('when_ordered',
               existing_type=sa.DATE(),
               type_=sa.DATETIME(),
               existing_nullable=True)
        batch_op.alter_column('scheduled_date',
               existing_type=postgresql.DOMAIN('time_stamp', TIMESTAMP()),
               type_=sa.DATETIME(),
               existing_nullable=True,
               existing_server_default=sa.text('CURRENT_TIMESTAMP(2)'))
        batch_op.alter_column('service_cost',
               existing_type=sa.NUMERIC(precision=10, scale=2),
               nullable=False)

    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    with op.batch_alter_table('service_service', schema=None) as batch_op:
        batch_op.alter_column('service_cost',
               existing_type=sa.NUMERIC(precision=10, scale=2),
               nullable=True)
        batch_op.alter_column('scheduled_date',
               existing_type=sa.DATETIME(),
               type_=postgresql.DOMAIN('time_stamp', TIMESTAMP()),
               existing_nullable=True,
               existing_server_default=sa.text('CURRENT_TIMESTAMP(2)'))
        batch_op.alter_column('when_ordered',
               existing_type=sa.DATETIME(),
               type_=sa.DATE(),
               existing_nullable=True)

    with op.batch_alter_table('customer_customer', schema=None) as batch_op:
        batch_op.add_column(sa.Column('verified_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=True))
        batch_op.drop_index(batch_op.f('ix_public_customer_customer_auth_net_profile_id'))

    with op.batch_alter_table('auto_delivery', schema=None) as batch_op:
        batch_op.alter_column('estimated_gallons_left_prev_day',
               existing_type=sa.DECIMAL(precision=6, scale=2),
               type_=sa.INTEGER(),
               existing_nullable=True)
        batch_op.alter_column('estimated_gallons_left',
               existing_type=sa.DECIMAL(precision=6, scale=2),
               type_=sa.INTEGER(),
               existing_nullable=True)

    with op.batch_alter_table('auth_users', schema=None) as batch_op:
        batch_op.drop_constraint(None, type_='unique')

    op.create_table('street_reference',
    sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False),
    sa.Column('street_name', sa.VARCHAR(length=500), autoincrement=False, nullable=False),
    sa.Column('street_name_normalized', sa.VARCHAR(length=500), autoincrement=False, nullable=False),
    sa.Column('street_number_low', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('street_number_high', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('town', sa.VARCHAR(length=140), autoincrement=False, nullable=False),
    sa.Column('town_normalized', sa.VARCHAR(length=140), autoincrement=False, nullable=False),
    sa.Column('state', sa.VARCHAR(length=2), autoincrement=False, nullable=False),
    sa.Column('zip_codes', sa.VARCHAR(length=100), autoincrement=False, nullable=True),
    sa.Column('osm_id', sa.VARCHAR(), autoincrement=False, nullable=True),
    sa.Column('created_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=False),
    sa.PrimaryKeyConstraint('id', name=op.f('street_reference_pkey'))
    )
    with op.batch_alter_table('street_reference', schema=None) as batch_op:
        batch_op.create_index(batch_op.f('ix_street_ref_town_state'), ['town_normalized', 'state'], unique=False)
        batch_op.create_index(batch_op.f('ix_street_ref_name_town'), ['street_name_normalized', 'town_normalized'], unique=False)
        batch_op.create_index(batch_op.f('ix_public_street_reference_street_name_normalized'), ['street_name_normalized'], unique=False)
        batch_op.create_index(batch_op.f('ix_public_street_reference_osm_id'), ['osm_id'], unique=False)

    op.create_table('delivery_payment',
    sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False),
    sa.Column('delivery_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('time_added', postgresql.TIMESTAMP(), autoincrement=False, nullable=True),
    sa.Column('total_amount_oil', sa.NUMERIC(precision=50, scale=2), autoincrement=False, nullable=True),
    sa.Column('total_amount_emergency', sa.NUMERIC(precision=50, scale=2), autoincrement=False, nullable=True),
    sa.Column('total_amount_prime', sa.NUMERIC(precision=50, scale=2), autoincrement=False, nullable=True),
    sa.Column('total_amount_fee', sa.NUMERIC(precision=50, scale=2), autoincrement=False, nullable=True),
    sa.Column('total_amount', sa.NUMERIC(precision=50, scale=2), autoincrement=False, nullable=True),
    sa.PrimaryKeyConstraint('id', name=op.f('delivery_payment_pkey'))
    )
    op.create_table('portal_user',
    sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False),
    sa.Column('username', sa.VARCHAR(length=50), autoincrement=False, nullable=True),
    sa.Column('account_number', sa.VARCHAR(length=32), autoincrement=False, nullable=True),
    sa.Column('house_number', sa.VARCHAR(length=32), autoincrement=False, nullable=True),
    sa.Column('email', sa.VARCHAR(length=350), autoincrement=False, nullable=True),
    sa.Column('password_hash', sa.TEXT(), autoincrement=False, nullable=True),
    sa.Column('member_since', postgresql.TIMESTAMP(timezone=True), server_default=sa.text('now()'), autoincrement=False, nullable=True),
    sa.Column('last_seen', postgresql.TIMESTAMP(timezone=True), server_default=sa.text('now()'), autoincrement=False, nullable=True),
    sa.Column('admin', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('admin_role', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('confirmed', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('active', sa.INTEGER(), server_default=sa.text('1'), autoincrement=False, nullable=True),
    sa.Column('password_reset_expires', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('password_reset_token', sa.TEXT(), autoincrement=False, nullable=True),
    sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('confirmation_token', sa.TEXT(), autoincrement=False, nullable=True),
    sa.Column('confirmation_sent_at', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('confirmed_at', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.PrimaryKeyConstraint('id', name=op.f('portal_user_pkey'))
    )
    op.create_table('pricing_service_general',
    sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False),
    sa.Column('price_service_hour', sa.NUMERIC(precision=50, scale=2), autoincrement=False, nullable=True),
    sa.Column('price_emergency_service_hour', sa.NUMERIC(precision=50, scale=2), autoincrement=False, nullable=True),
    sa.Column('price_emergency_call', sa.NUMERIC(precision=50, scale=2), autoincrement=False, nullable=True),
    sa.Column('price_out_of_oil', sa.NUMERIC(precision=50, scale=2), autoincrement=False, nullable=True),
    sa.Column('price_prime', sa.NUMERIC(precision=50, scale=2), autoincrement=False, nullable=True),
    sa.Column('price_cleaning', sa.NUMERIC(precision=50, scale=2), autoincrement=False, nullable=True),
    sa.Column('date', postgresql.TIMESTAMP(), autoincrement=False, nullable=True),
    sa.PrimaryKeyConstraint('id', name=op.f('pricing_service_general_pkey'))
    )
    op.create_table('taxes_pricing',
    sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False),
    sa.Column('state_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('taxes_oil', sa.NUMERIC(precision=50, scale=2), autoincrement=False, nullable=True),
    sa.Column('taxes_other', sa.NUMERIC(precision=50, scale=2), autoincrement=False, nullable=True),
    sa.PrimaryKeyConstraint('id', name=op.f('taxes_pricing_pkey'))
    )
    op.create_table('query_town_ist',
    sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False),
    sa.Column('value', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('text', sa.VARCHAR(length=240), autoincrement=False, nullable=True)
    )
    op.create_table('printer_jobs',
    sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False),
    sa.Column('delivery_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('date_added', sa.DATE(), autoincrement=False, nullable=True),
    sa.Column('date_completed', sa.DATE(), autoincrement=False, nullable=True),
    sa.Column('employee_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('status', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.PrimaryKeyConstraint('id', name=op.f('printer_jobs_pkey'))
    )
    # ### end Alembic commands ###