"""finalize_authorisation

Revision ID: f5fc28123cc0
Revises: f7a9944a660c
Create Date: 2026-07-25 00:31:02.716514

"""

import sqlalchemy as sa

from alembic import op

# revision identifiers, used by Alembic.
revision = "f5fc28123cc0"
down_revision = "f7a9944a660c"
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column(
        "organizations",
        sa.Column(
            "created_at",
            sa.DateTime(timezone=True),
            server_default=sa.text("now()"),
            nullable=False,
        ),
    )
    op.add_column(
        "organizations", sa.Column("updated_at", sa.DateTime(timezone=True), nullable=True)
    )
    op.add_column(
        "volunteer_groups",
        sa.Column(
            "created_at",
            sa.DateTime(timezone=True),
            server_default=sa.text("now()"),
            nullable=False,
        ),
    )
    op.add_column(
        "volunteer_groups", sa.Column("updated_at", sa.DateTime(timezone=True), nullable=True)
    )
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column("volunteer_groups", "updated_at")
    op.drop_column("volunteer_groups", "created_at")
    op.drop_column("organizations", "updated_at")
    op.drop_column("organizations", "created_at")
    # ### end Alembic commands ###