From 5e711f079121e0b9e958261df4aafcf568cb62cf Mon Sep 17 00:00:00 2001 From: Gertjan van den Burg Date: Tue, 26 Mar 2019 13:35:17 +0000 Subject: First working version of complete annotation functionality --- .../878e8193ae4d_change_annotation_structure.py | 31 ++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 migrations/versions/878e8193ae4d_change_annotation_structure.py (limited to 'migrations') diff --git a/migrations/versions/878e8193ae4d_change_annotation_structure.py b/migrations/versions/878e8193ae4d_change_annotation_structure.py new file mode 100644 index 0000000..1b37d5e --- /dev/null +++ b/migrations/versions/878e8193ae4d_change_annotation_structure.py @@ -0,0 +1,31 @@ +"""change annotation structure + +Revision ID: 878e8193ae4d +Revises: 37a7d932fc02 +Create Date: 2019-03-26 12:53:27.069030 + +""" +from alembic import op +import sqlalchemy as sa + + +# revision identifiers, used by Alembic. +revision = '878e8193ae4d' +down_revision = '37a7d932fc02' +branch_labels = None +depends_on = None + + +def upgrade(): + # ### commands auto generated by Alembic - please adjust! ### + with op.batch_alter_table("annotation") as batch_op: + batch_op.drop_column('time_start') + batch_op.drop_column('time_end') + # ### end Alembic commands ### + + +def downgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.add_column('annotation', sa.Column('time_end', sa.INTEGER(), nullable=True)) + op.add_column('annotation', sa.Column('time_start', sa.INTEGER(), nullable=True)) + # ### end Alembic commands ### -- cgit v1.2.3