view libervia/backend/memory/migration/versions/610345f77e75_add_version_id_to_history.py @ 4242:8acf46ed7f36

frontends: remote control implementation: This is the frontends common part of remote control implementation. It handle the creation of WebRTC session, and management of inputs. For now the reception use freedesktop.org Desktop portal, and works mostly with Wayland based Desktop Environments. rel 436
author Goffi <goffi@goffi.org>
date Sat, 11 May 2024 13:52:43 +0200
parents 23d21daed216
children 0d7bb4df2343
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')