view libervia/backend/memory/migration/versions/610345f77e75_add_version_id_to_history.py @ 4279:6276242736c3 default tip @

doc (components): Documentation for the new `Conferences` component: fix 445
author Goffi <goffi@goffi.org>
date Fri, 05 Jul 2024 17:18:37 +0200
parents 0d7bb4df2343
children
line wrap: on
line source

"""add "version_id" to History

Revision ID: 610345f77e75
Revises: 2ab01aa1f686
Create Date: 2023-11-20 17:33:53.544032

"""

from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = "610345f77e75"
down_revision = "2ab01aa1f686"
branch_labels = None
depends_on = None


def upgrade():
    with op.batch_alter_table("history", schema=None) as batch_op:
        batch_op.add_column(
            sa.Column(
                "version_id", sa.Integer(), server_default=sa.text("1"), nullable=False
            )
        )


def downgrade():
    with op.batch_alter_table("history", schema=None) as batch_op:
        batch_op.drop_column("version_id")