aboutsummaryrefslogtreecommitdiff
path: root/migrations
diff options
context:
space:
mode:
authorGertjan van den Burg <gertjanvandenburg@gmail.com>2019-03-26 13:35:17 +0000
committerGertjan van den Burg <gertjanvandenburg@gmail.com>2019-03-26 13:35:17 +0000
commit5e711f079121e0b9e958261df4aafcf568cb62cf (patch)
tree99a1336b2406411d81a2a05199362f6f1e362e0a /migrations
parentfirst working version of pan + zoom + click (diff)
downloadAnnotateChange-5e711f079121e0b9e958261df4aafcf568cb62cf.tar.gz
AnnotateChange-5e711f079121e0b9e958261df4aafcf568cb62cf.zip
First working version of complete annotation functionality
Diffstat (limited to 'migrations')
-rw-r--r--migrations/versions/878e8193ae4d_change_annotation_structure.py31
1 files changed, 31 insertions, 0 deletions
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 ###