| 123456789101112131415161718192021222324252627282930313233343536 |
- """add timestamp to commission
- Revision ID: b9072f955a8d
- Revises: f5fc28123cc0
- Create Date: 2026-07-25 09:49:34.418158
- """
- from alembic import op
- import sqlalchemy as sa
- from sqlalchemy.dialects import postgresql
- # revision identifiers, used by Alembic.
- revision = 'b9072f955a8d'
- down_revision = 'f5fc28123cc0'
- branch_labels = None
- depends_on = None
- def upgrade():
- # ### commands auto generated by Alembic - please adjust! ###
- op.add_column('commissions', sa.Column('created_at', sa.DateTime(timezone=True), server_default=sa.text('now()'), nullable=False))
- op.add_column('commissions', sa.Column('updated_at', sa.DateTime(timezone=True), nullable=False))
- op.alter_column('volunteer_groups', 'updated_at',
- existing_type=postgresql.TIMESTAMP(timezone=True),
- nullable=False)
- # ### end Alembic commands ###
- def downgrade():
- # ### commands auto generated by Alembic - please adjust! ###
- op.alter_column('volunteer_groups', 'updated_at',
- existing_type=postgresql.TIMESTAMP(timezone=True),
- nullable=True)
- op.drop_column('commissions', 'updated_at')
- op.drop_column('commissions', 'created_at')
- # ### end Alembic commands ###
|
