"""change in work groups

Revision ID: faf675cd104b
Revises: 71046ff74214
Create Date: 2025-09-04 16:37:59.880529

"""
from typing import Sequence, Union

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

# revision identifiers, used by Alembic.
revision: str = 'faf675cd104b'
down_revision: Union[str, None] = '71046ff74214'
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    """Upgrade schema."""
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('work_group_web_crawlers', sa.Column('created_at', sa.DateTime(), nullable=True))
    op.add_column('work_group_web_crawlers', sa.Column('updated_at', sa.DateTime(), nullable=True))
    op.add_column('work_group_web_crawlers', sa.Column('deleted_at', sa.DateTime(), nullable=True))
    op.create_unique_constraint('uq_work_group_web_crawler', 'work_group_web_crawlers', ['work_group_id', 'web_crawler_id'])
    op.drop_column('work_group_web_crawlers', 'last_updated')
    op.drop_column('work_group_web_crawlers', 'date_created')
    op.add_column('work_groups', sa.Column('created_at', sa.DateTime(), nullable=True))
    op.add_column('work_groups', sa.Column('updated_at', sa.DateTime(), nullable=True))
    op.add_column('work_groups', sa.Column('deleted_at', sa.DateTime(), nullable=True))
    op.drop_column('work_groups', 'last_updated')
    op.drop_column('work_groups', 'date_created')
    # ### end Alembic commands ###


def downgrade() -> None:
    """Downgrade schema."""
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('work_groups', sa.Column('date_created', postgresql.TIMESTAMP(), autoincrement=False, nullable=True))
    op.add_column('work_groups', sa.Column('last_updated', postgresql.TIMESTAMP(), autoincrement=False, nullable=True))
    op.drop_column('work_groups', 'deleted_at')
    op.drop_column('work_groups', 'updated_at')
    op.drop_column('work_groups', 'created_at')
    op.add_column('work_group_web_crawlers', sa.Column('date_created', postgresql.TIMESTAMP(), autoincrement=False, nullable=True))
    op.add_column('work_group_web_crawlers', sa.Column('last_updated', postgresql.TIMESTAMP(), autoincrement=False, nullable=True))
    op.drop_constraint('uq_work_group_web_crawler', 'work_group_web_crawlers', type_='unique')
    op.drop_column('work_group_web_crawlers', 'deleted_at')
    op.drop_column('work_group_web_crawlers', 'updated_at')
    op.drop_column('work_group_web_crawlers', 'created_at')
    # ### end Alembic commands ###